Please enable JavaScript to view this site.

Error itgendoc001X

xMsg javascript has not been loaded.

EZ-Base Data Model

Navigation: Schema:  > Tables

WebshopArticleGroupArticleProductDetailPrices: EZ-base Webshop Article Group Article Prices

 Contents Previous Home Next More

Catalog: EZBase

Label: Webshop Article Group Article Prices

The data in this table is partitioned per value of the column.

This is a read-only table. The EZ-base API may not support changing the data or the Invantive SQL driver for EZ-base does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the EZ-base API.

Topic: WebshopArticleGroupArticleProductDetailPrices

Base XPath: /Webshop

XPath: /ArticleGroups/ArticleGroup/Articles/Article/ProductDetailPrices/Price

Table Columns

The columns of the table WebshopArticleGroupArticleProductDetailPrices are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

ARTICLEDESCRIPTION

string

Article Description

 

 

GROSSPRICE

string

Gross Price

 

 

INTERFACE_URL

string(4000)

Interface URL

☑

 

MINIMUMBUYINGQUANTITY

string

Minimum Buying Quantity

 

 

NETPRICE

string

Net Price

 

 

PRICEBASEQUANTITY

string

Price Base Quantity

 

 

PRICELISTNAME_ATTR

string

Price List Name

 

 

PRODUCTDETAILPRICES_ARTICLE_ARTICLEGTIN

string

Article Article GTIN

 

 

PRODUCTDETAILPRICES_ARTICLE_ARTICLENUMBER

string

Article Article Number

 

 

PRODUCTDETAILPRICES_ARTICLE_ARTICLES_ARTICLEGROUP_ARTICLEGROUPS_WEBSHOP_CLASSIFICATION_NAME_ATTR

string

Classification Name

 

 

PRODUCTDETAILPRICES_ARTICLE_ARTICLES_ARTICLEGROUP_ARTICLEGROUPS_WEBSHOP_ETIM_VERSIONNUMBER_ATTR

string

ETIM Classification

 

 

PRODUCTDETAILPRICES_ARTICLE_ARTICLES_ARTICLEGROUP_ARTICLEGROUPS_WEBSHOP_EXPORTSELECTIONNAME_ATTR

string

Export Selection Name

 

 

PRODUCTDETAILPRICES_ARTICLE_ARTICLES_ARTICLEGROUP_ARTICLEGROUPS_WEBSHOP_LANGUAGE_ATTR

int32

Language

 

 

PRODUCTDETAILPRICES_ARTICLE_ARTICLES_ARTICLEGROUP_ARTICLEGROUPS_WEBSHOP_RECEIVERGLN_ATTR

string

Receiver GLN

 

 

PRODUCTDETAILPRICES_ARTICLE_ARTICLES_ARTICLEGROUP_ARTICLEGROUPS_WEBSHOP_RELATION_ATTR

string

Company Name

 

 

PRODUCTDETAILPRICES_ARTICLE_ARTICLES_ARTICLEGROUP_ARTICLEGROUPS_WEBSHOP_RELATIONGLN_ATTR

string

Company GLN

 

 

PRODUCTDETAILPRICES_ARTICLE_ARTICLES_ARTICLEGROUP_ARTICLEGROUPS_WEBSHOP_SENDERGLN_ATTR

string

Sender GLN

 

 

PRODUCTDETAILPRICES_ARTICLE_ARTICLES_ARTICLEGROUP_ARTICLEGROUPS_WEBSHOP_TEMPLATESETTINGS_CLASSIFICATIONMAXLEVEL

int32

Export Settings Maximum Number of Classifications Displayed

 

 

PRODUCTDETAILPRICES_ARTICLE_ARTICLES_ARTICLEGROUP_ARTICLEGROUPS_WEBSHOP_TEMPLATESETTINGS_DISPLAYSYNONYMS

boolean

Export Settings Display Synonyms

 

 

