PO_ReturnTaxDetail PO Return Tax Detail Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: N/A
SQL Def: Y SysDB: N "MAS_"+%C$+"/PO"+%C$+"/PO_ReturnTaxDetail.M4T"
KPRIMARY: ReturnType+ReturnNo+ScheduleSeqNo+TaxCode+TaxClass
Fld Column Name M/L TUR Description/Notes Class
1 ReturnType. . . . . . . . . . 1 SYN Return Type . . . . . . . . . .
Valid:R Notes: {PO_12$(1,1)}
2 ReturnNo. . . . . . . . . . . 6 SNN Return Number . . . . . . . . .RETURNNO
Mask:000000 Notes: {PO_12$(2,
6)}
3 ScheduleSeqNo . . . . . . . . 6 SNN Schedule Sequence Number. . . .
Mask:000000 FmtType:ZEROFILL
Notes: {PO_12$(8,2)}
4 TaxCode . . . . . . . . . . . 15 SYN Tax Code. . . . . . . . . . . .TAXCODE
Notes: {PO_12$(10,15)}
5 TaxClass. . . . . . . . . . . 2 SYN Tax Class . . . . . . . . . . .TAXCLASS
Notes: {PO_12$(25,2)}
6 PurchasesTaxable. . . . . . . 1 SYN Purchases Taxable . . . . . . .
DfltVal:N Valid:Y,N,T Notes:
{PO_12$(27,1)}
7 TaxablePurchasesAmt . . . . . 13.2 NNN Taxable Purchases Amount. . . .AMOUNT
Mask:###,###,###.00- Notes:
{PO_12[0]}
8 NonTaxablePurchasesAmt. . . . 13.2 NNN Non-Taxable Purchases Amount. .AMOUNT
Mask:###,###,###.00- Notes:
{PO_12[1]}
9 ExemptPurchasesAmt. . . . . . 13.2 NNN Exempt Purchases Amount . . . .AMOUNT
Mask:###,###,###.00- Notes:
{PO_12[2]}
10 UseTaxablePurchasesAmt. . . . 13.2 NNN Use Taxable Purchases Amount. .AMOUNT
Mask:###,###,###.00- Notes:
{PO_12[3]}
11 TaxRate . . . . . . . . . . . 11.6 NNN Tax Rate. . . . . . . . . . . .
Mask:##0.000000 Notes:
{PO_12[5]}
12 NonRecoverablePercent . . . . 7.2 NNN Non-Recoverable Percent . . . .PERCENTAGE
Mask:###.00- Notes:
{PO_12[6]}
13 TaxableTaxAmt . . . . . . . . 12.2 NNN Taxable Tax Amount. . . . . . .MISCAMOUNT
Mask:##,###,###.00-
14 NonRecoverableTaxAmt. . . . . 13.2 NNN Non Recoverable Tax Amount. . .AMOUNT
Mask:###,###,###.00
15 NonRecoverableUseTaxAmt . . . 13.2 NNN Non Recoverable Use Tax Amount.AMOUNT
Mask:###,###,###.00
16 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
17 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y
18 UserUpdatedKey. . . . . . . . 10 SNN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000