AP_SalesTax AP Sales Tax Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AP_SalesTax_bus,PO_ReturnRegister_upd SQL Def: Y SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_SalesTax.M4T"
KPRIMARY: TaxCode+TransactionDate+InvoiceNo KTRANSACTIONDATE: TransactionDate+TaxCode+InvoiceNo
Fld Column Name M/L TUR Description/Notes Class
1 TaxCode . . . . . . . . . . . 15 SYY Tax Code. . . . . . . . . . . .TAXCODE Notes: {APV(1,15)} 2 TransactionDate . . . . . . . 8 SNY Transaction Date. . . . . . . .DATE Notes: {APV(16,6)} 3 InvoiceNo . . . . . . . . . . 10 SYY AP Invoice Number . . . . . . .APINVOICE Notes: {APV(22,10)} 4 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . .APDIVISION Mask:00 FmtType:ZEROFILL Notes: {APV(32,2)} 5 VendorNo. . . . . . . . . . . 7 SYN Vendor Number . . . . . . . . .VENDORNO FmtType:MASTERNUM ChngTag:Rep lace1/APDivisionNo$ Notes: {APV(34,7)} 6 VendorName. . . . . . . . . . 30 SNN Vendor Name . . . . . . . . . .NAME Notes: {APV(41,30)} 7 ModuleCode. . . . . . . . . . 3 SYN Module Code . . . . . . . . . .MODULECODE Valid:AP,PO Notes: {APV(71, 2)} 8 SourceJournalNo . . . . . . . 6 SYN Source Journal Number . . . . . Mask:000000 Notes: {APV(73, 4)} 9 PrimaryTaxCode. . . . . . . . 15 SYN Primary Tax Code. . . . . . . .TAXCODE Notes: {APV(77,15)} 10 ExemptionNo . . . . . . . . . 20 SNN Exemption Number. . . . . . . . Notes: {APV(92,20)} 11 Override. . . . . . . . . . . 1 SYN Override. . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {APV(112,1)} 12 TaxablePurchasesAmt . . . . . 13.2 NNN Taxable Purchases Amount. . . .AMOUNT Mask:###,###,###.00 Notes: {APV[0]} 13 NonTaxablePurchasesAmt. . . . 13.2 NNN Non Taxable Purchases Amount. .AMOUNT Mask:###,###,###.00 Notes: {APV[1]} 14 TaxableFreightAmt . . . . . . 13.2 NNN Taxable Freight Amount. . . . .AMOUNT Mask:###,###,###.00 Notes: {APV[2]} 15 NonTaxableFreightAmt. . . . . 13.2 NNN Non-Taxable Freight Amount. . .AMOUNT Mask:###,###,###.00 Notes: {APV[3]} 16 TaxAmt. . . . . . . . . . . . 13.2 NNN Tax Amount. . . . . . . . . . .AMOUNT Mask:###,###,###.00 Notes: {APV[4]} 17 UseTaxAmt . . . . . . . . . . 13.2 NNN Use Tax Amount. . . . . . . . .AMOUNT Mask:###,###,###.00 Notes: {APV[5]} 18 TaxableTaxAmt . . . . . . . . 13.2 NNN Taxable Tax Amount. . . . . . .AMOUNT Mask:###,###,###.00 Notes: {APV[6]} 19 ExemptPurchasesAmt. . . . . . 13.2 NNN Exempt Purchases Amount . . . .AMOUNT Mask:###,###,###.00 Notes: {APV[7]} 20 NonRecoverableAmt . . . . . . 13.2 NNN Non-Recoverable Amount. . . . .AMOUNT Mask:###,###,###.00 Notes: {APV[8]} 21 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 22 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . . Read Only:Y 23 UserUpdatedKey. . . . . . . . 10 SNN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000