Skip to main content
Commerce

BCBindingExt

PX.Commerce.ObjectsRelease 2025.2

Extension over the BCBinding DAC that keeps additional information for the store. The extension is created together with BCBinding.

Field NameTypeDisplay NameForeign Key
AllowOrderEdit
bitAllow Adding Items to Processed Orders-
Description:Indicates whether adding items to processed orders is allowed.
Availability
varchar(1)Default Availability-
Description:Purchase availability settings of the item that are assigned during the item export.
AvailabilityCalcRule
nvarchar(1)Availability Mode-
Description:Specifies which value to use when exporting product availability, available, available for shipping, or on hand.
BindingID
intStoreBCBinding
Description:The record identity.
CreatedByIDDefault Navigation
uniqueidentifierCreated ByUsers
Description:No description available
CreatedByScreenID
char(8)Created At-
Description:No description available
CreatedDateTime
datetimeCreated On-
Description:No description available
CustomerClassIDDefault Navigation
nvarchar(10)Customer ClassCustomerClass
Description:Customer class used for creation of new customers on customer import.
CustomerNumberingIDDefault Navigation
nvarchar(10)Customer Numbering SequenceNumbering
Description:Numbering sequence used to generate new customer IDs on customer import. The field is mandatory for the Customer Processor.
CustomerTemplate
nvarchar(30)Customer Numbering Template-
Description:The template of the customer numbering for imported customers.
DefaultStoreCurrency
nvarchar(12)Default Currency-
Description:The default currency for this store.
DefaultTaxZoneIDDefault Navigation
nvarcharDefault Tax ZoneTaxZone
Description:Tax zone that should be used for the taxes synchronization if the tax zone cannot be resolved by Acumatica ERP logic.
GiftCertificateItemIDDefault Navigation
intGift Certificate ItemInventoryItem
Description:Item that should be used to created a gift certificate.
GiftWrappingItemIDDefault Navigation
intGift Wrapping ItemInventoryItem
Description:Item that should used to create the gift wrapping.
GuestCustomerIDDefault Navigation
intGeneric Guest CustomerCustomer
Description:ID of the customer account used for synchronization of orders created by a guest user in eCommerce.
HoldOnRiskStatus
nvarchar(1)Hold on Risk Status-
Description:The risk level at which orders should be put on hold, either medium to high or high.
ImportOrderRisks
bitImport Order Risks-
Description:Whether to import order risks or not.
InventoryNumberingIDDefault Navigation
nvarchar(10)Inventory Numbering SequenceNumbering
Description:Numbering sequence used to generate new inventory IDs.
InventoryTemplate
nvarchar(30)Inventory Numbering Template-
Description:The template of the inventory numbering for imported inventory items.
LastModifiedByIDDefault Navigation
uniqueidentifierLast Modified ByUsers
Description:No description available
LastModifiedByScreenID
char(8)Last Modified At-
Description:No description available
LastModifiedDateTime
datetimeLast Modified On-
Description:No description available
LocationNumberingIDDefault Navigation
nvarchar(10)Location Numbering SequenceNumbering
Description:Numbering sequence used to generate new location IDs on location import. The field is mandatory for the Location Processor.
LocationTemplate
nvarchar(30)Location Numbering Template-
Description:The template of the customer numbering for imported locations.
MultipleGuestAccounts
bitUse Multiple Guest Accounts-
Description:Indicates if the multiple guest accounts feature is enabled. This setting automatically creates a new guest account when the current one reaches 10,000 or more orders.
NonStockItemClassIDDefault Navigation
intItem Class for Non-Stock ItemsINItemClass
Description:Inventory class used for creation of new non-stock items on non-stock item import.
NonStockSalesCategoriesIDs
nvarchar(100)Default Non-Stock Categories-
Description:Sales category to be used for exporting non-stock items when no category is specified for them.
NotAvailMode
varchar(1)When Qty Unavailable-
Description:Description of what the store should do when inventory runs out of the item. The value is assigned during the item export.
OrderTimeZone
nvarchar(32)Order Time Zone-
Description:The time zone at which the store is located and the orders are placed.
OrderTypeDefault Navigation
char(2)Order Type for ImportSOOrderType
Description:Type of an order that should be used for export and import.
OtherSalesOrderTypes
nvarchar(100)Order Types for Export-
Description:Additional order types that should be fetched during export.
PaymentTermsListIDDefault Navigation
nvarchar(25)Payment TermsSYSubstitution
Description:The ID of the substitution list used to map "payment_terms" from external order.
PostDiscounts
nvarchar(1)Show Discounts As-
Description:The method of posting discounts, either on the document level, or the order line level.
ProductItemClassSubstitutionListIDDefault Navigation
nvarchar(25)Substitution List for Item ClassesSYSubstitution
Description:The ID of the substitution list to use when substituting item class during product import.
ReasonCodeDefault Navigation
nvarcharRefund Reason CodeReasonCode
Description:The reason code to use when importing refunds.
RefundAmountItemIDDefault Navigation
intRefund Amount ItemInventoryItem
Description:Item that should be used to create refund items.
RelatedItems
nvarchar(50)Related Items-
Description:Type of relations that should be specified during the item export.
ReturnOrderTypeDefault Navigation
char(2)Return Order TypeSOOrderType
Description:Return order type that should be created.
ShippingCarrierListIDDefault Navigation
nvarchar(25)Shipping CarriersSYSubstitution
Description:The ID of the substitution list to use when substituting ShipVia during shipment export.
StockItemClassIDDefault Navigation
intItem Class for Stock ItemsINItemClass
Description:Inventory class used for creation of new stock items on stock item import.
StockSalesCategoriesIDs
nvarchar(100)Default Stock Categories-
Description:Sales categories to be used for exporting stock items when no category is specified for them.
StoreTimeZone
nvarchar(100)Store Time Zone-
Description:The time zone for this store.
SupportedCurrencies
nvarchar(200)Supported Currencies-
Description:A comma-separated list of the supported currencies for this store.
SyncOrderNbrToStore
bitTag Ext. Order with ERP Order Nbr.-
Description:Whether to sync the order number to the store.
SyncOrdersFrom
datetimeEarliest Order Date-
Description:The earliest order date to sync orders, earlier orders are skipped.
TaxCategorySubstitutionListIDDefault Navigation
nvarchar(25)Tax CategoriesSYSubstitution
Description:The ID of the substitution list to use when substituting tax categories during order import.
TaxSubstitutionListIDDefault Navigation
nvarchar(25)TaxesSYSubstitution
Description:The ID of the substitution list to use when substituting tax categories during order import.
TaxSynchronization
bitTax Synchronization-
Description:Mode of the tax synchronization. Describes how the taxes are created for a sales order during its import.
UseAsPrimaryTaxZone
bitUse as Primary Tax Zone-
Description:Definition of whether DefaultTaxZoneID should always be used for creation of a sales order.
UseExternalCurrencyForOrderImport
bitImport in External Default Currency-
Description:Indicates whether import order should use external default currency.
Visibility
varchar(1)Default Visibility-
Description:Item visibility settings assigned during the item export.
WarehouseMode
nvarchar(1)Warehouse Mode-
Description:Specifies which warehouse to use when exporting product availability, all warehouses or specific warehouses.
tstamp
timestamp-
Description:No description available