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

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

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