Salesforce Commerce Cloud

Explore the interactive ERD

Table & Field Reference

store

Column	Type	Keys
`id`	String	PK
`address_1`	String
`address_2`	String
`city`	String
`country_code`	String
`creation_date`	Instant
`email`	String
`fax`	String
`inventory_id`	String
`last_modified`	Instant
`latitude`	String
`longitude`	String
`name`	String
`phone`	String
`pos_enabled`	Boolean
`postal_code`	String
`state_code`	String
`store_locator_enabled`	String

price_book

Column	Type	Keys
`id`	String	PK
`creation_date`	Instant
`currency_code`	String
`description`	String
`display_name`	String
`last_modified`	Instant
`online`	Boolean
`parent_id`	String
`valid_from`	Instant
`valid_to`	Instant

assignment

Column	Type	Keys
`campaign_id`	String	PKFK
`promotion_id`	String	PKFK
`rank`	Int
`schedule_end_date`	Instant
`schedule_start_date`	Instant

shared_product_option

Column	Type	Keys
`id`	String	PK
`catalog_id`	String	PKFK
`custom_name`	Json
`default_product_option_value`	String
`description`	Json
`link`	String
`name`	String
`selected_option_value`	String
`shared`	Boolean
`sorting_mode`	String
`image_`

catalog

Column	Type	Keys
`id`	String	PK
`assigned_product_count`	Int
`category_count`	Int
`creation_date`	Instant
`last_modified`	Instant
`online`	Boolean
`owned_product_count`	Int
`recommendation_count`	Int
`root_category`	String

ab_test

Column	Type	Keys
`id`	String	PK
`description`	String
`enabled`	Boolean
`schedule_end_date`	Instant
`schedule_start_date`	Instant
`segment_description`	String
`segment_id`	String

order_billing_address

Column	Type	Keys
`order_id`	String	PKFK
`address_1`	String
`city`	String
`country_code`	String
`first_name`	String
`full_name`	String
`last_name`	String
`phone`	String
`postal_code`	String
`state_code`	String

product

Column	Type	Keys
`id`	String	PK
`master_id`	String	FK
`owning_catalog_id`	String	FK
`primary_category_id`	String	FK
`brand`	String
`classification_category_catalog_id`	String
`classification_category_category_id`	String
`creation_date`	Instant
`default_variant_id`	String
`ean`	String
`image_abs_url`	String
`last_modified`	Instant
`long_description_default_markup`	String
`long_description_default_source`	String
`manufacturer_name`	String
`manufacturer_sku`	String
`price`	Double
`price_currency`	String
`price_per_unit`	Double
`short_description_default_markup`	String
`short_description_default_source`	String
`tax_class_id`	String
`unit`	String
`unit_measure`	String
`unit_quantity`	Double
`upc`	String
`type_`

coupon_redemption

Column	Type	Keys
`coupon_id`	String	PKFK
`order_id`	String	PKFK
`code`	String
`creation_date`	Instant
`customer_email`	String

customer_address

Column	Type	Keys
`index`	Long	PK
`customer_no`	String	PKFK
`address_1`	String
`address_2`	String
`city`	String
`company_name`	String
`country_code`	String
`creation_date`	Instant
`etag`	String
`first_name`	String
`full_name`	String
`id`	String
`job_title`	String
`last_modified`	Instant
`last_name`	String
`phone`	String
`post_box`	String
`postal_code`	String
`salutation`	String
`second_name`	String
`state_code`	String
`suffix`	String
`suite`	String
`title`	String

product_image_group_image

Column	Type	Keys
`index`	Long	PK
`product_id`	String	PKFK
`product_image_group_index`	Long	PKFK
`abs_url`	String
`dis_base_url`	String
`path`	String

order_shipping_item

