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_DetailSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 RPTNGYR 
Reporting Year Integer INT4_U0 4 2 CMPANYID Company ID Integer INT5 4 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'].CMPANYID3 CMPNYNAM Company Name String STR64_Company_Name 64 4 Location_Address Location Address String STR22_LBAU 22 5 Delivery_Address Delivery Address String STR22_LBAU 22 6 CITY City String STR35 35 7 STATECD State Code String STR2_State_Code 2 8 ZIPCODE Zip Code String STR10 10 9 Foreign_Address Foreign Address Boolean CB_Foreign_Address 0 10 Foreign_StateProvince Foreign State/Province String STR23 23 11 Foreign_Postal_Code Foreign Postal Code String STR15_LBAU 15 12 CCode Country Code String STR6_VAT 6 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'].CCode13 EPRIDNBR Employer ID Number String STR9_Employer_ID_Number 9 14 Establishment_Number Establishment Number String STR5 5 15 Employment_Code Employment Code Integer DDL_Employment_Code 0 16 Terminated_Business Terminated Business Boolean CB_Terminated_Business 0 17 Agent_Indicator_Code Agent Indicator Code Integer DDL_Agent_Indicator_Code 0 18 Agent_ID_Number Agent ID Number String STR9_Employer_ID_Number 9 19 Agent_for_EIN Agent for EIN String STR9_Employer_ID_Number 9 20 WAGEFILE Wage File Exists String STR3 3 21 DATE1 Date Date DT6 6 22 TIME1 Time Time TM6 6 23 INCLUDCO Include Company Boolean CB 0 24 EMPW2TOT Employer W2 Total Long Integer LI7_U2 7 25 EMPWTOC Employer Wages, Tips, Other Currency DLR14 14 26 EMPFEDTX Employer Federal Tax Currency DLR14 14 27 EMPSSWGS Employer Social Security Wages Currency DLR14 14 28 EMPSSTIP Employer Social Security Tips Currency DLR14 14 29 EMPSSTAX Employer Social Security Tax Currency DLR14 14 30 EMPMEDWG Employer Medicare Wages Currency DLR14 14 31 EMPMEDTX Employer Medicare Tax Currency DLR14 14 32 Employer_EIC_Payments Employer EIC Payments Currency DLR14 14 33 Employer_Allocated_Tips Employer Allocated Tips Currency DLR14 14 34 EmployerKind Employer Kind Integer DDL_Employer_Kind 0