     AR_OpenInvoice                         AR Open Invoice                Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: AR_OpenInvoice_bus,AR_SalesJournal_upd,SO_SalesJournal_upd,AR_FinanceChargeJournal_upd,AR_Cash
     SQL Def: Y  SysDB: N                                        "MAS_"+%C$+"/AR"+%C$+"/AR_OpenInvoice.M4T"

     KPRIMARY: ARDivisionNo+CustomerNo+InvoiceNo+InvoiceType
     KINVOICE: ARDivisionNo+CustomerNo+InvoiceDate+InvoiceNo+InvoiceType
     KINVOICEDECENDING: ARDivisionNo+CustomerNo+InvoiceDate(d)+InvoiceNo+InvoiceType

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  ARDivisionNo. . . . . . . . .     2 SNY  AR Division Number. . . . . . .ARDIVISION
                                                    Mask:00 FmtType:ZEROFILL
                                                    Notes: {AR4$(1,2)}
       2  CustomerNo. . . . . . . . . .    20 SYY  Customer Number . . . . . . . .CUSTOMERNO
                                                    FmtType:MASTERNUMC ChngTag:Re
                                                    place1/ARDivisionNo$ Notes:
                                                    {AR4$(3,7)}
       3  InvoiceNo . . . . . . . . . .     7 SYY  Invoice Number. . . . . . . . .INVOICE
                                                    FmtType:MASTERNUM Notes:
                                                    Payment Date {AR4$(10,7)}
       4  InvoiceType . . . . . . . . .     2 SYY  Invoice Type. . . . . . . . . .
                                                    Valid:CM,DM,FC,IN,PP,PY,BC,
                                                    BF Notes: CM=Credit Memo,
                                                    DM=Debit Memo, FC=Finance
                                                    Charge, IN=INvoice,
                                                    PP=PrePayment, PY=PaYment,
                                                    BC=Balance forward other
                                                    Charges, BF=Balance Forward
                                                    {AR4$(17,2)}
       5  InvoiceDate . . . . . . . . .     8 SNN  Invoice Date. . . . . . . . . .DATE
                                                    ChngTag:Min Notes: {AR4$(19,
                                                    6)}
       6  InvoiceDueDate. . . . . . . .     8 SNN  Invoice Due Date. . . . . . . .DATE
                                                    ChngTag:Min Notes: {AR4$(25,
                                                    6)}
       7  InvoiceDiscountDate . . . . .     8 SNN  Invoice Discount Date . . . . .DATE
                                                    ChngTag:Min Notes: {AR4$(31,
                                                    6)}
       8  InvoiceHistoryHeaderSeqNo . .     6 SNN  Invoice History Header Sequence
                                                    Mask:000000
       9  PostingDate . . . . . . . . .     8 SNN  Last Payment Posting Date . . .DATE
                                                    ChngTag:Min Notes: {AR4$(59,
                                                    6)}
      10  TermsCode . . . . . . . . . .     2 SNN  Terms Code. . . . . . . . . . .ARTERMS
                                                    Mask:00 FmtType:ZEROFILL
                                                    Notes: {AR4$(37,2)}
      11  TaxSchedule . . . . . . . . .     9 SYN  Tax Schedule. . . . . . . . . .TAXSCHEDULE
                                                    FmtType:CHARNUM Notes:
                                                    {AR4$(39,9)}
      12  SalespersonDivisionNo . . . .     2 SNN  Salesperson Division Number . .ARDIVISION
                                                    Mask:00 FmtType:ZEROFILL
      13  SalespersonNo . . . . . . . .     4 SYN  Salesperson Number. . . . . . .SALESPERSONNO
                                                    FmtType:CHARNUM Notes:
                                                    {AR4$(48,4)}
      14  SplitCommissionFlag . . . . .     1 SYN  Split Commission Flag . . . . .
                                                    Valid:Y,N,O Notes: Y=Yes,
                                                    N=No, O=Override {AR4$(52,1)}
      15  Comment . . . . . . . . . . .    30 SNN  Comment . . . . . . . . . . . .COMMENT30
                                                    Notes: {AR4$(65,30)}
      16  CreditMemoInvoiceReference. .     7 SYN  Credit Memo Invoice Reference .
                                                    FmtType:CHARNUM Notes:
                                                    {AR4$(95,7)}
      17  JobNo . . . . . . . . . . . .     7 SYN  Job Number. . . . . . . . . . .JOBNO
                                                    FmtType:CHARNUM Notes:
                                                    {AR4$(102,7)}
      18  CustomerPONo. . . . . . . . .    15 SNN  Customer PO Number. . . . . . .CUSTOMERPONO
                                                    Notes: {AR4$(109,15)}
      19  PostingReference. . . . . . .    10 SNN  Posting Reference . . . . . . .
                                                    Notes: {AR4$(124,10)}
      20  CheckNo . . . . . . . . . . .    10 SYN  Check Number. . . . . . . . . .CHECKNO
                                                    FmtType:ALPHANUM Notes:
                                                    {AR4$(124,10)}
      21  CommissionRate. . . . . . . .  9.3  NNN  Commission Rate . . . . . . . .COMMISSIONRATE
                                                    Mask:###0.000 Notes: {AR4[0]}
      22  TaxableAmt. . . . . . . . . . 14.2  NNN  Taxable Amount. . . . . . . . .
                                                    Mask:#,###,###,###.00-
                                                    ChngTag:Sum Notes: Payment
                                                    Amount {AR4[1]}
      23  NonTaxableAmt . . . . . . . . 14.2  NNN  Non-Taxable Amount. . . . . . .
                                                    Mask:#,###,###,###.00-
                                                    ChngTag:Sum Notes: {AR4[2]}
      24  FreightAmt. . . . . . . . . . 13.2  NNN  Freight Amount. . . . . . . . .
                                                    Mask:###,###,###.00-
                                                    ChngTag:Sum Notes: {AR4[3]}
      25  SalesTaxAmt . . . . . . . . . 13.2  NNN  Sales Tax Amount. . . . . . . .
                                                    Mask:###,###,###.00-
                                                    ChngTag:Sum Notes: {AR4[4]}
      26  CostOfSalesAmt. . . . . . . . 14.2  NNN  Cost Of Sales Amount. . . . . .
                                                    Mask:#,###,###,###.00-
                                                    ChngTag:Sum Notes: {AR4[5]}
      27  SalesSubjectToComm. . . . . . 14.2  NNN  Sales Subject To Commission . .
                                                    Mask:#,###,###,###.00-
                                                    ChngTag:Sum Notes: {AR4[6]}
      28  CostSubjectToComm . . . . . . 14.2  NNN  Cost Subject To Commission. . .
                                                    Mask:#,###,###,###.00-
                                                    ChngTag:Sum Notes: {AR4[7]}
      29  CommissionAmt . . . . . . . . 13.2  NNN  Commission Amount . . . . . . .
                                                    Mask:###,###,###.00-
                                                    ChngTag:Sum Notes: {AR4[8]}
      30  DiscountAmt . . . . . . . . . 14.2  NNN  Discount Amount . . . . . . . .
                                                    Mask:#,###,###,###.00-
                                                    ChngTag:Sum Notes: {AR4[9]}
      31  PaymentsToday . . . . . . . . 14.2  NNN  Payments Today. . . . . . . . .
                                                    Mask:#,###,###,###.00-
                                                    ChngTag:Sum Notes: {AR4[10]}
      32  Balance . . . . . . . . . . . 14.2  NNN  Balance . . . . . . . . . . . .
                                                    Mask:#,###,###,###.00-
                                                    ChngTag:Sum Notes: Balance
                                                    Forward {AR4[11]}
      33  RetentionAmt. . . . . . . . . 14.2  NNN  Retention Amount. . . . . . . .
                                                    Mask:#,###,###,###.00-
                                                    ChngTag:Sum Notes: * Bal Fwd
                                                    Accts - Payment Date Can Be
                                                    Ppmmdd Or Mmmddyy (Apr0499)
                                                    {AR4[12]}
      34  DateUpdated . . . . . . . . .     8 SNN  Last Update Date. . . . . . . .DATE
                                                    Read Only:Y ChngTag:Max
                                                    Notes: YYYYMMDD
      35  TimeUpdated . . . . . . . . .     8 SNN  Last Update Time. . . . . . . .
                                                    Read Only:Y ChngTag:CopyMax/D
                                                    ateUpdated$
      36  UserUpdatedKey. . . . . . . .    10 SYN  Last Update User ID . . . . . .USER
                                                    Read Only:Y Mask:0000000000
                                                    FmtType:ZEROFILL ChngTag:Copy
                                                    Max/DateUpdated$