Module List >
Module JC tables
JC01001
You are currently viewing the COMPANY
database.
Change
|
COMPANY..JC01001 Table Definition
(COMPANY..JC_Change_Orders_MSTR)
Field Definitions:
What is the 'source' column?
| WS_Job_Number |
char(17)
|
|
|
|
|
| Project_Number |
char(17)
|
|
|
|
|
| Change_Order_Nbr |
char(15)
|
|
|
|
|
| Change_Order_Status |
smallint
|
|
|
|
|
| Chg_Order_Description |
char(31)
|
|
|
|
|
| Change_Order_Type |
smallint
|
|
|
|
|
| Change_Order_Est_Cost |
numeric(19,5)
|
|
|
|
|
| Confirmed_Modified_Date |
datetime
|
|
|
|
|
| Orig_Change_Order_Amt |
numeric(19,5)
|
|
|
|
|
| XCHGRATE |
numeric(19,7)
|
Exchange R...(more) Join Now
|
CM20200.XCHGRATE
|
|
|
| EXCHDATE |
datetime
|
Exchange D...(more) Join Now
|
CM20200.EXCHDATE
|
|
|
| RATETPID |
char(15)
|
A valid Ra...(more) Join Now
|
|
|
|
| EXGTBLID |
char(15)
|
Exchange T...(more) Join Now
|
CM20200.EXGTBLID
|
|
|
| TIME1 |
datetime
|
Time see ...(more) Join Now
|
CM20200.TIME1
|
|
|
| Confirmed_Modified_Time |
datetime
|
|
|
|
|
| Confirmed_Mod_UserID |
char(15)
|
|
|
|
|
| In_Process_Mod_Date |
datetime
|
|
|
|
|
| In_Process_Mod_Time |
datetime
|
|
|
|
|
| In_Process_Mod_User_ID |
char(15)
|
|
|
|
|
| CO_UD1_Modified_Date |
datetime
|
|
|
|
|
| CO_UD1_Modified_Time |
datetime
|
|
|
|
|
| CO_UD1_Modified_UserID |
char(15)
|
|
|
|
|
| CO_UD2_Modified_Date |
datetime
|
|
|
|
|
| CO_UD2_Modified_Time |
datetime
|
|
|
|
|
| CO_UD2_Modified_UserID |
char(15)
|
|
|
|
|
| CO_UD3_Modified_Date |
datetime
|
|
|
|
|
| CO_UD3_Modified_Time |
datetime
|
|
|
|
|
| CO_UD3_Modified_UserID |
char(15)
|
|
|
|
|
| User_Defined_CO_1 |
char(15)
|
|
|
|
|
| User_Defined_CO_2 |
char(15)
|
|
|
|
|
| User_Defined_CO_3 |
char(15)
|
|
|
|
|
| User_Defined_CO_4 |
char(15)
|
|
|
|
|
| USRDAT01 |
datetime
|
|
|
|
|
| USRDAT02 |
datetime
|
|
|
|
|
| User_Defined_Date_3 |
datetime
|
|
|
|
|
| User_Defined_Date_4 |
datetime
|
|
|
|
|
| Est_Equipment_Cost |
numeric(19,5)
|
|
|
|
|
| Est_Labor_Cost |
numeric(19,5)
|
|
|
|
|
| Est_Labor_Units_TTD |
numeric(19,5)
|
|
|
|
|
| PAYRATE |
numeric(19,5)
|
|
|
|
|
| Est_Material_Cost |
numeric(19,5)
|
|
|
|
|
| Est_Misc_Other_Cost |
numeric(19,5)
|
|
|
|
|
| Est_Subs_Cost |
numeric(19,5)
|
|
|
|
|
| Est_Cost_UserDef1 |
numeric(19,5)
|
|
|
|
|
| Est_Cost_UserDef2 |
numeric(19,5)
|
|
|
|
|
| Est_Cost_UserDef3 |
numeric(19,5)
|
|
|
|
|
| Est_Cost_UserDef4 |
numeric(19,5)
|
|
|
|
|
| Total_Estimated_Cost |
numeric(19,5)
|
|
|
|
|
| Production_Estimate_Qty |
numeric(19,5)
|
|
|
|
|
| Estimated_Markup |
numeric(19,5)
|
|
|
|
|
| WS_Markup_Percent |
int
|
|
|
|
|
| PSTGSTUS |
smallint
|
Posting St...(more) Join Now
|
RM10301.PSTGSTUS
|
|
|
| PSTGDATE |
datetime
|
Posting Da...(more) Join Now
|
PM10000.PSTGDATE
|
|
|
| Change_Order_Maximum_Amt |
numeric(19,5)
|
|
|
|
|
| USERID |
char(15)
|
The user t...(more) Join Now
|
|
|
join ... more text available
|
| User_Define_1 |
char(31)
|
|
|
|
|
| User_Define_2 |
char(31)
|
|
|
|
|
| USERDEF1 |
char(21)
|
UserDefine...(more) Join Now
|
|
|
|
| USERDEF2 |
char(21)
|
UserDefine...(more) Join Now
|
|
|
|
| User_Def_Integer_1 |
int
|
|
|
|
|
| User_Def_Integer_2 |
int
|
|
|
|
|
| User_Defined_Integer_3 |
int
|
|
|
|
|
| User_Defined_Integer_4 |
int
|
|
|
|
|
| User_Defined_Dollar_1 |
numeric(19,5)
|
|
|
|
|
| User_Defined_Dollar_2 |
numeric(19,5)
|
|
|
|
|
| User_Defined_Dollar_3 |
numeric(19,5)
|
|
|
|
|
| User_Defined_Dollar_4 |
numeric(19,5)
|
|
|
|
|
| User_Defined_CB_1 |
tinyint
|
|
|
|
|
| User_Defined_CB_2 |
tinyint
|
|
|
|
|
| User_Defined_CB_3 |
tinyint
|
|
|
|
|
| User_Defined_CB_4 |
tinyint
|
|
|
|
|
| Wennsoft_Affiliate |
char(15)
|
|
|
|
|
| Wennsoft_Branch |
char(15)
|
|
|
|
|
| Wennsoft_Region |
char(15)
|
|
|
|
|
| MODIFDT |
datetime
|
Date the r...(more) Join Now
|
|
|
|
| Modified_Time |
datetime
|
|
|
|
|
| MDFUSRID |
char(15)
|
User that ...(more) Join Now
|
|
|
join ... more text available
|
| SV_Language_ID |
smallint
|
|
|
|
|
| Time_Zone |
char(3)
|
|
|
|
|
| WSReserved_CB1 |
tinyint
|
|
|
|
|
| WSReserved_CB2 |
tinyint
|
|
|
|
|
| WSReserved_CB3 |
tinyint
|
|
|
|
|
| WSReserved_CB4 |
tinyint
|
|
|
|
|
| WSReserved_CB5 |
tinyint
|
|
|
|
|
| WSReserved_STR1 |
char(11)
|
|
|
|
|
| WSReserved_STR2 |
char(11)
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|