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 | 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 |
Did this article solve your issue?
Let us know so we can improve!
