Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/UPR00900
Product: Microsoft Dynamics GP (0)
Series: Payroll
Display Name: Payroll Employee Summary Group Display Name: Payroll Employee Master
Physical Name: UPR00900
Technical Name: UPR_Employee_SUM
Group Technical Name: Payroll Employee Master
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length |
---|---|---|---|---|---|
1 | EMPLOYID | Employee ID | String | STR15_Employee_ID | 15 |
2 | LPCHKNUM | Last Paycheck Number | String | Check_Number | 20 |
3 | LSTPCKDT | Last Paycheck Date | Date | DT | 8 |
4 | LPCHKAMT | Last Paycheck Amount | Currency | DLR11_$S2 | 14 |
5 | GROSWAGS_1 | Gross Wages[1] | Currency | DLR11_$S2 | 14 |
6 | GROSWAGS | Gross Wages | DLR11_$S2 | Currency | 14 |
7 | GROSWAGS_2 | Gross Wages[2] | Currency | DLR11_$S2 | 14 |
8 | GROSWAGS_3 | Gross Wages[3] | Currency | DLR11_$S2 | 14 |
9 | GROSWAGS_4 | Gross Wages[4] | Currency | DLR11_$S2 | 14 |
10 | GROSWAGS_5 | Gross Wages[5] | Currency | DLR11_$S2 | 14 |
11 | GROSWAGS_6 | Gross Wages[6] | Currency | DLR11_$S2 | 14 |
12 | GROSWAGS_7 | Gross Wages[7] | Currency | DLR11_$S2 | 14 |
13 | GROSWAGS_8 | Gross Wages[8] | Currency | DLR11_$S2 | 14 |
14 | GROSWAGS_9 | Gross Wages[9] | Currency | DLR11_$S2 | 14 |
15 | GROSWAGS_10 | Gross Wages[10] | Currency | DLR11_$S2 | 14 |
16 | GROSWAGS_11 | Gross Wages[11] | Currency | DLR11_$S2 | 14 |
17 | GROSWAGS_12 | Gross Wages[12] | Currency | DLR11_$S2 | 14 |
18 | FDWTHLDG_1 | Federal Withholding[1] | Currency | DLR11_$S2 | 14 |
19 | FDWTHLDG | Federal Withholding | DLR11_$S2 | Currency | 14 |
20 | FDWTHLDG_2 | Federal Withholding[2] | Currency | DLR11_$S2 | 14 |
21 | FDWTHLDG_3 | Federal Withholding[3] | Currency | DLR11_$S2 | 14 |
22 | FDWTHLDG_4 | Federal Withholding[4] | Currency | DLR11_$S2 | 14 |
23 | FDWTHLDG_5 | Federal Withholding[5] | Currency | DLR11_$S2 | 14 |
24 | FDWTHLDG_6 | Federal Withholding[6] | Currency | DLR11_$S2 | 14 |
25 | FDWTHLDG_7 | Federal Withholding[7] | Currency | DLR11_$S2 | 14 |
26 | FDWTHLDG_8 | Federal Withholding[8] | Currency | DLR11_$S2 | 14 |
27 | FDWTHLDG_9 | Federal Withholding[9] | Currency | DLR11_$S2 | 14 |
28 | FDWTHLDG_10 | Federal Withholding[10] | Currency | DLR11_$S2 | 14 |
29 | FDWTHLDG_11 | Federal Withholding[11] | Currency | DLR11_$S2 | 14 |
30 | FDWTHLDG_12 | Federal Withholding[12] | Currency | DLR11_$S2 | 14 |
31 | FICASSWG_1 | FICA/Social Security Wages[1] | Currency | DLR11_$S2 | 14 |
32 | FICASSWG_2 | FICA/Social Security Wages[2] | Currency | DLR11_$S2 | 14 |
33 | FICASSWG_3 | FICA/Social Security Wages[3] | Currency | DLR11_$S2 | 14 |
34 | FICASSWG | FICA/Social Security Wages | DLR11_$S2 | Currency | 14 |
35 | FICASSWG_4 | FICA/Social Security Wages[4] | Currency | DLR11_$S2 | 14 |
36 | FICASSWG_5 | FICA/Social Security Wages[5] | Currency | DLR11_$S2 | 14 |
37 | FICASSWG_6 | FICA/Social Security Wages[6] | Currency | DLR11_$S2 | 14 |
38 | FICASSWG_7 | FICA/Social Security Wages[7] | Currency | DLR11_$S2 | 14 |
39 | FICASSWG_8 | FICA/Social Security Wages[8] | Currency | DLR11_$S2 | 14 |
40 | FICASSWG_9 | FICA/Social Security Wages[9] | Currency | DLR11_$S2 | 14 |
41 | FICASSWG_10 | FICA/Social Security Wages[10] | Currency | DLR11_$S2 | 14 |
42 | FICASSWG_11 | FICA/Social Security Wages[11] | Currency | DLR11_$S2 | 14 |
43 | FICASSWG_12 | FICA/Social Security Wages[12] | Currency | DLR11_$S2 | 14 |
44 | FICAMWGS_1 | FICA/Medicare Wages[1] | Currency | DLR11_$S2 | 14 |
45 | FICAMWGS_2 | FICA/Medicare Wages[2] | Currency | DLR11_$S2 | 14 |
46 | FICAMWGS_3 | FICA/Medicare Wages[3] | Currency | DLR11_$S2 | 14 |
47 | FICAMWGS | FICA/Medicare Wages | DLR11_$S2 | Currency | 14 |
48 | FICAMWGS_4 | FICA/Medicare Wages[4] | Currency | DLR11_$S2 | 14 |
49 | FICAMWGS_5 | FICA/Medicare Wages[5] | Currency | DLR11_$S2 | 14 |
50 | FICAMWGS_6 | FICA/Medicare Wages[6] | Currency | DLR11_$S2 | 14 |
51 | FICAMWGS_7 | FICA/Medicare Wages[7] | Currency | DLR11_$S2 | 14 |
52 | FICAMWGS_8 | FICA/Medicare Wages[8] | Currency | DLR11_$S2 | 14 |
53 | FICAMWGS_9 | FICA/Medicare Wages[9] | Currency | DLR11_$S2 | 14 |
54 | FICAMWGS_10 | FICA/Medicare Wages[10] | Currency | DLR11_$S2 | 14 |
55 | FICAMWGS_11 | FICA/Medicare Wages[11] | Currency | DLR11_$S2 | 14 |
56 | FICAMWGS_12 | FICA/Medicare Wages[12] | Currency | DLR11_$S2 | 14 |
57 | FICASSWH_1 | FICA/Social Security Withholding[1] | Currency | DLR11_$S2 | 14 |
58 | FICASSWH_2 | FICA/Social Security Withholding[2] | Currency | DLR11_$S2 | 14 |
59 | FICASSWH_3 | FICA/Social Security Withholding[3] | Currency | DLR11_$S2 | 14 |
60 | FICASSWH_4 | FICA/Social Security Withholding[4] | Currency | DLR11_$S2 | 14 |
61 | FICASSWH_5 | FICA/Social Security Withholding[5] | Currency | DLR11_$S2 | 14 |
62 | FICASSWH | FICA/Social Security Withholding | DLR11_$S2 | Currency | 14 |
63 | FICASSWH_6 | FICA/Social Security Withholding[6] | Currency | DLR11_$S2 | 14 |
64 | FICASSWH_7 | FICA/Social Security Withholding[7] | Currency | DLR11_$S2 | 14 |
65 | FICASSWH_8 | FICA/Social Security Withholding[8] | Currency | DLR11_$S2 | 14 |
66 | FICASSWH_9 | FICA/Social Security Withholding[9] | Currency | DLR11_$S2 | 14 |
67 | FICASSWH_10 | FICA/Social Security Withholding[10] | Currency | DLR11_$S2 | 14 |
68 | FICASSWH_11 | FICA/Social Security Withholding[11] | Currency | DLR11_$S2 | 14 |
69 | FICASSWH_12 | FICA/Social Security Withholding[12] | Currency | DLR11_$S2 | 14 |
70 | FICAMWDG_1 | FICA/Medicare Withholding[1] | Currency | DLR11_$S2 | 14 |
71 | FICAMWDG_2 | FICA/Medicare Withholding[2] | Currency | DLR11_$S2 | 14 |
72 | FICAMWDG_3 | FICA/Medicare Withholding[3] | Currency | DLR11_$S2 | 14 |
73 | FICAMWDG_4 | FICA/Medicare Withholding[4] | Currency | DLR11_$S2 | 14 |
74 | FICAMWDG_5 | FICA/Medicare Withholding[5] | Currency | DLR11_$S2 | 14 |
75 | FICAMWDG | FICA/Medicare Withholding | DLR11_$S2 | Currency | 14 |
76 | FICAMWDG_6 | FICA/Medicare Withholding[6] | Currency | DLR11_$S2 | 14 |
77 | FICAMWDG_7 | FICA/Medicare Withholding[7] | Currency | DLR11_$S2 | 14 |
78 | FICAMWDG_8 | FICA/Medicare Withholding[8] | Currency | DLR11_$S2 | 14 |
79 | FICAMWDG_9 | FICA/Medicare Withholding[9] | Currency | DLR11_$S2 | 14 |
80 | FICAMWDG_10 | FICA/Medicare Withholding[10] | Currency | DLR11_$S2 | 14 |
81 | FICAMWDG_11 | FICA/Medicare Withholding[11] | Currency | DLR11_$S2 | 14 |
82 | FICAMWDG_12 | FICA/Medicare Withholding[12] | Currency | DLR11_$S2 | 14 |
83 | SUTAWAGS_1 | Suta Wages[1] | Currency | DLR11_$S2 | 14 |
84 | SUTAWAGS_2 | Suta Wages[2] | Currency | DLR11_$S2 | 14 |
85 | SUTAWAGS_3 | Suta Wages[3] | Currency | DLR11_$S2 | 14 |
86 | SUTAWAGS_4 | Suta Wages[4] | Currency | DLR11_$S2 | 14 |
87 | SUTAWAGS_5 | Suta Wages[5] | Currency | DLR11_$S2 | 14 |
88 | SUTAWAGS_6 | Suta Wages[6] | Currency | DLR11_$S2 | 14 |
89 | SUTAWAGS_7 | Suta Wages[7] | Currency | DLR11_$S2 | 14 |
90 | SUTAWAGS | Suta Wages | DLR11_$S2 | Currency | 14 |
91 | SUTAWAGS_8 | Suta Wages[8] | Currency | DLR11_$S2 | 14 |
92 | SUTAWAGS_9 | Suta Wages[9] | Currency | DLR11_$S2 | 14 |
93 | SUTAWAGS_10 | Suta Wages[10] | Currency | DLR11_$S2 | 14 |
94 | SUTAWAGS_11 | Suta Wages[11] | Currency | DLR11_$S2 | 14 |
95 | SUTAWAGS_12 | Suta Wages[12] | Currency | DLR11_$S2 | 14 |
96 | FUTAWAGS_1 | Futa Wages[1] | Currency | DLR11_$S2 | 14 |
97 | FUTAWAGS_2 | Futa Wages[2] | Currency | DLR11_$S2 | 14 |
98 | FUTAWAGS_3 | Futa Wages[3] | Currency | DLR11_$S2 | 14 |
99 | FUTAWAGS_4 | Futa Wages[4] | Currency | DLR11_$S2 | 14 |
100 | FUTAWAGS_5 | Futa Wages[5] | Currency | DLR11_$S2 | 14 |
101 | FUTAWAGS_6 | Futa Wages[6] | Currency | DLR11_$S2 | 14 |
102 | FUTAWAGS_7 | Futa Wages[7] | Currency | DLR11_$S2 | 14 |
103 | FUTAWAGS | Futa Wages | DLR11_$S2 | Currency | 14 |
104 | FUTAWAGS_8 | Futa Wages[8] | Currency | DLR11_$S2 | 14 |
105 | FUTAWAGS_9 | Futa Wages[9] | Currency | DLR11_$S2 | 14 |
106 | FUTAWAGS_10 | Futa Wages[10] | Currency | DLR11_$S2 | 14 |
107 | FUTAWAGS_11 | Futa Wages[11] | Currency | DLR11_$S2 | 14 |
108 | FUTAWAGS_12 | Futa Wages[12] | Currency | DLR11_$S2 | 14 |
109 | NETWAGES_1 | Net Wages[1] | Currency | DLR11_$S2 | 14 |
110 | NETWAGES_2 | Net Wages[2] | Currency | DLR11_$S2 | 14 |
111 | NETWAGES_3 | Net Wages[3] | Currency | DLR11_$S2 | 14 |
112 | NETWAGES_4 | Net Wages[4] | Currency | DLR11_$S2 | 14 |
113 | NETWAGES_5 | Net Wages[5] | Currency | DLR11_$S2 | 14 |
114 | NETWAGES_6 | Net Wages[6] | Currency | DLR11_$S2 | 14 |
115 | NETWAGES_7 | Net Wages[7] | Currency | DLR11_$S2 | 14 |
116 | NETWAGES_8 | Net Wages[8] | Currency | DLR11_$S2 | 14 |
117 | NETWAGES | Net Wages | DLR11_$S2 | Currency | 14 |
118 | NETWAGES_9 | Net Wages[9] | Currency | DLR11_$S2 | 14 |
119 | NETWAGES_10 | Net Wages[10] | Currency | DLR11_$S2 | 14 |
120 | NETWAGES_11 | Net Wages[11] | Currency | DLR11_$S2 | 14 |
121 | NETWAGES_12 | Net Wages[12] | Currency | DLR11_$S2 | 14 |
122 | YEAR1 | Year | Integer | Year | 4 |
123 | Federal_Wages_1 | Federal Wages[1] | Currency | DLR11_$S2 | 14 |
124 | Federal_Wages_2 | Federal Wages[2] | Currency | DLR11_$S2 | 14 |
125 | Federal_Wages_3 | Federal Wages[3] | Currency | DLR11_$S2 | 14 |
126 | Federal_Wages_4 | Federal Wages[4] | Currency | DLR11_$S2 | 14 |
127 | Federal_Wages_5 | Federal Wages[5] | Currency | DLR11_$S2 | 14 |
128 | Federal_Wages_6 | Federal Wages[6] | Currency | DLR11_$S2 | 14 |
129 | Federal_Wages_7 | Federal Wages[7] | Currency | DLR11_$S2 | 14 |
130 | Federal_Wages_8 | Federal Wages[8] | Currency | DLR11_$S2 | 14 |
131 | Federal_Wages_9 | Federal Wages[9] | Currency | DLR11_$S2 | 14 |
132 | Federal_Wages_10 | Federal Wages[10] | Currency | DLR11_$S2 | 14 |
133 | Federal_Wages | Federal Wages | DLR11_$S2 | Currency | 14 |
134 | Federal_Wages_11 | Federal Wages[11] | Currency | DLR11_$S2 | 14 |
135 | Federal_Wages_12 | Federal Wages[12] | Currency | DLR11_$S2 | 14 |