Sales_channels
Sales Channels is used as part of the Sales Channel; Allocation feature for creating sales channels, which are later applied to the Sales Order and Order Reservation transaction header. The Order Reservation reserves inventory for future sales orders of the same channel.
Columns
| Name |
Type |
Length |
Precision |
Scale |
References |
In |
Description |
| date_created |
TIMESTAMP |
|
|
|
|
|
Date created |
| date_last_modified |
TIMESTAMP |
|
|
|
|
|
Date last modified |
| description |
VARCHAR2 |
2000 |
|
|
|
|
Description |
| is_inactive |
VARCHAR2 |
3 |
|
|
|
|
Is inactive |
| name |
VARCHAR2 |
400 |
|
|
|
|
Name |
| order_priority |
NUMBER |
|
39 |
0 |
|
|
Order priority |
| sales_channel_id |
NUMBER |
|
39 |
0 |
|
|
Sales channel ID |
| use_reservations_as_supply |
VARCHAR2 |
3 |
|
|
|
|
Only use dedicated order reservations as supply |
Primary key
| PK Column Name |
| sales_channel_id |
Foreign keys referencing this table
| FK Name |
PK Column Name |
FK Table Name |
FK Column Name |
Key Seq |
| Transactions_sales_channels_fk |
sales_channel_id |
Transactions |
sales_channel_id |
1 |