Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVA0430
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: SV_Equipment_Meter_MSTR_Archive
Physical Name: SVA0430
Technical Name: SV_Equipment_Meter_MSTR_Archive
| Seq 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/hideSELECT
['SV_Equipment_Meter_MSTR_Archive'].CUSTNMBR AS 'SV_Equipment_Meter_MSTR_Archive-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
SVA0430 AS ['SV_Equipment_Meter_MSTR_Archive']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['SV_Equipment_Meter_MSTR_Archive'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR | ||||||
| 2 | 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 | |