vendor_product
Primary key (PK)
The table below lists the colum names that are uniquely identified in the data entity.
Name | Column |
---|---|
vendor_product | vendor_tpartner_id, product_id, eff_start_date, eff_end_date |
The table below lists the column names supported by the data entity:
Column | Data type | Required | Description |
---|---|---|---|
company_id2 |
string |
No |
Company ID. |
vendor_tpartner_id2 |
string |
Yes |
Trading partner ID of the vendor. |
product_id2 |
string |
Yes |
Product ID. |
vendor_product_code |
string |
No |
Product identifier used by the vendor. |
vendor_product_desc |
string |
No |
Product description used by the vendor. |
vendor_cost |
double |
No |
Cost of product from this vendor. |
vendor_cost_uom |
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_volume |
double |
No |
Volume of one unit of product. |
volume_uom |
string |
No |
Unit of measure (UOM) for volume. |
unit_weight |
double |
No |
Weight of one unit of product. |
weight_uom |
string |
No |
Weight unit of measurement for weight. |
release_date |
timestamp |
No |
Date when the product was released by the vendor. |
end_date |
timestamp |
No |
Date when the vendor stopped supplying the product. |
eff_start_date |
timestamp |
Yes1 |
Displays the date and time from when the vendor's product is active. |
eff_end_date |
timestamp |
Yes1 |
Displays the date and time till when the vendor's product will be active. |
min_order_unit |
double |
No |
Minimum order quantity for a product from this vendor. |
country_of_origin |
string |
No |
Country of origin by product. |
sap_eina__infnr |
string |
No |
Record on number of purchases. Predicate key for SAP mapping. Upsert key for EINE. |
sap_eine__ebeln |
string |
No |
Purchasing Document Number. Predicate key for SAP mapping. Upsert key for EKPO. |
sap_eine__ebelp |
string |
No |
Item Number of Purchasing Document. Predicate key for SAP mapping. Upsert key for EKPO. |
max_order_unit |
double |
No |
Maximum order quantity for the vendor. |
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 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_id | Organization | company | id |
vendor_tpartner_id | Organization | trading_partner | id |
product_id | Product | product_id | id |