Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CBINT002
Product: Cashbook (1058)
Series: System
Display Name: Bank Transfers IC Codes
Physical Name: CBINT002
Technical Name: CB_Bank_Transfers_IC_CodesSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 INTERID 
Intercompany ID STR5_IC_ID String 5 Key to the Company Master (SY01500).
Click to show/hide
SELECT
['Bank Transfers IC Codes'].INTERID AS 'Bank Transfers IC Codes-Intercompany ID'
,['Company Master'].INTERID AS 'Company Master-Intercompany ID'
FROM
CBINT002 AS ['Bank Transfers IC Codes']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['Bank Transfers IC Codes'].INTERID = ['Company Master'].INTERID2 CB_IC_Code CB_IC_Code STR3 String 3