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