Payroll Employee Summary (UPR00900)

azurecurveProductsMicrosoft Dynamics GP (0)PayrollPayroll Employee Summary (UPR00900)

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
Physical Name: UPR00900
Technical Name: UPR_Employee_SUM

Group Display Name: Payroll Employee Master
Group Technical Name: Payroll Employee Master

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1EMPLOYID SearchEmployee IDSTR15_Employee_IDString1615
2LPCHKNUM SearchLast Paycheck NumberCheck_NumberString2220
3LSTPCKDT SearchLast Paycheck DateDTDate48
4LPCHKAMT SearchLast Paycheck AmountDLR11_$S2Currency1014
5GROSWAGS SearchGross WagesDLR11_$S2Currency1014
6GROSWAGS_1 SearchGross Wages[1]DLR11_$S2Currency1014
7GROSWAGS_2 SearchGross Wages[2]DLR11_$S2Currency1014
8GROSWAGS_3 SearchGross Wages[3]DLR11_$S2Currency1014
9GROSWAGS_4 SearchGross Wages[4]DLR11_$S2Currency1014
10GROSWAGS_5 SearchGross Wages[5]DLR11_$S2Currency1014
11GROSWAGS_6 SearchGross Wages[6]DLR11_$S2Currency1014
12GROSWAGS_7 SearchGross Wages[7]DLR11_$S2Currency1014
13GROSWAGS_8 SearchGross Wages[8]DLR11_$S2Currency1014
14GROSWAGS_9 SearchGross Wages[9]DLR11_$S2Currency1014
15GROSWAGS_10 SearchGross Wages[10]DLR11_$S2Currency1014
16GROSWAGS_11 SearchGross Wages[11]DLR11_$S2Currency1014
17GROSWAGS_12 SearchGross Wages[12]DLR11_$S2Currency1014
18FDWTHLDG SearchFederal WithholdingDLR11_$S2Currency1014
19FDWTHLDG_1 SearchFederal Withholding[1]DLR11_$S2Currency1014
20FDWTHLDG_2 SearchFederal Withholding[2]DLR11_$S2Currency1014
21FDWTHLDG_3 SearchFederal Withholding[3]DLR11_$S2Currency1014
22FDWTHLDG_4 SearchFederal Withholding[4]DLR11_$S2Currency1014
23FDWTHLDG_5 SearchFederal Withholding[5]DLR11_$S2Currency1014
24FDWTHLDG_6 SearchFederal Withholding[6]DLR11_$S2Currency1014
25FDWTHLDG_7 SearchFederal Withholding[7]DLR11_$S2Currency1014
26FDWTHLDG_8 SearchFederal Withholding[8]DLR11_$S2Currency1014
27FDWTHLDG_9 SearchFederal Withholding[9]DLR11_$S2Currency1014
28FDWTHLDG_10 SearchFederal Withholding[10]DLR11_$S2Currency1014
29FDWTHLDG_11 SearchFederal Withholding[11]DLR11_$S2Currency1014
30FDWTHLDG_12 SearchFederal Withholding[12]DLR11_$S2Currency1014
31FICASSWG SearchFICA/Social Security WagesDLR11_$S2Currency1014
32FICASSWG_1 SearchFICA/Social Security Wages[1]DLR11_$S2Currency1014
33FICASSWG_2 SearchFICA/Social Security Wages[2]DLR11_$S2Currency1014
34FICASSWG_3 SearchFICA/Social Security Wages[3]DLR11_$S2Currency1014
35FICASSWG_4 SearchFICA/Social Security Wages[4]DLR11_$S2Currency1014
36FICASSWG_5 SearchFICA/Social Security Wages[5]DLR11_$S2Currency1014
37FICASSWG_6 SearchFICA/Social Security Wages[6]DLR11_$S2Currency1014
38FICASSWG_7 SearchFICA/Social Security Wages[7]DLR11_$S2Currency1014
39FICASSWG_8 SearchFICA/Social Security Wages[8]DLR11_$S2Currency1014
40FICASSWG_9 SearchFICA/Social Security Wages[9]DLR11_$S2Currency1014
41FICASSWG_10 SearchFICA/Social Security Wages[10]DLR11_$S2Currency1014
42FICASSWG_11 SearchFICA/Social Security Wages[11]DLR11_$S2Currency1014
43FICASSWG_12 SearchFICA/Social Security Wages[12]DLR11_$S2Currency1014
44FICAMWGS SearchFICA/Medicare WagesDLR11_$S2Currency1014
45FICAMWGS_1 SearchFICA/Medicare Wages[1]DLR11_$S2Currency1014
46FICAMWGS_2 SearchFICA/Medicare Wages[2]DLR11_$S2Currency1014
47FICAMWGS_3 SearchFICA/Medicare Wages[3]DLR11_$S2Currency1014
48FICAMWGS_4 SearchFICA/Medicare Wages[4]DLR11_$S2Currency1014
49FICAMWGS_5 SearchFICA/Medicare Wages[5]DLR11_$S2Currency1014
50FICAMWGS_6 SearchFICA/Medicare Wages[6]DLR11_$S2Currency1014
51FICAMWGS_7 SearchFICA/Medicare Wages[7]DLR11_$S2Currency1014
52FICAMWGS_8 SearchFICA/Medicare Wages[8]DLR11_$S2Currency1014
53FICAMWGS_9 SearchFICA/Medicare Wages[9]DLR11_$S2Currency1014
54FICAMWGS_10 SearchFICA/Medicare Wages[10]DLR11_$S2Currency1014
55FICAMWGS_11 SearchFICA/Medicare Wages[11]DLR11_$S2Currency1014
56FICAMWGS_12 SearchFICA/Medicare Wages[12]DLR11_$S2Currency1014
57FICASSWH SearchFICA/Social Security WithholdingDLR11_$S2Currency1014
58FICASSWH_1 SearchFICA/Social Security Withholding[1]DLR11_$S2Currency1014
59FICASSWH_2 SearchFICA/Social Security Withholding[2]DLR11_$S2Currency1014
60FICASSWH_3 SearchFICA/Social Security Withholding[3]DLR11_$S2Currency1014
61FICASSWH_4 SearchFICA/Social Security Withholding[4]DLR11_$S2Currency1014
62FICASSWH_5 SearchFICA/Social Security Withholding[5]DLR11_$S2Currency1014
63FICASSWH_6 SearchFICA/Social Security Withholding[6]DLR11_$S2Currency1014
64FICASSWH_7 SearchFICA/Social Security Withholding[7]DLR11_$S2Currency1014
65FICASSWH_8 SearchFICA/Social Security Withholding[8]DLR11_$S2Currency1014
66FICASSWH_9 SearchFICA/Social Security Withholding[9]DLR11_$S2Currency1014
67FICASSWH_10 SearchFICA/Social Security Withholding[10]DLR11_$S2Currency1014
68FICASSWH_11 SearchFICA/Social Security Withholding[11]DLR11_$S2Currency1014
69FICASSWH_12 SearchFICA/Social Security Withholding[12]DLR11_$S2Currency1014
70FICAMWDG SearchFICA/Medicare WithholdingDLR11_$S2Currency1014
71FICAMWDG_1 SearchFICA/Medicare Withholding[1]DLR11_$S2Currency1014
72FICAMWDG_2 SearchFICA/Medicare Withholding[2]DLR11_$S2Currency1014
73FICAMWDG_3 SearchFICA/Medicare Withholding[3]DLR11_$S2Currency1014
74FICAMWDG_4 SearchFICA/Medicare Withholding[4]DLR11_$S2Currency1014
75FICAMWDG_5 SearchFICA/Medicare Withholding[5]DLR11_$S2Currency1014
76FICAMWDG_6 SearchFICA/Medicare Withholding[6]DLR11_$S2Currency1014
77FICAMWDG_7 SearchFICA/Medicare Withholding[7]DLR11_$S2Currency1014
78FICAMWDG_8 SearchFICA/Medicare Withholding[8]DLR11_$S2Currency1014
79FICAMWDG_9 SearchFICA/Medicare Withholding[9]DLR11_$S2Currency1014
80FICAMWDG_10 SearchFICA/Medicare Withholding[10]DLR11_$S2Currency1014
81FICAMWDG_11 SearchFICA/Medicare Withholding[11]DLR11_$S2Currency1014
82FICAMWDG_12 SearchFICA/Medicare Withholding[12]DLR11_$S2Currency1014
83SUTAWAGS SearchSuta WagesDLR11_$S2Currency1014
84SUTAWAGS_1 SearchSuta Wages[1]DLR11_$S2Currency1014
85SUTAWAGS_2 SearchSuta Wages[2]DLR11_$S2Currency1014
86SUTAWAGS_3 SearchSuta Wages[3]DLR11_$S2Currency1014
87SUTAWAGS_4 SearchSuta Wages[4]DLR11_$S2Currency1014
88SUTAWAGS_5 SearchSuta Wages[5]DLR11_$S2Currency1014
89SUTAWAGS_6 SearchSuta Wages[6]DLR11_$S2Currency1014
90SUTAWAGS_7 SearchSuta Wages[7]DLR11_$S2Currency1014
91SUTAWAGS_8 SearchSuta Wages[8]DLR11_$S2Currency1014
92SUTAWAGS_9 SearchSuta Wages[9]DLR11_$S2Currency1014
93SUTAWAGS_10 SearchSuta Wages[10]DLR11_$S2Currency1014
94SUTAWAGS_11 SearchSuta Wages[11]DLR11_$S2Currency1014
95SUTAWAGS_12 SearchSuta Wages[12]DLR11_$S2Currency1014
96FUTAWAGS SearchFuta WagesDLR11_$S2Currency1014
97FUTAWAGS_1 SearchFuta Wages[1]DLR11_$S2Currency1014
98FUTAWAGS_2 SearchFuta Wages[2]DLR11_$S2Currency1014
99FUTAWAGS_3 SearchFuta Wages[3]DLR11_$S2Currency1014
100FUTAWAGS_4 SearchFuta Wages[4]DLR11_$S2Currency1014
101FUTAWAGS_5 SearchFuta Wages[5]DLR11_$S2Currency1014
102FUTAWAGS_6 SearchFuta Wages[6]DLR11_$S2Currency1014
103FUTAWAGS_7 SearchFuta Wages[7]DLR11_$S2Currency1014
104FUTAWAGS_8 SearchFuta Wages[8]DLR11_$S2Currency1014
105FUTAWAGS_9 SearchFuta Wages[9]DLR11_$S2Currency1014
106FUTAWAGS_10 SearchFuta Wages[10]DLR11_$S2Currency1014
107FUTAWAGS_11 SearchFuta Wages[11]DLR11_$S2Currency1014
108FUTAWAGS_12 SearchFuta Wages[12]DLR11_$S2Currency1014
109NETWAGES SearchNet WagesDLR11_$S2Currency1014
110NETWAGES_1 SearchNet Wages[1]DLR11_$S2Currency1014
111NETWAGES_2 SearchNet Wages[2]DLR11_$S2Currency1014
112NETWAGES_3 SearchNet Wages[3]DLR11_$S2Currency1014
113NETWAGES_4 SearchNet Wages[4]DLR11_$S2Currency1014
114NETWAGES_5 SearchNet Wages[5]DLR11_$S2Currency1014
115NETWAGES_6 SearchNet Wages[6]DLR11_$S2Currency1014
116NETWAGES_7 SearchNet Wages[7]DLR11_$S2Currency1014
117NETWAGES_8 SearchNet Wages[8]DLR11_$S2Currency1014
118NETWAGES_9 SearchNet Wages[9]DLR11_$S2Currency1014
119NETWAGES_10 SearchNet Wages[10]DLR11_$S2Currency1014
120NETWAGES_11 SearchNet Wages[11]DLR11_$S2Currency1014
121NETWAGES_12 SearchNet Wages[12]DLR11_$S2Currency1014
122YEAR1 SearchYearYearInteger24
123Federal_Wages SearchFederal WagesDLR11_$S2Currency1014
124Federal_Wages_1 SearchFederal Wages[1]DLR11_$S2Currency1014
125Federal_Wages_2 SearchFederal Wages[2]DLR11_$S2Currency1014
126Federal_Wages_3 SearchFederal Wages[3]DLR11_$S2Currency1014
127Federal_Wages_4 SearchFederal Wages[4]DLR11_$S2Currency1014
128Federal_Wages_5 SearchFederal Wages[5]DLR11_$S2Currency1014
129Federal_Wages_6 SearchFederal Wages[6]DLR11_$S2Currency1014
130Federal_Wages_7 SearchFederal Wages[7]DLR11_$S2Currency1014
131Federal_Wages_8 SearchFederal Wages[8]DLR11_$S2Currency1014
132Federal_Wages_9 SearchFederal Wages[9]DLR11_$S2Currency1014
133Federal_Wages_10 SearchFederal Wages[10]DLR11_$S2Currency1014
134Federal_Wages_11 SearchFederal Wages[11]DLR11_$S2Currency1014
135Federal_Wages_12 SearchFederal Wages[12]DLR11_$S2Currency1014
136DEX_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 Employee Summary (UPR00900)

Leave a Reply

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