ME_Unprocessed_Dwnld_Trx (ME142818)

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

Display Name: ME_Unprocessed_Dwnld_Trx
Physical Name: ME142818
Technical Name: ME_Unprocessed_Dwnld_Trx

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	ME_ReconcileID	ME_ReconcileID	String	STR20	20
2	ME_ReconcileUpdate_SeqNu	ME_ReconUpdt_SeqNum	Long Integer	LI_Sequence_Number	10
3	MEARDLID	ME_DownloadID	String	STR20	20
4	SEQNUMBR	Sequence Number	Long Integer	LI_Sequence_Number	10
5	ME_Attempted_Date	ME_Attempted_Date	Date	DATE_LONG	8
6	ME_Attempted_Time	ME_Attempted_Time	Time	TM6	6
7	ME_Reconcile_TrxUpdate_E	ME_Recon_TrxUpdate_ErrorMsg	String	STR130	130
8	ME_Record_Type_Created	ME_Record_Type_Created	Integer	INT2	2
9	USERDATE	User Date	Date	DT	8
10	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['ME_Unprocessed_Dwnld_Trx'].USERID AS 'ME_Unprocessed_Dwnld_Trx-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM ME142818 AS ['ME_Unprocessed_Dwnld_Trx'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['ME_Unprocessed_Dwnld_Trx'].USERID = ['Users Master'].USERID
11	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['ME_Unprocessed_Dwnld_Trx'].NOTEINDX AS 'ME_Unprocessed_Dwnld_Trx-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM ME142818 AS ['ME_Unprocessed_Dwnld_Trx'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['ME_Unprocessed_Dwnld_Trx'].NOTEINDX = ['Record Notes Master'].NOTEINDX