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