ProductBundles
Stores records that represent bundled product groupings. This table supports multi-item pricing, quoting, and packaged sales offerings.
Columns
| Name | Type | ReadOnly | Description |
| Acl_Team_Names | String | True |
The list of team names that are associated with this product bundle record. These names determine which teams have visibility into the bundle as part of access control. |
| Acl_Team_Set_Id | String | False |
The identifier (Id) of the access control team set that is assigned to this product bundle. The team set defines the complete group of users and teams that are permitted to view or work with the bundle. |
| Base_Rate | String | False |
The currency base rate that is used when converting financial values in the product bundle to the system standard currency. |
| Bundle_Stage | String | False |
The current processing stage of the product bundle (for example, 'Draft'). This field indicates the workflow status or completion state of the bundle. |
| Created_By | String | True |
The Id of the user who created the product bundle record. |
| Currency_Id | String | False |
The Id of the currency that is assigned to this product bundle. |
| Currency_Name | String | True |
The display label of the currency that is assigned to this product bundle. |
| Currency_Symbol | String | True |
The symbol of the currency that is assigned to this product bundle. |
| Date_Entered | Datetime | True |
The date and time when the product bundle record was created. |
| Date_Modified | Datetime | True |
The date and time when the product bundle record was last modified. |
| Deal_Tot | Decimal | True |
The total discount amount that is applied to the product bundle before tax and shipping. |
| Deal_Tot_Usdollar | Decimal | True |
The discount amount that is converted to US dollars, based on the system currency conversion rate. |
| Default_Group | Bool | False |
A Boolean field that returns a value of 'true' when this product bundle is designated as the default bundle in the quote. It returns a value of 'false' when it is not designated as the default. |
| Deleted | Bool | False |
A Boolean field that returns a value of 'true' when the product bundle record is flagged as deleted. It returns a value of 'false' when the record remains active. |
| Description | String | False |
A text description that provides details or notes about the product bundle and its intended purpose. |
| Id [KEY] | String | True |
The unique Id of the product bundle record. |
| Modified_User_Id | String | True |
The Id of the user who last modified the product bundle record. |
| Name | String | False |
The name of the product bundle. This value identifies the bundle in quotes, product configuration workflows, and reporting. |
| New_Sub | Decimal | True |
The subtotal of the product bundle after discount, tax, and shipping are applied. |
| New_Sub_Usdollar | Decimal | True |
The subtotal value that is converted to US dollars. |
| Position | Int | True |
The numeric ordering value that determines the display sequence of this product bundle relative to other bundles in the quote. |
| Product_Bundle_Items | String | True |
The list of items that are included in this product bundle. Each item refers to a product, service, or bundle line component. |
| Shipping | Decimal | True |
The shipping charge that is applied to the product bundle. |
| Shipping_Usdollar | Decimal | True |
The shipping charge that is converted to US dollars. |
| Subtotal | Decimal | True |
The subtotal of the product bundle before tax and shipping charges are applied. |
| Subtotal_Usdollar | Decimal | True |
The subtotal value that is converted to US dollars. |
| Sync_Key | String | True |
An internal synchronization key that is used to align product bundle records across connected systems and integrations. |
| Tax | Decimal | True |
The tax amount that is applied to items in the product bundle. |
| Tax_Usdollar | Decimal | True |
The tax amount that is converted to US dollars. |
| Taxable_Subtotal | Decimal | True |
The subtotal of all items in the product bundle that are marked as taxable. |
| Taxrate_Id | String | False |
The Id of the tax rate that is applied to the product bundle. |
| Team_Count | String | False |
The number of teams that are associated with this product bundle record. |
| Team_Id | String | False |
The Id of the primary team that is associated with this product bundle. |
| Team_Name | String | False |
The display name of the primary team that is associated with this product bundle. |
| Team_Set_Id | String | False |
The Id of the complete set of teams that grant record access to the product bundle for visibility and collaboration. |
| Total | Decimal | True |
The final total amount for the product bundle after discount, tax, and shipping are calculated. |
| Total_Usdollar | Decimal | True |
The final total amount that is converted to US dollars. |