Power BI Connector for Vault CRM

Build 25.0.9454

SalesTransactions

Contains detailed records of all sales transactions, including product, quantity, date, and associated accounts or territories. This serves as the primary source of truth for sales activity reporting and performance metrics.

Columns

Name Type ReadOnly Description
ID [KEY] String True

Unique identifier for the sales transaction record.

Global ID String True

System-generated global identifier used to reference the transaction across Vault instances.

Link String False

System-generated link to directly access the sales transaction record within the Vault application.

Sales Transaction Name String False

Name or title of the sales transaction, typically representing the transaction event or purpose.

Status String False

Current status of the sales transaction, such as Draft, Approved, or Completed.

Created By String True

User who initially created the sales transaction record.

Created Date Datetime True

Date and time when the sales transaction was first created.

Last Modified By String True

User who last modified the sales transaction record.

Last Modified Date Datetime True

Date and time of the most recent update to the sales transaction record.

B100 Double False

Custom metric B100 associated with the transaction, potentially used for financial or performance tracking.

B101 Double False

Custom metric B101 tied to the transaction, which can represent a pricing, quantity, or adjustment value.

B102 Double False

Custom numeric field B102 for capturing transaction-specific data, such as discount rates or unit costs.

B103 Double False

Numeric field B103, used for custom calculations or business metrics related to the transaction.

B104 Double False

User-defined field B104, commonly used to track monetary values or internal scoring.

B105 Double False

Numeric field B105, potentially used to represent tax, markup, or volume-related values.

B106 Double False

Field B106 stores custom quantitative data tied to the sales transaction process.

B107 Double False

Custom metric B107, typically configured for analytics or operational tracking.

B108 Double False

User-defined numeric value B108 related to transaction performance or classification.

B109 Double False

Custom field B109 used to store additional computed or imported financial data.

B10 Double False

Legacy or system-specific metric B10, can represent a subtotal or line-level amount.

B110 Double False

Custom data point B110, configured for a business rule or workflow logic.

B111 Double False

User-configurable metric B111, used for validation or reporting calculations.

B112 Double False

Numerical value B112 designed for transaction-specific analytics or summarization.

B113 Double False

Custom field B113 storing numeric details related to transaction categorization.

B114 Double False

Metric B114, likely used for tracking amounts, rates, or quantities in a transaction.

B115 Double False

Numeric field B115 supporting business-specific reporting or segmentation.

B116 Double False

Calculated or user-entered value B116 representing transaction metadata or detail.

B117 Double False

Field B117 reserved for custom extensions to the transaction model.

B118 Double False

Final numeric metric B118 used in sales transaction analytics, validation, or documentation.

B119 Double False

Represents the transaction amount or quantity for item or metric code B119, typically used in performance or sales reporting.

B11 Double False

Contains the numerical value associated with item or indicator B11, which can represent a specific sales volume or metric.

B120 Double False

Stores the value for sales metric B120, potentially used for regional or category-specific reporting.

B121 Double False

Numeric field capturing data related to B121, possibly tied to transactional performance or product-specific statistics.

B122 Double False

Reflects data for sales indicator B122, which can denote a particular sales phase or customer segment metric.

B123 Double False

Holds the calculated value for B123, typically representing detailed breakdowns in transaction-level data.

B124 Double False

Includes metric data under code B124, often used for analytical tracking of sales performance.

B125 Double False

Captures the recorded value for B125, likely representing sales effectiveness or call outcome metrics.

B126 Double False

This is used to store the double-precision value for B126, possibly linked to a time-based or region-specific transaction count.

B127 Double False

Contains numerical data for B127, which can be related to incentive tracking, goals, or performance KPIs.

B128 Double False

Stores sales-related information under code B128, often used in advanced analytics or trend analysis.

B129 Double False

Numeric field representing the value of B129, potentially tied to compliance tracking or activity-based scoring.

B12 Double False

Reflects transaction data or metric value under B12, possibly summarizing totals or sales rep performance.

B130 Double False

Represents a calculated or input value for B130, frequently used in sales dashboards or reporting models.

