Order_allocation_strategies

Order Allocation Strategy is used as part of the Supply Allocation feature for defining allocation rules, which are later applied on transaction lines such as sales orders, transfer orders, or work orders.

Columns

Name Type Length Precision Scale References In Description
allocation_quantities VARCHAR2 18 Allocation quantities
allocation_type VARCHAR2 19 Allocation type
date_created TIMESTAMP Date created
date_last_modified TIMESTAMP Date last modified
is_future_inventory VARCHAR2 3 Is future inventory
is_inactive VARCHAR2 3 Is inactive
name VARCHAR2 100 Name
order_allocation_strategy_id NUMBER 39 0 Order allocation strategy ID

Primary key

PK Column Name
order_allocation_strategy_id

Foreign keys referencing this table

FK Name PK Column Name FK Table Name FK Column Name Key Seq
Transaction_lines_order_allocation_strategies_fk order_allocation_strategy_id Transaction_lines order_allocation_strategy_id 1