ProductBundles
The ProductBundles table.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | False |
Unique identifier |
| Deleted | Bool | False |
Record deletion indicator |
| Date_Entered | Datetime | False |
Date record created |
| Date_Modified | Datetime | False |
Date record last modified |
| Modified_User_Id | String | True |
User who last modified record |
| Created_By | String | True |
User who created record |
| Name | String | False |
Name of the group |
| Bundle_Stage | String | False |
Processing stage of the group (ex: Draft) |
| Description | String | False |
Group description |
| Taxrate_Id | String | False | |
| Tax | Decimal | True |
Tax rate applied to items in the group |
| Tax_Usdollar | Decimal | True |
Total tax for all items in group in USD |
| Total | Decimal | True |
Total amount for all items in the group |
| Total_Usdollar | Decimal | True |
Total amount for all items in the group in USD |
| Subtotal_Usdollar | Decimal | True |
Group total minus tax and shipping in USD |
| Shipping_Usdollar | Decimal | True |
Shipping charge for group in USD |
| Deal_Tot | Decimal | True |
discount amount |
| Deal_Tot_Usdollar | Decimal | True |
discount amount |
| New_Sub | Decimal | True |
Group total minus discount and tax and shipping |
| New_Sub_Usdollar | Decimal | True |
Group total minus discount and tax and shipping |
| Subtotal | Decimal | True |
Group total minus tax and shipping |
| Taxable_Subtotal | Decimal | True |
Rollup of all products marked as Taxable |
| Shipping | Decimal | True |
Shipping charge for group |
| Product_Bundle_Items | String | True | |
| Position | Int | True | |
| Default_Group | Bool | False | |
| Sync_Key | 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 | |
| Currency_Id | String | False | |
| Base_Rate | String | False | |
| Currency_Name | String | True | |
| Currency_Symbol | String | True |