Payroll Year End Wage (UPR10101)

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

Product: Microsoft Dynamics GP (0)
Series: Payroll

Display Name: Payroll Year End Wage
Physical Name: UPR10101
Technical Name: UPR_Year_End_WORK_Wage

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
2MCRQGEMP SearchMedicare Qualified Govt EmployeeCB_Medicare_Qualified_Govt_EmployeeBoolean20
3DEPRTMNT SearchDepartmentSTR6_Payroll_CodeString86
4LASTNAME SearchLast NameSTR20String2220
5FRSTNAME SearchFirst NameSTR15String1615
6MIDLNAME SearchMiddle NameSTR15String1615
7SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer410
8ADDRESS1 SearchAddress 1STR60String6260
9ADDRESS2 SearchAddress 2STR60String6260
10ADDRESS3 SearchAddress 3STR60String6260
11CITY SearchCitySTR35String3635
12STATE SearchStateSTR30_StateString3029
13ZIPCODE SearchZip CodeSTR10String1210
14Foreign_Address SearchForeign AddressCB_Foreign_AddressBoolean20
15Foreign_StateProvince SearchForeign State/ProvinceSTR23String2423
16Foreign_Postal_Code SearchForeign Postal CodeSTR15_LBAUString1615
17CCode SearchCountry CodeSTR6_VATString86
Key to the VAT Country Code MSTR (VAT10001).

Click to show/hide

SELECT
       ['Payroll Year End Wage'].CCode AS 'Payroll Year End Wage-Country Code'
       ,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
       UPR10101 AS ['Payroll Year End Wage']
INNER JOIN
       VAT10001 AS ['VAT Country Code MSTR']
              ON
                     ['Payroll Year End Wage'].CCode = ['VAT Country Code MSTR'].CCode
18W2CTRNBR SearchW2 Control NumberSTR7_LBAUString87
19EMPLOYID SearchEmployee IDSTR15_Employee_IDString1615
20SOCSCNUM SearchSocial Security NumberSTR15_Social_Security_NumberString1615
21W2BFSTEM SearchW2 Box For Statutory EmployeeCB_Statutory_EmployeeBoolean20
22W2BFDCSD SearchW2 Box For DeceasedCB_DeceasedBoolean20
23W2BFPPLN SearchW2 Box For Pension PlanCB_Pension_PlanBoolean20
24W2BFLREP SearchW2 Box For Legal RepresentativeCB_Legal_RepresentativeBoolean20
25W2BF942E SearchW2 Box For 942 EmployeeCB_942_EmployeeBoolean20
26W2BFSTTL SearchW2 Box For SubtotalSTR1String21
27W2BFDCMP SearchW2 Box For Deferred CompensationCB_Deferred_CompensationBoolean20
28WGTPCOMP SearchWages, Tips, Other CompensationDLR11_RU2NC_Year_EndCurrency1014
29FEDITXWH SearchFederal Income Tax W/HDLR11_RU2NC_Year_EndCurrency1014
30SSECWAGS SearchSocial Security WagesDLR11_RU2NC_Year_EndCurrency1014
31SSTXWHLD SearchSocial Security Tax WithheldDLR11_RU2NC_Year_EndCurrency1014
32MCRWGTPS SearchMedicare Wages and TipsDLR11_RU2NC_Year_EndCurrency1014
33MDCRTXWH SearchMedicare Tax WithheldDLR11_RU2NC_Year_EndCurrency1014
34SSECTIPS SearchSocial Security TipsDLR11_RU2NC_Year_EndCurrency1014
35ALOCTIPS SearchAllocated TipsDLR11_RU2NC_Year_EndCurrency1014
36ADEICPMT SearchAdvance EIC PaymentDLR11_RU2NC_Year_EndCurrency1014
37DEPCRBFT SearchDependent Care BenefitsDLR11_RU2NC_Year_EndCurrency1014
38NQLFPLNS SearchNonqualified PlansDLR11_RU2NC_Year_EndCurrency1014
39BNINCWGS SearchBenefits Included in WagesDLR11_RU2NC_Year_EndCurrency1014
40W2FRMCTR SearchW2 Forms CounterLI_9U0Long Integer49
41NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Payroll Year End Wage'].NOTEINDX AS 'Payroll Year End Wage-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       UPR10101 AS ['Payroll Year End Wage']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Payroll Year End Wage'].NOTEINDX = ['Record Notes Master'].NOTEINDX
42STRINGARRAY SearchString ArraySTR30String3230
43STRINGARRAY_1 SearchString Array[1]STR30String3230
44STRINGARRAY_2 SearchString Array[2]STR30String3230
45STRINGARRAY_3 SearchString Array[3]STR30String3230
46STRINGARRAY_4 SearchString Array[4]STR30String3230
47STRINGARRAY_5 SearchString Array[5]STR30String3230
48LONGINTARRAY SearchLong Integer ArrayLI_14Long Integer414
49LONGINTARRAY_1 SearchLong Integer Array[1]LI_14Long Integer414
50LONGINTARRAY_2 SearchLong Integer Array[2]LI_14Long Integer414
51LONGINTARRAY_3 SearchLong Integer Array[3]LI_14Long Integer414
52LONGINTARRAY_4 SearchLong Integer Array[4]LI_14Long Integer414
53LONGINTARRAY_5 SearchLong Integer Array[5]LI_14Long Integer414
54EMPLSUFF SearchEmployee SuffixSTR4_Employee_SuffixString64
55ESSW2PRINTED SearchESS W2 PrintedCB_W2_PrintedBoolean20
56DEX_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.

Leave a Reply

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