promotioncode
The promotioncode table.
Columns
| Name | Type | References | Description |
| id [KEY] | Integer | Internal ID | |
| applydiscountto | String | Each Customer Can Use The Promotion | |
| codepattern | String | Code Pattern | |
| description | String | Description | |
| discount | String | Discount | |
| discounttype | String | Discount Type | |
| displaylinediscounts | Boolean | Display Line Discounts | |
| enddate | Date | End Date | |
| externalid | String | External ID | |
| freeshipmethod | String | Shipping Method | |
| isinactive | Boolean | Inactive | |
| ispublic | Boolean | Available to all Customers | |
| location | String | Location | |
| name | String | Name | |
| promotiontype | String | Promotion Type | |
| rate | String | Rate | |
| startdate | Date | Start Date | |
| usetype | String | Coupon Code Type |