AP_TaxSummaryWork AP Tax Summary Work Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: AP_ManualCheckRegister_upd,AP_InvoiceRegister_upd,PO_ReceiptRegister_upd,PO_ReturnRegister_upd
SQL Def: Y SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_TaxSummaryWork.M4T"
KPRIMARY: SourceJournal+TransactionDate+APDivisionNo+VendorNo+InvoiceNo+ScheduleSeqNo+TaxCode
KSOURCEJOURNALNO: SourceJournalNo+SourceJournal+TransactionDate+APDivisionNo+VendorNo+InvoiceNo+Schedul
eSeqNo+TaxCode
Fld Column Name M/L TUR Description/Notes Class
1 SourceJournal . . . . . . . . 2 SYY Source Journal. . . . . . . . .SOURCEJOURNAL
2 TransactionDate . . . . . . . 8 SNY Transaction Date. . . . . . . .DATE
3 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . .APDIVISION
Mask:00
4 VendorNo. . . . . . . . . . . 7 SYN Vendor Number . . . . . . . . .VENDORNO
5 InvoiceNo . . . . . . . . . . 10 SYY AP Invoice Number . . . . . . .APINVOICE
6 ScheduleSeqNo . . . . . . . . 6 SNY Schedule Sequence Number. . . .
7 TaxCode . . . . . . . . . . . 15 SYY Tax Code. . . . . . . . . . . .TAXCODE
8 SourceJournalNo . . . . . . . 6 SNN Source Journal Number . . . . .
9 VendorName. . . . . . . . . . 30 SNN Vendor Name . . . . . . . . . .NAME
10 ModuleCode. . . . . . . . . . 3 SYN Module Code . . . . . . . . . .MODULECODE
Valid:AP,PO
11 PrimaryTaxCode. . . . . . . . 15 SYN Primary Tax Code. . . . . . . .TAXCODE
12 ExemptionNo . . . . . . . . . 20 SNN Exemption Number. . . . . . . .
13 Override. . . . . . . . . . . 1 SYN Override. . . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N
14 ExpenseToVendorItem . . . . . 1 SYN Expense To Vendor/Item. . . . .YESNO
DfltVal:N Valid:Y,N
15 TaxablePurchasesAmt . . . . . 13.2 NNN Taxable Purchases Amount. . . .AMOUNT
Mask:###,###,###.00
16 NonTaxablePurchasesAmt. . . . 13.2 NNN Non Taxable Purchases Amount. .AMOUNT
Mask:###,###,###.00
17 TaxableFreightAmt . . . . . . 13.2 NNN Taxable Freight Amount. . . . .AMOUNT
Mask:###,###,###.00
18 NonTaxableFreightAmt. . . . . 13.2 NNN Non-Taxable Freight Amount. . .AMOUNT
Mask:###,###,###.00
19 TaxAmt. . . . . . . . . . . . 13.2 NNN Tax Amount. . . . . . . . . . .AMOUNT
Mask:###,###,###.00
20 UseTaxAmt . . . . . . . . . . 13.2 NNN Use Tax Amount. . . . . . . . .AMOUNT
Mask:###,###,###.00
21 TaxableTaxAmt . . . . . . . . 13.2 NNN Taxable Tax Amount. . . . . . .AMOUNT
Mask:###,###,###.00
22 ExemptPurchasesAmt. . . . . . 13.2 NNN Exempt Purchases Amount . . . .AMOUNT
Mask:###,###,###.00
23 NonRecoverableAmt . . . . . . 13.2 NNN Non-Recoverable Amount. . . . .AMOUNT
Mask:###,###,###.00