Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PC40300
Product: Human Resources (414)
Series: Payroll
Display Name: Position Plans 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.
Physical Name: PC40300
Technical Name: pcPositionPlansSeq 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