Power BI Connector for Vault CRM

Build 25.0.9454

OrderCampaigns

Links promotional campaigns with order-related activities.

Columns

Name Type ReadOnly Description
ID [KEY] String True

A unique identifier for the order campaign, used to reference and manage the specific campaign record within the system.

Global ID String True

A globally unique identifier assigned to the order campaign to ensure consistency and uniqueness across different systems or databases.

Link String False

A hyperlink pointing to the order campaign's details or related content, allowing users to easily navigate to additional information about the campaign.

Order Campaign Name String False

The name of the order campaign, typically used to track and identify the campaign in the system and in reporting.

Status String False

The current status of the order campaign, such as 'Active', 'Inactive', or 'Completed', indicating the campaign's progress or phase.

Created By String True

The user or system responsible for creating the order campaign record, ensuring accountability for the initiation of the campaign.

Created Date Datetime True

The timestamp when the order campaign record was created, providing a reference point for the start of the campaign.

Last Modified By String True

The user or system that last modified the order campaign record, helping track any changes made after the initial creation.

Last Modified Date Datetime True

The timestamp of the last modification made to the order campaign record, allowing for audit trails and change tracking.

Account Group String False

The group or category of accounts associated with the order campaign, typically used to define a targeted audience for the campaign.

Account Type String False

The type of accounts participating in the order campaign, such as 'Customer', 'Prospective', 'Partner', helping differentiate between different types of accounts involved.

Active Bool False

Indicates whether the order campaign is currently active or not. A value of 'true' means the campaign is active, and 'false' means it is inactive.

Default Bool False

Indicates whether this order campaign is the default one for a particular process or group. A value of 'true' designates it as the default.

Description String False

A detailed description of the order campaign, providing context, objectives, or any other relevant information about the campaign's purpose.

End Date Date False

The date when the order campaign is scheduled to end. This helps in planning and reporting, indicating the campaign's timeline.

Order Campaign Bound Bool False

Indicates whether the order campaign is bound or associated with a particular process or order type. A value of 'true' indicates it is bound.

Order Record Type String False

The type of order record that this campaign relates to, such as 'Sales', 'Return', or 'Exchange', helping categorize the orders associated with the campaign.

Start Date Date False

The date when the order campaign is scheduled to start. This is important for campaign planning and scheduling.

Owner String False

The user or account ID responsible for overseeing or managing the order campaign, typically linked to the person or team accountable for the campaign's success.

Legacy CRM Id String False

The identifier from the legacy CRM system, used to link and migrate historical data into the current system.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454