InventoryApiGetSourcesAssignedToStockOrderedByPriority
InventoryApiGetSourcesAssignedToStockOrderedByPriority is an auto generated table
Table Specific Information
Select
The connector uses the AdobeCommerce API to filter the results by StockId while the rest of the filter is executed client side within the connector.
You must specify the StockId column in the WHERE clause to retrieve results from InventoryApiGetSourcesAssignedToStockOrderedByPriority. StockId can be used only with the equals (=) operator.
For example:
SELECT * FROM [InventoryApiGetSourcesAssignedToStockOrderedByPriority] WHERE StockId = '123'
Columns
| Name | Type | Description |
| CarrierLinks | String | This is an auto-generated column |
| StockId | String | stockId |
| City | String | Source city |
| ContactName | String | Source contact name |
| CountryId | String | Source country id |
| Description | String | Source description |
| String | Source email | |
| Enabled | Bool | If source is enabled. For new entity can be null |
| ExtensionAttributes | String | This is an auto-generated column |
| Fax | String | Source fax |
| Latitude | Double | Source latitude |
| Longitude | Double | Source longitude |
| Name | String | Source name |
| Phone | String | Source phone number |
| Postcode | String | Source post code |
| Region | String | Region title if source has custom region |
| RegionId | Int | Region id if source has registered region. |
| SourceCode | String | Source code |
| Street | String | Source street name |
| UseDefaultCarrierConfig | Bool | Is need to use default config |