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$