Others

Account

Table: account

Column Name	Data type	Description
account_id	Integer	Intentwise Account Id
account_name	String	Intentwise Account Name
organization_name	String	Organization name used within the intentwise
amazon_profile_id	Integer	Unique amazon Identifier for sellers and vendors referenced by APIs
region	String	Account region
country_code	String	Country code of the account
currency_code	String	Currency Code of the account
market_place	String	Market place of the account
brand_id	String	Identifier for sellers and vendors. Note that this value is not unique and maybe the same across the marketplace.
brand_type	String	The SELLER and VENDOR account types are associated with Sponsored Ads APIs. The AGENCY account type is associated with DSP
vendor_name	String	Account name used within the amazon console

Catalog Master

Table: catalog_master

Note: This table should be used in conjunction with catalog_item_summary. Use ctlg_master_id as the join condition

Column Name	Data type	Description
ctlg_master_id	Integer	Unique Identifier
asin	String	Amazon ASIN
account_id	Integer	Intentwise Account Identifier
account_name	String	Intentwise Account Name
updated date	Date	Updated Date

Catalog Item Summary

Table: catalog_item_summary

Column Name	Data type	Description
id	Integer	Unique Identfier
brand_name	String	Name of the brand associated with an Amazon catalog item
browse_node	String	Classification (browse node) associated with an Amazon catalog item.
color_name	String	Name of the color associated with an Amazon catalog item.
item_name	String	Name, or title, associated with an Amazon catalog item.
manufacturer	String	Name of the manufacturer associated with an Amazon catalog item.
model_number	String	Model number associated with an Amazon catalog item.
size_name	String	Name of the size associated with an Amazon catalog item.
style_name	String	Name of the style associated with an Amazon catalog item.
ctlg_master_id	Integer	Key to join with catalog_master table
account_id	Integer	Intentwise account identifier
asin	String	Amazon ASIN
website_display_group_name	String	The display name of the website display group that is associated with the Amazon catalog item.
adult_product	Boolean	When true, the Amazon catalog item is intended for an adult audience.
autographed	Boolean	When true, the Amazon catalog item is autographed.
memorabilia	Boolean	When true, the item is classified as memorabilia.
trade_in_eligible	Boolean	When true, the Amazon catalog item is eligible for trade-in.
package_quantity	Integer	The quantity of the Amazon catalog item within one package.
part_number	String	The part number that is associated with the Amazon catalog item.
browse_display_name	String	Browse Display Name
website_display_group	String	The identifier of the website display group that is associated with the Amazon catalog item
release_date	Date	The earliest date on which the Amazon catalog item can be shipped to customers.

Catalog Item Images

Table: catalog_item_images

Note: This table can be used in conjunction with catalog_item_summary and catalog_master. Use ctlg_master_id as the join condition

Column Name	Data Type	Description
id	Integer	Unique Identfier
variant	string	Variant of the image, such as MAIN or PT01
link	String	Link, or URL, for the image.
height	Integer	Height of the image in pixels.
width	Integer	Width of the image in pixels.
ctlg_master_id	Integer	Key to join with catalog_master table
account_id	Integer	Intentwise account identifier

Catalog Item Dimension

Table: catalog_item_dimension

Dimensions associated with the item in the Amazon catalog

Note: This table has to be used in conjunction with catalog_master. Use ctlg_master_id as the join condition

Column Name	Data type	Description
item_height_value	Numeric	Height of an item
item_height_unit	String	Measurement unit of the dimension value.
item_length_value	Numeric	Length of an item
item_length_unit	String	Measurement unit of the dimension value.
item_weight_value	Numeric	Weight of an item
item_weight_unit	String	Measurement unit of the dimension value.
item_width_value	Numeric	Width of an item
item_width_unit	String	Measurement unit of the dimension value.
package_height_value	Numeric	Height of an package
package_height_unit	String	Measurement unit of the dimension value.
package_length_value	Numeric	Length of an package
package_length_unit	String	Measurement unit of the dimension value.
package_weight_value	Numeric	Weight of an package
package_weight_unit	String	Measurement unit of the dimension value.
package_width_value	Numeric	Width of an package
package_width_unit	String	Measurement unit of the dimension value.
ctlg_master_id	Integer	Key to join with catalog_master table
account_id	Integer	Intentwise account identifier

Catalog Item Vendor Detail

Table: catalog_item_vendor_detail

Vendor details associated with an Amazon catalog item. Vendor details are available to vendors only.

Note: This table has to be used in conjunction with catalog_master. Use ctlg_master_id as the join condition

