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	SQL DB Length	Keyable Length
1	EQUIPID	Equipment ID	Long Int	Long Integer	4	8
2	ITEMNMBR	Item Number	STR30_Item_Number	String	32	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	STR20_LBAU	String	22	20
4	SCHEDID	Sched_ID	STR8_LBU	String	10	8
5	PMDTLID	PM_DTL_ID	STR8_LBU	String	10	8
6	Meter_1_Level	Meter 1 Level	LI_Meter_Reading	Long Integer	4	8
7	Meter_2_Level	Meter 2 Level	LI_Meter_Reading	Long Integer	4	8
8	CALLNBR	Service Call Number	STR10_LBAU	String	12	10
9	LSTPMDTE	Last PM Date	DT_Date	Date	4	6
10	METER1	Meter 1	LI_Meter_Reading	Long Integer	4	8
11	METER2	Meter 2	LI_Meter_Reading	Long Integer	4	8
12	PMSTAT	PM Status	DDL_PM_Status	Integer	2	0
13	SVCLSTPMPERF	SVC Last PM Performed Date	DATE	Date	4	6
14	DEX_ROW_ID		int	int	10	10
	DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information. Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.