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

COMPANY..PAM10505 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
DSCRIPTN char
''

TEMPSTAT char
''

CNTCPRSN char
''
Contact pe...(more) Join Now
Contact_Position char
''

ADRSCODE char
''
This field...(more) Join Now
DIVISID char
''

PERIODID smallint
0

STARTDT datetime
'1/1/1900'

EXPTDEND datetime
'1/1/1900'

ACTEND datetime
'1/1/1900'

YEAR1 smallint
0
Year...(more) Join Now SY40101.YEAR1
CREATDDT datetime
'1/1/1900'
Date this ...(more) Join Now RM00102.CREATDDT
CREATUSR char
''

MODIFDT datetime
'1/1/1900'
Date the r...(more) Join Now WDC41400.MODIFDT
MDFUSRID char
''
User that ...(more) Join Now SY40500.MDFUSRID
USRDEFS1 char
''

USRDEFS2 char
''

USERAMT1 numeric
0.00

USERAMT2 numeric
0.00

USRDAT01 datetime
'1/1/1900'

USRDAT02 datetime
'1/1/1900'

ACCSETID char
''

INVFORMT char
''

CALC881 tinyint
0

EXTOFJOB char
''

JOBDURTN int
0

CONTCONT tinyint
0

CLNTCONT tinyint
0

MARGINRT numeric
0.00

PRTAPPLY tinyint
0

CONTVALU numeric
0.00

Consultant_ID char
''

DAYPERWK int
0

HRSPERWK int
0

PORDNMBR char
''
Purchase O...(more) Join Now JC00701.PORDNMBR
PODATE datetime
'1/1/1900'

POAMOUNT numeric
0.00

POBALNCE numeric
0.00

PO_Hours int
0

AWARDID char
''

TAXSCHID char
''

INVCFREQ smallint
0

Office_ID char
''

SBU char
''

STATECD char
''
State Code...(more) Join Now W200006.STATECD
LOCALTAX char
''

WRKRCOMP char
''
Workers Co...(more) Join Now JC00701.WRKRCOMP
HOLD tinyint
0

HOLDCDID char
''

WEBTS_JOB_ENABLED tinyint
0

PAM_Calculate_Discounts tinyint
0

PAM_Discount_ID char
''

PAM_Discount_Percent smallint
0

PR_Apply_Fed_Rules tinyint
0

PR_OTBillType smallint
0

PR_OTPayTypeID char
''

PR_OTRegPayTypeID char
''

PR_DTBillType smallint
0

PR_DTPayTypeID char
''

PR_DTRegPayTypeID char
''

Contact_ID char
''

Flat_Rate_Billing tinyint
0

Flat_Rate_Bill_Amount numeric
0.00

ADDRESS1 char
''

ADDRESS2 char
''

ADDRESS3 char
''

CITY char
''

ZIP char
''

CURNCYID char
''
Currency I...(more) Join Now MC40200.CURNCYID
PAMProjectID char
''

PAM_Service_Code char
''

ADRCNTCT char
''

PAM_TimesheetFormat smallint
0

LOCLCODE char
''

Local_Code_Long_Name char
''

Email_Address char
''

PAM_Latitude numeric
0.00

PAM_Longitude numeric
0.00

FO_Job_Number char
''

PAYROLLED tinyint
0

PAM_VMS_Fee_ID char
''

PAM_VMS_Fee_Percent smallint
0

PayCycleID 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