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