Adobe Commerce Connector Objects
This feature is a Beta Service. A customer may opt to try a Beta Service in its sole discretion. Any use of the Beta Service is subject to the applicable Beta Services Terms provided at Agreements and Terms. If you have questions or feedback about this Beta Service, contact the Data 360 Connector team at datacloud-connectors-beta@salesforce.com.
| Name | Description |
|---|---|
| AdobeStockAssetApiAsset | AdobeStockAssetApiAsset is an auto generated table |
| AdobeStockAssetApiGetAssetList | AdobeStockAssetApiGetAssetList is an auto generated table |
| AdobeStockImageApiGetImageList | AdobeStockImageApiGetImageList is an auto generated table |
| AnalyticsLinkProvider | AnalyticsLinkProvider is an auto generated table |
| AsynchronousOperationsBulkStatus | AsynchronousOperationsBulkStatus is an auto generated table |
| AsynchronousOperationsOperation | AsynchronousOperationsOperation is an auto generated table |
| BillingAddresses | BillingAddresses is an auto-generated table. The supported operations are Querying data from this table. |
| BundleProductLinkChildren | BundleProductLinkChildren is an auto generated table. The supported operations are Querying data from this table. |
| BundleProductOption | BundleProductOption is an auto generated table. The supported operations are Delete, and Querying data from this table. |
| CatalogAttributeSet | CatalogAttributeSet is an auto generated table. The supported operations are Update, Delete, and Querying data from this table. |
| CatalogCategoryAttribute | CatalogCategoryAttribute is an auto generated table. The supported operations are Querying data from this table. |
| CatalogCategoryAttributeOptionOptions | CatalogCategoryAttributeOptionOptions is an auto generated table. The supported operations are Querying data from this table. |
| CatalogCategoryLinkProducts | CatalogCategoryLinkProducts is an auto generated table. The supported operations are Querying data from this table. |
| CatalogCategoryList | CatalogCategoryList is an auto generated table |
| CatalogProductAttribute | CatalogProductAttribute is an auto generated table. The supported operations are Insert, Update, Delete, and Querying data from this table. |
| CatalogProductAttributeTypesList | CatalogProductAttributeTypesList is an auto generated table. The supported operations are Querying data from this table. |
| CatalogProductLinkTypeList | CatalogProductLinkTypeList is an auto generated table. The supported operations are Querying data from this table. |
| CatalogProductRenderList | CatalogProductRenderList is an auto generated table |
| CatalogProductTierPriceTiers | CatalogProductTierPriceTiers is an auto generated table. The supported operations are Querying data from this table. |
| CatalogProductTypeList | CatalogProductTypeList is an auto generated table. The supported operations are Querying data from this table. |
| CheckoutAgreementsCheckoutAgreements | CheckoutAgreementsCheckoutAgreements is an auto generated table. The supported operations are Querying data from this table. |
| CheckoutAgreementsCheckoutAgreementsList | CheckoutAgreementsCheckoutAgreementsList is an auto generated table |
| CmsBlock | CmsBlock is an auto generated table. The supported operations are Insert, Update, Delete, and Querying data from this table. |
| CmsPage | CmsPage is an auto generated table. The supported operations are Insert, Update, Delete, and Querying data from this table. |
| ConfigurableProductLinkChildren | ConfigurableProductLinkChildren is an auto generated table. The supported operations are Querying data from this table. |
| ConfigurableProductOption | ConfigurableProductOption is an auto generated table. The supported operations are Insert, Update, Delete, and Querying data from this table. |
| CustomerAccountBillingAddress | CustomerAccountBillingAddress is an auto generated table. The supported operations are Querying data from this table. |
| CustomerAccountShippingAddress | CustomerAccountShippingAddress is an auto generated table. The supported operations are Querying data from this table. |
| CustomerAddress | CustomerAddress is an auto generated table. The supported operations are Delete, and Querying data from this table. |
| CustomerGroup | CustomerGroup is an auto generated table. The supported operations are Insert, Update, Delete, and Querying data from this table. |
| CustomerGroupDefault | CustomerGroupDefault is an auto generated table. The supported operations are Querying data from this table. |
| Customers | Customers is an auto generated table. The supported operations are Update, Delete, and Querying data from this table. |
| DirectoryCountryInformationAcquirer | DirectoryCountryInformationAcquirer is an auto generated table. The supported operations are Querying data from this table. |
| DirectoryCurrencyInformationAcquirer | DirectoryCurrencyInformationAcquirer is an auto generated table. The supported operations are Querying data from this table. |
| DownloadableLink | DownloadableLink is an auto generated table. The supported operations are Insert, Update, Delete, and Querying data from this table. |
| DownloadableSample | DownloadableSample is an auto generated table. The supported operations are Insert, Update, Delete, and Querying data from this table. |
| EavAttributeSet | EavAttributeSet is an auto generated table. The supported operations are Update, Delete, and Querying data from this table. |
| GiftMessageCart | GiftMessageCart is an auto generated table. The supported operations are Insert, and Querying data from this table. |
| GiftMessageGuestCart | GiftMessageGuestCart is an auto generated table. The supported operations are Insert, and Querying data from this table. |
| GiftMessageGuestItem | GiftMessageGuestItem is an auto generated table. The supported operations are Insert, and Querying data from this table. |
| GiftMessageItem | GiftMessageItem is an auto generated table. The supported operations are Insert, and Querying data from this table. |
| GuestBillingAddresses | GuestBillingAddresses is an auto generated table. The supported operations are Insert, and Querying data from this table. |
| GuestPaymentInformation | GuestPaymentInformation is an auto generated table. The supported operations are Querying data from this table. |
| GuestPaymentMethods | GuestPaymentMethods is an auto generated table. The supported operations are Querying data from this table. |
| GuestPaymentSelectedMethods | GuestPaymentSelectedMethods is an auto generated table. The supported operations are Querying data from this table. |
| GuestShippingMethods | GuestShippingMethods is an auto generated table. The supported operations are Querying data from this table. |
| Inventory | Inventory is an auto generated table. The supported operations are Update, and Querying data from this table. |
| InventoryApiGetSourcesAssignedToStockOrderedByPriority | InventoryApiGetSourcesAssignedToStockOrderedByPriority is an auto generated table |
| InventoryApiGetStockSourceLinks | InventoryApiGetStockSourceLinks is an auto generated table |
| InventoryApiSource | InventoryApiSource is an auto generated table |
| InventoryApiSourceItem | InventoryApiSourceItem is an auto generated table |
| InventoryApiStock | InventoryApiStock is an auto generated table |
| OrderComments | OrderComments is an auto generated table. The supported operations are Insert, and Querying data from this table. |
| OrderItems | OrderItems is an auto generated table. The supported operations are Querying data from this table. |
| Orders | Orders is an auto generated table. The supported operations are Insert, Update, and Querying data from this table. |
| PaymentMethods | PaymentMethods is an auto generated table. The supported operations are Querying data from this table. |
| PaymentSelectedMethods | PaymentSelectedMethods is an auto generated table. The supported operations are Querying data from this table. |
| PayPalBraintreeAuth | PayPalBraintreeAuth is an auto generated table |
| ProductAttributeGroup | ProductAttributeGroup is an auto generated table. The supported operations are Insert, Update, Delete, and Querying data from this table. |
| ProductAttributeOptions | ProductAttributeOptions is an auto generated table. The supported operations are Insert, Delete, and Querying data from this table. |
| ProductAttributes | ProductAttributes is an auto generated table. The supported operations are Querying data from this table. |
| ProductCategories | ProductCategories is an auto generated table. The supported operations are Insert, Update, Delete, and Querying data from this table. |
| ProductCustomOption | ProductCustomOption is an auto generated table. The supported operations are Insert, Update, Delete, and Querying data from this table. |
| ProductMedia | ProductMedia is an auto generated table. The supported operations are Insert, Update, Delete, and Querying data from this table. |
| Products | Products is an auto generated table. The supported operations are Insert, Update, Delete, and Querying data from this table. |
| QuoteCart | QuoteCart is an auto generated table. The supported operations are Update, and Querying data from this table. |
| QuoteCartItem | QuoteCartItem is an auto generated table. The supported operations are Insert, Update, Delete, and Querying data from this table. |
| QuoteCartTotal | QuoteCartTotal is an auto generated table. The supported operations are Querying data from this table. |
| QuoteGuestCart | QuoteGuestCart is an auto generated table. The supported operations are Querying data from this table. |
| QuoteGuestCartItem | QuoteGuestCartItem is an auto generated table. The supported operations are Insert, Update, Delete, and Querying data from this table. |
| QuoteGuestCartTotal | QuoteGuestCartTotal is an auto generated table. The supported operations are Querying data from this table. |
| SalesCreditmemo | SalesCreditmemo is an auto generated table. The supported operations are Insert, and Querying data from this table. |
| SalesCreditmemoComments | SalesCreditmemoComments is an auto generated table. The supported operations are Insert, and Querying data from this table. |
| SalesInvoice | SalesInvoice is an auto generated table. The supported operations are Insert, and Querying data from this table. |
| SalesInvoiceComments | SalesInvoiceComments is an auto generated table. The supported operations are Insert, and Querying data from this table. |
| SalesRule | SalesRule is an auto generated table. The supported operations are Insert, Update, Delete, and Querying data from this table. |
| SalesRuleCoupon | SalesRuleCoupon is an auto generated table. The supported operations are Insert, Update, Delete, and Querying data from this table. |
| SalesShipment | SalesShipment is an auto generated table. The supported operations are Insert, and Querying data from this table. |
| SalesShipmentComments | SalesShipmentComments is an auto generated table. The supported operations are Insert, and Querying data from this table. |
| SalesTransaction | SalesTransaction is an auto generated table. The supported operations are Querying data from this table. |
| ShippingMethods | ShippingMethods is an auto generated table. The supported operations are Querying data from this table. |
| StoreGroup | StoreGroup is an auto generated table. The supported operations are Querying data from this table. |
| Stores | Stores is an auto generated table. The supported operations are Querying data from this table. |
| StoreWebsite | StoreWebsite is an auto generated table. The supported operations are Querying data from this table. |
| TaxClass | TaxClass is an auto generated table. The supported operations are Insert, Update, Delete, and Querying data from this table. |
| TaxRate | TaxRate is an auto generated table. The supported operations are Insert, Update, Delete, and Querying data from this table. |
| TaxRule | TaxRule is an auto generated table. The supported operations are Insert, Update, Delete, and Querying data from this table. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Int | False | No | ID | |
| Category | String | False | No | This is an auto-generated column | |
| CategoryId | Int | False | No | Category | |
| CreationDate | String | False | No | Creation date | |
| Creator | String | False | No | This is an auto-generated column | |
| CreatorId | Int | False | No | The creator | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| IsLicensed | Int | False | No | Licensed | |
| MediaGalleryId | Int | False | No | Media gallery asset id | |
| SearchCriteria | String | False | No | This is an auto-generated column | |
| TotalCount | Int | False | No | Total count. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Int | False | No | This is an auto-generated column | |
| Aggregations | String | False | No | This is an auto-generated column | |
| SearchCriteria | String | False | No | This is an auto-generated column | |
| TotalCount | Int | False | No | Total count. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Int | False | No | This is an auto-generated column | |
| Aggregations | String | False | No | This is an auto-generated column | |
| SearchCriteria | String | False | No | This is an auto-generated column | |
| TotalCount | Int | False | No | Total count. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| InitializationVector | String | False | No | This is an auto-generated column | |
| Url | String | False | No | This is an auto-generated column |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| BulkId | String | False | No | Bulk uuid | |
| BulkUuid | String | False | No | bulkUuid | |
| Description | String | False | No | Bulk description | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| OperationCount | Int | False | No | Total number of operations scheduled in scope of this bulk | |
| OperationsList | String | False | No | Operations list. | |
| StartTime | String | False | No | Bulk scheduled time | |
| UserId | Int | False | No | User id | |
| UserType | Int | False | No | User type |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Int | False | No | Id | |
| BulkUuid | String | False | No | Bulk uuid | |
| ErrorCode | Int | False | No | Error code | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| ResultMessage | String | False | No | Result message | |
| ResultSerializedData | String | False | No | Serialized Data | |
| SearchCriteria | String | False | No | This is an auto-generated column | |
| SerializedData | String | False | No | Data | |
| Status | Int | False | No | Operation status | |
| TopicName | String | False | No | Queue Topic | |
| TotalCount | Int | False | No | Total count. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Int | False | No | Id | |
| CartId | String | False | No | cartId | |
| City | String | False | No | City name | |
| Company | String | False | No | Company | |
| CountryId | String | False | No | Country id | |
| CustomerAddressId | Int | False | No | Customer address id | |
| CustomerId | Int | False | No | Customer id | |
| String | False | No | Billing/shipping email | ||
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| Fax | String | False | No | Fax number | |
| Firstname | String | False | No | First name | |
| Lastname | String | False | No | Last name | |
| Middlename | String | False | No | Middle name | |
| Postcode | String | False | No | Postcode | |
| Prefix | String | False | No | Prefix | |
| Region | String | False | No | Region name | |
| RegionCode | String | False | No | Region code | |
| RegionId | Int | False | No | Region id | |
| SameAsBilling | Int | False | No | Same as billing flag | |
| SaveInAddressBook | Int | False | No | Save in address book flag | |
| Street | String | False | No | Street | |
| Suffix | String | False | No | Suffix | |
| Telephone | String | False | No | Telephone number | |
| VatId | String | False | No | Vat id |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | False | No | The identifier | |
| ProductSku | String | False | No | productSku | |
| CanChangeQuantity | Int | False | No | Whether quantity could be changed | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| IsDefault | Bool | False | No | Is default | |
| OptionId | Int | False | No | Option id | |
| Position | Int | False | No | Position | |
| Price | Double | False | No | Price | |
| PriceType | Int | False | No | Price type | |
| Qty | Double | False | No | Qty | |
| Sku | String | False | No | Linked product sku |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| OptionId [KEY] | Int | False | No | Option id | |
| Position | Int | False | No | Option position | |
| ProductLinks | String | False | No | Product links | |
| Required | Bool | False | No | Is required option | |
| Sku [KEY] | String | False | No | Product sku | |
| Title | String | False | No | Option title | |
| Type | String | False | No | Input type |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| AttributeSetId [KEY] | Int | False | No | Attribute set ID | |
| AttributeSetName | String | False | No | Attribute set name | |
| EntityTypeId | Int | False | No | Attribute set entity type id | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| SearchCriteria | String | False | No | This is an auto-generated column | |
| SortOrder | Int | False | No | Attribute set sort order index | |
| TotalCount | Int | False | No | Total count. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| ApplyTo | String | False | No | Apply to value for the element | |
| AttributeCode | String | False | No | Code of the attribute. | |
| AttributeId [KEY] | Int | False | No | Id of the attribute. | |
| BackendModel | String | False | No | Backend model | |
| BackendType | String | False | No | Backend type. | |
| DefaultFrontendLabel | String | False | No | Frontend label for default store | |
| DefaultValue | String | False | No | Default value for the element. | |
| EntityTypeId | String | False | No | Entity type id | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| FrontendClass | String | False | No | Frontend class of attribute | |
| FrontendInput | String | False | No | HTML for input element. | |
| FrontendLabels | String | False | No | Frontend label for each store | |
| IsComparable | String | False | No | The attribute can be compared on the frontend | |
| IsFilterable | Bool | False | No | It used in layered navigation | |
| IsFilterableInGrid | Bool | False | No | It is filterable in catalog product grid | |
| IsFilterableInSearch | Bool | False | No | It is used in search results layered navigation | |
| IsHtmlAllowedOnFront | Bool | False | No | The HTML tags are allowed on the frontend | |
| IsRequired | Bool | False | No | Attribute is required. | |
| IsSearchable | String | False | No | The attribute can be used in Quick Search | |
| IsUnique | String | False | No | This is a unique attribute | |
| IsUsedForPromoRules | String | False | No | The attribute can be used for promo rules | |
| IsUsedInGrid | Bool | False | No | It is used in catalog product grid | |
| IsUserDefined | Bool | False | No | Current attribute has been defined by a user. | |
| IsVisible | Bool | False | No | Attribute is visible on frontend. | |
| IsVisibleInAdvancedSearch | String | False | No | The attribute can be used in Advanced Search | |
| IsVisibleInGrid | Bool | False | No | It is visible in catalog product grid | |
| IsVisibleOnFront | String | False | No | The attribute is visible on the frontend | |
| IsWysiwygEnabled | Bool | False | No | WYSIWYG flag | |
| Note | String | False | No | The note attribute for the element. | |
| Options | String | False | No | Options of the attribute (key => value pairs for select) | |
| Position | Int | False | No | Position | |
| Scope | String | False | No | Attribute scope | |
| SearchCriteria | String | False | No | This is an auto-generated column | |
| SourceModel | String | False | No | Source model | |
| TotalCount | Int | False | No | Total count. | |
| UsedForSortBy | Bool | False | No | It is used for sorting in product listing | |
| UsedInProductListing | String | False | No | The attribute can be used in product listing | |
| ValidationRules | String | False | No | Validation rules. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| IsDefault | Bool | False | No | Default | |
| AttributeCode | String | False | No | attributeCode | |
| Label [KEY] | String | False | No | Option label | |
| SortOrder | Int | False | No | Option order | |
| StoreLabels | String | False | No | Option label for store scopes | |
| Value | String | False | No | Option value |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| CategoryId | String | False | No | Category id | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| Position | Int | False | No | This is an auto-generated column | |
| Sku [KEY] | String | False | No | This is an auto-generated column |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Int | False | No | Category id. | |
| AvailableSortBy | String | False | No | Available sort by for category. | |
| Children | String | False | No | Children ids comma separated. | |
| CreatedAt | Datetime | False | No | Category creation date and time. | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| IncludeInMenu | Bool | False | No | Category is included in menu. | |
| IsActive | Bool | False | No | Whether category is active | |
| Level | Int | False | No | Category level | |
| Name | String | False | No | Category name | |
| ParentId | Int | False | No | Parent category ID | |
| Path | String | False | No | Category full path. | |
| Position | Int | False | No | Category position | |
| SearchCriteria | String | False | No | This is an auto-generated column | |
| TotalCount | Int | False | No | Total count. | |
| UpdatedAt | Datetime | False | No | Category last update date and time. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| ApplyTo | String | False | No | Apply to value for the element | |
| AttributeCode [KEY] | String | False | No | Code of the attribute. | |
| AttributeId | Int | False | No | Id of the attribute. | |
| BackendModel | String | False | No | Backend model | |
| BackendType | String | False | No | Backend type. | |
| DefaultFrontendLabel | String | False | No | Frontend label for default store | |
| DefaultValue | String | False | No | Default value for the element. | |
| EntityTypeId | String | False | No | Entity type id | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| FrontendClass | String | False | No | Frontend class of attribute | |
| FrontendInput | String | False | No | HTML for input element. | |
| FrontendLabels | String | False | No | Frontend label for each store | |
| IsComparable | String | False | No | The attribute can be compared on the frontend | |
| IsFilterable | Bool | False | No | It used in layered navigation | |
| IsFilterableInGrid | Bool | False | No | It is filterable in catalog product grid | |
| IsFilterableInSearch | Bool | False | No | It is used in search results layered navigation | |
| IsHtmlAllowedOnFront | Bool | False | No | The HTML tags are allowed on the frontend | |
| IsRequired | Bool | False | No | Attribute is required. | |
| IsSearchable | String | False | No | The attribute can be used in Quick Search | |
| IsUnique | String | False | No | This is a unique attribute | |
| IsUsedForPromoRules | String | False | No | The attribute can be used for promo rules | |
| IsUsedInGrid | Bool | False | No | It is used in catalog product grid | |
| IsUserDefined | Bool | False | No | Current attribute has been defined by a user. | |
| IsVisible | Bool | False | No | Attribute is visible on frontend. | |
| IsVisibleInAdvancedSearch | String | False | No | The attribute can be used in Advanced Search | |
| IsVisibleInGrid | Bool | False | No | It is visible in catalog product grid | |
| IsVisibleOnFront | String | False | No | The attribute is visible on the frontend | |
| IsWysiwygEnabled | Bool | False | No | WYSIWYG flag | |
| Note | String | False | No | The note attribute for the element. | |
| Options | String | False | No | Options of the attribute (key => value pairs for select) | |
| Position | Int | False | No | Position | |
| Scope | String | False | No | Attribute scope | |
| SourceModel | String | False | No | Source model | |
| UsedForSortBy | Bool | False | No | It is used for sorting in product listing | |
| UsedInProductListing | String | False | No | The attribute can be used in product listing | |
| ValidationRules | String | False | No | Validation rules. | |
| SearchCriteria | String | False | No | This is an auto-generated column | |
| TotalCount | Int | False | No | Total count. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| Label [KEY] | String | False | No | Type label | |
| Value | String | False | No | Value |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Code [KEY] | Int | False | No | Link type code | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| Name | String | False | No | Link type name | |
| Type | String | False | No | Attribute type |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Int | False | No | Product identifier | |
| AddToCartButton | String | False | No | This is an auto-generated column | |
| AddToCompareButton | String | False | No | This is an auto-generated column | |
| CurrencyCode | String | False | No | Current or desired currency code to product | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| Images | String | False | No | Enough information, that needed to render image on front | |
| IsSalable | String | False | No | Information about product saleability (In Stock) | |
| Name | String | False | No | Product name | |
| PriceInfo | String | False | No | This is an auto-generated column | |
| StoreId | Int | False | No | Information about current store id or requested store id | |
| Type | String | False | No | Product type. Such as bundle, grouped, simple, etc… | |
| Url | String | False | No | Product url |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| CustomerGroupId [KEY] | Int | False | No | Customer group id | |
| Sku | String | False | No | sku | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| Qty | Double | False | No | Tier qty | |
| Value | Double | False | No | Price value |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| Label [KEY] | String | False | No | Product type label | |
| Name | String | False | No | Product type code |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| AgreementId [KEY] | Int | False | No | Agreement ID. | |
| CheckboxText | String | False | No | Agreement checkbox text. | |
| Content | String | False | No | Agreement content. | |
| ContentHeight | String | False | No | Agreement content height. Otherwise, null. | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| IsActive | Bool | False | No | Agreement status. | |
| IsHtml | Bool | False | No | _ true - HTML. _ false - plain text. | |
| Mode | Int | False | No | The agreement applied mode. | |
| Name | String | False | No | Agreement name. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| AgreementId | Int | False | No | Agreement ID. | |
| CheckboxText | String | False | No | Agreement checkbox text. | |
| Content | String | False | No | Agreement content. | |
| ContentHeight | String | False | No | Agreement content height. Otherwise, null. | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| IsActive | Bool | False | No | Agreement status. | |
| IsHtml | Bool | False | No | _ true - HTML. _ false - plain text. | |
| Mode | Int | False | No | The agreement applied mode. | |
| Name | String | False | No | Agreement name. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Int | False | No | ID | |
| BlockId | String | False | No | blockId | |
| Active | Bool | False | No | Active | |
| Content | String | False | No | Content | |
| CreationTime | String | False | No | Creation time | |
| Identifier | String | False | No | Identifier | |
| Title | String | False | No | Title | |
| UpdateTime | String | False | No | Update time | |
| SearchCriteria | String | False | No | This is an auto-generated column | |
| TotalCount | Int | False | No | Total count. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Int | False | No | ID | |
| PageId | String | False | No | pageId | |
| Active | Bool | False | No | Active | |
| Content | String | False | No | Content | |
| ContentHeading | String | False | No | Content heading | |
| CreationTime | String | False | No | Creation time | |
| CustomLayoutUpdateXml | String | False | No | Custom layout update xml | |
| CustomRootTemplate | String | False | No | Custom root template | |
| CustomTheme | String | False | No | Custom theme | |
| CustomThemeFrom | String | False | No | Custom theme from | |
| CustomThemeTo | String | False | No | Custom theme to | |
| Identifier | String | False | No | Identifier | |
| LayoutUpdateXml | String | False | No | Layout update xml | |
| MetaDescription | String | False | No | Meta description | |
| MetaKeywords | String | False | No | Meta keywords | |
| MetaTitle | String | False | No | Meta title | |
| PageLayout | String | False | No | Page layout | |
| SortOrder | String | False | No | Sort order | |
| Title | String | False | No | Title | |
| UpdateTime | String | False | No | Update time | |
| SearchCriteria | String | False | No | This is an auto-generated column | |
| TotalCount | Int | False | No | Total count. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Int | False | No | Id | |
| AttributeSetId | Int | False | No | Attribute set id | |
| CreatedAt | Datetime | False | No | Created date | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| MediaGalleryEntries | String | False | No | Media gallery entries | |
| Name | String | False | No | Name | |
| Options | String | False | No | List of product options | |
| Price | Double | False | No | Price | |
| ProductLinks | String | False | No | Product links info | |
| Sku | String | False | No | Sku | |
| Status | Int | False | No | Status | |
| TierPrices | String | False | No | List of product tier prices | |
| TypeId | String | False | No | Type id | |
| UpdatedAt | Datetime | False | No | Updated date | |
| Visibility | Int | False | No | Visibility | |
| Weight | Double | False | No | Weight |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Int | False | No | This is an auto-generated column | |
| Sku | String | False | No | sku | |
| AttributeId | String | False | No | This is an auto-generated column | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| IsUseDefault | Bool | False | No | This is an auto-generated column | |
| Label | String | False | No | This is an auto-generated column | |
| Position | Int | False | No | This is an auto-generated column | |
| ProductId | Int | False | No | This is an auto-generated column | |
| Values | String | False | No | This is an auto-generated column |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Int | False | No | ID | |
| City | String | False | No | City name | |
| Company | String | False | No | Company | |
| CountryId | String | False | No | Country code in ISO_3166-2 format | |
| CustomerId | Int | False | No | Customer ID | |
| DefaultBilling | Bool | False | No | If this address is default billing address | |
| DefaultShipping | Bool | False | No | If this address is default shipping address. | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| Fax | String | False | No | Fax number | |
| Firstname | String | False | No | First name | |
| Lastname | String | False | No | Last name | |
| Middlename | String | False | No | Middle name | |
| Postcode | String | False | No | Postcode | |
| Prefix | String | False | No | Prefix | |
| Region | String | False | No | This is an auto-generated column | |
| RegionId | Int | False | No | Region ID | |
| Street | String | False | No | Street | |
| Suffix | String | False | No | Suffix | |
| Telephone | String | False | No | Telephone number | |
| VatId | String | False | No | Vat id |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Int | False | No | ID | |
| City | String | False | No | City name | |
| Company | String | False | No | Company | |
| CountryId | String | False | No | Country code in ISO_3166-2 format | |
| CustomerId | Int | False | No | Customer ID | |
| DefaultBilling | Bool | False | No | If this address is default billing address | |
| DefaultShipping | Bool | False | No | If this address is default shipping address. | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| Fax | String | False | No | Fax number | |
| Firstname | String | False | No | First name | |
| Lastname | String | False | No | Last name | |
| Middlename | String | False | No | Middle name | |
| Postcode | String | False | No | Postcode | |
| Prefix | String | False | No | Prefix | |
| Region | String | False | No | This is an auto-generated column | |
| RegionId | Int | False | No | Region ID | |
| Street | String | False | No | Street | |
| Suffix | String | False | No | Suffix | |
| Telephone | String | False | No | Telephone number | |
| VatId | String | False | No | Vat id |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Int | False | No | ID | |
| AddressId | String | False | No | addressId | |
| City | String | False | No | City name | |
| Company | String | False | No | Company | |
| CountryId | String | False | No | Country code in ISO_3166-2 format | |
| CustomerId | Int | False | No | Customer ID | |
| DefaultBilling | Bool | False | No | If this address is default billing address | |
| DefaultShipping | Bool | False | No | If this address is default shipping address. | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| Fax | String | False | No | Fax number | |
| Firstname | String | False | No | First name | |
| Lastname | String | False | No | Last name | |
| Middlename | String | False | No | Middle name | |
| Postcode | String | False | No | Postcode | |
| Prefix | String | False | No | Prefix | |
| Region | String | False | No | This is an auto-generated column | |
| RegionId | Int | False | No | Region ID | |
| Street | String | False | No | Street | |
| Suffix | String | False | No | Suffix | |
| Telephone | String | False | No | Telephone number | |
| VatId | String | False | No | Vat id |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Int | False | No | Id | |
| Code | String | False | No | Code | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| TaxClassId | Int | False | No | Tax class id | |
| TaxClassName | String | False | No | Tax class name | |
| SearchCriteria | String | False | No | This is an auto-generated column | |
| TotalCount | Int | False | No | Total count. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Int | False | No | Id | |
| Code | String | False | No | Code | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| TaxClassId | Int | False | No | Tax class id | |
| TaxClassName | String | False | No | Tax class name |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Int | False | No | Customer id | |
| Addresses | String | False | No | Customer addresses. | |
| Confirmation | String | False | No | Confirmation | |
| CreatedAt | Datetime | False | No | Created at time | |
| CreatedIn | String | False | No | Created in area | |
| DefaultBilling | String | False | No | Default billing address id | |
| DefaultShipping | String | False | No | Default shipping address id | |
| DisableAutoGroupChange | Int | False | No | Disable auto group change flag. | |
| Dob | String | False | No | Date of birth | |
| String | False | No | Email address | ||
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| Firstname | String | False | No | First name | |
| Gender | Int | False | No | Gender | |
| GroupId | Int | False | No | Group id | |
| Lastname | String | False | No | Last name | |
| Middlename | String | False | No | Middle name | |
| Prefix | String | False | No | Prefix | |
| StoreId | Int | False | No | Store id | |
| Suffix | String | False | No | Suffix | |
| Taxvat | String | False | No | Tax Vat | |
| UpdatedAt | Datetime | False | No | Updated at time | |
| WebsiteId | Int | False | No | Website id | |
| SearchCriteria | String | False | No | This is an auto-generated column | |
| TotalCount | Int | False | No | Total count. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | String | False | No | The country id for the store. | |
| CountryId | String | False | No | countryId | |
| AvailableRegions | String | False | No | The available regions for the store. | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| FullNameEnglish | String | False | No | The country full name (in English) for the store. | |
| FullNameLocale | String | False | No | The country full name (in store locale) for the store. | |
| ThreeLetterAbbreviation | String | False | No | The country 3 letter abbreviation for the store. | |
| TwoLetterAbbreviation | String | False | No | The country 2 letter abbreviation for the store. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| AvailableCurrencyCodes | String | False | No | The list of allowed currency codes for the store. | |
| BaseCurrencyCode [KEY] | String | False | No | The base currency code for the store. | |
| BaseCurrencySymbol | String | False | No | The currency symbol of the base currency for the store. | |
| DefaultDisplayCurrencyCode | String | False | No | The default display currency code for the store. | |
| DefaultDisplayCurrencySymbol | String | False | No | The currency symbol of the default display currency for the store. | |
| ExchangeRates | String | False | No | The list of exchange rate information for the store. | |
| ExtensionAttributes | String | False | No | This is an auto-generated column |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Int | False | No | Sample(or link) id | |
| Sku | String | False | No | sku | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| IsShareable | Int | False | No | Shareable status | |
| LinkFile | String | False | No | relative file path | |
| LinkFileContent | String | False | No | This is an auto-generated column | |
| LinkType | String | False | No | This is an auto-generated column | |
| LinkUrl | String | False | No | Link url or null when type is ‘file’ | |
| NumberOfDownloads | Int | False | No | Of downloads per user | |
| Price | Double | False | No | Price | |
| SampleFile | String | False | No | relative file path | |
| SampleFileContent | String | False | No | This is an auto-generated column | |
| SampleType | String | False | No | This is an auto-generated column | |
| SampleUrl | String | False | No | file URL | |
| SortOrder | Int | False | No | This is an auto-generated column | |
| Title | String | False | No | This is an auto-generated column |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Int | False | No | Sample(or link) id | |
| Sku | String | False | No | sku | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| SampleFile | String | False | No | relative file path | |
| SampleFileContent | String | False | No | This is an auto-generated column | |
| SampleType | String | False | No | This is an auto-generated column | |
| SampleUrl | String | False | No | file URL | |
| SortOrder | Int | False | No | Order index for sample | |
| Title | String | False | No | Title |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| AttributeSetId [KEY] | Int | False | No | Attribute set ID | |
| AttributeSetName | String | False | No | Attribute set name | |
| EntityTypeId | Int | False | No | Attribute set entity type id | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| SearchCriteria | String | False | No | This is an auto-generated column | |
| SortOrder | Int | False | No | Attribute set sort order index | |
| TotalCount | Int | False | No | Total count. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| CustomerId | Int | False | No | Customer ID. Otherwise, null. | |
| CartId | String | False | No | cartId | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| GiftMessageId [KEY] | Int | False | No | Gift message ID. Otherwise, null. | |
| Message | String | False | No | Message text. | |
| Recipient | String | False | No | Recipient name. | |
| Sender | String | False | No | Sender name. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| CustomerId | Int | False | No | Customer ID. Otherwise, null. | |
| CartId | String | False | No | cartId | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| GiftMessageId [KEY] | Int | False | No | Gift message ID. Otherwise, null. | |
| Message | String | False | No | Message text. | |
| Recipient | String | False | No | Recipient name. | |
| Sender | String | False | No | Sender name. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| CustomerId | Int | False | No | Customer ID. Otherwise, null. | |
| CartId | String | False | No | cartId | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| GiftMessageId [KEY] | Int | False | No | Gift message ID. Otherwise, null. | |
| Message | String | False | No | Message text. | |
| Recipient | String | False | No | Recipient name. | |
| Sender | String | False | No | Sender name. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| CustomerId | Int | False | No | Customer ID. Otherwise, null. | |
| CartId | String | False | No | cartId | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| GiftMessageId [KEY] | Int | False | No | Gift message ID. Otherwise, null. | |
| Message | String | False | No | Message text. | |
| Recipient | String | False | No | Recipient name. | |
| Sender | String | False | No | Sender name. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Int | False | No | Id | |
| CartId | String | False | No | cartId | |
| City | String | False | No | City name | |
| Company | String | False | No | Company | |
| CountryId | String | False | No | Country id | |
| CustomerAddressId | Int | False | No | Customer address id | |
| CustomerId | Int | False | No | Customer id | |
| String | False | No | Billing/shipping email | ||
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| Fax | String | False | No | Fax number | |
| Firstname | String | False | No | First name | |
| Lastname | String | False | No | Last name | |
| Middlename | String | False | No | Middle name | |
| Postcode | String | False | No | Postcode | |
| Prefix | String | False | No | Prefix | |
| Region | String | False | No | Region name | |
| RegionCode | String | False | No | Region code | |
| RegionId | Int | False | No | Region id | |
| SameAsBilling | Int | False | No | Same as billing flag | |
| SaveInAddressBook | Int | False | No | Save in address book flag | |
| Street | String | False | No | Street | |
| Suffix | String | False | No | Suffix | |
| Telephone | String | False | No | Telephone number | |
| VatId | String | False | No | Vat id |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| CartId | String | False | No | cartId | |
| PaymentMethods | String | False | No | This is an auto-generated column | |
| Totals | String | False | No | This is an auto-generated column |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Code [KEY] | String | False | No | Payment method code | |
| CartId | String | False | No | cartId | |
| Title | String | False | No | Payment method title |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| AdditionalData | String | False | No | Payment additional details | |
| CartId | String | False | No | cartId | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| Method [KEY] | String | False | No | Payment method code | |
| PoNumber | String | False | No | Purchase order number |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Amount | Double | False | No | Shipping amount in store currency. | |
| CartId | String | False | No | cartId | |
| Available | Bool | False | No | The value of the availability flag for the current shipping method. | |
| BaseAmount | Double | False | No | Shipping amount in base currency. | |
| CarrierCode | String | False | No | Shipping carrier code. | |
| CarrierTitle | String | False | No | Shipping carrier title. Otherwise, null. | |
| ErrorMessage | String | False | No | Shipping Error message. | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| MethodCode [KEY] | String | False | No | Shipping method code. | |
| MethodTitle | String | False | No | Shipping method title. Otherwise, null. | |
| PriceExclTax | Double | False | No | Shipping price excl tax. | |
| PriceInclTax | Double | False | No | Shipping price incl tax. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Items | String | False | No | Items | |
| ProductSku [KEY] | String | False | No | This is an auto generated column. | |
| SearchCriteria | String | False | No | This is an auto-generated column | |
| TotalCount | Int | False | No | Total count. | |
| Backorders | Int | False | No | Backorders status | |
| EnableQtyIncrements | Bool | False | No | Whether Quantity Increments is enabled | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| IsDecimalDivided | Bool | False | No | This is an auto-generated column | |
| IsInStock | Bool | False | No | Stock Availability | |
| IsQtyDecimal | Bool | False | No | This is an auto-generated column | |
| ItemId [KEY] | Int | False | No | This is an auto-generated column | |
| LowStockDate | String | False | No | This is an auto-generated column | |
| ManageStock | Bool | False | No | Can Manage Stock | |
| MaxSaleQty | Double | False | No | Maximum Qty Allowed in Shopping Cart data wrapper | |
| MinQty | Double | False | No | Minimal quantity available for item status in stock | |
| MinSaleQty | Double | False | No | Minimum Qty Allowed in Shopping Cart or NULL when there is no limitation | |
| NotifyStockQty | Double | False | No | Notify for Quantity Below data wrapper | |
| ProductId | Int | False | No | This is an auto-generated column | |
| Qty | Double | False | No | This is an auto-generated column | |
| QtyIncrements | Double | False | No | Quantity Increments data wrapper | |
| ShowDefaultNotificationMessage | Bool | False | No | This is an auto-generated column | |
| StockId | Int | False | No | Stock identifier | |
| StockStatusChangedAuto | Int | False | No | This is an auto-generated column | |
| UseConfigBackorders | Bool | False | No | This is an auto-generated column | |
| UseConfigEnableQtyInc | Bool | False | No | This is an auto-generated column | |
| UseConfigManageStock | Bool | False | No | This is an auto-generated column | |
| UseConfigMaxSaleQty | Bool | False | No | This is an auto-generated column | |
| UseConfigMinQty | Bool | False | No | This is an auto-generated column | |
| UseConfigMinSaleQty | Int | False | No | This is an auto-generated column | |
| UseConfigNotifyStockQty | Bool | False | No | This is an auto-generated column | |
| UseConfigQtyIncrements | Bool | False | No | This is an auto-generated column | |
| StockItem | String | False | No | This is an auto-generated column | |
| StockStatus | Int | False | No | This is an auto-generated column |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| CarrierLinks | String | False | No | This is an auto-generated column | |
| StockId | String | False | No | stockId | |
| City | String | False | No | Source city | |
| ContactName | String | False | No | Source contact name | |
| CountryId | String | False | No | Source country id | |
| Description | String | False | No | Source description | |
| String | False | No | Source email | ||
| Enabled | Bool | False | No | If source is enabled. For new entity can be null | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| Fax | String | False | No | Source fax | |
| Latitude | Double | False | No | Source latitude | |
| Longitude | Double | False | No | Source longitude | |
| Name | String | False | No | Source name | |
| Phone | String | False | No | Source phone number | |
| Postcode | String | False | No | Source post code | |
| Region | String | False | No | Region title if source has custom region | |
| RegionId | Int | False | No | Region id if source has registered region. | |
| SourceCode | String | False | No | Source code | |
| Street | String | False | No | Source street name | |
| UseDefaultCarrierConfig | Bool | False | No | Is need to use default config |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| Priority | Int | False | No | Priority of the link | |
| SearchCriteria | String | False | No | This is an auto-generated column | |
| SourceCode | String | False | No | Source code of the link | |
| StockId | Int | False | No | Stock id | |
| TotalCount | Int | False | No | Total count. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| CarrierLinks | String | False | No | This is an auto-generated column | |
| City | String | False | No | Source city | |
| ContactName | String | False | No | Source contact name | |
| CountryId | String | False | No | Source country id | |
| Description | String | False | No | Source description | |
| String | False | No | Source email | ||
| Enabled | Bool | False | No | If source is enabled. For new entity can be null | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| Fax | String | False | No | Source fax | |
| Latitude | Double | False | No | Source latitude | |
| Longitude | Double | False | No | Source longitude | |
| Name | String | False | No | Source name | |
| Phone | String | False | No | Source phone number | |
| Postcode | String | False | No | Source post code | |
| Region | String | False | No | Region title if source has custom region | |
| RegionId | Int | False | No | Region id if source has registered region. | |
| SearchCriteria | String | False | No | This is an auto-generated column | |
| SourceCode | String | False | No | Source code | |
| Street | String | False | No | Source street name | |
| TotalCount | Int | False | No | Total count. | |
| UseDefaultCarrierConfig | Bool | False | No | Is need to use default config |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| Quantity | Double | False | No | Source item quantity | |
| SearchCriteria | String | False | No | This is an auto-generated column | |
| Sku | String | False | No | Source item sku | |
| SourceCode | String | False | No | Source code | |
| Status | Int | False | No | Source item status (One of self::STATUS_*) | |
| TotalCount | Int | False | No | Total count. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| Name | String | False | No | Stock name | |
| SearchCriteria | String | False | No | This is an auto-generated column | |
| StockId | Int | False | No | Stock id | |
| TotalCount | Int | False | No | Total count. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Comment | String | False | No | Comment. | |
| Id | String | False | No | id | |
| CreatedAt | Datetime | False | No | Created-at timestamp. | |
| EntityId [KEY] | Int | False | No | Order status history ID. | |
| EntityName | String | False | No | Entity name. | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| IsCustomerNotified | Int | False | No | Is-customer-notified flag value. | |
| IsVisibleOnFront | Int | False | No | Is-visible-on-storefront flag value. | |
| ParentId | Int | False | No | Parent ID. | |
| SearchCriteria | String | False | No | This is an auto-generated column | |
| Status | String | False | No | Status. | |
| TotalCount | Int | False | No | Total count. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| AdditionalData | String | False | No | Additional data. | |
| Id | String | False | No | id | |
| AmountRefunded | Double | False | No | Amount refunded. | |
| AppliedRuleIds | String | False | No | Applied rule IDs. | |
| BaseAmountRefunded | Double | False | No | Base amount refunded. | |
| BaseCost | Double | False | No | Base cost. | |
| BaseDiscountAmount | Double | False | No | Base discount amount. | |
| BaseDiscountInvoiced | Double | False | No | Base discount invoiced. | |
| BaseDiscountRefunded | Double | False | No | Base discount refunded. | |
| BaseDiscountTaxCompensationAmount | Double | False | No | Base discount tax compensation amount. | |
| BaseDiscountTaxCompensationInvoiced | Double | False | No | Base discount tax compensation invoiced. | |
| BaseDiscountTaxCompensationRefunded | Double | False | No | Base discount tax compensation refunded. | |
| BaseOriginalPrice | Double | False | No | Base original price. | |
| BasePrice | Double | False | No | Base price. | |
| BasePriceInclTax | Double | False | No | Base price including tax. | |
| BaseRowInvoiced | Double | False | No | Base row invoiced. | |
| BaseRowTotal | Double | False | No | Base row total. | |
| BaseRowTotalInclTax | Double | False | No | Base row total including tax. | |
| BaseTaxAmount | Double | False | No | Base tax amount. | |
| BaseTaxBeforeDiscount | Double | False | No | Base tax before discount. | |
| BaseTaxInvoiced | Double | False | No | Base tax invoiced. | |
| BaseTaxRefunded | Double | False | No | Base tax refunded. | |
| BaseWeeeTaxAppliedAmount | Double | False | No | Base WEEE tax applied amount. | |
| BaseWeeeTaxAppliedRowAmnt | Double | False | No | Base WEEE tax applied row amount. | |
| BaseWeeeTaxDisposition | Double | False | No | Base WEEE tax disposition. | |
| BaseWeeeTaxRowDisposition | Double | False | No | Base WEEE tax row disposition. | |
| CreatedAt | Datetime | False | No | Created-at timestamp. | |
| Description | String | False | No | Description. | |
| DiscountAmount | Double | False | No | Discount amount. | |
| DiscountInvoiced | Double | False | No | Discount invoiced. | |
| DiscountPercent | Double | False | No | Discount percent. | |
| DiscountRefunded | Double | False | No | Discount refunded. | |
| DiscountTaxCompensationAmount | Double | False | No | Discount tax compensation amount. | |
| DiscountTaxCompensationCanceled | Double | False | No | Discount tax compensation canceled. | |
| DiscountTaxCompensationInvoiced | Double | False | No | Discount tax compensation invoiced. | |
| DiscountTaxCompensationRefunded | Double | False | No | Discount tax compensation refunded. | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| ExtOrderItemId | String | False | No | External order item ID. | |
| FreeShipping | Int | False | No | Free-shipping flag value. | |
| IsQtyDecimal | Int | False | No | Is-quantity-decimal flag value. | |
| IsVirtual | Int | False | No | Is-virtual flag value. | |
| ItemId [KEY] | Int | False | No | Item ID. | |
| LockedDoInvoice | Int | False | No | Locked DO invoice flag value. | |
| LockedDoShip | Int | False | No | Locked DO ship flag value. | |
| Name | String | False | No | Name. | |
| NoDiscount | Int | False | No | No-discount flag value. | |
| OrderId | Int | False | No | Order ID. | |
| OriginalPrice | Double | False | No | Original price. | |
| ParentItem | String | False | No | This is an auto-generated column | |
| ParentItemId | Int | False | No | Parent item ID. | |
| Price | Double | False | No | Price. | |
| PriceInclTax | Double | False | No | Price including tax. | |
| ProductId | Int | False | No | Product ID. | |
| ProductOption | String | False | No | This is an auto-generated column | |
| ProductType | String | False | No | Product type. | |
| QtyBackordered | Double | False | No | Quantity backordered. | |
| QtyCanceled | Double | False | No | Quantity canceled. | |
| QtyInvoiced | Double | False | No | Quantity invoiced. | |
| QtyOrdered | Double | False | No | Quantity ordered. | |
| QtyRefunded | Double | False | No | Quantity refunded. | |
| QtyShipped | Double | False | No | Quantity shipped. | |
| QuoteItemId | Int | False | No | Quote item ID. | |
| RowInvoiced | Double | False | No | Row invoiced. | |
| RowTotal | Double | False | No | Row total. | |
| RowTotalInclTax | Double | False | No | Row total including tax. | |
| RowWeight | Double | False | No | Row weight. | |
| SearchCriteria | String | False | No | This is an auto-generated column | |
| Sku | String | False | No | SKU. | |
| StoreId | Int | False | No | Store ID. | |
| TaxAmount | Double | False | No | Tax amount. | |
| TaxBeforeDiscount | Double | False | No | Tax before discount. | |
| TaxCanceled | Double | False | No | Tax canceled. | |
| TaxInvoiced | Double | False | No | Tax invoiced. | |
| TaxPercent | Double | False | No | Tax percent. | |
| TaxRefunded | Double | False | No | Tax refunded. | |
| TotalCount | Int | False | No | Total count. | |
| UpdatedAt | Datetime | False | No | Updated-at timestamp. | |
| WeeeTaxApplied | String | False | No | WEEE tax applied. | |
| WeeeTaxAppliedAmount | Double | False | No | WEEE tax applied amount. | |
| WeeeTaxAppliedRowAmount | Double | False | No | WEEE tax applied row amount. | |
| WeeeTaxDisposition | Double | False | No | WEEE tax disposition. | |
| WeeeTaxRowDisposition | Double | False | No | WEEE tax row disposition. | |
| Weight | Double | False | No | Weight. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| AdjustmentNegative | Double | False | No | Negative adjustment value. | |
| Id | String | False | No | id | |
| AdjustmentPositive | Double | False | No | Positive adjustment value. | |
| AppliedRuleIds | String | False | No | Applied rule IDs. | |
| BaseAdjustmentNegative | Double | False | No | Base negative adjustment value. | |
| BaseAdjustmentPositive | Double | False | No | Base positive adjustment value. | |
| BaseCurrencyCode | String | False | No | Base currency code. | |
| BaseDiscountAmount | Double | False | No | Base discount amount. | |
| BaseDiscountCanceled | Double | False | No | Base discount canceled. | |
| BaseDiscountInvoiced | Double | False | No | Base discount invoiced. | |
| BaseDiscountRefunded | Double | False | No | Base discount refunded. | |
| BaseDiscountTaxCompensationAmount | Double | False | No | Base discount tax compensation amount. | |
| BaseDiscountTaxCompensationInvoiced | Double | False | No | Base discount tax compensation invoiced. | |
| BaseDiscountTaxCompensationRefunded | Double | False | No | Base discount tax compensation refunded. | |
| BaseGrandTotal | Double | False | No | Base grand total. | |
| BaseShippingAmount | Double | False | No | Base shipping amount. | |
| BaseShippingCanceled | Double | False | No | Base shipping canceled. | |
| BaseShippingDiscountAmount | Double | False | No | Base shipping discount amount. | |
| BaseShippingDiscountTaxCompensationAmnt | Double | False | No | Base shipping discount tax compensation amount. | |
| BaseShippingInclTax | Double | False | No | Base shipping including tax. | |
| BaseShippingInvoiced | Double | False | No | Base shipping invoiced. | |
| BaseShippingRefunded | Double | False | No | Base shipping refunded. | |
| BaseShippingTaxAmount | Double | False | No | Base shipping tax amount. | |
| BaseShippingTaxRefunded | Double | False | No | Base shipping tax refunded. | |
| BaseSubtotal | Double | False | No | Base subtotal. | |
| BaseSubtotalCanceled | Double | False | No | Base subtotal canceled. | |
| BaseSubtotalInclTax | Double | False | No | Base subtotal including tax. | |
| BaseSubtotalInvoiced | Double | False | No | Base subtotal invoiced. | |
| BaseSubtotalRefunded | Double | False | No | Base subtotal refunded. | |
| BaseTaxAmount | Double | False | No | Base tax amount. | |
| BaseTaxCanceled | Double | False | No | Base tax canceled. | |
| BaseTaxInvoiced | Double | False | No | Base tax invoiced. | |
| BaseTaxRefunded | Double | False | No | Base tax refunded. | |
| BaseToGlobalRate | Double | False | No | Base-to-global rate. | |
| BaseToOrderRate | Double | False | No | Base-to-order rate. | |
| BaseTotalCanceled | Double | False | No | Base total canceled. | |
| BaseTotalDue | Double | False | No | Base total due. | |
| BaseTotalInvoiced | Double | False | No | Base total invoiced. | |
| BaseTotalInvoicedCost | Double | False | No | Base total invoiced cost. | |
| BaseTotalOfflineRefunded | Double | False | No | Base total offline refunded. | |
| BaseTotalOnlineRefunded | Double | False | No | Base total online refunded. | |
| BaseTotalPaid | Double | False | No | Base total paid. | |
| BaseTotalQtyOrdered | Double | False | No | Base total quantity ordered. | |
| BaseTotalRefunded | Double | False | No | Base total refunded. | |
| BillingAddress | String | False | No | This is an auto-generated column | |
| BillingAddressId | Int | False | No | Billing address ID. | |
| CanShipPartially | Int | False | No | Can-ship-partially flag value. | |
| CanShipPartiallyItem | Int | False | No | Can-ship-partially-item flag value. | |
| CouponCode | String | False | No | Coupon code. | |
| CreatedAt | Datetime | False | No | Created-at timestamp. | |
| CustomerDob | String | False | No | Customer date-of-birth (DOB). | |
| CustomerEmail | String | False | No | Customer email address. | |
| CustomerFirstname | String | False | No | Customer first name. | |
| CustomerGender | Int | False | No | Customer gender. | |
| CustomerGroupId | Int | False | No | Customer group ID. | |
| CustomerId | Int | False | No | Customer ID. | |
| CustomerIsGuest | Int | False | No | Customer-is-guest flag value. | |
| CustomerLastname | String | False | No | Customer last name. | |
| CustomerMiddlename | String | False | No | Customer middle name. | |
| CustomerNote | String | False | No | Customer note. | |
| CustomerNoteNotify | Int | False | No | Customer-note-notify flag value. | |
| CustomerPrefix | String | False | No | Customer prefix. | |
| CustomerSuffix | String | False | No | Customer suffix. | |
| CustomerTaxvat | String | False | No | Customer value-added tax (VAT). | |
| DiscountAmount | Double | False | No | Discount amount. | |
| DiscountCanceled | Double | False | No | Discount canceled. | |
| DiscountDescription | String | False | No | Discount description. | |
| DiscountInvoiced | Double | False | No | Discount invoiced. | |
| DiscountRefunded | Double | False | No | Discount refunded amount. | |
| DiscountTaxCompensationAmount | Double | False | No | Discount tax compensation amount. | |
| DiscountTaxCompensationInvoiced | Double | False | No | Discount tax compensation invoiced amount. | |
| DiscountTaxCompensationRefunded | Double | False | No | Discount tax compensation refunded amount. | |
| EditIncrement | Int | False | No | Edit increment value. | |
| EmailSent | Int | False | No | Email-sent flag value. | |
| EntityId [KEY] | Int | False | No | Order ID. | |
| ExtCustomerId | String | False | No | External customer ID. | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| ExtOrderId | String | False | No | External order ID. | |
| ForcedShipmentWithInvoice | Int | False | No | Forced-shipment-with-invoice flag value. | |
| GlobalCurrencyCode | String | False | No | Global currency code. | |
| GrandTotal | Double | False | No | Grand total. | |
| HoldBeforeState | String | False | No | Hold before state. | |
| HoldBeforeStatus | String | False | No | Hold before status. | |
| IncrementId | String | False | No | Increment ID. | |
| IsVirtual | Int | False | No | Is-virtual flag value. | |
| Items | String | False | No | Array of items. | |
| OrderCurrencyCode | String | False | No | Order currency code. | |
| OriginalIncrementId | String | False | No | Original increment ID. | |
| Payment | String | False | No | This is an auto-generated column | |
| PaymentAuthExpiration | Int | False | No | Payment authorization expiration date. | |
| PaymentAuthorizationAmount | Double | False | No | Payment authorization amount. | |
| ProtectCode | String | False | No | Protect code. | |
| QuoteAddressId | Int | False | No | Quote address ID. | |
| QuoteId | Int | False | No | Quote ID. | |
| RelationChildId | String | False | No | Relation child ID. | |
| RelationChildRealId | String | False | No | Relation child real ID. | |
| RelationParentId | String | False | No | Relation parent ID. | |
| RelationParentRealId | String | False | No | Relation parent real ID. | |
| RemoteIp | String | False | No | Remote IP address. | |
| SearchCriteria | String | False | No | This is an auto-generated column | |
| ShippingAmount | Double | False | No | Shipping amount. | |
| ShippingCanceled | Double | False | No | Shipping canceled amount. | |
| ShippingDescription | String | False | No | Shipping description. | |
| ShippingDiscountAmount | Double | False | No | Shipping discount amount. | |
| ShippingDiscountTaxCompensationAmount | Double | False | No | Shipping discount tax compensation amount. | |
| ShippingInclTax | Double | False | No | Shipping including tax amount. | |
| ShippingInvoiced | Double | False | No | Shipping invoiced amount. | |
| ShippingRefunded | Double | False | No | Shipping refunded amount. | |
| ShippingTaxAmount | Double | False | No | Shipping tax amount. | |
| ShippingTaxRefunded | Double | False | No | Shipping tax refunded amount. | |
| State | String | False | No | State. | |
| Status | String | False | No | Status. | |
| StatusHistories | String | False | No | Array of status histories. | |
| StoreCurrencyCode | String | False | No | Store currency code. | |
| StoreId | Int | False | No | Store ID. | |
| StoreName | String | False | No | Store name. | |
| StoreToBaseRate | Double | False | No | Store-to-base rate. | |
| StoreToOrderRate | Double | False | No | Store-to-order rate. | |
| Subtotal | Double | False | No | Subtotal. | |
| SubtotalCanceled | Double | False | No | Subtotal canceled amount. | |
| SubtotalInclTax | Double | False | No | Subtotal including tax amount. | |
| SubtotalInvoiced | Double | False | No | Subtotal invoiced amount. | |
| SubtotalRefunded | Double | False | No | Subtotal refunded amount. | |
| TaxAmount | Double | False | No | Tax amount. | |
| TaxCanceled | Double | False | No | Tax canceled amount. | |
| TaxInvoiced | Double | False | No | Tax invoiced amount. | |
| TaxRefunded | Double | False | No | Tax refunded amount. | |
| TotalCanceled | Double | False | No | Total canceled. | |
| TotalCount | Int | False | No | Total count. | |
| TotalDue | Double | False | No | Total due. | |
| TotalInvoiced | Double | False | No | Total invoiced amount. | |
| TotalItemCount | Int | False | No | Total item count. | |
| TotalOfflineRefunded | Double | False | No | Total offline refunded amount. | |
| TotalOnlineRefunded | Double | False | No | Total online refunded amount. | |
| TotalPaid | Double | False | No | Total paid. | |
| TotalQtyOrdered | Double | False | No | Total quantity ordered. | |
| TotalRefunded | Double | False | No | Total amount refunded. | |
| UpdatedAt | Datetime | False | No | Updated-at timestamp. | |
| Weight | Double | False | No | Weight. | |
| XForwardedFor | String | False | No | X-Forwarded-For field value. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Code [KEY] | String | False | No | Payment method code | |
| CartId | String | False | No | cartId | |
| Title | String | False | No | Payment method title |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| AdditionalData | String | False | No | Payment additional details | |
| CartId | String | False | No | cartId | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| Method [KEY] | String | False | No | Payment method code | |
| PoNumber | String | False | No | Purchase order number |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| ActionSuccess | String | False | No | To success page | |
| ClientToken | String | False | No | Client token | |
| DisplayName | String | False | No | Display name | |
| LoggedIn | Bool | False | No | This is an auto-generated column | |
| StoreCode | String | False | No | Current store code |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| AttributeGroupId [KEY] | String | False | No | Id | |
| AttributeGroupName | String | False | No | Name | |
| AttributeSetId | Int | False | No | Attribute set id | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| SearchCriteria | String | False | No | This is an auto-generated column | |
| TotalCount | Int | False | No | Total count. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| IsDefault | Bool | False | No | Default | |
| AttributeCode | String | False | No | attributeCode | |
| Label [KEY] | String | False | No | Option label | |
| SortOrder | Int | False | No | Option order | |
| StoreLabels | String | False | No | Option label for store scopes | |
| Value | String | False | No | Option value |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| ApplyTo | String | False | No | Apply to value for the element | |
| AttributeSetId | String | False | No | attributeSetId | |
| AttributeCode | String | False | No | Code of the attribute. | |
| AttributeId [KEY] | Int | False | No | Id of the attribute. | |
| BackendModel | String | False | No | Backend model | |
| BackendType | String | False | No | Backend type. | |
| DefaultFrontendLabel | String | False | No | Frontend label for default store | |
| DefaultValue | String | False | No | Default value for the element. | |
| EntityTypeId | String | False | No | Entity type id | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| FrontendClass | String | False | No | Frontend class of attribute | |
| FrontendInput | String | False | No | HTML for input element. | |
| FrontendLabels | String | False | No | Frontend label for each store | |
| IsComparable | String | False | No | The attribute can be compared on the frontend | |
| IsFilterable | Bool | False | No | It used in layered navigation | |
| IsFilterableInGrid | Bool | False | No | It is filterable in catalog product grid | |
| IsFilterableInSearch | Bool | False | No | It is used in search results layered navigation | |
| IsHtmlAllowedOnFront | Bool | False | No | The HTML tags are allowed on the frontend | |
| IsRequired | Bool | False | No | Attribute is required. | |
| IsSearchable | String | False | No | The attribute can be used in Quick Search | |
| IsUnique | String | False | No | This is a unique attribute | |
| IsUsedForPromoRules | String | False | No | The attribute can be used for promo rules | |
| IsUsedInGrid | Bool | False | No | It is used in catalog product grid | |
| IsUserDefined | Bool | False | No | Current attribute has been defined by a user. | |
| IsVisible | Bool | False | No | Attribute is visible on frontend. | |
| IsVisibleInAdvancedSearch | String | False | No | The attribute can be used in Advanced Search | |
| IsVisibleInGrid | Bool | False | No | It is visible in catalog product grid | |
| IsVisibleOnFront | String | False | No | The attribute is visible on the frontend | |
| IsWysiwygEnabled | Bool | False | No | WYSIWYG flag | |
| Note | String | False | No | The note attribute for the element. | |
| Options | String | False | No | Options of the attribute (key => value pairs for select) | |
| Position | Int | False | No | Position | |
| Scope | String | False | No | Attribute scope | |
| SourceModel | String | False | No | Source model | |
| UsedForSortBy | Bool | False | No | It is used for sorting in product listing | |
| UsedInProductListing | String | False | No | The attribute can be used in product listing | |
| ValidationRules | String | False | No | Validation rules. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Int | False | No | This is an auto-generated column | |
| CategoryId | String | False | No | categoryId | |
| AvailableSortBy | String | False | No | This is an auto-generated column | |
| Children | String | False | No | This is an auto-generated column | |
| CreatedAt | Datetime | False | No | This is an auto-generated column | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| IncludeInMenu | Bool | False | No | This is an auto-generated column | |
| IsActive | Bool | False | No | Whether category is active | |
| Level | Int | False | No | Category level | |
| Name | String | False | No | Category name | |
| ParentId | Int | False | No | Parent category ID | |
| Path | String | False | No | This is an auto-generated column | |
| Position | Int | False | No | Category position | |
| UpdatedAt | Datetime | False | No | This is an auto-generated column | |
| ProductCount | Int | False | No | Product count |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| FileExtension | String | False | No | This is an auto-generated column | |
| ImageSizeX | Int | False | No | This is an auto-generated column | |
| ImageSizeY | Int | False | No | This is an auto-generated column | |
| IsRequire | Bool | False | No | Is require | |
| MaxCharacters | Int | False | No | This is an auto-generated column | |
| OptionId [KEY] | Int | False | No | Option id | |
| Price | Double | False | No | Price | |
| PriceType | String | False | No | Price type | |
| ProductSku | String | False | No | Product SKU | |
| Sku | String | False | No | Sku | |
| SortOrder | Int | False | No | Sort order | |
| Title | String | False | No | Option title | |
| Type | String | False | No | Option type | |
| Values | String | False | No | This is an auto-generated column |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Int | False | No | Gallery entry ID | |
| Sku | String | False | No | sku | |
| Content | String | False | No | This is an auto-generated column | |
| Disabled | Bool | False | No | If gallery entry is hidden from product page | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| File | String | False | No | File path | |
| Label | String | False | No | Gallery entry alternative text | |
| MediaType | String | False | No | Media type | |
| Position | Int | False | No | Gallery entry position (sort order) | |
| Types | String | False | No | Gallery entry image types (thumbnail, image, small_image etc) |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id | Int | False | No | Id | |
| AttributeSetId | Int | False | No | Attribute set id | |
| CreatedAt | Datetime | False | No | Created date | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| MediaGalleryEntries | String | False | No | Media gallery entries | |
| Name | String | False | No | Name | |
| Options | String | False | No | List of product options | |
| Price | Double | False | No | Price | |
| ProductLinks | String | False | No | Product links info | |
| Sku [KEY] | String | False | No | Sku | |
| Status | Int | False | No | Status | |
| TierPrices | String | False | No | List of product tier prices | |
| TypeId | String | False | No | Type id | |
| UpdatedAt | Datetime | False | No | Updated date | |
| Visibility | Int | False | No | Visibility | |
| Weight | Double | False | No | Weight | |
| description | String | False | No | Custom Attribute field | |
| short_description | String | False | No | Custom Attribute field | |
| special_price | Decimal | False | No | Custom Attribute field | |
| special_from_date | Datetime | False | No | Custom Attribute field | |
| special_to_date | Datetime | False | No | Custom Attribute field | |
| cost | Decimal | False | No | Custom Attribute field | |
| manufacturer | Int | False | No | Custom Attribute field | |
| meta_title | String | False | No | Custom Attribute field | |
| meta_keyword | String | False | No | Custom Attribute field | |
| meta_description | String | False | No | Custom Attribute field | |
| image | String | False | No | Custom Attribute field | |
| small_image | String | False | No | Custom Attribute field | |
| thumbnail | String | False | No | Custom Attribute field | |
| media_gallery | String | False | No | Custom Attribute field | |
| old_id | Int | False | No | Custom Attribute field | |
| tier_price | Decimal | False | No | Custom Attribute field | |
| color | Int | False | No | Custom Attribute field | |
| news_from_date | Datetime | False | No | Custom Attribute field | |
| news_to_date | Datetime | False | No | Custom Attribute field | |
| gallery | String | False | No | Custom Attribute field | |
| minimal_price | Decimal | False | No | Custom Attribute field | |
| custom_design | String | False | No | Custom Attribute field | |
| custom_design_from | Datetime | False | No | Custom Attribute field | |
| custom_design_to | Datetime | False | No | Custom Attribute field | |
| custom_layout_update | String | False | No | Custom Attribute field | |
| page_layout | String | False | No | Custom Attribute field | |
| category_ids | String | False | No | Custom Attribute field | |
| options_container | String | False | No | Custom Attribute field | |
| required_options | String | False | No | Custom Attribute field | |
| has_options | String | False | No | Custom Attribute field | |
| image_label | String | False | No | Custom Attribute field | |
| small_image_label | String | False | No | Custom Attribute field | |
| thumbnail_label | String | False | No | Custom Attribute field | |
| created_at | String | False | No | Custom Attribute field | |
| updated_at | String | False | No | Custom Attribute field | |
| country_of_manufacture | String | False | No | Custom Attribute field | |
| quantity_and_stock_status | Int | False | No | Custom Attribute field | |
| custom_layout | String | False | No | Custom Attribute field | |
| url_key | String | False | No | Custom Attribute field | |
| url_path | String | False | No | Custom Attribute field | |
| msrp | Decimal | False | No | Custom Attribute field | |
| msrp_display_actual_price_type | String | False | No | Custom Attribute field | |
| price_type | Int | False | No | Custom Attribute field | |
| sku_type | Int | False | No | Custom Attribute field | |
| weight_type | Int | False | No | Custom Attribute field | |
| price_view | Int | False | No | Custom Attribute field | |
| shipment_type | Int | False | No | Custom Attribute field | |
| links_purchased_separately | Int | False | No | Custom Attribute field | |
| samples_title | String | False | No | Custom Attribute field | |
| links_title | String | False | No | Custom Attribute field | |
| links_exist | Int | False | No | Custom Attribute field | |
| swatch_image | String | False | No | Custom Attribute field | |
| tax_class_id | Int | False | No | Custom Attribute field | |
| gift_message_available | String | False | No | Custom Attribute field | |
| ryanattribute | String | False | No | Custom Attribute field | |
| ryan_attribute | String | False | No | Custom Attribute field | |
| deti_attr | String | False | No | Custom Attribute field | |
| deti_attribut | String | False | No | Custom Attribute field | |
| SearchCriteria | String | False | No | This is an auto-generated column | |
| TotalCount | Int | False | No | Total count. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Int | False | No | Cart/quote ID. | |
| CartId | String | False | No | cartId | |
| BillingAddress | String | False | No | This is an auto-generated column | |
| ConvertedAt | String | False | No | Cart conversion date and time. Otherwise, null. | |
| CreatedAt | Datetime | False | No | Cart creation date and time. Otherwise, null. | |
| Currency | String | False | No | This is an auto-generated column | |
| Customer | String | False | No | This is an auto-generated column | |
| CustomerIsGuest | Bool | False | No | For guest customers, false for logged in customers | |
| CustomerNote | String | False | No | Notice text | |
| CustomerNoteNotify | Bool | False | No | Customer notification flag | |
| CustomerTaxClassId | Int | False | No | Customer tax class ID. | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| IsActive | Bool | False | No | Active status flag value. Otherwise, null. | |
| IsVirtual | Bool | False | No | Virtual flag value. Otherwise, null. | |
| Items | String | False | No | Array of items. Otherwise, null. | |
| ItemsCount | Int | False | No | Number of different items or products in the cart. Otherwise, null. | |
| ItemsQty | Double | False | No | Total quantity of all cart items. Otherwise, null. | |
| OrigOrderId | Int | False | No | Original order ID. Otherwise, null. | |
| ReservedOrderId | Int | False | No | Reserved order ID. Otherwise, null. | |
| SearchCriteria | String | False | No | This is an auto-generated column | |
| StoreId | Int | False | No | Store identifier | |
| TotalCount | Int | False | No | Total count. | |
| UpdatedAt | Datetime | False | No | Cart last update date and time. Otherwise, null. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| CartId | String | False | No | cartId | |
| ItemId | Int | False | No | Item ID. Otherwise, null. | |
| Name | String | False | No | Product name. Otherwise, null. | |
| Price | Double | False | No | Product price. Otherwise, null. | |
| ProductOption | String | False | No | This is an auto-generated column | |
| ProductType | String | False | No | Product type. Otherwise, null. | |
| Qty | Double | False | No | Product quantity. | |
| QuoteId [KEY] | String | False | No | Quote id. | |
| Sku | String | False | No | Product SKU. Otherwise, null. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| BaseCurrencyCode | String | False | No | Base currency code | |
| CartId | String | False | No | cartId | |
| BaseDiscountAmount | Double | False | No | Discount amount in base currency | |
| BaseGrandTotal | Double | False | No | Grand total in base currency | |
| BaseShippingAmount | Double | False | No | Shipping amount in base currency | |
| BaseShippingDiscountAmount | Double | False | No | Shipping discount amount in base currency | |
| BaseShippingInclTax | Double | False | No | Shipping including tax in base currency | |
| BaseShippingTaxAmount | Double | False | No | Shipping tax amount in base currency | |
| BaseSubtotal | Double | False | No | Subtotal in base currency | |
| BaseSubtotalInclTax | Double | False | No | Subtotal including tax in base currency | |
| BaseSubtotalWithDiscount | Double | False | No | Subtotal in base currency with applied discount | |
| BaseTaxAmount | Double | False | No | Tax amount in base currency | |
| CouponCode | String | False | No | Applied coupon code | |
| DiscountAmount | Double | False | No | Discount amount in quote currency | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| GrandTotal | Double | False | No | Grand total in quote currency | |
| Items | String | False | No | Totals by items | |
| ItemsQty | Int | False | No | Items qty | |
| QuoteCurrencyCode | String | False | No | Quote currency code | |
| ShippingAmount | Double | False | No | Shipping amount in quote currency | |
| ShippingDiscountAmount | Double | False | No | Shipping discount amount in quote currency | |
| ShippingInclTax | Double | False | No | Shipping including tax in quote currency | |
| ShippingTaxAmount | Double | False | No | Shipping tax amount in quote currency | |
| Subtotal | Double | False | No | Subtotal in quote currency | |
| SubtotalInclTax | Double | False | No | Subtotal including tax in quote currency | |
| SubtotalWithDiscount | Double | False | No | Subtotal in quote currency with applied discount | |
| TaxAmount | Double | False | No | Tax amount in quote currency | |
| TotalSegments | String | False | No | Dynamically calculated totals | |
| WeeeTaxAppliedAmount | Double | False | No | Item weee tax applied amount in quote currency. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Int | False | No | Cart/quote ID. | |
| CartId | String | False | No | cartId | |
| BillingAddress | String | False | No | This is an auto-generated column | |
| ConvertedAt | String | False | No | Cart conversion date and time. Otherwise, null. | |
| CreatedAt | Datetime | False | No | Cart creation date and time. Otherwise, null. | |
| Currency | String | False | No | This is an auto-generated column | |
| Customer | String | False | No | This is an auto-generated column | |
| CustomerIsGuest | Bool | False | No | For guest customers, false for logged in customers | |
| CustomerNote | String | False | No | Notice text | |
| CustomerNoteNotify | Bool | False | No | Customer notification flag | |
| CustomerTaxClassId | Int | False | No | Customer tax class ID. | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| IsActive | Bool | False | No | Active status flag value. Otherwise, null. | |
| IsVirtual | Bool | False | No | Virtual flag value. Otherwise, null. | |
| Items | String | False | No | Array of items. Otherwise, null. | |
| ItemsCount | Int | False | No | Number of different items or products in the cart. Otherwise, null. | |
| ItemsQty | Double | False | No | Total quantity of all cart items. Otherwise, null. | |
| OrigOrderId | Int | False | No | Original order ID. Otherwise, null. | |
| ReservedOrderId | Int | False | No | Reserved order ID. Otherwise, null. | |
| StoreId | Int | False | No | Store identifier | |
| UpdatedAt | Datetime | False | No | Cart last update date and time. Otherwise, null. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| CartId | String | False | No | cartId | |
| ItemId | Int | False | No | Item ID. Otherwise, null. | |
| Name | String | False | No | Product name. Otherwise, null. | |
| Price | Double | False | No | Product price. Otherwise, null. | |
| ProductOption | String | False | No | This is an auto-generated column | |
| ProductType | String | False | No | Product type. Otherwise, null. | |
| Qty | Double | False | No | Product quantity. | |
| QuoteId [KEY] | String | False | No | Quote id. | |
| Sku | String | False | No | Product SKU. Otherwise, null. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| BaseCurrencyCode | String | False | No | Base currency code | |
| CartId | String | False | No | cartId | |
| BaseDiscountAmount | Double | False | No | Discount amount in base currency | |
| BaseGrandTotal | Double | False | No | Grand total in base currency | |
| BaseShippingAmount | Double | False | No | Shipping amount in base currency | |
| BaseShippingDiscountAmount | Double | False | No | Shipping discount amount in base currency | |
| BaseShippingInclTax | Double | False | No | Shipping including tax in base currency | |
| BaseShippingTaxAmount | Double | False | No | Shipping tax amount in base currency | |
| BaseSubtotal | Double | False | No | Subtotal in base currency | |
| BaseSubtotalInclTax | Double | False | No | Subtotal including tax in base currency | |
| BaseSubtotalWithDiscount | Double | False | No | Subtotal in base currency with applied discount | |
| BaseTaxAmount | Double | False | No | Tax amount in base currency | |
| CouponCode | String | False | No | Applied coupon code | |
| DiscountAmount | Double | False | No | Discount amount in quote currency | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| GrandTotal | Double | False | No | Grand total in quote currency | |
| Items | String | False | No | Totals by items | |
| ItemsQty | Int | False | No | Items qty | |
| QuoteCurrencyCode | String | False | No | Quote currency code | |
| ShippingAmount | Double | False | No | Shipping amount in quote currency | |
| ShippingDiscountAmount | Double | False | No | Shipping discount amount in quote currency | |
| ShippingInclTax | Double | False | No | Shipping including tax in quote currency | |
| ShippingTaxAmount | Double | False | No | Shipping tax amount in quote currency | |
| Subtotal | Double | False | No | Subtotal in quote currency | |
| SubtotalInclTax | Double | False | No | Subtotal including tax in quote currency | |
| SubtotalWithDiscount | Double | False | No | Subtotal in quote currency with applied discount | |
| TaxAmount | Double | False | No | Tax amount in quote currency | |
| TotalSegments | String | False | No | Dynamically calculated totals | |
| WeeeTaxAppliedAmount | Double | False | No | Item weee tax applied amount in quote currency. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Adjustment | Double | False | No | Credit memo adjustment. | |
| Id | String | False | No | id | |
| AdjustmentNegative | Double | False | No | Credit memo negative adjustment. | |
| AdjustmentPositive | Double | False | No | Credit memo positive adjustment. | |
| BaseAdjustment | Double | False | No | Credit memo base adjustment. | |
| BaseAdjustmentNegative | Double | False | No | Credit memo negative base adjustment. | |
| BaseAdjustmentPositive | Double | False | No | Credit memo positive base adjustment. | |
| BaseCurrencyCode | String | False | No | Credit memo base currency code. | |
| BaseDiscountAmount | Double | False | No | Credit memo base discount amount. | |
| BaseDiscountTaxCompensationAmount | Double | False | No | Credit memo base discount tax compensation amount. | |
| BaseGrandTotal | Double | False | No | Credit memo base grand total. | |
| BaseShippingAmount | Double | False | No | Credit memo base shipping amount. | |
| BaseShippingDiscountTaxCompensationAmnt | Double | False | No | Credit memo base shipping discount tax compensation amount. | |
| BaseShippingInclTax | Double | False | No | Credit memo base shipping including tax. | |
| BaseShippingTaxAmount | Double | False | No | Credit memo base shipping tax amount. | |
| BaseSubtotal | Double | False | No | Credit memo base subtotal. | |
| BaseSubtotalInclTax | Double | False | No | Credit memo base subtotal including tax. | |
| BaseTaxAmount | Double | False | No | Credit memo base tax amount. | |
| BaseToGlobalRate | Double | False | No | Credit memo base-to-global rate. | |
| BaseToOrderRate | Double | False | No | Credit memo base-to-order rate. | |
| BillingAddressId | Int | False | No | Credit memo billing address ID. | |
| Comments | String | False | No | Array of any credit memo comments. Otherwise, null. | |
| CreatedAt | Datetime | False | No | Credit memo created-at timestamp. | |
| CreditmemoStatus | Int | False | No | Credit memo status. | |
| DiscountAmount | Double | False | No | Credit memo discount amount. | |
| DiscountDescription | String | False | No | Credit memo discount description. | |
| DiscountTaxCompensationAmount | Double | False | No | Credit memo discount tax compensation amount. | |
| EmailSent | Int | False | No | Credit memo email sent flag value. | |
| EntityId [KEY] | Int | False | No | Credit memo ID. | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| GlobalCurrencyCode | String | False | No | Credit memo global currency code. | |
| GrandTotal | Double | False | No | Credit memo grand total. | |
| IncrementId | String | False | No | Credit memo increment ID. | |
| InvoiceId | Int | False | No | Credit memo invoice ID. | |
| Items | String | False | No | Array of credit memo items. | |
| OrderCurrencyCode | String | False | No | Credit memo order currency code. | |
| OrderId | Int | False | No | Credit memo order ID. | |
| ShippingAddressId | Int | False | No | Credit memo shipping address ID. | |
| ShippingAmount | Double | False | No | Credit memo shipping amount. | |
| ShippingDiscountTaxCompensationAmount | Double | False | No | Credit memo shipping discount tax compensation amount. | |
| ShippingInclTax | Double | False | No | Credit memo shipping including tax. | |
| ShippingTaxAmount | Double | False | No | Credit memo shipping tax amount. | |
| State | Int | False | No | Credit memo state. | |
| StoreCurrencyCode | String | False | No | Credit memo store currency code. | |
| StoreId | Int | False | No | Credit memo store ID. | |
| StoreToBaseRate | Double | False | No | Credit memo store-to-base rate. | |
| StoreToOrderRate | Double | False | No | Credit memo store-to-order rate. | |
| Subtotal | Double | False | No | Credit memo subtotal. | |
| SubtotalInclTax | Double | False | No | Credit memo subtotal including tax. | |
| TaxAmount | Double | False | No | Credit memo tax amount. | |
| TransactionId | String | False | No | Credit memo transaction ID. | |
| UpdatedAt | Datetime | False | No | Credit memo updated-at timestamp. | |
| SearchCriteria | String | False | No | This is an auto-generated column | |
| TotalCount | Int | False | No | Total count. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Comment | String | False | No | Comment. | |
| Id | String | False | No | id | |
| CreatedAt | Datetime | False | No | Created-at timestamp. | |
| EntityId [KEY] | Int | False | No | Credit memo ID. | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| IsCustomerNotified | Int | False | No | Is-customer-notified flag value. | |
| IsVisibleOnFront | Int | False | No | Is-visible-on-storefront flag value. | |
| ParentId | Int | False | No | Parent ID. | |
| SearchCriteria | String | False | No | This is an auto-generated column | |
| TotalCount | Int | False | No | Total count. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| BaseCurrencyCode | String | False | No | Base currency code. | |
| Id | String | False | No | id | |
| BaseDiscountAmount | Double | False | No | Base discount amount. | |
| BaseDiscountTaxCompensationAmount | Double | False | No | Base discount tax compensation amount. | |
| BaseGrandTotal | Double | False | No | Base grand total. | |
| BaseShippingAmount | Double | False | No | Base shipping amount. | |
| BaseShippingDiscountTaxCompensationAmnt | Double | False | No | Base shipping discount tax compensation amount. | |
| BaseShippingInclTax | Double | False | No | Base shipping including tax. | |
| BaseShippingTaxAmount | Double | False | No | Base shipping tax amount. | |
| BaseSubtotal | Double | False | No | Base subtotal. | |
| BaseSubtotalInclTax | Double | False | No | Base subtotal including tax. | |
| BaseTaxAmount | Double | False | No | Base tax amount. | |
| BaseToGlobalRate | Double | False | No | Base-to-global rate. | |
| BaseToOrderRate | Double | False | No | Base-to-order rate. | |
| BaseTotalRefunded | Double | False | No | Base total refunded. | |
| BillingAddressId | Int | False | No | Billing address ID. | |
| CanVoidFlag | Int | False | No | Can void flag value. | |
| Comments | String | False | No | Array of any invoice comments. Otherwise, null. | |
| CreatedAt | Datetime | False | No | Created-at timestamp. | |
| DiscountAmount | Double | False | No | Discount amount. | |
| DiscountDescription | String | False | No | Discount description. | |
| DiscountTaxCompensationAmount | Double | False | No | Discount tax compensation amount. | |
| EmailSent | Int | False | No | Email-sent flag value. | |
| EntityId [KEY] | Int | False | No | Invoice ID. | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| GlobalCurrencyCode | String | False | No | Global currency code. | |
| GrandTotal | Double | False | No | Grand total. | |
| IncrementId | String | False | No | Increment ID. | |
| IsUsedForRefund | Int | False | No | Is-used-for-refund flag value. | |
| Items | String | False | No | Array of invoice items. | |
| OrderCurrencyCode | String | False | No | Order currency code. | |
| OrderId | Int | False | No | Order ID. | |
| SearchCriteria | String | False | No | This is an auto-generated column | |
| ShippingAddressId | Int | False | No | Shipping address ID. | |
| ShippingAmount | Double | False | No | Shipping amount. | |
| ShippingDiscountTaxCompensationAmount | Double | False | No | Shipping discount tax compensation amount. | |
| ShippingInclTax | Double | False | No | Shipping including tax. | |
| ShippingTaxAmount | Double | False | No | Shipping tax amount. | |
| State | Int | False | No | State. | |
| StoreCurrencyCode | String | False | No | Store currency code. | |
| StoreId | Int | False | No | Store ID. | |
| StoreToBaseRate | Double | False | No | Store-to-base rate. | |
| StoreToOrderRate | Double | False | No | Store-to-order rate. | |
| Subtotal | Double | False | No | Subtotal. | |
| SubtotalInclTax | Double | False | No | Subtotal including tax. | |
| TaxAmount | Double | False | No | Tax amount. | |
| TotalCount | Int | False | No | Total count. | |
| TotalQty | Double | False | No | Total quantity. | |
| TransactionId | String | False | No | Transaction ID. | |
| UpdatedAt | Datetime | False | No | Updated-at timestamp. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Comment | String | False | No | Comment. | |
| Id | String | False | No | id | |
| CreatedAt | Datetime | False | No | Created-at timestamp. | |
| EntityId [KEY] | Int | False | No | Invoice ID. | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| IsCustomerNotified | Int | False | No | Is-customer-notified flag value. | |
| IsVisibleOnFront | Int | False | No | Is-visible-on-storefront flag value. | |
| ParentId | Int | False | No | Parent ID. | |
| SearchCriteria | String | False | No | This is an auto-generated column | |
| TotalCount | Int | False | No | Total count. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| ActionCondition | String | False | No | This is an auto-generated column | |
| ApplyToShipping | Bool | False | No | The rule applies to shipping | |
| Condition | String | False | No | This is an auto-generated column | |
| CouponType | String | False | No | Coupon type | |
| CustomerGroupIds | String | False | No | Ids of customer groups that the rule applies to | |
| Description | String | False | No | Description | |
| DiscountAmount | Double | False | No | Discount amount | |
| DiscountQty | Double | False | No | Maximum qty discount is applied | |
| DiscountStep | Int | False | No | Discount step | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| FromDate | String | False | No | The start date when the coupon is active | |
| IsActive | Bool | False | No | The coupon is active | |
| IsAdvanced | Bool | False | No | Is this field needed | |
| IsRss | Bool | False | No | Whether the rule is in RSS | |
| Name | String | False | No | Rule name | |
| ProductIds | String | False | No | Product ids | |
| RuleId [KEY] | Int | False | No | Rule id | |
| SimpleAction | String | False | No | Simple action of the rule | |
| SimpleFreeShipping | String | False | No | To grant free shipping | |
| SortOrder | Int | False | No | Sort order | |
| StopRulesProcessing | Bool | False | No | To stop rule processing | |
| StoreLabels | String | False | No | Display label | |
| TimesUsed | Int | False | No | How many times the rule has been used | |
| ToDate | String | False | No | The end date when the coupon is active | |
| UseAutoGeneration | Bool | False | No | To auto generate coupon | |
| UsesPerCoupon | Int | False | No | Limit of uses per coupon | |
| UsesPerCustomer | Int | False | No | Number of uses per customer | |
| WebsiteIds | String | False | No | A list of websites the rule applies to | |
| SearchCriteria | String | False | No | This is an auto-generated column | |
| TotalCount | Int | False | No | Total count. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Code | String | False | No | Coupon code | |
| CouponId [KEY] | Int | False | No | Coupon id | |
| CreatedAt | Datetime | False | No | When the coupon is created | |
| ExpirationDate | String | False | No | Expiration date | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| IsPrimary | Bool | False | No | The coupon is primary coupon for the rule that it’s associated with | |
| RuleId | Int | False | No | The id of the rule associated with the coupon | |
| TimesUsed | Int | False | No | The number of times the coupon has been used | |
| Type | Int | False | No | Of coupon | |
| UsageLimit | Int | False | No | Usage limit | |
| UsagePerCustomer | Int | False | No | Usage limit per customer | |
| SearchCriteria | String | False | No | This is an auto-generated column | |
| TotalCount | Int | False | No | Total count. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| BillingAddressId | Int | False | No | Billing address ID. | |
| Id | String | False | No | id | |
| Comments | String | False | No | Array of comments. | |
| CreatedAt | Datetime | False | No | Created-at timestamp. | |
| CustomerId | Int | False | No | Customer ID. | |
| EmailSent | Int | False | No | Email-sent flag value. | |
| EntityId [KEY] | Int | False | No | Shipment ID. | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| IncrementId | String | False | No | Increment ID. | |
| Items | String | False | No | Array of items. | |
| OrderId | Int | False | No | Order ID. | |
| Packages | String | False | No | Array of packages, if any. Otherwise, null. | |
| ShipmentStatus | Int | False | No | Shipment status. | |
| ShippingAddressId | Int | False | No | Shipping address ID. | |
| ShippingLabel | String | False | No | Shipping label. | |
| StoreId | Int | False | No | Store ID. | |
| TotalQty | Double | False | No | Total quantity. | |
| TotalWeight | Double | False | No | Total weight. | |
| Tracks | String | False | No | Array of tracks. | |
| UpdatedAt | Datetime | False | No | Updated-at timestamp. | |
| SearchCriteria | String | False | No | This is an auto-generated column | |
| TotalCount | Int | False | No | Total count. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Comment | String | False | No | Comment. | |
| Id | String | False | No | id | |
| CreatedAt | Datetime | False | No | Created-at timestamp. | |
| EntityId [KEY] | Int | False | No | Invoice ID. | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| IsCustomerNotified | Int | False | No | Is-customer-notified flag value. | |
| IsVisibleOnFront | Int | False | No | Is-visible-on-storefront flag value. | |
| ParentId | Int | False | No | Parent ID. | |
| SearchCriteria | String | False | No | This is an auto-generated column | |
| TotalCount | Int | False | No | Total count. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| AdditionalInformation | String | False | No | Array of additional information. Otherwise, null. | |
| Id | String | False | No | id | |
| ChildTransactions | String | False | No | Array of child transactions. | |
| CreatedAt | Datetime | False | No | Created-at timestamp. | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| IsClosed | Int | False | No | Is-closed flag value. | |
| OrderId | Int | False | No | Order ID. | |
| ParentId | Int | False | No | The parent ID for the transaction. Otherwise, null. | |
| ParentTxnId | String | False | No | Parent transaction business ID. | |
| PaymentId | Int | False | No | Payment ID. | |
| SearchCriteria | String | False | No | This is an auto-generated column | |
| TotalCount | Int | False | No | Total count. | |
| TransactionId [KEY] | Int | False | No | Transaction ID. | |
| TxnId | String | False | No | Transaction business ID. | |
| TxnType | String | False | No | Transaction type. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Amount | Double | False | No | Shipping amount in store currency. | |
| CartId | String | False | No | cartId | |
| Available | Bool | False | No | The value of the availability flag for the current shipping method. | |
| BaseAmount | Double | False | No | Shipping amount in base currency. | |
| CarrierCode | String | False | No | Shipping carrier code. | |
| CarrierTitle | String | False | No | Shipping carrier title. Otherwise, null. | |
| ErrorMessage | String | False | No | Shipping Error message. | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| MethodCode [KEY] | String | False | No | Shipping method code. | |
| MethodTitle | String | False | No | Shipping method title. Otherwise, null. | |
| PriceExclTax | Double | False | No | Shipping price excl tax. | |
| PriceInclTax | Double | False | No | Shipping price incl tax. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Int | False | No | This is an auto-generated column | |
| DefaultStoreId | Int | False | No | This is an auto-generated column | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| Name | String | False | No | This is an auto-generated column | |
| RootCategoryId | Int | False | No | This is an auto-generated column | |
| WebsiteId | Int | False | No | This is an auto-generated column |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Int | False | No | This is an auto-generated column | |
| Code | String | False | No | This is an auto-generated column | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| Name | String | False | No | Store name | |
| StoreGroupId | Int | False | No | This is an auto-generated column | |
| WebsiteId | Int | False | No | This is an auto-generated column |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Int | False | No | This is an auto-generated column | |
| Code | String | False | No | This is an auto-generated column | |
| DefaultGroupId | Int | False | No | This is an auto-generated column | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| Name | String | False | No | Website name |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| ClassId [KEY] | Int | False | No | Tax class ID. | |
| TaxClassId | String | False | No | taxClassId | |
| ClassName | String | False | No | Tax class name. | |
| ClassType | String | False | No | Tax class type. | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| SearchCriteria | String | False | No | This is an auto-generated column | |
| TotalCount | Int | False | No | Total count. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Int | False | No | Id | |
| Code | String | False | No | Tax rate code | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| Rate | Double | False | No | Tax rate in percentage | |
| RegionName | String | False | No | Region name | |
| TaxCountryId | String | False | No | Country id | |
| TaxPostcode | String | False | No | Postcode | |
| TaxRegionId | Int | False | No | Region id | |
| Titles | String | False | No | Tax rate titles | |
| ZipFrom | Int | False | No | Zip range from | |
| ZipIsRange | Int | False | No | Zip is range | |
| ZipTo | Int | False | No | Zip range to | |
| SearchCriteria | String | False | No | This is an auto-generated column | |
| TotalCount | Int | False | No | Total count. |
| Name | Type | ReadOnly | References | FilterOnly | Description |
|---|---|---|---|---|---|
| Id [KEY] | Int | False | No | Id | |
| CalculateSubtotal | Bool | False | No | Calculate subtotal. | |
| Code | String | False | No | Tax rule code | |
| CustomerTaxClassIds | String | False | No | Customer tax class id | |
| ExtensionAttributes | String | False | No | This is an auto-generated column | |
| Position | Int | False | No | Sort order. | |
| Priority | Int | False | No | Priority | |
| ProductTaxClassIds | String | False | No | Product tax class id | |
| TaxRateIds | String | False | No | Tax rate ids | |
| SearchCriteria | String | False | No | This is an auto-generated column | |
| TotalCount | Int | False | No | Total count. |