CM20300 - CM Receipt
Dynamics GP table CM20300 (CM Receipt) contains 57 columns including CMRECNUM, sRecNum, CNTRLTYP....
SQL Query Builder
57 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| CMRECNUM | Record Number | Currency | 10 | ||
| sRecNum | Record Number String | String | 22 | ||
| CNTRLTYP | Control Type | Integer | 2 | ||
Control Type values (3) 0 = Voucher types1 = Payment types2 = Printed alignment forms | |||||
| DEPOSITED | Deposited | Boolean | 2 | ||
| MDFUSRID | Modified User ID | String | 16 | ||
| MODIFDT | Modified Date | Date | 4 | ||
| CHEKBKID | Checkbook ID | String | 16 | ||
| depositnumber | Deposit Number | String | 22 | ||
| RCPTNMBR | Receipt Number | String | 22 | ||
| receiptdate | Receipt Date | Date | 4 | ||
| RCPTAMT | Receipt Amount | Currency | 10 | ||
| RcpType | Receipt Type | Integer | 2 | ||
| CARDNAME | Card Name | String | 16 | ||
| CURNCYID | Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. | String | 16 | ||
| BANKNAME | Bank Name | String | 32 | ||
| BNKBRNCH | Bank Branch | String | 22 | ||
| GLPOSTDT | GL Posting Date | Date | 4 | ||
| POSTEDDT | Posted Date | Date | 4 | ||
| PTDUSRID | Posted User ID | String | 16 | ||
| CMLinkID | CMLinkID | String | 16 | ||
| RcvdFrom | Received From | String | 32 | ||
| DSCRIPTN | Description | String | 32 | ||
| VOIDED | Voided | Boolean | 2 | ||
| VOIDDATE | Void Date | Date | 4 | ||
| VOIDPDATE | Void GL Posting Date | Date | 4 | ||
| VOIDDESC | Void Description | String | 32 | ||
| USERDEF1 | User Defined 1 | String | 22 | ||
| USERDEF2 | User Defined 2 | String | 22 | ||
| NOTEINDX | Note Index | Currency | 10 | ||
| RCRDSTTS | Record Status | Integer | 2 | ||
| SOURCDOC | Source Document1= Invoice2= Finance Charge3= Miscellaneous Charges4= Return5= Credit Memo | String | 12 | ||
| SRCDOCNUM | Source Doc Number | String | 22 | ||
| SRCDOCTYP | Source Doc Type | Integer | 2 | ||
| AUDITTRAIL | Audit Trail Code | String | 14 | ||
| ORIGAMT | Originating Amount | Currency | 10 | ||
| Checkbook_Amount | Checkbook Amount | Currency | 10 | ||
| RATETPID | Rate Type ID | String | 16 | ||
| RCVGRATETPID | Receiving Rate Type ID | String | 16 | ||
| EXGTBLID | Exchange Table ID | String | 16 | ||
| XCHGRATE | Exchange Rate | Currency (Variable) | 10 | ||
| Receiving_Exchange_Rate | Receiving Exchange Rate | Currency (Variable) | 10 | ||
| EXCHDATE | Exchange Date | Date | 4 | ||
| TIME1 | Time | Time | 4 | ||
| RTCLCMTD | Rate Calculation Method | Integer | 2 | ||
| RCVGRTCLCMTD | Receiving Rate Calc Method | Integer | 2 | ||
| EXPNDATE | Expiration Date | Date | 4 | ||
| CURRNIDX | Currency Index | Integer | 2 | ||
| DECPLCUR | Decimal Places Currency | Integer | 2 | ||
| RLGANLOS | Realized Gain-Loss Amount | Currency | 10 | ||
| Cash_Account_Index | Cash Account Index | Long Integer | 4 | ||
| Realized_GL_Account_Inde | Realized GL Account Index | Long Integer | 4 | ||
| 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 | ||
| Receiving_DenomEXRate | Receiving Denomination Exchange Rate | Currency (Variable) | 10 | ||
| Receiving_MC_Transaction | Receiving MC Transaction State | Integer | 2 | ||
| PMNTNMBR | Payment Number | String | 22 | ||
| EFTFLAG | EFT Flag | Boolean | 2 | ||
Related Tables
Tables that share columns with CM20300. Click "Join" to add to your query.