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 TypeLength
1RPTNGYR SearchReporting YearINT4_U0Integer4
2EMPLOYID SearchEmployee IDSTR15_Employee_IDString15
3STATINTX SearchState Income TaxDLR11_RU2NC_Year_EndCurrency14
4STATEWGS SearchState WagesDLR11_RU2NC_Year_EndCurrency14
5SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer10
6STATECD SearchState CodeSTR2_State_CodeString2
7ESTIDNBR SearchEmployer State ID NumberSTR20String20
8W2PRINTD SearchW2 PrintedCB_W2_PrintedBoolean0
9TXENTYCD SearchTaxing Entity CodeSTR5_Taxing_Entity_CodeString5
10OTHSTDAT SearchOther State DataSTR10String10
11STCNTRLNUM SearchState Control NumberSTR7String7
12SUPPDAT1 SearchSupplemental Data 1STR75String75
13SUPPDAT2 SearchSupplemental Data 2STR75String75
14DEX_ROW_ID Searchintint10

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 *