product_alternate
Primary key (PK)
The table below lists the colum names that are uniquely identified in the data entity.
| Name | Column |
|---|---|
| product_alternate | product_alternate_id, eff_start_date, eff_end_date |
Note
To avoid data ingestion failure, you must enter a value for eff_start_date and eff_end_date.
The table below lists the column names supported by the data entity:
| Column name | Data type | Required | Description |
|---|---|---|---|
|
product_alternate_id |
string |
Yes |
Unique identifier for a record. |
|
product_id 2 |
string |
Yes |
Product ID. |
|
alternative_product_id |
string |
Yes |
Alternate product ID. |
|
site_id |
string |
No |
Site ID. |
|
alternate_type |
string |
No |
Alternate product type. For example, similar_demand_value. |
|
company_id 2 |
string |
No |
Company ID. |
|
priority |
int |
No |
Priority or rank of alternatives. |
|
alternate_group_id |
string |
No |
Used to group interchangeable alternate products. Note, this field does not correspond to product_group in product_hierarchy. |
|
status |
string |
No |
Status of the alternate product record. For example, Active, Inactive. |
|
alternate_product_qty |
double |
No |
Quantity of the alternate product. The conversion is done per base_UOM of primary product. |
|
alternate_product_qty_uom |
string |
No |
Unit of measure (UOM) of alternative product quantity. |
|
eff_start_date |
timestamp |
Yes |
Displays the date and time the record becomes effective. |
|
eff_end_date |
timestamp |
Yes |
Displays the date and time the record ends. |
|
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. |
1You must enter a value. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED.
2Foreign key
Foreign key (FK)
The table below lists the columns with the associated foreign key.
| Column | Category | FK/Data entity | FK/Column |
|---|---|---|---|
| product_id | Product | product | id |
| company_id | Organization | company | id |
