Payroll Year End Employee ACA (UPR10111)

azurecurveProductsMicrosoft Dynamics GP (0)PayrollPayroll Year End Employee ACA (UPR10111)

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

Product: Microsoft Dynamics GP (0)
Series: Payroll

Display Name: Payroll Year End Employee ACA
Physical Name: UPR10111
Technical Name: uprYearEndEmployeeACA

Group Display Name: Payroll Year End
Group Technical Name: Payroll Year End

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1YEAR1 SearchYearYearInteger24
2EMPLOYID SearchEmployee IDSTR15_Employee_IDString1615
3MonthofCoverage SearchMonthofCoverageDDL_1095_Line_CodeInteger20
4MonthofCoverage_1 SearchMonthofCoverage[1]DDL_1095_Line_CodeInteger20
5MonthofCoverage_2 SearchMonthofCoverage[2]DDL_1095_Line_CodeInteger20
6MonthofCoverage_3 SearchMonthofCoverage[3]DDL_1095_Line_CodeInteger20
7MonthofCoverage_4 SearchMonthofCoverage[4]DDL_1095_Line_CodeInteger20
8MonthofCoverage_5 SearchMonthofCoverage[5]DDL_1095_Line_CodeInteger20
9MonthofCoverage_6 SearchMonthofCoverage[6]DDL_1095_Line_CodeInteger20
10MonthofCoverage_7 SearchMonthofCoverage[7]DDL_1095_Line_CodeInteger20
11MonthofCoverage_8 SearchMonthofCoverage[8]DDL_1095_Line_CodeInteger20
12MonthofCoverage_9 SearchMonthofCoverage[9]DDL_1095_Line_CodeInteger20
13MonthofCoverage_10 SearchMonthofCoverage[10]DDL_1095_Line_CodeInteger20
14MonthofCoverage_11 SearchMonthofCoverage[11]DDL_1095_Line_CodeInteger20
15MonthofCoverage_12 SearchMonthofCoverage[12]DDL_1095_Line_CodeInteger20
16MonthofCost SearchMonthofCostDLR11_$S2Currency1014
17MonthofCost_1 SearchMonthofCost[1]DLR11_$S2Currency1014
18MonthofCost_2 SearchMonthofCost[2]DLR11_$S2Currency1014
19MonthofCost_3 SearchMonthofCost[3]DLR11_$S2Currency1014
20MonthofCost_4 SearchMonthofCost[4]DLR11_$S2Currency1014
21MonthofCost_5 SearchMonthofCost[5]DLR11_$S2Currency1014
22MonthofCost_6 SearchMonthofCost[6]DLR11_$S2Currency1014
23MonthofCost_7 SearchMonthofCost[7]DLR11_$S2Currency1014
24MonthofCost_8 SearchMonthofCost[8]DLR11_$S2Currency1014
25MonthofCost_9 SearchMonthofCost[9]DLR11_$S2Currency1014
26MonthofCost_10 SearchMonthofCost[10]DLR11_$S2Currency1014
27MonthofCost_11 SearchMonthofCost[11]DLR11_$S2Currency1014
28MonthofCost_12 SearchMonthofCost[12]DLR11_$S2Currency1014
29MonthofSafeHarbor SearchMonthofSafeHarborDDL_1095_Line_CodeInteger20
30MonthofSafeHarbor_1 SearchMonthofSafeHarbor[1]DDL_1095_Line_CodeInteger20
31MonthofSafeHarbor_2 SearchMonthofSafeHarbor[2]DDL_1095_Line_CodeInteger20
32MonthofSafeHarbor_3 SearchMonthofSafeHarbor[3]DDL_1095_Line_CodeInteger20
33MonthofSafeHarbor_4 SearchMonthofSafeHarbor[4]DDL_1095_Line_CodeInteger20
34MonthofSafeHarbor_5 SearchMonthofSafeHarbor[5]DDL_1095_Line_CodeInteger20
35MonthofSafeHarbor_6 SearchMonthofSafeHarbor[6]DDL_1095_Line_CodeInteger20
36MonthofSafeHarbor_7 SearchMonthofSafeHarbor[7]DDL_1095_Line_CodeInteger20
37MonthofSafeHarbor_8 SearchMonthofSafeHarbor[8]DDL_1095_Line_CodeInteger20
38MonthofSafeHarbor_9 SearchMonthofSafeHarbor[9]DDL_1095_Line_CodeInteger20
39MonthofSafeHarbor_10 SearchMonthofSafeHarbor[10]DDL_1095_Line_CodeInteger20
40MonthofSafeHarbor_11 SearchMonthofSafeHarbor[11]DDL_1095_Line_CodeInteger20
41MonthofSafeHarbor_12 SearchMonthofSafeHarbor[12]DDL_1095_Line_CodeInteger20
42CHANGEBY_I SearchChange BySTR15_User_IDString1615
43CHANGEDATE_I SearchChange DateDTDate48
44DEX_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 Year End Employee ACA (UPR10111)

Leave a Reply

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