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 |