AR_InvoiceHeader                       AR Invoice Header              Rel: 4.40  Bld: 398  8/28/2009
 Bus Obj: AR_Invoice_bus
 SQL Def: N  SysDB: N                                      "MAS_"+%C$+"/AR"+%C$+"/AR_InvoiceHeader.M4T"

 KPRIMARY: InvoiceNo+InvoiceType
 KBATCH: BatchNo+InvoiceNo+InvoiceType
 KCUSTOMER: ARDivisionNo+CustomerNo+InvoiceNo+InvoiceType

 Fld  Column Name                     M/L TUR  Description/Notes              Class

   1  InvoiceNo . . . . . . . . . .     7 SYY  Invoice Number. . . . . . . . .INVOICE
                                                FmtType:MASTERNUMC Next:Invoi
                                                ceNo$ Notes: {AR7$(1,7)}
   2  InvoiceType . . . . . . . . .     2 SYY  Invoice Type. . . . . . . . . .
                                                DfltVal:IN Valid:CM,DM,IN,FC,
                                                CA,XD Notes: CM=Credit Memo,
                                                DM=Debit Memo, IN=INvoice,
                                                FC=Finance Charge, CA=CAsh,
                                                XD=Deleted {AR7$(8,2)}
   3  ARDivisionNo. . . . . . . . .     2 SNY  AR Division Number. . . . . . .ARDIVISION
                                                Mask:00 FmtType:ZEROFILL
                                                ValGroup:ARDivisionRequired
                                                Notes: {AR7$(10,2)}
   4  CustomerNo. . . . . . . . . .    20 SYY  Customer Number . . . . . . . .CUSTOMERNO
                                                FmtType:MASTERNUMC ChngTag:Re
                                                place1/ARDivisionNo$ Notes:
                                                {AR7$(12,7)}
   5  SoldTo. . . . . . . . . . . .    30 SNN  Sold To . . . . . . . . . . . .NAME
                                                Notes: {AR7$(19,30)}
   6  InvoiceDate . . . . . . . . .     8 SNN  Invoice Date. . . . . . . . . .DATE
                                                DepVal:REQUIRED Notes:
                                                {AR7$(49,6)}
   7  TermsCode . . . . . . . . . .     2 SNN  Terms Code. . . . . . . . . . .ARTERMS
                                                Mask:00 FmtType:ZEROFILL
                                                DepVal:REQUIRED Notes:
                                                {AR7$(55,2)}
   8  TaxSchedule . . . . . . . . .     9 SYN  Tax Schedule. . . . . . . . . .TAXSCHEDULE
                                                FmtType:CHARNUM DepVal:REQUIR
                                                ED ValGroup:ARSalesTax
                                                Notes: {AR7$(57,9)}
   9  SalespersonDivisionNo . . . .     2 SNN  Salesperson Division Number . .ARDIVISION
                                                Mask:00 FmtType:ZEROFILL
                                                ValGroup:ARDivisionRequired,
                                                SalespersonReporting,
                                                CustomerRequired
  10  SalespersonNo . . . . . . . .     4 SYN  Salesperson Number. . . . . . .SALESPERSONNO
                                                FmtType:CHARNUM DepVal:REQUIR
                                                ED ValGroup:SalespersonReport
                                                ing,CustomerRequired Notes:
                                                {AR7$(66,4)}
  11  PrintInvoice. . . . . . . . .     1 SYN  Print Invoice . . . . . . . . .YESNO
                                                DfltVal:N Valid:Y,N Notes:
                                                {AR7$(70,1)}
  12  ShipMethod. . . . . . . . . .    15 SYN  Ship Method . . . . . . . . . .SHIPCODE
                                                Notes: {AR7$(71,15)}
  13  CustomerPONo. . . . . . . . .    15 SNN  Customer PO Number. . . . . . .CUSTOMERPONO
                                                Notes: {AR7$(86,15)}
  14  ApplyToInvoiceNo. . . . . . .     7 SYN  Apply To Invoice Number . . . .
                                                FmtType:CHARNUM Notes:
                                                {AR7$(101,7)}
  15  Comment . . . . . . . . . . .    30 SNN  Comment . . . . . . . . . . . .COMMENT30
                                                Notes: {AR7$(108,30)}
  16  Adjustment. . . . . . . . . .     1 SYN  Adjustment. . . . . . . . . . .YESNO
                                                DfltVal:N Valid:Y,N Notes:
                                                {AR7$(138,1)}
  17  RepetitiveInvoiceRefNo. . . .     4 SYN  Repetitive Invoice Reference Nu
                                                FmtType:CHARNUM Notes:
                                                {AR7$(139,4)}
  18  ActuallyPrinted . . . . . . .     1 SYN  Actually Printed. . . . . . . .YESNO
                                                DfltVal:N Valid:Y,N Notes:
                                                {AR7$(143,1)}
  19  JobNo . . . . . . . . . . . .     7 SYN  Job Number. . . . . . . . . . .JOBNO
                                                FmtType:CHARNUM DepVal:REQUIR
                                                ED ValGroup:JCIntegrated
                                                Notes: {AR7$(144,7)}
  20  InvoiceDueDate. . . . . . . .     8 SNN  Invoice Due Date. . . . . . . .DATE
                                                Notes: {AR7$(151,6)}
  21  DiscountDueDate . . . . . . .     8 SNN  Discount Due Date . . . . . . .DATE
                                                Notes: {AR7$(157,6)}
  22  BatchNo . . . . . . . . . . .     5 SYN  Batch Number. . . . . . . . . .BATCHNO
                                                FmtType:ALPHANUM Notes:
                                                {AR7$(163,5)}
  23  InvalidTaxCalc. . . . . . . .     1 SYN  Invalid Tax Calculation . . . .YESNO
                                                DfltVal:N Valid:Y,N
                                                ValGroup:ARSalesTax Notes:
                                                {AR7$(168,1)}
  24  BatchFax. . . . . . . . . . .     1 SYN  Batch Fax . . . . . . . . . . .YESNO
                                                DfltVal:N Valid:Y,N Notes:
                                                {AR7$(169,1)}
  25  FaxNo . . . . . . . . . . . .    17 SNN  Fax Number. . . . . . . . . . .TELEPHONENO
                                                Notes: {AR7$(170,17)}
  26  EmailAddress. . . . . . . . .   250 SNN  Email Address . . . . . . . . .EMAILADDRESS
  27  CommissionRate. . . . . . . .  9.3  NNN  Commission Rate . . . . . . . .COMMISSIONRATE
                                                Mask:###0.000 ValGroup:Salesp
                                                ersonReporting Notes:
                                                {AR7[0]}
  28  TaxableSalesAmt . . . . . . . 14.2  NNN  Taxable Sales Amount. . . . . .SALESAMOUNT
                                                Read Only:Y Mask:#,###,###,
                                                ###.00- ValGroup:ARSalesTax
                                                Notes: {AR7[1]}
  29  NonTaxableSalesAmt. . . . . . 14.2  NNN  Non Taxable Sales Amount. . . .SALESAMOUNT
                                                Read Only:Y Mask:#,###,###,
                                                ###.00- Notes: {AR7[2]}
  30  FreightAmt. . . . . . . . . . 12.2  NNN  Freight Amount. . . . . . . . .MISCAMOUNT
                                                Mask:##,###,###.00-
                                                ValSeqNo:9999 Notes: {AR7[3]}
  31  SalesTaxAmt . . . . . . . . . 12.2  NNN  Sales Tax Amount. . . . . . . .MISCAMOUNT
                                                Read Only:Y Mask:##,###,
                                                ###.00- ValGroup:ARSalesTax
                                                Notes: {AR7[4]}
  32  CostOfSalesAmt. . . . . . . . 14.2  NNN  Cost of Sales Amount. . . . . .SALESAMOUNT
                                                Read Only:Y Mask:#,###,###,
                                                ###.00- Notes: {AR7[5]}
  33  SalesSubjectToComm. . . . . . 14.2  NNN  Sales Subject to Commission . .SALESAMOUNT
                                                Read Only:Y Mask:#,###,###,
                                                ###.00- ValGroup:SalespersonR
                                                eporting Notes: {AR7[6]}
  34  CostSubjectToComm . . . . . . 14.2  NNN  Cost Subject To Commission. . .SALESAMOUNT
                                                Read Only:Y Mask:#,###,###,
                                                ###.00- ValGroup:SalespersonR
                                                eporting Notes: {AR7[7]}
  35  CommissionAmt . . . . . . . . 14.2  NNN  Commission Amount . . . . . . .SALESAMOUNT
                                                Mask:#,###,###,###.00-
                                                ValGroup:SalespersonReporting
                                                 Notes: {AR7[8]}
  36  RetentionAmt. . . . . . . . . 14.2  NNN  Retention Amount. . . . . . . .SALESAMOUNT
                                                Mask:#,###,###,###.00-
                                                ValGroup:JCIntegrated,
                                                JCRetention Notes: {AR7[10]}
  37  DateCreated . . . . . . . . .     8 SNY  Creation Date . . . . . . . . .DATE
                                                Read Only:Y
  38  TimeCreated . . . . . . . . .     8 SNY  Creation Time . . . . . . . . .
                                                Read Only:Y
  39  UserCreatedKey. . . . . . . .    10 SYY  Creation User ID. . . . . . . .USER
                                                Read Only:Y Mask:0000000000
                                                FmtType:ZEROFILL
  40  DateUpdated . . . . . . . . .     8 SNN  Last Update Date. . . . . . . .DATE
                                                Read Only:Y
  41  TimeUpdated . . . . . . . . .     8 SNN  Last Update Time. . . . . . . .
                                                Read Only:Y
  42  UserUpdatedKey. . . . . . . .    10 SYN  Last Update User ID . . . . . .USER
                                                Read Only:Y Mask:0000000000
                                                FmtType:ZEROFILL