Skip to main content
Commerce

BCBindingAmazon

PX.Commerce.AmazonRelease 2025.2

Amazon store settings

Field NameTypeDisplay NameForeign Key
AmazonFulfilledOrderTypeDefault Navigation
char(2)Marketplace-Fulfilled Order TypeSOOrderType
Description:The type of the document, which is used for FBA orders.
AmazonReturnOrderTypeDefault Navigation
char(2)Marketplace-Fulfilled Return TypeSOOrderType
Description:Amazon-Fulfilled Return order type that should be created.
BindingID
intStoreBCBinding
Description:The primary key and identity of the binding.
CarriersToShipViaCodesDefault Navigation
nvarchar(25)Ship-Via Codes to CarriersSYSubstitution
Description:The substitution list will be used by the user to define the mapping between Amazon (Carrier) and the ERP (Ship Via).
CreatedByIDDefault Navigation
uniqueidentifierCreated ByUsers
Description:No description available
CreatedByScreenID
char(8)Created At-
Description:No description available
CreatedDateTime
datetimeCreated On-
Description:No description available
EarliestShipmentDate
datetimeEarliest Shipment Date-
Description:The earliest Inbound Shipment creations date in Amazon Seller Portal
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
LocationIDDefault Navigation
intMarketplace Warehouse LocationINLocation
Description:The warehouse location that has been set from where the inventory will be reduced when marketplace invoices are released for FBA Orders
Marketplace API
nvarchar(100)Marketplace-
Description:Marketplace where selling partners authorizes the application
RefreshToken API
nvarcharRefresh Token-
Description:It's longed live token to exchange Access Token
Region API
nvarchar(100)Region-
Description:AWS region
ReleaseInvoices
bitRelease Invoices-
Description:Release Invoices
ReturnChargeItemDefault Navigation
intCharge ItemInventoryItem
Description:Item that should be used for refund charges.
SellerFulfilledOrderTypeDefault Navigation
char(2)Seller-Fulfilled Order TypeSOOrderType
Description:The type of the document, which is used for FBM orders.
SellerPartnerId API
nvarcharSeller Partner ID-
Description:The identifier of the selling partner who is authorizing your application.
SellerReturnOrderTypeDefault Navigation
char(2)Seller-Fulfilled Return TypeSOOrderType
Description:Seller-Fulfilled Return order type that should be created.
SettlementReportStartDate
datetimeEarliest Report Date-
Description:Stores the earliest Date the settlement report should be fetched.
ShipViaCodesToCarrierServicesDefault Navigation
nvarchar(25)Ship Via Codes to Carrier ServicesSYSubstitution
Description:The substitution list will be used by the user to define the mapping between the ERP (Ship Via) and Amazon (Carrier Service).
ShipViaCodesToCarriersDefault Navigation
nvarchar(25)Ship Via Codes to CarriersSYSubstitution
Description:The substitution list will be used by the user to define the mapping between the ERP (Ship Via) and Amazon (Carrier).
ShippingAccountDefault Navigation
intShipping AccountAccount
Description:The shippingAccount will be used for shipping line in FBA
ShippingPriceItemDefault Navigation
intShipping Price ItemInventoryItem
Description:Item that should used for shipping.
ShippingSubAccountDefault Navigation
intShipping SubaccountSub
Description:The Shipping Subaccount will be used for shipping line in FBA
SourceWarehouseDefault Navigation
intSource WarehouseINSite
Description:The warehouse will be used for items in the FBA shipments lines
TransferOrderTypeDefault Navigation
char(2)Order Type for ImportSOOrderType
Description:Transfer order type that will be used to import FBA Inbound Shipments to ERP
WarehouseDefault Navigation
intMarketplace WarehouseINSite
Description:The warehouse will be used for items in the FBA orders
tstamp
timestamp-
Description:No description available