Promotion_codes
The Other > Promotion Code custom field is available for the Promotion Codes table.
Columns
| Name |
Type |
Length |
Precision |
Scale |
References |
In |
Description |
| apply_discount |
VARCHAR2 |
20 |
|
|
|
|
When discount applied; first sale or all sales |
| code |
VARCHAR2 |
120 |
|
|
|
|
Name or code |
| code_pattern |
VARCHAR2 |
120 |
|
|
|
|
Code Pattern |
| date_last_modified |
TIMESTAMP |
|
|
|
|
|
Date last modified (GMT) |
| descr |
VARCHAR2 |
199 |
|
|
|
|
Description |
| discount |
VARCHAR2 |
42 |
|
|
|
|
Discount item name |
| discount_id |
NUMBER |
|
39 |
0 |
|
|
Discount item ID |
| display_line_discounts |
VARCHAR2 |
3 |
|
|
|
|
Display line discounts |
| end_date |
TIMESTAMP |
|
|
|
|
|
End date |
| name |
VARCHAR2 |
120 |
|
|
|
|
Promotion Name |
| plugin_implementation_id |
VARCHAR2 |
200 |
|
|
|
|
Plugin implementation ID |
| promotion_code_id |
NUMBER |
|
39 |
0 |
|
|
Promotion code ID |
| use_type |
VARCHAR2 |
12 |
|
|
|
|
Use type |
Primary key
| PK Column Name |
| promotion_code_id |
Foreign keys referencing this table
| FK Name |
PK Column Name |
FK Table Name |
FK Column Name |
Key Seq |
| Campaignevent_promotion_codes_fk |
promotion_code_id |
Campaignevent |
promotion_code_id |
1 |
| Posting_account_activity_pe_promotion_codes_fk |
promotion_code_id |
Posting_account_activity_pe |
promotion_code_id |
1 |
| Posting_account_activity_promotion_codes_fk |
promotion_code_id |
Posting_account_activity |
promotion_code_id |
1 |
This table is included in the following domains
Domain diagrams
Campaignevents
