     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