CM00001 - CM_DepRcpt_RGLCash_LINE_TEMP
Dynamics GP table CM00001 (CM_DepRcpt_RGLCash_LINE_TEMP) contains 17 columns including depositnumber, RCPTNMBR, CURNCYID....
SQL Query Builder
17 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| depositnumber | Deposit Number | String | 22 | |
| RCPTNMBR | Receipt Number | String | 22 | |
| CURNCYID | Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. | String | 16 | |
| ACTINDX | Account Index Links to GL00105 to get the full concatenated account number and description. This is the primary key for account lookups across all modules. | Long Integer | 4 | |
| SEQNUMBR | Sequence Number | Long Integer | 4 | |
| DEBITAMT | Debit Amount | Currency | 10 | |
| CRDTAMNT | Credit Amount | Currency | 10 | |
| DSCRIPTN | Description | String | 32 | |
| REFRENCE | Reference | String | 32 | |
| GLPOSTDT | GL Posting Date | Date | 4 | |
| VOIDED | Voided | Boolean | 2 | |
| CURRNIDX | Currency Index | Integer | 2 | |
| DECPLACS | Decimal Places | Integer | 2 | |
| 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 | |
| RATETPID | Rate Type ID | String | 16 | |
| EXGTBLID | Exchange Table ID | String | 16 | |
| CHEKBKID | Checkbook ID | String | 16 |
Related Tables
Tables that share columns with CM00001. Click "Join" to add to your query.