JDBC Driver for SugarCRM

Build 24.0.9062

ProductBundles

The ProductBundles table.

Columns

Name Type ReadOnly Description
Acl_Team_Names String True

Acl_Team_Set_Id String False

Base_Rate String False

Bundle_Stage String False

Processing stage of the group (ex: Draft)

Created_By String True

User who created record

Currency_Id String False

Currency_Name String True

Currency_Symbol String True

Date_Entered Datetime True

Date record created

Date_Modified Datetime True

Date record last modified

Deal_Tot Decimal True

discount amount

Deal_Tot_Usdollar Decimal True

discount amount

Default_Group Bool False

Deleted Bool False

Record deletion indicator

Description String False

Group description

Id [KEY] String True

Unique identifier

Modified_User_Id String True

User who last modified record

Name String False

Name of the group

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

Position Int True

Product_Bundle_Items String True

Shipping Decimal True

Shipping charge for group

Shipping_Usdollar Decimal True

Shipping charge for group in USD

Subtotal Decimal True

Group total minus tax and shipping

Subtotal_Usdollar Decimal True

Group total minus tax and shipping in USD

Sync_Key String True

Tax Decimal True

Tax rate applied to items in the group

Tax_Usdollar Decimal True

Total tax for all items in group in USD

Taxable_Subtotal Decimal True

Rollup of all products marked as Taxable

Taxrate_Id String False

Team_Count String False

Team_Id String False

Team ID for the account

Team_Name String False

Team_Set_Id String False

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

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