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$