| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| CMRECNUM | Record Number |
Currency | 10 | View | |
| depositnumber | Deposit Number |
String | 22 | View | |
| RcpType | Receipt Type |
Integer | 2 | View | |
| RCPTNMBR | Receipt Number |
String | 22 | View | |
| RCPTAMT | Receipt Amount |
Currency | 10 | View | |
| BANKNAME | Bank Name |
String | 32 | View | |
| BNKBRNCH | Bank Branch |
String | 22 | View | |
| UPDATED | Updated |
Boolean | 2 | View | |
| MARKED | Marked |
Boolean | 2 | View | |
| receiptdate | Receipt Date |
Date | 4 | 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 | |
| Receiving_Exchange_Rate | Receiving 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 | |
| RLGANLOS | Realized Gain-Loss Amount |
Currency | 10 | View | |
| CURNCYID | Currency ID |
String | 16 | View | |
| CURRNIDX | Currency Index |
Integer | 2 | View | |
| DECPLCUR | Decimal Places Currency |
Integer | 2 | View | |
| ORIGAMT | Originating Amount |
Currency | 10 | 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 |