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$