AP_OpenInvoiceTaxSummary AP Open Invoice Tax Summary Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AP_OpenInvoiceTaxSummary_bus,PO_ReturnRegister_upd SQL Def: Y SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_OpenInvoiceTaxSummary.M4T"
KPRIMARY: APDivisionNo+VendorNo+InvoiceNo+ScheduleSeqNo+TaxCode
Fld Column Name M/L TUR Description/Notes Class
1 APDivisionNo. . . . . . . . . 2 SNY AP Division Number. . . . . . .APDIVISION Mask:00 FmtType:ZEROFILL Notes: {AP_07$(1,2)} 2 VendorNo. . . . . . . . . . . 7 SYY Vendor Number . . . . . . . . .VENDORNO FmtType:MASTERNUM ChngTag:Rep lace1/APDivisionNo$ Notes: {AP_07$(3,7)} 3 InvoiceNo . . . . . . . . . . 10 SNY AP Invoice Number . . . . . . .APINVOICE Notes: {AP_07$(10,10)} 4 ScheduleSeqNo . . . . . . . . 6 SNY Schedule Sequence Number. . . . Mask:000000 FmtType:ZEROFILL Notes: {AP_07$(20,2)} 5 TaxCode . . . . . . . . . . . 15 SYN Tax Code. . . . . . . . . . . .TAXCODE Notes: {AP_07$(22,15)} 6 ExemptionNo . . . . . . . . . 20 SNN Exemption Number. . . . . . . . Notes: {AP_07$(37,20)} 7 TaxablePurchasesAmt . . . . . 13.2 NNN Taxable Purchases Amount. . . .AMOUNT Mask:###,###,###.00- ChngTag:Sum Notes: {AP_07[0]} 8 TaxableFreightAmt . . . . . . 13.2 NNN Taxable Freight Amount. . . . .AMOUNT Mask:###,###,###.00- ChngTag:Sum Notes: {AP_07[1]} 9 TaxableTaxAmt . . . . . . . . 13.2 NNN Taxable Tax Amount. . . . . . .AMOUNT Mask:###,###,###.00- ChngTag:Sum Notes: {AP_07[2]} 10 NonTaxablePurchasesAmt. . . . 13.2 NNN Non-Taxable Purchases Amount. .AMOUNT Mask:###,###,###.00- ChngTag:Sum Notes: {AP_07[3]} 11 NonTaxableFreightAmt. . . . . 13.2 NNN Non-Taxable Freight Amount. . .AMOUNT Mask:###,###,###.00- ChngTag:Sum Notes: {AP_07[4]} 12 ExemptPurchasesAmt. . . . . . 13.2 NNN Exempt Purchases Amount . . . .AMOUNT Mask:###,###,###.00- ChngTag:Sum Notes: {AP_07[5]} 13 UseTaxAmt . . . . . . . . . . 13.2 NNN Use Tax Amount. . . . . . . . .AMOUNT Mask:###,###,###.00- ChngTag:Sum Notes: {AP_07[6]} 14 NonRecoverableAmt . . . . . . 13.2 NNN Non-Recoverable Amount. . . . .AMOUNT Mask:##,###,###.00- ChngTag:Sum Notes: {AP_07[7]} 15 TaxAmt. . . . . . . . . . . . 13.2 NNN Tax Amount. . . . . . . . . . .AMOUNT Mask:###,###,###.00- ChngTag:Sum Notes: {AP_07[8]} 16 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE Read Only:Y ChngTag:Max Notes: YYYYMMDD 17 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . . Read Only:Y ChngTag:CopyMax/D ateUpdated$ 18 UserUpdatedKey. . . . . . . . 10 SNN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000 ChngTag:CopyMax/DateUpdated$