ProductTemplates
The ProductTemplates table.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | False |
Unique identifier |
| Name | String | False | |
| 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 |
| Type_Id | String | False |
Product type (ex: hardware, software) |
| Manufacturer_Id | String | False |
Manufacturer of the product |
| Manufacturer_Name | String | True | |
| Category_Id | String | False |
Category of the product |
| Category_Name | String | True | |
| Type_Name | String | True | |
| Mft_Part_Num | String | False |
Manufacturer part number |
| Vendor_Part_Num | String | False |
Vendor part number |
| Date_Cost_Price | Date | False |
Starting date cost price is valid |
| Cost_Price | Decimal | False |
Product cost ( |
| Discount_Price | Decimal | False |
Discounted price ( |
| List_Price | Decimal | False |
List price of product ( |
| 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 (not used in product Catalog) |
| Tax_Class | String | False |
Tax classification (ex: Taxable, Non-taxable) |
| Active_Status | String | False |
Active status (ex: Active, Inactive or Retired) |
| Date_Available | Date | False |
Availability date |
| Website | String | False |
Product URL |
| Weight | Decimal | True |
Weight of the product |
| Qty_In_Stock | Int | True |
Quantity on hand |
| Support_Name | String | False |
Name of product for support purposes |
| Support_Description | String | False |
Description of product for support purposes |
| Support_Contact | String | False |
Contact for support purposes |
| Support_Term | String | False |
Term (length) of support contract |
| Pricing_Formula | String | True |
Pricing formula (ex: Fixed, Markup over Cost) |
| Pricing_Factor | Decimal | True |
Variable pricing factor depending on pricing_formula |
| 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) |
| 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 |
| Lock_Duration | Bool | False |
Indicates whether the duration can be manually changed |
| 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 | |
| Currency_Id | String | False | |
| Base_Rate | String | False | |
| Currency_Name | String | True | |
| Currency_Symbol | 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 |