AP_InvoiceHistoryTaxSummary AP Invoice History Tax Summary Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: AP_InvoiceHistoryTaxSummary_bus,PO_ReturnRegister_upd
SQL Def: Y SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_InvoiceHistoryTaxSummary.M4T"
KPRIMARY: InvoiceNo+HeaderSeqNo+ScheduleSeqNo+TaxCode
Fld Column Name M/L TUR Description/Notes Class
1 InvoiceNo . . . . . . . . . . 10 SNY AP Invoice Number . . . . . . .APINVOICE
Notes: {AP_08$(1,10)}
2 HeaderSeqNo . . . . . . . . . 6 SNY Header Sequence Number. . . . .
Mask:000000 FmtType:ZEROFILL
Notes: {AP_08$(11,3)}
3 ScheduleSeqNo . . . . . . . . 6 SNY Schedule Sequence Number. . . .
Mask:000000 FmtType:ZEROFILL
Notes: {AP_08$(14,2)}
4 TaxCode . . . . . . . . . . . 15 SYY Tax Code. . . . . . . . . . . .TAXCODE
Notes: {AP_08$(16,15)}
5 ExemptionNo . . . . . . . . . 20 SNN Exemption Number. . . . . . . .
Notes: {AP_08$(31,20)}
6 TaxablePurchasesAmt . . . . . 13.2 NNN Taxable Purchases Amount. . . .AMOUNT
Mask:###,###,###.00- Notes:
{AP_08[0]}
7 NonTaxablePurchasesAmt. . . . 13.2 NNN Non-Taxable Purchases Amount. .AMOUNT
Mask:###,###,###.00- Notes:
{AP_08[3]}
8 TaxableFreightAmt . . . . . . 13.2 NNN Taxable Freight Amount. . . . .AMOUNT
Mask:###,###,###.00- Notes:
{AP_08[1]}
9 TaxableTaxAmt . . . . . . . . 13.2 NNN Taxable Tax Amount. . . . . . .AMOUNT
Mask:###,###,###.00- Notes:
{AP_08[2]}
10 ExemptPurchasesAmt. . . . . . 13.2 NNN Exempt Purchases Amount . . . .AMOUNT
Mask:###,###,###.00- Notes:
{AP_08[5]}
11 TaxAmt. . . . . . . . . . . . 13.2 NNN Tax Amount. . . . . . . . . . .AMOUNT
Mask:###,###,###.00- Notes:
{AP_08[8]}
12 NonTaxableFreightAmt. . . . . 13.2 NNN Non-Taxable Freight Amount. . .AMOUNT
Mask:###,###,###.00- Notes:
{AP_08[4]}
13 UseTaxAmt . . . . . . . . . . 13.2 NNN Use Tax Amount. . . . . . . . .AMOUNT
Mask:###,###,###.00- Notes:
{AP_08[6]}
14 NonRecoverableAmt . . . . . . 13.2 NNN Non-Recoverable Amount. . . . .AMOUNT
Mask:##,###,###.00- Notes:
{AP_08[7]}