Module List >
Module SV tables
SV00200
You are currently viewing the COMPANY
database.
Change
|
COMPANY..SV00200 Table Definition
(COMPANY..SV_Location_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
|
|
|
|
| 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)
|
|
|
|
|
| CUSTNAME |
char(65)
|
Field Type...(more) Join Now
|
|
|
|
| PHONE1 |
char(21)
|
Field Type...(more) Join Now
|
|
|
|
| Map_Grid |
char(15)
|
|
|
|
|
| FAX |
char(21)
|
Fax: Same...(more) Join Now
|
RM00101.FAX
|
|
|
| Service_Area |
char(15)
|
|
|
|
|
| LOCATNNM |
char(31)
|
|
|
|
|
| STATE |
char(29)
|
Field Type...(more) Join Now
|
|
|
|
| ZIP |
char(11)
|
Field Type...(more) Join Now
|
|
|
|
| PHONE2 |
char(21)
|
Field Type...(more) Join Now
|
|
|
|
| ADDRESS1 |
char(61)
|
Field Type...(more) Join Now
|
|
|
|
| CITY |
char(35)
|
Field Type...(more) Join Now
|
|
|
|
| Labor_Group_Name |
char(15)
|
|
|
|
|
| Pricing_Matrix_Name |
char(15)
|
|
|
|
|
| SLPRSNID |
char(15)
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| Technician |
char(11)
|
|
|
|
|
| Technician_2 |
char(11)
|
|
|
|
|
| Technician_ID2 |
char(15)
|
|
|
|
|
| CNTCPRSN |
char(61)
|
Field Type...(more) Join Now
|
|
|
|
| Contact_Name |
char(15)
|
|
|
|
|
| Hold_Transaction_ID |
int
|
|
|
|
|
| Safety_Flag |
tinyint
|
|
|
|
|
| Blanket_PO_CB |
tinyint
|
|
|
|
|
| Blanket_PO_Number |
char(17)
|
|
|
|
|
| Orig_Blanket_PO_Amt |
numeric(19,5)
|
|
|
|
|
| Blanket_PO_Amt_Spent |
numeric(19,5)
|
|
|
|
|
| Blanket_PO_Amt__Remainin |
numeric(19,5)
|
|
|
|
|
| Blanket_PO_Exp_Date |
datetime
|
|
|
|
|
| User_Define_1a |
char(31)
|
|
|
|
|
| User_Define_2a |
char(31)
|
|
|
|
|
| User_Define_3a |
char(31)
|
|
|
|
|
| User_Define_4a |
char(31)
|
|
|
|
|
| User_Define_5a |
char(31)
|
|
|
|
|
| User_Define_6a |
char(31)
|
|
|
|
|
| PO_Required |
tinyint
|
|
|
|
|
| Out_of_Service_Flag |
tinyint
|
|
|
|
|
| Alarm_Flag |
tinyint
|
|
|
|
|
| Supervisors_ID |
char(15)
|
|
|
|
|
| Supervisors_Hold_Flag |
tinyint
|
|
|
|
|
| CPRCSTNM |
char(15)
|
Corporate ...(more) Join Now
|
RM00101.CPRCSTNM
|
|
|
| Divisions |
char(15)
|
|
|
|
|
| Travel_Rate_Name |
char(15)
|
|
|
|
|
| SVSLARES |
char(11)
|
|
|
|
|
| Bill_Customer_Number |
char(15)
|
|
|
|
|
| Bill_Address_Code |
char(15)
|
|
|
|
|
| Longitude |
numeric(19,5)
|
|
|
|
|
| Latitude |
numeric(19,5)
|
|
|
|
|
| Priority_of_Call |
char(1)
|
|
|
|
|
| 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)
|
|
|
|
|
| Time_Zone_Tag |
char(5)
|
|
|
|
|
| SV_Language_ID |
smallint
|
|
|
|
|
| Base_Currency_ID |
char(15)
|
|
|
|
|
| Billing_Currency_ID |
char(15)
|
|
|
|
|
| Local_Currency_ID |
char(15)
|
|
|
|
|
| Civic1Alpha |
char(5)
|
|
|
|
|
| Civic1Num |
smallint
|
|
|
|
|
| Civic1Dir |
char(5)
|
|
|
|
|
| Civic2Alpha |
char(5)
|
|
|
|
|
| Civic2Num |
smallint
|
|
|
|
|
| Civic2Dir |
char(5)
|
|
|
|
|
| StreetName |
char(31)
|
|
|
|
|
| StreetType |
char(7)
|
|
|
|
|
| PostDir |
char(5)
|
|
|
|
|
| SecAddType1 |
char(13)
|
|
|
|
|
| SecAddNum1 |
smallint
|
|
|
|
|
| SecAddAlpha1 |
char(5)
|
|
|
|
|
| SecAddType2 |
char(13)
|
|
|
|
|
| SecAddNum2 |
smallint
|
|
|
|
|
| SecAddAlpha2 |
char(5)
|
|
|
|
|
| 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
|
|
|
|
|