SVC_PM_Schedule_WORK (SVC00350)

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

Display Name: SVC_PM_Schedule_WORK
Physical Name: SVC00350
Technical Name: SVC_PM_Schedule_WORK

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	SVC_PM_Annual_Date	SVC PM Annual Date	DATE	Date	4	6
3	SCHEDID	Sched_ID	STR8_LBU	String	10	8
4	PMDTLID	PM_DTL_ID	STR8_LBU	String	10	8
5	FREQOFPM	Frequency_of_PM	INT1	Integer	2	1
6	SRVTYPE	Service Type	STR10_LBAU	String	12	10
7	QUANTITY	QTY	DLR17_QTY_RBS0_STR	Currency	10	17
8	SVC_PM_Type	SVC PM Type	SVC_DDL_PM_Type	Integer	2	0
9	SVC_Meter_Type	SVC Meter Type	SVC_DDL_Meter_Type	Integer	2	0
10	CONTNBR	Contract Number	STR11	String	12	11
11	LNSEQNBR	Line SEQ Number	Sequence_Number	Currency	10	19
12	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.