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

Leave a Reply

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