Module List >
Module RM tables
RM00303
You are currently viewing the COMPANY
database.
Change
|
COMPANY..RM00303 Table Definition
(COMPANY..Sales Territory Master File)
Field Definitions:
What is the 'source' column?
| SALSTERR |
char(15)
''
|
Territory ...(more) Join Now
|
|
|
|
| SLTERDSC |
char(31)
''
|
|
|
|
|
| INACTIVE |
tinyint
0
|
1 if inact...(more) Join Now
|
|
|
|
| SLPRSNID |
char(15)
''
|
The salesp...(more) Join Now
|
|
|
join ... more text available
|
| STMGRFNM |
char(15)
''
|
|
|
|
|
| STMGRMNM |
char(15)
''
|
|
|
|
|
| STMGRLNM |
char(21)
''
|
|
|
|
|
| COUNTRY |
char(61)
''
|
Country: C...(more) Join Now
|
RM00101.COUNTRY
|
|
|
| COSTTODT |
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
|
|
|
|
| NCOMSLYR |
numeric(19,5)
0.00
|
Sales Amou...(more) Join Now
|
|
|
|
| COMSLLYR |
numeric(19,5)
0.00
|
Total amou...(more) Join Now
|
|
|
|
| CSTLSTYR |
numeric(19,5)
0.00
|
Cost of go...(more) Join Now
|
|
|
|
| COMSLTDT |
numeric(19,5)
0.00
|
The dollar...(more) Join Now
|
|
|
|
| NCOMSLTD |
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
|
|
|
|
| DEX_ROW_TS |
datetime
(getutcdate())
|
Time Stamp...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|