B131 Double False

Represents metric B131, a numerical field likely used to capture a sales-specific quantitative attribute such as product units, order volume, or regional allocation data.

B132 Double False

Contains the B132 metric value, which can reflect a financial figure, performance indicator, or transactional count relevant to sales activities.

B133 Double False

Stores the B133 value, potentially representing a derived or calculated measure within a sales reporting context such as average units sold or commission amount.

B134 Double False

Captures the B134 metric, typically associated with secondary sales data points like adjusted totals or returns.

B135 Double False

Tracks B135, a numeric value possibly linked to discount rates, product availability scoring, or quota fulfillment.

B136 Double False

Represents B136, which can relate to the conversion rate or sales penetration for a particular product or segment.

B137 Double False

Holds the B137 value, often tied to business intelligence KPIs such as regional performance indexes or campaign-level metrics.

B138 Double False

Numeric field B138, which can denote revenue contribution or a target achievement percentage in the context of sales.

B139 Double False

Captures B139, a metric that could be used for measuring productivity, engagement level, or cross-sell ratios.

B13 Double False

Represents the B13 numeric indicator, a foundational metric used across sales reports or dashboards for aggregating performance.

B140 Double False

Stores the B140 field, likely related to revenue targets, sales incentives, or market share tracking.

B141 Double False

Contains B141, a sales data metric often used to calculate trend analysis or year-over-year growth.

B142 Double False

Captures B142 values that might reflect tiered pricing impact, demand variance, or product ranking scores.

B143 Double False

Represents the B143 numeric indicator, potentially associated with internal benchmarking or compliance metrics.

B144 Double False

Tracks B144 values that can be utilized for operational forecasting or incentive payout modeling.

B145 Double False

Holds the B145 metric, typically tied to performance thresholds, deal closure ratios, or sales velocity.

B146 Double False

Stores B146, which can represent a cumulative or weighted value used in executive reporting or sales analysis models.

B147 Double False

Represents the total number of product samples distributed during the transaction, as recorded in field b147__v.

B148 Double False

Indicates the total monetary value of all samples distributed, helping track high-value transactions via b148__v.

B149 Double False

Captures the total volume or units sold in this transaction, aligned with field b149__v for inventory movement tracking.

B14 Double False

Reflects a custom metric such as a transaction discount or adjustment factor, tied to field b14__v.

B150 Double False

Denotes the number of Healthcare Professional (HCP) engagements linked to this sales event, stored in b150__v.

B151 Double False

Records the number of promotional materials shared during the sales call, as captured in b151__v.

B152 Double False

Measures the duration of the sales call or interaction in minutes, tracked using b152__v.

B153 Double False

Represents a performance score or effectiveness rating of the transaction, calculated and stored in b153__v.

B154 Double False

Indicates the percentage of the sales target achieved in this transaction, logged in b154__v.

B155 Double False

Stores the bonus eligibility or earned incentive value for the sales rep related to this transaction, in b155__v.

B156 Double False

Reflects a compliance score or audit metric for the sales interaction, recorded in field b156__v.

B157 Double False

Captures the number of product variants discussed or presented during the transaction, noted in b157__v.

B158 Double False

Represents the customer satisfaction score, usually gathered post-transaction, and stored in b158__v.

B159 Double False

Denotes the count of follow-up actions scheduled or completed as part of this transaction, from field b159__v.

B15 Double False

Captures a transaction-specific metric such as co-promotion indicator or marketing tag value, using b15__v.

B160 Double False

Logs the number of samples returned, exchanged, or adjusted post-transaction, recorded in b160__v.

B161 Double False

Metric B161: Captures the total monetary value of promotional samples distributed during the transaction period, used for compliance and tracking.

B162 Double False

Metric B162: Represents the calculated average spend per territory associated with this transaction entry, typically used in sales performance evaluations.

B163 Double False

Metric B163: Indicates the total volume of product units transferred in this transaction, reflecting operational throughput.

B164 Double False

Metric B164: Tracks the return quantity of distributed items for reconciliation and loss prevention purposes.

B165 Double False

