ODBC Driver for SugarCRM

Build 24.0.9062

ProductTemplates

The ProductTemplates table.

Columns

Name Type ReadOnly Description
Acl_Team_Names String True

Acl_Team_Set_Id String False

Active_Status String False

Active status (ex: Active, Inactive or Retired)

Assigned_User_Id String False

User ID assigned to record

Assigned_User_Name String True

Base_Rate String False

Category_Id String False

Category of the product

Category_Name String True

Commentlog String True

Cost_Price Decimal False

Product cost (

Cost_Usdollar Decimal True

Cost expressed in USD

Created_By String True

User who created record

Created_By_Name String True

Currency_Id String False

Currency_Name String True

Currency_Symbol String True

Date_Available Date False

Availability date

Date_Cost_Price Date False

Starting date cost price is valid

Date_Entered Datetime True

Date record created

Date_Modified Datetime True

Date record last modified

Deleted Bool False

Record deletion indicator

Description String False

Full text of the note

Discount_Price Decimal False

Discounted price (

Discount_Usdollar Decimal True

Discount price expressed in USD

Following Bool False

Is user following this record

Id [KEY] String True

Unique identifier

List_Price Decimal False

List price of product (

List_Usdollar Decimal True

List price expressed in USD

Lock_Duration Bool False

Indicates whether the duration can be manually changed

Locked_Fields String True

Manufacturer_Id String False

Manufacturer of the product

Manufacturer_Name String True

Mft_Part_Num String False

Manufacturer part number

Modified_By_Name String True

Modified_User_Id String True

User who last modified record

My_Favorite Bool False

Favorite for the user

Name String False

Pricing_Factor Decimal True

Variable pricing factor depending on pricing_formula

Pricing_Formula String True

Pricing formula (ex: Fixed, Markup over Cost)

Qty_In_Stock Int True

Quantity on hand

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_Unit String False

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

Service_Duration_Value Int True

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

Status String False

Product status (not used in product Catalog)

Support_Contact String False

Contact for support purposes

Support_Description String False

Description of product for support purposes

Support_Name String False

Name of product for support purposes

Support_Term String False

Term (length) of support contract

Sync_Key String True

Tag String False

Tax_Class String False

Tax classification (ex: Taxable, Non-taxable)

Team_Count String False

Team_Id String False

Team ID for the account

Team_Name String False

Team_Set_Id String False

Type_Id String False

Product type (ex: hardware, software)

Type_Name String True

Vendor_Part_Num String False

Vendor part number

Website String False

Product URL

Weight Decimal True

Weight of the product

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