ServiceMeterWarehouse (SVINTER6)

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: ServiceMeterWarehouse

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
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'].CUSTNMBR
2ADRSCODE SearchAddress CodeSTR15_Address_CodeString1615
3Equipment_ID SearchEquipment IDSTR30String3230
4Meter_Read_Date SearchMeter Read DateDT6Date46
5Technician SearchTechnicianSTR10_LBAUString1210
6Record SearchRecordINTInteger20
7CUSTNAME SearchCustomer NameSTR64_Customer_NameString6664
8LOCATNNM SearchLocation NameSTR30String3230
9Equipment_Type SearchEquipment TypeSTR30String3230
10Equipment_Meter1_Master SearchEquipment Meter1 MasterLI8_U0Long Integer48
11Equipment_Meter2 SearchEquipment Meter2LI8_U0Long Integer48
12Equipment_Meter3 SearchEquipment Meter3LI8_U0Long Integer48
13Equipment_Meter4 SearchEquipment Meter4LI8_U0Long Integer48
14Equipment_Meter5 SearchEquipment Meter5LI8_U0Long Integer48
15Equipment_Meter6_Master SearchEquipment Meter6 MasterLI8_U2Long Integer48
16Equipment_Meter7 SearchEquipment Meter7LI8_U2Long Integer48
17Equipment_Meter8 SearchEquipment Meter8LI8_U2Long Integer48
18Equipment_Meter9 SearchEquipment Meter9LI8_U2Long Integer48
19Equipment_Meter10 SearchEquipment Meter10LI8_U2Long Integer48
20Equipment_Meter11 SearchEquipment Meter11LI8_U2Long Integer48
21Equipment_Meter12 SearchEquipment Meter12LI8_U2Long Integer48
22Equipment_Meter13 SearchEquipment Meter13LI8_U2Long Integer48
23Equipment_Meter14 SearchEquipment Meter14LI8_U2Long Integer48
24Equipment_Meter15 SearchEquipment Meter15LI8_U2Long Integer48
25Equipment_Meter16 SearchEquipment Meter16STR30String3230
26Equipment_Meter17 SearchEquipment Meter17STR30String3230
27Equipment_Meter18 SearchEquipment Meter18STR30String3230
28Equipment_Meter19 SearchEquipment Meter19STR30String3230
29Equipment_Meter20 SearchEquipment Meter20STR30String3230
30Equipment_Meter21 SearchEquipment Meter21DT6Date46
31Equipment_Meter22 SearchEquipment Meter22DT6Date46
32Equipment_Meter23 SearchEquipment Meter23DT6Date46
33Equipment_Meter24 SearchEquipment Meter24DLR14_RBS0_STR$Currency1014
34Equipment_Meter25 SearchEquipment Meter25DLR14_RBS0_STR$Currency1014

Leave a Reply

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