PRODUCTDETAILPRICES_ARTICLE_ARTICLES_ARTICLEGROUP_ARTICLEGROUPS_WEBSHOP_TEMPLATESETTINGS_IMAGECOUNT

int32

Export Settings Number of Images Displayed

 

 

PRODUCTDETAILPRICES_ARTICLE_ARTICLES_ARTICLEGROUP_ARTICLEGROUPS_WEBSHOP_TEMPLATESETTINGS_PROPERTYCOUNT

int32

Export Settings Number of Properties Displayed

 

 

PRODUCTDETAILPRICES_ARTICLE_ARTICLES_ARTICLEGROUP_ARTICLEGROUPS_WEBSHOP_VERSION_ATTR

decimal

Version

 

 

PRODUCTDETAILPRICES_ARTICLE_ARTICLES_ARTICLEGROUP_ASSETS

string

Article Group Assets

 

 

PRODUCTDETAILPRICES_ARTICLE_ARTICLES_ARTICLEGROUP_BLUEPENCILDATA_SPECIFICATIONBULLETS_ATTR

boolean

Edit Data Specification Bullets

 

 

PRODUCTDETAILPRICES_ARTICLE_ARTICLES_ARTICLEGROUP_BLUEPENCILDATA_TRANSPOSED_ATTR

boolean

Edit Data Transposed

 

 

PRODUCTDETAILPRICES_ARTICLE_ARTICLES_ARTICLEGROUP_BRAND

string

Article Group Brand

 

 

PRODUCTDETAILPRICES_ARTICLE_ARTICLES_ARTICLEGROUP_CLASSIFICATIONS_CLASSIFICATION_ID_ATTR

int32

Classification ID

 

 

PRODUCTDETAILPRICES_ARTICLE_ARTICLES_ARTICLEGROUP_CLASSIFICATIONS_CLASSIFICATION_NAME_ATTR

string

Classification Name

 

 

PRODUCTDETAILPRICES_ARTICLE_ARTICLES_ARTICLEGROUP_CLASSIFICATIONS_ETIM_ECCODE_ATTR

string

ETIM Class Code

 

 

PRODUCTDETAILPRICES_ARTICLE_ARTICLES_ARTICLEGROUP_ID_ATTR

int32

Article Group ID

 

 

PRODUCTDETAILPRICES_ARTICLE_ARTICLES_ARTICLEGROUP_KIND

string

Article Group Kind

 

 

PRODUCTDETAILPRICES_ARTICLE_ARTICLES_ARTICLEGROUP_LEGACYID_ATTR

string

Article Group Legacy ID

 

 

PRODUCTDETAILPRICES_ARTICLE_ARTICLES_ARTICLEGROUP_MANUFACTURERGLN

string

Article Group Manufacturer GLN

 

 

PRODUCTDETAILPRICES_ARTICLE_ARTICLES_ARTICLEGROUP_NAME

string

Article Group Name

 

 

PRODUCTDETAILPRICES_ARTICLE_ARTICLES_ARTICLEGROUP_POSITION_ATTR

int32

Article Group Position

 

 

PRODUCTDETAILPRICES_ARTICLE_ARTICLES_ARTICLEGROUP_STATES_AVAILABLE_FIRST_ATTR

string

State Available First

 

 

PRODUCTDETAILPRICES_ARTICLE_ARTICLES_ARTICLEGROUP_STATES_AVAILABLE_LAST_ATTR

string

State Available Last

 

 

PRODUCTDETAILPRICES_ARTICLE_ARTICLES_ARTICLEGROUP_STATES_BLUEPENCIL

string

State Edit

 

 

PRODUCTDETAILPRICES_ARTICLE_ARTICLES_ARTICLEGROUP_STATES_CLASSIFICATION

string

State Classification

 

 

PRODUCTDETAILPRICES_ARTICLE_ARTICLES_ARTICLEGROUP_STATES_CONFIRM

string

State Confirm

 

 

