     AP_InvoiceHeader                       AP Invoice Header              Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: AP_Invoice_bus
     SQL Def: Y  SysDB: N                                      "MAS_"+%C$+"/AP"+%C$+"/AP_InvoiceHeader.M4T"

     KPRIMARY: APDivisionNo+VendorNo+InvoiceNo
     KBATCH: BatchNo+APDivisionNo+VendorNo+InvoiceNo

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  APDivisionNo. . . . . . . . .     2 SNY  AP Division Number. . . . . . .APDIVISION
                                                    Mask:00 FmtType:ZEROFILL
                                                    ValGroup:APDivisionRequired
                                                    Notes: {AP5$(1,2)}
       2  VendorNo. . . . . . . . . . .     7 SYY  Vendor Number . . . . . . . . .VENDORNO
                                                    FmtType:MASTERNUM Notes:
                                                    {AP5$(3,7)}
       3  InvoiceNo . . . . . . . . . .    10 SYY  Invoice Number. . . . . . . . .APINVOICE
                                                    Notes: {AP5$(10,10)}
       4  InvoiceDate . . . . . . . . .     8 SNN  Invoice Date. . . . . . . . . .DATE
                                                    DepVal:REQUIRED Notes:
                                                    {AP5$(20,6)}
       5  InvoiceDueDate. . . . . . . .     8 SNN  Invoice Due Date. . . . . . . .DATE
                                                    Notes: {AP5$(26,6)}
       6  InvoiceDiscountDate . . . . .     8 SNN  Invoice Discount Date . . . . .DATE
                                                    Notes: {AP5$(32,6)}
       7  TermsCode . . . . . . . . . .     2 SNN  Terms Code. . . . . . . . . . .APTERMS
                                                    Mask:00 FmtType:ZEROFILL
                                                    DepVal:REQUIRED Notes:
                                                    {AP5$(38,2)}
       8  HoldPayment . . . . . . . . .     1 SYN  Hold Payment. . . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N Notes:
                                                    {AP5$(40,1)}
       9  Comment . . . . . . . . . . .    40 SNN  Comment . . . . . . . . . . . .
                                                    Notes: {AP5$(41,30)}
      10  JobNo . . . . . . . . . . . .     7 SYN  Job Number. . . . . . . . . . .JOBNO
                                                    FmtType:CHARNUM DepVal:REQUIR
                                                    ED ValGroup:JCIntegrated
                                                    Notes: {AP5$(71,7)}
      11  Adjustment. . . . . . . . . .     1 SYN  Adjustment. . . . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N Notes:
                                                    {AP5$(78,1)}
      12  RecurringInvoice. . . . . . .     1 SYN  Recurring Invoice . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N Notes:
                                                    {AP5$(79,1)}
      13  PrepaidApplyToInvoiceNo . . .    10 SYN  Prepaid Apply To AP Invoice NumAPINVOICE
                                                    DepVal:REQUIRED Notes:
                                                    {AP5$(80,10)}
      14  PrepaidPaymentDate. . . . . .     8 SNN  Prepaid Payment Invoice Date. .DATE
                                                    Notes: {AP5$(90,6)}
      15  PrepaidCheckNo. . . . . . . .    10 SYN  Prepaid Check Number. . . . . .APCHECKNO
                                                    Notes: {AP5$(96,6)}
      16  Form1099. . . . . . . . . . .     1 SNN  1099 Form . . . . . . . . . . .FORM1099
                                                    ValGroup:TEN99 Notes:
                                                    {AP5$(102,1)}
      17  Box1099 . . . . . . . . . . .     3 SNN  1099 Box. . . . . . . . . . . .BOX1099
                                                    ValGroup:TEN99 Notes:
                                                    {AP5$(103,2)}
      18  SeparateCheck . . . . . . . .     1 SYN  Separate Check. . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N Notes:
                                                    {AP5$(105,1)}
      19  BatchNo . . . . . . . . . . .     5 SYN  Batch Number. . . . . . . . . .BATCHNO
                                                    FmtType:ALPHANUM Notes:
                                                    {AP5$(106,5)}
      20  TaxSchedule . . . . . . . . .     9 SYN  Tax Schedule. . . . . . . . . .TAXSCHEDULE
                                                    FmtType:CHARNUM DepVal:REQUIR
                                                    ED ValGroup:APSalesTax
                                                    Notes: {AP5$(111,9)}
      21  TaxClass. . . . . . . . . . .     2 SYN  Tax Class . . . . . . . . . . .TAXCLASS
                                                    DepVal:REQUIRED ValGroup:APSa
                                                    lesTax Notes: {AP5$(120,2)}
      22  InvalidTaxCalc. . . . . . . .     1 SYN  Invalid Tax Calculation . . . .YESNO
                                                    DfltVal:N Valid:Y,N
                                                    ValGroup:APSalesTax Notes:
                                                    {AP5$(122,1)}
      23  UseTax. . . . . . . . . . . .     1 SYN  Use Tax . . . . . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
                                                    ValGroup:APSalesTax Notes:
                                                    {AP5$(123,1)}
      24  InvoiceAmt. . . . . . . . . . 13.2  NNN  Invoice Amount. . . . . . . . .AMOUNT
                                                    Mask:###,###,###.00- Notes:
                                                    {AP5[0]}
      25  NetInvoiceAmt . . . . . . . . 13.2  NNN  Net Invoice Amount. . . . . . .AMOUNT
                                                    Mask:###,###,###.00- Notes:
                                                    {AP5[1]}
      26  DiscountAmt . . . . . . . . . 13.2  NNN  Discount Amount . . . . . . . .AMOUNT
                                                    Mask:###,###,###.00-
                                                    ValSeqNo:9999 Notes: {AP5[2]}
      27  RetentionAmt. . . . . . . . . 13.2  NNN  Retention Amount. . . . . . . .AMOUNT
                                                    Read Only:Y Mask:###,###,
                                                    ###.00- ValGroup:JCIntegrated
                                                    ,JCRetention Notes: {AP5[3]}
      28  PrepaymentAmt . . . . . . . . 13.2  NNN  Prepayment Amount . . . . . . .AMOUNT
                                                    Mask:###,###,###.00- Notes:
                                                    {AP5[4]}
      29  TaxableAmt. . . . . . . . . . 13.2  NNN  Taxable Amount. . . . . . . . .AMOUNT
                                                    Read Only:Y Mask:###,###,
                                                    ###.00- ValGroup:APSalesTax
                                                    Notes: {AP5[6]}
      30  NonTaxableAmt . . . . . . . . 13.2  NNN  Non-Taxable Amount. . . . . . .AMOUNT
                                                    Read Only:Y Mask:###,###,
                                                    ###.00- Notes: {AP5[7]}
      31  FreightAmt. . . . . . . . . . 13.2  NNN  Freight Amount. . . . . . . . .AMOUNT
                                                    Mask:###,###,###.00- Notes:
                                                    {AP5[8]}
      32  TaxAmt. . . . . . . . . . . . 13.2  NNN  Tax Amount. . . . . . . . . . .AMOUNT
                                                    Read Only:Y Mask:###,###,
                                                    ###.00- ValGroup:APSalesTax
                                                    ValSeqNo:9999 Notes: {AP5[9]}
      33  NonRecoverableAmt . . . . . . 13.2  NNN  Non-Recoverable Amount. . . . .AMOUNT
                                                    Read Only:Y Mask:###,###,
                                                    ###.00- ValGroup:APSalesTax
                                                    Notes: {AP5[10]}
      34  DateCreated . . . . . . . . .     8 SNY  Creation Date . . . . . . . . .DATE
                                                    Read Only:Y Notes: YYYYMMDD
      35  TimeCreated . . . . . . . . .     8 SNY  Creation Time . . . . . . . . .
                                                    Read Only:Y
      36  UserCreatedKey. . . . . . . .    10 SYY  Creation User ID. . . . . . . .USER
                                                    Read Only:Y Mask:0000000000
      37  DateUpdated . . . . . . . . .     8 SNN  Last Update Date. . . . . . . .DATE
                                                    Read Only:Y Notes: YYYYMMDD
      38  TimeUpdated . . . . . . . . .     8 SNN  Last Update Time. . . . . . . .
                                                    Read Only:Y
      39  UserUpdatedKey. . . . . . . .    10 SNN  Last Update User ID . . . . . .USER
                                                    Read Only:Y Mask:0000000000