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$