ODBC Driver for SugarCRM

Build 23.0.8839

RevenueLineItems

The RevenueLineItems table.

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier

Name String False

Name of the product

Date_Entered Datetime True

Date record created

Date_Modified Datetime True

Date record last modified

Modified_User_Id String True

User who last modified record

Modified_By_Name String True

Created_By String True

User who created record

Created_By_Name String True

Description String False

Full text of the note

Deleted Bool False

Record deletion indicator

Product_Template_Id String False

Product (in Admin Products) from which this product is derived (in user Products)

Product_Template_Name String True

Lock_Duration Bool False

Turn on or off a user ability to directly edit the duration field

Account_Id String False

Account this product is associated with

Subtotal Decimal True

Stores the total of the line item before any discounts are applied, taking proration into consideration

Total_Amount Decimal True

Type_Id String False

Product type (ex: hardware, software)

Quote_Id String False

If product created via Quote, this is quote ID

Manufacturer_Id String False

Manufacturer of product

Manufacturer_Name String True

Category_Id String False

Product category

Category_Name String True

Mft_Part_Num String False

Manufacturer part number

Cost_Price Decimal True

Product cost (

Discount_Price Decimal True

Discounted price (

Discount_Amount String True

Discounted amount

Discount_Select Bool False

Discount_Rate_Percent Decimal True

Discount_Amount_Usdollar Decimal True

Discount_Amount_Signed Decimal True

Discounted Amount Signed

Deal_Calc Decimal True

deal_calc

Deal_Calc_Usdollar Decimal True

deal_calc_usdollar

Cost_Usdollar Decimal True

Cost expressed in USD

Discount_Usdollar Decimal True

Discount price expressed in USD

List_Usdollar Decimal True

List price expressed in USD

Status String False

Product status (ex: Quoted, Ordered, Shipped)

Book_Value_Usdollar Decimal True

Book value expressed in USD

Generate_Purchase String False

Generate Purchase Options (ex: Yes, No, Completed)

Purchasedlineitem_Id String False

If PLI was created from this RLI, this is that PLIs ID

Purchasedlineitem_Name String True

PLI Name

Best_Case Decimal True

Likely_Case Decimal False

Worst_Case Decimal True

Date_Closed Date False

Expected or actual date the product (for opportunity) will close

Date_Closed_Timestamp String True

Next_Step String False

The next step in the sales process

Commit_Stage String False

Forecast commit category: Include, Likely, Omit etc.

Sales_Stage String False

Indication of progression towards closure

Probability Int True

The probability of closure

Lead_Source String False

Source of the product

Campaign_Id String False

Campaign that generated lead

Campaign_Name String True

Forecasted_Likely Decimal True

Rollup of included RLIs on the Opportunity

Quote_Name String True

Quote Name

Opportunity_Id String False

The opportunity id for the line item entry

Opportunity_Name String False

The opportunity name associated with the opportunity_id

Product_Type String False

Type of product ( from opportunities opportunity_type ex: Existing, New)

Type_Name String True

Account_Name String True

Add_On_To_Id String False

Purchased line item that this is an add-on to

Add_On_To_Name String True

Renewal_Rli_Id String False

Renewal RLI of this RLI, set during renewal generation

Renewal_Rli_Name String True

Following Bool False

Is user following this record

My_Favorite Bool False

Favorite for the user

Tag String False

Commentlog String True

Locked_Fields String True

Sync_Key String True

Assigned_User_Id String False

User ID assigned to record

Assigned_User_Name String True

Team_Id String False

Team ID for the account

Team_Set_Id String False

Acl_Team_Set_Id String False

Team_Count String False

Team_Name String False

Acl_Team_Names String True

Asset_Number String False

Asset tag number of sales item in use

Book_Value Decimal True

Book value of sales item in use

Book_Value_Date Date False

Date of book value for sales item in use

Date_Purchased Date False

Date sales item purchased

Date_Support_Expires Date False

Support expiration date

Date_Support_Starts Date False

Support start date

List_Price Decimal True

List price of sales item

Pricing_Factor Int True

Variable pricing factor depending on pricing_formula

Pricing_Formula String False

Pricing formula (ex: Fixed, Markup over Cost)

Quantity Decimal True

Quantity in use

Serial_Number String False

Serial number of sales item in use

Renewable Bool False

Indicates whether the sales item is renewable (e.g. a service)

Service Bool False

Indicates whether the sales item is a service or a product

Service_Duration_Value Int True

Value of the service duration, if service duration is 4 Months the value is 4

Service_Duration_Unit String False

Service Duration unit like Year(s), Month(s) or Day(s)

Catalog_Service_Duration_Value Int True

Stores a Product Catalog item's Service Duration Value, used for duration comparisons

Catalog_Service_Duration_Unit String True

Stores a Product Catalog item's Service Duration Unit, used for duration comparisons

Service_Duration_Multiplier Decimal True

Stores a multiplier based on the ratio of this sales item's duration to another duration (such as a Product Template's)

Service_End_Date String True

End date of the service

Service_Start_Date Date False

Start date of the service

Support_Contact String False

Contact for support purposes

Support_Description String False

Description of sales item for support purposes

Support_Name String False

Name of sales item for support purposes

Support_Term String False

Term (length) of support contract

Tax_Class String False

Tax classification (ex: Taxable, Non-taxable)

Vendor_Part_Num String False

Vendor part number

Website String False

Sales item URL

Weight Decimal True

Weight of the sales item

Renewal Bool True

Indicates whether this line item is a renewal

Currency_Id String False

Base_Rate String True

Currency_Name String True

Currency_Symbol String True

Denorm_Account_Name String False

Name of the Company

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839