# supplementary\$1time\$1series
<a name="forecast-supp-timeseries-entity"></a>

**Note**  
If you cannot locate the supplementary\$1time\$1series data entity, your instance might be using an older data model version. You can contact AWS Support to upgrade your data model version or create a new data connection.

**Primary key (PK)**

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


| Name | Column | 
| --- | --- | 
| forecast\$1supplementary\$1time\$1series | id | 

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


| Column | Data type | Required | Description | 
| --- | --- | --- | --- | 
|  id  |  string  |  Yes  |  Unique identifier with each supplementary data entry.  | 
|  product\$1id 2  |  string  |  No  |  Unique identifier for a specific product. Corresponds to product\$1id in the outbound\$1order\$1line dataset.  | 
|  product\$1group\$1id  |  string  |  No  |  Product hierarchy or grouping.  | 
|  order\$1date   |  timestamp  |  Yes1  |  The timestamp indicating the date and time when the date for the respective time-series was recorded.  | 
|  channel\$1id  |  string  |  No  |  Unique identifier for a specific product. Corresponds to product\$1id in the outbound\$1order\$1line dataset.  | 
|  customer\$1tpartner\$1id 2  |  string  |  No  |  Unique identifier for a specific user. Corresponds to customer\$1tpartner\$1id field in outbound\$1order\$1line dataset.  | 
|  site\$1id 2  |  string  |  No  |  Unique identifier for a specific site or location.  | 
|  ship\$1to\$1site\$1id 2  |  string  |  No  |  Unique identifier for a specific site or location. This corresponds to the *ship\$1to\$1site\$1id* in the *outbound\$1order\$1line* dataset.  | 
|  ship\$1to\$1site\$1address\$1zip  |  string  |  No  |  Postal code of *ship\$1to\$1site\$1id*.  | 
|  geo\$1id 2  |  string  |  No  |  Geographical hierarchy ID.  | 
|  ship\$1from\$1site\$1id 2  |  string  |  No  |  Corresponds to the *ship\$1from\$1site\$1id* in the *outbound\$1order\$1line* dataset.  | 
|  ship\$1from\$1site\$1address\$1zip  |  string  |  No  |  Postal code of *ship\$1from\$1site\$1id*.  | 
|  time\$1series\$1name  |  string  |  Yes  |  The *time\$1series\$1name* must start with a letter, should be 2 to 56 characters long, and can contain letters, numbers, and underscores. No other special characters are allowed.  | 
|  time\$1series\$1value  |  string  |  Yes  |  Value corresponding to the specific time series. This could represent quantities, metric, or string that is relevant to the type of the data. Demand planning only supports numerical value as additional forecast input.  | 
|  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 value for *string* is SCN\$1RESERVED\$1NO\$1VALUE\$1PROVIDED.

2Foreign key

**Foreign key (FK)**

The table below lists the columns with the associated foreign key.


| Column | Category | FK/Data entity | FK/Column | 
| --- | --- | --- | --- | 
| product\$1id | Product | product | id | 
| site\$1id | Network | site | id | 
| customer\$1tpartner\$1id | Organization | trading\$1partner | id | 
| ship\$1to\$1site\$1id | Outbound fulfilment | outbound\$1order\$1line | ship\$1to\$1site\$1id | 
| geo\$1id | Organization | geography | id | 
| ship\$1from\$1site\$1id | Outbound fulfilment | outbound\$1order\$1line | ship\$1from\$1site\$1id |