Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/DDEU021
Product: Direct Debits & Refunds (8811)
Series: Sales
Display Name: Direct Debits Setup Table Extension
Physical Name: DDEU021
Technical Name: DD_SETP_EXTSeq 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
['Direct Debits Setup Table Extension'].CMPANYID AS 'Direct Debits Setup Table Extension-Company ID'
,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
DDEU021 AS ['Direct Debits Setup Table Extension']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['Direct Debits Setup Table Extension'].CMPANYID = ['Company Master'].CMPANYID2 Transaction_Code_Message Transaction Code Message CB_Trx_Code_Message Boolean 0