     AR_SalespersonCommission               AR Salesperson Commission      Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: AR_CommissionEdit_bus,AR_CashReceiptsJournal_upd,AR_SalesJournal_upd,SO_SalesJournal_upd,AP_AR
     SQL Def: N  SysDB: N                              "MAS_"+%C$+"/AR"+%C$+"/AR_SalespersonCommission.M4T"

     KPRIMARY: SalespersonDivisionNo+SalespersonNo+ARDivisionNo+CustomerNo+InvoiceNo+InvoiceType
     KCUSTOMER: ARDivisionNo+CustomerNo

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  SalespersonDivisionNo . . . .     2 SNY  Salesperson Division Number . .ARDIVISION
                                                    Mask:00 FmtType:ZEROFILL
                                                    Notes: {ARE$(1,2)}
       2  SalespersonNo . . . . . . . .     4 SYY  Salesperson Number. . . . . . .SALESPERSONNO
                                                    FmtType:CHARNUM Notes:
                                                    {ARE$(3,4)}
       3  ARDivisionNo. . . . . . . . .     2 SNY  AR Division Number. . . . . . .ARDIVISION
                                                    Mask:00 FmtType:ZEROFILL
                                                    Notes: {ARE$(7,2)}
       4  CustomerNo. . . . . . . . . .    20 SYY  Customer Number . . . . . . . .CUSTOMERNO
                                                    FmtType:MASTERNUMC ChngTag:Re
                                                    place1/ARDivisionNo$ Notes:
                                                    {ARE$(9,7)}
       5  InvoiceNo . . . . . . . . . .     7 SYY  Invoice Number. . . . . . . . .INVOICE
                                                    FmtType:MASTERNUM Notes:
                                                    {ARE$(16,7)}
       6  InvoiceType . . . . . . . . .     2 SYY  Invoice Type. . . . . . . . . .
                                                    DfltVal:IN Valid:IN,CM,DM,CA,
                                                    FC Notes: CM=Credit Memo,
                                                    DM=Debit Memo, IN=INvoice,
                                                    CA=CAsh, FC=Finance Charge
                                                    00=will be switched to IN,
                                                    $$=will be switched to IN,
                                                    {ARE$(23,2)}
       7  InvoiceDate . . . . . . . . .     8 SNN  Invoice Date. . . . . . . . . .DATE
                                                    Notes: {ARE$(25,6)}
       8  PayDate . . . . . . . . . . .     8 SNN  Pay Date. . . . . . . . . . . .DATE
                                                    Notes: {ARE$(31,6)}
       9  ApplyToNo . . . . . . . . . .     7 SYN  Apply To Credit Memo/Debit Memo
                                                    FmtType:CHARNUM Notes: Only
                                                    applys to CM and DM {ARE$(37,
                                                    7)}
      10  HasCommRecordBeenEdited . . .     1 SYN  Has Commission Record Been EditYESNO
                                                    DfltVal:N Valid:Y,N Notes:
                                                    {AR_07$(25,1)}
      11  LinkUpdated . . . . . . . . .     1 SNN  Link Updated. . . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      12  CommissionRate. . . . . . . .  9.3  NYN  Commission Rate . . . . . . . .COMMISSIONRATE
                                                    Mask:###0.000 Notes: {ARE[0]}
      13  InvoiceTotal. . . . . . . . . 14.2  NNN  Invoice Total . . . . . . . . .SALESAMOUNT
                                                    Mask:#,###,###,###.00-
                                                    ChngTag:Sum Notes: {ARE[1]}
      14  SalesSubjectToComm. . . . . . 14.2  NNN  Sales Subject To Commission . .SALESAMOUNT
                                                    Mask:#,###,###,###.00-
                                                    ChngTag:Sum Notes: {ARE[2]}
      15  CostSubjectToComm . . . . . . 14.2  NNN  Cost Subject To Commission. . .SALESAMOUNT
                                                    Mask:#,###,###,###.00-
                                                    ChngTag:Sum Notes: {ARE[3]}
      16  CommissionAmt . . . . . . . . 14.2  NNN  Commission Amount . . . . . . .SALESAMOUNT
                                                    Mask:#,###,###,###.00-
                                                    ChngTag:Sum Notes: {ARE[4]}
      17  InvoiceAmountPaid . . . . . . 14.2  NNN  Invoice Amount Paid . . . . . .SALESAMOUNT
                                                    Mask:#,###,###,###.00-
                                                    ChngTag:Sum Notes: {ARE[5]}
      18  SplitCommPercent. . . . . . .  7.2  NNN  Split Commission Percentage . .
                                                    Mask:##0.00 Notes: {ARE[6]}
      19  DateUpdated . . . . . . . . .     8 SNN  Last Update Date. . . . . . . .DATE
                                                    Read Only:Y ChngTag:Max
                                                    Notes: YYYYMMDD
      20  TimeUpdated . . . . . . . . .     8 SNN  Last Update Time. . . . . . . .
                                                    Read Only:Y ChngTag:CopyMax/D
                                                    ateUpdated$
      21  UserUpdatedKey. . . . . . . .    10 SYN  Last Update User ID . . . . . .USER
                                                    Read Only:Y Mask:0000000000
                                                    FmtType:ZEROFILL ChngTag:Copy
                                                    Max/DateUpdated$