invantive documentation
Invantive Support ForumsLog In / Sign Up

WebshopArticleGroupArticleNormalizedProperties: EZ-Base Webshop Article Group Article Normalized Properties

read only XML

  • Catalog: EZBase
  • Label: Webshop Article Group Article Normalized Properties

Can only retrieve data.

API Source

  • XML topic: WebshopArticleGroupArticleNormalizedProperties
  • XML path: /ArticleGroups/ArticleGroup/Articles/Article/NormalizedProperties/Property

Table Columns

The columns of the table WebshopArticleGroupArticleNormalizedProperties are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
HEADER_ATTR int32 Header
INTERFACE_URL varchar2(4000) Interface URL
NORMALIZEDPROPERTIES_ARTICLE_ARTICLEGTIN varchar2 Article Article GTIN
NORMALIZEDPROPERTIES_ARTICLE_ARTICLENUMBER varchar2 Article Article Number
NORMALIZEDPROPERTIES_ARTICLE_ARTICLES_ARTICLEGROUP_ARTICLEGROUPS_WEBSHOP_CLASSIFICATION_NAME_ATTR varchar2 Classification Name
NORMALIZEDPROPERTIES_ARTICLE_ARTICLES_ARTICLEGROUP_ARTICLEGROUPS_WEBSHOP_ETIM_VERSIONNUMBER_ATTR varchar2 ETIM Classification
NORMALIZEDPROPERTIES_ARTICLE_ARTICLES_ARTICLEGROUP_ARTICLEGROUPS_WEBSHOP_EXPORTSELECTIONNAME_ATTR varchar2 Export Selection Name
NORMALIZEDPROPERTIES_ARTICLE_ARTICLES_ARTICLEGROUP_ARTICLEGROUPS_WEBSHOP_LANGUAGE_ATTR int32 Language
NORMALIZEDPROPERTIES_ARTICLE_ARTICLES_ARTICLEGROUP_ARTICLEGROUPS_WEBSHOP_RECEIVERGLN_ATTR varchar2 Receiver GLN
NORMALIZEDPROPERTIES_ARTICLE_ARTICLES_ARTICLEGROUP_ARTICLEGROUPS_WEBSHOP_RELATION_ATTR varchar2 Company Name
NORMALIZEDPROPERTIES_ARTICLE_ARTICLES_ARTICLEGROUP_ARTICLEGROUPS_WEBSHOP_RELATIONGLN_ATTR varchar2 Company GLN
NORMALIZEDPROPERTIES_ARTICLE_ARTICLES_ARTICLEGROUP_ARTICLEGROUPS_WEBSHOP_SENDERGLN_ATTR varchar2 Sender GLN
NORMALIZEDPROPERTIES_ARTICLE_ARTICLES_ARTICLEGROUP_ARTICLEGROUPS_WEBSHOP_TEMPLATESETTINGS_CLASSIFICATIONMAXLEVEL int32 Export Settings Maximum Number of Classifications Displayed
NORMALIZEDPROPERTIES_ARTICLE_ARTICLES_ARTICLEGROUP_ARTICLEGROUPS_WEBSHOP_TEMPLATESETTINGS_DISPLAYSYNONYMS char Export Settings Display Synonyms
NORMALIZEDPROPERTIES_ARTICLE_ARTICLES_ARTICLEGROUP_ARTICLEGROUPS_WEBSHOP_TEMPLATESETTINGS_IMAGECOUNT int32 Export Settings Number of Images Displayed
NORMALIZEDPROPERTIES_ARTICLE_ARTICLES_ARTICLEGROUP_ARTICLEGROUPS_WEBSHOP_TEMPLATESETTINGS_PROPERTYCOUNT int32 Export Settings Number of Properties Displayed
NORMALIZEDPROPERTIES_ARTICLE_ARTICLES_ARTICLEGROUP_ARTICLEGROUPS_WEBSHOP_VERSION_ATTR decimal Version
NORMALIZEDPROPERTIES_ARTICLE_ARTICLES_ARTICLEGROUP_ASSETS varchar2 Article Group Assets
NORMALIZEDPROPERTIES_ARTICLE_ARTICLES_ARTICLEGROUP_BLUEPENCILDATA_SPECIFICATIONBULLETS_ATTR char Edit Data Specification Bullets
NORMALIZEDPROPERTIES_ARTICLE_ARTICLES_ARTICLEGROUP_BLUEPENCILDATA_TRANSPOSED_ATTR char Edit Data Transposed
NORMALIZEDPROPERTIES_ARTICLE_ARTICLES_ARTICLEGROUP_BRAND varchar2 Article Group Brand
NORMALIZEDPROPERTIES_ARTICLE_ARTICLES_ARTICLEGROUP_CLASSIFICATIONS_CLASSIFICATION_ID_ATTR int32 Classification ID
NORMALIZEDPROPERTIES_ARTICLE_ARTICLES_ARTICLEGROUP_CLASSIFICATIONS_CLASSIFICATION_NAME_ATTR varchar2 Classification Name
NORMALIZEDPROPERTIES_ARTICLE_ARTICLES_ARTICLEGROUP_CLASSIFICATIONS_ETIM_ECCODE_ATTR varchar2 ETIM Class Code
NORMALIZEDPROPERTIES_ARTICLE_ARTICLES_ARTICLEGROUP_ID_ATTR int32 Article Group ID
NORMALIZEDPROPERTIES_ARTICLE_ARTICLES_ARTICLEGROUP_KIND varchar2 Article Group Kind
NORMALIZEDPROPERTIES_ARTICLE_ARTICLES_ARTICLEGROUP_LEGACYID_ATTR varchar2 Article Group Legacy ID
NORMALIZEDPROPERTIES_ARTICLE_ARTICLES_ARTICLEGROUP_MANUFACTURERGLN varchar2 Article Group Manufacturer GLN
NORMALIZEDPROPERTIES_ARTICLE_ARTICLES_ARTICLEGROUP_NAME varchar2 Article Group Name
NORMALIZEDPROPERTIES_ARTICLE_ARTICLES_ARTICLEGROUP_POSITION_ATTR int32 Article Group Position
NORMALIZEDPROPERTIES_ARTICLE_ARTICLES_ARTICLEGROUP_STATES_AVAILABLE_FIRST_ATTR varchar2 State Available First
NORMALIZEDPROPERTIES_ARTICLE_ARTICLES_ARTICLEGROUP_STATES_AVAILABLE_LAST_ATTR varchar2 State Available Last
NORMALIZEDPROPERTIES_ARTICLE_ARTICLES_ARTICLEGROUP_STATES_BLUEPENCIL varchar2 State Edit
NORMALIZEDPROPERTIES_ARTICLE_ARTICLES_ARTICLEGROUP_STATES_CLASSIFICATION varchar2 State Classification
NORMALIZEDPROPERTIES_ARTICLE_ARTICLES_ARTICLEGROUP_STATES_CONFIRM varchar2 State Confirm
NORMALIZEDPROPERTIES_ARTICLE_ARTICLES_ARTICLEGROUP_STATES_LIFETIME varchar2 State Life Time
NORMALIZEDPROPERTIES_ARTICLE_ARTICLES_ARTICLEGROUP_STATES_PRODUCTION varchar2 State Production
NORMALIZEDPROPERTIES_ARTICLE_ARTICLES_ARTICLEGROUP_SUPPLIER_DATAPROVIDERGLN_ATTR varchar2 Article Group Supplier Data Provider GLN
NORMALIZEDPROPERTIES_ARTICLE_ARTICLES_ARTICLEGROUP_SUPPLIER_GLN_ATTR varchar2 Article Group Supplier GLN
NORMALIZEDPROPERTIES_ARTICLE_ARTICLES_ARTICLEGROUP_SUPPLIER_ID_ATTR int32 Article Group Supplier ID
NORMALIZEDPROPERTIES_ARTICLE_ARTICLES_ARTICLEGROUP_SUPPLIER_NAME_ATTR varchar2 Article Group Supplier Name
NORMALIZEDPROPERTIES_ARTICLE_ARTICLES_ARTICLEGROUP_SUPPLIER_PURCHASECOMBINATIONGLN_ATTR varchar2 Article Group Supplier Purchase Combination GLN
NORMALIZEDPROPERTIES_ARTICLE_ARTICLES_ARTICLEGROUP_TEMPLATE varchar2 Article Group Template
NORMALIZEDPROPERTIES_ARTICLE_ARTICLESUBGROUP_ATTR int32 Article Sub Group
NORMALIZEDPROPERTIES_ARTICLE_ASSETS varchar2 Article Assets
NORMALIZEDPROPERTIES_ARTICLE_CBSNUMBER varchar2 Article CBS Article Class Number
NORMALIZEDPROPERTIES_ARTICLE_DESCRIPTION varchar2 Article Description
NORMALIZEDPROPERTIES_ARTICLE_ID_ATTR int32 Article ID
NORMALIZEDPROPERTIES_ARTICLE_MANUFACTURERARTICLEGTIN varchar2 Article Manufacturer Article EAN
NORMALIZEDPROPERTIES_ARTICLE_MANUFACTURERARTICLENUMBER varchar2 Article Manufacturer Article Number
NORMALIZEDPROPERTIES_ARTICLE_OWNINFORMATION_ABCCLASSIFICATION varchar2 ABC Classification
NORMALIZEDPROPERTIES_ARTICLE_OWNINFORMATION_OWNARTICLENUMBER varchar2 Own Article Number
NORMALIZEDPROPERTIES_ARTICLE_OWNINFORMATION_OWNDESCRIPTION varchar2 Own Description
NORMALIZEDPROPERTIES_ARTICLE_OWNINFORMATION_OWNPURCHASECOMBINATIONNUMBER varchar2 Own Purchase Combination Number
NORMALIZEDPROPERTIES_ARTICLE_OWNINFORMATION_OWNSTATE varchar2 Own State
NORMALIZEDPROPERTIES_ARTICLE_POSITION_ATTR int32 Article Position
NORMALIZEDPROPERTIES_ARTICLE_STATES_AVAILABLE_END_ATTR varchar2 Article Available State End
NORMALIZEDPROPERTIES_ARTICLE_STATES_AVAILABLE_START_ATTR varchar2 Article Available State Start
NORMALIZEDPROPERTIES_ARTICLE_STATES_LIFETIME varchar2 Life Time
NORMALIZEDPROPERTIES_ARTICLE_STATES_STATE varchar2 State
NORMALIZEDPROPERTIES_ARTICLE_TYPENUMBER varchar2 Article Type Number