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