W2 MMREF-1 Detail (W200006)

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

Product: Microsoft Dynamics GP (0)
Series: System

Display Name: W2 MMREF-1 Detail
Physical Name: W200006
Technical Name: W2_MMREF1_Detail

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1RPTNGYR SearchReporting YearINT4_U0Integer24
2CMPANYID SearchCompany IDINT5Integer24
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['W2 MMREF-1 Detail'].CMPANYID AS 'W2 MMREF-1 Detail-Company ID'
       ,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
       W200006 AS ['W2 MMREF-1 Detail']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['W2 MMREF-1 Detail'].CMPANYID = ['Company Master'].CMPANYID
3CMPNYNAM SearchCompany NameSTR64_Company_NameString6664
4Location_Address SearchLocation AddressSTR22_LBAUString2422
5Delivery_Address SearchDelivery AddressSTR22_LBAUString2422
6CITY SearchCitySTR35String3635
7STATECD SearchState CodeSTR2_State_CodeString42
8ZIPCODE SearchZip CodeSTR10String1210
9Foreign_Address SearchForeign AddressCB_Foreign_AddressBoolean20
10Foreign_StateProvince SearchForeign State/ProvinceSTR23String2423
11Foreign_Postal_Code SearchForeign Postal CodeSTR15_LBAUString1615
12CCode SearchCountry CodeSTR6_VATString86
Key to the VAT Country Code MSTR (VAT10001).

Click to show/hide

SELECT
       ['W2 MMREF-1 Detail'].CCode AS 'W2 MMREF-1 Detail-Country Code'
       ,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
       W200006 AS ['W2 MMREF-1 Detail']
INNER JOIN
       VAT10001 AS ['VAT Country Code MSTR']
              ON
                     ['W2 MMREF-1 Detail'].CCode = ['VAT Country Code MSTR'].CCode
13EPRIDNBR SearchEmployer ID NumberSTR9_Employer_ID_NumberString109
14Establishment_Number SearchEstablishment NumberSTR5String65
15Employment_Code SearchEmployment CodeDDL_Employment_CodeInteger20
16Terminated_Business SearchTerminated BusinessCB_Terminated_BusinessBoolean20
17Agent_Indicator_Code SearchAgent Indicator CodeDDL_Agent_Indicator_CodeInteger20
18Agent_ID_Number SearchAgent ID NumberSTR9_Employer_ID_NumberString109
19Agent_for_EIN SearchAgent for EINSTR9_Employer_ID_NumberString109
20WAGEFILE SearchWage File ExistsSTR3String43
21DATE1 SearchDateDT6Date46
22TIME1 SearchTimeTM6Time46
23INCLUDCO SearchInclude CompanyCBBoolean20
24EMPW2TOT SearchEmployer W2 TotalLI7_U2Long Integer47
25EMPWTOC SearchEmployer Wages, Tips, OtherDLR14Currency1014
26EMPFEDTX SearchEmployer Federal TaxDLR14Currency1014
27EMPSSWGS SearchEmployer Social Security WagesDLR14Currency1014
28EMPSSTIP SearchEmployer Social Security TipsDLR14Currency1014
29EMPSSTAX SearchEmployer Social Security TaxDLR14Currency1014
30EMPMEDWG SearchEmployer Medicare WagesDLR14Currency1014
31EMPMEDTX SearchEmployer Medicare TaxDLR14Currency1014
32Employer_EIC_Payments SearchEmployer EIC PaymentsDLR14Currency1014
33Employer_Allocated_Tips SearchEmployer Allocated TipsDLR14Currency1014
34EmployerKind SearchEmployer KindDDL_Employer_KindInteger20
35DEX_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 *