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