Excel und BMECat Vergleich

Excel Begriff

BMEcat Begriff

SupplierID

<SUPPLIER_ID type="duns">340487466</SUPPLIER_ID>

SupplierName

<SUPPLIER_NAME>BeNeering</SUPPLIER_NAME>

SupplierAID

<SUPPLIER_AID>19VDHL001</SUPPLIER_AID>

ManufacturerName

<MANUFACTURER_NAME>Sanmar</MANUFACTURER_NAME>

ManufacturerAID

<MANUFACTURER_AID>19VDHL001</MANUFACTURER_AID>

Language

<LANGUAGE>deu</LANGUAGE>

DesctiptionShort

<DESCRIPTION_SHORT>*Stocked Item Short Sleeve Black T Shirt</DESCRIPTION_SHORT>

DescriptionLong

<DESCRIPTION_LONG>In stock and ready to ship. A reliable choice for comfort, softness and durability. Short sleeved t-shirt in 5.5-ounce, 50/50 cotton/poly. Made with up to 5% recycled polyester from plastic bottles.</DESCRIPTION_LONG>

DeliveryTime

DELIVERY_TIME>3</DELIVERY_TIME>

Keywords

<KEYWORD>Apparel</KEYWORD>
<KEYWORD>Man</KEYWORD>

BoostingWords

<REFERENCE_FEATURE_GROUP_ID>21100420</REFERENCE_FEATURE_GROUP_ID>

EAN

EAN>8712670911213</EAN>

BuyerAID

<BUYER_AID type="buyer_specific">123456</BUYER_AID>

Catalog

<CATALOG_NAME>BeNeering</CATALOG_NAME>

CatalogViews

<FEATURE>
<FNAME>CATALOG_VIEWS</FNAME>
<FVALUE>View1,View2,View3</FVALUE>
</FEATURE>

CoreArticle

<ARTICLE_STATUS type="core_article">Y</ARTICLE_STATUS>

HazardousGood

<SPECIAL_TREATMENT_CLASS type="HazardousGood">N</SPECIAL_TREATMENT_CLASS>

HazardousSubstance

<SPECIAL_TREATMENT_CLASS type="HazardousSubstance">N</SPECIAL_TREATMENT_CLASS>

CatalogManaged

<FEATURE>
<FNAME>CATALOG_MANAGED</FNAME>
<FVALUE>X</FVALUE>
</FEATURE>

DwfLcat

<FEATURE>
<FNAME>DWF_L_CAT</FNAME>
<FVALUE>BENEERING</FVALUE>
</FEATURE>

DwfVend

<FEATURE>
<FNAME>DWF_VEND</FNAME>
<FVALUE>BENEERING</FVALUE>
</FEATURE>

DwfProd

FEATURE>
<FNAME>DWF_PROD</FNAME>
<FVALUE>SIZE</FVALUE>
</FEATURE>

DwfService

<FEATURE>
<FNAME>DWF_SERVICE</FNAME>
<FVALUE>CSE</FVALUE>
</FEATURE>

ArticleOrderDetails.OrderUnit
ArticleOrderDetails.PriceQuantity
ArticleOrderDetails.QuantityMin
ArticleOrderDetails.QuantityInterval

<ARTICLE_ORDER_DETAILS>
<ORDER_UNIT>EA</ORDER_UNIT>
<PRICE_QUANTITY>1.00</PRICE_QUANTITY>
<QUANTITY_MIN>1</QUANTITY_MIN>
<QUANTITY_INTERVAL>1</QUANTITY_INTERVAL>
</ARTICLE_ORDER_DETAILS>

ArticlePriceDetails.ValidStartDate

<DATETIME type="agreement_start_date">
<DATE>2021-04-15</DATE>
</DATETIME>

ArticlePriceDetails.ValidEndDate

<DATETIME type="agreement_end_date">
<DATE>2022-04-30</DATE>
</DATETIME>
</AGREEMENT>

