PX_PROMOARG

This table contains details about how promotions are applied to an order.

Column Descriptions:

NameTypeDescription
ORDERS_IDBIGINT NOT NULLForeign key to ORDERS table. This is the ID of an order to which promotions were applied.
DETAILCLOB (1000000)Details of how promotions are applied to an order. The size of this column is currently set to 4M, which will support approximately 3400 discounts applied to a single order. In the case of where it is possible to have more discounts applied to a single order, the limit can be increased. No other code change is needed. For each 1M limit added to the limit, approximately 850 additional discounts can be supported in an order.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ORDERS_IDPrimary Key

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1051ORDERS_IDORDERSORDERS_IDCascade