# product\$1alternate
<a name="product-alternate-entity"></a>

**Primary key (PK)**

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


| Name | Column | 
| --- | --- | 
| product\$1alternate | product\$1alternate\$1id, eff\$1start\$1date, eff\$1end\$1date | 

**Note**  
To avoid data ingestion failure, you must enter a value for *eff\$1start\$1date* and *eff\$1end\$1date*.

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


|  Column name | Data type | Required | Description | 
| --- | --- | --- | --- | 
|  product\$1alternate\$1id  |  string  |  Yes  |  Unique identifier for a record.  | 
|  product\$1id 2  |  string  |  Yes  |  Product ID.  | 
|  alternative\$1product\$1id  |  string  |  Yes  |  Alternate product ID.  | 
|  site\$1id  |  string  |  No  |  Site ID.  | 
|  alternate\$1type  |  string  |  No  |  Alternate product type. For example, similar\$1demand\$1value.  | 
|  company\$1id 2  |  string  |  No  |  Company ID.  | 
|  priority  |  int  |  No  |  Priority or rank of alternatives.  | 
|  alternate\$1group\$1id  |  string  |  No  |  Used to group interchangeable alternate products. Note, this field does not correspond to product\$1group in product\$1hierarchy.  | 
|  status  |  string  |  No  |  Status of the alternate product record. For example, Active, Inactive.  | 
|  alternate\$1product\$1qty  |  double  |  No  |  Quantity of the alternate product. The conversion is done per base\$1UOM of primary product.  | 
|  alternate\$1product\$1qty\$1uom  |  string  |  No  |  Unit of measure (UOM) of alternative product quantity.  | 
|  eff\$1start\$1date  |  timestamp  |  Yes  |  Displays the date and time the record becomes effective.  | 
|  eff\$1end\$1date   |  timestamp  |  Yes  |  Displays the date and time the record ends.  | 
|  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 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 | 
| company\$1id | Organization | company | id |