| 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
|
|
|
|