ME Upload Transactions (ME123504)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ME123504

Display Name: ME Upload Transactions
Physical Name: ME123504
Technical Name: ME_Upload_Transactions

Seq 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'].CHEKBKID
6	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'].USERID
12	USERDATE	User Date	Date	DT	8
13	ME_Dummy_File_Convert_De	ME_Dummy_File_Convert_Detector	Boolean	Boolean	0