CreditCardRefund
Contains records of credit card refunds issued to customers, including amounts refunded, refund status, and associated transaction details.
Columns
| Name | Type | References | Description |
| account | String | The account associated with the transaction or record. | |
| balance | Decimal | The current balance of the account or transaction. | |
| class | String | The classification or category of the transaction, such as department or project. | |
| cleared | Boolean | Indicates whether the transaction has been cleared. | |
| cleareddate | Datetime | The date and time when the transaction was cleared. | |
| createddate | Datetime | The date and time when the transaction was created. | |
| currency | String | The currency used in the transaction. | |
| currencyname | String | The name of the currency used in the transaction. | |
| currencysymbol | String | The symbol of the currency used in the transaction. | |
| customform | String | The custom form used for the transaction. | |
| department | String | The department associated with the transaction. | |
| entity | String | The entity (customer, vendor, or partner) associated with the transaction. | |
| entity_nexus_country | String | The country where the entity has a tax nexus. | |
| entitynexus | String | The tax nexus associated with the entity. | |
| exchangerate | Decimal | The exchange rate used for currency conversion in the transaction. | |
| externalid | String | A unique external identifier for referencing the transaction in external systems. | |
| isbasecurrency | Boolean | Indicates whether the transaction is in the base currency. | |
| lastmodifieddate | Datetime | The date and time when the transaction was last modified. | |
| location | String | The location associated with the transaction. | |
| memo | String | A memo or note associated with the transaction. | |
| nexus | String | The tax nexus associated with the transaction. | |
| nexus_country | String | The country associated with the tax nexus for the transaction. | |
| postingperiod | String | The accounting period during which the transaction was posted. | |
| subsidiary | String | The subsidiary associated with the transaction. | |
| taxperiod | String | The tax period associated with the transaction. | |
| taxpointdate | Datetime | The date when tax liability arises for the transaction. | |
| taxpointdateoverride | Boolean | Indicates whether the tax point date has been manually overridden. | |
| total | Decimal | The total amount of the transaction, including taxes and fees. | |
| trandate | Datetime | The date when the transaction was recorded. | |
| tranid | String | The unique identifier assigned to the transaction. | |
| transactionnumber | String | The transaction number associated with the record. | |
| trantype | String | The type of transaction, such as sale, purchase, or refund. | |
| updatecurrency | String | The currency used for updating the transaction. | |
| usertotal | Decimal | The total amount calculated by the user for the transaction. |