Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ME142807
Product: Electronic Reconcile (1428)
Series:
Display Name: ME Download Transactions
Physical Name: ME142807
Technical Name: ME_Download_TransactionsSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 MEARDLID 
ME_DownloadID String STR20 20 2 SEQNUMBR Sequence Number Long Integer LI_Sequence_Number 10 3 ARNUM ME_AutoRec_Number String STR20_LBAU 20 4 ME_Transaction_Code ME_TransactionCode String STR40 40 5 METRXSTATCODE ME_TrxStatusCode String STR20 20 6 ME_Updated_CMTrx_Table ME_Updated_CMTrx_Table Boolean boolean 0 7 ME_Updated_Date ME_Updated_Date Date DATE 6 8 ME_Download_Date ME_Download_Date Date DATE 6 9 ME_Download_Time ME_Download_Time Time TM6 6 10 ME_Updated_User_ID ME_Updated_User_ID String STR15 15 11 CHEKBKID Checkbook ID String STR15_Checkbook_ID 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['ME Download Transactions'].CHEKBKID AS 'ME Download Transactions-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
ME142807 AS ['ME Download Transactions']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['ME Download Transactions'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID12 ME_Account_Holder ME_Account_Holder String STR40 40 13 TRXDATE TRX Date Date DT_Date 6 14 CMTrxNum CM Trx Number String STR20_Document_Number 20 15 ME_Is_a_Clear ME_Is_a_Clear Boolean boolean 0 16 CMTrxType CM Trx Type Integer DDL 0 17 paidtorcvdfrom Paid ToRcvd From String STR64 64 18 TRX_CODE_DESC Transaction Code Description String STR50 50 19 DSTINDX Distribution Account Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ME Download Transactions'].DSTINDX AS 'ME Download Transactions-Distribution Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ME142807 AS ['ME Download Transactions']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ME Download Transactions'].DSTINDX = ['Account Index Master'].ACTINDX20 DOCTYPE Document Type Integer DDL_Document_Type 0 21 DistRef Distribution Reference String STR30 30 22 ME_Transaction_Type ME_TransactionType Integer ME_FieldTrxTypeDDL 0 23 TRXAMNT TRX Amount Currency DLR19_$S2 19 24 USERID User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['ME Download Transactions'].USERID AS 'ME Download Transactions-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
ME142807 AS ['ME Download Transactions']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['ME Download Transactions'].USERID = ['Users Master'].USERID25 USERDATE User Date Date DT 8 26 ME_Dummy_File_Convert_De ME_Dummy_File_Convert_Detector Boolean Boolean 0 27 CURNCYID Currency ID String STR15_Currency_ID 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['ME Download Transactions'].CURNCYID AS 'ME Download Transactions-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
ME142807 AS ['ME Download Transactions']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['ME Download Transactions'].CURNCYID = ['Currency Setup'].CURNCYID