sourcing_schedule_details
Primary key (PK)
The table below lists the colum names that are uniquely identified in the data entity.
| Name | Column |
|---|---|
| sourcing_schedule_details | sourcing_schedule_detail_id, sourcing_schedule_id |
The table below lists the column names supported by the data entity:
| Column | Data type | Required | Description |
|---|---|---|---|
|
sourcing_schedule_detail_id |
string |
Yes |
Schedule detail ID. |
|
sourcing_schedule_id |
string |
Yes |
Sourcing schedule ID. |
|
company_id1 |
string |
No |
Displays the company ID. |
|
product_id1 |
string |
No |
Product ID used if schedule details are for a specific product. |
|
product_group_id1 |
string |
No |
Product group ID used if schedule details are for a product group. |
|
day_of_week |
string |
No |
Day of the week when the supply schedule is active. Values can be integer or string: Sun: 0 Mon: 1 Tue: 2 Wed: 3 Thu: 4 Fri: 5 Sat: 6 |
|
week_of_month |
string |
No |
To be used when ordering X times in a month. To be used in conjunction with day_of_week. If used multiple times in a month, use multiple rows. |
|
time_of_day |
timestamp |
No |
If supply schedule detail is for a specific time in a day, use this field to enter that information. Only time value is used. |
|
date |
timestamp |
No |
If supply schedule detail is for a specific date, use this field to enter that information. Only date value is used. |
|
source |
string |
No |
Source of data. |
|
source_event_id |
string |
No |
ID of the event created in the source system. |
|
source_update_dttm |
timestamp |
No |
Date time stamp of the update made in the source system. |
1Foreign key
Foreign key (FK)
The table below lists the column names with the associated data entity and category:
| Column | Category | FK/Data entity | FK/Column |
|---|---|---|---|
| company_id | Organization | company | id |
| product_id | Product | product | id |
| product_group_id | Product | product_hierarchy | id |
