CM20200 - CM Transaction
Dynamics GP table CM20200 (CM Transaction) contains 48 columns including CMRECNUM, sRecNum, RCRDSTTS....
SQL Query Builder
48 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| CMRECNUM | Record Number | Currency | 10 | |
| sRecNum | Record Number String | String | 22 | |
| RCRDSTTS | Record Status | Integer | 2 | |
| CHEKBKID | Checkbook ID | String | 16 | |
| CMTrxNum | CM Trx Number | String | 22 | |
| CMTrxType | CM Trx Type | Integer | 2 | |
| TRXDATE | TRX Date | Date | 4 | |
| GLPOSTDT | GL Posting Date | Date | 4 | |
| TRXAMNT | TRX Amount | Currency | 10 | |
| CURNCYID | Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. | String | 16 | |
| CMLinkID | CMLinkID | String | 16 | |
| paidtorcvdfrom | Paid ToRcvd From | String | 66 | |
| DSCRIPTN | Description | String | 32 | |
| Recond | Reconciled | Boolean | 2 | |
| RECONUM | Reconcile Number | Currency | 10 | |
| ClrdAmt | Cleared Amount | Currency | 10 | |
| clearedate | Cleared Date | Date | 4 | |
| VOIDED | Voided | Boolean | 2 | |
| VOIDDATE | Void Date | Date | 4 | |
| VOIDPDATE | Void GL Posting Date | Date | 4 | |
| VOIDDESC | Void Description | String | 32 | |
| NOTEINDX | Note Index | Currency | 10 | |
| AUDITTRAIL | Audit Trail Code | String | 14 | |
| DEPTYPE | Deposit Type | Integer | 2 | |
| SOURCDOC | Source Document1= Invoice2= Finance Charge3= Miscellaneous Charges4= Return5= Credit Memo | String | 12 | |
| SRCDOCTYP | Source Doc Type | Integer | 2 | |
| SRCDOCNUM | Source Doc Number | String | 22 | |
| POSTEDDT | Posted Date | Date | 4 | |
| PTDUSRID | Posted User ID | String | 16 | |
| MODIFDT | Modified Date | Date | 4 | |
| MDFUSRID | Modified User ID | String | 16 | |
| USERDEF1 | User Defined 1 | String | 22 | |
| USERDEF2 | User Defined 2 | String | 22 | |
| ORIGAMT | Originating Amount | Currency | 10 | |
| Checkbook_Amount | Checkbook Amount | Currency | 10 | |
| RATETPID | Rate Type ID | String | 16 | |
| EXGTBLID | Exchange Table ID | String | 16 | |
| XCHGRATE | Exchange Rate | Currency (Variable) | 10 | |
| EXCHDATE | Exchange Date | Date | 4 | |
| TIME1 | Time | Time | 4 | |
| RTCLCMTD | Rate Calculation Method | Integer | 2 | |
| EXPNDATE | Expiration Date | Date | 4 | |
| CURRNIDX | Currency Index | Integer | 2 | |
| DECPLCUR | Decimal Places Currency | Integer | 2 | |
| DENXRATE | Denomination Exchange Rate | Currency (Variable) | 10 | |
| MCTRXSTT | MC Transaction State0 = Euro currency is not created or no denomination currencies are enabled.1 = Originating is not a denomination; Functional is not a denomination2 = Originating is not a denomination; Functional is the Euro currency.3 = Originating is not a denomination; Functional is a denomination.4 = Originating is a denomination; Functional is not a denomination.5 = Originating is a denomination; Functional is a denomination.6 = Originating is a denomination; Functional is the Euro currency.7 = Originating is the Euro currency; Functional is a denomination.8 = Originating is the Euro currency; Functional is not a denomination. | Integer | 2 | |
| Xfr_Record_Number | Xfr Record Number | Currency | 10 | |
| EFTFLAG | EFT Flag | Boolean | 2 |
Related Tables
Tables that share columns with CM20200. Click "Join" to add to your query.