CCTransaction
Retrieves details about credit card transactions, including financial entity, payment information, and status.
Columns
| Name | Type | Description |
| Recordno [KEY] | String | A unique identifier for the credit card transaction record. |
| Financialentity | String | Specifies the financial entity associated with the credit card transaction. |
| Whencreated | Datetime | The date and time when the credit card transaction record was created. |
| Recordid | String | An identifier for the transaction record in the source system. |
| Recordtype | String | The type of record associated with the credit card transaction. |
| Description2 | String | Additional description of the credit card transaction. |
| Description | String | A description of the credit card transaction. |
| Prbatchkey | Int64 | The batch key associated with the transaction. |
| Basecurr | String | The base currency for the transaction. |
| Currency | String | The transaction currency for the credit card transaction. |
| Exch_rate_date | Datetime | The date used for determining the exchange rate. |
| Exch_rate_type_id | Int64 | The identifier for the exchange rate type applied. |
| Exchange_rate | Double | The exchange rate applied to the transaction. |
| Totalentered | Double | The total amount entered for the transaction. |
| Trx_totalentered | Double | The total transaction amount in its original currency. |
| Totalpaid | Double | The total amount paid for the transaction. |
| Trx_totalpaid | Double | The total amount paid in the original transaction currency. |
| Whenpaid | Datetime | The date and time when the transaction was paid. |
| Reversalkey | Int64 | The key identifying a reversal transaction for the credit card transaction. |
| Reversaldate | String | The date when the reversal of the transaction occurred. |
| Reversedkey | Int64 | The key of the record that was reversed. |
| Reverseddate | String | The date of the reversal for the associated record. |
| State | String | The current state or status of the credit card transaction. |
| Rawstate | String | The unprocessed state of the credit card transaction. |
| Cleared | String | Indicates whether the transaction has been cleared. |
| Paymentkey | Int64 | The key associated with the payment transaction. |
| Auwhencreated | Datetime | The audit timestamp for when the record was created. |
| Whenmodified | Datetime | The date and time when the record was last modified. |
| Createdby | Int64 | The user or process ID that created the record. |
| Modifiedby | Int64 | The user or process ID that last modified the record. |
| Megaentitykey | Int64 | The key identifying the parent entity of the record. |
| Megaentityid | String | The identifier for the parent entity of the record. |
| Megaentityname | String | The name of the parent entity associated with the record. |
| Record_url | String | A URL providing direct access to the credit card transaction record. |