     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