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 TypeLength
1RPTNGYR SearchReporting YearINT4_U0Integer4
2CMPANYID SearchCompany IDINT5Integer4
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_NameString64
4Location_Address SearchLocation AddressSTR22_LBAUString22
5Delivery_Address SearchDelivery AddressSTR22_LBAUString22
6CITY SearchCitySTR35String35
7STATECD SearchState CodeSTR2_State_CodeString2
8ZIPCODE SearchZip CodeSTR10String10
9Foreign_Address SearchForeign AddressCB_Foreign_AddressBoolean0
10Foreign_StateProvince SearchForeign State/ProvinceSTR23String23
11Foreign_Postal_Code SearchForeign Postal CodeSTR15_LBAUString15
12CCode SearchCountry CodeSTR6_VATString6
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_NumberString9
14Establishment_Number SearchEstablishment NumberSTR5String5
15Employment_Code SearchEmployment CodeDDL_Employment_CodeInteger0
16Terminated_Business SearchTerminated BusinessCB_Terminated_BusinessBoolean0
17Agent_Indicator_Code SearchAgent Indicator CodeDDL_Agent_Indicator_CodeInteger0
18Agent_ID_Number SearchAgent ID NumberSTR9_Employer_ID_NumberString9
19Agent_for_EIN SearchAgent for EINSTR9_Employer_ID_NumberString9
20WAGEFILE SearchWage File ExistsSTR3String3
21DATE1 SearchDateDT6Date6
22TIME1 SearchTimeTM6Time6
23INCLUDCO SearchInclude CompanyCBBoolean0
24EMPW2TOT SearchEmployer W2 TotalLI7_U2Long Integer7
25EMPWTOC SearchEmployer Wages, Tips, OtherDLR14Currency14
26EMPFEDTX SearchEmployer Federal TaxDLR14Currency14
27EMPSSWGS SearchEmployer Social Security WagesDLR14Currency14
28EMPSSTIP SearchEmployer Social Security TipsDLR14Currency14
29EMPSSTAX SearchEmployer Social Security TaxDLR14Currency14
30EMPMEDWG SearchEmployer Medicare WagesDLR14Currency14
31EMPMEDTX SearchEmployer Medicare TaxDLR14Currency14
32Employer_EIC_Payments SearchEmployer EIC PaymentsDLR14Currency14
33Employer_Allocated_Tips SearchEmployer Allocated TipsDLR14Currency14
34EmployerKind SearchEmployer KindDDL_Employer_KindInteger0
35DEX_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 *