Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVINTER6
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: ServiceMeterWarehouse
Physical Name: SVINTER6
Technical Name: ServiceMeterWarehouseSeq 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
['ServiceMeterWarehouse'].CUSTNMBR AS 'ServiceMeterWarehouse-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
SVINTER6 AS ['ServiceMeterWarehouse']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['ServiceMeterWarehouse'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR2 ADRSCODE Address Code STR15_Address_Code String 15 3 Equipment_ID Equipment ID STR30 String 30 4 Meter_Read_Date Meter Read Date DT6 Date 6 5 Technician Technician STR10_LBAU String 10 6 Record Record INT Integer 0 7 CUSTNAME Customer Name STR64_Customer_Name String 64 8 LOCATNNM Location Name STR30 String 30 9 Equipment_Type Equipment Type STR30 String 30 10 Equipment_Meter1_Master Equipment Meter1 Master LI8_U0 Long Integer 8 11 Equipment_Meter2 Equipment Meter2 LI8_U0 Long Integer 8 12 Equipment_Meter3 Equipment Meter3 LI8_U0 Long Integer 8 13 Equipment_Meter4 Equipment Meter4 LI8_U0 Long Integer 8 14 Equipment_Meter5 Equipment Meter5 LI8_U0 Long Integer 8 15 Equipment_Meter6_Master Equipment Meter6 Master LI8_U2 Long Integer 8 16 Equipment_Meter7 Equipment Meter7 LI8_U2 Long Integer 8 17 Equipment_Meter8 Equipment Meter8 LI8_U2 Long Integer 8 18 Equipment_Meter9 Equipment Meter9 LI8_U2 Long Integer 8 19 Equipment_Meter10 Equipment Meter10 LI8_U2 Long Integer 8 20 Equipment_Meter11 Equipment Meter11 LI8_U2 Long Integer 8 21 Equipment_Meter12 Equipment Meter12 LI8_U2 Long Integer 8 22 Equipment_Meter13 Equipment Meter13 LI8_U2 Long Integer 8 23 Equipment_Meter14 Equipment Meter14 LI8_U2 Long Integer 8 24 Equipment_Meter15 Equipment Meter15 LI8_U2 Long Integer 8 25 Equipment_Meter16 Equipment Meter16 STR30 String 30 26 Equipment_Meter17 Equipment Meter17 STR30 String 30 27 Equipment_Meter18 Equipment Meter18 STR30 String 30 28 Equipment_Meter19 Equipment Meter19 STR30 String 30 29 Equipment_Meter20 Equipment Meter20 STR30 String 30 30 Equipment_Meter21 Equipment Meter21 DT6 Date 6 31 Equipment_Meter22 Equipment Meter22 DT6 Date 6 32 Equipment_Meter23 Equipment Meter23 DT6 Date 6 33 Equipment_Meter24 Equipment Meter24 DLR14_RBS0_STR$ Currency 14 34 Equipment_Meter25 Equipment Meter25 DLR14_RBS0_STR$ Currency 14