DQR 10.0 Struktur XML
- Daniela Ludwig
Header
Externe Struktur | Interne Struktur |
| |||
XML | Sheet-Name | Sheet-ID | Spalten-Name | Spalten-ID | Anmerkungen |
|---|---|---|---|---|---|
Header / sSupplierID | Kopfdaten | SHEET1 | DatenlieferantID | COL0 |
|
Header / sSupplierIDType | Kopfdaten | SHEET1 | Datenlieferant ID Typ | DatenlieferantIDTyp |
|
Header / sSupplierShortName | Kopfdaten | SHEET1 | DatenlieferantName | COL1 |
|
Header / sSupplierSynonym | Kopfdaten | SHEET1 | Datenlieferantkuerzel | COL2 |
|
Header / sCatalogID | Kopfdaten | SHEET1 | KatalogID | COL3 |
|
Header / sCatalogDesc | Kopfdaten | SHEET1 | Katalogname | COL4 |
|
Header / dValidityBegin | Kopfdaten | SHEET1 | Gueltigkeitsbeginn | COL5 |
|
Header / dValidityEnd | Kopfdaten | SHEET1 | Gueltigkeitsende | COL6 |
|
Header / sMessageName | Kopfdaten | SHEET1 | Bezeichnung_der_Datenlieferung | COL7 |
|
Header / sMessageDescription | Kopfdaten | SHEET1 | Hinweise zur Datenlieferung | Hinweis |
|
Header / bIncludesSystemRelevantPackagings | Kopfdaten | SHEET1 | Artikel_mit_systemrelevanter_Verpackung_vorhanden | COL8 |
|
Header / sLUCIDNumber | Kopfdaten | SHEET1 | LUCID-Nummer | COL9 |
|
Header / sPackagingDisposalProvider | Kopfdaten | SHEET1 | Entsorgungsdienstleister | COL10 |
|
Header / sTeststring | Kopfdaten | SHEET1 | Pruefkonstante | COL11 | Neues Feld |
Header / sVersion | Kopfdaten | SHEET1 | Versionsnummer | COL12 | Neues Feld |
Header / sSparepartsystemURL | Kopfdaten | SHEET1 | URL_Ersatzteilsystem | COL13 | Neues Feld |
Header / sSparepartsystemdescription | Kopfdaten | SHEET1 | Beschreibung_Ersatzteilsystem | COL14 | Neues Feld |
Header / sPostAddress | Kopfdaten | SHEET1 | Postadresse | COL15 | Neues Feld |
Header / sElectronicAddress | Kopfdaten | SHEET1 | Elektronische Adresse | COL16 | Neues Feld |
Gruppen
Externe Struktur | Interne Struktur |
| |||
XML | Sheet-Name | Sheet-ID | Spalten-Name | Spalten-ID | Anmerkungen |
|---|---|---|---|---|---|
Waregroups / sWaregroup | SHEET10 | gruppen | Gruppennummer | COL1 | COL0 = WG |
Waregroups / sDescription | SHEET10 | gruppen | Gruppenbezeichnung | COL2 |
|
|
|
|
|
|
|
Productgroups / sProductgroup | SHEET10 | gruppen | Gruppennummer | COL1 | COL0 = PG |
Productgroups / sDescription | SHEET10 | gruppen | Gruppenbezeichnung | COL2 |
|
|
|
|
|
|
|
Discountgroups / sDiscountgroup | SHEET10 | gruppen | Gruppennummer | COL1 | COL0 = DG |
Discountgroups / sDescription | SHEET10 | gruppen | Gruppenbezeichnung | COL2 |
|
|
|
|
|
|
|
Bonusgroups / sBonusgroup | SHEET10 | gruppen | Gruppennummer | COL1 | COL0 = BG |
Bonusgroups / sDescription | SHEET10 | gruppen | Gruppenbezeichnung | COL2 |
|
Articles
Externe Struktur | Interne Struktur |
| |||
XML | Sheet-Name | Sheet-ID | Spalten-Name | Spalten-ID | Anmerkungen |
|---|---|---|---|---|---|
Articles / sArticle | SHEET2 | artikel | Werksartikelnummer | COL0 |
|
Articles / sEan | SHEET2 | artikel | GTIN | COL1 |
|
Articles / cArticletype | SHEET2 | artikel | Artikeltyp | COL2 |
|
Articles / dValidityBegin | SHEET2 | artikel | Gueltigkeitsbeginn | COL3 |
|
Articles / dValidityEnd | SHEET2 | artikel | Gueltigkeitsende | COL4 |
|
Articles / sShorttext1 | SHEET2 | artikel | Kurztext_1 | COL5 |
|
Articles / sShorttext2 | SHEET2 | artikel | Kurztext_2 | COL6 |
|
Articles / sWaregroup | SHEET2 | artikel | Warengruppen_ID | COL7 |
|
Articles / sProductgroup | SHEET2 | artikel | Produktgruppen_ID | COL8 |
|
Articles / sDiscountgroup | SHEET2 | artikel | Rabattgruppen_ID | COL9 |
|
Articles / sBonusgroup | SHEET2 | artikel | Bonusgruppen_ID | COL10 |
|
Articles / nMinOrder | SHEET2 | artikel | MinBestellmenge | COL11 |
|
Articles / cMinOrderUnit | SHEET2 | artikel | MinBestellmengeEinheit | COL12 |
|
Articles / sArticleNumberPrint | SHEET2 | artikel | Werksartikelnummer_Katalog | COL13 |
|
Articles / sAlternate | SHEET2 | artikel | Alternativartikel | COL14 |
|
Articles / sSuccessor_1 | SHEET2 | artikel | Nachfolgeartikelnummer_1 | COL15 |
|
Articles / sSuccessor_2 | SHEET2 | artikel | Nachfolgeartikelnummer_2 | COL16 |
|
Articles / sSuccessor_3 | SHEET2 | artikel | Nachfolgeartikelnummer_3 | COL17 |
|
Articles / sLongtext | SHEET2 | artikel | Langtextnummer | COL18 |
|
Articles / sUrl | SHEET2 | artikel | URL | COL19 |
|
Articles / cDiscontinued | SHEET2 | artikel | Auslaufartikel | COL20 |
|
Articles / dDiscontinuedStart | SHEET2 | artikel | Auslaufdatum | COL21 |
|
Articles / sSparepartlist | SHEET2 | artikel | Ersatzteillistennummer | COL22 |
|
Articles / sExplodedView | SHEET3 | artikeldokumentenzuordnungen | Dokument | COL1 | Alle Dokumente mit Dokumententyp = "X_" |
Articles / dConstructionFrom | SHEET2 | artikel | Baujahr_von | COL23 |
|
Articles / dConstructionTo | SHEET2 | artikel | Baujahr_bis | COL24 |
|
Articles / sConstructiontext | SHEET2 | artikel | Baujahr_Text | COL25 |
|
Articles / bExportabel | SHEET2 | artikel | Exportfaehig | COL26 |
|
Articles / sWaregroupNumber | SHEET2 | artikel | Warennummer | COL27 |
|
Articles / cCountryOfOrigin | SHEET2 | artikel | Ursprungsland | COL28 |
|
Articles / nShelfLife | SHEET2 | artikel | Haltbarkeitszeitraum | COL33 |
|
Articles / nLength | SHEET2 | artikel | Länge_mm | COL39 |
|
Articles / nWidth | SHEET2 | artikel | Breite_mm | COL40 |
|
Articles / nHeight | SHEET2 | artikel | Höhe_mm | COL41 |
|
Articles / nWeight | SHEET2 | artikel | Gewicht_kg | COL42 |
|
Articles / nPackageAmount | SHEET2 | artikel | Anzahl_Packstuecke | COL43 |
|
Articles / cTaxCode | SHEET2 | artikel | Umsatzsteuerklasse | COL44 |
|
Articles / nDeliveryTime | SHEET2 | artikel | Standardlieferzeit | COL45 |
|
Articles / sSerie | SHEET2 | artikel | Serie | COL36 |
|
Articles / sModelNumber | SHEET2 | artikel | Modellnummer | COL37 |
|
Articles / sDescriptionShort | SHEET5 | zusaetzliche_artikeltexte | Artikelkurzbeschreibung | COL1 |
|
Articles / sDescriptionLong | SHEET5 | zusaetzliche_artikeltexte | Artikelbeschreibung | COL2 |
|
Articles / sDescriptionMarketing | SHEET5 | zusaetzliche_artikeltexte | Vermarktungstext | COL3 |
|
Articles / sUsageNode | SHEET5 | zusaetzliche_artikeltexte | Verwendungshinweis | COL4 |
|
Articles / bDeleted | SHEET2 | artikel | Loeschkennzeichen | COL91 |
|
Articles / nCUperOU | SHEET2 | artikel | Inhaltsmenge | Inhaltsmenge |
|
Articles / cContentunit | SHEET2 | artikel | Inhaltseinheit | Inhaltseinheit |
|
Articles / PriceOnDemand | SHEET2 | artikel | Preis_auf_Anfrage | COL38 |
|
Articles / nPricePro | SHEET2 | artikel | Werkslistenpreis_Preiswert | COL46 |
|
Articles / cCurrencyPro | SHEET2 | artikel | Werkslistenpreis_Waehrung | COL47 |
|
Articles / nPricebasePro | SHEET2 | artikel | Werkslistenpreis_Preisbasis | COL48 |
|
Articles / cPriceunitPro | SHEET2 | artikel | Werkslistenpreis_Preismengeneinheit | COL49 |
|
Articles / nPriceUVP | SHEET2 | artikel | UVP_ohne_Steuer_Preiswert | COL50 |
|
Articles / cCurrencyUVP | SHEET2 | artikel | UVP_ohne_Steuer_Waehrung | COL51 |
|
Articles / nPricebaseUVP | SHEET2 | artikel | UVP_ohne_Steuer_Preisbasis | COL52 |
|
Articles / cPriceunitUVP | SHEET2 | artikel | UVP_ohne_Steuer_Preismengeneinheit | COL53 |
|
Articles / PricelLine / sDescription | SHEET15 | Linienpreis | Bezeichnung | Bezeichnung |
|
Articles / PricelLine / nPrice | SHEET15 | Linienpreis | Linienpreis_Preiswert | Linienpreis_Preiswert |
|
Articles / PricelLine / cCurrency | SHEET15 | Linienpreis | Linienpreis_Waehrung | Linienpreis_Waehrung |
|
Articles / PricelLine / nPricebase | SHEET15 | Linienpreis | Linienpreis_Preisbasis | Linienpreis_Preisbasis |
|
Articles / PricelLine / cPriceunit | SHEET15 | Linienpreis | Linienpreis_Preismengeneinheit | Linienpreis_Preismengeneinheit |
|
Articles / PackageUnit [1] / cPackageKind | SHEET2 | artikel | VPE_1_Verpackungsart | COL54 |
|
Articles / PackageUnit [1] / nQuantity | SHEET2 | artikel | VPE_1_Menge | COL55 |
|
Articles / PackageUnit [1] / sEan | SHEET2 | artikel | VPE_1_GTIN | COL56 |
|
Articles / PackageUnit [1] / nLength | SHEET2 | artikel | VPE_1_Länge_mm | COL57 |
|
Articles / PackageUnit [1] / nWidth | SHEET2 | artikel | VPE_1_Breite_mm | COL58 |
|
Articles / PackageUnit [1] / nHeight | SHEET2 | artikel | VPE_1_Höhe_mm | COL59 |
|
Articles / PackageUnit [1] / nWeight | SHEET2 | artikel | VPE_1_Gewicht_kg | COL60 |
|
Articles / PackageUnit [2] / cPackageKind | SHEET2 | artikel | VPE_2_Verpackungsart | COL61 |
|
Articles / PackageUnit [2] / nQuantity | SHEET2 | artikel | VPE_2_Menge | COL62 |
|
Articles / PackageUnit [2] / sEan | SHEET2 | artikel | VPE_2_GTIN | COL63 |
|
Articles / PackageUnit [2] / nLength | SHEET2 | artikel | VPE_1_Länge_mm | COL64 |
|
Articles / PackageUnit [2] / nWidth | SHEET2 | artikel | VPE_1_Breite_mm | COL65 |
|
Articles / PackageUnit [2] / nHeight | SHEET2 | artikel | VPE_1_Höhe_mm | COL66 |
|
Articles / PackageUnit [2] / nWeight | SHEET2 | artikel | VPE_2_Gewicht_kg | COL67 |
|
Articles / PackageUnit [3] / cPackageKind | SHEET2 | artikel | VPE_3_Verpackungsart | COL68 |
|
Articles / PackageUnit [3] / nQuantity | SHEET2 | artikel | VPE_3_Menge | COL69 |
|
Articles / PackageUnit [3] / sEan | SHEET2 | artikel | VPE_3_GTIN | COL70 |
|
Articles / PackageUnit [3] / nLength | SHEET2 | artikel | VPE_2_Länge_mm | COL71 |
|
Articles / PackageUnit [3] / nWidth | SHEET2 | artikel | VPE_2_Breite_mm | COL72 |
|
Articles / PackageUnit [3] / nHeight | SHEET2 | artikel | VPE_2_Höhe_mm | COL73 |
|
Articles / PackageUnit [3] / nWeight | SHEET2 | artikel | VPE_3_Gewicht_kg | COL74 |
|
Articles / PackageUnit [4] / cPackageKind | SHEET2 | artikel | VPE_4_Verpackungsart | COL75 |
|
Articles / PackageUnit [4] / nQuantity | SHEET2 | artikel | VPE_4_Menge | COL76 |
|
Articles / PackageUnit [4] / sEan | SHEET2 | artikel | VPE_4_GTIN | COL77 |
|
Articles / PackageUnit [4] / nLength | SHEET2 | artikel | VPE_4_Länge_mm | COL78 |
|
Articles / PackageUnit [4] / nWidth | SHEET2 | artikel | VPE_4_Breite_mm | COL79 |
|
Articles / PackageUnit [4] / nHeight | SHEET2 | artikel | VPE_4_Höhe_mm | COL80 |
|
Articles / PackageUnit [4] / nWeight | SHEET2 | artikel | VPE_4_Gewicht_kg | COL81 |
|
Articles / PackageUnit [5] / cPackageKind | SHEET2 | artikel | VPE_5_Verpackungsart | COL82 |
|
Articles / PackageUnit [5] / nQuantity | SHEET2 | artikel | VPE_5_Menge | COL83 |
|
Articles / PackageUnit [5] / sEan | SHEET2 | artikel | VPE_5_GTIN | COL84 |
|
Articles / PackageUnit [5] / nLength | SHEET2 | artikel | VPE_5_Länge_mm | COL85 |
|
Articles / PackageUnit [5] / nWidth | SHEET2 | artikel | VPE_5_Breite_mm | COL86 |
|
Articles / PackageUnit [5] / nHeight | SHEET2 | artikel | VPE_5_Höhe_mm | COL87 |
|
Articles / PackageUnit [5] / nWeight | SHEET2 | artikel | VPE_5_Gewicht_kg | COL88 |
|
Articles / ArticleAccessories / sAccessory | SHEET6 | artikelzubehoer | Zubehoerartikel | COL1 |
|
Articles / ArticleAccessories / nAmount | SHEET6 | artikelzubehoer | Menge | COL2 |
|
Articles / ArticlePictures / sDocument | SHEET3 | artikeldokumentenzuordnungen | Dokument | COL1 | Nicht vom Typ "X_" |
Articles / ArticlePictures / cPictureType | SHEET3 | artikeldokumentenzuordnungen | Dokumententyp | COL2 |
|
Articles / ArticlePictures / cPictureUse | SHEET3 | artikeldokumentenzuordnungen | Bild_Verwendung | COL3 |
|
Articles / ArticlePictures / bSubstitute | SHEET3 | artikeldokumentenzuordnungen | Stellvertreterkennzeichen | COL4 |
|
Articles / ArticlePictures / sDocDescription | SHEET3 | artikeldokumentenzuordnungen | Dokument_Bezeichnung | COL5 |
|
Articles / ArticlePictures / nDocOrder | SHEET3 | artikeldokumentenzuordnungen | Dokument_Sortierreihenfolge | COL6 |
|
Articles / ArticleDocuments/ sDocument | SHEET3 | artikeldokumentenzuordnungen | Dokument | COL1 |
|
Articles / ArticleDocuments/ cDocumentType | SHEET3 | artikeldokumentenzuordnungen | Dokumententyp | COL2 |
|
Articles / ArticleDocuments/ sDocDescription | SHEET3 | artikeldokumentenzuordnungen | Dokument_Bezeichnung | COL5 |
|
Articles / ArticleDocuments/ nDocOrder | SHEET3 | artikeldokumentenzuordnungen | Dokument_Sortierreihenfolge | COL6 |
|
Articles / ArticleDocuments/ cLanguage | SHEET3 | artikeldokumentenzuordnungen | Sprache | Sprache |
|
Articles / ArticleAttribute / cAttributesystem | SHEET9 | artikelattribute | Attributsystem | COL1 |
|
Articles / ArticleAttribute / sAttributeclass | SHEET9 | artikelattribute | Attributklasse | COL2 |
|
Articles / ArticleAttribute / sAttributename | SHEET9 | artikelattribute | Attributname | COL3 |
|
Articles / ArticleAttribute / sAttributevalue | SHEET9 | artikelattribute | Attributwert | COL4 |
|
Articles / ArticleAttribute / sAttributevalue2 | SHEET9 | artikelattribute | Attributwert2 | COL5 |
|
Articles / ArticleAttribute / cAttributeunit | SHEET9 | artikelattribute | Attributeinheit | COL6 |
|
Articles / ArticleAttribute / sAttributedescription | SHEET9 | artikelattribute | Attributwertbeschreibung | COL7 |
|
Articles / ArticleTexts / nTextRow | SHEET4 | dimensionstexte | Dimensionstextzeilennummer | COL1 |
|
Articles / ArticleTexts / sDimensiontext | SHEET4 | dimensionstexte | Dimensionstextzeile | COL2 |
|
Articles / ArticleRawmaterials / cMaterial | SHEET8 | rohstoffe | Material | COL1 |
|
Articles / ArticleRawmaterials / nWeigthbase | SHEET8 | rohstoffe | Gewichtsbasis | COL2 |
|
Articles / ArticleRawmaterials / cWeightbaseUnit | SHEET8 | rohstoffe | Basiseinheit | COL3 |
|
Articles / ArticleRawmaterials / nWeigthrate | SHEET8 | rohstoffe | Gewichtsanteil | COL4 |
|
Articles / ArticleRawmaterials / cWeightrateUnit | SHEET8 | rohstoffe | Anteileinheit | COL5 |
|
Articles / ArticleRawmaterials / nQuotationOfRawMaterial | SHEET8 | rohstoffe | Rohstoffnotierung | COL6 |
|
Articles / ArticleSets / sAssignedArticle | SHEET7 | artikelsets | Zugeordneter_Artikel | COL1 |
|
Articles / ArticleSets / nQuantity | SHEET7 | artikelsets | Menge | COL2 |
|
Longtext
Externe Struktur | Interne Struktur |
| |||
XML | Sheet-Name | Sheet-ID | Spalten-Name | Spalten-ID | Anmerkungen |
|---|---|---|---|---|---|
Longtext / sLongtext | SHEET11 | ersatzteillisten | Langtextnummer | COL0 |
|
Longtext / Longtexts / nTextRow | SHEET11 | ersatzteillisten | Langtextzeilennummer | COL1 |
|
Longtext / Longtexts / sText | SHEET11 | ersatzteillisten | Langtextzeile | COL2 |
|
HistoricProducts
Externe Struktur | Interne Struktur |
| |||
XML | Sheet-Name | Sheet-ID | Spalten-Name | Spalten-ID | Anmerkungen |
|---|---|---|---|---|---|
HistoricProducts / sHistoricProduct | SHEET13 | historische_produkte | Historisches_Produkt | COL0 |
|
HistoricProducts / dConstructionFrom | SHEET13 | historische_produkte | Baujahr_von | COL1 |
|
HistoricProducts / dConstructionTo | SHEET13 | historische_produkte | Baujahr_bis | COL2 |
|
HistoricProducts / sConstructiontext | SHEET13 | historische_produkte | Baujahrtext | COL3 |
|
HistoricProducts / sShorttext1 | SHEET13 | historische_produkte | Kurztext_1 | COL4 |
|
HistoricProducts / sShorttext2 | SHEET13 | historische_produkte | Kurztext_2 | COL5 |
|
HistoricProducts / sEan | SHEET13 | historische_produkte | GTIN | COL6 |
|
HistoricProducts / sWaregroup | SHEET13 | historische_produkte | Warengruppen_ID | COL7 |
|
HistoricProducts / sProductgroup | SHEET13 | historische_produkte | Produktgruppen_ID | COL8 |
|
HistoricProducts / sSparepartlist | SHEET13 | historische_produkte | Ersatzteillistennummer | COL9 |
|
HistoricProducts / sExplodedView | SHEET14 | hp_dokumentenzuordnungen | Dokument | COL2 | COL3 = "X_" |
HistoricProducts / HistoricProductPics / sDocument | SHEET14 | hp_dokumentenzuordnungen | Dokument | COL2 | COL3 = "B_", "S_", "U_", "V_", "MI", "DT", "KV", "LS", "LO", "KB", "BF" |
HistoricProducts / HistoricProductPics / cPictureType | SHEET14 | hp_dokumentenzuordnungen | Dokumententyp | COL3 | COL3 = "B_", "S_", "U_", "V_", "MI", "DT", "KV", "LS", "LO", "KB", "BF" |
HistoricProducts / HistoricProductPics / cPictureUse | SHEET14 | hp_dokumentenzuordnungen | Bild_Verwendung | COL4 | COL3 = "B_", "S_", "U_", "V_", "MI", "DT", "KV", "LS", "LO", "KB", "BF" |
HistoricProducts / HistoricProductPics / bSubstitute | SHEET14 | hp_dokumentenzuordnungen | Stellvertreterkennzeichen | COL5 | COL3 = "B_", "S_", "U_", "V_", "MI", "DT", "KV", "LS", "LO", "KB", "BF" |
HistoricProducts / HistoricProductPics / sDocDescription | SHEET14 | hp_dokumentenzuordnungen | Dokument_Bezeichnung | COL6 | COL3 = "B_", "S_", "U_", "V_", "MI", "DT", "KV", "LS", "LO", "KB", "BF" |
HistoricProducts / HistoricProductPics / nDocOrder | SHEET14 | hp_dokumentenzuordnungen | Dokument_Sortierreihenfolge | COL7 | COL3 = "B_", "S_", "U_", "V_", "MI", "DT", "KV", "LS", "LO", "KB", "BF" |
HistoricProducts / HistoricProductDocs / sDocument | SHEET14 | hp_dokumentenzuordnungen | Dokument | COL2 | COL3 = "2D","2F","2S","3C","3B","3A","AN","DB","GG","IS","MA","PA","PP","ZL","SB","SF","PF","TI","TZ","VI","WA","LE","EL","UP","WL","VP","VM","VT","EP","BS","EX","AS","KS","CE","VD","SS" |
HistoricProducts / HistoricProductDocs / cDocumentType | SHEET14 | hp_dokumentenzuordnungen | Dokumententyp | COL3 | COL3 = "2D","2F","2S","3C","3B","3A","AN","DB","GG","IS","MA","PA","PP","ZL","SB","SF","PF","TI","TZ","VI","WA","LE","EL","UP","WL","VP","VM","VT","EP","BS","EX","AS","KS","CE","VD","SS" |
HistoricProducts / HistoricProductDocs / sDocDescription | SHEET14 | hp_dokumentenzuordnungen | Dokument_Bezeichnung | COL6 | COL3 = "2D","2F","2S","3C","3B","3A","AN","DB","GG","IS","MA","PA","PP","ZL","SB","SF","PF","TI","TZ","VI","WA","LE","EL","UP","WL","VP","VM","VT","EP","BS","EX","AS","KS","CE","VD","SS" |
HistoricProducts / HistoricProductDocs / nDocOrder | SHEET14 | hp_dokumentenzuordnungen | Dokument_Sortierreihenfolge | COL7 | COL3 = "2D","2F","2S","3C","3B","3A","AN","DB","GG","IS","MA","PA","PP","ZL","SB","SF","PF","TI","TZ","VI","WA","LE","EL","UP","WL","VP","VM","VT","EP","BS","EX","AS","KS","CE","VD","SS" |
HistoricProducts / HistoricProductDocs / cLanguage | SHEET14 | hp_dokumentenzuordnungen | Dokument_Sortierreihenfolge | COL7 | COL3 = "2D","2F","2S","3C","3B","3A","AN","DB","GG","IS","MA","PA","PP","ZL","SB","SF","PF","TI","TZ","VI","WA","LE","EL","UP","WL","VP","VM","VT","EP","BS","EX","AS","KS","CE","VD","SS" |
Sparepartlists
Externe Struktur | Interne Struktur |
| |||
XML | Sheet-Name | Sheet-ID | Spalten-Name | Spalten-ID | Anmerkungen |
|---|---|---|---|---|---|
Sparepartlists / sList | SHEET12 | ersatzteillisten | Listennummer | COL0 |
|
Sparepartlists / Spareparts / nRow | SHEET12 | ersatzteillisten | Zeilennummer | COL1 |
|
Sparepartlists / Spareparts / TextRow / sPosition | SHEET12 | ersatzteillisten | Positionsnummer | COL2 | COL6 = "ETT" |
Sparepartlists / Spareparts / TextRow / sText | SHEET12 | ersatzteillisten | Text | COL5 | COL6 = "ETT" |
Sparepartlists / Spareparts / ArticleRow / sPosition | SHEET12 | ersatzteillisten | Positionsnummer | COL2 | COL6 = "ETA" |
Sparepartlists / Spareparts / ArticleRow / sPricegroup | SHEET12 | ersatzteillisten | Preisgruppe | COL4 | COL6 = "ETA" |
Sparepartlists / Spareparts / ArticleRow / sText | SHEET12 | ersatzteillisten | Text | COL5 | COL6 = "ETA" |
Sparepartlists / Spareparts / ArticleRow / LinkedArticle / sSparepart | SHEET12 | ersatzteillisten | Ersatzteil | COL3 | COL6 = "ETA" and COL8 = "A" |
Sparepartlists / Spareparts / ArticleRow / LinkedHistoricProduct / sHistoricProduct | SHEET12 | ersatzteillisten | Ersatzteil | COL3 | COL6 = "ETA" and COL8 = "HP" |
Sparepartlists / Spareparts / ArticleRow / LinkedHistoricProduct / dConstructionFrom | SHEET12 | ersatzteillisten | Baujahr_von | COL7 | COL6 = "ETA" and COL8 = "HP" |