JDBC Driver for Vault CRM

Build 25.0.9434

OpportunityLines

Represents product- or service-level details within an opportunity.

Columns

Name Type ReadOnly Description
ID [KEY] String True

A unique identifier for the opportunity line record, used to reference and index the individual opportunity line within the system.

Opportunity Line Type String True

The classification or category of the opportunity line, which helps distinguish between different types of lines such as 'Product', 'Service', or 'Discount'.

Global ID String True

A globally unique identifier assigned to the opportunity line, ensuring consistency and uniqueness across different systems or databases.

Link String False

A hyperlink that points to the opportunity line or related content, providing direct access to more detailed information for the record.

Opportunity Line Name String True

The name or identifier given to the opportunity line, typically used to describe the product or service associated with the opportunity.

Status String False

The current status of the opportunity line, such as 'Active', 'Closed', or 'Pending', indicating the line's current role or progress in the opportunity.

Created By String True

The user or system responsible for creating the opportunity line record, ensuring accountability and traceability of who initiated the line item.

Created Date Datetime True

The timestamp when the opportunity line was created, providing a reference point for the creation of this record.

Last Modified By String True

The user or system that last modified the opportunity line record, allowing tracking of changes and updates to the line item.

Last Modified Date Datetime True

The timestamp of the last modification made to the opportunity line record, providing an audit trail for when changes were made.

Line Discount Double False

The discount applied to the opportunity line, represented as a percentage or fixed amount, impacting the final sale price of the product or service.

List Price Decimal False

The original price of the product or service before any discounts or adjustments, representing the full retail price in the system.

List Price Corp Decimal True

The list price of the product or service for corporate accounting purposes, potentially reflecting a different pricing structure for internal use.

Local Currency String False

The currency used for the opportunity line's pricing, typically based on the geographical location of the sale or customer.

Net Amount Decimal False

The final amount after discounts and adjustments are applied to the opportunity line, representing the actual price to be paid for the product or service.

Net Amount Corp Decimal True

The net amount after corporate pricing adjustments and discounts, calculated for internal accounting or financial reporting purposes.

Net Price Decimal False

The final price of the product or service, including applicable discounts or adjustments, representing the price before any taxes or other charges.

Net Price Corp Decimal True

The final net price for corporate customers, reflecting any internal pricing structures or special corporate discounts.

Opportunity String False

The opportunity associated with this specific line, linking the product or service to the larger sales opportunity and tracking progress.

Product String False

The product or service offered in this opportunity line, identifying the specific item being sold.

Quantity Decimal False

The quantity of the product or service being sold in this opportunity line, representing the volume or amount of the item in the sale.

Product Identifier String True

A unique identifier for the product associated with the opportunity line, ensuring that the correct product is linked to the sale.

Mobile ID String False

A unique identifier for the mobile device associated with accessing or interacting with the opportunity line, tracking mobile engagement.

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