ArticlePriceDetails.ArticlePrice.1.PriceType
ArticlePriceDetails.ArticlePrice.1.PriceAmount
ArticlePriceDetails.ArticlePrice.1.PriceCurrency
ArticlePriceDetails.ArticlePrice.1.Tax
ArticlePriceDetails.ArticlePrice.1.PriceFactor
ArticlePriceDetails.ArticlePrice.1.LowerBound

<ARTICLE_PRICE price_type="net_customer">
<PRICE_AMOUNT>9.56</PRICE_AMOUNT>
<PRICE_CURRENCY>USD</PRICE_CURRENCY>
<TAX>0.07</TAX>
<PRICE_FACTOR>1</PRICE_FACTOR>
<LOWER_BOUND>1</LOWER_BOUND>
</ARTICLE_PRICE>

Target.ClassificationSystem

<REFERENCE_FEATURE_SYSTEM_NAME>ECLASS-5.1.2</REFERENCE_FEATURE_SYSTEM_NAME>

Target.ClassificationID

<REFERENCE_FEATURE_GROUP_ID>21100420</REFERENCE_FEATURE_GROUP_ID>

Mime.1.MimeType
Mime.1.MimeSource
Mime.1.MimeDescr
Mime.1.MimePurpose
Mime.2.MimeType
Mime.2.MimeSource
Mime.2.MimeDescr
Mime.2.MimePurpose

<MIME_INFO>
<MIME>
<MIME_TYPE>image/jpeg</MIME_TYPE>
<MIME_SOURCE>219VDHL001.jpg</MIME_SOURCE>
<MIME_DESCR>Product Image</MIME_DESCR>
<MIME_PURPOSE>normal</MIME_PURPOSE>
</MIME>
<MIME>
<MIME_TYPE>image/jpeg</MIME_TYPE>
<MIME_SOURCE>19VDHL002.jpg</MIME_SOURCE>
<MIME_DESCR>Product Image</MIME_DESCR>
<MIME_PURPOSE>normal</MIME_PURPOSE>
</MIME>
</MIME_INFO>

DocField.1.Name
DocField.1.Value
DocField.2.Name
DocField.2.Value

<FEATURE>
<FNAME>COLOR</FNAME>
<FVALUE>Visible=Black</FVALUE>
</FEATURE>
<FEATURE>
<FNAME>SIZE</FNAME>
<FVALUE>Visible=Small (+0.00$),Suffix=-S,Surcharge=.00|Visible=Medium (+0.00$),Suffix=-M,Surcharge=.00|Visible=Large (+0.00$),Suffix=-L,Surcharge=.00|Visible=Xlarge (+0.00$),Suffix=-XL,Surcharge=.00|Visible=2Xlarge (+2.46$),Suffix=-2X,Surcharge=2.46|Visible=3Xlarge (+2.46$),Suffix=-3X,Surcharge=2.46|Visible=4Xlarge (+2.46$),Suffix=-4X,Surcharge=2.46|Visible=5Xlarge (+2.46$),Suffix=-5X,Surcharge=2.46|Visible=6Xlarge (+2.46$),Suffix=-6X,Surcharge=2.46</FVALUE>
</FEATURE>

DocField.3.Name
DocField.3.Value
DocField.4.Name
DocField.4.Value
DocField.5.Name
DocField.5.Value

<USER_DEFINED_EXTENSIONS>
<UDX.URSPRUNGSLAND>CN</UDX.URSPRUNGSLAND>
<UDX.BREITE>80,00</UDX.BREITE>
<UDX.HOEHE>70,00</UDX.HOEHE>
</USER_DEFINED_EXTENSIONS>

Relation.1.Type
Relation.1.SupplierAID

<ARTICLE_REFERENCE type="mandatory">
<ART_ID_TO>RELATED_ITEM</ART_ID_TO>
</ARTICLE_REFERENCE>