PC Setup Information (PC40100)

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

Product: Human Resources (414)
Series: Payroll

Display Name: PC Setup Information
Physical Name: PC40100
Technical Name: pcSetupInfo

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1SETUPKEY SearchSetup KeyINTInteger20
2BUDEMPLREXP SearchBudget Employer ExpenseDDL_BudgetEmployerExpenseInteger20
3BUDGETFTE SearchBudget FTEDDL_BudgetFTEInteger20
4BUDPERMSEATS SearchBudget Pemanent SeatsDDL_BudgetPermanentSeatsInteger20
5BUDTEMPSEATS SearchBudget Temporary SeatsDDL_BudgetTemporarySeatsInteger20
6INCUNASSIGNED SearchInclude UnassignedDDL_IncludeUnassignedInteger20
7PWDARRAY_1 SearchPassword Array[1]STR15String1615
8PWDARRAY_2 SearchPassword Array[2]STR15String1615
9PWDARRAY_3 SearchPassword Array[3]STR15String1615
10PWDARRAY_4 SearchPassword Array[4]STR15String1615
11PWDARRAY_5 SearchPassword Array[5]STR15String1615
12SAVRECRD SearchSave RecordCBBoolean20
13DEX_ROW_ID Searchintint1010

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.

Leave a Reply

Your email address will not be published. Required fields are marked *