Column	Type	Keys
`item_id`	String	PK
`shipment_id`	String	PKFK
`adjusted_tax`	Double
`base_price`	Double
`gross_price`	Double
`item_text`	String
`net_price`	Double
`order_id`	String
`price_after_item_discount`	Double
`tax`	Double
`tax_basis`	Double
`tax_rate`	Double
`type`	String

payment_instrument

Column	Type	Keys
`payment_instrument_id`	String	PK
`bank_routing_number`	String
`payment_method`	String
`payment_card`

assigned_category

Column	Type	Keys
`catalog_id`	String	PKFK
`category_id`	String	PKFK
`product_id`	String	PKFK

campaign

Column	Type	Keys
`id`	String	PK
`coupons`	Json
`creation_date`	Instant
`description`	String
`enabled`	Boolean
`end_date`	Instant
`last_modified`	Instant
`site_id`	String
`start_date`	Instant

order_payment_instrument

Column	Type	Keys
`order_id`	String	PKFK
`payment_instrument_id`	String	PKFK
`authorization_status`	Int
`authorization_status_code`	String
`authorization_status_message`	String
`masked_gift_certificate_code`	String
`payment_transaction_amount`	Double
`payment_transaction_id`	String

source_code_group

Column	Type	Keys
`id`	String	PK
`active`	Boolean
`active_indirect_location_type`	String
`cookie_duration`	Int
`creation_date`	Instant
`description`	String
`enabled`	Boolean
`end_time`	Instant
`inactive_redirect_location_type`	String
`last_modified`	Instant
`start_time`	Instant

custom_object_attribute_definition

Column	Type	Keys
`id`	String	PK
`creation_date`	Instant
`description`	Json
`display_name`	Json
`effective_id`	String
`externally_defined`	Boolean
`externally_managed`	Boolean
`field_height`	Int
`field_length`	Int
`key`	Boolean
`last_modified`	Instant
`link`	String
`localizable`	Boolean
`mandatory`	Boolean
`max_value`	Double
`min_length`	Int
`min_value`	Double
`multi_value_type`	Boolean
`object_type`	String
`order_required`	Boolean
`queryable`	Boolean
`read_only`	Boolean
`regular_expression`	String
`requires_encoding`	Boolean
`scale`	Int
`searchable`	Boolean
`set_value_type`	Boolean
`site_specific`	Boolean
`system`	Boolean
`unit`	Json
`value_type`	String
`visible`	Boolean
`default_value_`

inventory_list

Column	Type	Keys
`id`	String	PK
`assigned_sites`	Json
`creation_date`	Instant
`default_in_stock`	Boolean
`description`	String
`last_modified`	Instant
`on_order_inventory_enabled`	Boolean
`use_bundle_inventory_only`	Boolean

campaign_source_code_group

Column	Type	Keys
`campaign_id`	String	PKFK
`source_code_group_id`	String	PKFK

inventory_list_record

Column	Type	Keys
`index`	Int	PK
`inventory_list_id`	String	PKFK
`product_id`	String	FK
`allocation_amount`	Double
`allocation_reset_date`	Instant
`ats`	Double
`creation_date`	Instant
`in_stock_date`	Instant
`inventory_turnover`	Double
`last_modified`	Instant
`perpetual_flag`	Boolean
`pre_order_back_order_allocation`	Double
`pre_order_back_order_handling`	String
`product_name`	String
`quantity_on_order`	Double
`stock_level`	Double

product_image_group_variation_attribute

Column	Type	Keys
`id`	String	PK
`product_id`	String	PKFK
`product_image_group_index`	Long	PKFK
`attribute_definition_id`	String
`shared`	Boolean
`slicing`	Boolean
`variation_attribute_type`	String

custom_object

Column	Type	Keys
`key_property`	String	PK
`key_value`	Unknown	PK
`object_type`	String	PK
`creation_date`	Instant
`last_modified`	Instant

promotion_ab_test

Column	Type	Keys
`status`	String	PK
`ab_test_id`	String	PKFK
`promotion_id`	String	PKFK

gift_certificate

