AAG2001T - aa CM Deposit Diff TEMP
Dynamics GP table AAG2001T (aa CM Deposit Diff TEMP) contains 26 columns including CMRECNUM, depositnumber, RcpType....
SQL Query Builder
26 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| CMRECNUM | Record Number | Currency | 10 | |
| depositnumber | Deposit Number | String | 22 | |
| RcpType | Receipt Type | Integer | 2 | |
| RCPTNMBR | Receipt Number | String | 22 | |
| RCPTAMT | Receipt Amount | Currency | 10 | |
| BANKNAME | Bank Name | String | 32 | |
| BNKBRNCH | Bank Branch | String | 22 | |
| UPDATED | Updated | Boolean | 2 | |
| MARKED | Marked | Boolean | 2 | |
| receiptdate | Receipt Date | Date | 4 | |
| Checkbook_Amount | Checkbook Amount | Currency | 10 | |
| RATETPID | 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 | |
| EXPNDATE | Expiration Date | Date | 4 | |
| RLGANLOS | Realized Gain-Loss Amount | Currency | 10 | |
| CURNCYID | Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. | String | 16 | |
| CURRNIDX | Currency Index | Integer | 2 | |
| DECPLCUR | Decimal Places Currency | Integer | 2 | |
| ORIGAMT | Originating Amount | Currency | 10 | |
| 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 |
Related Tables
Tables that share columns with AAG2001T. Click "Join" to add to your query.