Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ME142808
Product: Electronic Reconcile (1428)
Series:
Display Name: ME_AutoRec_Trx_Codes
Physical Name: ME142808
Technical Name: ME_AutoRec_Trx_CodesSeq 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 ME_Transaction_Code ME_TransactionCode String STR40 40 4 DOCTYPE Document Type Integer DDL_Document_Type 0 5 ACTINDX Account Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ME_AutoRec_Trx_Codes'].ACTINDX AS 'ME_AutoRec_Trx_Codes-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ME142808 AS ['ME_AutoRec_Trx_Codes']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ME_AutoRec_Trx_Codes'].ACTINDX = ['Account Index Master'].ACTINDX
6 DistRef Distribution Reference String STR30 30 7 TRX_CODE_DESC Transaction Code Description String STR50 50