When you set up and Install the Consumer Goods Cloud Data Kit and deploy the data streams, you get access to data model objects (DMOs) as part of the SSOT package that’s automatically installed in your org.
Required Editions
| Available in: Lightning Experience in Enterprise and Unlimited Editions that have Consumer Goods Cloud enabled |
Your data is mapped to these DMO attributes.
| DLO Name | DLO Attribute | DMO Name | DMO Attribute |
|---|---|---|---|
| Account | Account Number | Account | Account Number |
| Account | Annual Revenue | Account | Annual Revenue Amount |
| Account | Website | Account | Website |
| Account | Account ID | Account | Account Id |
| Account | Account | ContactPointEmailId | |
| Account | Last Modified By ID | Account | Last Modified By |
| Account | Created Date | Account | Created Date |
| Account | Account Description | Account | Account Description |
| Account | Account Source | Account | Account Source |
| Account | Account Fax | Account | Fax Phone |
| Account | External Id | Account | External Record Id |
| Account | Employees | Account | Employee Count |
| Account | Last Modified Date | Account | Last Modified Date |
| Account | Photo URL | Account | Profile Image URL |
| Account | Account Type | Account | Account Type |
| Account | Last Activity | Account | Last Activity Date |
| Account | Name 2 | Account | Alternate Name |
| Account | Account Phone | Account | Sales Phone |
| Account | Account Name | Account | Account Name |
| Account | Industry | Account | Primary Industry |
| Account | Sales Org | Account | Business Unit |
| Account | Account ID | Account Relationship | Account Relationship Id |
| Account | Account ID | Account Relationship | Related Account |
| Account | Parent Account ID | Account Relationship | Account |
| Account_Billing_Address_dlo | BillingCity | Contact Point Address | City |
| Account_Billing_Address_dlo | BillingPostalCode | Contact Point Address | Postal Code |
| Account_Billing_Address_dlo | BillingLatitude | Contact Point Address | Geo Latitude |
| Account_Billing_Address_dlo | Address_Id | Contact Point Address | Contact Point Address Id |
| Account_Billing_Address_dlo | BillingStreet | Contact Point Address | Address Line 1 |
| Account_Billing_Address_dlo | BillingLongitude | Contact Point Address | Geo Longitude |
| Account_Billing_Address_dlo | BillingCountry | Contact Point Address | Country |
| Account_Billing_Address_dlo | BillingState | Contact Point Address | State Province |
| Account_Shipping_Address_dlo | ShippingLatitude | Contact Point Address | Geo Latitude |
| Account_Shipping_Address_dlo | ShippingPostalCode | Contact Point Address | Postal Code |
| Account_Shipping_Address_dlo | ShippingCountry | Contact Point Address | Country |
| Account_Shipping_Address_dlo | ShippingLongitude | Contact Point Address | Geo Longitude |
| Account_Shipping_Address_dlo | ShippingState | Contact Point Address | State Province |
| Account_Shipping_Address_dlo | Address_Id | Contact Point Address | Contact Point Address Id |
| Account_Shipping_Address_dlo | ShippingStreet | Contact Point Address | Address Line 1 |
| Account_Shipping_Address_dlo | ShippingCity | Contact Point Address | City |
| Assortment | Description | Assortment | Description |
| Assortment | Assortment ID | Assortment | Assortment Id |
| Assortment | Name | Assortment | Name |
| Assortment | Sales Org | Assortment | Business Unit |
| Assortment | Valid Thru | Assortment | Effective End Date |
| Assortment | Valid From | Assortment | Effective Start Date |
| Assortment | Is Obligatory | Assortment | Is Obligatory |
| AssortmentProduct | Valid Thru | Assortment Product | Effective End Date |
| AssortmentProduct | Distribution | Assortment Product | Product Distribution Status |
| AssortmentProduct | Facings | Assortment Product | Product Facing Value |
| AssortmentProduct | Valid From | Assortment Product | Effective Start Date |
| AssortmentProduct | Assortment ID | Assortment Product | Assortment |
| AssortmentProduct | Assortment Product ID | Assortment Product | Assortment Product Id |
| AssortmentProduct | Price | Assortment Product | Product Selling Price |
| AssortmentProduct | Product ID | Assortment Product | Product |
| AssortmentProduct | Active | Assortment Product | Active |
| Bill_To_Role_dlo | Effective Start Date | Account Role | Effective Start Date |
| Bill_To_Role_dlo | Account Role Id | Account Role | Account Role Id |
| Bill_To_Role_dlo | Effective End Date | Account Role | Effective End Date |
| Bill_To_Role_dlo | Account Role Type | Account Role | Account Role Type |
| Bill_To_Role_dlo | Account | Account Role | Account |
| Broker_Role_dlo | Effective Start Date | Account Role | Effective Start Date |
| Broker_Role_dlo | Account | Account Role | Account |
| Broker_Role_dlo | Effective End Date | Account Role | Effective End Date |
| Broker_Role_dlo | Account Role Type | Account Role | Account Role Type |
| Broker_Role_dlo | Account Role Id | Account Role | Account Role Id |
| cgcloud__Account_Extension__c | Class Of Trade | Account | Trade Classification Type |
| cgcloud__Account_Extension__c | Customer | Account | Account Id |
| cgcloud__Account_Extension__c | Sales Org | Account | Business Unit |
| cgcloud__Account_Extension__c | Payment Mode | Account | Auto Payment Method |
| cgcloud__Account_Extension__c | RBF Overdraw % | Account | Rate Based Funding Overdraw Percentage |
| cgcloud__Account_Extension__c | Last Visit Date | Account | Last Visit Date |
| cgcloud__Account_Extension__c | Last Modified Date | Account | Last Modified Date |
| cgcloud__Account_Extension__c | Created Date | Account | Created Date |
| cgcloud__Account_Extension__c | Payer Role Overall Credit Limit | Account | Credit Limit |
| cgcloud__Account_Extension__c | Fixed Overdraw % | Account | Fixed Funding Overdraw Percentage |
| cgcloud__Account_Extension__c | Tax Jurisdiction Code | Account | Tax Payment Jurisdiction Code |
| cgcloud__Account_Extension__c | Company Type | Account | Account Business Type |
| cgcloud__Account_Extension__c | Payer Role Credit Rating | Account | Credit Rating Type |
| cgcloud__Account_Extension__c | Credit Blocked | Account | Credit Blocked |
| cgcloud__Account_Relationship__c | Self Relationship String Value | Account Relationship | Self Relationship |
| cgcloud__Account_Relationship__c | Record ID | Account Relationship | Account Relationship Id |
| cgcloud__Account_Relationship__c | Related Customer | Account Relationship | Related Account |
| cgcloud__Account_Relationship__c | Customer | Account Relationship | Account |
| cgcloud__Account_Relationship__c | End Date | Account Relationship | Effective End Date |
| cgcloud__Account_Relationship__c | Start Date | Account Relationship | Effective Start Date |
| cgcloud__Account_Relationship__c | Relationship Type | Account Relationship | Account Relationship Role |
| cgcloud__Account_Relationship__c | Primary Relationship String Value | Account Relationship | Primary Relationship |
| cgcloud__Account_Trade_Org_Hierarchy__c | Child Customer | Account Relationship | Related Account |
| cgcloud__Account_Trade_Org_Hierarchy__c | Parent Customer | Account Relationship | Account |
| cgcloud__Account_Trade_Org_Hierarchy__c | Valid From | Account Relationship | Effective Start Date |
| cgcloud__Account_Trade_Org_Hierarchy__c | Record ID | Account Relationship | Account Relationship Id |
| cgcloud__Account_Trade_Org_Hierarchy__c | Valid Thru | Account Relationship | Effective End Date |
| cgcloud__Account_Trade_Org_Hierarchy__c | Parent Relationship Role | Account Relationship | Account Relationship Role |
| cgcloud__Order__c | Pricing Date | Sales Order | Price Date |
| cgcloud__Order__c | Bill Recipient Customer | Sales Order | Bill To Account |
| cgcloud__Order__c | Total Value/Gross | Sales Order | Total Amount |
| cgcloud__Order__c | Payment Reason | Sales Order | Payment Adjustment Reason |
| cgcloud__Order__c | Order Date | Sales Order | Confirmation Date |
| cgcloud__Order__c | Customer Order Id | Sales Order | External Record Id |
| cgcloud__Order__c | Customer | Sales Order | Sold To Customer |
| cgcloud__Order__c | Order Name | Sales Order | Name |
| cgcloud__Order__c | Currency | Sales Order | Currency Code |
| cgcloud__Order__c | Created Date | Sales Order | Create Date |
| cgcloud__Order__c | Record ID | Sales Order | Sales Order Id |
| cgcloud__Order__c | Payer | Sales Order | Payer Account |
| cgcloud__Order__c | Order Id | Sales Order | Order Number |
| cgcloud__Order__c | Paid Amount | Sales Order | Paid Amount |
| cgcloud__Order__c | Delivery Date | Sales Order | Planned Delivery Date |
| cgcloud__Order__c | Owner ID | Sales Order | Owner User Id |
| cgcloud__Order__c | Delivery Recipient | Sales Order | Ship To Account |
| cgcloud__Order__c | Gross Total Value | Sales Order | Grand Total Amount |
| cgcloud__Order__c | Wholesaler | Sales Order | Wholesaler Account |
| cgcloud__Order__c | Cancel Reason | Sales Order | Status Reason |
| cgcloud__Order__c | Last Modified Date | Sales Order | Last Modified Date |
| cgcloud__Order_Item__c | Suggested Quantity | Sales Order Product | Recommended Quantity |
| cgcloud__Order_Item__c | Value | Sales Order Product | Total Unit Price Amount |
| cgcloud__Order_Item__c | Record ID | Sales Order Product | Sales Order Product |
| cgcloud__Order_Item__c | Order | Sales Order Product | Sales Order |
| cgcloud__Order_Item__c | Quantity | Sales Order Product | Allocated Quantity |
| cgcloud__Order_Item__c | Promotion | Sales Order Product | Promotion |
| cgcloud__Order_Item__c | Order Item Name | Sales Order Product | Name |
| cgcloud__Order_Item__c | Special Price | Sales Order Product | Special Unit Price Amount |
| cgcloud__Order_Item__c | Discount | Sales Order Product | Discount Amount |
| cgcloud__Order_Item__c | Product | Sales Order Product | Product |
| cgcloud__Order_Item__c | Price | Sales Order Product | Unit Price Amount |
| cgcloud__Order_Item__c | Created Date | Sales Order Product | Created Date |
| cgcloud__Order_Item__c | Parent_Order_Item | Sales Order Product | Original Order Product |
| cgcloud__Order_Item__c | Base Price | Sales Order Product | List Price Amount |
| cgcloud__Order_Item__c | Promoted String Value | Sales Order Product | Promotional Product |
| cgcloud__Order_Item__c | Listed String Value | Sales Order Product | Listed Product |
| cgcloud__Order_Item__c | UoM | Sales Order Product | Allocated Quantity Unit of Measure |
| cgcloud__Order_Item__c | Parent Type | Sales Order Product | Bonus Product Reason Type |
| cgcloud__Order_Item__c | Consumer Quantity | Sales Order Product | Ordered Quantity |
| cgcloud__Order_Item__c | Last Modified Date | Sales Order Product | Last Modified Date |
| cgcloud__Product_Hierarchy__c | Valid Thru | Product Related Product | To Date |
| cgcloud__Product_Hierarchy__c | Record ID | Product Related Product | Product Related Product Id |
| cgcloud__Product_Hierarchy__c | Parent Product | Product Related Product | Parent Product Id |
| cgcloud__Product_Hierarchy__c | Child Product | Product Related Product | Child Product Id |
| cgcloud__Product_Hierarchy__c | Valid From | Product Related Product | From Date |
| cgcloud__Promotion__c | DateTime Thru | Promotion | End Date |
| cgcloud__Promotion__c | Comment | Promotion | Notes |
| cgcloud__Promotion__c | Parent Promotion | Promotion | Related Promotion |
| cgcloud__Promotion__c | In-Store Date From | Promotion | In Store Display Start Date |
| cgcloud__Promotion__c | Shipment Date From | Promotion | Shipment Start Date |
| cgcloud__Promotion__c | In-Store Date Thru | Promotion | In Store Display End Date |
| cgcloud__Promotion__c | Promotion Name | Promotion | Name |
| cgcloud__Promotion__c | Shipment Date Thru | Promotion | Shipment End Date |
| cgcloud__Promotion__c | Last Modified Date | Promotion | Last Modified Date |
| cgcloud__Promotion__c | Owner ID | Promotion | Owner |
| cgcloud__Promotion__c | Created Date | Promotion | Created Date |
| cgcloud__Promotion__c | External Id | Promotion | External Record Id |
| cgcloud__Promotion__c | Sales Org | Promotion | Business Unit |
| cgcloud__Promotion__c | Last Modified By ID | Promotion | Last Modified By |
| cgcloud__Promotion__c | DateTime From | Promotion | Start Date |
| cgcloud__Promotion__c | Record ID | Promotion | Promotion Id |
| cgcloud__Promotion__c | Phase | Promotion | Promotion Status |
| cgcloud__Promotion__c | Slogan | Promotion | Promotional Message |
| cgcloud__Promotion__c | Record ID | Promotion Account | Promotion Account Id |
| cgcloud__Promotion__c | Record ID | Promotion Account | Promotion |
| cgcloud__Promotion__c | Anchor Customer | Promotion Account | Account |
| cgcloud__Promotion__c | Record ID | Promotion Product | Promotion Product Id |
| cgcloud__Promotion__c | Record ID | Promotion Product | Promotion |
| cgcloud__Promotion__c | Effective Brands | Promotion Product | Product |
| cgcloud__Promotion__c | Record ID | Promotion Product Category | Promotion Product Category Id |
| cgcloud__Promotion__c | Record ID | Promotion Product Category | Promotion |
| cgcloud__Promotion__c | Effective Categories | Promotion Product Category | Product Category |
| cgcloud__Tactic__c | Sales Org | Promotion Offer | Business Unit |
| cgcloud__Tactic__c | Deleted | Promotion Offer | Deleted |
| cgcloud__Tactic__c | Shipment Date From | Promotion Offer | Shipment Start Date |
| cgcloud__Tactic__c | Record ID | Promotion Offer | Promotion Offer Id |
| cgcloud__Tactic__c | Shipment Date Thru | Promotion Offer | Shipment End Date |
| cgcloud__Tactic__c | Promotion | Promotion Offer | Promotion |
| cgcloud__Tactic__c | In-Store Date From | Promotion Offer | In Store Display Start Date |
| cgcloud__Tactic__c | Date Thru | Promotion Offer | Effective End Date |
| cgcloud__Tactic__c | Tactic Name | Promotion Offer | Name |
| cgcloud__Tactic__c | Comment | Promotion Offer | Description |
| cgcloud__Tactic__c | In-Store Date Thru | Promotion Offer | In Store Display End Date |
| cgcloud__Tactic__c | Date From | Promotion Offer | Effective Start Date |
| cgcloud__Tactic_Product__c | Deleted | Promotion Offer Product | Deleted |
| cgcloud__Tactic_Product__c | Promoted Price | Promotion Offer Product | Discount |
| cgcloud__Tactic_Product__c | Quantity | Promotion Offer Product | Product Quantity |
| cgcloud__Tactic_Product__c | Sales Org | Promotion Offer Product | Business Unit |
| cgcloud__Tactic_Product__c | Record ID | Promotion Offer Product | Promotion Offer Product Id |
| cgcloud__Tactic_Product__c | Tactic | Promotion Offer Product | Promotion Offer |
| cgcloud__Tactic_Product__c | Product Name | Promotion Offer Product | Name |
| cgcloud__Tactic_Product__c | Product | Promotion Offer Product | Product |
| cgcloud__Tactic_Product__c | Description 1 | Promotion Offer Product | Description |
| cgcloud__Tactic_Product__c | Status | Promotion Offer Product | Status |
| Customer_Role_dlo | Effective Start Date | Account Role | Effective Start Date |
| Customer_Role_dlo | Effective End Date | Account Role | Effective End Date |
| Customer_Role_dlo | Account | Account Role | Account |
| Customer_Role_dlo | Account Role Id | Account Role | Account Role Id |
| Customer_Role_dlo | Account Role Type | Account Role | Account Role Type |
| Delivery_Role_dlo | Effective End Date | Account Role | Effective End Date |
| Delivery_Role_dlo | Account | Account Role | Account |
| Delivery_Role_dlo | Account Role Id | Account Role | Account Role Id |
| Delivery_Role_dlo | Account Role Type | Account Role | Account Role Type |
| Delivery_Role_dlo | Effective Start Date | Account Role | Effective Start Date |
| Fund_Role_dlo | Effective End Date | Account Role | Effective End Date |
| Fund_Role_dlo | Account Role Id | Account Role | Account Role Id |
| Fund_Role_dlo | Effective Start Date | Account Role | Effective Start Date |
| Fund_Role_dlo | Account Role Type | Account Role | Account Role Type |
| Fund_Role_dlo | Account | Account Role | Account |
| Product2 | Product Name | Product | Product Name |
| Product2 | Product Description | Product | Product Description |
| Product2 | Container Size Unit | Product | Container Size UOM |
| Product2 | Container Type | Product | Container Type |
| Product2 | Brand | Product | Brand |
| Product2 | Product Form | Product | Form Type |
| Product2 | Pack Size | Product | Package Product Quantity |
| Product2 | Active | Product | Product Status |
| Product2 | Sell Out Code | Product | Sell Out Code |
| Product2 | Sales Org | Product | Business Unit |
| Product2 | Product Short Code | Product | Short Code |
| Product2 | Container Size | Product | Container Size |
| Product2 | Pack Size Unit | Product | Package Type |
| Product2 | Sell In Code | Product | Sell In Code |
| Product2 | Product SKU | Product | Product SKU |
| Product2 | Consumer Goods Product Code | Product | Product Code |
| Product2 | Product ID | Product | Product Id |
| Product2 | Category | Product | Primary Product Category |
| Product2 | Consumer Goods External Product ID | Product | External Source Record Id |
| Product2 | Product Family | Product | Product Family |
| Product2 | Weight | Product | Weight UOM |
| Product2 | Quantity Unit of Measure | Product | Quantity Unit Of Measure |
| Product2 | Tax Classification | Product | Tax Class |
| Product2 | Product Type | Product | Product Type |
| Product2 | Competitor’s Product String Value | Product | Competitive Product |
| Product2 | UPC | Product | Universal Product Code |
| Product2 | BOM Material Id | Product Related Component | Parent Product Code |
| Product2 | Product ID | Product Related Component | Product Related Component Id |
| Product2 | Product ID | Product Related Product | Product Related Product Id |
| Product2 | Product Level | Product Related Product | Product Relationship Type |
| Product2 | Container Size | Product | Container Size |
| Promotion_Account_dlo | Id | Promotion Account | Promotion Account Id |
| Promotion_Account_dlo | Promotion | Promotion Account | Promotion |
| Promotion_Account_dlo | Account | Promotion Account | Account |
| Store_Role_dlo | Account Role Id | Account Role | Account Role Id |
| Store_Role_dlo | Account | Account Role | Account |
| Store_Role_dlo | Account Role Type | Account Role | Account Role Type |
| Store_Role_dlo | Effective Start Date | Account Role | Effective Start Date |
| Store_Role_dlo | Effective End Date | Account Role | Effective End Date |
| StoreAssortment | Account ID | Assortment Assignment | Account |
| StoreAssortment | Store Assortment ID | Assortment Assignment | Assortment Assignment Id |
| StoreAssortment | Assortment ID | Assortment Assignment | Assortment |
| StoreAssortment | Name | Assortment Assignment | Name |
| StoreAssortment | Effective Start Date | Assortment Assignment | Start Date |
| StoreAssortment | Effective End Date | Assortment Assignment | End Date |