Payroll Year End State (UPR10105)

Easily find this page again using the shortlink:

Product: Microsoft Dynamics GP (0)
Series: Payroll

Display Name: Payroll Year End State
Physical Name: UPR10105
Technical Name: UPR_Year_End_WORK_State

Group Display Name: Payroll Year End
Group Technical Name: Payroll Year End

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1RPTNGYR SearchReporting YearINT4_U0Integer24
2EMPLOYID SearchEmployee IDSTR15_Employee_IDString1615
3STATINTX SearchState Income TaxDLR11_RU2NC_Year_EndCurrency1014
4STATEWGS SearchState WagesDLR11_RU2NC_Year_EndCurrency1014
5SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer410
6STATECD SearchState CodeSTR2_State_CodeString42
7ESTIDNBR SearchEmployer State ID NumberSTR20String2220
8W2PRINTD SearchW2 PrintedCB_W2_PrintedBoolean20
9TXENTYCD SearchTaxing Entity CodeSTR5_Taxing_Entity_CodeString65
10OTHSTDAT SearchOther State DataSTR10String1210
11STCNTRLNUM SearchState Control NumberSTR7String87
12SUPPDAT1 SearchSupplemental Data 1STR75String7675
13SUPPDAT2 SearchSupplemental Data 2STR75String7675
14DEX_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 *