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