ME Download Transactions (ME142807)

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

Product: Electronic Reconcile (1428)
Series: Financial

Display Name: ME Download Transactions
Physical Name: ME142807
Technical Name: ME_Download_Transactions

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1MEARDLID SearchME_DownloadIDSTR20String2220
2SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer410
3ARNUM SearchME_AutoRec_NumberSTR20_LBAUString2220
4ME_Transaction_Code SearchME_TransactionCodeSTR40String4240
5METRXSTATCODE SearchME_TrxStatusCodeSTR20String2220
6ME_Updated_CMTrx_Table SearchME_Updated_CMTrx_TablebooleanBoolean20
7ME_Updated_Date SearchME_Updated_DateDATEDate46
8ME_Download_Date SearchME_Download_DateDATEDate46
9ME_Download_Time SearchME_Download_TimeTM6Time46
10ME_Updated_User_ID SearchME_Updated_User_IDSTR15String1615
11CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
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'].CHEKBKID
12ME_Account_Holder SearchME_Account_HolderSTR40String4240
13TRXDATE SearchTRX DateDT_DateDate46
14CMTrxNum SearchCM Trx NumberSTR20_Document_NumberString2220
15ME_Is_a_Clear SearchME_Is_a_ClearbooleanBoolean20
16CMTrxType SearchCM Trx TypeDDLInteger20
17paidtorcvdfrom SearchPaid ToRcvd FromSTR64String6664
18TRX_CODE_DESC SearchTransaction Code DescriptionSTR50String5250
19DSTINDX SearchDistribution Account IndexLI_14Long Integer414
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'].ACTINDX
20DOCTYPE SearchDocument TypeDDL_Document_TypeInteger20
21DistRef SearchDistribution ReferenceSTR30String3230
22ME_Transaction_Type SearchME_TransactionTypeME_FieldTrxTypeDDLInteger20
23TRXAMNT SearchTRX AmountDLR19_$S2Currency1019
24USERID SearchUser IDSTR15_User_IDString1615
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'].USERID
25USERDATE SearchUser DateDTDate48
26ME_Dummy_File_Convert_De SearchME_Dummy_File_Convert_DetectorBooleanBoolean20
27CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
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
28DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

Leave a Reply

Your email address will not be published. Required fields are marked *