Mapping Felder Produktimport
Mit Hilfe der UDT "Mapping Felder ProductUpdate" (VAG_PU_MAPPING) kann konfiguriert werden, welche Felder aus der Importdatei bei Neuanlage und Aktualisierung beim Import berücksichtigt werden sollen.
Die Felder "Quelldeld" und "Zielfeld" dienen hierbei lediglich der Information.
Über die Spalte "Name Checkbox" wird festgelegt, welche Chekcboxen in der Maske zum Import der Produktdaten angezeigt werden sollen.
Über die Haken "Neuanlage" und "Aktualisierung" kann festgelegt werden, für welchen Importtyp diese Checkbox aktiv sein soll.
Beispielsweise kann darüber festgelegt werden, dass der Artikelname nur bei Neuanlage eines Artikels gesetzt werden soll, bei einer Aktualisierung eines Artikels jedoch nicht aktualisiert werden soll.
<style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page { mso-header-data:""; mso-footer-data:""; margin:0.787401575in 0.7in 0.787401575in 0.7in; mso-header-margin:0.3in; mso-footer-margin:0.3in; mso-page-orientation:Portrait; }tr {mso-height-source:auto; mso-ruby-visibility:none;}col {mso-width-source:auto; mso-ruby-visibility:none;}br {mso-data-placement:same-cell;}ruby {ruby-align:left;}.style0 { mso-number-format:General; text-align:general; vertical-align:bottom; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:11pt; font-weight:400; font-style:normal; font-family:"Calibri","sans-serif"; border:none; mso-protection:locked visible; mso-style-name:Normal; mso-style-id:0;}.font0 { color:#000000; font-size:11pt; font-weight:400; font-style:normal; font-family:"Calibri","sans-serif"; }.font1 { color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; }td {mso-style-parent:style0; mso-number-format:General; text-align:general; vertical-align:bottom; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:11pt; font-weight:400; font-style:normal; font-family:"Calibri","sans-serif"; border:none; mso-protection:locked visible; mso-ignore:padding;}.style0 { text-align:general; vertical-align:bottom; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:11pt; font-weight:400; font-style:normal; font-family:"Calibri","sans-serif"; mso-protection:locked visible; mso-style-name:"Normal"; }.style1 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style2 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style3 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style4 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style5 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style6 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style7 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style8 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style9 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style10 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style11 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style12 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style13 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style14 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.x15 { mso-style-parent:style0; mso-number-format:General; text-align:general; vertical-align:bottom; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:11pt; font-weight:400; font-style:normal; font-family:"Calibri","sans-serif"; mso-protection:locked visible; }--></style><div class="cells-worksheet" data-sheet-number="0" data-sheet-name="Tabelle1"><table border="0" cellpadding="0" cellspacing="0" style="border-collapse:collapse;table-layout:fixed;width:828pt"> <colgroup> <col span="2" style="width:80px"></col> <col style="mso-width-source:userset;width:284px"></col> <col style="mso-width-source:userset;width:161px"></col> <col style="mso-width-source:userset;width:107px"></col> <col style="mso-width-source:userset;width:153px"></col> <col span="3" style="width:80px"></col> </colgroup> <tbody> <tr style="mso-height-source:userset;height:15pt" id="r0"> <td style="height:15pt;width:60pt">Code</td> <td style="width:60pt">Name</td> <td style="width:213pt">Quellfeld</td> <td style="width:120.75pt">Zielfeld</td> <td style="width:80.25pt;overflow:hidden">Name Checkbox</td> <td style="width:114.75pt">Beschr. Checkbox</td> <td style="width:60pt">Neuanlage</td> <td style="width:60pt;overflow:hidden">Aktualisierung</td> <td style="width:60pt">Beschreibung</td> </tr> <tr style="mso-height-source:userset;height:15pt" id="r1"> <td style="text-align:right;height:15pt">1</td> <td style="text-align:right">1</td> <td>Name</td> <td>ItemName</td> <td>cbName</td> <td>Name</td> <td>Y</td> <td>Y</td> <td></td> </tr> <tr style="mso-height-source:userset;height:15pt" id="r2"> <td style="text-align:right;height:15pt">2</td> <td style="text-align:right">2</td> <td>ArticleIdEan</td> <td>CodeBars</td> <td>cbEan</td> <td>Barcode</td> <td>Y</td> <td>Y</td> <td></td> </tr> <tr style="mso-height-source:userset;height:15pt" id="r3"> <td style="text-align:right;height:15pt">3</td> <td style="text-align:right">3</td> <td>ArticleIdSupplier</td> <td>Substitute</td> <td>cbSuItmCod</td> <td>Herstellerartikelnr.</td> <td>Y</td> <td>Y</td> <td></td> </tr> <tr style="mso-height-source:userset;height:15pt" id="r4"> <td style="text-align:right;height:15pt">4</td> <td style="text-align:right">4</td> <td>ShortDescription</td> <td>UserText</td> <td>cbShrtDesc</td> <td>Kurzbezeichnung</td> <td>Y</td> <td>Y</td> <td></td> </tr> <tr style="mso-height-source:userset;height:15pt" id="r5"> <td style="text-align:right;height:15pt">5</td> <td style="text-align:right">5</td> <td>Description</td> <td style="overflow:hidden">U_VAG_MC_LongName</td> <td>cbLongDesc</td> <td>Langbeschreibung</td> <td>Y</td> <td>Y</td> <td></td> </tr> <tr style="mso-height-source:userset;height:15pt" id="r6"> <td style="text-align:right;height:15pt">6</td> <td style="text-align:right">6</td> <td>MinimumOrderQuantity</td> <td>MinOrdrQty</td> <td>cbMinQty</td> <td>Mindestauftragsmenge</td> <td>Y</td> <td>Y</td> <td></td> </tr> <tr style="mso-height-source:userset;height:15pt" id="r7"> <td style="text-align:right;height:15pt">7</td> <td style="text-align:right">7</td> <td>OrderQuantityInterval</td> <td>OrdrMulti</td> <td>cbQtyIntvl</td> <td>Auftragsvielfaches</td> <td>Y</td> <td>Y</td> <td></td> </tr> <tr style="mso-height-source:userset;height:15pt" id="r8"> <td style="text-align:right;height:15pt">8</td> <td style="text-align:right">8</td> <td>ClassificationPath</td> <td style="overflow:hidden">U_VAG_MC_PMCategory</td> <td>cbCtyPath</td> <td>Kategoriepfad</td> <td>Y</td> <td>Y</td> <td></td> </tr> <tr style="mso-height-source:userset;height:15pt" id="r9"> <td style="text-align:right;height:15pt">9</td> <td style="text-align:right">9</td> <td>Supplier</td> <td>CardCode</td> <td>cbSuplId</td> <td>PM ID Lieferant</td> <td>Y</td> <td>Y</td> <td></td> </tr> <tr style="mso-height-source:userset;height:15pt" id="r10"> <td style="text-align:right;height:15pt">10</td> <td style="text-align:right">10</td> <td>DangerousGoods</td> <td>U_VAG_MCP160</td> <td>cbDanGoods</td> <td>PM ID Gefahrgut</td> <td>Y</td> <td>Y</td> <td></td> </tr> <tr style="mso-height-source:userset;height:15pt" id="r11"> <td style="text-align:right;height:15pt">11</td> <td style="text-align:right">11</td> <td>BuyUnit</td> <td>BuyUnitMsr</td> <td>cbBuyUnit</td> <td>Einkaufsmengen</td> <td>Y</td> <td>Y</td> <td></td> </tr> <tr style="mso-height-source:userset;height:15pt" id="r12"> <td style="text-align:right;height:15pt">12</td> <td style="text-align:right">12</td> <td>SellUnit</td> <td>SalUnitMsr</td> <td>cbSellUnit</td> <td>Verkaufsmengen</td> <td>Y</td> <td>Y</td> <td></td> </tr> <tr style="mso-height-source:userset;height:15pt" id="r13"> <td style="text-align:right;height:15pt">13</td> <td style="text-align:right">13</td> <td>OrderUnit</td> <td>InvntryUom</td> <td>cbBaseUnit</td> <td>Basismengen</td> <td>Y</td> <td>Y</td> <td></td> </tr> <tr style="mso-height-source:userset;height:15pt" id="r14"> <td style="text-align:right;height:15pt">14</td> <td style="text-align:right">14</td> <td>VatRate</td> <td></td> <td>cbMwst</td> <td>MwSt.</td> <td>Y</td> <td>Y</td> <td></td> </tr> <tr style="display:none"> <td style="width:60pt"></td> <td style="width:60pt"></td> <td style="width:213pt"></td> <td style="width:120.75pt"></td> <td style="width:80.25pt"></td> <td style="width:114.75pt"></td> <td style="width:60pt"></td> <td style="width:60pt"></td> <td style="width:60pt"></td> </tr> </tbody></table></div>