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