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

COMPANY..RM00302 Table Definition

(COMPANY..Salesperson Master Summary File)

The summary file would not normally be imported into. The only reason normally would be to provide data for comparative purposes before this product was implemented.

This table contains financial summary information such as year to date, last year to date and life to date. One record is stored in the table for each salesperson. In SBM, this table is not available.


4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
SLPRSNID char(15)
''
The salesp...(more) Join Now
join ... more text available
HISTTYPE smallint
0
History Ty...(more) Join Now
PERIODID smallint
0
The period...(more) Join Now
YEAR1 smallint
0
The fiscal...(more) Join Now
COSTAMNT numeric(19,5)
0.00
Cost Amoun...(more) Join Now
TTLCOMAM numeric(19,5)
0.00
Dollar of ...(more) Join Now
COMSLTDT numeric(19,5)
0.00
The dollar...(more) Join Now
NCOMAMNT numeric(19,5)
0.00
The dollar...(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