Integration Specifications
This article will help you learn about how Daasity replicates data from Salesforce Commerce Cloud, limitations to the data we can extract and where the data is stored in the Salesforce Commerce schema
Integration Overview
Salesforce Commerce Cloud empowers you to create seamless e-commerce experiences that inspire and convert today's connected shoppers. With our cloud-based e-commerce software, you can go to market faster and smarter — delivering personalized customer experiences across mobile, digital, and social platforms.
Salesforce Commerce Cloud (also known as Demandware) allows brands to build localized site, order management and fulfillment for each region in a single platform.
This document provides context on what kind of data is being gathered through this extractor, which endpoints that data is coming from, and how the extracted tables relate to each other.
Integration Availability
This integration is available for:
Enterprise
API Endpoints
The Daasity Salesforce Commerce Cloud extractor is broken into two sections:
Salesforce B2C Commerce (SFCC) endpoints are based on this OpenCommerce API Documentation to extract data from the website.
Salesforce Order Management (SOM) endpoints are based on this Salesforce Order Management API documentation to extract order data.
These endpoints are used by Daasity to replicate data from Salesforce Commerce Cloud:
Salesforce B2C Commerce (SFCC)
Campaigns
Catalogs
Coupons
Coupon Redemption Search
Inventory Lists
Products
Promotions
Sites
Salesforce Order Management (SOM)
Accounts
Contacts
Fulfillment Order Item Tax
Fulfillment Order Line Item
Order Adjustment Group Summary
Order Delivery Group Summary
Order Item Summary
Order Item Tax Line Summary
Order Payments Summary
Order Summary
Sales Channels
Entity Relationship Diagram (ERD)
Click here to view the ERD for the Daasity Salesforce Commerce Cloud integration illustrating the different tables and keys to join across tables.
Salesforce Commerce Cloud Schema
The Daasity Salesforce Commerce extractor creates these tables using the endpoints and replication methods listed. The data is mapped from source API endpoint to the table based on the mapping logic outlined in each table.
Salesforce B2C Commerce (SFCC)
Campaigns
Endpoint: SFCC Campaigns
Update Method: UPSERT
Table Name: [
salesforce_commerce.campaigns]
campaign_id
campaign_id
description
description
enabled
enabled
start_date
start_date
end_date
end_date
creation_date
created_at
Daasity: shop_id
__shop_id
Daasity: account_id
_account_id
Daasity: MD5(campaign_id + __shop_id)
__sync_key
Daasity: timestamp when loaded into DB
__synced_at
Campaign Customer Groups
Endpoint: SFCC Campaigns
Update Method: UPSERT
Table Name: [
salesforce_commerce.campaign_customer_groups]
campaign_id
campaign_id
customer_groups
customer_groups
Daasity: shop_id
__shop_id
Daasity: account_id
_account_id
Daasity: MD5(campaign_id + customer_groups + __shop_id)
__sync_key
Daasity: timestamp when loaded into DB
__synced_at
Campaign Coupon Codes
Endpoint: SFCC Campaigns
Update Method: UPSERT
Table Name: [
salesforce_commerce.campaign_coupon]
campaign_id
campaign_id
coupons
coupon_code
Daasity: shop_id
__shop_id
Daasity: account_id
_account_id
Daasity: MD5(campaign_id + coupons + __shop_id)
__sync_key
Daasity: timestamp when loaded into DB
__synced_at
Catalogs
Endpoint: SFCC Catelogs
Update Method: UPSERT
Table Name: [
salesforce_commerce.catalogs]
id
catalog_id
creation_date
created_at
last_modified
updated_at
online
online_status
name::default
catalog_name
assigned_product_count
assigned_product_count
category_count
category_count
owned_product_count
owned_product_count
recommendation_count
recommendation_count
Daasity: shop_id
__shop_id
Daasity: account_id
_account_id
Daasity: MD5(id + __shop_id)
__sync_key
Daasity: timestamp when loaded into DB
__synced_at
Catalog Sites
Endpoint: SFCC Catalogs
Update Method: UPSERT
Table Name: [
salesforce_commerce.catalog_sites]
assigned_sites::id
catalog_site_id
id
catalog_id
Daasity: shop_id
__shop_id
Daasity: account_id
_account_id
Daasity: MD5(assigned_sites::id + __shop_id)
__sync_key
Daasity: timestamp when loaded into DB
__synced_at
Coupons
Endpoint: SFCC Coupons
Update Method: UPSERT
Table Name: [
salesforce_commerce.coupons]
coupon_id
coupon_id
creation_date
created_at
last_modified
updated_at
description
description
enabled
coupon_enabled
single_code
coupon_code
total_codes_count
total_coupon_codes
type
coupon_code_type
redemption_limits::limit_per_code
limit_per_code
redemption_limits::limit_per_customer
limit_per_customer
system_codes_config::code_prefix
coupon_code_prefix
system_codes_config::number_of_codes
max_coupon_codes
Daasity: shop_id
__shop_id
Daasity: account_id
_account_id
Daasity: MD5(coupon_id + __shop_id)
__sync_key
Daasity: timestamp when loaded into DB
__synced_at
Coupon Redemptions
Endpoint: SFCC Coupon Redemption Search
Update Method: UPSERT
Table Name: [
salesforce_commer.coupon_redemptions]
coupon_id
coupon_id
coupon_code
coupon_code
customer_email
customer_email
order_no
order_no
creation_date
created_at
Daasity: shop_id
__shop_id
Daasity: account_id
_account_id
Daasity: MD5(coupon_id + order_no + __shop_id)
__sync_key
Daasity: timestamp when loaded into DB
__synced_at
Inventory Lists
Endpoint: SFCC Inventory Lists
Update Method: UPSERT
Table Name: [
salesforce_commerce.inventory_lists]
id
inventory_list_id
creation_date
created_at
last_modified
updated_at
default_in_stock
default_in_stock
on_order_inventory_enabled
on_order_inventory_enabled
use_bundle_inventory_only
use_bundle_inventory_only
Daasity: shop_id
__shop_id
Daasity: account_id
_account_id
Daasity: MD5(id + __shop_id)
__sync_key
Daasity: timestamp when loaded into DB
__synced_at
Inventory List Sites
Endpoint: SFCC Inventory Lists
Update Method: UPSERT
Table Name: [
salesforce_commerce.inventory_list_sites]
id || ':' || assigned_sites::value
inventory_list_site_id
id
inventory_list_id
assigned_sites::value
site_name
Daasity: shop_id
__shop_id
Daasity: account_id
_account_id
Daasity: MD5(id + assigned_sites::value + __shop_id)
__sync_key
Daasity: timestamp when loaded into DB
__synced_at
Products
Endpoint: SFCC Products
Update Method: UPSERT
Table Name: [
salesforce_commerce.products]
id
product_id
brand
brand
name::default
product_name
type::bundle
product_is_bundle_flag
type::bundled
product_part_of_bundle_flag
type::item
product_item_flag
type::master
product_master_flag
type::option
product_option_flag
type::part_of_product_set
part_of_product_set_flag
type::part_of_retail_set
part_of_retail_set_flag
type::retail_set
product_retail_set_flag
type::set
product_set_flag
type::variant
product_variant_flag
type::variation_group
production_variation_group_flag
short_description::default::source
short_description
long_description::default::source
long_description
page_description::default
page_description
page_keywords::default
page_keywords
page_title::default
page_title
ats
available_to_sell
default_variant_id
default_variant_id
ean
ean
in_stock
in_stock
link
product_rl
manufacturer_name
manufacturer_name
manufacturer_sku
manufacturer_sku
maser::master_id
product_master_id
online_flag::default@[site_id]
online_flag
owning_catalog_id
owning_catalog_id
owning_catalog_name
owning_catalog_name
price
price
price_currency
price_currency
primary_category_id
primary_category_id
searchable
searchable
unit
unit
upc
upc
creation_date
created_at
last_modified
updated_at
Daasity: shop_id
__shop_id
Daasity: account_id
_account_id
Daasity: MD5(id + __shop_id)
__sync_key
Daasity: timestamp when loaded into DB
__synced_at
Product Categories
Endpoint: SFCC Products
Update Method: UPSERT
Table Name: [
salesforce_commerce.product_categories]
id
product_id
assigned_categories::catalog_id
catelog_id
assigned_categories::category_id
category_id
Daasity: shop_id
__shop_id
Daasity: account_id
_account_id
Daasity: MD5(id + assigned_categories::catalog_id + __shop_id)
__sync_key
Daasity: timestamp when loaded into DB
__synced_at
Product Bundles
Endpoint: SFCC Products
Update Method: UPSERT
Table Name: [
salesforce_commerce.product_bundles]
id
product_id
bundled_products::id
bundled_product_id
Daasity: shop_id
__shop_id
Daasity: account_id
_account_id
Daasity: MD5(id + bundled_products::id + __shop_id)
__sync_key
Daasity: timestamp when loaded into DB
__synced_at
Product Images
Endpoint: SFCC Products
Update Method: UPSERT
Table Name: [
salesforce_commerce.product_images]
id
product_id
image::alt::default
alt_image_text
image::dis_base_url
product_image_url
image::title::default
image_title
Daasity: shop_id
__shop_id
Daasity: account_id
_account_id
Daasity: MD5(id + image::title::default + __shop_id)
__sync_key
Daasity: timestamp when loaded into DB
__synced_at
Product Options
Endpoint: SFCC Products
Update Method: UPSERT
Table Name: [
salesforce_commerce.product_options]
id
product_id
product_options::id
product_option_id
product_options::custom_name
custom_name
product_options::default_product_option_value
default_option
product_options::description::default
description
product_options::name
product_option_name
product_options::selected_option_value
selected_option
product_options::shared
shared_product_option_flag
Daasity: shop_id
__shop_id
Daasity: account_id
_account_id
Daasity: MD5(id +product_options::id + __shop_id)
__sync_key
Daasity: timestamp when loaded into DB
__synced_at
Product Sets
Endpoint: SFCC Products
Update Method: UPSERT
Table Name: [
salesforce_commerce.product_sets]
id
product_id
product_sets::id
component_product_id
Daasity: shop_id
__shop_id
Daasity: account_id
_account_id
Daasity: MD5(id +product_sets::id + __shop_id)
__sync_key
Daasity: timestamp when loaded into DB
__synced_at
Product Variants
Endpoint: SFCC Products
Update Method: UPSERT
Table Name: [
salesforce_commerce.product_variants]
id
product_id
variants::product_id
product_variant_id
variants::ats
available_to_sell
variants::in_stock
in_stock
variants::link
product_variant_url
variants::online
online_flag
variants::orderable
orderable_flag
variants::price
price
variants::price_currency
price_currency
variants::searchable::default@[site_id][1]
searchable
Daasity: shop_id
__shop_id
Daasity: account_id
_account_id
Daasity: MD5(id + variants::product_id + __shop_id)
__sync_key
Daasity: timestamp when loaded into DB
__synced_at
Product Custom Attribute Values
Endpoint: SFCC Products
Update Method: UPSERT
Table Name: [
salesforce_commerce.product_custom_attribute_values]
id
product_id
key
custom_attribute_key
value
custom_attribute_value
Daasity: shop_id
__shop_id
Daasity: account_id
_account_id
Daasity: MD5(id + key + __shop_id)
__sync_key
Daasity: timestamp when loaded into DB
__synced_at
Promotions
Endpoint: SFCC Promotions
Update Method: UPSERT
Table Name: [
salesforce_commerce.promotions]
id
promotion_id
name::default
promotion_name
promotion_class
promotion_class
currency_code
currency_code
archived
archived_flag
enabled
enabled_flag
disable_globally_exclusion
disable_global_exclusion_flag
exclusivity
exclusivity
assignment_information::campaign_id
campaign_id
assignment_information::schedule_type
promotion_schedule_type
assignment_information::end_date
promotion_end_date
creation_date
created_at
last_modified
updated_at
Daasity: shop_id
__shop_id
Daasity: account_id
_account_id
Daasity: MD5(id + __shop_id)
__sync_key
Daasity: timestamp when loaded into DB
__synced_at
Promotion Custom Attribute Values
Endpoint: SFCC Promotions
Update Method: UPSERT
Table Name: [
salesforce_commerce.promotion_custom_attribute_values]
id
promotion_id
key
custom_attribute_key
value
custom_attribute_value
Daasity: shop_id
__shop_id
Daasity: account_id
_account_id
Daasity: MD5(id + key + __shop_id)
__sync_key
Daasity: timestamp when loaded into DB
__synced_at
Promotion Tags
Endpoint: SFCC Promotions
Update Method: UPSERT
Table Name: [
salesforce_commerce.promotion_tags]
id
promotion_id
tags::tag_id
tag_name
Daasity: shop_id
__shop_id
Daasity: account_id
_account_id
Daasity: MD5(id + tags::tag_id + __shop_id)
__sync_key
Daasity: timestamp when loaded into DB
__synced_at
Sites
Endpoint: SFCC Sites
Update Method: UPSERT
Table Name: [
salesforce_commerce.sites]
id
site_id
display_name::default
site_name
storefront_status
site_status
description
description
Daasity: shop_id
__shop_id
Daasity: account_id
_account_id
Daasity: MD5(id + __shop_id)
__sync_key
Daasity: timestamp when loaded into DB
__synced_at
Salesforce Order Managment (SOM)
Accounts
Endpoint: SOM Account
Update Method: UPSERT
Table Name: [
salesforce_commerce.accounts]
Id
account_id
IsDeleted
is_deleted
MasterRecordId
master_record_id
Name
name
FirstName
first_name
LastName
last_name
Salutation
salutation
MiddleName
middle_name
Suffix
suffix
Type
typ
RecordTypeId
record_type_id
ParentId
parent_id
BillingStreet
billing_street
BillingCity
billing_city
BillingState
billing_state
BillingStateCode
billing_state_code
BillingPostalCode
billing_postal_code
BillingCountry
billing_country
BillingCountryCode
billing_country_code
BillingGeocodeAccuracy
billing_geocode_accuracy
BillingLatitude
billing_latitude
BillingLongitude
billing_longitude
ShippingStreet
shipping_street
ShippingCity
shipping_city
ShippingState
shipping_state
ShippingStateCode
shipping_state_code
ShippingPostalCode
shipping_postal_code
ShippingCountry
shipping_country
ShippingCountryCode
shipping_country_code
ShippingGeocodeAccuracy
shipping_geocode_accuracy
ShippingLatitude
shipping_latitude
ShippingLongitude
shipping_longitude
Phone
phone
PhotoUrl
photo_url
Industry
industry
Website
website
NumberOfEmployees
number_of_employees
Description
description
CurrencyIsoCode
currency_iso_code
OwnerId
owner_id
AccountNumber
account_number
HasOptedOutOfEmail
has_opted_out_of_email
PersonContactId
person_contact_id
IsPersonAccount
is_person_account
PersonEmail
person_email
PersonMailingStreet
person_mailing_street
PersonMailingCity
person_mailing_city
PersonMailingState
person_mailing_state
PersonMailingPostalCode
person_mailing_postal_code
PersonMailingCountry
person_mailing_country
PersonMailingGeocodeAccuracy
person_mailing_geocode_accuracy
PersonMailingLatitude
person_mailing_latitude
PersonMailingLongitude
person_mailing_longitude
PersonBirthDate
person_birth_date
PersonHomePhone
person_home_phone
PersonMobilePhone
person_mobile_phone
PersonTitle
person_title
PersonDepartment
person_department
PersonEmailBouncedDate
person_email_bounced_date
PersonEmailBouncedReason
person_email_bounced_reason
PersonHasOptedOutOfEmail
person_has_opted_out_of_email
AccountSource
account_source
Sic
sic
SicDesc
sic_desc
CreatedById
created_by_id
CreatedDate
created_at
LastActivityDate
last_activity_date
LastModifiedById
updated_by_id
LastModifiedDate
updated_at
LastReferencedDate
last_referenced_date
LastViewedDate
last_viewed_date
Daasity: shop_id
__shop_id
Daasity: account_id
_account_id
Daasity: MD5(id + __shop_id)
__sync_key
Daasity: timestamp when loaded into DB
__synced_at
Account Custom Attribute Values
Endpoint: SOM Account
Update Method: UPSERT
Table Name: [
salesforce_commerce.account_custom_attribute_values]
id
account_id
key
custom_attribute_key
value
custom_attribute_value
Daasity: shop_id
__shop_id
Daasity: account_id
_account_id
Daasity: MD5(id + key + __shop_id)
__sync_key
Daasity: timestamp when loaded into DB
__synced_at
Contacts
Endpoint: SOM Contacts
Update Method: UPSERT
Table Name: [
salesforce_commerce.contacts]
Id
contact_id
IsDeleted
is_deleted
MasterRecordId
master_record_id
AccountId
account_id
IsPersonAccount
is_person_account
CanAllowPortalSelfReg
can_allow_portal_self_reg
DoNotCall
do_not_call
LastName
last_name
FirstName
first_name
Salutation
salutation
MiddleName
middle_name
Suffix
suffix
Name
name
MailingStreet
mailing_street
MailingCity
mailing_city
MailingState
mailing_state
MailingPostalCode
mailing_postal_code
MailingCountry
mailing_country
MailingLatitude
mailing_latitude
MailingLongitude
mailing_longitude
MailingGeocodeAccuracy
mailing_geocode_accuracy
Phone
phone
Fax
fax
MobilePhone
mobile_phone
ReportsToId
reports_to_id
Title
title
Department
department
CurrencyIsoCode
currency_iso_code
OwnerId
owner_id
EmailBouncedReason
email_bounced_reason
EmailBouncedDate
email_bounced_at
IsEmailBounced
is_email_bounced
HasOptedOutOfEmail
has_opted_out_of_email
CreatedById
created_by_id
CreatedDate
created_at
LastModifiedById
updated_by_id
LastModifiedDate
updated_at
LastActivityDate
last_activity_date
LastReferencedDate
last_referenced_date
LastViewedDate
last_viewed_date
Daasity: shop_id
__shop_id
Daasity: account_id
_account_id
Daasity: MD5(id + __shop_id)
__sync_key
Daasity: timestamp when loaded into DB
__synced_at
Fulfillment Orders
Endpoint: Fulfillment Order
Update Method: UPSERT
Table Name: [
salesforce_commerce.fulfillment_orders]
AccountId
account_id
Id
fulfillment_order_id
OrderSummaryId
order_summary_id
OwnerId
owner_id
IsDeleted
is_deleted
IsSuspended
is_suspended
CurrencyIsoCode
currency_iso_code
FulfillmentOrderNumber
fulfillment_order_number
OrderId
order_id
InvoiceId
invoice_id
DeliveryMethodId
delivery_method_id
FulfilledFromLocationId
fulfilled_from_location_id
FulfilledToName
fulfilled_to_name
FulfilledToStreet
fulfilled_to_street
FulfilledToCity
fulfilled_to_city
FulfilledToState
fulfilled_to_state
FulfilledToPostalCode
fulfilled_to_postal_code
FulfilledToCountry
fulfilled_to_country
FulfilledToLatitude
fulfilled_to_latitude
FulfilledToLongitude
fulfilled_to_longitude
FulfilledToGeocodeAccuracy
fulfilled_to_geocode_accuracy
FulfilledToEmailAddress
fulfilled_to_address
FulfilledToPhone
fulfilled_to_phone
ItemCount
item_count
Status
status
StatusCategory
status_category
Type
type
TypeCategory
type_category
GrandTotalAmount
grand_total_amount
TotalProductAmount
total_product_amount
TotalAdjustmentAmount
total_adjustment_amount
TotalDeliveryAmount
total_delivery_amount
TotalProductTaxAmount
total_product_tax_amount
TotalAdjustmentTaxAmount
total_adjustment_tax_amount
TotalDeliveryTaxAmount
total_delivery_tax_amount
TotalAmount
total_amount
TotalTaxAmount
total_tax_amount
TotalDeliveryAdjustAmount
total_delivery_adjust_amount
TotalDeliveryAdjustTaxAmount
total_delivery_adjust_tax_Amount
CreatedById
created_by_id
CreatedDate
created_at
LastModifiedById
updated_by_id
LastModifiedDate
updated_at
LastViewedDate
last_viewed_date
LastReferencedDate
last_referenced_date
Daasity: shop_id
__shop_id
Daasity: account_id
_account_id
Daasity: MD5(id + __shop_id)
__sync_key
Daasity: timestamp when loaded into DB
__synced_at
Fulfillment Order Item Adjustments
Endpoint: SOM Fulfillment Order Item Adjustment
Update Method: UPESRT
Table Name: [
salesforce_commerce.fulfillment_order_item_adjustments]
Id
fulfillment_order_item_adjustment_id
IsDeleted
is_deleted
FulfillmentOrderItemAdjustmentNumber
fulfillment_order_item_adjustment_number
CurrencyIsoCode
currency_iso_code
FulfillmentOrderLineItemId
fulfillment_order_line_item_id
FulfillmentOrderId
fulfillment_order_id
OrderItemAdjustmentLineSummaryId
order_item_adjustment_line_summary_id
CampaignName
campaign_name
CouponName
coupon_name
PromotionName
promotion_name
Description
description
TotalTaxAmount
total_tax_amount
Amount
amount
CreatedDate
created_at
LastModifiedById
updated_by_id
LastModifiedDate
updated_at
LastViewedDate
last_viewed_date
LastReferencedDate
last_referenced_date
Daasity: shop_id
__shop_id
Daasity: account_id
_account_id
Daasity: MD5(id + __shop_id)
__sync_key
Daasity: timestamp when loaded into DB
__synced_at
Fulfillment Order Item Taxes
Endpoint: SOM Fulfillment Order Item Tax
Update Method: UPSERT
Table Name: [
salesforce_commerce.fulfillment_order_item_taxes]
Id
fulfillment_order_item_adjustment_id
IsDeleted
is_deleted
FulfillmentOrderItemAdjustmentNumber
fulfillment_order_item_adjustment_number
CurrencyIsoCode
currency_iso_code
FulfillmentOrderLineItemId
fulfillment_order_line_item_id
FulfillmentOrderId
fulfillment_order_id
OrderItemAdjustLineSummaryId
order_item_adjustment_line_summary_id
CampaignName
campaign_name
CouponName
coupon_name
PromotionName
promotion_name
Description
description
TotalTaxAmount
total_tax_amount
CreatedDate
created_at
LastModifiedById
updated_by_id
LastModifiedDate
updated_at
LastViewedDate
last_viewed_date
LastReferencedDate
last_referenced_date
Daasity: shop_id
__shop_id
Daasity: account_id
_account_id
Daasity: MD5(id + __shop_id)
__sync_key
Daasity: timestamp when loaded into DB
__synced_at
Fulfillment Order Line Items
Endpoint: SOM Fulfillment Order Line Item
Update Method: UPSERT
Table Name: [
salesforce_commerce.fulfillment_order_line_items]
Id
fulfillment_order_item_tax_id
IsDeleted
is_deleted
FulfillmentOrderItemTaxNumber
fulfillment_order_item_tax_number
CurrencyIsoCode
currency_iso_code
FulfillmentOrderLineItemId
fulfillment_order_line_item_id
FulfillmentOrderId
fulfillment_order_id
OrderItemTaxLineItemSummaryId
order_item_tax_line_item_summary_id
FulfillmentOrderItemAdjustmentId
fulfillment_order_item_adjust_id
Type
type
Amount
amount
Description
description
Rate
rate
TaxEffectiveDate
tax_effective_date
CreatedDate
created_at
LastModifiedById
updated_by_id
LastModifiedDate
updated_at
LastViewedDate
last_viewed_date
LastReferencedDate
last_referenced_date
Daasity: shop_id
__shop_id
Daasity: account_id
_account_id
Daasity: MD5(id + __shop_id)
__sync_key
Daasity: timestamp when loaded into DB
__synced_at
Fulfillment Order Line Item Custom Attribute Values
Endpoint: SOM Fulfillment Order Line Item
Update Method: UPSERT
Table Name: [
salesforce_commerce.fulfillment_order_line_item_custom_attribute_values]
id
fulfillment_order_line_item_id
key
custom_attribute_key
value
custom_attribute_value
Daasity: shop_id
__shop_id
Daasity: account_id
_account_id
Daasity: MD5(id + key + __shop_id)
__sync_key
Daasity: timestamp when loaded into DB
__synced_at
Order Adjustment Group Summaries
Endpoint: SOM Order Adjustment Group Summary
Update Method: UPSERT
Table Name: [
salesforce_commerce.order_adjustment_group_summaries]
Id
order_adjustment_group_summary_id
IsDeleted
is_deleted
Name
name
Description
description
CurrencyIsoCode
currency_iso_code
OrderSummaryId
order_summary_id
OriginalOrderAdjGroupId
original_order_adj_group_id
Type
type
TotalAmount
total_amount
TotalTaxAmount
total_tax_amount
GrandTotalAmount
grand_total_amount
CreatedById
created_by_id
CreatedDate
created_at
LastModifiedById
updated_by_id
LastModifiedDate
updated_at
Daasity: shop_id
__shop_id
Daasity: account_id
_account_id
Daasity: MD5(id + __shop_id)
__sync_key
Daasity: timestamp when loaded into DB
__synced_at
Order Delivery Group Summaries
Endpoint: SOM Order Delivery Group Summary
Update Method: UPSERT
Table Name: [
salesforce_commerce.order_delivery_group_summaries]
Id
order_delivery_group_summary_id
IsDeleted
is_deleted
Description
description
CurrencyIsoCode
currency_iso_Code
OrderDeliveryGroupSummaryNumber
order_delivery_group_summary_number
OrderSummaryId
order_summary_id
OriginalOrderDeliveryGroupId
original_order_delivery_group_id
OrderDeliveryMethodId
order_delivery_method_id
EmailAddress
email_address
PhoneNumber
phone_number
DeliverToName
deliver_to_name
DeliverToStreet
deliver_to_street
DeliverToCity
deliver_to_city
DeliverToState
deliver_to_state
DeliverToCountry
deliver_to_country
DeliverToLatitude
deliver_to_latitude
DeliverToLongitude
deliver_to_longitude
DeliverToGeocodeAccuracy
deliver_to_geocode_accuracy
GiftMessage
gift_message
IsGift
is_gift
DeliveryInstructions
delivery_instructions
DesiredDeliveryDate
desired_delivery_date
PromisedDeliveryDate
promised_delivery_date
TotalLineAmount
total_line_amount
TotalLineTaxAmount
total_line_tax_amount
TotalAdjustmentAmount
total_adjustment_amount
TotalAdjustmentTaxAmount
total_adjustment_tax_amount
TotalAmount
total_Amount
TotalTaxAmount
total_tax_amount
GrandTotalAmount
grand_total_amount
CreatedById
created_by_id
CreatedDate
created_at
LastModifiedById
updated_by_id
LastModifiedDate
updated_at
Daasity: shop_id
__shop_id
Daasity: account_id
_account_id
Daasity: MD5(id + __shop_id)
__sync_key
Daasity: timestamp when loaded into DB
__synced_at
Order Delivery Group Custom Attribute Values
Endpoint: SOM Order Delivery Group Summary
Update Method: UPSERT
Table Name: [
salesforce_commerce.order_delivery_group_custom_attribute_values]
id
order_delivery_group_summary_id
key
custom_attribute_key
value
custom_attribute_Value
Daasity: shop_id
__shop_id
Daasity: account_id
_account_id
Daasity: MD5(id +key + __shop_id)
__sync_key
Daasity: timestamp when loaded into DB
__synced_at
Order Delivery Methods
Endpoint: SOM Order Delivery Method
Update Method: UPSERT
Table Name: [
salesforce_commerce.order_delivery_methods]
Id
order_delivery_method_id
OwnerId
owner_id
IsDeleted
is_deleted
Name
name
Description
description
CurrencyIsoCode
currency_iso_code
ProductId
product_id
ReferenceNumber
reference_number
Carrier
carrier
ClassOfService
class_of_Service
IsActive
is_active
CreatedById
created_by_id
CreatedDate
created_at
LastModifiedById
updated_by_id
LastModifiedDate
updated_at
LastViewedDate
last_viewed_date
LastReferencedDate
last_referenced_date
Daasity: shop_id
__shop_id
Daasity: account_id
_account_id
Daasity: MD5(id + __shop_id)
__sync_key
Daasity: timestamp when loaded into DB
__synced_at
Order Item Summaries
Endpoint: SOM Order Item Summary
Update Method: UPSERT
Table Name: [
salesforce_commerce.order_item_summaries]
Id
order_item_summary_id
IsDeleted
is_deleted
Name
name
Description
description
CurrencyIsoCode
currency_iso_Code
OrderSummaryId
order_summary_id
OriginalOrderItemId
original_order_item_id
OrderDeliveryGroupSummaryId
order_delivery_group_summary_id
Status
status
Product2Id
product_2_id
ProductCode
product_code
LineNumber
line_number
Type
type
TypeCode
type_code
Quantity
quantity
QuantityAllocated
quantity_allocated
QuantityCanceled
quantity_canceled
QuantityOrdered
quantity_ordered
QuantityFulfilled
quantity_fulfilled
QuantityReturned
quantity_returned
QuantityReturnInitiated
quantity_return_initiated
QuantityNetOrdered
quantity_net_ordered
QuantityAvailableToCancel
quantity_available_to_cancel
QuantityAvailableToReturn
quantity_available_to_return
QuantityAvailableToFulfill
quantity_available_to_fulfill
ListPrice
list_price
UnitPrice
unit_price
TotalPrice
total_price
AdjustedLineAmount
adjusted_line_amount
TotalAdjustedLineTaxAmount
total_adjusted_line_tax_Amount
TotalTaxAmount
total_tax_amount
TotalAdjustmentAmount
total_adjustment_amount
TotalAdjustmentTaxAmount
total_adjustment_tax_amount
TotalLineAmount
total_line_amount
TotalLineTaxAmount
total_line_tax_amount
TotalLineAdjustmentAmount
total_line_adjustment_amount
TotalLineAdjustmentTaxAmount
total_line_adjustment_tax_amount
TotalAdjustmentDistAmount
total_adjustment_dist_amount
TotalAdjustmentDistTaxAmount
total_adjustment_dist_tax_amount
ServiceDate
service_date
EndDate
end_Date
CreatedById
created_by_id
CreatedDate
created_at
LastModifiedById
updated_by_id
LastModifiedDate
updated_at
Daasity: shop_id
__shop_id
Daasity: account_id
_account_id
Daasity: MD5(id + __shop_id)
__sync_key
Daasity: timestamp when loaded into DB
__synced_at
Order Item Summary Custom Attribute Values
Endpoint: SOM Order Item Summary
Update Method: UPSERT
Table Name: [
salesforce_commerce.order_item_summary_custom_attribute_values]
id
order_item_summary_id
key
custom_attribute_key
value
custom_attribute_value
Daasity: shop_id
__shop_id
Daasity: account_id
_account_id
Daasity: MD5(id + key + __shop_id)
__sync_key
Daasity: timestamp when loaded into DB
__synced_at
Order Item Adjustment Line Summaries
Endpoint: SOM Order Item Adjustment Line Summary
Update Method: UPSERT
Table Name: [
salesforce_commerce.order_item_adjustment_line_summaries]
Id
order_item_adjustment_line_summary
IsDeleted
is_deleted
Name
name
Description
description
CurrencyIsoCode
currency_iso_code
OrderItemSummaryId
order_item_summary_id
OriginalItemSummaryId
original_item_summary_id
OriginalOrderItemAdjustmentLineItemId
original_order_item_adjustment_line_item_id
OrderAdjustmentGroupSummaryId
order_adjustment_group_summary_id
OrderSummaryId
order_summary_id
TotalTaxAmount
total_tax_amount
Amount
amount
CreatedById
created_by_id
CreatedDate
created_at
LastModifiedById
updated_by_id
LastModifiedDate
updated_at
Daasity: shop_id
__shop_id
Daasity: account_id
_account_id
Daasity: MD5(id + __shop_id)
__sync_key
Daasity: timestamp when loaded into DB
__synced_at
Order Item Tax Line Summaries
Endpoint: SOM Order Item Tax Line Summary
Update Method: UPSERT
Table Name: [
salesforce_commerce.order_item_tax_line_summaries]
Id
order_item_tax_line_summary_id
IsDeleted
is_deleted
Name
Name
Description
description
CurrencyIsoCode
currency_iso_code
OrderSummaryId
order_summary_id
OrderItemSummaryId
order_item_summary_id
OriginalOrderItemTaxLineItemId
original_order_item_tax_line_item_id
Type
type
Rate
rate
Amount
amount
TaxEffectiveDate
tax_effective_date
CreatedById
created_by_id
CreatedDate
created_at
LastModifiedById
updated_by_id
LastModifiedDate
updated_at
Daasity: shop_id
__shop_id
Daasity: account_id
_account_id
Daasity: MD5(id + __shop_id)
__sync_key
Daasity: timestamp when loaded into DB
__synced_at
Order Payment Summaries
Endpoint: SOM Order Payment Summary
Update Method: UPSERT
Table Name: [
salesforce_commerce.order_payment_summaries]
Id
order_payment_summary_id
OwnerId
owner_id
IsDeleted
is_deleted
Method
method
CurrencyIsoCode
currency_iso_code
OrderSummaryId
order_summary_id
PaymentMethodId
payment_method_id
LastPaymentGatewayLogId
last_payment_gateway_log_id
LastPaymentGatewayMessage
last_payment_gateway_message
FullName
full_name
Type
type
AuthorizationReversalAmount
authorization_reversal_amount
AuthorizationAmount
authorization_amount
CapturedAmount
captured_amount
BalanceAmount
balance_amount
PendingAuthorizationAmount
pending_authorization_amount
PendingReverseAuthAmount
pending_reverse_auth_amount
PendingCaptureAmount
pending_capture_amount
PendingRefundAmount
pending_refund_amount
RefundedAmount
refunded_amount
AvailableToRefundAmount
available_to_refund_amount
AvailableToCaptureAmount
available_to_capture_amount
CreatedById
created_by_id
CreatedDate
created_at
LastModifiedById
updated_by_id
LastModifiedDate
updated_at
Daasity: shop_id
__shop_id
Daasity: account_id
_account_id
Daasity: MD5(id + __shop_id)
__sync_key
Daasity: timestamp when loaded into DB
__synced_at
Order Summaries
Endpoint: SOM Order Summary
Update Method: UPSERT
Table Name: [
salesforce_commerce.order_summaries]
Id
order_summary_id
OwnerId
owner_id
IsDeleted
is_deleted
OrderNumber
order_number
CurrencyIsoCode
currency_iso_code
OriginalOrderId
original_order_id
AccountId
account_id
ChangeOrderId
change_order_id
TotalAmount
total_amount
GrandTotalAmount
grand_total_amount
TotalAdjDistAmount
total_adj_dist_amount
TotalAdjDistTaxAmount
total_adj_dist_tax_amount
BillingStreet
billing_street
BillingCity
billing_city
BillingState
billing_state
BillingPostalCode
billing_postal_code
BillingCountry
billing_country
BillingLatitude
billing_latitude
BillingLongitude
billing_longitude
BillingGeocodeAccuracy
billing_geocode_accuracy
BillingEmailAddress
billing_email_Address
BillingPhoneNumber
billing_phone_number
OrderedDate
order_date
TotalTaxAmount
total_tax_amount
Status
status
Description
description
SalesChannelId
sales_channel_id
PoNumber
po_number
TotalAdjustedProductAmount
total_adjusted_product_amount
TotalAdjustedDeliveryAmount
total_adjusted_delivery_amount
TotalProductAdjDistAmount
total_product_adj_dist_amount
TotalDeliveryAdjDistAmount
total_delivery_adj_dist_amount
TotalAdjustedProductTaxAmount
total_adjusted_product_tax_amount
TotalAdjustedDeliveryTaxAmount
total_adjusted_delivery_tax_amount
TotalProductAdjDistTaxAmount
total_product_adj_dist_tax_amount
TotalDeliveryAdjDistTaxAmount
total_delivery_adj_dist_tax_amount
CreatedById
created_by_id
CreatedDate
created_at
LastModifiedById
updated_by_id
LastModifiedDate
updated_at
LastViewedDate
last_viewed_date
LastReferencedDate
last_referenced_date
Daasity: shop_id
__shop_id
Daasity: account_id
_account_id
Daasity: MD5(id + __shop_id)
__sync_key
Daasity: timestamp when loaded into DB
__synced_at
Order Summary Custom Attribute Values
Endpoint: SOM Order Summary
Update Method: UPSERT
Table Name: [
salesforce_commerce.order_summary_custom_attribute_values]
id
order_summary_id
key
custom_attribute_key
value
custom_attribute_value
Daasity: shop_id
__shop_id
Daasity: account_id
_account_id
Daasity: MD5(id + key + __shop_id)
__sync_key
Daasity: timestamp when loaded into DB
__synced_at
Sales Channels
Endpoint: SOM Sales Channels
Update Method: UPSERT
Table Name: [
salesforce_commerce.sales_channels]
Id
sales_channel_id
OwnerId
owner_id
IsDeleted
is_deleted
SalesChannelName
sales_channel_name
CurrencyIsoCode
currency_iso_code
ExternalChannelNumber
external_channel_number
Description
description
CreatedById
created_by_id
CreatedDate
created_at
LastModifiedById
updated_by_id
LastModifiedDate
updated_at
LastViewedDate
last_viewed_date
LastReferencedDate
last_referenced_date
Daasity: shop_id
__shop_id
Daasity: account_id
_account_id
Daasity: MD5(id + __shop_id)
__sync_key
Daasity: timestamp when loaded into DB
__synced_at
Last updated