# PromotionalCredits: Chargebee Promotional Credits
- Catalog: `Chargebee`
- Schema: `PromotionalCredits`
- Primary Keys: `id`
- Label: Promotional Credits
Can retrieve data and change data using insert, update and delete.
## Table Columns
The columns of the table `PromotionalCredits` are shown below. Each column has an SQL data type.
| Name | Data Type | Label | Required | Documentation |
|---|:---:|---|:---:|---|
| `amount_in_decimal` | `decimal` | Amount in Decimal | ☐ | |
| `amount` | `decimal` | Amount | ☐ | |
| `closing_balance` | `decimal` | Closing Balance | ☐ | |
| `created_at` | `datetime` | Created at | ☐ | |
| `credit_type` | `string` | Credit Type | ☐ | |
| `currency_code` | `string` | Currency Code | ☐ | |
| `customer_id` | `string` | Customer ID | ☐ | |
| `description` | `string` | Description | ☐ | |
| `done_by` | `string` | Done by | ☐ | |
| `id` | `string` | ID | ☑ | |
| `reference` | `string` | Reference | ☐ | |
| `type` | `string` | Type | ☐ | |