| WS_Job_Number |
char(17)
|
|
|
|
|
| PERIODID |
smallint
|
Period ID:...(more) Join Now
|
GL20000.PERIODID
|
|
|
| YEAR1 |
smallint
|
Year: The ...(more) Join Now
|
GL00200.YEAR1
|
|
|
| Project_Number |
char(17)
|
|
|
|
|
| WS_Job_Name |
char(31)
|
|
|
|
|
| Divisions |
char(15)
|
|
|
|
|
| CUSTNMBR |
char(15)
|
Customer N...(more) Join Now
|
RM20101.CUSTNMBR
|
|
join ... more text available
|
| JC_Contract_Number |
char(15)
|
|
|
|
|
| Contract_Type |
smallint
|
1 = 'Fixed...(more) Join Now
|
|
|
|
| WS_Billing_Type |
smallint
|
1 = Standa...(more) Join Now
|
|
|
|
| Contract_to_Date |
numeric(19,5)
|
|
|
|
|
| Retention_Pct |
numeric(19,5)
|
|
|
|
|
| Actual_Units_TTD |
numeric(19,5)
|
|
|
|
|
| Act_Labor_Cost_TTD |
numeric(19,5)
|
|
|
|
|
| Act_Materials_Cost_TTD |
numeric(19,5)
|
|
|
|
|
| Act_Equipment_Cost_TTD |
numeric(19,5)
|
|
|
|
|
| Act_Subs_Cost_TTD |
numeric(19,5)
|
|
|
|
|
| Act_Misc_Other_Cost_TTD |
numeric(19,5)
|
|
|
|
|
| Act_Cost_TTD_UserDef1 |
numeric(19,5)
|
|
|
|
|
| Act_Cost_TTD_UserDef2 |
numeric(19,5)
|
|
|
|
|
| Act_Cost_TTD_UserDef3 |
numeric(19,5)
|
|
|
|
|
| Act_Cost_TTD_UserDef4 |
numeric(19,5)
|
|
|
|
|
| Total_Actual_Cost |
numeric(19,5)
|
|
|
|
|
| Orig_Contract_Amount |
numeric(19,5)
|
|
|
|
|
| Contract_Earned |
numeric(19,5)
|
|
|
|
|
| Contract_Earned_Curr_Mo |
numeric(19,5)
|
|
|
|
|
| Billed_Labor_TTD_Mkup |
numeric(19,5)
|
|
|
|
|
| Billed_Mat_Cst_TTD_Mkup |
numeric(19,5)
|
|
|
|
|
| Billed_EquipTTD_Mkup |
numeric(19,5)
|
|
|
|
|
| Billed_Subs_TTD_Mkup |
numeric(19,5)
|
|
|
|
|
| Billed_Other_TTD_Mkup |
numeric(19,5)
|
|
|
|
|
| Billed_UsrDef1_TTD_Mkup |
numeric(19,5)
|
|
|
|
|
| Billed_UsrDef2_TTD_Mkup |
numeric(19,5)
|
|
|
|
|
| Billed_UsrDef3_TTD_Mkup |
numeric(19,5)
|
|
|
|
|
| Billed_UsrDef4_TTD_Mkup |
numeric(19,5)
|
|
|
|
|
| Billed_Amount_TTD |
numeric(19,5)
|
|
|
|
|
| Retention_Amount_TTD |
numeric(19,5)
|
|
|
|
|
| Retention_Billed_TTD |
numeric(19,5)
|
|
|
|
|
| Net_Billed_TTD |
numeric(19,5)
|
|
|
|
|
| Cash_Received_TTD |
numeric(19,5)
|
|
|
|
|
| MSCTXAMT |
numeric(19,5)
|
Misc Tax A...(more) Join Now
|
POP30300.MSCTXAMT
|
|
|
| TAXAMNT |
numeric(19,5)
|
Tax Amount...(more) Join Now
|
RM20101.TAXAMNT
|
|
|
| DISCAMNT |
numeric(19,5)
|
|
|
|
|
| WROFAMNT |
numeric(19,5)
|
Write Off ...(more) Join Now
|
RM20101.WROFAMNT
|
|
|
| Last_Billing_Date |
datetime
|
|
|
|
|
| Expected_Contract |
numeric(19,5)
|
|
|
|
|
| Committed_Equipment_TTD |
numeric(19,5)
|
|
|
|
|
| Committed_Materials_TTD |
numeric(19,5)
|
|
|
|
|
| Committed_Labor_TTD |
numeric(19,5)
|
|
|
|
|
| Committed_Subs_TTD |
numeric(19,5)
|
|
|
|
|
| Committed_Other_TTD |
numeric(19,5)
|
|
|
|
|
| Committed_TTD_UserDef1 |
numeric(19,5)
|
|
|
|
|
| Committed_TTD_UserDef2 |
numeric(19,5)
|
|
|
|
|
| Committed_TTD_UserDef3 |
numeric(19,5)
|
|
|
|
|
| Committed_TTD_UserDef4 |
numeric(19,5)
|
|
|
|
|
| Committed_Cost |
numeric(19,5)
|
|
|
|
|
| Revsd_Equip_Forecasted |
numeric(19,5)
|
|
|
|
|
| Revsd_Labor_Forecasted |
numeric(19,5)
|
|
|
|
|
| Revsd_Materials_Forecst |
numeric(19,5)
|
|
|
|
|
| Revsd_Subs_Forecast_Cst |
numeric(19,5)
|
|
|
|
|
| Revsd_Other_Forecst_Cst |
numeric(19,5)
|
|
|
|
|
| Revsd_Forecast_UserDef1 |
numeric(19,5)
|
|
|
|
|
| Revsd_Forecast_UserDef2 |
numeric(19,5)
|
|
|
|
|
| Revsd_Forecast_UserDef3 |
numeric(19,5)
|
|
|
|
|
| Revsd_Forecast_UserDef4 |
numeric(19,5)
|
|
|
|
|
| Tot_Revsd_Forecast_Cost |
numeric(19,5)
|
|
|
|
|
| Confirmed_Chg_Order_Amt |
numeric(19,5)
|
|
|
|
|
| In_Process_Chg_Ord_Amt |
numeric(19,5)
|
|
|
|
|
| CO_Amount_UserDef1 |
numeric(19,5)
|
|
|
|
|
| CO_Amount_UserDef2 |
numeric(19,5)
|
|
|
|
|
| CO_Amount_UserDef3 |
numeric(19,5)
|
|
|
|
|
| Est_Labor_Units_TTD |
numeric(19,5)
|
|
|
|
|
| Act_Labor_Units_TTD |
numeric(19,5)
|
|
|
|
|
| Total_Act_Plus_Markup |
numeric(19,5)
|
|
|
|
|
| Revsd_Forecast_Lab_Units |
numeric(19,5)
|
|
|
|
|
| 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
|
|
|
|
|
| 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)
|
|
|
|
|
| Technician_ID |
char(15)
|
|
|
|
|
| Technician_Team |
char(15)
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|