Column Name	Data type	Description
brand_code	String	Brand code associated with an Amazon catalog item.
manufacturer_code	String	Manufacturer code associated with an Amazon catalog item.
manufacturer_code_parent	String	Parent vendor code of the manufacturer code.
product_group	String	Product group associated with an Amazon catalog item.
ctlg_master_id	Integer	Key to join with catalog_master table
product_category_display_name	String	Display name of the product category
product_category_value	String	Value (code) of the product category
product_sub_category_display_name	String	Display name of the product subcategory
product_sub_category_value	String	Value (code) of the subcategory.
replenishment_category	String	Replenishment category associated with an Amazon catalog item.
account_id	Integer	Intentwise account identifier

Catalog Item Child Relation

Table: catalog_item_child_relation

Relationship details for an Amazon catalog item.

Note: This table provides information about Parent and child relationship. You can filter on a parent_asin and fetch all child_asins.

Column Name	Data type	Description
child_asin	varchar	ASINs of the related items that are children of this item.
parent_asin	varchar	ASINs of the related items that are parents of this item.
relation_type	varchar	Type of relationship. Example : "VARIATION"
variation_attributes	varchar	Names of the Amazon catalog item attributes that are associated with the variation theme.
variation_theme	varchar	Variation theme that indicates the combination of Amazon catalog item attributes that define the variation family
variation_type	varchar	Type of Variation
ctlg_master_id	bigint	Key to join with catalog_master table
account_id	bigint	Intentwise Account Identifier

Catalog Item Parent Relation

Table: catalog_item_parent_relation

Relationship details for an Amazon catalog item.

Note: This table provides information about Parent and child relationship. You can filter on a child_asin and fetch all parent_asins.

Column Name	Data type	Description
parent_asin	varchar	ASINs of the related items that are parents of this item.
child_asin	varchar	ASINs of the related items that are children of this item.
relation_type	varchar	Type of relationship. Example : "VARIATION"
variation_attributes	varchar	Names of the Amazon catalog item attributes that are associated with the variation theme.
variation_theme	varchar	Variation theme that indicates the combination of Amazon catalog item attributes that define the variation family
variation_type	varchar	Type of Variation
ctlg_master_id	bigint	Key to join with catalog_master table
account_id	bigint	Intentwise Account Identifier

Catalog Item Attribute

Table: catalog_item_attributes

Catalog Item Attribute details for an Amazon catalog item.

Note: This table can be used in conjunction with catalog_item_summary and catalog_master. Use ctlg_master_id as the join condition

Column Name	Data type	Description
attribute_value	super	A JSON object containing structured item attribute data that is keyed by attribute name.
ctlg_master_id	bigint	Key to join with catalog_master table
account_id	bigint	Intentwise Account Identifier
asin	varchar	ASIN Value

Catalog Item Classifications

Table: catalog_item_classifications

Catalog Item Classification details for an Amazon catalog item.

Note: This table can be used in conjunction with catalog_item_summary and catalog_master. Use ctlg_master_id as the join condition

Column Name	Data type	Description
classification_id	varchar	Identifier of the classification.
display_name	varchar	Display name for the classification.
child_id	bigint	Child ID
ctlg_master_id	bigint	Key to join with catalog_master table
account_id	bigint	Intentwise Account Identifier
asin	varchar	ASIN Value

Catalog Item Identifiers

Table: catalog_item_identifiers

Catalog Item Identifier details for an Amazon catalog item.

Note: This table can be used in conjunction with catalog_item_summary and catalog_master. Use ctlg_master_id as the join condition

Column Name	Data type	Description
identifier_type	varchar	Type of identifier, such as UPC, EAN, or ISBN.
identifier	varchar	Identifier of the item.
ctlg_master_id	bigint	Key to join with catalog_master table
account_id	bigint	Intentwise Account Identifier
asin	varchar	ASIN Value

Catalog Item Product Type

Table: catalog_item_product_types

Catalog Item Product Type details for an Amazon catalog item.

Note: This table can be used in conjunction with catalog_item_summary and catalog_master. Use ctlg_master_id as the join condition

Column Name	Data type	Description
product_type	varchar	Product Type
ctlg_master_id	bigint	Key to join with catalog_master table
account_id	bigint	Intentwise Account Identifier
asin	varchar	ASIN Value

Catalog Item Sales Ranks

Table: catalog_item_sales_ranks

Catalog Item Sales Rank details for an Amazon catalog item.

Note: This table can be used in conjunction with catalog_item_summary and catalog_master. Use ctlg_master_id as the join condition

Column Name	Data type	Description
title	varchar	Name of the sales rank.
link	varchar	Corresponding Amazon retail website URL for the sales category.
rank	integer	Sales rank.
classification_id	varchar	Identifier of the classification that is associated with the sales rank.
website_display_group	varchar	The identifier of the website display group that is associated with the Amazon catalog item.
ctlg_master_id	bigint	Key to join with catalog_master table
account_id	bigint	Intentwise Account Identifier
asin	varchar	ASIN Value