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 Group Display Name: Payroll Year End
Physical Name: UPR10103
Technical Name: UPR_Year_End_WORK_Pension
Group Technical Name: Payroll Year End
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length |
---|---|---|---|---|---|
1 | RPTNGYR ![]() | Reporting Year | Integer | INT4_U0 | 4 |
2 | LASTNAME ![]() | Last Name | String | STR20 | 20 |
3 | FRSTNAME ![]() | First Name | String | STR15 | 15 |
4 | MIDLNAME ![]() | Middle Name | String | STR15 | 15 |
5 | ADDRESS1 ![]() | Address 1 | String | STR60 | 60 |
6 | ADDRESS2 ![]() | Address 2 | String | STR60 | 60 |
7 | ADDRESS3 ![]() | Address 3 | String | STR60 | 60 |
8 | CITY ![]() | City | String | STR35 | 35 |
9 | STATE ![]() | State | String | STR30_State | 29 |
10 | ZIPCODE ![]() | Zip Code | String | STR10 | 10 |
11 | EMPLOYID ![]() | Employee ID | String | STR15_Employee_ID | 15 |
12 | SOCSCNUM ![]() | Social Security Number | String | STR15_Social_Security_Number | 15 |
13 | DEPRTMNT ![]() | Department | String | STR6_Payroll_Code | 6 |
14 | GROSDIST ![]() | Gross Distribution | Currency | DLR11_RU2NC_Year_End | 14 |
15 | TXBAMNDT ![]() | Taxable Amount Not Determined | Boolean | CB_Taxable_Amount_Not_Determined | 0 |
16 | TAMD1099 ![]() | Taxable Amt Dtrmnd 1099 | Currency | DLR11_RU2NC_Year_End | 14 |
17 | TOTDSTCB ![]() | Total Distribution CB | Boolean | CB_Total_Distribution | 0 |
18 | CAPTLGAIN ![]() | Capital Gain | Currency | DLR11_RU2NC_Year_End | 14 |
19 | FEDITXWH ![]() | Federal Income Tax W/H | Currency | DLR11_RU2NC_Year_End | 14 |
20 | EMPLECTR ![]() | Employee Contributions | Currency | DLR11_RU2NC_Year_End | 14 |
21 | NTREALAP ![]() | Net Realized Appreciation | Currency | DLR11_RU2NC_Year_End | 14 |
22 | DSTCODE1 ![]() | Distribution Code 1 | String | STR1_LBU | 1 |
23 | DSTCODE2 ![]() | Distribution Code 2 | String | STR1_LBU | 1 |
24 | DSTCODE3 ![]() | Distribution Code 3 | String | STR1_LBU | 1 |
25 | IRASEPCB ![]() | IRA/SEP CB | Boolean | CB_IRA/SEP | 0 |
26 | OTAM1099 ![]() | Other Amount 1099-R | Currency | DLR11_RU2NC_Year_End | 14 |
27 | OTPC1099 ![]() | Other Percentage 1099-R | Currency | DLR7_%5 | 7 |
28 | TTLTDSTPC ![]() | Total Distribution Percentage | Currency | DLR8_S5% | 8 |
29 | STATWGS1 ![]() | State Wages-1 | Currency | DLR11_RU2NC_Year_End | 14 |
30 | STATWGS2 ![]() | State Wages-2 | Currency | DLR11_RU2NC_Year_End | 14 |
31 | STAINTX1 ![]() | State Income Tax-1 | Currency | DLR11_RU2NC_Year_End | 14 |
32 | STAINTX2 ![]() | State Income Tax-2 | Currency | DLR11_RU2NC_Year_End | 14 |
33 | STATECD1 ![]() | State Code-1 | String | STR2_State_Code | 2 |
34 | STATECD2 ![]() | State Code-2 | String | STR2_State_Code | 2 |
35 | ESTIDNR1 ![]() | Employer State ID Number-1 | String | STR20 | 20 |
36 | ESTIDBR2 ![]() | Employer State ID Number-2 | String | STR20 | 20 |
37 | LCLWGES1 ![]() | Local Wages-1 | Currency | DLR11_RU2NC_Year_End | 14 |
38 | LCLWGS2 ![]() | Local Wages-2 | Currency | DLR11_RU2NC_Year_End | 14 |
39 | LCLINTX1 ![]() | Local Income Tax-1 | Currency | DLR11_RU2NC_Year_End | 14 |
40 | LCLINTX2 ![]() | Local Income Tax-2 | Currency | DLR11_RU2NC_Year_End | 14 |
41 | LCLCODE1 ![]() | Local Code-1 | String | STR6_Payroll_Code | 6 |
42 | LCLCODE2 ![]() | Local Code-2 | String | STR6_Payroll_Code | 6 |
43 | Y1099RFC ![]() | Year End 1099R Forms Count | Long Integer | LI_9U0 | 9 |
44 | EMPLSUFF ![]() | Employee Suffix | String | STR4_Employee_Suffix | 4 |