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

Leave a Reply

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