Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SV99403
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: SV_Equipment_Contract_Coverage_VIEW
Physical Name: SV99403
Technical Name: SV_Equipment_Contract_Coverage_VIEWSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CUSTNMBR 
Customer Number STR15_RM_Customer_Number String 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['SV_Equipment_Contract_Coverage_VIEW'].CUSTNMBR AS 'SV_Equipment_Contract_Coverage_VIEW-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
SV99403 AS ['SV_Equipment_Contract_Coverage_VIEW']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['SV_Equipment_Contract_Coverage_VIEW'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR2 ADRSCODE Address Code STR15_Address_Code String 15 3 Contract_Number WS Contract Number STR10 String 10 4 WSCONTSQ WS Contract Number Sequence LI_Sequence_Number Long Integer 10 5 Contract_Internal_Name Contract Internal Name STR15_LBAU String 15 6 Contract_Start_Date WS Contract Start Date DT Date 8 7 Contract_Expiration_Date Contract Experation Date DT Date 8 8 Equipment_ID Equipment ID STR30 String 30 9 Wennsoft_Master_Equip_ID Wennsoft Master Equipment ID STR30 String 30 10 Equipment_Type Equipment Type STR30 String 30 11 Location_Equipment Location Equipment STR50_LBU String 50 12 Wennsoft_Serial_Number Wennsoft Serial Number STR40 String 40 13 Manufacturer_ID Manufacturer ID STR15_LBAU String 15 14 Wennsoft_Model_Number Wennsoft Model Number STR20 String 20 15 Warranty_Expiration Warranty Experation DT Date 8 16 Extended_Warr_Expiration Extended Warranty Experation DT Date 8 17 User_Define_1a User Define 1a STR30 String 30 18 User_Define_2a User Define 2a STR30 String 30 19 User_Define_3a User Define 3a STR30 String 30 20 User_Define_4a User Define 4a STR30 String 30 21 User_Define_5a User Define 5a STR30 String 30 22 Out_of_Service_Flag Out of Service Flag CB_Out_Of_Service_Flag Boolean 0 23 Inactive_Retired_Flag Inactive/Retired Flag CB_Inactive/Retired Boolean 0 24 CMPTFLAG Component Flag CB_Component_Item Boolean 0 25 WSReserved_CB1 WSReserved CB1 CB Boolean 0 26 Component_Qty Component Qty INT5 Integer 4