Module List >
Module SV tables
SV00550
You are currently viewing the COMPANY
database.
Change
|
COMPANY..SV00550 Table Definition
(COMPANY..SV_Maint_Annual_MSTR)
Field Definitions:
What is the 'source' column?
| CUSTNMBR |
char(15)
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| ADRSCODE |
char(15)
|
Field Type...(more) Join Now
|
|
|
|
| Equipment_ID |
char(31)
|
|
|
|
|
| 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
|
| HOLD |
tinyint
|
Hold: 1 i...(more) Join Now
|
RM00101.HOLD
|
|
|
| Cancel_Box |
tinyint
|
|
|
|
|
| Task_Estimated_Hours1 |
smallint
|
|
|
|
|
| Task_Estimated_Hours2 |
smallint
|
|
|
|
|
| Task_Estimated_Hours3 |
smallint
|
|
|
|
|
| Task_Estimated_Hours4 |
smallint
|
|
|
|
|
| Task_Estimated_Hours5 |
smallint
|
|
|
|
|
| Divisions |
char(15)
|
|
|
|
|
| Technician |
char(11)
|
|
|
|
|
| Service_Call_ID |
char(17)
|
|
|
|
|
| Service_Area |
char(15)
|
|
|
|
|
| First_Mailer_Sent |
tinyint
|
|
|
|
|
| Contract_Experation_Date |
datetime
|
|
|
|
|
| Contract_Description |
char(31)
|
|
|
|
|
| Technician_ID |
char(15)
|
|
|
|
|
| Technician_Team |
char(15)
|
|
|
|
|
| Wennsoft_Model_Number |
char(21)
|
|
|
|
|
| Equipment_Type |
char(31)
|
|
|
|
|
| Manufacturer_ID |
char(15)
|
|
|
|
|
| ITEMNMBR |
char(31)
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| Do_Task_1 |
tinyint
|
|
|
|
|
| Do_Task_2 |
tinyint
|
|
|
|
|
| Do_Task_3 |
tinyint
|
|
|
|
|
| Do_Task_4 |
tinyint
|
|
|
|
|
| Do_Task_5 |
tinyint
|
|
|
|
|
| Task_Override_Amount_1 |
numeric(19,5)
|
|
|
|
|
| Task_Override_Amount_2 |
numeric(19,5)
|
|
|
|
|
| Task_Override_Amount_3 |
numeric(19,5)
|
|
|
|
|
| Task_Override_Amount_4 |
numeric(19,5)
|
|
|
|
|
| Task_Override_Amount_5 |
numeric(19,5)
|
|
|
|
|
| Override_Amount_Flag |
char(11)
|
|
|
|
|
| Report_Break |
char(51)
|
|
|
|
|
| Estimated_Service_Date |
datetime
|
|
|
|
|
| Response_Date |
datetime
|
Field Type...(more) Join Now
|
|
|
|
| Tot_Summer_Service_Tasks |
numeric(19,5)
|
|
|
|
|
| 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)
|
|
|
|
|
| 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)
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|