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$