Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PAUPGCOS
Product: Collections Management (1157)
Series: System
Display Name: PA Upgrade Companies
Physical Name: PAUPGCOS
Technical Name: PA_UpgradeCompanies_TEMPSeq 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
['PA Upgrade Companies'].CMPANYID AS 'PA Upgrade Companies-Company ID'
,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
PAUPGCOS AS ['PA Upgrade Companies']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['PA Upgrade Companies'].CMPANYID = ['Company Master'].CMPANYID2 CMPNYNAM Company Name STR64_Company_Name String 64 3 INTERID Intercompany ID STR5_IC_ID String 5 Key to the Company Master (SY01500).
Click to show/hide
SELECT
['PA Upgrade Companies'].INTERID AS 'PA Upgrade Companies-Intercompany ID'
,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
PAUPGCOS AS ['PA Upgrade Companies']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['PA Upgrade Companies'].INTERID = ['Company Master'].INTERID4 MKTOPROC Marked To Process CB Boolean 0