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_Transactions
| Seq 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 | ||||||
| 12 | 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 | ||||||
| 20 | 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 | ||||||
| 25 | 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 | ||||||