Excel Add-In for Vault CRM

Build 25.0.9434

ContractLines

Represents the individual line items within a contract, detailing specific terms, pricing, deliverables, or conditions that form part of the overall agreement.

Columns

Name Type ReadOnly Description
ID [KEY] String True

Unique identifier for the contract line record within the Vault system.

Contract Line Type String True

Specifies the type of contract line, such as Sales or Listing, determining the applicable business rules and workflows.

Global ID String True

System-generated global identifier combining Vault ID and record ID, ensuring uniqueness across all Vaults for integration purposes.

Link String False

Reference field used to track the source of the object record, facilitating Vault-to-Vault or external system integrations.

Contract Line ID String True

User-defined identifier for the contract line, often used for display and reference in user interfaces and reports.

Status String False

Indicates the current lifecycle state of the contract line, such as Draft, Active, or Expired, guiding permissible actions.

Created By String True

Identifier of the user who created the contract line record, useful for audit trails and user activity tracking.

Created Date Datetime True

Timestamp marking when the contract line was initially created in the system.

Last Modified By String True

Identifier of the user who last modified the contract line record, aiding in change tracking and accountability.

Last Modified Date Datetime True

Timestamp of the most recent modification to the contract line record.

Device Type String False

Specifies the category of device associated with the contract line, such as Medical Device or Pharmaceutical Product.

Rate Maximum Decimal False

Maximum allowable rate for the service or product under the contract line, expressed in local currency.

Rate Maximum Corp Decimal True

Corporate-level maximum rate for the service or product, standardized across different regions or business units.

Local Currency String False

Currency code representing the local currency applicable to the contract line, aligning with regional financial practices.

Rate Minimum Decimal False

Minimum allowable rate for the service or product under the contract line, expressed in local currency.

Rate Minimum Corp Decimal True

Corporate-level minimum rate for the service or product, ensuring consistency in pricing strategies.

Rate Type String False

Defines the method of rate calculation, such as Fixed, Variable, or Tiered, influencing billing and invoicing processes.

Rate Decimal False

Standard rate applied to the service or product under the contract line, based on the defined rate type.

Rate Corp Decimal True

Corporate-standard rate for the service or product, facilitating uniform pricing across the organization.

Service Quantity Maximum Double False

Upper limit on the quantity of service or product deliverable under the contract line.

Service Quantity Minimum Double False

Lower limit on the quantity of service or product deliverable under the contract line.

Service Quantity Double False

Agreed-upon quantity of service or product to be delivered under the contract line.

End Date Date False

Date on which the contract line's terms and conditions cease to be effective.

External ID String False

Identifier used to link the contract line record to external systems or datasets, supporting data synchronization.

IM Consumer Price Decimal False

Price point of the product or service as observed in inventory monitoring, reflecting consumer-facing pricing.

IM Consumer Price Corp Decimal True

Corporate-level consumer price used in inventory monitoring, aiding in centralized pricing analysis.

IM Horizontal Decimal False

Measurement of product facings in a horizontal orientation within a retail or display setting, used in inventory assessments.

IM Facings Decimal False

Total number of product facings, indicating the product's visibility and shelf presence in inventory monitoring.

IM Vertical Decimal False

Measurement of product facings in a vertical orientation within a retail or display setting, used in inventory assessments.

IM Inventory Decimal False

Represents the inventory level of the product at the time the contract line was created or evaluated. This value can be used to assess availability or fulfillment readiness.

IM Layer String False

Indicates the inventory management layer or tier associated with this contract line, such as central warehouse, regional depot, or retail point.

IM Moved Goods Decimal False

Tracks the quantity of goods that have been moved or transferred under this contract line, reflecting logistics or distribution activity.

IM Position String False

Describes the physical or logical inventory position relevant to this contract line, such as shelf location, depot slot, or assigned container.

Lock Bool False

Indicates whether the contract line is locked from further modification. A locked state prevents updates and enforces data consistency.

Mandatory Contract Line Bool False

Specifies whether the contract line is mandatory as part of the overall contract. This flag enforces inclusion during contract validation and submission.

