Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/UPR00502
Product: Microsoft Dynamics GP (0)
Series: Payroll
Display Name: Payroll Deduction Sequence Master Group Display Name: Payroll Employee Master
Physical Name: UPR00502
Technical Name: uprMstrDeductionSequence
Group Technical Name: Payroll Employee Master
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | SQL DB Length | Keyable Length |
|---|---|---|---|---|---|---|
| 1 | EMPLOYID  | Employee ID | STR15_Employee_ID | String | 16 | 15 |
| 2 | DEDUCTON | Deduction | STR6_Payroll_Code | String | 8 | 6 |
| 3 | DEDNSQNC | Deduction Sequence | INT | Integer | 2 | 0 |
| 4 | SPLITMTHD | Split Method | DDL_Split_Method | Integer | 2 | 0 |
| 5 | 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. | ||||||