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