AR_Salesperson                      AR Salesperson Master             Rel: 4.40  Bld: 398  8/28/2009
 Bus Obj: AR_Salesperson_bus
 SQL Def: N  SysDB: N                                        "MAS_"+%C$+"/AR"+%C$+"/AR_Salesperson.M4T"

 KPRIMARY: SalespersonDivisionNo+SalespersonNo
 KCRMUSER: CRMUserID
 KUSERKEY: UserKey

 Fld  Column Name                     M/L TUR  Description/Notes              Class

   1  SalespersonDivisionNo . . . .     2 SNY  Salesperson Division Number . .ARDIVISION
                                                Mask:00 FmtType:ZEROFILL
                                                Notes: {ARD$(1,2)}
   2  SalespersonNo . . . . . . . .     4 SYY  Salesperson Number. . . . . . .SALESPERSONNO
                                                FmtType:CHARNUM Notes:
                                                {ARD$(3,4)}
   3  SalespersonName . . . . . . .    30 SNN  Salesperson Name. . . . . . . .NAME
                                                Notes: {ARD$(7,30)}
   4  AddressLine1. . . . . . . . .    30 SNN  Address Line 1. . . . . . . . .ADDRESSLINE
                                                Notes: {ARD$(37,30)}
   5  AddressLine2. . . . . . . . .    30 SNN  Address Line 2. . . . . . . . .ADDRESSLINE
                                                Notes: {ARD$(67,30)}
   6  AddressLine3. . . . . . . . .    30 SNN  Address Line 3. . . . . . . . .ADDRESSLINE
                                                Notes: {ARD$(167,30)}
   7  City. . . . . . . . . . . . .    20 SNN  City. . . . . . . . . . . . . .CITY
                                                Notes: {ARD$(97,20)}
   8  State . . . . . . . . . . . .     2 SYN  State . . . . . . . . . . . . .STATE
                                                Notes: {ARD$(117,2)}
   9  ZipCode . . . . . . . . . . .    10 SYN  Zip Code. . . . . . . . . . . .ZIPCODE
                                                Notes: {ARD$(119,10)}
  10  CountryCode . . . . . . . . .     3 SYN  Country Code. . . . . . . . . .COUNTRY
                                                Notes: {ARD$(197,3)}
  11  TelephoneNo . . . . . . . . .    17 SNN  Telephone Number. . . . . . . .TELEPHONENO
                                                Notes: {ARD$(150,17)}
  12  TelephoneExt. . . . . . . . .     5 SNN  Telephone Ext . . . . . . . . .TELEPHONEEXT
                                                Notes: {ARD$(139,5)}
  13  EmailAddress. . . . . . . . .    50 SNN  Email Address . . . . . . . . .EMAILADDRESS
                                                Notes: {ARD$(200,50)}
  14  SalesManagerDivisionNo. . . .     2 SNN  Sales Manager AR Division NumbeARDIVISION
                                                Mask:00 FmtType:ZEROFILL
                                                Notes: {ARD$(144,2)}
  15  SalesManagerNo. . . . . . . .     4 SYN  Sales Manager Number. . . . . .SALESPERSONNO
                                                FmtType:CHARNUM DepVal:REQUIR
                                                ED Notes: {ARD$(146,4)}
  16  CRMUserID . . . . . . . . . .    11 SNN  CRM User ID . . . . . . . . . .
  17  UserKey . . . . . . . . . . .    10 SNN  User Key. . . . . . . . . . . .USER
                                                Mask:0000000000 DepVal:REQUIR
                                                ED
  18  CommissionRate. . . . . . . .  9.3  NNN  Salesperson Commission Rate . .COMMISSIONRATE
                                                Mask:###0.000 Notes: {ARD[0]}
  19  SalesManagerCommRate. . . . .  9.3  NNN  Sales Manager Commission Rate .COMMISSIONRATE
                                                Mask:###0.000 Notes:
                                                {ARD[10]}
  20  DateCreated . . . . . . . . .     8 SNY  Creation Date . . . . . . . . .DATE
                                                Read Only:Y Notes: YYYYMMDD
  21  TimeCreated . . . . . . . . .     8 SNY  Creation Time . . . . . . . . .
                                                Read Only:Y
  22  UserCreatedKey. . . . . . . .    10 SYY  Creation User ID. . . . . . . .USER
                                                Read Only:Y Mask:0000000000
                                                FmtType:ZEROFILL
  23  DateUpdated . . . . . . . . .     8 SNN  Last Update Date. . . . . . . .DATE
                                                Read Only:Y Notes: YYYYMMDD
  24  TimeUpdated . . . . . . . . .     8 SNN  Last Update Time. . . . . . . .
                                                Read Only:Y
  25  UserUpdatedKey. . . . . . . .    10 SYN  Last Update User ID . . . . . .USER
                                                Read Only:Y Mask:0000000000
                                                FmtType:ZEROFILL