Metric B165: Denotes adjusted gross revenue after discounts have been applied to the original transaction value.

B166 Double False

Metric B166: Captures total tax applied to the transaction, including both sales and regulatory taxes where applicable.

B167 Double False

Metric B167: Represents the amount attributed to shipping and handling fees included in the transaction.

B168 Double False

Metric B168: Reflects the number of interactions recorded with healthcare providers in connection to this transaction.

B169 Double False

Metric B169: Summarizes the number of samples requested in follow-up to this transaction by the receiving party.

B16 Double False

Metric B16: Historical field retained for compatibility with legacy reporting systems, can represent deprecated or transitional values.

B170 Double False

Metric B170: Reflects the cumulative value of bonuses or incentives issued to field reps based on this transaction's metrics.

B171 Double False

Metric B171: Tracks calculated cost-per-call derived from field activity linked to the transaction.

B172 Double False

Metric B172: Indicates the number of products with low inventory thresholds triggered during this transaction.

B173 Double False

Metric B173: Denotes compliance score assigned to the transaction based on regulatory guidelines or internal policy.

B174 Double False

Metric B174: Captures transaction-level flags for audit review, quality assurance, or data verification processes.

B175 Double False

Metric B175: Stores calculated forecast accuracy by comparing expected vs. actual sales performance in this transaction.

B176 Double False

Metric B176: Represents internal risk rating or alert level assigned based on transaction irregularities or anomalies.

B177 Double False

Custom field B177 capturing a numeric sales-related metric specific to transaction audits or performance tracking.

B178 Double False

Custom field B178 used to store calculated values related to pricing, discounts, or financial adjustments during a sales transaction.

B179 Double False

Custom metric B179 that can reflect inventory counts, batch-level totals, or regulatory compliance data in sales workflows.

B17 Double False

Field B17 typically stores a numeric value such as a transaction score, risk factor, or forecast indicator.

B180 Double False

Custom field B180 potentially representing volume-based sales data, quantity multipliers, or promotional impact figures.

B181 Double False

Numeric field B181 tracking partner-related revenue shares, sales commissions, or allocation metrics.

B182 Double False

Field B182 used to record detailed numeric inputs such as expected delivery counts, sample allocation, or sales thresholds.

B183 Double False

Custom field B183 capturing structured financial metrics, such as invoice discrepancies or tax computations tied to a transaction.

B184 Double False

Field B184 used in transaction analytics to quantify customer-level segmentation or campaign responsiveness.

B185 Double False

Numeric field B185 storing reporting-specific values like year-over-year sales change, margin variances, or product-level benchmarks.

B186 Double False

Custom metric B186 used for internal tracking of SLA adherence, delivery turnaround time, or fulfillment rates.

B187 Double False

Field B187 likely designed to store sales scorecards, transaction-based evaluations, or compliance checkpoints.

B188 Double False

Field B188 represents numeric inputs linked to budget allocations, sales planning, or incentive payout estimations.

B189 Double False

Custom field B189 tracking operational performance metrics such as distribution accuracy, region-based performance, or logistics delays.

B18 Double False

Field B18 typically holds a transaction-level numeric identifier, such as a sales stage progress index or milestone achievement score.

B190 Double False

Custom numeric field B190 designed for advanced reporting calculations, potentially involving weighted averages or predictive scoring models.

B191 Double False

Represents the numeric value associated with transaction attribute B191, which can correspond to a specific sales metric or internal identifier used in revenue tracking.

B192 Double False

Numeric field capturing the value for B192, potentially indicating a secondary measurement related to the sales transaction such as a bonus, tax, or adjustment.

B193 Double False

Stores a quantitative detail for field B193, likely representing a transaction-specific calculation such as margin, rate, or allocation.

B194 Double False

Denotes the value of field B194, which can be used to represent a special condition, conversion factor, or auxiliary amount in the context of a sales event.

B195 Double False

Holds the numerical data for B195, potentially a derived figure such as prorated cost, distributed revenue, or tier-based value.

B196 Double False

