SVC_Serial_MSTR_PM (SVC00305)

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

Display Name: SVC_Serial_MSTR_PM
Physical Name: SVC00305
Technical Name: SVC_Serial_MSTR_PM

Group Display Name: Service Table Group
Group Technical Name: Service

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	EQUIPID	Equipment ID	Long Integer	Long Int	8
2	ITEMNMBR	Item Number	String	STR30_Item_Number	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['SVC_Serial_MSTR_PM'].ITEMNMBR AS 'SVC_Serial_MSTR_PM-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM SVC00305 AS ['SVC_Serial_MSTR_PM'] INNER JOIN IV00101 AS ['Item Master'] ON ['SVC_Serial_MSTR_PM'].ITEMNMBR = ['Item Master'].ITEMNMBR
3	SERLNMBR	Serial Number	String	STR20_LBAU	20
4	SCHEDID	Sched_ID	String	STR8_LBU	8
5	PMDTLID	PM_DTL_ID	String	STR8_LBU	8
6	Meter_1_Level	Meter 1 Level	Long Integer	LI_Meter_Reading	8
7	Meter_2_Level	Meter 2 Level	Long Integer	LI_Meter_Reading	8
8	CALLNBR	Service Call Number	String	STR10_LBAU	10
9	LSTPMDTE	Last PM Date	Date	DT_Date	6
10	METER1	Meter 1	Long Integer	LI_Meter_Reading	8
11	METER2	Meter 2	Long Integer	LI_Meter_Reading	8
12	PMSTAT	PM Status	Integer	DDL_PM_Status	0
13	SVCLSTPMPERF	SVC Last PM Performed Date	Date	DATE	6