The Other > Promotion Code custom field is available for the Promotion Codes table.


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

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_promotion_codes_fk promotion_code_id Posting_account_activity promotion_code_id 1

This table is included in the following domains


Domain diagrams