Position Plans (PC40300)

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

Display Name: Position Plans
Physical Name: PC40300
Technical Name: pcPositionPlans

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	SQL DB Length	Keyable Length
1	PLANCODE	Plan	STR15_LBAU	String	16	15
2	DSCRIPTN	Description	STR30	String	32	30
3	STRTDATE	Start Date	DT	Date	4	8
4	ENDDATE	End Date	DT	Date	4	8
5	INACTIVE	Inactive	CB_Inactive	Boolean	2	0
6	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.