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. |