SV_Equipment_Meter_MSTR (sv00430)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/sv00430

Product: WennSoft Products (131)
Series: 3rd Party

Display Name: SV_Equipment_Meter_MSTR
Physical Name: sv00430
Technical Name: SV_Equipment_Meter_MSTR

Group Display Name: SERVICE
Group Technical Name: SERVICE

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['SV_Equipment_Meter_MSTR'].CUSTNMBR AS 'SV_Equipment_Meter_MSTR-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       sv00430 AS ['SV_Equipment_Meter_MSTR']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['SV_Equipment_Meter_MSTR'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
2ADRSCODE SearchAddress CodeSTR15_Address_CodeString15
3Equipment_ID SearchEquipment IDSTR30String30
4Meter_Read_Date SearchMeter Read DateDT6Date6
5Technician SearchTechnicianSTR10_LBAUString10
6Record SearchRecordINTInteger0
7CUSTNAME SearchCustomer NameSTR64_Customer_NameString64
8LOCATNNM SearchLocation NameSTR30String30
9Equipment_Type SearchEquipment TypeSTR30String30
10Equipment_Meter1_Master SearchEquipment Meter1 MasterLI8_U0Long Integer8
11Equipment_Meter2 SearchEquipment Meter2LI8_U0Long Integer8
12Equipment_Meter3 SearchEquipment Meter3LI8_U0Long Integer8
13Equipment_Meter4 SearchEquipment Meter4LI8_U0Long Integer8
14Equipment_Meter5 SearchEquipment Meter5LI8_U0Long Integer8
15Equipment_Meter6_Master SearchEquipment Meter6 MasterLI8_U2Long Integer8
16Equipment_Meter7 SearchEquipment Meter7LI8_U2Long Integer8
17Equipment_Meter8 SearchEquipment Meter8LI8_U2Long Integer8
18Equipment_Meter9 SearchEquipment Meter9LI8_U2Long Integer8
19Equipment_Meter10 SearchEquipment Meter10LI8_U2Long Integer8
20Equipment_Meter11 SearchEquipment Meter11LI8_U2Long Integer8
21Equipment_Meter12 SearchEquipment Meter12LI8_U2Long Integer8
22Equipment_Meter13 SearchEquipment Meter13LI8_U2Long Integer8
23Equipment_Meter14 SearchEquipment Meter14LI8_U2Long Integer8
24Equipment_Meter15 SearchEquipment Meter15LI8_U2Long Integer8
25Equipment_Meter16 SearchEquipment Meter16STR30String30
26Equipment_Meter17 SearchEquipment Meter17STR30String30
27Equipment_Meter18 SearchEquipment Meter18STR30String30
28Equipment_Meter19 SearchEquipment Meter19STR30String30
29Equipment_Meter20 SearchEquipment Meter20STR30String30
30Equipment_Meter21 SearchEquipment Meter21DT6Date6
31Equipment_Meter22 SearchEquipment Meter22DT6Date6
32Equipment_Meter23 SearchEquipment Meter23DT6Date6
33Equipment_Meter24 SearchEquipment Meter24DLR14_RBS0_STR$Currency14
34Equipment_Meter25 SearchEquipment Meter25DLR14_RBS0_STR$Currency14

Leave a Reply

Your email address will not be published. Required fields are marked *