Module List > Module RM tables RM00301
You are currently viewing the COMPANY database.
Change

COMPANY..RM00301 Table Definition

(COMPANY..RM Salesperson Master)

The RM Salesperson Master stores salespeople for vendors and your company.

This table contains information used to define a salesperson record. One record is stored in the table for each salesperson. Year to date and life to date information for the salesperson is also stored in this table.


4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
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
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3