CData Python Connector for SugarCRM

Build 25.0.9454

PurchasedLineItems

Stores individual purchase line-item records. This table supports purchase history analysis, revenue attribution, and customer value insights.

Columns

Name Type ReadOnly Description
Account_Id String False

The identifier (Id) of the account that is associated with the purchased line item's parent purchase. This value links the purchased item to the customer or business entity responsible for the transaction.

Account_Name String True

The display name of the account that is associated with the purchased line item. This value is shown in the user interface for readability and reporting.

Acl_Team_Names String True

The list of team names that are associated with this purchased line-item record. This value supports collaboration, access control, and visibility filtering.

Acl_Team_Set_Id String False

The Id of the set of teams that have access to this purchased line item. This value is used to manage shared permissions across teams.

Annual_Revenue Decimal True

The annual revenue amount that is associated with the purchased item, if applicable. This value can be used for revenue planning, reporting, or forecasting.

Asset_Number String False

The asset tag or tracking number that identifies the product item that is in use by the customer. This value supports asset management and lifecycle tracking.

Assigned_User_Id String False

The Id of the user who is responsible for managing or overseeing this purchased line item. This assignment determines ownership and workflow accountability.

Assigned_User_Name String True

The display name of the user who is assigned to this purchased line item. This value enhances readability in the user interface and reports.

Base_Rate String False

The base exchange or pricing rate that is applied to the purchased line item. This value can be used in pricing, billing, or currency calculations.

Book_Value Decimal True

The current accounting value of the purchased asset, based on depreciation or book valuation methods. This value supports financial tracking and asset reporting.

Book_Value_Date Date False

The date on which the book value of the purchased asset was calculated. This value is used to verify accuracy and timing of depreciation or valuation adjustments.

Book_Value_Usdollar Decimal True

The accounting book value of the purchased asset expressed in United States dollars (USDs). This value supports standardized financial comparison and reporting.

Catalog_Service_Duration_Unit String True

The unit of time that is associated with the product catalog item's service duration (for example, 'days', 'months', or 'years'). This value supports duration comparison and entitlement calculations.

Catalog_Service_Duration_Value Int True

The numeric duration value that corresponds to the Catalog_Service_Duration_Unit field. This value defines the length of the service or entitlement period.

Category_Id String False

The Id of the product category that this purchased line item belongs to. This classification supports product grouping and reporting.

Category_Name String True

The name of the product category that is associated with this purchased line item. This value is shown for readability and classification in selection lists and reports.

Commentlog String True

The comment log entries that are associated with this purchased line item. This field stores collaboration notes, discussion history, and context regarding changes or decisions.

Cost_Price Decimal True

The cost of the purchased product or service. This value represents internal expense before markup or margin is applied.

Cost_Usdollar Decimal True

The cost of the purchased product or service expressed in USDs. This value supports standardized reporting and financial analysis.

Created_By String True

The Id of the user who created this purchased line-item record. This value identifies the record author for auditing and ownership tracking.

Created_By_Name String True

The display name of the user who created this purchased line-item record. This value is shown in the user interface for clarity and review.

Currency_Id String False

The Id of the currency that is associated with monetary values in this purchased line item. This value supports multi-currency pricing and financial conversion.

Currency_Name String True

The display name of the currency that is associated with this purchased line item. This value is shown for readability in the user interface and reports.

Currency_Symbol String True

The symbol that represents the currency that is associated with this purchased line item (for example, '$', '€', or '£'). This value supports formatted display of financial amounts.

Date_Closed Date False

The expected or actual date when this purchased line item is considered closed or finalized. This value supports revenue recognition and contract timeline tracking.

Date_Closed_Timestamp String True

The timestamp representation of the Date_Closed value. This value can be used for precise historical or system-driven event processing.

Date_Entered Datetime True

The date and time when this purchased line-item record was created. This value provides timeline context for auditing and lifecycle tracking.

Date_Modified Datetime True

The date and time when this purchased line-item record was most recently updated. This field supports audit visibility and operational tracking.

Date_Purchased Date False

The date on which the product or service was purchased. This value provides context for customer entitlements, warranty dates, and billing cycles.

Date_Support_Expires Date False

The date when support coverage for the purchased item expires. This value supports renewal planning and service entitlement enforcement.

Date_Support_Starts Date False

