promotioncode
Stores promotional codes used for discounts and marketing campaigns in sales transactions.
Columns
| Name | Type | References | Description |
| id [KEY] | Integer | A unique internal identifier assigned to the record, used to track and reference the entry within the system. | |
| applydiscountto | String | Indicates whether the promotion can be applied to each customer, allowing for targeted or generalized discounts based on customer eligibility. | |
| codepattern | String | The pattern or format of the discount code, used to define the structure of the code that customers can enter to apply the promotion. | |
| description | String | A detailed description of the promotion, used to provide additional context or information about the promotion’s terms and conditions. | |
| discount | String | The discount value or percentage associated with the promotion, indicating the amount the customer will save on their purchase. | |
| discounttype | String | The type of discount being applied, such as a percentage discount, fixed amount discount, or other discount models. | |
| displaylinediscounts | Boolean | Indicates whether discounts are displayed at the individual line item level on invoices or receipts, allowing for transparency in pricing. | |
| enddate | Date | The date when the promotion ends, marking the cutoff point for when the promotion is no longer valid. | |
| externalid | String | A unique identifier assigned to the record by an external system, used for integration and synchronization across platforms. | |
| freeshipmethod | String | The shipping method associated with the promotion that offers free shipping, allowing customers to use specific shipping options without charge. | |
| isinactive | Boolean | Indicates whether the promotion is inactive, often used to flag promotions that are no longer available or have expired. | |
| ispublic | Boolean | Indicates whether the promotion is available to all customers, making it publicly accessible for any eligible customer to use. | |
| location | String | The physical or virtual location where the promotion applies, often used to target specific geographic areas or store locations. | |
| name | String | The name of the promotion, typically used for identification and display in user interfaces or reports. | |
| promotiontype | String | The type of promotion (such as a seasonal sale, clearance event, or loyalty discount), used to categorize the nature of the promotion. | |
| rate | String | The rate or amount associated with the discount or promotion, typically used to specify the value or percentage of the discount being applied. | |
| startdate | Date | The date when the promotion starts, marking the beginning of when the promotion is active and can be applied to customer orders. | |
| usetype | String | The type of coupon code used (such as a one-time use, multiple-use, or unique user code), to define the rules around how the code can be applied. |