Module List >
Module SV tables
SV00650
You are currently viewing the COMPANY
database.
Change
|
COMPANY..SV00650 Table Definition
(COMPANY..SV_Master_Contract_MSTR)
Field Definitions:
What is the 'source' column?
| CUSTNMBR |
char(15)
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| Corporate_Contract_Nbr |
char(21)
|
|
|
|
|
| WSMSTRCONTSQ |
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)
|
|
|
|
|
| Customer_Contract_Type |
char(15)
|
|
|
|
|
| Customer_Contract_Desc |
char(31)
|
|
|
|
|
| Customer_Contract_Amount |
numeric(19,5)
|
|
|
|
|
| Cust_Contract_Start_Date |
datetime
|
|
|
|
|
| Customer_Contract_End_Dt |
datetime
|
|
|
|
|
| Contract_Service_Date |
smallint
|
|
|
|
|
| SLPRSNID |
char(15)
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| COMAPPTO |
smallint
|
Commission...(more) Join Now
|
RM10301.COMAPPTO
|
|
|
| PRBTADCD |
char(15)
|
Primary Bi...(more) Join Now
|
RM00101.PRBTADCD
|
|
join ... more text available
|
| Bill_Freq |
smallint
|
|
|
|
|
| Wennsoft_Close_Date |
datetime
|
|
|
|
|
| Annual_Contract_Value |
numeric(19,5)
|
|
|
|
|
| Revenue_Rec_Method_ID |
smallint
|
|
|
|
|
| Invoice_Style |
smallint
|
|
|
|
|
| Multiyear_Contract_Flag |
tinyint
|
|
|
|
|
| PORDNMBR |
char(21)
|
Field Type...(more) Join Now
|
|
|
|
| Current_Billing_Amount |
numeric(19,5)
|
|
|
|
|
| Billing_Control |
tinyint
|
|
|
|
|
| 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)
|
|
|
|
|
| WSUserDefined1ID |
char(15)
|
|
|
|
|
| WSUserDefined2ID |
char(15)
|
|
|
|
|
| Customer_User_Define1a |
char(15)
|
|
|
|
|
| Customer_User_Define2a |
char(15)
|
|
|
|
|
| Customer_User_Define3a |
char(15)
|
|
|
|
|
| Customer_User_Define4a |
char(15)
|
|
|
|
|
| Customer_User_Define5a |
char(15)
|
|
|
|
|
| Customer_User_Define6a |
char(15)
|
|
|
|
|
| Customer_User_Define7a |
char(15)
|
|
|
|
|
| Customer_User_Define8a |
char(15)
|
|
|
|
|
| Customer_User_Define9a |
char(15)
|
|
|
|
|
| Customer_User_Define10a |
char(15)
|
|
|
|
|
| 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
|
|
|
|
|
| WS_Closed |
tinyint
|
|
|
|
|
| Auto_Bill |
tinyint
|
|
|
|
|
| LSTFSCDY |
datetime
|
Last Fisca...(more) Join Now
|
SY40101.LSTFSCDY
|
|
|
| Auto_Date |
datetime
|
|
|
|
|
| Cancel_Box |
tinyint
|
|
|
|
|
| HOLD |
tinyint
|
Hold: 1 i...(more) Join Now
|
RM00101.HOLD
|
|
|
| Hold_Reason_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
|
| Time_Zone |
char(3)
|
|
|
|
|
| SV_Language_ID |
smallint
|
|
|
|
|
| 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
|
|
|
|
|
| Leave_Open_Flag |
tinyint
|
|
|
|
|
| Bill_Customer_Number |
char(15)
|
|
|
|
|
| Bill_Address_Code |
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
|
|
|
|
|