The date when support coverage for the purchased item begins. This value marks the start of the support entitlement period.

Deal_Calc Decimal True

The calculated revenue or loss amount for this purchased line item. This value supports margin analysis and financial performance tracking.

Deal_Calc_Usdollar Decimal True

The calculated revenue or loss expressed in USDs. This value supports standardized financial comparison and reporting.

Deleted Bool False

A Boolean field that returns a value of 'true' when this purchased line item is marked as deleted. It returns a value of 'false' when the record remains active and available for use.

Denorm_Account_Name String False

The descriptive name of the account that is associated with this purchased line item, stored in a flattened form for search and reporting efficiency.

Description String False

A detailed description of the purchased line item. This field can include usage notes, context about the purchase, or relevant supporting details.

Discount_Amount String True

The total discount that is applied to the purchased line item. This value reflects price reductions before final pricing or revenue calculation.

Discount_Amount_Signed Decimal True

The total discount amount expressed as a signed value, which can be positive or negative depending on the calculation rules.

Discount_Amount_Usdollar Decimal True

The total discount amount expressed in USDs. This value supports consistent financial reporting across currencies.

Discount_Price Decimal False

The discounted price of the purchased item before taxes or fees are applied. This value reflects the final unit price after discounting.

Discount_Select Bool False

A Boolean field that returns a value of 'true' when a discount option has been selected for this purchased line item. It returns a value of 'false' when no discount selection has been made.

Discount_Usdollar Decimal True

The discounted price of the purchased item expressed in USDs. This value supports standardized pricing and financial reporting.

Following Bool False

A Boolean field that returns a value of 'true' when the current user is following this purchased line item to receive update notifications. It returns a value of 'false' when the user is not following the record.

Id [KEY] String True

The unique Id for this purchased line-item record. This value is used to reference the record across the system and related processes.

List_Price Decimal True

The list price of the purchased product or service before discounts or adjustments are applied. This value supports pricing transparency and comparison.

List_Usdollar Decimal True

The list price of the purchased product or service expressed in USDs. This value supports multi-currency normalization and reporting.

Lock_Duration Bool False

A Boolean field that returns a value of 'true' when direct editing of the duration field is restricted for this purchased line item. It returns a value of 'false' when the duration field is open for editing.

Locked_Fields String True

The list of fields that are restricted from editing for this purchased line item. This ensures that system-controlled configuration remains protected.

Manufacturer_Id String False

The Id of the manufacturer that produced the product that is associated with this purchased line item. This value supports supplier tracking and reporting.

Manufacturer_Name String True

The display name of the manufacturer that produced the product associated with this purchased line item. This value is shown in the user interface and reports.

Mft_Part_Num String False

The part number that is assigned by the manufacturer for this product. This value supports procurement, servicing, and product identification.

Modified_By_Name String True

The display name of the user who most recently modified this purchased line item. This value provides visibility into recent record changes.

Modified_User_Id String True

The Id of the user who most recently updated this purchased line item. This field identifies the source of the latest change activity.

My_Favorite Bool False

A Boolean field that returns a value of 'true' when the current user has marked this purchased line item as a favorite for quick reference. It returns a value of 'false' when the record is not marked as a favorite.

Name String False

The name of the purchased line item. This value is used as the primary label throughout the system.

Pricing_Factor Int True

The numeric factor that is applied during price calculation based on the selected pricing formula. This value influences the resulting sale price.

Pricing_Formula String False

The pricing formula that determines how the final price is calculated (for example, 'Fixed' or 'Markup over Cost'). This value supports consistent and automated pricing.

Product_Template_Id String False

The Id of the product template from which this purchased line item was originally derived. This value links the purchased item to the standard catalog definition.

Product_Template_Name String True

The display name of the product template that is associated with this purchased line item. This value is shown for readability and reference.

Product_Type_Id String False

The Id of the product type classification for this purchased item (for example, 'hardware' or 'software'). This value supports categorization and reporting.

Product_Type_Name String True

The display name of the product type classification that is associated with this purchased line item. This value provides readability in lists and reports.

Purchase_Id String False

The Id of the parent purchase record that resulted in this purchased line item. This value establishes the relationship between the purchase and its itemized components.

Purchase_Name String False

The display name of the parent purchase record that is associated with this purchased line item. This value is shown in the user interface for clarity.

