product - AWS Supply Chain

product

Primary key (PK)

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

Name Column
product id

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

Column Data type Required Description

id

string

Yes

Displays the product ID. Referred to by other entities as product_id.

description

string

Yes

Displays the description of the product.

company_id1

string

No

Displays the company ID.

product_group_id1

string

No

Displays the product group ID that this product belongs to.

product_type

string

No

Type of product, for example, finished good, component, service, or packaging.

hts_code

string

No

Harmonized Tariff Schedule code.

is_hazmat

string

No

Displays whether product is Hazmat compliant.

is_flammable

string

No

Indicator of whether the product is flammable or not.

is_special_handling

string

No

Displays if the product requires special handling.

is_perishable

string

No

Displays if the product is perishable.

is_digital

string

No

Displays if the product is digital.

is_deleted

string

No

Indicates whether product is deleted ("true") or active ("false").

is_lot_controlled

string

No

Indicates if the product is a lot-controlled product.

is_expiry_controlled

string

No

Indicates if the product is an expiry-date controlled product.

creation_date

timestamp

No

Product launch or release date.

brand_name

string

No

Product brand name.

parent_product_id1

string

No

If the product is part of a bundle, lists the ID of the parent product.

display_desc

string

No

External facing description of the product.

discontinue_day

timestamp

No

Date when the product was discontinued.

base_uom

string

No

Unit of measure for product. Default is Eaches.

unit_cost

double

No

Average unit cost of the product. Measured in currency_uom per base_uom.

unit_price

double

No

Unit price, standard price, or MSRP of the product.

inventory_holding_cost

double

No

Average yearly holding cost of the product.

currency_uom

string

No

Currency unit of measure for the price and other economic variables of this product.

product_available_day

timestamp

No

Date when the product is available for fulfillment.

shipping_weight

double

No

Default weight to be used by the carrier.

shipping_dimension

double

No

Dimensional weight to be used by the carrier.

unit_volume

double

No

Volume of product per base_uom.

pkg_length

double

No

Packaged length of the individual product.

pkg_width

double

No

Packaged width of the individual product.

pkg_height

double

No

Packaged height of the individual product.

weight_uom

string

No

Unit of measure for product's weight.

dim_uom

string

No

Unit of measure for product's dimensions.

volume_uom

string

No

Product volume.

diameter

double

No

Diameter of an individual product.

color

string

No

Product color

casepack_size

int

No

Number of products in each casepack.

gtin

string

No

Global Trade Item Number (GTIN). 14-digit number that includes various EAN/UCC numbering structures and is used to uniquely identify a product.

long_term_horizon

double

No

Long Term Horizon time window used to determine salvage value.

long_term_horizon_uom

string

No

UOM for Long Term Horizon time window used to determine salvage value.

salvage_value_percentage

double

No

Product cost expected to recover at the end of Long Term Horizon.

sap_0material_attr__prdha

string

No

Product hierarchy. Predicate key for SAP mapping. Upsert key for T179.

shelf_life

double

No

Duration for which a product can be stored or kept fresh and safe for consumption or use before it spoils or expires. This information is crucial for managing inventory levels, determining reorder points, and ensuring that products are sold or consumed before their expiration dates.

shelf_life_uom

string

No

Unit of measure of the shelf life.

un_id

string

No

UN IDs are four-digit numbers that identify dangerous goods, hazardous substances and articles (such as explosives, flammable liquids, toxic substances, and so on.) in the framework of international transport. If this field is populated then the is_hazmat flag must be true.

demand_planning_enabled

string

No

Identifies parts used for demand planning.

inventory_planning_enabled

string

No

Identifies parts used for inventory planning.

mrp_enabled

string

No

Identifies parts enabled for planning in MRP.

purchased_item

string

No

Identifies parts that are purchased.

1Foreign 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
product_group_id Product product_hierarchy id
parent_product_id Product product id
un_id Product un_details un_id