GP Tables

SVA0430 - SV_Equipment_Meter_MSTR_Archive

SQL Query Builder

35 Columns

Column Description Type Length
CUSTNMBR char(15)
ADRSCODE char(15)
Equipment_ID char(31)
Meter_Read_Date datetime
Technician char(11)
Record smallint
CUSTNAME char(65)
LOCATNNM char(31)
Equipment_Type char(31)
Equipment_Meter1_Master int
Equipment_Meter2 int
Equipment_Meter3 int
Equipment_Meter4 int
Equipment_Meter5 int
Equipment_Meter6_Master int
Equipment_Meter7 int
Equipment_Meter8 int
Equipment_Meter9 int
Equipment_Meter10 int
Equipment_Meter11 int
Equipment_Meter12 int
Equipment_Meter13 int
Equipment_Meter14 int
Equipment_Meter15 int
Equipment_Meter16 char(31)
Equipment_Meter17 char(31)
Equipment_Meter18 char(31)
Equipment_Meter19 char(31)
Equipment_Meter20 char(31)
Equipment_Meter21 datetime
Equipment_Meter22 datetime
Equipment_Meter23 datetime
Equipment_Meter24 numeric(19,5)
Equipment_Meter25 numeric(19,5)
DEX_ROW_ID int auto number (1,1)

Related Tables

Tables that share columns with SVA0430. Click "Join" to add to your query.

DEX_ROW_ID

AAG00200 AAG00201 AAG00202 AAG00300 AAG00301 AAG00302 ACColumn AF00100

CUSTNMBR

ASIEXP02 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP15 ASIEXP19 ASIEXP20 ASIEXP21

ADRSCODE

ASIEXP02 ASIEXP05 ASIEXP07 ASIEXP08 ASIEXP10 ASIEXP15 ASIEXP16 ASIEXP18

Equipment_ID

JC10701 SV00055 SV00302 SV00303 SV00304 SV00309 SV00311 SV00387

CUSTNAME

ASIEXP02 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP15 ASIEXP17 ASIEXP20 ASIEXP21

Equipment_Type

SV00055 SV00300 SV00302 SV00315 SV00387 SV00400 SV00401 SV00402

Technician

SV00101 SV00114 SV00115 SV00118 SV00200 SV00221 SV00300 SV00301

Record

JC01101 JC41102 SV00010 SV00012 SV00117 SV00148 SV00196 SV00197

LOCATNNM

EDCEI002 SY01500 SV00054 SV00055 SV00101 SV00200 SV00300 SV00430

Meter_Read_Date

SV00309 SV00430 SV_SVC_R SVINTER6 SVA0309