# sourcing\$1schedule\$1details
<a name="planning-sourcing-schedule-details-entity"></a>

**Primary key (PK)**

The table below lists the colum names that are uniquely identified in the data entity.


| Name | Column | 
| --- | --- | 
| sourcing\$1schedule\$1details | sourcing\$1schedule\$1detail\$1id, sourcing\$1schedule\$1id | 

The table below lists the column names supported by the data entity:


| Column | Data type | Required | Description | 
| --- | --- | --- | --- | 
|  sourcing\$1schedule\$1detail\$1id  |  string  |  Yes  |  Schedule detail ID.  | 
|  sourcing\$1schedule\$1id  |  string  |  Yes  |  Sourcing schedule ID.  | 
|  company\$1id1  |  string  |  No  |  Displays the company ID.  | 
|  product\$1id1  |  string  |  No  |  Product ID used if schedule details are for a specific product.  | 
|  product\$1group\$1id1  |  string  |  No  |  Product group ID used if schedule details are for a product group.  | 
|  day\$1of\$1week  |  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\$1of\$1month  |  string  |  No  |  To be used when ordering X times in a month. To be used in conjunction with day\$1of\$1week. If used multiple times in a month, use multiple rows.  | 
|  time\$1of\$1day  |  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\$1event\$1id  |  string  |  No  |  ID of the event created in the source system.   | 
|  source\$1update\$1dttm  |  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\$1id | Organization | company | id | 
| product\$1id | Product | product | id | 
| product\$1group\$1id | Product | product\$1hierarchy | id |