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 TypeLength
1RPTNGYR SearchReporting YearINT4_U0Integer4
2MCRQGEMP SearchMedicare Qualified Govt EmployeeCB_Medicare_Qualified_Govt_EmployeeBoolean0
3DEPRTMNT SearchDepartmentSTR6_Payroll_CodeString6
4LASTNAME SearchLast NameSTR20String20
5FRSTNAME SearchFirst NameSTR15String15
6MIDLNAME SearchMiddle NameSTR15String15
7SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer10
8ADDRESS1 SearchAddress 1STR60String60
9ADDRESS2 SearchAddress 2STR60String60
10ADDRESS3 SearchAddress 3STR60String60
11CITY SearchCitySTR35String35
12STATE SearchStateSTR30_StateString29
13ZIPCODE SearchZip CodeSTR10String10
14Foreign_Address SearchForeign AddressCB_Foreign_AddressBoolean0
15Foreign_StateProvince SearchForeign State/ProvinceSTR23String23
16Foreign_Postal_Code SearchForeign Postal CodeSTR15_LBAUString15
17CCode SearchCountry CodeSTR6_VATString6
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_LBAUString7
19EMPLOYID SearchEmployee IDSTR15_Employee_IDString15
20SOCSCNUM SearchSocial Security NumberSTR15_Social_Security_NumberString15
21W2BFSTEM SearchW2 Box For Statutory EmployeeCB_Statutory_EmployeeBoolean0
22W2BFDCSD SearchW2 Box For DeceasedCB_DeceasedBoolean0
23W2BFPPLN SearchW2 Box For Pension PlanCB_Pension_PlanBoolean0
24W2BFLREP SearchW2 Box For Legal RepresentativeCB_Legal_RepresentativeBoolean0
25W2BF942E SearchW2 Box For 942 EmployeeCB_942_EmployeeBoolean0
26W2BFSTTL SearchW2 Box For SubtotalSTR1String1
27W2BFDCMP SearchW2 Box For Deferred CompensationCB_Deferred_CompensationBoolean0
28WGTPCOMP SearchWages, Tips, Other CompensationDLR11_RU2NC_Year_EndCurrency14
29FEDITXWH SearchFederal Income Tax W/HDLR11_RU2NC_Year_EndCurrency14
30SSECWAGS SearchSocial Security WagesDLR11_RU2NC_Year_EndCurrency14
31SSTXWHLD SearchSocial Security Tax WithheldDLR11_RU2NC_Year_EndCurrency14
32MCRWGTPS SearchMedicare Wages and TipsDLR11_RU2NC_Year_EndCurrency14
33MDCRTXWH SearchMedicare Tax WithheldDLR11_RU2NC_Year_EndCurrency14
34SSECTIPS SearchSocial Security TipsDLR11_RU2NC_Year_EndCurrency14
35ALOCTIPS SearchAllocated TipsDLR11_RU2NC_Year_EndCurrency14
36ADEICPMT SearchAdvance EIC PaymentDLR11_RU2NC_Year_EndCurrency14
37DEPCRBFT SearchDependent Care BenefitsDLR11_RU2NC_Year_EndCurrency14
38NQLFPLNS SearchNonqualified PlansDLR11_RU2NC_Year_EndCurrency14
39BNINCWGS SearchBenefits Included in WagesDLR11_RU2NC_Year_EndCurrency14
40W2FRMCTR SearchW2 Forms CounterLI_9U0Long Integer9
41NOTEINDX SearchNote IndexDLR14Currency14
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 ArraySTR30String30
43STRINGARRAY_1 SearchString Array[1]STR30String30
44STRINGARRAY_2 SearchString Array[2]STR30String30
45STRINGARRAY_3 SearchString Array[3]STR30String30
46STRINGARRAY_4 SearchString Array[4]STR30String30
47STRINGARRAY_5 SearchString Array[5]STR30String30
48LONGINTARRAY SearchLong Integer ArrayLI_14Long Integer14
49LONGINTARRAY_1 SearchLong Integer Array[1]LI_14Long Integer14
50LONGINTARRAY_2 SearchLong Integer Array[2]LI_14Long Integer14
51LONGINTARRAY_3 SearchLong Integer Array[3]LI_14Long Integer14
52LONGINTARRAY_4 SearchLong Integer Array[4]LI_14Long Integer14
53LONGINTARRAY_5 SearchLong Integer Array[5]LI_14Long Integer14
54EMPLSUFF SearchEmployee SuffixSTR4_Employee_SuffixString4
55ESSW2PRINTED SearchESS W2 PrintedCB_W2_PrintedBoolean0
56DEX_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.

Leave a Reply

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