AR_SalesTax AR Sales Tax Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AR_SalesTax_bus,AP_ARClearingRegister_upd SQL Def: N SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_SalesTax.M4T"
KPRIMARY: TaxCode+TransactionDate+InvoiceNo+InvoiceType KPRMTCTRANSDATE: PrimaryTaxCode+TaxCode+TransactionDate+InvoiceNo+InvoiceType KINVOICEDATE: TaxCode+InvoiceNo+InvoiceType KPRMTCINVDATE: PrimaryTaxCode+TaxCode+InvoiceNo+InvoiceType KTRANSACTIONDATE: TransactionDate+TaxCode+InvoiceNo+InvoiceType
Fld Column Name M/L TUR Description/Notes Class
1 TaxCode . . . . . . . . . . . 15 SYY Tax Code. . . . . . . . . . . .TAXCODE Notes: {ARV$(1,15)} 2 TransactionDate . . . . . . . 8 SNN Transaction Date. . . . . . . .DATE Notes: {ARV$(16,6)} 3 InvoiceNo . . . . . . . . . . 7 SNN Invoice Number. . . . . . . . .INVOICE FmtType:MASTERNUM Notes: {ARV$(22,7)} 4 InvoiceType . . . . . . . . . 2 SYN Invoice Type. . . . . . . . . . Notes: {ARV$(29,2)} 5 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .ARDIVISION Mask:00 FmtType:ZEROFILL Notes: {ARV$(31,2)} 6 CustomerNo. . . . . . . . . . 20 SYN Customer Number . . . . . . . .CUSTOMERNO FmtType:MASTERNUMC ChngTag:Re place1/ARDivisionNo$ Notes: {ARV$(33,7)} 7 CustomerName. . . . . . . . . 30 SNN Customer Name . . . . . . . . .NAME Notes: {ARV$(40,30)} 8 ModuleCode. . . . . . . . . . 3 SYN Module Code . . . . . . . . . .MODULECODE Valid:AR,JC,SO Notes: (AR, SO, JC) {ARV$(70,2)} 9 SourceJournalNo . . . . . . . 6 SNN Source Journal Number . . . . . Mask:000000 FmtType:ZEROFILL Notes: {ARV$(72,4)} 10 PrimaryTaxCode. . . . . . . . 15 SYN Primary Tax Code. . . . . . . .TAXCODE Notes: {ARV$(76,15)} 11 ExemptionNo . . . . . . . . . 20 SNN Exemption Number. . . . . . . . Notes: {ARV$(91,20)} 12 Override. . . . . . . . . . . 1 SYN Override. . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: {ARV$(111,1)} 13 TaxableSalesAmt . . . . . . . 13.2 NNN Taxable Sales Amount. . . . . .AMOUNT Mask:###,###,###.00 Notes: {ARV[0]} 14 NonTaxableSalesAmt. . . . . . 13.2 NNN NonTaxable Sales Amount . . . .AMOUNT Mask:###,###,###.00 Notes: {ARV[1]} 15 TaxableFreightAmt . . . . . . 12.2 NNN Taxable Freight Amount. . . . .MISCAMOUNT Mask:##,###,###.00- Notes: {ARV[2]} 16 NonTaxableFreightAmt. . . . . 12.2 NNN NonTaxable Freight Amount . . .MISCAMOUNT Mask:##,###,###.00- Notes: {ARV[3]} 17 SalesTaxInvoiced. . . . . . . 12.2 NNN Sales Tax Invoiced. . . . . . .MISCAMOUNT Mask:##,###,###.00- Notes: {ARV[4]} 18 SalesTaxCollected . . . . . . 12.2 NNN Sales Tax Collected . . . . . .MISCAMOUNT Mask:##,###,###.00- Notes: {ARV[5]} 19 TaxableTaxAmt . . . . . . . . 12.2 NNN Taxable Tax Amount. . . . . . .MISCAMOUNT Mask:##,###,###.00- Notes: {ARV[6]} 20 ExemptSalesAmt. . . . . . . . 13.2 NNN Exempt Sales Amount . . . . . .AMOUNT Mask:###,###,###.00 Notes: {ARV[7]} 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 SYN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL