Module List > Module TM tables Contract
You are currently viewing the COMPANY database.
Change

COMPANY..Contract Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
TB_Contract_# char
''

TB_Contract_Name char
''

CUSTNMBR char
''
Customer N...(more) Join Now PA01101.CUSTNMBR
join ... more text available
TB_Contract_PO_# char
''

TB_Contract_Cust_Bill_Ad char
''

TB_Contract_Cust_Dept_Ad char
''

TB_Cont_Reg_Bill numeric
0.00

TB_Cont_OT_Bill numeric
0.00

TB_Cont_OT_Wk_Bill numeric
0.00

TB_Cont_Other_Bill numeric
0.00

EMPLOYID char
''
Employee I...(more) Join Now PA11801.EMPLOYID
join ... more text available
DEPRTMNT char
''
Department...(more) Join Now WC010931.DEPRTMNT
join ... more text available
JOBTITLE char
''

TB_Cont_Reg_Time char
''

TB_Cont_Reg_Rate numeric
0.00

TB_Contract_Regular_Actu numeric
0.00

TB_Cont_OT_Daily tinyint
0

TB_Contract_Pay_Daily_OT numeric
0.00

TB_Cont_OT_Pay_Code char
''

TB_Cont_OT_Pay_Rate numeric
0.00

TB_Contract_OT_Daily_Act numeric
0.00

TB_Cont_OT_Wk_Paid tinyint
0

TB_Contract_Pay_Week_OT numeric
0.00

TB_Cont_OT_Wk_Code char
''

TB_Cont_OT_Wk_Rate numeric
0.00

TB_Cont_OT_Wkly_Act numeric
0.00

TB_Cont_Other_Paid tinyint
0

TB_Cont_Other_Code char
''

TB_Cont_Other_Rate numeric
0.00

TB_Cont_Other_Act numeric
0.00

TB_Contract_Status smallint
0

TB_Contract_Date datetime
'1/1/1900'

TB_Contract_Start_Daste datetime
'1/1/1900'

TB_Contract_End_Date datetime
'1/1/1900'

NOTEINDX numeric
0.00
Note Index...(more) Join Now
join ... more text available
MDFUSRID char
''
User that ...(more) Join Now
join ... more text available
AA_Modify_Date datetime
'1/1/1900'

AA_Modify_Time datetime
'1/1/1900'

TB_Contract_Sort char
''

TB_TC_Detail_Logbk tinyint
0

DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
AA_Coment_Text text


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