Column	Type	Keys
`id`	String	PK
`order_id`	String	FK
`amount_currency_mnemonic`	String
`amount_value`	Double
`balance_currency_mnemonic`	String
`balance_value`	Double
`creation_date`	Instant
`description`	String
`enabled`	Boolean
`last_modified`	Instant
`masked_gift_certificate_code`	String
`message`	String
`recipient_email`	String
`recipient_name`	String
`sender_name`	String
`status`	String

product_image_group

Column	Type	Keys
`index`	Long	PK
`product_id`	String	PKFK
`view_type`	String

orders_history

Column	Type	Keys
`id`	String	PK
`last_modified`	Instant	PK
`customer_id`	String	FK
`adjusted_merchandize_total_tax`	Double
`adjusted_shipping_total_tax`	Double
`cancel_code`	String
`confirmation_status`	String
`created_by`	String
`creation_date`	Instant
`currency`	String
`customer_is_guest`	Boolean
`export_status`	String
`invoice_no`	String
`merchandize_total_tax`	Double
`order_total`	Double
`payment_status`	String
`place_date`	Instant
`product_sub_total`	Double
`product_total`	Double
`remote_host`	String
`shipping_status`	String
`shipping_total`	Double
`shipping_total_tax`	Double
`site_id`	String
`status`	String
`tax_total`	Double
`taxation`	String

price_adjustment

Column	Type	Keys
`item_id`	String	PK
`price_adjustment_id`	String	PK
`campaign_id`	String	FK
`order_id`	String	FK
`promotion_id`	String	FK
`ab_test_segment_segment_id`	String
`ab_test_segment_test_id`	String
`base_price`	Double
`coupon_code`	String
`created_by`	String
`creation_date`	Instant
`custom`	Boolean
`gross_price`	Double
`item_text`	String
`last_modified`	Instant
`manual`	Boolean
`net_price`	Double
`price_adjustment_type`	String
`reason_code`	String
`tax`	Double
`tax_basis`	Double
`applied_discount_`

promotion_tag

Column	Type	Keys
`id`	String	PK
`promotion_id`	String	PKFK

customer

Column	Type	Keys
`id`	String	PK
`birthday`	LocalDate
`company_name`	String
`creation_date`	Instant
`credentials_enabled`	Boolean
`credentials_locked`	Boolean
`credentials_login`	String
`credentials_password_question`	String
`customer_no`	String
`email`	String
`fax`	String
`first_name`	String
`gender`	Int
`job_title`	String
`last_login_time`	Instant
`last_modified`	Instant
`last_name`	String
`last_visit_time`	Instant
`phone_business`	String
`phone_home`	String
`phone_mobile`	String
`preferred_locale`	String
`previous_login_time`	Instant
`previous_visit_time`	Instant
`primary_address_address_1`	String
`primary_address_address_2`	String
`primary_address_city`	String
`primary_address_company_name`	String
`primary_address_country_code`	String
`primary_address_creation_date`	Instant
`primary_address_etag`	String
`primary_address_first_name`	String
`primary_address_full_name`	String
`primary_address_id`	String
`primary_address_job_title`	String
`primary_address_last_modified`	Instant
`primary_address_last_name`	String
`primary_address_phone`	String
`primary_address_post_box`	String
`primary_address_postal_code`	String
`primary_address_salutation`	String
`primary_address_second_name`	String
`primary_address_state_code`	String
`primary_address_suffix`	String
`primary_address_suite`	String
`primary_address_title`	String
`salutation`	String
`second_name`	String
`suffix`	String
`title`	String

Column	Type	Keys
`catalog_id`	String	PK
`id`	String	PKFK
`parent_category_id`	String	FK
`creation_date`	Instant
`last_modified`	Instant
`online`	Boolean
`position`	Int

order_shipment_address

