Module List >
Module SV tables
SV00529
You are currently viewing the COMPANY
database. Change
|
COMPANY..SV00529 Table Definition
(COMPANY..SV_Equipment_Type_Task_Codes_MSTR)
Field Definitions:
What is the 'source' column?
| Equipment_Type |
char(31)
|
|
|
|
| Task_Code |
char(11)
|
|
|
|
| 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)
|
|
|
|
| Subcontractor_ID |
char(15)
|
|
|
|
| System |
char(15)
|
|
|
|
| Major |
char(15)
|
|
|
|
| Sub_1 |
char(15)
|
|
|
|
| Sub_2 |
char(15)
|
|
|
|
| Sub_3 |
char(15)
|
|
|
|
| Sub_4 |
char(15)
|
|
|
|
| Long_Task_Description |
char(11)
|
|
|
|
| Task_Description |
char(61)
|
|
|
|
| Wennsoft_Close_Date |
datetime
|
|
|
|
| INACTIVE |
tinyint
|
Inactive: ...(more) Join Now
|
RM00101.INACTIVE
|
|
| Estimate_Hours |
int
|
|
|
|
| Estimate_Labor |
numeric(19,5)
|
|
|
|
| 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
|
|
|
|
| Estimate_Material |
numeric(19,5)
|
|
|
|
| Estimate_Subs |
numeric(19,5)
|
|
|
|
| Estimate_Other |
numeric(19,5)
|
|
|
|
| Estimate_Total_Cost |
numeric(19,5)
|
|
|
|
| Frequency |
char(15)
|
|
|
|
| Schedule |
smallint
|
|
|
|
| Optional |
tinyint
|
|
|
|
| Skill_Level |
char(15)
|
|
|
|
| Schedule_Date |
datetime
|
|
|
|
| Completion_Date |
datetime
|
Completion...(more) Join Now
|
BM10200.Completion_Date
|
|
| Material_Kit_Required |
char(31)
|
|
|
|
| Material_Kit_Quantity |
int
|
|
|
|
| Tool_Kit_Required |
char(15)
|
|
|
|
| Coverage_Code |
smallint
|
|
|
|
| Task_User_Define1 |
char(21)
|
|
|
|
| Task_User_Define2 |
char(21)
|
|
|
|
| Task_User_Define3 |
char(31)
|
|
|
|
| Task_User_Define4 |
char(31)
|
|
|
|
| Task_User_Define5 |
int
|
|
|
|
| Task_User_Define6 |
int
|
|
|
|
| Task_User_Define7 |
int
|
|
|
|
| Task_User_Define8 |
int
|
|
|
|
| Task_User_Define9 |
datetime
|
|
|
|
| Task_User_Define10 |
datetime
|
|
|
|
| Task_User_Define11 |
datetime
|
|
|
|
| Task_User_Define12 |
datetime
|
|
|
|
| Task_User_Define13 |
numeric(19,5)
|
|
|
|
| Task_User_Define14 |
numeric(19,5)
|
|
|
|
| Task_User_Define15 |
numeric(19,5)
|
|
|
|
| Task_User_Define16 |
numeric(19,5)
|
|
|
|
| Task_User_Define17 |
numeric(19,5)
|
|
|
|
| Task_User_Define18 |
tinyint
|
|
|
|
| Task_User_Define19 |
tinyint
|
|
|
|
| Task_User_Define20 |
tinyint
|
|
|
|
| Task_User_Define21 |
tinyint
|
|
|
|
| Task_Hours |
int
|
|
|
|
| Jan_Required |
tinyint
|
|
|
|
| Jan_Completed |
tinyint
|
|
|
|
| Jan_Completed_Date |
datetime
|
|
|
|
| Jan_Service_ID |
char(17)
|
|
|
|
| Jan_Est_Hours |
int
|
|
|
|
| Feb_Required |
tinyint
|
|
|
|
| Feb_Completed |
tinyint
|
|
|
|
| Feb_Completed_Date |
datetime
|
|
|
|
| Feb_Service_ID |
char(17)
|
|
|
|
| Feb_Est_Hours |
int
|
|
|
|
| March_Required |
tinyint
|
|
|
|
| March_Completed |
tinyint
|
|
|
|
| March_Completed_Date |
datetime
|
|
|
|
| March_Service_ID |
char(17)
|
|
|
|
| March_Est_Hours |
int
|
|
|
|
| April_Required |
tinyint
|
|
|
|
| April_Completed |
tinyint
|
|
|
|
| April_Completed_Date |
datetime
|
|
|
|
| April_Service_ID |
char(17)
|
|
|
|
| April_Est_Hours |
int
|
|
|
|
| May_Required |
tinyint
|
|
|
|
| May_Completed |
tinyint
|
|
|
|
| May_Completed_Date |
datetime
|
|
|
|
| May_Service_ID |
char(17)
|
|
|
|
| May_Est_Hours |
int
|
|
|
|
| June_Required |
tinyint
|
|
|
|
| June_Completed |
tinyint
|
|
|
|
| June_Completed_Date |
datetime
|
|
|
|
| June_Service_ID |
char(17)
|
|
|
|
| June_Est_Hours |
int
|
|
|
|
| July_Required |
tinyint
|
|
|
|
| July_Completed |
tinyint
|
|
|
|
| July_Completed_Date |
datetime
|
|
|
|
| July_Service_ID |
char(17)
|
|
|
|
| July_Est_Hours |
int
|
|
|
|
| Aug_Required |
tinyint
|
|
|
|
| Aug_Completed |
tinyint
|
|
|
|
| Aug_Completed_Date |
datetime
|
|
|
|
| Aug_Service_ID |
char(17)
|
|
|
|
| Aug_Est_Hours |
int
|
|
|
|
| Sept_Required |
tinyint
|
|
|
|
| Sept_Completed |
tinyint
|
|
|
|
| Sept_Completed_Date |
datetime
|
|
|
|
| Sept_Service_ID |
char(17)
|
|
|
|
| Sept_Est_Hours |
int
|
|
|
|
| Oct_Required |
tinyint
|
|
|
|
| Oct_Completed |
tinyint
|
|
|
|
| Oct_Completed_Date |
datetime
|
|
|
|
| Oct_Service_ID |
char(17)
|
|
|
|
| Oct_Est_Hours |
int
|
|
|
|
| Nov_Required |
tinyint
|
|
|
|
| Nov_Completed |
tinyint
|
|
|
|
| Nov_Completed_Date |
datetime
|
|
|
|
| Nov_Service_ID |
char(17)
|
|
|
|
| Nov_Est_Hours |
int
|
|
|
|
| Dec_Required |
tinyint
|
|
|
|
| Dec_Completed |
tinyint
|
|
|
|
| Dec_Completed_Date |
datetime
|
|
|
|
| Dec_Service_ID |
char(17)
|
|
|
|
| Dec_Est_Hours |
int
|
|
|
|
| Week_1 |
tinyint
|
|
|
|
| Week_2 |
tinyint
|
|
|
|
| Week_3 |
tinyint
|
|
|
|
| Week_4 |
tinyint
|
|
|
|
| Week_5 |
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)
|
|
|
|
| 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)
|
|
|
|
| PM_Group |
char(3)
|
|
|
|
| ID_1 |
char(11)
|
|
|
|
| ID_2 |
char(11)
|
|
|
|
| YR_MOD |
smallint
|
|
|
|
| YR_REM |
smallint
|
|
|
|
| Auto_Date |
datetime
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|