| SLPRSNID |
char(15)
''
|
The salesp...(more) Join Now
|
|
|
|
| EMPLOYID |
char(15)
''
|
Employee I...(more) Join Now
|
|
|
join ... more text available
|
| VENDORID |
char(15)
''
|
The Vendor...(more) Join Now
|
|
|
join ... more text available
|
| SLPRSNFN |
char(15)
''
|
Salesperso...(more) Join Now
|
|
|
|
| SPRSNSMN |
char(15)
''
|
Salesperso...(more) Join Now
|
|
|
|
| SPRSNSLN |
char(21)
''
|
Salesperso...(more) Join Now
|
|
|
|
| ADDRESS1 |
char(61)
''
|
Address li...(more) Join Now
|
|
|
|
| ADDRESS2 |
char(61)
''
|
Address li...(more) Join Now
|
|
|
|
| ADDRESS3 |
char(61)
''
|
Address li...(more) Join Now
|
|
|
|
| CITY |
char(35)
''
|
City: City...(more) Join Now
|
|
|
|
| STATE |
char(29)
''
|
4 characte...(more) Join Now
|
|
|
|
| ZIP |
char(11)
''
|
Postal Cod...(more) Join Now
|
|
|
|
| COUNTRY |
char(61)
''
|
Country: C...(more) Join Now
|
|
|
|
| PHONE1 |
char(21)
''
|
10 digit p...(more) Join Now
|
|
|
|
| PHONE2 |
char(21)
''
|
Phone 2: ...(more) Join Now
|
|
|
|
| PHONE3 |
char(21)
''
|
Phone 3: ...(more) Join Now
|
|
|
|
| FAX |
char(21)
''
|
Fax: Same...(more) Join Now
|
|
|
|
| INACTIVE |
tinyint
0
|
1 if inact...(more) Join Now
|
|
|
|
| SALSTERR |
char(15)
''
|
Territory ...(more) Join Now
|
|
|
join ... more text available
|
| COMMCODE |
char(15)
''
|
Not used (...(more) Join Now
|
|
|
|
| COMPRCNT |
smallint
0
|
Percent co...(more) Join Now
|
|
|
|
| STDCPRCT |
smallint
0
|
Not used (...(more) Join Now
|
|
|
|
| COMAPPTO |
smallint
0
|
Commission...(more) Join Now
|
|
|
|
| COSTTODT |
numeric(19,5)
0.00
|
Cost of go...(more) Join Now
|
|
|
|
| CSTLSTYR |
numeric(19,5)
0.00
|
Cost of go...(more) Join Now
|
|
|
|
| TTLCOMTD |
numeric(19,5)
0.00
|
Commission...(more) Join Now
|
|
|
|
| TTLCOMLY |
numeric(19,5)
0.00
|
Commission...(more) Join Now
|
|
|
|
| COMSLTDT |
numeric(19,5)
0.00
|
The dollar...(more) Join Now
|
|
|
|
| COMSLLYR |
numeric(19,5)
0.00
|
Total amou...(more) Join Now
|
|
|
|
| NCOMSLTD |
numeric(19,5)
0.00
|
Sales Amou...(more) Join Now
|
|
|
|
| NCOMSLYR |
numeric(19,5)
0.00
|
Sales Amou...(more) Join Now
|
|
|
|
| KPCALHST |
tinyint
0
|
1 to keep ...(more) Join Now
|
|
|
|
| KPERHIST |
tinyint
0
|
1 to keep ...(more) Join Now
|
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| MODIFDT |
datetime
'1/1/1900'
|
Date the r...(more) Join Now
|
|
|
|
| CREATDDT |
datetime
'1/1/1900'
|
Date this ...(more) Join Now
|
|
|
|
| COMMDEST |
smallint
0
|
Not on the...(more) Join Now
|
|
|
|
| DEX_ROW_TS |
datetime
(getutcdate())
|
Time Stamp...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|