Reflects the value associated with B196, which might correspond to an internal system flag, quota metric, or adjusted transaction score.

B197 Double False

Captures the transaction-specific amount for B197, possibly indicating regional variance, cost override, or incentive payout.

B198 Double False

Numeric representation of B198, which can be a result of business logic related to rebates, net sales, or promotion deductions.

B199 Double False

Stores the double-precision number for B199, used potentially for performance indicators, ROI calculations, or transactional benchmarks.

B19 Double False

Represents a key numeric value from field B19, often linked to legacy codes or standardized values used across historical transaction records.

B1 Double False

Core transaction amount or indicator labeled as B1, possibly representing the primary sales figure or unit price in the transaction dataset.

B200 Double False

Captures the calculated or input value for B200, often used for extended transaction attributes such as total discount or customer ranking score.

B201 Double False

Stores the value of B201, which can represent estimated impact, strategic forecast data, or pipeline-derived contribution.

B202 Double False

Numeric field for B202, likely associated with transaction metadata such as sales channel weight, allocation ratio, or uplift factor.

B203 Double False

Holds the double value for B203, potentially tied to regulatory reporting, audit scoring, or CRM-influenced transaction weight.

B204 Double False

Represents the value stored in B204, which could be relevant for compliance factors, exception tracking, or procedural adjustments.

B205 Double False

Numeric data field for B205, which can reflect a concluding metric in the sales transaction pipeline, such as final evaluated value or quality assurance adjustment.

B206 Double False

Represents a numeric metric associated with transactional performance, possibly a sales efficiency or conversion ratio indicator.

B207 Double False

Quantitative value capturing a specific financial detail within the sales transaction, potentially related to rebates or discounts applied.

B208 Double False

Holds a decimal-based value likely corresponding to tax adjustments or a calculated financial offset applied to the sale.

B20 Double False

Stores a numerical code or measure used to segment transaction categories, such as region or product type.

B21 Double False

Captures the unit cost or price per item sold in a given sales transaction.

B22 Double False

Represents the total quantity of units sold for the item within the transaction record.

B23 Double False

Reflects the gross transaction amount prior to discounts, taxes, or adjustments.

B24 Double False

Indicates the discount applied to the transaction, recorded as a numeric value.

B25 Double False

Represents tax or VAT calculated for the transaction line item.

B26 Double False

Final amount after applying discounts and taxes, serving as the net transaction value.

B27 Double False

Tracks the commission or incentive value earned for this transaction line.

B28 Double False

Contains the budget allocation value from the marketing or sales budget attributed to this transaction.

B29 Double False

Numeric field used for auditing purposes, potentially tracking internal validation scores or system checks.

B2 Double False

Stores the transaction sequence or priority index, helping define order or processing logic.

B30 Double False

Represents a custom financial calculation applied to the transaction, such as margin or profitability ratio.

B31 Double False

Captures an adjustment or correction applied post-transaction, used for financial reconciliation.

B32 Double False

Captured numeric value representing sales-related attribute B32, typically associated with customer-specific transaction metrics.

B33 Double False

Numeric value for B33, which can correspond to calculated revenue figures or performance thresholds tied to a sales operation.

B34 Double False

Represents a transaction-specific metric B34, often used in the context of sales event logging or reporting analysis.

B35 Double False

Quantitative field used to track value B35, which could relate to inventory movement, sales volume, or pricing adjustments.

B36 Double False

This is used to store financial or operational figures labeled as B36, such as sales discounts, surcharges, or allocation ratios.

B37 Double False

Reflects a transaction factor B37, commonly used for internal reporting on customer engagements or product performance.

B38 Double False

This column tracks metric B38, typically linked to promotional effectiveness, sales representative output, or regional performance.

B39 Double False

Stores numeric value B39, which could indicate invoice totals, rebate amounts, or internal adjustment coefficients.

B3 Double False

Represents base metric B3, frequently used in legacy transaction tracking or as a foundational sales data component.

B40 Double False

Contains figure B40 related to secondary financial indicators like commissions, bonuses, or channel-specific allocations.

B41 Double False

