Payroll Transaction History Header (UPR30301)

azurecurveProductsMicrosoft Dynamics GP (0)PayrollPayroll Transaction History Header (UPR30301)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/UPR30301

Product: Microsoft Dynamics GP (0)
Series: Payroll

Display Name: Payroll Transaction History Header
Physical Name: UPR30301
Technical Name: UPR_Transaction_HIST_HDR

Group Display Name: Payroll Transaction History
Group Technical Name: Payroll Transaction History

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1EMPLOYID SearchEmployee IDSTR15_Employee_IDString1615
2YEAR1 SearchYearYearInteger24
3PYRLRTYP SearchPayroll Record TypeDDL_Payroll_Record_TypeInteger20
4PAYROLCD SearchPayroll CodeSTR6_Payroll_CodeString86
5MTDWAGES SearchMTD WagesDLR11_$S2Currency1014
6MTDWAGES_1 SearchMTD Wages[1]DLR11_$S2Currency1014
7MTDWAGES_2 SearchMTD Wages[2]DLR11_$S2Currency1014
8MTDWAGES_3 SearchMTD Wages[3]DLR11_$S2Currency1014
9MTDWAGES_4 SearchMTD Wages[4]DLR11_$S2Currency1014
10MTDWAGES_5 SearchMTD Wages[5]DLR11_$S2Currency1014
11MTDWAGES_6 SearchMTD Wages[6]DLR11_$S2Currency1014
12MTDWAGES_7 SearchMTD Wages[7]DLR11_$S2Currency1014
13MTDWAGES_8 SearchMTD Wages[8]DLR11_$S2Currency1014
14MTDWAGES_9 SearchMTD Wages[9]DLR11_$S2Currency1014
15MTDWAGES_10 SearchMTD Wages[10]DLR11_$S2Currency1014
16MTDWAGES_11 SearchMTD Wages[11]DLR11_$S2Currency1014
17MTDWAGES_12 SearchMTD Wages[12]DLR11_$S2Currency1014
18MTDHOURS SearchMTD HoursLI6_S2Long Integer46
19MTDHOURS_1 SearchMTD Hours[1]LI6_S2Long Integer46
20MTDHOURS_2 SearchMTD Hours[2]LI6_S2Long Integer46
21MTDHOURS_3 SearchMTD Hours[3]LI6_S2Long Integer46
22MTDHOURS_4 SearchMTD Hours[4]LI6_S2Long Integer46
23MTDHOURS_5 SearchMTD Hours[5]LI6_S2Long Integer46
24MTDHOURS_6 SearchMTD Hours[6]LI6_S2Long Integer46
25MTDHOURS_7 SearchMTD Hours[7]LI6_S2Long Integer46
26MTDHOURS_8 SearchMTD Hours[8]LI6_S2Long Integer46
27MTDHOURS_9 SearchMTD Hours[9]LI6_S2Long Integer46
28MTDHOURS_10 SearchMTD Hours[10]LI6_S2Long Integer46
29MTDHOURS_11 SearchMTD Hours[11]LI6_S2Long Integer46
30MTDHOURS_12 SearchMTD Hours[12]LI6_S2Long Integer46
31STXBLWGS SearchState Taxable WagesDLR11_$S2Currency1014
32STXBLWGS_1 SearchState Taxable Wages[1]DLR11_$S2Currency1014
33STXBLWGS_2 SearchState Taxable Wages[2]DLR11_$S2Currency1014
34STXBLWGS_3 SearchState Taxable Wages[3]DLR11_$S2Currency1014
35STXBLWGS_4 SearchState Taxable Wages[4]DLR11_$S2Currency1014
36STXBLWGS_5 SearchState Taxable Wages[5]DLR11_$S2Currency1014
37STXBLWGS_6 SearchState Taxable Wages[6]DLR11_$S2Currency1014
38STXBLWGS_7 SearchState Taxable Wages[7]DLR11_$S2Currency1014
39STXBLWGS_8 SearchState Taxable Wages[8]DLR11_$S2Currency1014
40STXBLWGS_9 SearchState Taxable Wages[9]DLR11_$S2Currency1014
41STXBLWGS_10 SearchState Taxable Wages[10]DLR11_$S2Currency1014
42STXBLWGS_11 SearchState Taxable Wages[11]DLR11_$S2Currency1014
43STXBLWGS_12 SearchState Taxable Wages[12]DLR11_$S2Currency1014
44LCTXBLWG SearchLocal Taxable WagesDLR11_$S2Currency1014
45LCTXBLWG_1 SearchLocal Taxable Wages[1]DLR11_$S2Currency1014
46LCTXBLWG_2 SearchLocal Taxable Wages[2]DLR11_$S2Currency1014
47LCTXBLWG_3 SearchLocal Taxable Wages[3]DLR11_$S2Currency1014
48LCTXBLWG_4 SearchLocal Taxable Wages[4]DLR11_$S2Currency1014
49LCTXBLWG_5 SearchLocal Taxable Wages[5]DLR11_$S2Currency1014
50LCTXBLWG_6 SearchLocal Taxable Wages[6]DLR11_$S2Currency1014
51LCTXBLWG_7 SearchLocal Taxable Wages[7]DLR11_$S2Currency1014
52LCTXBLWG_8 SearchLocal Taxable Wages[8]DLR11_$S2Currency1014
53LCTXBLWG_9 SearchLocal Taxable Wages[9]DLR11_$S2Currency1014
54LCTXBLWG_10 SearchLocal Taxable Wages[10]DLR11_$S2Currency1014
55LCTXBLWG_11 SearchLocal Taxable Wages[11]DLR11_$S2Currency1014
56LCTXBLWG_12 SearchLocal Taxable Wages[12]DLR11_$S2Currency1014
57DEX_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 Transaction History Header (UPR30301)

Leave a Reply

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