Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ME142820
Product: Electronic Reconcile (1428)
Series:
Display Name: ME_AutoRec_Trx_HDR
Physical Name: ME142820
Technical Name: ME_AutoRec_Trx_HDRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 MEBANKID ME_Bank_ID String STR20_LBAU 20 2 ME_Transaction_Type ME_TransactionType Integer ME_FieldTrxTypeDDL 0 3 ACTINDX Account Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ME_AutoRec_Trx_HDR'].ACTINDX AS 'ME_AutoRec_Trx_HDR-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ME142820 AS ['ME_AutoRec_Trx_HDR']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ME_AutoRec_Trx_HDR'].ACTINDX = ['Account Index Master'].ACTINDX
4 DistRef Distribution Reference String STR30 30