PRODUCTDETAILPRICES_ARTICLE_ARTICLES_ARTICLEGROUP_STATES_LIFETIME

string

State Life Time

 

 

PRODUCTDETAILPRICES_ARTICLE_ARTICLES_ARTICLEGROUP_STATES_PRODUCTION

string

State Production

 

 

PRODUCTDETAILPRICES_ARTICLE_ARTICLES_ARTICLEGROUP_SUPPLIER_DATAPROVIDERGLN_ATTR

string

Article Group Supplier Data Provider GLN

 

 

PRODUCTDETAILPRICES_ARTICLE_ARTICLES_ARTICLEGROUP_SUPPLIER_GLN_ATTR

string

Article Group Supplier GLN

 

 

PRODUCTDETAILPRICES_ARTICLE_ARTICLES_ARTICLEGROUP_SUPPLIER_ID_ATTR

int32

Article Group Supplier ID

 

 

PRODUCTDETAILPRICES_ARTICLE_ARTICLES_ARTICLEGROUP_SUPPLIER_NAME_ATTR

string

Article Group Supplier Name

 

 

PRODUCTDETAILPRICES_ARTICLE_ARTICLES_ARTICLEGROUP_SUPPLIER_PURCHASECOMBINATIONGLN_ATTR

string

Article Group Supplier Purchase Combination GLN

 

 

PRODUCTDETAILPRICES_ARTICLE_ARTICLES_ARTICLEGROUP_TEMPLATE

string

Article Group Template

 

 

PRODUCTDETAILPRICES_ARTICLE_ARTICLESUBGROUP_ATTR

int32

Article Sub Group

 

 

PRODUCTDETAILPRICES_ARTICLE_ASSETS

string

Article Assets

 

 

PRODUCTDETAILPRICES_ARTICLE_CBSNUMBER

string

Article CBS Article Class Number

 

 

PRODUCTDETAILPRICES_ARTICLE_DESCRIPTION

string

Article Description

 

 

PRODUCTDETAILPRICES_ARTICLE_ID_ATTR

int32

Article ID

 

 

PRODUCTDETAILPRICES_ARTICLE_MANUFACTURERARTICLEGTIN

string

Article Manufacturer Article EAN

 

 

PRODUCTDETAILPRICES_ARTICLE_MANUFACTURERARTICLENUMBER

string

Article Manufacturer Article Number

 

 

PRODUCTDETAILPRICES_ARTICLE_OWNINFORMATION_ABCCLASSIFICATION

string

ABC Classification

 

 

PRODUCTDETAILPRICES_ARTICLE_OWNINFORMATION_OWNARTICLENUMBER

string

Own Article Number

 

 

PRODUCTDETAILPRICES_ARTICLE_OWNINFORMATION_OWNDESCRIPTION

string

Own Description

 

 

PRODUCTDETAILPRICES_ARTICLE_OWNINFORMATION_OWNPURCHASECOMBINATIONNUMBER

string

Own Purchase Combination Number

 

 

PRODUCTDETAILPRICES_ARTICLE_OWNINFORMATION_OWNSTATE

string

Own State

 

 

PRODUCTDETAILPRICES_ARTICLE_POSITION_ATTR

int32

Article Position

 

 

PRODUCTDETAILPRICES_ARTICLE_STATES_AVAILABLE_END_ATTR

string

Article Available State End

 

 

PRODUCTDETAILPRICES_ARTICLE_STATES_AVAILABLE_START_ATTR

string

Article Available State Start

 

 

PRODUCTDETAILPRICES_ARTICLE_STATES_LIFETIME

string

Life Time

 

 

PRODUCTDETAILPRICES_ARTICLE_STATES_STATE

string

State

 

 

PRODUCTDETAILPRICES_ARTICLE_TYPENUMBER

string

Article Type Number

 

 

UNITOFMEASUREPRICEBASE

string

UOM Price Base

 

 

 

12-12-2020 20:01 Version 20.1.301-BETA+3023