vendor_product - AWS Supply Chain

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