     AP_InvoiceHistoryWrk                  AP Invoice History Work         Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: AP_InvoiceHistoryReport_rpt,AP_InvoiceHistoryListInv_rpt
     SQL Def: Y  SysDB: N                           "MAS_"+%C$+"/AP"+%C$+"/AP_InvoiceHistoryWrk"+%S$+".M4T"

     KPRIMARY: SortField

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  SortField . . . . . . . . . .   127 SNN  Sort Field. . . . . . . . . . .
       2  GroupField. . . . . . . . . .    30 SNN  Group Field . . . . . . . . . .
       3  InvoiceNo . . . . . . . . . .    10 SNN  AP Invoice Number . . . . . . .
       4  HeaderSeqNo . . . . . . . . .     6 SNN  Header Sequence Number. . . . .
       5  DetailSeqNo . . . . . . . . .     6 SNN  Detail Sequence Number. . . . .
       6  ModuleCode. . . . . . . . . .     3 SNN  Module Code . . . . . . . . . .
       7  InvoiceType . . . . . . . . .     2 SNN  Invoice Type. . . . . . . . . .
       8  APDivisionNo. . . . . . . . .     2 SNN  AP Division Number. . . . . . .
       9  VendorNo. . . . . . . . . . .     7 SNN  Vendor Number . . . . . . . . .
      10  VendorName. . . . . . . . . .    30 SNN  Vendor Name . . . . . . . . . .
      11  InvoiceDate . . . . . . . . .     8 SNN  Invoice Date. . . . . . . . . .DATE
      12  TermsCode . . . . . . . . . .     2 SNN  Terms Code. . . . . . . . . . .
      13  TermsCodeDesc . . . . . . . .    30 SNN  Terms Code Description. . . . .
      14  Comment . . . . . . . . . . .    40 SNN  Comment . . . . . . . . . . . .
      15  TaxSchedule . . . . . . . . .     9 SNN  Tax Schedule. . . . . . . . . .
      16  TaxClass. . . . . . . . . . .     2 SNN  Tax Class . . . . . . . . . . .
      17  UseTax. . . . . . . . . . . .     2 SNN  Use Tax . . . . . . . . . . . .
      18  PurchaseOrderNo . . . . . . .     7 SNN  Purchase Order Number . . . . .
      19  PurchaseName. . . . . . . . .    30 SNN  Purchase Name . . . . . . . . .
      20  PurchaseAddress1. . . . . . .    30 SNN  Purchase Address 1. . . . . . .
      21  PurchaseAddress2. . . . . . .    30 SNN  Purchase Address 2. . . . . . .
      22  PurchaseAddress3. . . . . . .    30 SNN  Purchase Address 3. . . . . . .
      23  PurchaseCity. . . . . . . . .    20 SNN  Purchase City . . . . . . . . .
      24  PurchaseState . . . . . . . .     2 SNN  Purchase State. . . . . . . . .
      25  PurchaseZipCode . . . . . . .    10 SNN  PurchaseZipCode . . . . . . . .
      26  PurchaseCountryCode . . . . .     3 SNN  Purchase Country Code . . . . .
      27  PurchaseCountryCodeName . . .    30 SNN  Purchase Country Code Name. . .
      28  ShipToName. . . . . . . . . .    30 SNN  Ship To Name. . . . . . . . . .
      29  ShipToAddress1. . . . . . . .    30 SNN  Ship To Address 1 . . . . . . .
      30  ShipToAddress2. . . . . . . .    30 SNN  Ship To Address 2 . . . . . . .
      31  ShipToAddress3. . . . . . . .    30 SNN  Ship To Address 3 . . . . . . .
      32  ShipToCity. . . . . . . . . .    20 SNN  Ship To City. . . . . . . . . .
      33  ShipToState . . . . . . . . .     3 SNN  Ship To State . . . . . . . . .
      34  ShipToZipCode . . . . . . . .    10 SNN  Ship To Zip Code. . . . . . . .
      35  ShipToCountryCode . . . . . .     3 SNN  Ship To Country Code. . . . . .
      36  ShipToCountryName . . . . . .    30 SNN  Ship To Country Name. . . . . .
      37  ShipVia . . . . . . . . . . .    15 SNN  Ship Via. . . . . . . . . . . .
      38  ConfirmTo . . . . . . . . . .    30 SNN  Confirm To. . . . . . . . . . .
      39  JobNo . . . . . . . . . . . .     7 SNN  Job Number. . . . . . . . . . .
      40  CostCode. . . . . . . . . . .     9 SNN  Cost Code . . . . . . . . . . .
      41  CostCodeFormatted . . . . . .    11 SNN  Cost Code Formatted . . . . . .
      42  CostType. . . . . . . . . . .     1 SNN  Cost Type . . . . . . . . . . .
      43  CommentText . . . . . . . . .  2048 SNN  Comment Text. . . . . . . . . .
      44  TransferAPDivisionNo. . . . .     2 SNN  Transfer AP Division Number . .
      45  TransferVendorNo. . . . . . .     7 SNN  Transfer Vendor Number. . . . .
      46  TransferVendorName. . . . . .    30 SNN  Transfer Vendor Name. . . . . .
      47  TransferInvoiceNo . . . . . .    10 SNN  Transfer Invoice Number . . . .
      48  ItemCode. . . . . . . . . . .    30 SNN  Item Code . . . . . . . . . . .
      49  ItemCodeDesc. . . . . . . . .    30 SNN  Item Code Description . . . . .
      50  ItemType. . . . . . . . . . .     1 SNN  Item Type . . . . . . . . . . .
      51  AccountKey. . . . . . . . . .     9 SNN  Account Key . . . . . . . . . .
      52  Account . . . . . . . . . . .    41 SNN  Fully Formatted Account . . . .
      53  AccountDesc . . . . . . . . .    50 SNN  Account Description . . . . . .
      54  UseTaxDetail. . . . . . . . .     1 SNN  Use Tax Detail. . . . . . . . .
      55  WarehouseCode . . . . . . . .     3 SNN  Warehouse Code. . . . . . . . .
      56  UnitOfMeasure . . . . . . . .     4 SNN  Unit Of Measure . . . . . . . .
      57  TaxClassDetail. . . . . . . .     2 SNN  Tax Class Detail. . . . . . . .
      58  ProductLine . . . . . . . . .     4 SNN  Product Line. . . . . . . . . .
      59  ProductLineDesc . . . . . . .    25 SNN  Product Line Description. . . .
      60  TaxDetailFormatted. . . . . .   460 SNN  Tax Detail Formatted. . . . . .
      61  InvoiceAmt. . . . . . . . . . 13.2  NNN  Invoice Amount. . . . . . . . .
      62  NetInvoiceAmt . . . . . . . . 13.2  NNN  Net Invoice Amount. . . . . . .
      63  DiscountAmt . . . . . . . . . 13.2  NNN  Discount Amount . . . . . . . .
      64  RetentionAmt. . . . . . . . . 13.2  NNN  Retention Amount. . . . . . . .
      65  PrepaymentAmt . . . . . . . . 13.2  NNN  Prepayment Amount . . . . . . .
      66  TaxableAmt. . . . . . . . . . 13.2  NNN  Taxable Amount. . . . . . . . .
      67  NonTaxableAmt . . . . . . . . 13.2  NNN  Non Taxable Amount. . . . . . .
      68  FreightAmt. . . . . . . . . . 13.2  NNN  Freight Amount. . . . . . . . .
      69  TaxAmt. . . . . . . . . . . . 13.2  NNN  Tax Amount. . . . . . . . . . .
      70  UseTaxAmt . . . . . . . . . . 13.2  NNN  Use Tax Amount. . . . . . . . .
      71  TaxableMiscChargeAmt. . . . . 13.2  NNN  Taxable Miscellaneous Charge Am
      72  NonTaxableMiscChargeAmt . . . 13.2  NNN  Non Taxable Miscellaneous Charg
      73  RetentionAmtDetail. . . . . . 13.2  NNN  Retention Amount Detail . . . .
      74  QuantityOrdered . . . . . . . 16.6  NNN  Quantity Ordered. . . . . . . .
      75  QuantityReceived. . . . . . . 16.6  NNN  Quantity Received . . . . . . .
      76  QuantityInvoiced. . . . . . . 16.6  NNN  Quantity Invoiced . . . . . . .
      77  UnitCost. . . . . . . . . . . 16.6  NNN  Unit Cost . . . . . . . . . . .
      78  ExtensionAmt. . . . . . . . . 13.2  NNN  Extension Amount. . . . . . . .