Consumer Goods Cloud Data Model Objects

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 required DMO attributes.

Data Lake Object Mappings for Retail Execution Base:

DLO Name DLO Attribute DMO Name DMO Attribute
Account Employees Account Employee Count
Account Account Name Account Account Name
Account Industry Account Primary Industry
Account Created Date Account Created Date
Account Account Number Account Account Number
Account Photo URL Account Profile Image URL
Account Account Source Account Account Source
Account Last Modified Date Account Last Modified Date
Account Account Type Account Account Type
Account Account Description Account Account Description
Account Last Activity Account Last Activity Date
Account Annual Revenue Account Annual Revenue Amount
Account Website Account Website
Account Account Phone Account Sales Phone
Account Account Fax Account Fax Phone
Account Account ID Account Account Id
Account Last Modified By ID Account Last Modified By
Account Parent Account ID Account Relationship Account
Account Account ID Account Relationship Related Account
Account Account ID Account Relationship Account Relationship Id
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
Address Longitude Address Longitude
Address Country Address Country Name
Address Address Address Address Line 1
Address Zip/Postal Code Address Postal Code
Address Address Type Address Address Type
Address Address ID Address Address Id
Address Latitude Address Latitude
Address State/Province Address State Province Name
Address City Address City Name
AssessmentIndicatorDefinition Description Assessment Indicator Definition Description
AssessmentIndicatorDefinition Indicator Field Type Assessment Indicator Definition Indicator Data Type
AssessmentIndicatorDefinition Assessment Indicator Definition ID Assessment Indicator Definition Assessment Indicator Definition Id
AssessmentIndicatorDefinition Name Assessment Indicator Definition Name
AssessmentTask End Time Assessment Task Completion DateTime
AssessmentTask Status Assessment Task Task Status
AssessmentTask Name Assessment Task Name
AssessmentTask Assessment Task ID Assessment Task Assessment Task Id
AssessmentTask Sequence Assessment Task Sequence Number
AssessmentTask Task Type Assessment Task Task Type
AssessmentTask Description Assessment Task Description
AssessmentTask Assessment Task Definition ID Assessment Task Assessment Task Definition
AssessmentTask Visit ID Assessment Task Related To Item
AssessmentTask Start Time Assessment Task Start Date Time
AssessmentTask Is Required Boolean Value Assessment Task Mandatory
AssessmentTaskDefinition Assessment Task Definition Description Assessment Task Definition Description
AssessmentTaskDefinition Assessment Task Definition Task Type Assessment Task Definition Category
AssessmentTaskDefinition Assessment Task Definition ID Assessment Task Definition Assessment Task Definition Id
AssessmentTaskIndDefinition Assessment Task Indicator Definition ID Assessment Task Indicator Definition Assessment Task Indicator Definition Id
AssessmentTaskIndDefinition Assessment Task Definition ID Assessment Task Indicator Definition Assessment Task Definition
AssessmentTaskIndDefinition Assessment Indicator Definition ID Assessment Task Indicator Definition Assessment Indicator Definition
AssessmentTaskIndDefinition Name Assessment Task Indicator Definition Name
AssessmentTaskOrder Retail Store ID Assessment Task Order Retail Store
AssessmentTaskOrder Order ID Assessment Task Order Sales Order
AssessmentTaskOrder Assessment Task Order ID Assessment Task Order Assessment Task Purchase Order
AssessmentTaskOrder Name Assessment Task Order Name
AssessmentTaskOrder Assessment Task ID Assessment Task Order Assessment Task
Assortment Description Assortment Description
Assortment Assortment ID Assortment Assortment Id
Assortment Name Assortment Name
AssortmentProduct Assortment ID Assortment Product Assortment
AssortmentProduct Assortment Product ID Assortment Product Assortment Product Id
AssortmentProduct Product ID Assortment Product Product
InStoreLocation In-store Location Type In Store Location Type
InStoreLocation In-store Location ID In Store Location In Store Location Id
InStoreLocation Retail Store ID In Store Location Retail Store
InStoreLocation Name In Store Location Name
InStoreLocation Category In Store Location Category
InStoreLocation Description In Store Location Description
InStoreLocation Image ID In Store Location Planogram
InStoreLocation Location ID In Store Location Location
Location Inventory Location Location Is Inventory Location
Location Parent Location ID Location Parent Location ID
Location Location Name Location Name
Location Longitude Location Longitude
Location Remodel End Date Location Remodel End Date
Location Root Location ID Location Root Location
Location Location ID Location Location ID
Location Construction End Date Location Construction End Date
Location Time Zone Location Time Zone
Location Latitude Location Latitude
Location System Modstamp Location System Modified Stamp
Location Possession Date Location Possession Date
Location Construction Start Date Location Construction Start Date
Location Open Date Location Open Date
Location Close Date Location Close Date
Location Created Date Location Created Date
Location Remodel Start Date Location Remodel Start Date
Location Last Modified By ID Location Last Modified By
Location Last Modified Date Location Last Modified Date
Location Created By ID Location Created By
Location Description Location Description
Location Location Type Location Location Type
Location Mobile Location Location Is Mobile Location
Location Owner ID Location Owner
Order Last Modified Date Sales Order Last Modified Date
Order Order ID Sales Order Sales Order Id
Order Activated By ID Sales Order Activated By User
Order Order Type Sales Order Sales Order Type
Order Owner ID Sales Order Owner User Id
Order Order Number Sales Order Order Number
Order Created Date Sales Order Created Date
Order Status Sales Order Sales Order Status
Order Order End Date Sales Order Order End Date
Order Company Authorized By ID Sales Order CompanyAuthorizedBy
Order Customer Authorized By ID Sales Order CustomerAuthorizedBy
Order Description Sales Order Description
Order Account ID Sales Order Sold To Customer
Order Order Start Date Sales Order Order Start Date
Order Order Name Sales Order Name
Order Contract ID Sales Order Contract
Order Order Amount Sales Order Total Amount
Order Ship To Contact ID Sales Order Ship To Contact
Order_Billing_Address_dlo Address_Id Contact Point Address Contact Point Address Id
Order_Billing_Address_dlo BillingCity Contact Point Address City
Order_Billing_Address_dlo BillingLatitude Contact Point Address Geo Latitude
Order_Billing_Address_dlo BillingLongitude Contact Point Address Geo Longitude
Order_Billing_Address_dlo BillingCountry Contact Point Address Country
Order_Billing_Address_dlo BillingState Contact Point Address State Province
Order_Billing_Address_dlo BillingStreet Contact Point Address Address Line 1
Order_Billing_Address_dlo BillingPostalCode Contact Point Address Postal Code
Order_Shipping_Address_dlo ShippingState Contact Point Address State Province
Order_Shipping_Address_dlo ShippingCity Contact Point Address City
Order_Shipping_Address_dlo ShippingLongitude Contact Point Address Geo Longitude
Order_Shipping_Address_dlo ShippingPostalCode Contact Point Address Postal Code
Order_Shipping_Address_dlo ShippingStreet Contact Point Address Address Line 1
Order_Shipping_Address_dlo Address_Id Contact Point Address Contact Point Address Id
Order_Shipping_Address_dlo ShippingCountry Contact Point Address Country
Order_Shipping_Address_dlo ShippingLatitude Contact Point Address Geo Latitude
OrderItem List Price Sales Order Product List Price Amount
OrderItem Last Modified Date Sales Order Product Last Modified Date
OrderItem Unit Price Sales Order Product Unit Price Amount
OrderItem Order Product ID Sales Order Product Sales Order Product
OrderItem Total Price Sales Order Product Total Price Amount
OrderItem Quantity Sales Order Product Ordered Quantity
OrderItem Price Book Entry ID Sales Order Product Pricebook Entry
OrderItem Available Quantity Sales Order Product Available Quantity
OrderItem Order ID Sales Order Product Sales Order
OrderItem Line Description Sales Order Product Description
OrderItem End Date Sales Order Product Requested End Date
OrderItem Product ID Sales Order Product Product
OrderItem Created Date Sales Order Product Created Date
OrderItem Order Product Number Sales Order Product Order Product Number
OrderItem Original Order Item ID Sales Order Product Original Order Product
Product2 Product Name Product Product Name
Product2 Product Description Product Product Description
Product2 Active Product Product Status
Product2 Product SKU Product Product SKU
Product2 Product ID Product Product Id
Product2 Product Family Product Product Family
Product2 Quantity Unit of Measure Product Quantity Unit Of Measure
Product2 Product ID Product Related Component Product Related Component Id
Product2 Product ID Product Related Product Product Related Product Id
ProductCategory Show In Menu Product Category Is Navigational
ProductCategory Last Modified Date Product Category Last Modified Date
ProductCategory Category ID Product Category Product Category Id
ProductCategory Created Date Product Category Created Date
ProductCategory Description Product Category Description
ProductCategory Catalog ID Product Category Product Catalog
ProductCategory Name Product Category Category Name
Promotion Created Date Promotion Created Date
Promotion Method Promotion Promotion Method
Promotion Owner ID Promotion Owner
Promotion Objective Promotion Objective
Promotion Description Promotion Description
Promotion Start Date Promotion Start Date
Promotion End Date Promotion End Date
Promotion Last Modified Date Promotion Last Modified Date
Promotion Name Promotion Name
Promotion Active Promotion Is Active
Promotion Category Promotion Promotion Class
Promotion Promotion ID Promotion Promotion Id
RetailLocationGroup Retail Store Group ID Retail Store Group Retail Store Group Id
RetailLocationGroup Name Retail Store Group Name
RetailStore Recommended Visit Frequency Retail Store Recommended Visit Frequency
RetailStore Delivery Frequency Retail Store Delivery Frequency
RetailStore Operating Hour ID Retail Store Preferred Visit Hours
RetailStore Retail Store ID Retail Store Retail Store Id
RetailStore Priority Retail Store Priority
RetailStore Contact ID Retail Store Primary Contact
RetailStore Payment Method Retail Store Payment Method
RetailStore Description Retail Store Description
RetailStore Account ID Retail Store Account
RetailStore Delivery Method Retail Store Delivery Method
RetailStore Retail Store Group ID Retail Store Retail Location Group
RetailStore Delivery Frequency Type Retail Store Delivery Frequency Type
RetailStore Recommended Visit Frequency Type Retail Store Recommended Visit Frequency Type
RetailStore Store Type Retail Store Retail Store Type
RetailStore Name Retail Store Name
RetailVisitKpi Custom Context Record Name Retail Visit KPI Source Context Object Record
RetailVisitKpi Custom Context ID Retail Visit KPI Source Context Object
RetailVisitKpi Primary Display Order Retail Visit KPI Display Order
RetailVisitKpi Unit of Measure Retail Visit KPI Unit Of Measure
RetailVisitKpi Name Retail Visit KPI Name
RetailVisitKpi Category ID Retail Visit KPI Product Category
RetailVisitKpi In-store Location ID Retail Visit KPI In Store Location
RetailVisitKpi Visit ID Retail Visit KPI Visit
RetailVisitKpi Image ID Retail Visit KPI Planogram
RetailVisitKpi Promotion ID Retail Visit KPI Promotion
RetailVisitKpi Assessment Indicator Definition ID Retail Visit KPI Assessment Indicator Definition
RetailVisitKpi Retail Visit KPI ID Retail Visit KPI Retail Visit KPI Id
RetailVisitKpi Product ID Retail Visit KPI Product
RetailVisitKpi Assessment Task ID Retail Visit KPI Assessment Task
RetailVisitKpi Target Value Data Type Retail Visit KPI Target Value Data Type
RetailVisitKpi Target Value Retail Visit KPI Target Value
RetailVisitKpi Actual Value Retail Visit KPI Actual Value
RetailVisitKpi Actual Value Data Type Retail Visit KPI Actual Value Data Type
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
StoreAssortment Retail Store Id Assortment Assignment Retail Store
StoreAssortment Retail Store Group Id Assortment Assignment Retail Store Group
StoreProduct Retail Store ID Retail Store Product Retail Store
StoreProduct Store Product ID Retail Store Product Retail Store Product Id
StoreProduct Name Retail Store Product Name
StoreProduct Account ID Retail Store Product Account
StoreProduct Default Order Quantity Retail Store Product Default Product Quantity
StoreProduct Product ID Retail Store Product Product
StoreProduct In-store Location ID Retail Store Product In Store Location
StoreProduct Start Date Only Retail Store Product Start Date
StoreProduct End Date Only Retail Store Product End Date
StoreProduct Is Favorite Boolean Value Retail Store Product Top Selling Product
Visit Last Modified Date Location Last Modified Date
Visit Name Location Name
Visit Created Date Location Created Date
Visit Location ID Location Location Id
Visit Status Visit Status
Visit Account ID Visit Account
Visit Actual Start Time Visit Actual Visit Start Time
Visit Planned Start Time Visit Planned Visit Start Time
Visit Visit ID Visit Visit Id
Visit Name Visit Name
Visit Responsible Visit Status Reason
Visit Actual End Time Visit Actual Visit End Time
Visit Visit Priority Visit Priority
Visit Visitor ID Visit Visitor Record
Visit Visitor ID Visit Visitor Record Object
Visit Planned End Time Visit Planned Visit End Time
Visit Place ID Visit Place Record Object

