| WS_Job_Number |
char(17)
|
|
|
|
|
| Project_Number |
char(17)
|
|
|
|
|
| Cost_Code_Number_1 |
char(7)
|
|
|
|
|
| Cost_Code_Number_2 |
char(7)
|
|
|
|
|
| Cost_Code_Number_3 |
char(7)
|
|
|
|
|
| Cost_Code_Number_4 |
char(7)
|
|
|
|
|
| Cost_Code_Alias |
char(27)
|
|
|
|
|
| Cost_Code_Description |
char(31)
|
|
|
|
|
| Cost_Element |
smallint
|
|
|
|
|
| WS_Manager_ID |
char(15)
|
|
|
|
|
| WS_Inactive |
tinyint
|
0 = Active...(more) Join Now
|
|
|
|
| Profit_Type_Number |
smallint
|
1 = ...(more) Join Now
|
|
|
|
| Profit_Amount |
numeric(19,5)
|
|
|
|
|
| Type_of_Transaction |
smallint
|
|
|
|
|
| Next_Subdivision_Type |
smallint
|
|
|
|
|
| WS_Account_Index_1 |
int
|
|
|
|
|
| WS_Account_Index_2 |
int
|
|
|
|
|
| Added_By_CO_Module |
tinyint
|
|
|
|
|
| Track_Production_Qty |
tinyint
|
|
|
|
|
| Cost_Code_Act_Cost_TTD |
numeric(19,5)
|
|
|
|
|
| Cost_Code_Act_Cost_YTD |
numeric(19,5)
|
|
|
|
|
| Actual_Units_TTD |
numeric(19,5)
|
|
|
|
|
| Cost_Code_Estimated_Cst |
numeric(19,5)
|
|
|
|
|
| Change_Order_Est_Cost |
numeric(19,5)
|
|
|
|
|
| Cost_Code_Rvsd_Est_Cost |
numeric(19,5)
|
|
|
|
|
| Cost_Code_Forecast_Cost |
numeric(19,5)
|
|
|
|
|
| Cost_Code_Rvsd_Forecast |
numeric(19,5)
|
|
|
|
|
| Forecasted_Units |
numeric(19,5)
|
|
|
|
|
| Committed_Cost |
numeric(19,5)
|
|
|
|
|
| Committed_Units |
numeric(19,5)
|
|
|
|
|
| Cost_Code_Est_Unit |
numeric(19,5)
|
|
|
|
|
| Estimated_Amt_Units |
numeric(19,5)
|
|
|
|
|
| Production_Estimate_Qty |
numeric(19,5)
|
|
|
|
|
| Production_Actual_Qty |
numeric(19,5)
|
|
|
|
|
| Production_Qty_Unit |
numeric(19,5)
|
|
|
|
|
| Production_Qty_Curr_Per |
numeric(19,5)
|
|
|
|
|
| Production_Best |
numeric(19,5)
|
|
|
|
|
| Production_Best_Date |
datetime
|
|
|
|
|
| Production_Measure_Code |
char(7)
|
|
|
|
|
| OVHD1_UOM |
char(21)
|
|
|
|
|
| OVHD1_Type |
smallint
|
|
|
|
|
| OVHD1_Percent |
smallint
|
|
|
|
|
| OVHD1_Estimated_Units |
numeric(19,5)
|
|
|
|
|
| OVHD1_Actual_Units |
numeric(19,5)
|
|
|
|
|
| OVHD1_Forecasted_Units |
numeric(19,5)
|
|
|
|
|
| OVHD1_Amt_Per_Unit |
numeric(19,5)
|
|
|
|
|
| OVHD1_Estimated_Amount |
numeric(19,5)
|
|
|
|
|
| OVHD1_Actual_Amount |
numeric(19,5)
|
|
|
|
|
| OVHD1_Profit_Type |
smallint
|
|
|
|
|
| OVHD1_Profit_Amount |
numeric(19,5)
|
|
|
|
|
| OVHD2_UOM |
char(21)
|
|
|
|
|
| OVHD2_Type |
smallint
|
|
|
|
|
| OVHD2_Percent |
smallint
|
|
|
|
|
| OVHD2_Estimated_Units |
numeric(19,5)
|
|
|
|
|
| OVHD2_Actual_Units |
numeric(19,5)
|
|
|
|
|
| OVHD2_Forecasted_Units |
numeric(19,5)
|
|
|
|
|
| OVHD2_Amt_Per_Unit |
numeric(19,5)
|
|
|
|
|
| OVHD2_Estimated_Amount |
numeric(19,5)
|
|
|
|
|
| OVHD2_Actual_Amount |
numeric(19,5)
|
|
|
|
|
| OVHD2_Profit_Type |
smallint
|
|
|
|
|
| OVHD2_Profit_Amount |
numeric(19,5)
|
|
|
|
|
| Bill_Type |
smallint
|
|
|
|
|
| Sched_Completion_Date |
datetime
|
|
|
|
|
| ACTCOMPDATE |
datetime
|
|
|
|
|
| Schedule_Start_Date |
datetime
|
|
|
|
|
| ACTSTARTDATE |
datetime
|
|
|
|
|
| Billing_Schedule_Line |
char(9)
|
|
|
|
|
| Estimated_Measure_Code |
char(7)
|
|
|
|
|
| Amount_Pct_Complete |
smallint
|
|
|
|
|
| Units_Pct_Complete |
smallint
|
|
|
|
|
| Production_Pct_Complete |
smallint
|
|
|
|
|
| Field_Pct_Complete |
smallint
|
|
|
|
|
| Posted_To |
tinyint
|
|
|
|
|
| WRKRCOMP |
char(7)
|
Workers Co...(more) Join Now
|
|
|
|
| Change_Order_Est_Units |
numeric(19,5)
|
|
|
|
|
| Labor_Group_Name |
char(15)
|
|
|
|
|
| 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)
|
|
|
|
|
| USRDAT01 |
datetime
|
|
|
|
|
| USRDAT02 |
datetime
|
|
|
|
|
| User_Defined_Date_3 |
datetime
|
|
|
|
|
| User_Defined_Date_4 |
datetime
|
|
|
|
|
| User_Defined_CB_1 |
tinyint
|
|
|
|
|
| User_Defined_CB_2 |
tinyint
|
|
|
|
|
| User_Defined_CB_3 |
tinyint
|
|
|
|
|
| User_Defined_CB_4 |
tinyint
|
|
|
|
|
| VNDRNMBR |
char(25)
|
|
|
|
|
| ITEMNMBR |
char(31)
|
span style...(more) Join Now
|
|
|
join ... more text available
|
| PORDNMBR |
char(21)
|
Purchase O...(more) Join Now
|
|
|
|
| CC_Rvsd_Forecast_Units |
numeric(19,5)
|
|
|
|
|
| Rate_Per_Unit |
numeric(19,5)
|
|
|
|
|
| Original_Estimate_Units |
numeric(19,5)
|
|
|
|
|
| Original_Forecast_Units |
numeric(19,5)
|
|
|
|
|
| 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_CB6 |
tinyint
|
|
|
|
|
| WSReserved_CB7 |
tinyint
|
|
|
|
|
| WSReserved_CB8 |
tinyint
|
|
|
|
|
| WSReserved_CB9 |
tinyint
|
|
|
|
|
| WSReserved_CB10 |
tinyint
|
|
|
|
|
| WSReserved_STR1 |
char(11)
|
|
|
|
|
| WSReserved_STR2 |
char(11)
|
|
|
|
|
| Import_Journal_Number |
char(15)
|
|
|
|
|
| Import_Journal_Number_Count |
smallint
|
|
|
|
|
| Import_Status |
char(15)
|
|
|
|
|
| Import_Status_Descriptio |
char(89)
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|