     AP_InvoiceHistoryHeader                AP Invoice History Header      Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: AP_InvoiceHistory_bus,AP_InvoiceRegister_upd,AP_ManualCheckRegister_upd,AP_ARClearingRegister_
     SQL Def: Y  SysDB: N                               "MAS_"+%C$+"/AP"+%C$+"/AP_InvoiceHistoryHeader.M4T"

     KPRIMARY: InvoiceNo+HeaderSeqNo
     KVENDOR: APDivisionNo+VendorNo+InvoiceNo+HeaderSeqNo

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  InvoiceNo . . . . . . . . . .    10 SNY  AP Invoice Number . . . . . . .APINVOICE
                                                    Notes: {AP_12$(1,10)}
       2  HeaderSeqNo . . . . . . . . .     6 SNY  Header Sequence Number. . . . .
                                                    Mask:000000 FmtType:ZEROFILL
                                                    Notes: {AP_12$(11,3)}
       3  ModuleCode. . . . . . . . . .     3 SNN  Module Code . . . . . . . . . .MODULECODE
                                                    Notes: {AP_12$(14,2)}
       4  InvoiceType . . . . . . . . .     1 SYN  Invoice Type. . . . . . . . . .
                                                    Notes: {AP_12$(16,1)}
       5  APDivisionNo. . . . . . . . .     2 SNN  AP Division Number. . . . . . .APDIVISION
                                                    Mask:00 FmtType:ZEROFILL
                                                    Notes: {AP_12$(17,2)}
       6  VendorNo. . . . . . . . . . .     7 SYN  Vendor Number . . . . . . . . .VENDORNO
                                                    FmtType:MASTERNUM ChngTag:Rep
                                                    lace1/APDivisionNo$ Notes:
                                                    {AP_12$(19,7)}
       7  InvoiceDate . . . . . . . . .     8 SNN  Invoice Date. . . . . . . . . .DATE
                                                    Notes: {AP_12$(26,6)}
       8  InvoiceDueDate. . . . . . . .     8 SNN  Invoice Due Date. . . . . . . .DATE
                                                    Notes: {AP_12$(32,6)}
       9  InvoiceDiscountDate . . . . .     8 SNN  Invoice Discount Date . . . . .DATE
                                                    Notes: {AP_12$(38,6)}
      10  TransactionDate . . . . . . .     8 SNN  Transaction Date. . . . . . . .DATE
                                                    Notes: {AP_12$(116,6)}
      11  TermsCode . . . . . . . . . .     2 SYN  AP Terms Code . . . . . . . . .APTERMS
                                                    Notes: {AP_12$(44,2)}
      12  HoldPayment . . . . . . . . .     1 SYN  Hold Payment. . . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N Notes:
                                                    {AP_12$(46,1)}
      13  Comment . . . . . . . . . . .    40 SNN  Comment . . . . . . . . . . . .
                                                    Notes: {AP_12$(47,30)}
      14  PrepaidApplyToInvoiceNo . . .    10 SNN  Pre-Paid Apply To Invoice NumbeAPINVOICE
                                                    Notes: {AP_12$(77,10)}
      15  PrepaidPaymentDate. . . . . .     8 SNN  Pre-Paid Payment Invoice Date .DATE
                                                    Notes: {AP_12$(87,6)}
      16  PrepaidCheckNo. . . . . . . .    10 SNN  Pre-Paid Check Number . . . . .APCHECKNO
                                                    Notes: {AP_12$(93,6)}
      17  SourceJournal . . . . . . . .     2 SYN  Source Journal. . . . . . . . .SOURCEJOURNAL
                                                    Notes: {AP_12$(99,2)}
      18  SourceJournalNo . . . . . . .     6 SNN  Source Journal Number . . . . .
                                                    Mask:000000 FmtType:ZEROFILL
                                                    Notes: {AP_12$(101,4)}
      19  Form1099. . . . . . . . . . .     1 SNN  1099 Form . . . . . . . . . . .
                                                    Notes: {AP_12$(105,1)}
      20  Box1099 . . . . . . . . . . .     3 SNN  1099 Box. . . . . . . . . . . .
                                                    Notes: {AP_12$(106,2)}
      21  SeparateCheck . . . . . . . .     1 SYN  Separate Check. . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N Notes:
                                                    {AP_12$(108,1)}
      22  JobNo . . . . . . . . . . . .     7 SYN  Job Number. . . . . . . . . . .JOBNO
                                                    FmtType:CHARNUM Notes:
                                                    {AP_12$(109,7)}
      23  VendorName. . . . . . . . . .    30 SNN  Vendor Name . . . . . . . . . .NAME
                                                    Notes: If AP_12$(14,2)="AP"
                                                    {AP_12$(122,30)}, If
                                                    AP_12$(14,2)="PO" {AP_12$(141
                                                    ,30)}
      24  TaxSchedule . . . . . . . . .     9 SYN  Tax Schedule. . . . . . . . . .TAXSCHEDULE
                                                    Notes: {AP_12$(599,9)}
      25  TaxClass. . . . . . . . . . .     2 SYN  Tax Class . . . . . . . . . . .TAXCLASS
                                                    Notes: {AP_12$(608,2)}
      26  UseTax. . . . . . . . . . . .     1 SYN  Use Tax . . . . . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N Notes:
                                                    {AP_12$(610,1)}
      27  PurchaseOrderNo . . . . . . .     7 SNN  Purchase Order Number . . . . .PURCHASEORDERNO
                                                    Notes: {AP_12$(134,7)}
      28  ReceiptNo . . . . . . . . . .     6 SYN  Receipt Number. . . . . . . . .RECEIPTNO
                                                    Notes: {AP_12$(122,6)}
      29  ReceiptDate . . . . . . . . .     8 SNN  Receipt Date. . . . . . . . . .DATE
                                                    Notes: {AP_12$(128,6)}
      30  PurchaseAddressCode . . . . .     4 SYN  Purchase Address Code . . . . .PURCHASEADDRCODE
                                                    Notes: {AP_12$(495,4)}
      31  PurchaseName. . . . . . . . .    30 SNN  Purchase Name . . . . . . . . .NAME
                                                    Notes: {AP_12$(141,30)}
      32  PurchaseAddress1. . . . . . .    30 SNN  Purchase Address 1. . . . . . .ADDRESSLINE
                                                    Notes: {AP_12$(171,30)}
      33  PurchaseAddress2. . . . . . .    30 SNN  Purchase Address 2. . . . . . .ADDRESSLINE
                                                    Notes: {AP_12$(201,30)}
      34  PurchaseAddress3. . . . . . .    30 SNN  Purchase Address 3. . . . . . .ADDRESSLINE
                                                    Notes: {AP_12$(231,30)}
      35  PurchaseCity. . . . . . . . .    20 SNN  Purchase City . . . . . . . . .CITY
                                                    Notes: {AP_12$(261,20)}
      36  PurchaseState . . . . . . . .     2 SNN  Purchase State. . . . . . . . .STATE
                                                    Notes: {AP_12$(281,2)}
      37  PurchaseZipCode . . . . . . .    10 SNN  Purchase Zip Code . . . . . . .ZIPCODE
                                                    Notes: {AP_12$(303,10)}
      38  PurchaseCountryCode . . . . .     3 SNN  Purchase Country Code . . . . .COUNTRY
                                                    Notes: {AP_12$(283,3)}
      39  ShipToCode. . . . . . . . . .     4 SYN  Ship To Code. . . . . . . . . .
                                                    Notes: {AP_12$(313,4)} This
                                                    is a dual purpose field and
                                                    could hold either the PO
                                                    Ship To Code or SO Ship To
                                                    Code.
      40  ShipToName. . . . . . . . . .    30 SNN  Ship To Name. . . . . . . . . .NAME
                                                    Notes: {AP_12$(317,30)}
      41  ShipToAddress1. . . . . . . .    30 SNN  Ship To Address 1 . . . . . . .ADDRESSLINE
                                                    Notes: {AP_12$(347,30)}
      42  ShipToAddress2. . . . . . . .    30 SNN  Ship To Address 2 . . . . . . .ADDRESSLINE
                                                    Notes: {AP_12$(377,30)}
      43  ShipToAddress3. . . . . . . .    30 SNN  Ship To Address 3 . . . . . . .ADDRESSLINE
                                                    Notes: {AP_12$(407,30)}
      44  ShipToCity. . . . . . . . . .    20 SNN  Ship To City. . . . . . . . . .CITY
                                                    Notes: {AP_12$(437,20)}
      45  ShipToState . . . . . . . . .     2 SNN  Ship To State . . . . . . . . .STATE
                                                    Notes: {AP_12$(457,2)}
      46  ShipToZipCode . . . . . . . .    10 SNN  Ship To Zip Code. . . . . . . .ZIPCODE
                                                    Notes: {AP_12$(479,10)}
      47  ShipToCountryCode . . . . . .     3 SNN  Ship To Country Code. . . . . .COUNTRY
                                                    Notes: {AP_12$(459,3)}
      48  RequiredDate. . . . . . . . .     8 SNN  Required Date . . . . . . . . .DATE
                                                    Notes: {AP_12$(489,6)}
      49  ShipVia . . . . . . . . . . .    15 SNN  Ship Via. . . . . . . . . . . .SHIPCODE
                                                    Notes: {AP_12$(500,15)}
      50  FOB . . . . . . . . . . . . .    15 SNN  F.O.B.. . . . . . . . . . . . .
                                                    Notes: {AP_12$(515,15)}
      51  WarehouseCode . . . . . . . .     3 SYN  Warehouse Code. . . . . . . . .WAREHOUSE
                                                    FmtType:CHARNUM Notes:
                                                    {AP_12$(530,3)}
      52  ConfirmTo . . . . . . . . . .    30 SNN  Confirm To. . . . . . . . . . .
                                                    Notes: {AP_12$(533,30)}
      53  ARDivisionNo. . . . . . . . .     2 SNN  AR Division Number. . . . . . .ARDIVISION
                                                    Mask:00 FmtType:ZEROFILL
                                                    Notes: {AP_12$(563.2)}
      54  CustomerNo. . . . . . . . . .    20 SYN  Customer Number . . . . . . . .CUSTOMERNO
                                                    FmtType:MASTERNUMC Notes:
                                                    {AP_12$(565,7)}
      55  CODCheckNo. . . . . . . . . .    10 SNN  COD Check No. . . . . . . . . .
                                                    Notes: {AP_12$(572,6)}
      56  BankCode. . . . . . . . . . .     1 SYN  Bank Code . . . . . . . . . . .BANKCODE
                                                    Notes: {AP_12$(578,1)}
      57  PurchaseOrderType . . . . . .     1 SYN  Purchase Order Type . . . . . .
                                                    Notes: {AP_12$(579,1)}
      58  PurchaseOrderDate . . . . . .     8 SNN  Purchase Order Date . . . . . .DATE
                                                    Notes: {AP_12$(580,6)}
      59  CODNo . . . . . . . . . . . .    10 SNN  COD Number. . . . . . . . . . .
                                                    Notes: {AP_12$(586,10)}
      60  UserKey . . . . . . . . . . .    10 SYN  User Key. . . . . . . . . . . .USER
                                                    Read Only:Y Mask:0000000000
                                                    Notes: {AP_12$(596,3)}
      61  InvoiceAmt. . . . . . . . . . 13.2  NNN  Invoice Amount. . . . . . . . .AMOUNT
                                                    Mask:###,###,###.00- Notes:
                                                    {AP_12[0]}
      62  NetInvoiceAmt . . . . . . . . 13.2  NNN  Net Invoice Amount. . . . . . .AMOUNT
                                                    Mask:###,###,###.00- Notes:
                                                    {AP_12[1]}
      63  DiscountAmt . . . . . . . . . 13.2  NNN  Discount Amount . . . . . . . .AMOUNT
                                                    Mask:###,###,###.00- Notes:
                                                    {AP_12[2]}
      64  RetentionAmt. . . . . . . . . 13.2  NNN  Retention Amount. . . . . . . .AMOUNT
                                                    Mask:###,###,###.00- Notes:
                                                    {AP_12[3]}
      65  PrepaymentAmt . . . . . . . . 13.2  NNN  Prepayment Amount . . . . . . .AMOUNT
                                                    Mask:###,###,###.00- Notes:
                                                    {AP_12[4]}
      66  TaxableAmt. . . . . . . . . . 13.2  NNN  Taxable Amount. . . . . . . . .AMOUNT
                                                    Mask:###,###,###.00- Notes:
                                                    {AP_12[5]}
      67  NonTaxableAmt . . . . . . . . 13.2  NNN  Non-Taxable Amount. . . . . . .AMOUNT
                                                    Mask:###,###,###.00- Notes:
                                                    {AP_12[6]}
      68  FreightAmt. . . . . . . . . . 13.2  NNN  Freight Amount. . . . . . . . .AMOUNT
                                                    Mask:###,###,###.00- Notes:
                                                    {AP_12[7]}
      69  TaxAmt. . . . . . . . . . . . 13.2  NNN  Tax Amount. . . . . . . . . . .AMOUNT
                                                    Mask:###,###,###.00- Notes:
                                                    {AP_12[8]}
      70  NonRecoverableAmt . . . . . . 13.2  NNN  Non-Recoverable Amount. . . . .AMOUNT
                                                    Mask:###,###,###.00- Notes:
                                                    {AP_12[9]}
      71  TaxableMiscChargeAmt. . . . . 13.2  NNN  Taxable Miscellaneous Charge AmAMOUNT
                                                    Mask:###,###,###.00 Notes:
                                                    {AP_12[7]}
      72  NonTaxableMiscChargeAmt . . . 13.2  NNN  Non-Taxable Miscellaneous ChargAMOUNT
                                                    Mask:###,###,###.00 Notes:
                                                    {AP_12[8]}
      73  TotalCostForFrghtAlloc. . . . 13.2  NNN  Total Cost for Freight AllocatiAMOUNT
                                                    Mask:###,###,###.00 Notes:
                                                    {AP_12[9]}
      74  PrepaidFreight. . . . . . . . 13.2  NNN  Prepaid Freight . . . . . . . .AMOUNT
                                                    Mask:###,###,###.00 Notes:
                                                    {AP_12[10]}
      75  CODAmount . . . . . . . . . . 13.2  NNN  COD Amount. . . . . . . . . . .AMOUNT
                                                    Mask:###,###,###.00 Notes:
                                                    {AP_12[11]}
      76  DateUpdated . . . . . . . . .     8 SNN  Last Update Date. . . . . . . .DATE
                                                    Read Only:Y Notes: YYYYMMDD
      77  TimeUpdated . . . . . . . . .     8 SNN  Last Update Time. . . . . . . .
                                                    Read Only:Y
      78  UserUpdatedKey. . . . . . . .    10 SNN  Last Update User ID . . . . . .USER
                                                    Read Only:Y Mask:0000000000