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