CM20200 - CM Transaction
Query Builder
| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| CMRECNUM | Record Number |
Currency | 10 | View | |
| sRecNum | Record Number String |
String | 22 | View | |
| RCRDSTTS | Record Status |
Integer | 2 | View | |
| CHEKBKID | Checkbook ID |
String | 16 | View | |
| CMTrxNum | CM Trx Number |
String | 22 | View | |
| CMTrxType | CM Trx Type |
Integer | 2 | View | |
| TRXDATE | TRX Date |
Date | 4 | View | |
| GLPOSTDT | GL Posting Date |
Date | 4 | View | |
| TRXAMNT | TRX Amount |
Currency | 10 | View | |
| CURNCYID | Currency ID |
String | 16 | View | |
| CMLinkID | CMLinkID |
String | 16 | View | |
| paidtorcvdfrom | Paid ToRcvd From |
String | 66 | View | |
| DSCRIPTN | Description |
String | 32 | View | |
| Recond | Reconciled |
Boolean | 2 | View | |
| RECONUM | Reconcile Number |
Currency | 10 | View | |
| ClrdAmt | Cleared Amount |
Currency | 10 | View | |
| clearedate | Cleared Date |
Date | 4 | View | |
| VOIDED | Voided |
Boolean | 2 | View | |
| VOIDDATE | Void Date |
Date | 4 | View | |
| VOIDPDATE | Void GL Posting Date |
Date | 4 | View | |
| VOIDDESC | Void Description |
String | 32 | View | |
| NOTEINDX | Note Index |
Currency | 10 | View | |
| AUDITTRAIL | Audit Trail Code |
String | 14 | View | |
| DEPTYPE | Deposit Type |
Integer | 2 | View | |
| SOURCDOC | Source Document 1= Invoice |
String | 12 | View | |
| SRCDOCTYP | Source Doc Type |
Integer | 2 | View | |
| SRCDOCNUM | Source Doc Number |
String | 22 | View | |
| POSTEDDT | Posted Date |
Date | 4 | View | |
| PTDUSRID | Posted User ID |
String | 16 | View | |
| MODIFDT | Modified Date |
Date | 4 | View | |
| MDFUSRID | Modified User ID |
String | 16 | View | |
| USERDEF1 | User Defined 1 |
String | 22 | View | |
| USERDEF2 | User Defined 2 |
String | 22 | View | |
| ORIGAMT | Originating Amount |
Currency | 10 | View | |
| Checkbook_Amount | Checkbook Amount |
Currency | 10 | View | |
| RATETPID | Rate Type ID |
String | 16 | View | |
| EXGTBLID | Exchange Table ID |
String | 16 | View | |
| XCHGRATE | Exchange Rate |
Currency (Variable) | 10 | View | |
| EXCHDATE | Exchange Date |
Date | 4 | View | |
| TIME1 | Time |
Time | 4 | View | |
| RTCLCMTD | Rate Calculation Method |
Integer | 2 | View | |
| EXPNDATE | Expiration Date |
Date | 4 | View | |
| CURRNIDX | Currency Index |
Integer | 2 | View | |
| DECPLCUR | Decimal Places Currency |
Integer | 2 | View | |
| DENXRATE | Denomination Exchange Rate |
Currency (Variable) | 10 | View | |
| MCTRXSTT | MC Transaction State 0 = Euro currency is not created or no denomination currencies are enabled. |
Integer | 2 | View | |
| Xfr_Record_Number | Xfr Record Number |
Currency | 10 | View | |
| EFTFLAG | EFT Flag |
Boolean | 2 | View |