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

**Primary key (PK)**

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


| Name | Column | 
| --- | --- | 
| product\$1bom | id, product\$1id, component\$1product\$1id | 

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


| column | Data type | Required | Description | 
| --- | --- | --- | --- | 
|  id  |  string  |  Yes  |  Displays the BOM ID.  | 
|  product\$1id 2  |  string  |  Yes  |  Product for which the BOM is defined.  | 
|  site\$1id 2  |  string  |  No  |  Site for which the BOM is defined.  | 
|  company\$1id2  |  string  |  No  |  Displays the company ID.  | 
|  level  |  int  |  No  |  Displays the level of the BOM in multi-level BOM.  | 
|  component\$1product\$1id  |  string  |  Yes 1  |  Displays the component's product ID.  | 
|  component\$1quantity\$1per  |  double  |  Yes  |  Quantity of component required to produce one unit of parent product.  | 
|  component\$1quantity\$1uom  |  string  |  No  |  Unit of measurement of the component.  | 
|  component\$1line\$1number  |  int  |  No  |  Line ID of the child record.  | 
|  lifecycle\$1phase  |  string  |  No  |  Information about the life cycle phase associated with the BOM.  | 
|  assembly\$1cost  |  double  |  No  |  UOM of the product.  | 
|  assembly\$1cost\$1uom  |  string  |  No  |  Assembly cost of the product.  | 
|  eff\$1start\$1date  |  timestamp  |  No  |  Dates from when the record is effective.  | 
|  eff\$1end\$1date  |  timestamp  |  No  |  Dates till when the record is effective.  | 
|  description  |  string  |  No  |  BOM description.  | 
|  production\$1process\$1id  |  string  |  No  |  ID associated with a specific production process.  | 
|  alternative\$1product\$1id  |  string  |  No1  |  ID of the alternate product used in the BOM.  | 
|  priority  |  string  |  No  |  Priority of the product or components used in the BOM.  | 
|  alternate\$1group\$1id  |  string  |  No  |  ID of the alternate product group.  | 
|  alternate\$1product\$1qty  |  double  |  No  |  Quantity of the alternate product used in the BOM.  | 
|  alternate\$1product\$1qty\$1uom  |  string  |  No  |  UOM associated with the quantity of the alternate product.  | 
|  ratio  |  double  |  No  |  Ratio of the products in the BOM.  | 
|  creation\$1date  |  timestamp  |  No1  |  Date when the BOM was created.  | 
|  change\$1date  |  timestamp  |  No1  |  Date when the BOM was updated.  | 
|  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 string and timestamp date type values are: SCN\$1RESERVED\$1NO\$1VALUE\$1PROVIDED for *string*; and for *timestamp* , 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 | 
| --- | --- | --- | --- | 
| company\$1id | Organization | company | id | 
| product\$1id | Product | product | id | 
| site\$1id | Network | site | id | 
| production\$1process\$1id | Operation | production\$1process | production\$1process\$1id | 
| alternative\$1product\$1id | Product | product\$1alternate | product\$1alternate\$1id |