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 YearIntegerINT4_U04
2CMPNYNAM SearchCompany NameStringSTR64_Company_Name64
3EMPLTYPE SearchEmployment TypeStringSTR7_LB7
4WAGEFILE SearchWage File ExistsStringSTR33
5DATE1 SearchDateDateDT66
6TIME1 SearchTimeTimeTM66
7EPRIDNBR SearchEmployer ID NumberStringSTR9_Employer_ID_Number9
8INCLUDCO SearchInclude CompanyBooleanCB0
9EMPLRADD SearchEmployer AddressStringSTR30_LBAU30
10EMPLRCTY SearchEmployer CityStringSTR25_LBU25
11STATECD SearchState CodeStringSTR2_State_Code2
12ZIPCODE SearchZip CodeStringSTR1010
13PHONNAME SearchPhone NumberStringPhone_Number14
14CMPANYID SearchCompany IDIntegerINT54
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 TotalLong IntegerLI7_U27
16EMPWTOC SearchEmployer Wages, Tips, OtherCurrencyDLR1414
17EMPFEDTX SearchEmployer Federal TaxCurrencyDLR1414
18EMPSSWGS SearchEmployer Social Security WagesCurrencyDLR1414
19EMPSSTAX SearchEmployer Social Security TaxCurrencyDLR1414
20EMPMEDWG SearchEmployer Medicare WagesCurrencyDLR1414
21EMPMEDTX SearchEmployer Medicare TaxCurrencyDLR1414
22EMPSSTIP SearchEmployer Social Security TipsCurrencyDLR1414
azurecurveProductsMicrosoft Dynamics GP (0)SystemW2 Magnetic Media Detail (W200002)

Leave a Reply

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