Quantity Decimal True

The quantity of the purchased item that is in use or recorded in the line item. This value supports inventory, entitlement, and billing calculations.

Renewable Bool False

A Boolean field that returns a value of 'true' when the purchased item is renewable, such as a service subscription. It returns a value of 'false' when the item does not renew.

Renewal Bool True

A Boolean field that returns a value of 'true' when this purchased line item represents a renewal of a previous purchase. It returns a value of 'false' when it is a new purchase.

Renewal_Opp_Id String False

The Id of the renewal opportunity that is associated with this purchased line item, if it originated from an opportunity renewal process.

Renewal_Opp_Name String True

The display name of the renewal opportunity that is associated with this purchased line item. This value supports visibility in sales workflows and reporting.

Revenue Decimal False

The revenue that is recognized from this purchased line item. This value supports financial tracking and profitability analysis.

Revenue_Usdollar Decimal True

The revenue that is recognized from this purchased line item expressed in USDs. This value supports standardized financial reporting.

Revenuelineitem_Id String False

The Id of the revenue line item from which this purchased line item was created, when applicable. This value supports traceability in sales processing workflows.

Revenuelineitem_Name String True

The display name of the revenue line item that is associated with this purchased line item. This value provides readability and context in reporting.

Serial_Number String False

The serial number that is assigned to the physical product that is in use. This value supports warranty tracking, servicing, and asset traceability.

Service Bool False

A Boolean field that returns a value of 'true' when the purchased item is a service offering rather than a tangible product. It returns a value of 'false' when the item is a product.

Service_Duration_Multiplier Decimal True

The multiplier that represents the proportion of this purchased item's service duration relative to another reference duration such as its product template. This value is used in entitlement and renewal calculations.

Service_Duration_Unit String False

The time unit that applies to the service duration (for example, 'Year(s)', 'Month(s)', or 'Day(s)'). This value supports scheduling and entitlement definitions.

Service_Duration_Value Int True

The numeric value that represents the length of the service duration. For example, if the duration is four months, the value is '4'.

Service_End_Date String True

The date when service coverage or subscription entitlement ends for this purchased item. This value supports renewal and service continuity planning.

Service_Start_Date Date False

The date when service coverage or subscription entitlement begins. This value marks the start of the service entitlement period.

Status String False

The current status of the purchased line item, indicating whether it is active, expired, pending renewal, or retired.

Subtotal Decimal True

The subtotal value for the purchased line item before discounts, taxes, or adjustments are applied. This value can reflect proration based on service duration.

Support_Contact String False

The contact information that is used for support associated with this purchased item, such as a vendor or internal service group.

Support_Description String False

A description of the support coverage or service entitlement associated with the purchased item. This value can include limitations, service tiers, or usage notes.

Support_Name String False

The name of the support plan or service that is associated with this purchased line item. This value is shown in the user interface and reports.

Support_Term String False

The length or duration of the support contract. This value supports service entitlement and renewal scheduling.

Sync_Key String True

The synchronization key that is used to match this purchased line item with records in external systems. This value ensures data consistency during system integration.

Tag String False

The tags that are associated with this purchased line item. Tags support flexible grouping, categorization, and filtering across records.

Tax_Class String False

The tax classification that applies to this purchased item (for example, 'Taxable' or 'Non-taxable'). This value influences tax calculation and billing.

Team_Count String False

The number of teams that are associated with this purchased line item. This value indicates collaboration scope and access distribution.

Team_Id String False

The Id of the primary team responsible for this purchased line item. This value establishes core ownership for permissions and visibility.

Team_Name String False

The display name of the primary team that is associated with this purchased line item. This value is shown in the user interface for clarity and reporting.

Team_Set_Id String False

The Id of the set of teams that share access to this purchased line item. This value supports multi-team collaboration and permission configuration.

Total_Amount Decimal True

The total monetary amount of the purchased line item after discounts and adjustments are applied. This value is used for billing and reporting.

Vendor_Part_Num String False

The part number that is assigned by the vendor for this purchased product. This value supports procurement and supply chain coordination.

Website String False

The website or URL that provides product or service information for this purchased item. This value can link to vendor, manufacturer, or catalog documentation.

Weight Decimal True

The weight of the purchased item. This value can be used for shipping, logistics, or asset handling.

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