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$