Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/AMS40400
Product: MIS-AMS Extensions (3459)
Series: Financial
Display Name: AMS_Reconcile_Module_Accounts_SETP
Physical Name: AMS40400
Technical Name: AMS_Reconcile_Module_Accounts_SETPSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 MODULE1 
Module DDL Integer 0 2 SQNCLINE Sequence Line DLR19_$S2 Currency 19 3 ACTINDX Account Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['AMS_Reconcile_Module_Accounts_SETP'].ACTINDX AS 'AMS_Reconcile_Module_Accounts_SETP-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
AMS40400 AS ['AMS_Reconcile_Module_Accounts_SETP']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['AMS_Reconcile_Module_Accounts_SETP'].ACTINDX = ['Account Index Master'].ACTINDX