Commerce
BCBindingExt
Extension over the BCBinding DAC that keeps additional information for the store. The extension is created together with BCBinding.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AllowOrderEdit | bit | Allow 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 | int | Store | BCBinding | |
Description:The record identity. | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | Created At | - | |
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
CustomerClassID | nvarchar(10) | Customer Class | CustomerClass | |
Description:Customer class used for creation of new customers on customer import. | ||||
CustomerNumberingID | nvarchar(10) | Customer Numbering Sequence | Numbering | |
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. | ||||
DefaultTaxZoneID | nvarchar | Default Tax Zone | TaxZone | |
Description:Tax zone that should be used for the taxes synchronization if the tax zone cannot be resolved by Acumatica ERP logic. | ||||
GiftCertificateItemID | int | Gift Certificate Item | InventoryItem | |
Description:Item that should be used to created a gift certificate. | ||||
GiftWrappingItemID | int | Gift Wrapping Item | InventoryItem | |
Description:Item that should used to create the gift wrapping. | ||||
GuestCustomerID | int | Generic Guest Customer | Customer | |
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 | bit | Import Order Risks | - | |
Description:Whether to import order risks or not. | ||||
InventoryNumberingID | nvarchar(10) | Inventory Numbering Sequence | Numbering | |
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. | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | Last Modified At | - | |
Description:No description available | ||||
LastModifiedDateTime | datetime | Last Modified On | - | |
Description:No description available | ||||
LocationNumberingID | nvarchar(10) | Location Numbering Sequence | Numbering | |
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 | bit | Use 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. | ||||
NonStockItemClassID | int | Item Class for Non-Stock Items | INItemClass | |
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. | ||||
OrderType | char(2) | Order Type for Import | SOOrderType | |
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. | ||||
PaymentTermsListID | nvarchar(25) | Payment Terms | SYSubstitution | |
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. | ||||
ProductItemClassSubstitutionListID | nvarchar(25) | Substitution List for Item Classes | SYSubstitution | |
Description:The ID of the substitution list to use when substituting item class during product import. | ||||
ReasonCode | nvarchar | Refund Reason Code | ReasonCode | |
Description:The reason code to use when importing refunds. | ||||
RefundAmountItemID | int | Refund Amount Item | InventoryItem | |
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. | ||||
ReturnOrderType | char(2) | Return Order Type | SOOrderType | |
Description:Return order type that should be created. | ||||
ShippingCarrierListID | nvarchar(25) | Shipping Carriers | SYSubstitution | |
Description:The ID of the substitution list to use when substituting ShipVia during shipment export. | ||||
StockItemClassID | int | Item Class for Stock Items | INItemClass | |
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 | bit | Tag Ext. Order with ERP Order Nbr. | - | |
Description:Whether to sync the order number to the store. | ||||
SyncOrdersFrom | datetime | Earliest Order Date | - | |
Description:The earliest order date to sync orders, earlier orders are skipped. | ||||
TaxCategorySubstitutionListID | nvarchar(25) | Tax Categories | SYSubstitution | |
Description:The ID of the substitution list to use when substituting tax categories during order import. | ||||
TaxSubstitutionListID | nvarchar(25) | Taxes | SYSubstitution | |
Description:The ID of the substitution list to use when substituting tax categories during order import. | ||||
TaxSynchronization | bit | Tax Synchronization | - | |
Description:Mode of the tax synchronization. Describes how the taxes are created for a sales order during its import. | ||||
UseAsPrimaryTaxZone | bit | Use as Primary Tax Zone | - | |
Description:Definition of whether DefaultTaxZoneID should always be used for creation of a sales order. | ||||
UseExternalCurrencyForOrderImport | bit | Import 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 | ||||