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 TypeSQL DB LengthKeyable Length
1RPTNGYR SearchReporting YearINT4_U0Integer24
2CMPNYNAM SearchCompany NameSTR64_Company_NameString6664
3EMPLTYPE SearchEmployment TypeSTR7_LBString87
4WAGEFILE SearchWage File ExistsSTR3String43
5DATE1 SearchDateDT6Date46
6TIME1 SearchTimeTM6Time46
7EPRIDNBR SearchEmployer ID NumberSTR9_Employer_ID_NumberString109
8INCLUDCO SearchInclude CompanyCBBoolean20
9EMPLRADD SearchEmployer AddressSTR30_LBAUString3230
10EMPLRCTY SearchEmployer CitySTR25_LBUString2625
11STATECD SearchState CodeSTR2_State_CodeString42
12ZIPCODE SearchZip CodeSTR10String1210
13PHONNAME SearchPhone NumberPhone_NumberString2214
14CMPANYID SearchCompany IDINT5Integer24
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 Integer47
16EMPWTOC SearchEmployer Wages, Tips, OtherDLR14Currency1014
17EMPFEDTX SearchEmployer Federal TaxDLR14Currency1014
18EMPSSWGS SearchEmployer Social Security WagesDLR14Currency1014
19EMPSSTAX SearchEmployer Social Security TaxDLR14Currency1014
20EMPMEDWG SearchEmployer Medicare WagesDLR14Currency1014
21EMPMEDTX SearchEmployer Medicare TaxDLR14Currency1014
22EMPSSTIP SearchEmployer Social Security TipsDLR14Currency1014
23DEX_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.

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

Leave a Reply

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