Column	Type	Keys
`order_id`	String	PKFK
`shipment_id`	String	PKFK
`address_1`	String
`city`	String
`country_code`	String
`first_name`	String
`full_name`	String
`last_name`	String
`phone`	String
`postal_code`	String
`state_code`	String

product_image_group_variation_attribute_value

Column	Type	Keys
`index`	Long	PK
`product_id`	String	PKFK
`product_image_group_index`	Long	PKFK
`product_image_group_variation_attribute_id`	String	PKFK
`orderable`	Boolean
`position`	Int
`value`	String

custom_object_attribute_group

Column	Type	Keys
`id`	String	PK
`attribute_definitions_count`	Int
`creation_date`	Instant
`description`	Json
`display_name`	Json
`internal`	Boolean
`last_modified`	Instant
`link`	String
`object_type`	String
`position`	Double

order_shipment

Column	Type	Keys
`shipment_id`	String	PK
`shipment_no`	String	PK
`order_id`	String	PKFK
`adjusted_merchandize_total_tax`	Double
`adjusted_shipping_total_tax`	Double
`gift`	Boolean
`merchandize_total_tax`	Double
`product_sub_total`	Double
`product_total`	Double
`shipment_total`	Double
`shipping_method_id`	String
`shipping_status`	String
`shipping_total`	Double
`shipping_total_tax`	Double
`tax_total`	Double

campaign_customer_group

Column	Type	Keys
`campaign_id`	String	PKFK
`customer_group_id`	String	PKFK

price_book_site_assignment

Column	Type	Keys
`site_id`	String	PK
`price_book_id`	String	PKFK
`display_name`	String

order_product_item

Column	Type	Keys
`item_id`	String	PK
`order_id`	String	PKFK
`product_id`	String	PKFK
`shipment_id`	String	FK
`shipping_item_id`	String	FK
`adjusted_tax`	Double
`base_price`	Double
`bonus_product_line_item`	Boolean
`gift`	Boolean
`gross_price`	Double
`item_text`	String
`net_price`	Double
`position`	Double
`price_after_item_discount`	Double
`price_after_order_discount`	Double
`product_name`	String
`quantity`	Double
`tax`	Double
`tax_basis`	Double
`tax_rate`	Double

shared_product_option_value

Column	Type	Keys
`id`	String	PK
`product_option_id`	String	PKFK
`link`	String
`option_prices`	Json
`sku_extension`	String
`value`	Json

customer_group

Column	Type	Keys
`id`	String	PK
`creation_date`	Instant
`description`	String
`last_modified`	Instant
`link`	String
`rule_description`	String
`type`	String

primary_category

Column	Type	Keys
`catalog_id`	String	PKFK
`category_id`	String	PKFK
`product_id`	String	PKFK

campaign_promotion

Column	Type	Keys
`status`	String	PK
`campaign_id`	String	PKFK
`promotion_id`	String	PKFK

gift_certificate_transaction

Column	Type	Keys
`index`	Int	PK
`gift_certificate_id`	String	PKFK
`order_id`	String	FK
`amount_currency_mnemonic`	String
`amount_value`	Double
`timestamp`	Instant
`type_code`	String

promotion

Column	Type	Keys
`id`	String	PK
`archived`	Boolean
`creation_date`	Instant
`currency_code`	String
`disable_globally_excluded`	Boolean
`enabled`	Boolean
`exclusivity`	String
`last_modified`	Instant
`promotion_class`	String
`site_id`	String

campaign_coupon

Column	Type	Keys
`campaign_id`	String	PKFK
`coupon_id`	String	PKFK

coupon

Column	Type	Keys
`id`	String	PK
`creation_date`	Instant
`description`	String
`enabled`	Boolean
`exported_code_count`	Int
`last_modified`	Instant
`redemption_count`	Int
`redemption_limits_per_code`	Int
`redemption_limits_per_customer`	Int
`single_code`	String
`system_codes_config_code_prefix`	String
`system_codes_config_number_of_codes`	Int
`total_codes_count`	Int
`type`	String