| USERID |
char(15)
|
The user t...(more) Join Now
|
|
|
join ... more text available
|
| PROCNAME |
char(31)
|
|
|
|
|
| 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
|
|
|
|
|
| Corporate_Contract_Nbr |
char(21)
|
|
|
|
|
| WSMSTRCONTSQ |
int
|
|
|
|
|
| Contract_Experation_Date |
datetime
|
|
|
|
|
| Escalation_Date |
datetime
|
|
|
|
|
| Escalation_Year |
smallint
|
|
|
|
|
| Escalation_Month |
smallint
|
|
|
|
|
| Wennsoft_Affiliate |
char(15)
|
|
|
|
|
| Wennsoft_Region |
char(15)
|
|
|
|
|
| Wennsoft_Branch |
char(15)
|
|
|
|
|
| Bill_Freq |
smallint
|
|
|
|
|
| Next_Escalation_Date |
datetime
|
|
|
|
|
| Escalation_Notifiy_Date |
datetime
|
|
|
|
|
| Escalation_Calc_Date |
datetime
|
|
|
|
|
| Escalation_Calculated_By |
char(15)
|
|
|
|
|
| Escalation_Approved |
tinyint
|
|
|
|
|
| SLPRSNID |
char(15)
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| APPRVLDT |
datetime
|
Approval D...(more) Join Now
|
SY00500.APPRVLDT
|
|
|
| Escalation_Idx_ID_Equip |
char(3)
|
|
|
|
|
| Escal_Idx_ID_Material |
char(3)
|
|
|
|
|
| Escalation_Idx_ID_Labor |
char(3)
|
|
|
|
|
| Escalation_Index_ID_Subs |
char(3)
|
|
|
|
|
| Escalation_Idx_ID_Other |
char(3)
|
|
|
|
|
| Escal_Fixed_Amt_Equip |
numeric(19,5)
|
|
|
|
|
| Escalation_Fixed_Amt_Mat |
numeric(19,5)
|
|
|
|
|
| Escal_Fixed_Amt_Labor |
numeric(19,5)
|
|
|
|
|
| Escal_Fixed_Amt_Subs |
numeric(19,5)
|
|
|
|
|
| Escal_Fixed_Amt_Other |
numeric(19,5)
|
|
|
|
|
| Escalation_Pct_Equip |
numeric(19,5)
|
|
|
|
|
| Escalation_Pct_Material |
numeric(19,5)
|
|
|
|
|
| Escalation_Pct_Labor |
numeric(19,5)
|
|
|
|
|
| Escalation_Pct_Subs |
numeric(19,5)
|
|
|
|
|
| Escalation_Pct_Other |
numeric(19,5)
|
|
|
|
|
| Proposed_Billing_Equip |
numeric(19,5)
|
|
|
|
|
| Prop_Billing_Material |
numeric(19,5)
|
|
|
|
|
| Proposed_Billing_Labor |
numeric(19,5)
|
|
|
|
|
| Proposed_Billing_Subs |
numeric(19,5)
|
|
|
|
|
| Proposed_Billing_Other |
numeric(19,5)
|
|
|
|
|
| Accepted_Billing_Equip |
numeric(19,5)
|
|
|
|
|
| Accepted_Billing_Materl |
numeric(19,5)
|
|
|
|
|
| Accepted_Billing_Labor |
numeric(19,5)
|
|
|
|
|
| Accepted_Billing_Subs |
numeric(19,5)
|
|
|
|
|
| Accepted_Billing_Other |
numeric(19,5)
|
|
|
|
|
| Proposed_Estimate_Equip |
numeric(19,5)
|
|
|
|
|
| Proposed_Est_Material |
numeric(19,5)
|
|
|
|
|
| Proposed_Estimate_Labor |
numeric(19,5)
|
|
|
|
|
| Proposed_Estimate_Subs |
numeric(19,5)
|
|
|
|
|
| Proposed_Estimate_Other |
numeric(19,5)
|
|
|
|
|
| Proposed_Estimate_Hours |
int
|
|
|
|
|
| Accepted_Estimate_Equip |
numeric(19,5)
|
|
|
|
|
| Accepted_Est_Material |
numeric(19,5)
|
|
|
|
|
| Accepted_Estimate_Labor |
numeric(19,5)
|
|
|
|
|
| Accepted_Estimate_Subs |
numeric(19,5)
|
|
|
|
|
| Accepted_Estimate_Other |
numeric(19,5)
|
|
|
|
|
| Accepted_Estimate_Hours |
int
|
|
|
|
|
| POSTED |
tinyint
|
Field Type...(more) Join Now
|
|
|
|
| POSTEDDT |
datetime
|
Field Type...(more) Join Now
|
|
|
|
| SV_Language_ID |
smallint
|
|
|
|
|
| MODIFDT |
datetime
|
Date the r...(more) Join Now
|
|
|
|
| Modified_Time |
datetime
|
|
|
|
|
| MDFUSRID |
char(15)
|
User that ...(more) Join Now
|
|
|
join ... more text available
|
| Service_User_Define_1 |
char(21)
|
|
|
|
|
| Service_User_Define_2 |
char(21)
|
|
|
|
|
| Service_User_Define_3 |
char(31)
|
|
|
|
|
| Service_User_Define_4 |
char(31)
|
|
|
|
|
| Service_User_Define_5 |
int
|
|
|
|
|
| Service_User_Define_6 |
int
|
|
|
|
|
| Service_User_Define_7 |
int
|
|
|
|
|
| Service_User_Define_8 |
int
|
|
|
|
|
| Service_User_Define_9 |
datetime
|
|
|
|
|
| Service_User_Define_10 |
datetime
|
|
|
|
|
| Service_User_Define_11 |
datetime
|
|
|
|
|
| Service_User_Define_12 |
datetime
|
|
|
|
|
| Service_User_Define_18 |
tinyint
|
|
|
|
|
| Service_User_Define_19 |
tinyint
|
|
|
|
|
| Service_User_Define_20 |
tinyint
|
|
|
|
|
| Service_User_Define_21 |
tinyint
|
|
|
|
|
| Service_User_Define_22 |
numeric(19,5)
|
|
|
|
|
| Service_User_Define_23 |
numeric(19,5)
|
|
|
|
|
| Service_User_Define_24 |
numeric(19,5)
|
|
|
|
|
| Service_User_Define_25 |
numeric(19,5)
|
|
|
|
|
| Error_Flag_Equip |
tinyint
|
|
|
|
|
| Contract_Valid |
smallint
|
|
|
|
|
| Error_Flag_Material |
tinyint
|
|
|
|
|
| Error_Flag_Labor |
tinyint
|
|
|
|
|
| Error_Flag_Subs |
tinyint
|
|
|
|
|
| Error_Flag_Other |
tinyint
|
|
|
|
|
| Contract_Open_Calls |
tinyint
|
|
|
|
|
| Contract_Not_Billed |
tinyint
|
|
|
|
|
| Contract_Not_Rev |
tinyint
|
|
|
|
|
| Forecasted_Indicator |
tinyint
|
|
|
|
|
| Escalation_Indicator |
tinyint
|
|
|
|
|
| HOLD |
tinyint
|
Hold: 1 i...(more) Join Now
|
RM00101.HOLD
|
|
|
| Contract_Billed_Not_Reco |
tinyint
|
|
|
|
|
| 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
|
|
|
|
|