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

COMPANY..PAM30523 Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
JOBNUMBR char
''
Job Number...(more) Join Now SF010601.JOBNUMBR
CUSTNMBR char
''
Customer c...(more) Join Now
TEMPID char
''

Consultant_ID char
''

Office_ID char
''

SBU char
''

STRTDATE datetime
'1/1/1900'
Start Date...(more) Join Now
ENDDATE datetime
'1/1/1900'
End Date ...(more) Join Now
Split smallint
0

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

USRDEF04 char
''

USRDAT01 datetime
'1/1/1900'

USRDAT02 datetime
'1/1/1900'

USERAMT1 numeric
0.00

USERAMT2 numeric
0.00

User_Defined_Amount_3 numeric
0.00

User_Defined_Amount_4 numeric
0.00

PAM_UD_Amounts_1 numeric
0.00

PAM_UD_Amounts_2 numeric
0.00

PAM_UD_Amounts_3 numeric
0.00

PAM_UD_Amounts_4 numeric
0.00

PAM_UD_Amounts_5 numeric
0.00

PAM_UD_Amounts_6 numeric
0.00

PAM_UD_Dates_1 datetime
'1/1/1900'

PAM_UD_Dates_2 datetime
'1/1/1900'

PAM_UD_Dates_3 datetime
'1/1/1900'

PAM_UD_Dates_4 datetime
'1/1/1900'

PAM_UD_Dates_5 datetime
'1/1/1900'

PAM_UD_Dates_6 datetime
'1/1/1900'

PAM_UD_Dates_7 datetime
'1/1/1900'

PAM_UD_Dates_8 datetime
'1/1/1900'

PAM_UD_STR20_1 char
''

PAM_UD_STR20_2 char
''

PAM_UD_STR20_3 char
''

PAM_UD_STR20_4 char
''

PAM_UD_STR20_5 char
''

PAM_UD_STR20_6 char
''

CommissionType smallint
0

CommissionPlanID 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