Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ME123504
Product: Safe Pay (1235)
Series:
Display Name: ME Upload Transactions
Physical Name: ME123504
Technical Name: ME_Upload_TransactionsSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 MEUPLDID 
ME Upload ID String STR20 20 2 PP_Number ME PP Number String STR20_LBAU 20 3 MEUPDT ME Upload Date Date DATE 6 4 MEUPTIM ME Upload Time Time TM6 6 5 CHEKBKID Checkbook ID String STR15_Checkbook_ID 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['ME Upload Transactions'].CHEKBKID AS 'ME Upload Transactions-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
ME123504 AS ['ME Upload Transactions']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['ME Upload Transactions'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID6 TRXDATE TRX Date Date DT_Date 6 7 CMTrxNum CM Trx Number String STR20_Document_Number 20 8 CMTrxType CM Trx Type Integer DDL 0 9 TRXAMNT TRX Amount Currency DLR19_$S2 19 10 paidtorcvdfrom Paid ToRcvd From String STR64 64 11 USERID User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['ME Upload Transactions'].USERID AS 'ME Upload Transactions-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
ME123504 AS ['ME Upload Transactions']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['ME Upload Transactions'].USERID = ['Users Master'].USERID12 USERDATE User Date Date DT 8 13 ME_Dummy_File_Convert_De ME_Dummy_File_Convert_Detector Boolean Boolean 0