Module List >
Module SV tables
SV00515
You are currently viewing the COMPANY
database.
Change
|
COMPANY..SV00515 Table Definition
(COMPANY..SV_Maint_Contract_Type_MSTR)
Field Definitions:
What is the 'source' column?
| Contract_Internal_Name |
char(15)
|
|
|
|
|
| Contract_Description |
char(31)
|
|
|
|
|
| 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)
|
|
|
|
|
| Labor_Pct_Contract_Amt |
numeric(19,5)
|
|
|
|
|
| Stand_Lbr_Cost_Per_Hr |
numeric(19,5)
|
|
|
|
|
| Labor_Adjust_For_T_and_E |
numeric(19,5)
|
|
|
|
|
| ATS_Percent_Labor |
numeric(19,5)
|
|
|
|
|
| Labor_1_Percent_of_Labor |
numeric(19,5)
|
|
|
|
|
| Labor_2_Percent_of_Labor |
numeric(19,5)
|
|
|
|
|
| Labor_3_Percent_of_Labor |
numeric(19,5)
|
|
|
|
|
| Labor_4_Percent_of_Labor |
numeric(19,5)
|
|
|
|
|
| Labor_5_Percent_of_Labor |
numeric(19,5)
|
|
|
|
|
| Pct_of_Contract_Equip |
numeric(19,5)
|
|
|
|
|
| ATS_Percent_Equip |
numeric(19,5)
|
|
|
|
|
| Pct_of_Contract_Material |
numeric(19,5)
|
|
|
|
|
| ATS_Percent_Material |
numeric(19,5)
|
|
|
|
|
| Percent_of_Contract_Subs |
numeric(19,5)
|
|
|
|
|
| ATS_Percent_Subs |
numeric(19,5)
|
|
|
|
|
| Pct_of_Contract_Other |
numeric(19,5)
|
|
|
|
|
| ATS_Percent_Other |
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)
|
|
|
|
|
| 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
|
|
|
|
| Notes |
text
|
|
|
|
|
|