AR_SalespersonHistory AR Salesperson History Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: AR_SalespersonHistory_bus,AR_CashReceiptsJournal_upd,AR_SalesJournal_upd,SO_SalesJournal_upd,A
SQL Def: N SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_SalespersonHistory.M4T"
KPRIMARY: SalespersonDivisionNo+SalespersonNo+FiscalYear+FiscalPeriod
KALTERNATE: FiscalYear+FiscalPeriod+SalespersonDivisionNo+SalespersonNo
KYEARPERIOD: FiscalYear(d**)+FiscalPeriod+SalespersonDivisionNo+SalespersonNo **=Case Sensitive
Fld Column Name M/L TUR Description/Notes Class
1 SalespersonDivisionNo . . . . 2 SNY Salesperson Division Number . .ARDIVISION
Mask:00 FmtType:ZEROFILL
Notes: {ARH$(1,2)}
2 SalespersonNo . . . . . . . . 4 SYY Salesperson Number. . . . . . .SALESPERSONNO
FmtType:CHARNUM Notes:
{ARH$(3,4)}
3 FiscalYear. . . . . . . . . . 4 SNY Fiscal Year . . . . . . . . . .YEAR
Mask:0000
4 FiscalPeriod. . . . . . . . . 2 SNY Fiscal Period . . . . . . . . .FISCALPERIOD
Mask:00
5 CommissionDollarsSold . . . . 15.2 NNN Commission Dollars Sold . . . .
Mask:##,###,###,###.00-
6 GrossProfitAmt. . . . . . . . 15.2 NNN Gross Profit Amount . . . . . .
Mask:##,###,###,###.00-
7 CommissionAmt . . . . . . . . 15.2 NNN Commission Amount . . . . . . .
Mask:##,###,###,###.00-
8 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
9 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y
10 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL