     AR_CashSales                     AR Cash Sales Transactions           Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: AR_SalesJournal_upd,SO_SalesJournal_upd,AR_CommissionEditRegister_upd
     SQL Def: N  SysDB: N                                          "MAS_"+%C$+"/AR"+%C$+"/AR_CashSales.M4T"

     KPRIMARY: ARDivisionNo+CustomerNo+InvoiceNo+InvoiceType+SequenceNo

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  ARDivisionNo. . . . . . . . .     2 SNY  AR Division Number. . . . . . .ARDIVISION
                                                    FmtType:ZEROFILL
       2  CustomerNo. . . . . . . . . .    20 SYY  Customer Number . . . . . . . .CUSTOMERNO
                                                    FmtType:MASTERNUMC ChngTag:Re
                                                    place1/ARDivisionNo$ Notes:
                                                    {ARS$(3,7)}
       3  InvoiceNo . . . . . . . . . .     7 SYY  Invoice Number. . . . . . . . .INVOICE
                                                    FmtType:MASTERNUM Notes:
                                                    {ARS$(10,7)}
       4  InvoiceType . . . . . . . . .     2 SYY  Invoice Type. . . . . . . . . .
                                                    Valid:CM,DM,IN,FC,CA Notes:
                                                    CM=Credit Memo, DM=Debit
                                                    Memo, IN=INvoice, FC=Finance
                                                    Charge, CA=CAsh {ARS$(17,2)}
       5  SequenceNo. . . . . . . . . .     6 SNY  Sequence Number . . . . . . . .
                                                    Mask:000000 FmtType:ZEROFILL
                                                    ChngTag:KeySeq Notes:
                                                    {ARS$(19,3)}
       6  InvoiceDate . . . . . . . . .     8 SNN  Invoice Date. . . . . . . . . .DATE
                                                    Notes: {ARS$(22,6)}
       7  InvoiceDueDate. . . . . . . .     8 SNN  Invoice Due Date. . . . . . . .DATE
                                                    Notes: {ARS$(28,6)}
       8  InvoiceDiscountDate . . . . .     8 SNN  Invoice Discount Date . . . . .DATE
                                                    Notes: {ARS$(34,6)}
       9  TransactionDate . . . . . . .     8 SNN  Transaction Date. . . . . . . .DATE
                                                    Notes: {ARS$(40,6)}
      10  TermsCode . . . . . . . . . .     2 SNN  Terms Code. . . . . . . . . . .ARTERMS
                                                    Mask:00 FmtType:ZEROFILL
                                                    Notes: {ARS$(46,2)}
      11  TaxSchedule . . . . . . . . .     9 SYN  Tax Schedule. . . . . . . . . .TAXSCHEDULE
                                                    Notes: {ARS$(48,9)}
      12  SalespersonDivisionNo . . . .     2 SNN  Salesperson Division Number . .ARDIVISION
                                                    Mask:00 FmtType:ZEROFILL
      13  SalespersonNo . . . . . . . .     4 SYN  Salesperson Number. . . . . . .SALESPERSONNO
                                                    FmtType:CHARNUM Notes:
                                                    {ARS$(57,4)}
      14  SplitCommission . . . . . . .     1 SYN  Split Commission. . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N Notes:
                                                    {ARS$(61,1)}
      15  JobNo . . . . . . . . . . . .     7 SYN  Job Number. . . . . . . . . . .JOBNO
                                                    FmtType:CHARNUM Notes:
                                                    {ARS$(62,7)}
      16  CommissionRate. . . . . . . .  9.3  NNN  Commission Rate . . . . . . . .COMMISSIONRATE
                                                    Mask:###0.000 Notes: {ARS[0]}
      17  TaxableAmt. . . . . . . . . . 13.2  NNN  Taxable Amount. . . . . . . . .AMOUNT
                                                    Mask:###,###,###.00 Notes:
                                                    {ARS[1]}
      18  NonTaxableAmt . . . . . . . . 13.2  NNN  Non-Taxable Amount. . . . . . .AMOUNT
                                                    Mask:###,###,###.00 Notes:
                                                    {ARS[2]}
      19  FreightAmt. . . . . . . . . . 12.2  NNN  Freight Amount. . . . . . . . .MISCAMOUNT
                                                    Mask:##,###,###.00- Notes:
                                                    {ARS[3]}
      20  SalesTaxAmt . . . . . . . . . 12.2  NNN  Sales Tax Amount. . . . . . . .MISCAMOUNT
                                                    Mask:##,###,###.00- Notes:
                                                    {ARS[4]}
      21  CostOfSalesAmt. . . . . . . . 13.2  NNN  Cost Of Sales Amount. . . . . .AMOUNT
                                                    Mask:###,###,###.00 Notes:
                                                    {ARS[5]}
      22  SalesSubjectToComm. . . . . . 13.2  NNN  Sales Subject To Commission . .AMOUNT
                                                    Mask:###,###,###.00 Notes:
                                                    {ARS[6]}
      23  CostSubjectToComm . . . . . . 13.2  NNN  Cost Subject To Commission. . .AMOUNT
                                                    Mask:###,###,###.00 Notes:
                                                    {ARS[7]}
      24  CommissionAmt . . . . . . . . 13.2  NNN  Commission Amount . . . . . . .AMOUNT
                                                    Mask:###,###,###.00 Notes:
                                                    {ARS[8]}
      25  RetentionAmt. . . . . . . . . 13.2  NNN  Retention Amount. . . . . . . .AMOUNT
                                                    Mask:###,###,###.00 Notes:
                                                    {ARS[9]}
      26  DateUpdated . . . . . . . . .     8 SNN  Last Update Date. . . . . . . .DATE
                                                    Read Only:Y Notes: YYYYMMDD
      27  TimeUpdated . . . . . . . . .     8 SNN  Last Update Time. . . . . . . .
                                                    Read Only:Y
      28  UserUpdatedKey. . . . . . . .    10 SYN  Last Update User ID . . . . . .USER
                                                    Read Only:Y Mask:0000000000
                                                    FmtType:ZEROFILL