| CUSTNMBR |
char(15)
|
Field Type...(more) Join Now
|
|
join ... more text available
|
| ADRSCODE |
char(15)
|
Field Type...(more) Join Now
|
|
|
| Contract_Number |
char(11)
|
|
|
|
| WSCONTSQ |
int
|
|
|
|
| Wennsoft_Affiliate |
char(15)
|
|
|
|
| Wennsoft_Region |
char(15)
|
|
|
|
| Wennsoft_Branch |
char(15)
|
|
|
|
| USERID |
char(15)
|
The user t...(more) Join Now
|
|
join ... more text available
|
| Technician_ID |
char(15)
|
|
|
|
| Technician_Team |
char(15)
|
|
|
|
| Technician |
char(11)
|
|
|
|
| CPRCSTNM |
char(15)
|
Corporate ...(more) Join Now
|
RM00101.CPRCSTNM
|
|
| Corporate_Contract_Nbr |
char(21)
|
|
|
|
| WSMSTRCONTSQ |
int
|
|
|
|
| Corporate_Invoice_Number |
char(17)
|
|
|
|
| Contract_Amount |
numeric(19,5)
|
|
|
|
| Bill_Freq |
smallint
|
|
|
|
| Wennsoft_Close_Date |
datetime
|
|
|
|
| Amount_Billed |
numeric(19,5)
|
|
|
|
| SLPRSNID |
char(15)
|
Field Type...(more) Join Now
|
|
join ... more text available
|
| Annual_Contract_Value |
numeric(19,5)
|
|
|
|
| Revenue_Rec_Method_ID |
smallint
|
|
|
|
| Invoice_Style |
smallint
|
|
|
|
| Multiyear_Contract_Flag |
tinyint
|
|
|
|
| Contract_Start_Date |
datetime
|
|
|
|
| Contract_Experation_Date |
datetime
|
|
|
|
| Forecast_Original_Equip |
numeric(19,5)
|
|
|
|
| Forecast_Original_Labor |
numeric(19,5)
|
|
|
|
| Fore_Orig_Material |
numeric(19,5)
|
|
|
|
| Forecast_Original_Other |
numeric(19,5)
|
|
|
|
| Forecast_Original_Subs |
numeric(19,5)
|
|
|
|
| Forecast_Orig_Labor_1 |
numeric(19,5)
|
|
|
|
| Forecast_Orig_Labor1_Hrs |
int
|
|
|
|
| Forecast_Orig_Labor_2 |
numeric(19,5)
|
|
|
|
| Fore_Orig_Labor_2_Hrs |
int
|
|
|
|
| Forecast_Orig_Labor_3 |
numeric(19,5)
|
|
|
|
| Forecast_Orig_Labor3_Hrs |
int
|
|
|
|
| Forecast_Orig_Labor_4 |
numeric(19,5)
|
|
|
|
| Forecast_Orig_Labor4_Hrs |
int
|
|
|
|
| Forecast_Orig_Labor_5 |
numeric(19,5)
|
|
|
|
| Forecast_Orig_Labor5_Hrs |
int
|
|
|
|
| Forecast_Orig_Tot_Labor |
numeric(19,5)
|
|
|
|
| Fore_Orig_Tot_Lbr_Hrs |
int
|
|
|
|
| Actual_Equipment |
numeric(19,5)
|
|
|
|
| Actual_Labor |
numeric(19,5)
|
|
|
|
| Actual_Material |
numeric(19,5)
|
|
|
|
| Actual_Subs |
numeric(19,5)
|
|
|
|
| Actual_Other |
numeric(19,5)
|
|
|
|
| Total_Cost_Tax |
numeric(19,5)
|
|
|
|
| Actual_Total_Cost |
numeric(19,5)
|
|
|
|
| Actual_Hours |
int
|
|
|
|
| Actual_Labor_1 |
numeric(19,5)
|
|
|
|
| Actual_Labor_1_Hours |
int
|
|
|
|
| Actual_Labor_2 |
numeric(19,5)
|
|
|
|
| Actual_Labor_2_Hours |
int
|
|
|
|
| Actual_Labor_3 |
numeric(19,5)
|
|
|
|
| Actual_Labor_3_Hours |
int
|
|
|
|
| Actual_Labor_4 |
numeric(19,5)
|
|
|
|
| Actual_Labor_4_Hours |
int
|
|
|
|
| Actual_Labor_5 |
numeric(19,5)
|
|
|
|
| Actual_Labor_5_Hours |
int
|
|
|
|
| Actual_Total_Labor |
numeric(19,5)
|
|
|
|
| Actual_Total_Labor_Hrs |
int
|
|
|
|
| Estimate_Equipment |
numeric(19,5)
|
|
|
|
| Estimate_Labor |
numeric(19,5)
|
|
|
|
| Estimate_Material |
numeric(19,5)
|
|
|
|
| Estimate_Subs |
numeric(19,5)
|
|
|
|
| Estimate_Other |
numeric(19,5)
|
|
|
|
| Estimate_Total_Cost |
numeric(19,5)
|
|
|
|
| Estimate_Hours |
int
|
|
|
|
| Estimate_Labor_1 |
numeric(19,5)
|
|
|
|
| Estimate_Labor_1_Hours |
int
|
|
|
|
| Estimate_Labor_2 |
numeric(19,5)
|
|
|
|
| Estimate_Labor_2_Hours |
int
|
|
|
|
| Estimate_Labor_3 |
numeric(19,5)
|
|
|
|
| Estimate_Labor_3_Hours |
int
|
|
|
|
| Estimate_Labor_4 |
numeric(19,5)
|
|
|
|
| Estimate_Labor_4_Hours |
int
|
|
|
|
| Estimate_Labor_5 |
numeric(19,5)
|
|
|
|
| Estimate_Labor_5_Hours |
int
|
|
|
|
| Estimate_Total_Labor |
numeric(19,5)
|
|
|
|
| Estimate_Total_Labor_Hrs |
int
|
|
|
|
| Forecast_Labor |
numeric(19,5)
|
|
|
|
| Forecast_Equipment |
numeric(19,5)
|
|
|
|
| Forecast_Material |
numeric(19,5)
|
|
|
|
| Forecast_Subs |
numeric(19,5)
|
|
|
|
| Forecast_Other |
numeric(19,5)
|
|
|
|
| Forecast_Total_Cost |
numeric(19,5)
|
|
|
|
| Forecast_Hours |
int
|
|
|
|
| Forecast_Labor_1 |
numeric(19,5)
|
|
|
|
| Forecast_Labor_1_Hours |
int
|
|
|
|
| Forecast_Labor_2 |
numeric(19,5)
|
|
|
|
| Forecast_Labor_2_Hours |
int
|
|
|
|
| Forecast_Labor_3 |
numeric(19,5)
|
|
|
|
| Forecast_Labor_3_Hours |
int
|
|
|
|
| Forecast_Labor_4 |
numeric(19,5)
|
|
|
|
| Forecast_Labor_4_Hours |
int
|
|
|
|
| Forecast_Labor_5 |
numeric(19,5)
|
|
|
|
| Forecast_Labor_5_Hours |
int
|
|
|
|
| Forecast_Total_Labor |
numeric(19,5)
|
|
|
|
| Forecast_Total_Labor_Hrs |
int
|
|
|
|
| Task_Est_Rollup_Group |
smallint
|
|
|
|
| Contract_Description |
char(31)
|
|
|
|
| User_Define_1a |
char(31)
|
|
|
|
| User_Define_2a |
char(31)
|
|
|
|
| User_Define_3a |
char(31)
|
|
|
|
| User_Define_4a |
char(31)
|
|
|
|
| Service_User_Define_3 |
char(31)
|
|
|
|
| Service_User_Define_5 |
int
|
|
|
|
| Service_User_Define_6 |
int
|
|
|
|
| Service_User_Define_9 |
datetime
|
|
|
|
| Service_User_Define_10 |
datetime
|
|
|
|
| Service_User_Define_18 |
tinyint
|
|
|
|
| Service_User_Define_19 |
tinyint
|
|
|
|
| Service_User_Define_22 |
numeric(19,5)
|
|
|
|
| Service_User_Define_23 |
numeric(19,5)
|
|
|
|
| Service_User_Define_24 |
numeric(19,5)
|
|
|
|
| Contract_Billing_Date |
smallint
|
|
|
|
| Contract_Service_Date |
smallint
|
|
|
|
| WS_Closed |
tinyint
|
|
|
|
| Auto_Bill |
tinyint
|
|
|
|
| Purchase_Order |
char(15)
|
|
|
|
| LSTFSCDY |
datetime
|
Last Fisca...(more) Join Now
|
SY40101.LSTFSCDY
|
|
| Divisions |
char(15)
|
|
|
|
| PY_Labor |
numeric(19,5)
|
|
|
|
| PY_Material |
numeric(19,5)
|
|
|
|
| PY_Equipment |
numeric(19,5)
|
|
|
|
| PY_Subcontractor |
numeric(19,5)
|
|
|
|
| PY_Other |
numeric(19,5)
|
|
|
|
| PY_Total_Cost |
numeric(19,5)
|
|
|
|
| PY_Billed |
numeric(19,5)
|
|
|
|
| PY_Contract_Earned |
numeric(19,5)
|
|
|
|
| PY_Gross_Profit |
numeric(19,5)
|
|
|
|
| PY_Revenue_Recognized |
numeric(19,5)
|
|
|
|
| PY_Hours |
int
|
|
|
|
| PY_Labor_1 |
numeric(19,5)
|
|
|
|
| PY_Labor_1_Hours |
int
|
|
|
|
| PY_Labor_2 |
numeric(19,5)
|
|
|
|
| PY_Labor_2_Hours |
int
|
|
|
|
| PY_Labor_3 |
numeric(19,5)
|
|
|
|
| PY_Labor_3_Hours |
int
|
|
|
|
| PY_Labor_4 |
numeric(19,5)
|
|
|
|
| PY_Labor_4_Hours |
int
|
|
|
|
| PY_Labor_5 |
numeric(19,5)
|
|
|
|
| PY_Labor_5_Hours |
int
|
|
|
|
| PY_Total_Labor |
numeric(19,5)
|
|
|
|
| PY_Total_Labor_Hrs |
int
|
|
|
|
| YTD_Labor |
numeric(19,5)
|
|
|
|
| YTD_Material |
numeric(19,5)
|
|
|
|
| YTD_Equipment |
numeric(19,5)
|
|
|
|
| YTD_Subcontractor |
numeric(19,5)
|
|
|
|
| YTD_Other |
numeric(19,5)
|
|
|
|
| YTD_Total_Cost |
numeric(19,5)
|
|
|
|
| YTD_Billed |
numeric(19,5)
|
|
|
|
| YTD_Contract_Earned |
numeric(19,5)
|
|
|
|
| YTD_Gross_Profit |
numeric(19,5)
|
|
|
|
| YTD_Revenue_Recognized |
numeric(19,5)
|
|
|
|
| YTDHOURS |
int
|
|
|
|
| YTD_Labor_1 |
numeric(19,5)
|
|
|
|
| YTD_Labor_1_Hours |
int
|
|
|
|
| YTD_Labor_2 |
numeric(19,5)
|
|
|
|
| YTD_Labor_2_Hours |
int
|
|
|
|
| YTD_Labor_3 |
numeric(19,5)
|
|
|
|
| YTD_Labor_3_Hours |
int
|
|
|
|
| YTD_Labor_4 |
numeric(19,5)
|
|
|
|
| YTD_Labor_4_Hours |
int
|
|
|
|
| YTD_Labor_5 |
numeric(19,5)
|
|
|
|
| YTD_Labor_5_Hours |
int
|
|
|
|
| YTD_Total_Labor |
numeric(19,5)
|
|
|
|
| YTD_Total_Labor_Hrs |
int
|
|
|
|
| TTD_Billed |
numeric(19,5)
|
|
|
|
| TTD_Contract_Earned |
numeric(19,5)
|
|
|
|
| TTD_Gross_Profit |
numeric(19,5)
|
|
|
|
| TTD_Revenue_Recognized |
numeric(19,5)
|
|
|
|
| Auto_Date |
datetime
|
|
|
|
| Cancel_Box |
tinyint
|
|
|
|
| HOLD |
tinyint
|
Hold: 1 i...(more) Join Now
|
RM00101.HOLD
|
|
| Excess_Cost |
numeric(19,5)
|
|
|
|
| Unbilled_Receivable |
numeric(19,5)
|
|
|
|
| Contract_NTE_Units |
int
|
|
|
|
| Contract_Actual_Units |
int
|
|
|
|
| Equipment_ID |
char(31)
|
|
|
|
| Warranty_Checkbox |
tinyint
|
|
|
|
| MODIFDT |
datetime
|
Date the r...(more) Join Now
|
|
|
| Modified_Time |
datetime
|
|
|
|
| MDFUSRID |
char(15)
|
User that ...(more) Join Now
|
|
join ... more text available
|
| Time_Zone |
char(3)
|
|
|
|
| SV_Language_ID |
smallint
|
|
|
|
| Base_Currency_ID |
char(15)
|
|
|
|
| Billing_Currency_ID |
char(15)
|
|
|
|
| Local_Currency_ID |
char(15)
|
|
|
|
| Hold_Reason_ID |
smallint
|
|
|
|
| Billing_Equipment |
numeric(19,5)
|
|
|
|
| Billing_Material |
numeric(19,5)
|
|
|
|
| Billing_Labor |
numeric(19,5)
|
|
|
|
| Billing_Subs |
numeric(19,5)
|
|
|
|
| Billing_Other |
numeric(19,5)
|
|
|
|
| Billing_Percentage_Equip |
numeric(19,5)
|
|
|
|
| Billing_Pct_Material |
numeric(19,5)
|
|
|
|
| Billing_Percentage_Labor |
numeric(19,5)
|
|
|
|
| Billing_Percentage_Subs |
numeric(19,5)
|
|
|
|
| Billing_Percentage_Other |
numeric(19,5)
|
|
|
|
| Current_Billing_Amount |
numeric(19,5)
|
|
|
|
| Escalation_Frequency |
char(15)
|
|
|
|
| Escalation_Date |
datetime
|
|
|
|
| Escal_Notify_Days |
smallint
|
|
|
|
| Next_Escalation_Date |
datetime
|
|
|
|
| Begin_Date_CY |
datetime
|
|
|
|
| Anniversary_Date |
datetime
|
|
|
|
| Evergreen_Contract_Flag |
tinyint
|
|
|
|
| Contract_Units_Measure |
char(15)
|
|
|
|
| Last_Review_Date |
datetime
|
|
|
|
| Last_Review_User_ID |
char(15)
|
|
|
|
| Contract_Internal_Name |
char(15)
|
|
|
|
| Auto_Escalation_Flag |
tinyint
|
|
|
|
| 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)
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|