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

COMPANY..PAM30601 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
JOBTYPE smallint
0

HOLDJOB tinyint
0

CUSTNMBR char
''
Customer c...(more) Join Now
DIVISID char
''

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

ADRSCODE char
''
This field...(more) Join Now
PERIODID smallint
0

FRSTNAME char
''

LASTNAME char
''
Last Name:...(more) Join Now WC010300.LASTNAME
POSITION_ID char
''

POSITION_DESCRIPTION char
''

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

TOTALFEE numeric
0.00

YEAR1 smallint
0
Year...(more) Join Now SY40101.YEAR1
FEE_PERCENT smallint
0

GUARANTEE tinyint
0

BASE_SALARY numeric
0.00

PACKAGE numeric
0.00

DSCPCTAM smallint
0
Discount P...(more) Join Now
Consultant_ID char
''

SBU char
''

Office_ID char
''

DOCDATE datetime
'1/1/1900'
The date a...(more) Join Now RM20101.DOCDATE
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
''

MKDTOPST tinyint
0

USERID char
''
The user t...(more) Join Now WRS10001.USERID
INVFORMT char
''

JRNENTRY int
0

POSTEDDT datetime
'1/1/1900'
Posted Date The system date at the time the transaction iso psted B3950340.POSTEDDT
PTDUSRID char
''

INVCDDT datetime
'1/1/1900'

INVOICBY char
''

INVCNMBR char
''

INVCJRNL int
0

Retainer_Job_Number char
''

PORDNMBR char
''
Purchase O...(more) Join Now JC00701.PORDNMBR
TAXSCHID char
''

PAM_WH_CHANGED tinyint
0

Contact_ID char
''

CURNCYID char
''
Currency I...(more) Join Now MC40200.CURNCYID
CURRNIDX smallint
0
Currency I...(more) Join Now
PYMTRMID char
''
Payment Te...(more) Join Now RM50105.PYMTRMID
SY033... more text available
EXCHDATE datetime
'1/1/1900'
Exchange D...(more) Join Now
XCHGRATE numeric
0.00
Exchange R...(more) Join Now MC00100.XCHGRATE
EXGTBLID char
''
Exchange T...(more) Join Now MC00100.EXGTBLID
TIME1 datetime
'1/1/1900'
Time Time...(more) Join Now WO010213.TIME1
RATETPID char
''

RTCLCMTD smallint
0
Rate calcu...(more) Join Now MC40300.RTCLCMTD
DENXRATE numeric
0.00
Exchange R...(more) Join Now
OTOTALFE numeric
0.00

OBASESALARY numeric
0.00

OPACKAGe numeric
0.00

MC_Processed tinyint
0

PAM_Invoice_Grouping char
''

PAM_Original_Cost numeric
0.00

VENDORID char
''
Vendor ID ...(more) Join Now WC010931.VENDORID
VCHRNMBR char
''
Voucher Nu...(more) Join Now PP100101.VCHRNMBR
DOCTYPE smallint
0
Document T...(more) Join Now PM30200.DOCTYPE
STATE char
''

PAMProjectID char
''

Account_Manager char
''

PAM_Service_Code char
''

GLPOSTDT datetime
'1/1/1900'
Date that ...(more) Join Now
Email_Address 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