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 |