A value representing attribute B41, often associated with client groupings, specialty campaign results, or offer tracking.

B42 Double False

Sales transaction field B42, possibly referencing currency conversions, unit sales in bundles, or performance indexing.

B43 Double False

This is used for tracking operational metric B43, which can pertain to delivery compliance, logistics KPIs, or distribution effort.

B44 Double False

Stores measurement B44, likely related to territory-based performance analysis or vertical market segmentation outcomes.

B45 Double False

Numeric representation of B45, which can support audit trail evaluations, escalation flags, or workflow scoring.

B46 Double False

Captures quantitative detail B46, possibly associated with VAT, tax implications, or pricing tier differentiation.

B47 Double False

Represents transaction variable B47, generally used for special case sales activities, such as incentive qualification or exception handling.

B48 Double False

Custom numeric field B48, often used to capture a transaction-specific metric such as discount rate or secondary commission amount.

B49 Double False

Custom numeric field B49, which can represent an override value, rebate percentage, or similar sales adjustment metric.

B4 Double False

Custom numeric field B4, typically configured to store region-specific sales figures or a derived calculation based on quantity and unit price.

B50 Double False

Custom numeric field B50, often used to store a calculated field such as promotional value, bonus allocation, or pricing variance.

B51 Double False

Custom numeric field B51, potentially representing a secondary sales performance indicator or territory-based sales quota.

B52 Double False

Custom numeric field B52, likely capturing transactional costs such as shipping fees, handling charges, or packaging expenses.

B53 Double False

Custom numeric field B53, used to track supplementary sales data such as adjusted net value or customer-level adjustments.

B54 Double False

Custom numeric field B54, intended to hold alternate revenue figures such as exchange rate-adjusted revenue or tax-adjusted amounts.

B55 Double False

Custom numeric field B55, capturing metrics linked to customer engagement levels or incentive-based volume tiers.

B56 Double False

Custom numeric field B56, which can be used to hold data for time-sensitive sales elements like flash discount totals or campaign spend.

B57 Double False

Custom numeric field B57, used for tracking metrics tied to digital sales channels, such as app-based transactions or website-specific revenue.

B58 Double False

Custom numeric field B58, which could reflect legacy import values, conversion-adjusted amounts, or integration-transferred data.

B59 Double False

Custom numeric field B59, generally used for customized reporting, capturing data like forecast overrides or market simulation outcomes.

B5 Double False

Custom numeric field B5, commonly used in sales performance reports, potentially representing a fixed monthly quota or benchmark value.

B60 Double False

Custom numeric field B60, used for high-level rollup data such as quarterly aggregate sales or pipeline-weighted projections.

B61 Double False

Custom numeric field B61, capturing transaction-level statistics such as sales effectiveness ratios or conversion efficiency scores.

B62 Double False

Custom numeric field B62, frequently configured to log adjustment factors, refund percentages, or tolerance thresholds.

B63 Double False

Custom numeric field B63, used to represent grouped transaction data such as cluster-level totals or territory aggregates.

B64 Double False

Custom numeric field B64, often applied to quality control or audit checks, capturing calculated discrepancies or flags.

B65 Double False

Custom numeric field B65, potentially used to hold compliance scores, customer satisfaction metrics, or audit result indicators.

B66 Double False

Represents the total discount amount applied to the transaction before tax calculations.

B67 Double False

Indicates the final invoice value after applying all discounts and taxes.

B68 Double False

Captures the unit cost of the product or service sold in the transaction.

B69 Double False

Reflects the total quantity of items returned or reversed in this transaction.

B6 Double False

Internal metric B6 used for pricing adjustment calculations based on territory or customer tier.

B70 Double False

Represents the applied tax percentage or rate used in the transaction.

B71 Double False

Captures the net payable amount post all adjustments including discounts and taxes.

B72 Double False

Denotes the shipment cost incurred for fulfilling this particular transaction.

B73 Double False

Holds the promotional discount percentage if the sale was part of a campaign.

B74 Double False

Tracks the revenue contribution from this transaction toward monthly sales goals.

B75 Double False

