Payroll Year End Pension (UPR10103)

azurecurveProductsMicrosoft Dynamics GP (0)PayrollPayroll Year End Pension (UPR10103)

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

Product: Microsoft Dynamics GP (0)
Series: Payroll

Display Name: Payroll Year End Pension
Physical Name: UPR10103
Technical Name: UPR_Year_End_WORK_Pension

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
2LASTNAME SearchLast NameSTR20String2220
3FRSTNAME SearchFirst NameSTR15String1615
4MIDLNAME SearchMiddle NameSTR15String1615
5ADDRESS1 SearchAddress 1STR60String6260
6ADDRESS2 SearchAddress 2STR60String6260
7ADDRESS3 SearchAddress 3STR60String6260
8CITY SearchCitySTR35String3635
9STATE SearchStateSTR30_StateString3029
10ZIPCODE SearchZip CodeSTR10String1210
11EMPLOYID SearchEmployee IDSTR15_Employee_IDString1615
12SOCSCNUM SearchSocial Security NumberSTR15_Social_Security_NumberString1615
13DEPRTMNT SearchDepartmentSTR6_Payroll_CodeString86
14GROSDIST SearchGross DistributionDLR11_RU2NC_Year_EndCurrency1014
15TXBAMNDT SearchTaxable Amount Not DeterminedCB_Taxable_Amount_Not_DeterminedBoolean20
16TAMD1099 SearchTaxable Amt Dtrmnd 1099DLR11_RU2NC_Year_EndCurrency1014
17TOTDSTCB SearchTotal Distribution CBCB_Total_DistributionBoolean20
18CAPTLGAIN SearchCapital GainDLR11_RU2NC_Year_EndCurrency1014
19FEDITXWH SearchFederal Income Tax W/HDLR11_RU2NC_Year_EndCurrency1014
20EMPLECTR SearchEmployee ContributionsDLR11_RU2NC_Year_EndCurrency1014
21NTREALAP SearchNet Realized AppreciationDLR11_RU2NC_Year_EndCurrency1014
22DSTCODE1 SearchDistribution Code 1STR1_LBUString21
23DSTCODE2 SearchDistribution Code 2STR1_LBUString21
24DSTCODE3 SearchDistribution Code 3STR1_LBUString21
25IRASEPCB SearchIRA/SEP CBCB_IRA/SEPBoolean20
26OTAM1099 SearchOther Amount 1099-RDLR11_RU2NC_Year_EndCurrency1014
27OTPC1099 SearchOther Percentage 1099-RDLR7_%5Currency107
28TTLTDSTPC SearchTotal Distribution PercentageDLR8_S5%Currency108
29STATWGS1 SearchState Wages-1DLR11_RU2NC_Year_EndCurrency1014
30STATWGS2 SearchState Wages-2DLR11_RU2NC_Year_EndCurrency1014
31STAINTX1 SearchState Income Tax-1DLR11_RU2NC_Year_EndCurrency1014
32STAINTX2 SearchState Income Tax-2DLR11_RU2NC_Year_EndCurrency1014
33STATECD1 SearchState Code-1STR2_State_CodeString42
34STATECD2 SearchState Code-2STR2_State_CodeString42
35ESTIDNR1 SearchEmployer State ID Number-1STR20String2220
36ESTIDBR2 SearchEmployer State ID Number-2STR20String2220
37LCLWGES1 SearchLocal Wages-1DLR11_RU2NC_Year_EndCurrency1014
38LCLWGS2 SearchLocal Wages-2DLR11_RU2NC_Year_EndCurrency1014
39LCLINTX1 SearchLocal Income Tax-1DLR11_RU2NC_Year_EndCurrency1014
40LCLINTX2 SearchLocal Income Tax-2DLR11_RU2NC_Year_EndCurrency1014
41LCLCODE1 SearchLocal Code-1STR6_Payroll_CodeString86
42LCLCODE2 SearchLocal Code-2STR6_Payroll_CodeString86
43Y1099RFC SearchYear End 1099R Forms CountLI_9U0Long Integer49
44EMPLSUFF SearchEmployee SuffixSTR4_Employee_SuffixString64
45DEX_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.

azurecurveProductsMicrosoft Dynamics GP (0)PayrollPayroll Year End Pension (UPR10103)

Leave a Reply

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