Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/MEP_CompanyProductStatus
Product: Mekorma Products Manager (7156)
Series: 3rd Party
Display Name: MEP_CompanyProductStatus_MEM
Physical Name: MEP_CompanyProductStatus
Technical Name: MEP_CompanyProductStatus_MEMSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CMPANYID 
Company ID INT5 Integer 4 Key to the Company Master (SY01500).
Click to show/hide
SELECT
['MEP_CompanyProductStatus_MEM'].CMPANYID AS 'MEP_CompanyProductStatus_MEM-Company ID'
,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
MEP_CompanyProductStatus AS ['MEP_CompanyProductStatus_MEM']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['MEP_CompanyProductStatus_MEM'].CMPANYID = ['Company Master'].CMPANYID2 PRODID Product ID INT4 Integer 4 3 Visible Visible CB_Visible Boolean 0 4 Selected Selected Boolean Boolean 0 5 CMPNYNAM Company Name STR64_Company_Name String 64 6 DBNAME Database Name STR10_LBAU String 10 7 MEP_Initialized MEP_Initialized MEP_Initialized Boolean 0 8 MEP_ProductName MEP_ProductName MEP_ProductName String 128 9 MEACTIVATED ME_Activated Boolean Boolean 0 10 MEP_ProductStatus MEP_ProductStatus MEP_ProductStatus Integer 0 11 MEP_TextMessage MEP_TextMessage MEP_TextMessage Text 32000