Represents an internal risk score or confidence factor associated with this transaction.

B76 Double False

Indicates the average deal size in which this transaction falls, based on historical ranges.

B77 Double False

Captures the transaction margin percentage based on cost vs. invoice value.

B78 Double False

Stores adjustment values due to late payments, refunds, or invoice corrections.

B79 Double False

This is used to represent the weighted revenue impact for sales compensation calculations.

B7 Double False

Internal metric B7 tracking customer engagement level during the sales cycle.

B80 Double False

Captures the sales channel ID through which the transaction was executed, such as direct, partner, or digital.

B81 Double False

Indicates the calculated customer lifetime value contribution derived from this sale.

B82 Double False

Represents the discount percentage applied to the transaction, often used for promotional pricing analysis.

B83 Double False

Captures the final net price after all discounts, rebates, and adjustments have been applied.

B84 Double False

Indicates the wholesale acquisition cost (WAC) at the time of the transaction, used for market comparisons.

B85 Double False

Specifies the cost of goods sold (COGS) for the item in this transaction, contributing to profitability metrics.

B86 Double False

Shows the markup amount added to the base cost to derive the list price for the transaction item.

B87 Double False

Reflects the reimbursement amount expected from third-party payers or insurance entities for this sale.

B88 Double False

Denotes the government price ceiling relevant to the item, ensuring compliance with regulatory price limits.

B89 Double False

Tracks the total taxes applied to this transaction, including local, state, and federal taxes.

B8 Double False

Stores a custom business-specific metric, such as internal performance scoring or incentive triggers.

B90 Double False

Measures the quantity sold in standard units, providing input for forecasting and sales performance tracking.

B91 Double False

Indicates the number of free or bonus units included in the transaction, commonly used in sampling programs.

B92 Double False

Represents the sales territory multiplier, used for crediting sales teams based on regional contributions.

B93 Double False

Contains the calculated gross margin for the transaction, derived from price and COGS differentials.

B94 Double False

Holds the standard price before any customer-specific or market-based adjustments are applied.

B95 Double False

Captures the actual invoice amount paid by the customer, post-discounts and returns.

B96 Double False

Stores the internal revenue code or classification tied to this transaction for accounting purposes.

B97 Double False

Reflects the percentage of transaction cost attributed to logistics and distribution overhead.

B98 Double False

Indicates the volume-based rebate or credit earned as part of a larger purchasing agreement.

B99 Double False

Captures the deferred revenue portion from this transaction, relevant for multi-period revenue recognition.

B9 Double False

Internal numeric identifier used for reference or system-specific computations within the sales transaction dataset.

Brick String False

Geographical segmentation code, commonly used in pharmaceutical sales to define territories for sales reporting and analysis.

Child ID String False

Identifier for a subordinate or related entity, such as a sub-account or dependent product, linked to the parent record.

Data Channel String False

Indicates the source or type of channel through which the sales data was collected, such as retail, mail order, or specialty pharmacy.

ID2 String False

Secondary unique identifier for the transaction or record, often used in legacy systems or integration processes.

Market String False

Specifies the healthcare market or therapeutic area in which the transaction took place, used for segmentation and analytics.

Payer Id String False

Unique identifier assigned to the insurance payer or benefit provider responsible for reimbursing the transaction.

Payer Plan String False

Name or identifier of the specific insurance or benefit plan associated with the payer, used to distinguish between multiple plans under the same payer.

Product_Group String False

Categorization of the product involved in the transaction, grouping similar medications or treatments for reporting purposes.

Territory Name String False

The descriptive name of the sales territory associated with the transaction, used for sales force alignment and performance tracking.

Type String False

Specifies the classification or nature of the transaction, such as new, refill, adjustment, or sample.

Zip String False

Postal ZIP code indicating the geographic location related to the transaction, typically of the prescribing provider or dispensing pharmacy.

Owner String False

Vault-specific owner ID referencing the user or process that owns or submitted the transaction record.

Legacy CRM Id String False

Identifier carried over from a previous Customer Relationship Management (CRM) system, used to map historical data to the current Vault record.

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