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. . . . . . . .