AP_InvoiceTaxDetail AP Invoice Tax Detail Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AP_InvoiceTaxDetail_bus SQL Def: Y SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_InvoiceTaxDetail.M4T"
KPRIMARY: APDivisionNo+VendorNo+InvoiceNo+ScheduleSeqNo+TaxCode+TaxClass
Fld Column Name M/L TUR Description/Notes Class
1 APDivisionNo. . . . . . . . . 2 SNY AP Division Number. . . . . . .APDIVISION Mask:00 FmtType:ZEROFILL Notes: {AP_01$(1,2)} 2 VendorNo. . . . . . . . . . . 7 SYY Vendor Number . . . . . . . . .VENDORNO FmtType:MASTERNUM Notes: {AP_01$(3,7)} 3 InvoiceNo . . . . . . . . . . 10 SNY AP Invoice Number . . . . . . .APINVOICE Notes: {AP_01$(10,10)} 4 ScheduleSeqNo . . . . . . . . 6 SNY Schedule Sequence Number. . . . Mask:000000 FmtType:ZEROFILL Notes: {AP_01$(20,2)} 5 TaxCode . . . . . . . . . . . 15 SYY Tax Code. . . . . . . . . . . .TAXCODE Notes: {AP_01$(22,15)} 6 TaxClass. . . . . . . . . . . 2 SYY Tax Class . . . . . . . . . . .TAXCLASS Notes: {AP_01$(37,2)} 7 PurchasesTaxable. . . . . . . 1 SYN Purchases Taxable . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {AP_01$(39,1)} 8 TaxablePurchasesAmt . . . . . 13.2 NNN Taxable Purchases Amount. . . .AMOUNT Mask:###,###,###.00- Notes: {AP_01[0]} 9 NonTaxablePurchasesAmt. . . . 13.2 NNN Non-Taxable Purchases Amount. .AMOUNT Mask:###,###,###.00- Notes: {AP_01[1]} 10 ExemptPurchasesAmt. . . . . . 13.2 NNN Exempt Purchases Amount . . . .AMOUNT Mask:###,###,###.00- Notes: {AP_01[2]} 11 UseTaxablePurchasesAmt. . . . 13.2 NNN Use Taxable Purchases Amount. .AMOUNT Mask:###,###,###.00- Notes: {AP_01[3]} 12 TaxRate . . . . . . . . . . . 11.6 NNN Tax Rate. . . . . . . . . . . . Mask:##0.000000 Notes: {AP_01[5]} 13 NonRecoverablePercent . . . . 8.3 NNN Non-Recoverable Percent . . . . Mask:###.000- Notes: {AP_01[6]}