# sourcing\$1schedule **Primary key (PK)** The table below lists the colum names that are uniquely identified in the data entity. | Name | Column | | --- | --- | | sourcing\$1schedule | sourcing\$1schedule\$1id, eff\$1start\$1date, eff\$1end\$1date | The table below lists the column names supported by the data entity: | Column | Data type | Required | Description | | --- | --- | --- | --- | | sourcing\$1schedule\$1id | string | Yes | Sourcing schedule ID. | | company\$1id2 | string | No | Displays the company ID. | | tpartner\$1id2 | string | No | Trading partner ID. | | status | string | No | Status of the supply schedule. For example, active, inactive. | | from\$1site\$1id2 | string | No | Origin site ID. For example, hub, vendor. | | to\$1site\$1id2 | string | No | Destination site ID. For example, hub or a customer in the network. | | schedule\$1type | string | No | Type of schedule. For example, inbound ordering, outbound shipping. | | eff\$1start\$1date | timestamp | Yes1 | Date-time when schedule becomes effective. | | eff\$1end\$1date | timestamp | Yes1 | Date-time till when schedule is effective. | | 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. | 1You must enter a value. When you ingest data from SAP or EDI, the default values for *timestamp* is, 1900-01-01 00:00:00 for start date, and 9999-12-31 23:59:59 for end date. 2Foreign 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 | | --- | --- | --- | --- | | from\$1site\$1id, to\$1site\$1id | Network | site | id | | company\$1id | Organization | company | id | | tpartner\$1id | Organization | trading\$1partner | id |