Mobile Created Datetime Datetime False

Captures the exact date and time the contract line record was created using a mobile device, supporting field activity traceability.

Mobile ID String False

Unique identifier assigned to the contract line record by the mobile device that created it, used for synchronization and audit tracking.

Mobile Last Modified Datetime Datetime False

Stores the timestamp of the most recent modification to the contract line via a mobile device, useful for mobile user audits.

Notes String False

Free-text field containing comments, observations, or internal remarks relevant to the contract line. Often used for operational annotations.

OM List Amount Achieved Decimal False

Represents the total achieved sales amount based on list price under this contract line, used for incentive or rebate calculations.

OM List Amount Achieved Corp Decimal True

Corporate-level aggregation of the list amount achieved under this contract line, supporting centralized reporting and finance controls.

OM List Amount Target Decimal False

Targeted sales amount based on list price for this contract line, used to evaluate performance against contract expectations.

OM List Amount Target Corp Decimal True

Corporate-level sales target amount under list pricing for this contract line, aiding in strategic planning and financial forecasting.

OM Net Amount Achieved Decimal False

Total achieved sales amount under net pricing (after discounts or rebates) for this contract line, reflecting true revenue contribution.

OM Net Amount Achieved Corp Decimal True

Corporate roll-up of the net amount achieved for this contract line, typically used for high-level profitability analysis.

OM Net Amount Target Decimal False

Net pricing target for the contract line, representing the expected revenue goal after discounts are applied.

OM Net Amount Target Corp Decimal True

Corporate-level net revenue target for the contract line, used to assess sales performance across business units or regions.

OM Quantity Achieved Decimal False

Actual product quantity sold or fulfilled under this contract line, supporting volume-based performance tracking.

OM Quantity Target Decimal False

Planned product quantity to be achieved for this contract line, used to evaluate progress toward contractual obligations.

Override Lock Bool False

Indicates whether users have permission to override the lock on this contract line. If true, modifications can be allowed even when locked.

Product Identifier String False

Unique product code or SKU referenced by this contract line, used to link the contract to a specific product in the catalog.

Start Date Date False

The effective date when this contract line becomes active. Determines the beginning of the fulfillment or tracking period.

Event Format String False

Specifies the type of promotional or contractual event associated with this line, such as webinar, in-person session, or hybrid format.

Location Type String False

Describes the type of location where the contract line activity or fulfillment occurs, such as hospital, clinic, or distribution center.

Content Length String False

Represents the duration, size, or extent of content associated with the contract line, depending on the context (for example, video minutes, document pages).

Program Type String False

Categorizes the program under which this contract line is executed, such as educational initiative, marketing campaign, or compliance training.

Service Type String False

Defines the type of service being provided or contracted, such as consulting, delivery, or technical support.

Contract String False

Reference to the parent contract to which this line belongs. This is used to group and organize lines within the larger contractual framework.

Product String False

Descriptive name of the product tied to this contract line, supporting human-readable identification alongside the product identifier.

Service String False

Identifier of the medical service or offering associated with this contract line, as defined in the Vault service catalog (service__v).

Service Name String True

Descriptive name of the service linked to this contract line, typically used for human-readable referencing in reports and user interfaces (service_name__v).

Total Payment Decimal True

Cumulative amount that has been paid or is expected to be paid for this specific contract line, reflecting the full value of the service agreement (em_total_payment__v).

OM List Amount Remaining Decimal True

Remaining balance from the original list price value allocated to this contract line, used to track unutilized list-priced amounts in operational models (om_list_amount_remaining__v).

OM Net Amount Remaining Decimal True

Net value still available under this contract line after accounting for discounts, adjustments, or partial usage, as tracked in operational models (om_net_amount_remaining__v).

OM Quantity Remaining Decimal True

Remaining quantity or units of the contracted item or service that have not yet been utilized or invoiced, based on operational model tracking (om_quantity_remaining__v).

Legacy CRM Id String False

Reference ID carried over from a legacy Customer Relationship Management (CRM) system to maintain historical linkage and data integrity across systems (legacy_crm_id__v).

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