Module List > Module PAM tables PAM00701
You are currently viewing the COMPANY database.
Change

COMPANY..PAM00701 Table Definition

(COMPANY..)
Salesperson master
4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
Consultant_ID char
''

SLPRSNFN char
''

SPRSNSLN char
''

SPRSNSMN char
''

Office char
''

SBU char
''

PHONE1 char
''

PHONE2 char
''

FAX char
''

Email_Address char
''

INACTIVE tinyint
0

Consultant_Type smallint
0

USERDEF1 char
''
UserDefine...(more) Join Now JC00701.USERDEF1
USERDEF2 char
''
UserDefine...(more) Join Now JC00701.USERDEF2
USRDEF03 char
''

USRDEF04 char
''

USRDEF05 char
''

ACSEGMNT char
''

Account_Manager char
''

SPDHCashCommPlanID char
''

SPDHRevCommPlanID char
''

RecDHCashCommPlanID char
''

RecDHRevCommPlanID char
''

RecTempCommPlanID char
''

SPTempCommPlanID char
''

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