Payroll Year End Header (UPR10100)

azurecurveProductsMicrosoft Dynamics GP (0)PayrollPayroll Year End Header (UPR10100)

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

Product: Microsoft Dynamics GP (0)
Series: Payroll

Display Name: Payroll Year End Header
Physical Name: UPR10100
Technical Name: UPR_Year_End_WORK_HDR

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1RPTNGYR SearchReporting YearINT4_U0Integer24
2EPRIDNBR SearchEmployer ID NumberSTR9_Employer_ID_NumberString109
3YENDCRTD SearchYear End CreatedCBBoolean20
4ESTIDNBR SearchEmployer State ID NumberSTR20String2220
5LOCATNID SearchLocation IDSTR15_Location_IDString1615
6CMPNYNAM SearchCompany NameSTR64_Company_NameString6664
7ADDRESS1 SearchAddress 1STR60String6260
8ADDRESS2 SearchAddress 2STR60String6260
9ADDRESS3 SearchAddress 3STR60String6260
10CITY SearchCitySTR35String3635
11STATE SearchStateSTR30_StateString3029
12ZIPCODE SearchZip CodeSTR10String1210
13INACW2RN SearchInactives W-2 RunBooleanBoolean20
14YEPRW2SK SearchYear End Print Regular W2 Sort KeyINT2Integer22
15YPMQGEW2 SearchYear End Print MQGE W2 Sort KeyINT2Integer22
16YP1099RS SearchYear End Print 1099R Sort KeyINT2Integer22
17FICASSTR SearchFICA/Social Security Tax RateLI6_U4Long Integer46
18FICASSWL SearchFICA/Social Security Wage LimitDLR11_U2Currency1014
19TICAMTRT SearchFICA/Medicare Tax RateLI6_U4Long Integer46
20FICAMWLM SearchFICA/Medicare Wage LimitDLR11_U2Currency1014
21EICMXWHG SearchEIC Maximum WithholdingDLR11_U2Currency1014
22Establishment_Type SearchEstablishment TypeDDL_Establishment_TypeInteger20
23Establishment_Number SearchEstablishment NumberSTR5String65
24Charged_Tips SearchCharged TipsDLR11_$S2Currency1014
25Charged_Receipts SearchCharged ReceiptsDLR11_$S2Currency1014
26Indirect_Tips SearchIndirect TipsDLR11_$S2Currency1014
27Direct_Tips SearchDirect TipsDLR11_$S2Currency1014
28RECEIPTS SearchReceiptsDLR11_$S2Currency1014
29Directly_Tipped SearchDirectly TippedINT5_U0Integer25
30Return_Type SearchReturn TypeGB_ReturnTypeInteger20
31Reported_Tips SearchReported TipsDLR11_$S2Currency1014
32ALOCTIPS SearchAllocated TipsDLR11_RU2NC_Year_EndCurrency1014
33EmployerKind SearchEmployer KindDDL_Employer_KindInteger20
34PHONE1 SearchPhone 1Phone_NumberString2214
35Employer_SelfInsured SearchEmployer Self-InsuredCB_EmployerSelfInsuredBoolean20
36PayerKind SearchPayer KindDDL_Payer_KindInteger20
37W2Published SearchW2PublishedCB_W2PublishedBoolean20
38DEX_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 Header (UPR10100)

Leave a Reply

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