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 TypeLength
1RPTNGYR SearchReporting YearINT4_U0Integer4
2EPRIDNBR SearchEmployer ID NumberSTR9_Employer_ID_NumberString9
3YENDCRTD SearchYear End CreatedCBBoolean0
4ESTIDNBR SearchEmployer State ID NumberSTR20String20
5LOCATNID SearchLocation IDSTR15_Location_IDString15
6CMPNYNAM SearchCompany NameSTR64_Company_NameString64
7ADDRESS1 SearchAddress 1STR60String60
8ADDRESS2 SearchAddress 2STR60String60
9ADDRESS3 SearchAddress 3STR60String60
10CITY SearchCitySTR35String35
11STATE SearchStateSTR30_StateString29
12ZIPCODE SearchZip CodeSTR10String10
13INACW2RN SearchInactives W-2 RunBooleanBoolean0
14YEPRW2SK SearchYear End Print Regular W2 Sort KeyINT2Integer2
15YPMQGEW2 SearchYear End Print MQGE W2 Sort KeyINT2Integer2
16YP1099RS SearchYear End Print 1099R Sort KeyINT2Integer2
17FICASSTR SearchFICA/Social Security Tax RateLI6_U4Long Integer6
18FICASSWL SearchFICA/Social Security Wage LimitDLR11_U2Currency14
19TICAMTRT SearchFICA/Medicare Tax RateLI6_U4Long Integer6
20FICAMWLM SearchFICA/Medicare Wage LimitDLR11_U2Currency14
21EICMXWHG SearchEIC Maximum WithholdingDLR11_U2Currency14
22Establishment_Type SearchEstablishment TypeDDL_Establishment_TypeInteger0
23Establishment_Number SearchEstablishment NumberSTR5String5
24Charged_Tips SearchCharged TipsDLR11_$S2Currency14
25Charged_Receipts SearchCharged ReceiptsDLR11_$S2Currency14
26Indirect_Tips SearchIndirect TipsDLR11_$S2Currency14
27Direct_Tips SearchDirect TipsDLR11_$S2Currency14
28RECEIPTS SearchReceiptsDLR11_$S2Currency14
29Directly_Tipped SearchDirectly TippedINT5_U0Integer5
30Return_Type SearchReturn TypeGB_ReturnTypeInteger0
31Reported_Tips SearchReported TipsDLR11_$S2Currency14
32ALOCTIPS SearchAllocated TipsDLR11_RU2NC_Year_EndCurrency14
33EmployerKind SearchEmployer KindDDL_Employer_KindInteger0
34PHONE1 SearchPhone 1Phone_NumberString14
35Employer_SelfInsured SearchEmployer Self-InsuredCB_EmployerSelfInsuredBoolean0
36PayerKind SearchPayer KindDDL_Payer_KindInteger0
37W2Published SearchW2PublishedCB_W2PublishedBoolean0
38DEX_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 Year End Header (UPR10100)

Leave a Reply

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