W2 Magnetic Media Detail (W200002)

azurecurveProductsMicrosoft Dynamics GP (0)SystemW2 Magnetic Media Detail (W200002)

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

Product: Microsoft Dynamics GP (0)
Series: System

Display Name: W2 Magnetic Media Detail
Physical Name: W200002
Technical Name: W2_Mag_Media_Detail

Group Display Name: W2 Federal Magnetic Media
Group Technical Name: W2 Federal Magnetic Media

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1RPTNGYR SearchReporting YearINT4_U0Integer4
2CMPNYNAM SearchCompany NameSTR64_Company_NameString64
3EMPLTYPE SearchEmployment TypeSTR7_LBString7
4WAGEFILE SearchWage File ExistsSTR3String3
5DATE1 SearchDateDT6Date6
6TIME1 SearchTimeTM6Time6
7EPRIDNBR SearchEmployer ID NumberSTR9_Employer_ID_NumberString9
8INCLUDCO SearchInclude CompanyCBBoolean0
9EMPLRADD SearchEmployer AddressSTR30_LBAUString30
10EMPLRCTY SearchEmployer CitySTR25_LBUString25
11STATECD SearchState CodeSTR2_State_CodeString2
12ZIPCODE SearchZip CodeSTR10String10
13PHONNAME SearchPhone NumberPhone_NumberString14
14CMPANYID SearchCompany IDINT5Integer4
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['W2 Magnetic Media Detail'].CMPANYID AS 'W2 Magnetic Media Detail-Company ID'
       ,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
       W200002 AS ['W2 Magnetic Media Detail']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['W2 Magnetic Media Detail'].CMPANYID = ['Company Master'].CMPANYID
15EMPW2TOT SearchEmployer W2 TotalLI7_U2Long Integer7
16EMPWTOC SearchEmployer Wages, Tips, OtherDLR14Currency14
17EMPFEDTX SearchEmployer Federal TaxDLR14Currency14
18EMPSSWGS SearchEmployer Social Security WagesDLR14Currency14
19EMPSSTAX SearchEmployer Social Security TaxDLR14Currency14
20EMPMEDWG SearchEmployer Medicare WagesDLR14Currency14
21EMPMEDTX SearchEmployer Medicare TaxDLR14Currency14
22EMPSSTIP SearchEmployer Social Security TipsDLR14Currency14
23DEX_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)SystemW2 Magnetic Media Detail (W200002)

Leave a Reply

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