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

**Primary key (PK)**

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


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

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


| Column | Data type | Required | Description | 
| --- | --- | --- | --- | 
|  company\$1id2  |  string  |  No  |  Company ID.  | 
|  vendor\$1tpartner\$1id2  |  string  |  Yes  |  Trading partner ID of the vendor.  | 
|  product\$1id2  |  string  |  Yes  |  Product ID.  | 
|  vendor\$1product\$1code  |  string  |  No  |  Product identifier used by the vendor.  | 
|  vendor\$1product\$1desc  |  string  |  No  |  Product description used by the vendor.  | 
|  vendor\$1cost  |  double  |  No  |  Cost of product from this vendor.  | 
|  vendor\$1cost\$1uom  |  string  |  No  |  Unit of measure (UOM) of the product cost from this vendor.  | 
|  status  |  string  |  No  |  Status of the product, for example, new product (NP), and obsolete (OB).  | 
|  unit\$1volume  |  double  |  No  |  Volume of one unit of product.  | 
|  volume\$1uom  |  string  |  No  |  Unit of measure (UOM) for volume.  | 
|  unit\$1weight  |  double  |  No  |  Weight of one unit of product.  | 
|  weight\$1uom  |  string  |  No  |  Weight unit of measurement for weight.  | 
|  release\$1date  |  timestamp  |  No  |  Date when the product was released by the vendor.  | 
|  end\$1date  |  timestamp  |  No  |  Date when the vendor stopped supplying the product.  | 
|  eff\$1start\$1date  |  timestamp  |  Yes1  |  Displays the date and time from when the vendor's product is active.  | 
|  eff\$1end\$1date  |  timestamp  |  Yes1  |  Displays the date and time till when the vendor's product will be active.  | 
|  min\$1order\$1unit  |  double  |  No  |  Minimum order quantity for a product from this vendor.  | 
|  country\$1of\$1origin  |  string  |  No  |  Country of origin by product.  | 
|  sap\$1eina\$1\$1infnr  |  string  |  No  |  Record on number of purchases. Predicate key for SAP mapping. Upsert key for EINE.  | 
|  sap\$1eine\$1\$1ebeln  |  string  |  No  |  Purchasing Document Number. Predicate key for SAP mapping. Upsert key for EKPO.  | 
|  sap\$1eine\$1\$1ebelp  |  string  |  No  |  Item Number of Purchasing Document. Predicate key for SAP mapping. Upsert key for EKPO.  | 
|  max\$1order\$1unit  |  double  |  No  |  Maximum order quantity for the vendor.  | 
|  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 *timestamp* date type value 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 columns with the associated foreign key.


| Column | Category | FK/Data entity | FK/Column | 
| --- | --- | --- | --- | 
| company\$1id | Organization | company | id | 
| vendor\$1tpartner\$1id | Organization | trading\$1partner | id | 
| product\$1id | Product | product\$1id | id |