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 |