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 TypeLength
1RPTNGYR SearchReporting YearINT4_U0Integer4
2LASTNAME SearchLast NameSTR20String20
3FRSTNAME SearchFirst NameSTR15String15
4MIDLNAME SearchMiddle NameSTR15String15
5ADDRESS1 SearchAddress 1STR60String60
6ADDRESS2 SearchAddress 2STR60String60
7ADDRESS3 SearchAddress 3STR60String60
8CITY SearchCitySTR35String35
9STATE SearchStateSTR30_StateString29
10ZIPCODE SearchZip CodeSTR10String10
11EMPLOYID SearchEmployee IDSTR15_Employee_IDString15
12SOCSCNUM SearchSocial Security NumberSTR15_Social_Security_NumberString15
13DEPRTMNT SearchDepartmentSTR6_Payroll_CodeString6
14GROSDIST SearchGross DistributionDLR11_RU2NC_Year_EndCurrency14
15TXBAMNDT SearchTaxable Amount Not DeterminedCB_Taxable_Amount_Not_DeterminedBoolean0
16TAMD1099 SearchTaxable Amt Dtrmnd 1099DLR11_RU2NC_Year_EndCurrency14
17TOTDSTCB SearchTotal Distribution CBCB_Total_DistributionBoolean0
18CAPTLGAIN SearchCapital GainDLR11_RU2NC_Year_EndCurrency14
19FEDITXWH SearchFederal Income Tax W/HDLR11_RU2NC_Year_EndCurrency14
20EMPLECTR SearchEmployee ContributionsDLR11_RU2NC_Year_EndCurrency14
21NTREALAP SearchNet Realized AppreciationDLR11_RU2NC_Year_EndCurrency14
22DSTCODE1 SearchDistribution Code 1STR1_LBUString1
23DSTCODE2 SearchDistribution Code 2STR1_LBUString1
24DSTCODE3 SearchDistribution Code 3STR1_LBUString1
25IRASEPCB SearchIRA/SEP CBCB_IRA/SEPBoolean0
26OTAM1099 SearchOther Amount 1099-RDLR11_RU2NC_Year_EndCurrency14
27OTPC1099 SearchOther Percentage 1099-RDLR7_%5Currency7
28TTLTDSTPC SearchTotal Distribution PercentageDLR8_S5%Currency8
29STATWGS1 SearchState Wages-1DLR11_RU2NC_Year_EndCurrency14
30STATWGS2 SearchState Wages-2DLR11_RU2NC_Year_EndCurrency14
31STAINTX1 SearchState Income Tax-1DLR11_RU2NC_Year_EndCurrency14
32STAINTX2 SearchState Income Tax-2DLR11_RU2NC_Year_EndCurrency14
33STATECD1 SearchState Code-1STR2_State_CodeString2
34STATECD2 SearchState Code-2STR2_State_CodeString2
35ESTIDNR1 SearchEmployer State ID Number-1STR20String20
36ESTIDBR2 SearchEmployer State ID Number-2STR20String20
37LCLWGES1 SearchLocal Wages-1DLR11_RU2NC_Year_EndCurrency14
38LCLWGS2 SearchLocal Wages-2DLR11_RU2NC_Year_EndCurrency14
39LCLINTX1 SearchLocal Income Tax-1DLR11_RU2NC_Year_EndCurrency14
40LCLINTX2 SearchLocal Income Tax-2DLR11_RU2NC_Year_EndCurrency14
41LCLCODE1 SearchLocal Code-1STR6_Payroll_CodeString6
42LCLCODE2 SearchLocal Code-2STR6_Payroll_CodeString6
43Y1099RFC SearchYear End 1099R Forms CountLI_9U0Long Integer9
44EMPLSUFF SearchEmployee SuffixSTR4_Employee_SuffixString4
45DEX_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.

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

Leave a Reply

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