ME142807 - ME Download Transactions
SQL Query Builder
34 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| MEARDLID | char(21) '' | ||||
| SEQNUMBR | int 0 | ||||
| ARNUM | char(21) '' | ||||
| ME_Transaction_Code | char(41) '' | ||||
| METRXSTATCODE | char(21) '' | ||||
| ME_Updated_CMTrx_Table | tinyint 0 | ||||
| ME_Updated_Date | datetime '1/1/1900' | ||||
| ME_Download_Date | datetime '1/1/1900' | ||||
| ME_Download_Time | datetime '1/1/1900' | ||||
| ME_Updated_User_ID | char(15) '' | ||||
| CHEKBKID | char(15) '' | ||||
| ME_Account_Holder | char(41) '' | ||||
| TRXDATE | datetime '1/1/1900' | ||||
| CMTrxNum | char(21) '' | ||||
| ME_Is_a_Clear | tinyint 0 | ||||
| CMTrxType | smallint 0 | ||||
| paidtorcvdfrom | char(65) '' | ||||
| DSCRIPTN | char(31) '' | ||||
| TRX_CODE_DESC | char '' | ||||
| DSTINDX | int 0 | ||||
| ACTNUMBR_1 | char(5) '' | ||||
| ACTNUMBR_2 | char(5) '' | ||||
| ACTNUMBR_3 | char(5) '' | ||||
| ACTNUMBR_4 | char(5) '' | ||||
| ACTNUMBR_5 | char(5) '' | ||||
| DOCTYPE | smallint 0 | ||||
Document Type (Payables) values (7) 1 = Invoice2 = Finance Charge3 = Miscellaneous Charge4 = Return5 = Credit Memo6 = Payment7 = Scheduled Payment | |||||
| DistRef | char(31) '' | ||||
| ME_Transaction_Type | smallint 0 | ||||
| CURNCYID | Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. | char '' | |||
| TRXAMNT | numeric(19,5) 0.00 | ||||
| USERID | char(15) '' | ||||
| USERDATE | datetime '1/1/1900' | ||||
| ME_Dummy_File_Convert_De | tinyint 0 | ||||
| DEX_ROW_ID | int auto number (1,1) | ||||
Related Tables
Tables that share columns with ME142807. Click "Join" to add to your query.