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

COMPANY..PAM30504 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
''

Temporary_Name char
''

Temp_Rate numeric
0.00

Client_Rate numeric
0.00

ENDDATE datetime
'1/1/1900'
End Date ...(more) Join Now
Temporary_Main tinyint
0

POSITION_ID char
''

STRTDATE datetime
'1/1/1900'
Start Date...(more) Join Now
TIMEID char
''

PYTIMEID char
''

CREATDDT datetime
'1/1/1900'
Date this ...(more) Join Now RM00102.CREATDDT
CRUSRID char
''

MODIFDT datetime
'1/1/1900'
Date the r...(more) Join Now WDC41400.MODIFDT
MODTIME datetime
'1/1/1900'

MDFUSRID char
''
User that ...(more) Join Now SY40500.MDFUSRID
Forecast_Hours int
0

Recruiter char
''

Primary_Placement tinyint
0

Salaried tinyint
0

PR_Over40 smallint
0

SEQNUMBR int
0
Sequence N...(more) Join Now SEE30303.SEQNUMBR
Creditor_Currency_ID char
''

Creditor_Currency_Index smallint
0

NOTEINDX numeric
0.00
Note Index...(more) Join Now
PAM_Vendor_Cost numeric
0.00

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