AR_CustomerSalespersonHistory AR Customer Salesperson HistoryRel: 4.40 Bld: 398 8/28/2009
Bus Obj: AR_SalesJournal_upd,SO_SalesJournal_upd,AR_CommissionEditRegister_upd,AR_CustomerSalespersonHi
SQL Def: Y SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_CustomerSalespersonHistory.m4T"
KPRIMARY: SalespersonDivisionNo+SalespersonNo+ARDivisionNo+CustomerNo+FiscalYear+FiscalPeriod
KALTERNATE: FiscalYear+FiscalPeriod+SalespersonDivisionNo+SalespersonNo+ARDivisionNo+CustomerNo
KYEARPERIOD: FiscalYear(d**)+FiscalPeriod+SalespersonDivisionNo+SalespersonNo+ARDivisionNo+CustomerNo
**=Case Sensitive
KCUSTOMER: ARDivisionNo+CustomerNo+SalespersonDivisionNo+SalespersonNo+FiscalYear+FiscalPeriod
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 ARDivisionNo. . . . . . . . . 2 SNY AR Division Number. . . . . . .ARDIVISION
Mask:00 FmtType:ZEROFILL
Notes: {ARH$(7,2)}
4 CustomerNo. . . . . . . . . . 20 SYY Customer Number . . . . . . . .CUSTOMERNO
FmtType:MASTERNUMC ChngTag:Re
place1/ARDivisionNo$ Notes:
{ARH$(9,7)}
5 FiscalYear. . . . . . . . . . 4 SNY Fiscal Year . . . . . . . . . .YEAR
Mask:0000
6 FiscalPeriod. . . . . . . . . 2 SNY Fiscal Period . . . . . . . . .FISCALPERIOD
Mask:00
7 DollarsSold . . . . . . . . . 15.2 NNN Dollars Sold. . . . . . . . . .
Mask:##,###,###,###.00-
ChngTag:Sum
8 CostOfGoodsSold . . . . . . . 15.2 NNN Cost Of Goods Sold. . . . . . .
Mask:##,###,###,###.00-
ChngTag:Sum
9 DateUpdated . . . . . . . . . 8 SNN Date Updated. . . . . . . . . .DATE
Read Only:Y ChngTag:Max
Notes: YYYYMMDD
10 TimeUpdated . . . . . . . . . 8 SNN Time Updated. . . . . . . . . .
Read Only:Y ChngTag:CopyMax/D
ateUpdated$
11 UserUpdatedKey. . . . . . . . 10 SNN User. . . . . . . . . . . . . .USER
Read Only:Y Mask:0000000000
ChngTag:CopyMax/DateUpdated$