Data Lake Object Mappings for Retail Execution Enhanced:

DLO Name DLO Attribute DMO Name DMO Attribute
Account Employees Account Employee Count
Account Annual Revenue Account Annual Revenue Amount
Account Last Modified By ID Account Last Modified By
Account Last Activity Account Last Activity Date
Account Name 2 Account Alternate Name
Account Last Modified Date Account Last Modified Date
Account External Id Account External Record Id
Account Sales Org Account Business Unit
Account Account Source Account Account Source
Account Account Type Account Account Type
Account Account Phone Account Sales Phone
Account Created Date Account Created Date
Account Email Account ContactPointEmailId
Account Account ID Account Account Id
Account Photo URL Account Profile Image URL
Account Industry Account Primary Industry
Account Account Description Account Account Description
Account Account Fax Account Fax Phone
Account Account Name Account Account Name
Account Account Number Account Account Number
Account Website Account Website
Account Account ID Account Relationship Account
Account Account ID Account Relationship Related Account
Account Account ID Account Relationship Account Relationship Id
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
Address Longitude Address Longitude
Address Country Address Country Name
Address Address Address Address Line 1
Address Zip/Postal Code Address Postal Code
Address Address Type Address Address Type
Address Address ID Address Address Id
Address Latitude Address Latitude
Address State/Province Address State Province Name
Address City Address City Name
AssessmentIndicatorDefinition Description Assessment Indicator Definition Description
AssessmentIndicatorDefinition Indicator Field Type Assessment Indicator Definition Indicator Data Type
AssessmentIndicatorDefinition Assessment Indicator Definition ID Assessment Indicator Definition Assessment Indicator Definition Id
AssessmentIndicatorDefinition Name Assessment Indicator Definition Name
AssessmentTask End Time Assessment Task Completion DateTime
AssessmentTask Status Assessment Task Task Status
AssessmentTask Name Assessment Task Name
AssessmentTask Assessment Task ID Assessment Task Assessment Task Id
AssessmentTask Sequence Assessment Task Sequence Number
AssessmentTask Task Type Assessment Task Task Type
AssessmentTask Description Assessment Task Description
AssessmentTask Assessment Task Definition ID Assessment Task Assessment Task Definition
AssessmentTask Visit ID Assessment Task Related To Item
AssessmentTask Start Time Assessment Task Start Date Time
AssessmentTask Is Required Boolean Value Assessment Task Mandatory
AssessmentTaskDefinition Assessment Task Definition Description Assessment Task Definition Description
AssessmentTaskDefinition Assessment Task Definition Task Type Assessment Task Definition Category
AssessmentTaskDefinition Assessment Task Definition ID Assessment Task Definition Assessment Task Definition Id
AssessmentTaskIndDefinition Assessment Task Indicator Definition ID Assessment Task Indicator Definition Assessment Task Indicator Definition Id
AssessmentTaskIndDefinition Assessment Task Definition ID Assessment Task Indicator Definition Assessment Task Definition
AssessmentTaskIndDefinition Assessment Indicator Definition ID Assessment Task Indicator Definition Assessment Indicator Definition
AssessmentTaskIndDefinition Name Assessment Task Indicator Definition Name
AssessmentTaskOrder Retail Store ID Assessment Task Order Retail Store
AssessmentTaskOrder Order ID Assessment Task Order Sales Order
AssessmentTaskOrder Assessment Task Order ID Assessment Task Order Assessment Task Purchase Order
AssessmentTaskOrder Name Assessment Task Order Name
AssessmentTaskOrder Assessment Task ID Assessment Task Order Assessment Task
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 Focus Product Type Assortment Product Focus Product Type
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 String Value 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 Priority Account Account Priority
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__Job_Definition_Template__c Sales Org Assessment Indicator Definition Business Unit
cgcloud__Job_Definition_Template__c Measure Type Assessment Indicator Definition Question Context Type
cgcloud__Job_Definition_Template__c Primary Survey Policy Assessment Indicator Definition Primary Survey Policy
cgcloud__Job_Definition_Template__c Target Value Column Assessment Indicator Definition Target Value
cgcloud__Job_Definition_Template__c Competitor Relevant Assessment Indicator Definition Is Competitor Relevant
cgcloud__Job_Definition_Template__c Product Reference Assessment Indicator Definition Has Product Reference
cgcloud__Job_Definition_Template__c Description Assessment Indicator Definition Question Description
cgcloud__Job_Definition_Template__c Job Definition Template Name Assessment Indicator Definition Assessment Indicator Definition Id
cgcloud__Job_Definition_Template__c Survey Identification Assessment Indicator Definition Survey Category
cgcloud__Job_Definition_Template__c Data Type Assessment Indicator Definition Indicator Data Type Name
cgcloud__Job_Definition_Template__c Activation Status Assessment Indicator Definition Activation Status
cgcloud__Job_Definition_List__c Description Assessment Task Definition Description
cgcloud__Job_Definition_List__c Record ID Assessment Task Definition Assessment Task Definition Id
cgcloud__Job_List__c Activity Assessment Task Assessment Task Definition
cgcloud__Job_List__c Record ID Assessment Task Assessment Task Id
cgcloud__Job_List__c Done Assessment Task Task Status
cgcloud__Job_List__c Description Assessment Task Description
cgcloud__Job_List__c Visit Assessment Task Related To Item
cgcloud__Job_List__c Job List Name Assessment Task Name
cgcloud__Job_List__c Visit Date Time Assessment Task Start Date Time
cgcloud_Job_DL_Job_Definition_Template_c Sort Assessment Task Indicator Definition Sequence Number
cgcloud_Job_DL_Job_Definition_Template_c Measure Type Assessment Task Indicator Definition Measure Level
cgcloud_Job_DL_Job_Definition_Template_c Record ID Assessment Task Indicator Definition Assessment Task Indicator Definition Id
cgcloud_Job_DL_Job_Definition_Template_c Question Name Assessment Task Indicator Definition Name
cgcloud_Job_DL_Job_Definition_Template_c Description Assessment Task Indicator Definition Description
cgcloud_Job_DL_Job_Definition_Template_c Job Definition Template Assessment Task Indicator Definition Assessment Indicator Definition
cgcloud_Job_DL_Job_Definition_Template_c Activity Assessment Task Indicator Definition Assessment Task Definition
cgcloud_Job_DL_Job_Definition_Template_c Mandatory Assessment Task Indicator Definition Is Mandatory
cgcloud_Job_DL_Job_Definition_Template_c Consider Score Boolean Value Assessment Task Indicator Definition Has Score
cgcloud_Job_DL_Job_Definition_Template_c Sales Org Assessment Task Indicator Definition Business Unit
cgcloud__Order__c Customer Order Id Sales Order External Record Id
cgcloud__Order__c Payer Sales Order Payer Account
cgcloud__Order__c Total Value/Gross Sales Order Total Amount
cgcloud__Order__c Gross Total Value Sales Order Grand Total Amount
cgcloud__Order__c Created Date Sales Order Created Date
cgcloud__Order__c Owner ID Sales Order Owner User Id
cgcloud__Order__c Order Name Sales Order Name
cgcloud__Order__c Paid Amount Sales Order Paid Amount
cgcloud__Order__c Wholesaler Sales Order Wholesaler Account
cgcloud__Order__c Order Id Sales Order Order Number
cgcloud__Order__c Customer Sales Order Sold To Customer
cgcloud__Order__c Order Date Sales Order Confirmation Date
cgcloud__Order__c Payment Reason Sales Order Payment Adjustment Reason
cgcloud__Order__c Record ID Sales Order Sales Order Id
cgcloud__Order__c Delivery Recipient Sales Order Ship To Account
cgcloud__Order__c Currency Sales Order Currency Code
cgcloud__Order__c Cancel Reason Sales Order Status Reason
cgcloud__Order__c Last Modified Date Sales Order Last Modified Date
cgcloud__Order__c Bill Recipient Customer Sales Order Bill To Account
cgcloud__Order__c Pricing Date Sales Order Price Date
cgcloud__Order__c Delivery Date Sales Order Planned Delivery 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__Order_Item__c Is Out Of Stock Sales Order Product Is Out Of Stock
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__Product_Hierarchy__c Parent Product Product Related Product Parent Product Id
cgcloud__Product_Hierarchy__c Valid From Product Related Product From Date
cgcloud__Product_Hierarchy__c Record ID Product Related Product Product Related Product Id
cgcloud__Product_Hierarchy__c Child Product Product Related Product Child Product Id
cgcloud__Product_Hierarchy__c Valid Thru Product Related Product To Date
cgcloud__Promotion_Store__c Promotion Store Name Promotion Account Name
cgcloud__Promotion_Store__c Promotion Promotion Account Promotion
cgcloud__Promotion_Store__c Store Promotion Account Account
cgcloud__Promotion_Store__c Record ID Promotion Account Promotion Account Id
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
InStoreLocation Location ID In Store Location Location
InStoreLocation Category In Store Location Category
InStoreLocation In-store Location Type In Store Location Type
InStoreLocation Image ID In Store Location Planogram
InStoreLocation Name In Store Location Name
InStoreLocation Retail Store ID In Store Location Retail Store
InStoreLocation Description In Store Location Description
InStoreLocation In-store Location ID In Store Location In Store Location Id
Location System Modstamp Location System Modified Stamp
Location Created By ID Location Created By
Location Remodel End Date Location Remodel End Date
Location Open Date Location Open Date
Location Close Date Location Close Date
Location Mobile Location Location Is Mobile Location
Location Location Type Location Location Type
Location Remodel Start Date Location Remodel Start Date
Location Last Modified By ID Location Last Modified By
Location Construction End Date Location Construction End Date
Location Inventory Location Location Is Inventory Location
Location Construction Start Date Location Construction Start Date
Location Created Date Location Created Date
Location Location ID Location Location Id
Location Location Name Location Name
Location Longitude Location Longitude
Location Owner ID Location Owner
Location Description Location Description
Location Possession Date Location Possession Date
Location Last Modified Date Location Last Modified Date
Location Parent Location ID Location Parent Location Id
Location Latitude Location Latitude
Location Time Zone Location Time Zone
Location Root Location ID Location Root Location
Order Last Modified Date Sales Order Last Modified Date
Order Order ID Sales Order Sales Order Id
Order Activated By ID Sales Order Activated By User
Order Order Type Sales Order Sales Order Type
Order Owner ID Sales Order Owner User Id
Order Order Number Sales Order Order Number
Order Created Date Sales Order Created Date
Order Status Sales Order Sales Order Status
Order Order End Date Sales Order Order End Date
Order Company Authorized By ID Sales Order CompanyAuthorizedBy
Order Customer Authorized By ID Sales Order CustomerAuthorizedBy
Order Description Sales Order Description
Order Account ID Sales Order Sold To Customer
Order Order Start Date Sales Order Order Start Date
Order Order Name Sales Order Name
Order Contract ID Sales Order Contract
Order Order Amount Sales Order Total Amount
Order Ship To Contact ID Sales Order Ship To Contact
Order_Billing_Address_dlo Address_Id Contact Point Address Contact Point Address Id
Order_Billing_Address_dlo BillingCity Contact Point Address City
Order_Billing_Address_dlo BillingLatitude Contact Point Address Geo Latitude
Order_Billing_Address_dlo BillingLongitude Contact Point Address Geo Longitude
Order_Billing_Address_dlo BillingCountry Contact Point Address Country
Order_Billing_Address_dlo BillingState Contact Point Address State Province
Order_Billing_Address_dlo BillingStreet Contact Point Address Address Line 1
Order_Billing_Address_dlo BillingPostalCode Contact Point Address Postal Code
Order_Shipping_Address_dlo ShippingState Contact Point Address State Province
Order_Shipping_Address_dlo ShippingCity Contact Point Address City
Order_Shipping_Address_dlo ShippingLongitude Contact Point Address Geo Longitude
Order_Shipping_Address_dlo ShippingPostalCode Contact Point Address Postal Code
Order_Shipping_Address_dlo ShippingStreet Contact Point Address Address Line 1
Order_Shipping_Address_dlo Address_Id Contact Point Address Contact Point Address Id
Order_Shipping_Address_dlo ShippingCountry Contact Point Address Country
Order_Shipping_Address_dlo ShippingLatitude Contact Point Address Geo Latitude
OrderItem List Price Sales Order Product List Price Amount
OrderItem Last Modified Date Sales Order Product Last Modified Date
OrderItem Unit Price Sales Order Product Unit Price Amount
OrderItem Order Product ID Sales Order Product Sales Order Product
OrderItem Total Price Sales Order Product Total Price Amount
OrderItem Quantity Sales Order Product Ordered Quantity
OrderItem Price Book Entry ID Sales Order Product Pricebook Entry
OrderItem Available Quantity Sales Order Product Available Quantity
OrderItem Order ID Sales Order Product Sales Order
OrderItem Line Description Sales Order Product Description
OrderItem End Date Sales Order Product Requested End Date
OrderItem Product ID Sales Order Product Product
OrderItem Created Date Sales Order Product Created Date
OrderItem Order Product Number Sales Order Product Order Product Number
OrderItem Original Order Item ID Sales Order Product Original Order Product
POS_POS_Template_dlo POS Template Name In Store Location Name
POS_POS_Template_dlo Record ID In Store Location In Store Location Id
POS_POS_Template_dlo POS Template POS Type In Store Location Type
POS_POS_Template_dlo POS Template Sales Org In Store Location Business Unit
POS_POS_Template_dlo Description In Store Location Description
POS_POS_Template_dlo Customer In Store Location Sales Store
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
ProductCategory Show In Menu Product Category Is Navigational
ProductCategory Last Modified Date Product Category Last Modified Date
ProductCategory Category ID Product Category Product Category Id
ProductCategory Created Date Product Category Created Date
ProductCategory Description Product Category Description
ProductCategory Catalog ID Product Category Product Catalog
ProductCategory Name Product Category Category Name
Promotion Method Promotion Promotion Method
Promotion Description Promotion Description
Promotion Start Date Promotion Start Date
Promotion Owner ID Promotion Owner
Promotion End Date Promotion End Date
Promotion Created Date Promotion Created Date
Promotion Name Promotion Name
Promotion Active Promotion Is Active
Promotion Category Promotion Promotion Class
Promotion Objective Promotion Objective
Promotion Promotion ID Promotion Promotion Id
Promotion Last Modified Date Promotion Last Modified Date
Promotion_Account_dlo Id Promotion Account Promotion Account Id
Promotion_Account_dlo Promotion Promotion Account Promotion
Promotion_Account_dlo Account Promotion Account Account
RetailLocationGroup Retail Store Group ID Retail Store Group Retail Store Group Id
RetailLocationGroup Name Retail Store Group Name
RetailStore Recommended Visit Frequency Retail Store Recommended Visit Frequency
RetailStore Delivery Frequency Retail Store Delivery Frequency
RetailStore Operating Hour ID Retail Store Preferred Visit Hours
RetailStore Retail Store ID Retail Store Retail Store Id
RetailStore Priority Retail Store Priority
RetailStore Contact ID Retail Store Primary Contact
RetailStore Payment Method Retail Store Payment Method
RetailStore Description Retail Store Description
RetailStore Account ID Retail Store Account
RetailStore Delivery Method Retail Store Delivery Method
RetailStore Retail Store Group ID Retail Store Retail Location Group
RetailStore Delivery Frequency Type Retail Store Delivery Frequency Type
RetailStore Recommended Visit Frequency Type Retail Store Recommended Visit Frequency Type
RetailStore Store Type Retail Store Retail Store Type
RetailStore Name Retail Store Name
RetailVisitKpi Promotion ID Retail Visit KPI Promotion
RetailVisitKpi Category ID Retail Visit KPI Product Category
RetailVisitKpi Assessment Task ID Retail Visit KPI Assessment Task
RetailVisitKpi Unit of Measure Retail Visit KPI Unit Of Measure
RetailVisitKpi Image ID Retail Visit KPI Planogram
RetailVisitKpi Visit ID Retail Visit KPI Visit
RetailVisitKpi Custom Context Record Name Retail Visit KPI Source Context Object
RetailVisitKpi Name Retail Visit KPI Name
RetailVisitKpi Custom Context ID Retail Visit KPI Source Context Object Record
RetailVisitKpi Retail Visit KPI ID Retail Visit KPI Retail Visit KPI Id
RetailVisitKpi In-store Location ID Retail Visit KPI In Store Location
RetailVisitKpi Primary Display Order Retail Visit KPI Display Order
RetailVisitKpi Product ID Retail Visit KPI Product
RetailVisitKpi Assessment Indicator Definition ID Retail Visit KPI Assessment Indicator Definition
RetailVisitKpi Actual Value Data Type Retail Visit KPI Actual Value Data Type
RetailVisitKpi Target Value Retail Visit KPI Target Value
RetailVisitKpi Target Value Data Type Retail Visit KPI Target Value Data Type
RetailVisitKpi Actual Value Retail Visit KPI Actual Value
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
StoreAssortment Retail Store Group ID Assortment Assignment Retail Store Group
StoreAssortment Retail Store ID Assortment Assignment Retail Store
StoreProduct Retail Store ID Retail Store Product Retail Store
StoreProduct Store Product ID Retail Store Product Retail Store Product Id
StoreProduct Name Retail Store Product Name
StoreProduct Account ID Retail Store Product Account
StoreProduct Default Order Quantity Retail Store Product Default Product Quantity
StoreProduct Product ID Retail Store Product Product
StoreProduct In-store Location ID Retail Store Product In Store Location
StoreProduct Start Date Only Retail Store Product Start Date
StoreProduct End Date Only Retail Store Product End Date
StoreProduct Is Favorite Boolean Value Retail Store Product Top Selling Product
Visit Last Modified Date Location Last Modified Date
Visit Location Status Location Location Status
Visit Geolocation (Longitude) Location Longitude
Visit Name Location Name
Visit Created Date Location Created Date
Visit Location ID Location Location Id
Visit Geolocation (Latitude) Location Latitude
Visit Subject Visit Purpose
Visit cgcloud Visit Planned DateTime Visit Planned Visit Date
Visit PSI Visit Perfect Store Index Score
Visit Status Visit Status
Visit Account ID Visit Account
Visit Distribution Rate All Visit Product Distribution Rate
Visit OoS Rate Focus Visit Out Of Stock Rate Focus Area
Visit Location Status Visit Location Status
Visit Actual Start Time Visit Actual Visit Start Time
Visit OoS Issue Visit Out Of Stock Issue Count
Visit Planned Start Time Visit Planned Visit Start Time
Visit Geolocation (Longitude) Visit Actual Visit Longitude
Visit Distribution Rate Focus Visit Product Distribution Rate Focus Area
Visit Duration In Minutes Visit Duration Unit of Measure
Visit Completed Date Visit Completion Date
Visit Visit ID Visit Visit Id
Visit Name Visit Name
Visit Status Remark Visit Status Reason
Visit Duration Effective Visit Duration
Visit PSQ Rate Visit Perfect Store Quotient
Visit Actual End Time Visit Actual Visit End Time
Visit Visit Priority Visit Priority
Visit Distribution Issue Visit Distribution Issue Count
Visit Geolocation (Latitude) Visit Actual Visit Latitude
Visit Visitor ID Visit Visitor Record
Visit Visitor ID Visit Visitor Record Object
Visit Planned End Time Visit Planned Visit End Time
Visit Place ID Visit Place Record Object
Visit Out Of Stock Issue Visit Out Of Stock Issue
Visit Has Distribution Issues Visit Has Distribution Issues
Visit All Day Visit Visit All Day Visit
Visit_Job_dlo Target Value Retail Visit KPI Target Value
Visit_Job_dlo Record ID Retail Visit KPI Retail Visit KPI Id
Visit_Job_dlo Number of Pictures Retail Visit KPI Uploaded Image Count
Visit_Job_dlo Actual Value Retail Visit KPI Actual Value
Visit_Job_dlo Product Retail Visit KPI Product
Visit_Job_dlo Promotion Retail Visit KPI Promotion
Visit_Job_dlo Manually Retail Visit KPI Manually Answered
Visit_Job_dlo Actual Value Data Type Retail Visit KPI Actual Value Data Type
Visit_Job_dlo Actual Value Data Type Retail Visit KPI Target Value Data Type
Visit_Job_dlo Job Definition Template Retail Visit KPI Assessment Indicator Definition
Visit_Job_dlo POS Retail Visit KPI In Store Location
Visit_Job_dlo Visit Retail Visit KPI Visit