{"text_format":"2","workbook":"xls","n_sheets":8,"sheets":["Übersicht","Kopf-Rahmen","Kopf-Freier-Text","Kopf-Beteiligte","Kopf-Beteiligte einzeln","Position","PosText","Zu-Abschläge"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Übersicht","index":0,"n_rows":167,"n_cols":9,"rows_kept":167,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["B&N RCV-ORDERS",null,null,"Erstellt am 07.06.2005"]
["Übersicht "]
["#","Feld","Format","Rahmen- Informationen","Freier Text","Beteiligte","Position","PosText","Zu-Abschläge"]
["1","SndRec","an3","RCV","<---","<---","<---","<---","<---"]
["2","PrtNum","an35","ILN des Daten-Absenders","<---","<---","<---","<---","<---"]
["3","MsgTyp","an6","ORDERS","<---","<---","<---","<---","<---"]
["4","MaiKey","an35","Eindeutige Nummer von m@gic EDDY vergeben","<---","<---","<---","<---","<---"]
["5","HrcLvl","an9","100000000","110000000","120000000","150000000","154000000","155000000"]
["6","LinNum","n6","0","laufende Nummer über alle Sätze","laufende Nummer über alle Sätze","laufende Nummer über alle Sätze","laufende Nummer über alle Sätze","laufende Nummer über alle Sätze"]
["7","a1#01","an1","Testkennzeichen: 1=Test, leer=produktiv"]
["8","a1#02","an1","Syntax-Versionsnummer"]
["9","a3#01","an3",null,"Textzuordnung, codiert","Beteiligter, Qual.SU=Lieferant,IV=Rg-Empf,BY=Käufer","Masseinheit der bestellte Menge, Qual. z.B. PCE=Stueck","Textzuordnung, codiert ; AAK=Preiskonditionen, PUR=Beschaffungsinforma","Zu- oder Abschlag, Qualifier A=Abschlag, C=Zuschlag"]
["10","a3#02","an3","Dokumententyp, codiert 220=Bestellung; 50E=Transit-Auftrag","Freier Text, codiert",null,null,null,"Kalkulations-Folge-Anzeiger,cod. 1=Erste Kalkulationsstufe, 2=... "]
["11","a3#03","an3",null,"Codeliste, Qualifier",null,"Preisart, Qualifier Nettopreis ",null,"Zu-/Abschlaege, cod. DI=Abzug, EAB-Skonto, FC-Frachtgeb.           "]
["12","a3#04","an3","Dokumentenfunktion, codiert 9=Original; 7=Duplikat","Sprache, codiert",null,"Preisart, Qualifier Bruttopreis",null,"Verantwortliche Stelle für die Codepflege zu Dienst/Leistung;; 9=EAN,"]
["13","a3#05","an3"]
["14","a3#06","an3","Währung",null,null,"Währung, codiert"]
["15","a3#07","an3"]
["16","a3#08","an3",null,null,null,"Masseinheit der Preisbasis-Menge, Qual. z.B. PCE=Stueck"]
["17","a3#09","an3"]
["18","a3#10","an3",null,null,"Qualifier 1(TE=Telefonnr.,FX=Telefaxnr.)","Qualifier Artikelnummer 1"]
["19","a3#11","an3",null,null,"Qualifier 2(TE=Telefonnr.,FX=Telefaxnr.)","Qualifier Artikelnummer 2"]
["20","a3#12","an3",null,null,null,"Qualifier Artikelnummer 3"]
["21","a3#13","an3"]
["22","a3#14","an3"]
["23","a3#15","an3",null,null,null,"Qualifier LIN-Artikelnummer 1"]
["24","a3#16","an3",null,null,null,"Qualifier LIN-Artikelnummer 2"]
["25","a3#17","an3"]
["26","a3#18","an3"]
["27","a3#19","an3"]
["28","a3#20","an3"]
["29","a3#21","an3"]
["30","a3#22","an3"]
["31","a3#23","an3"]
["32","a3#24","an3"]
["33","a3#25","an3"]
["34","a3#26","an3"]
["35","a3#27","an3"]
["36","a3#28","an3",null,null,"Warenendempfaenger: Land, codiert (DE=Deutschland)"]
["37","a3#29","an3",null,null,"Lieferant: Land, codiert (DE=Deutschland)"]
["38","a3#30","an3",null,null,"Rechnungsempfaenger: Land, codiert (DE=Deutschland)"]
["39","a3#31","an3",null,null,"Warenempfaenger: Land, codiert (DE=Deutschland)"]
["40","a3#32","an3","Sonderkondition (codiert)  ",null,"Kaeufer: Land, codiert (DE=Deutschland)"]
["41","a4#01","an4","Uhrzeit der Erstellung (HHMM)"]
["42","a4#02","an4"]
["43","a4#03","an4"]
["44","a6#01","an6"]
["45","a6#02","an6"]
["46","a6#03","an6"]
["47","a6#04","an6"]
["48","a7#01","an7"]
["49","a7#02","an7"]
["50","a8#01","an8","Datum der Erstellung (JJMMTT)"]
["51","a9#01","an9",null,null,"Warenempfaenger: PLZ"]
["52","a9#02","an9",null,null,"Kaeufer: PLZ  "]
["53","a11#01","an11",null,null,"Rechnungsempfaenger: PLZ "]
["54","a11#2","an11",null,null,"Lieferant: PLZ  "]
["55","a14#01","an14","Rueckleitungs-adresse ",null,"Warenendempfaenger: PLZ   "]
["56","a14#02","an14","Weiterleitungs-adresse"]
["57","a14#02","an14"]
["58","a14#03","an14"]
["59","a14#04","an14"]
["60","a14#05","an14"]
["61","a14#06","an14"]
["62","a14#07","an14"]
["63","a14#08","an14",null,null,"Telefonnr. Wareneingang"]
["64","a17#01","an17","Referenz für den Empfaenger",null,"Beteiligter: ILN","Liefertermin, gefordert (CCJJMMTT)"]
["65","a17#02","an17",null,null,"ILN Lieferant ","Mindestrestlaufzeit in Tagen   "]
["66","a17#3","an17",null,null,"ILN Kaeufer  "]
["67","a17#04","an17",null,null,"ILN Warenempfaenger"]
["68","a17#05","an17",null,null,"ILN Rechnungsempfaenger"]
["69","a17#06","an17",null,null,"Umsatz-ID des Lieferanten "]
["70","a17#07","an17",null,null,"ID Lieferort (Kaeufer)","Art der Verpackung auf innerer Ebene; PK=Packstueck, 201=Europalette"]
["71","a17#08","an17",null,null,"ID Lieferort (Warenempfaenger)","Art der Verpackung auf aeussere Ebene; PK=Packstueck, 201=Europalette"]
["72","a25#01","an25",null,null,"ILN Endempfaenger  "]
["73","a25#02","an25",null,null,"Interne Kundennummer des Lieferanten"]
["74","a35#01","an35","ILN des Daten-Empfaengers",null,"Lieferort (Kaeufer)","EAN-Artikelnummer"]
["75","a35#02","an35","Dokumenten-/Nachrichtendatum (CCJJMMTT)",null,"Ansprechpartner, Auftragskontakt, Identifikation ","Artikelnummer des Kaeufers"]
["76","a35#03","an35","Liefertermin, gefordert (CCJJMMTT)",null,"Umsatzsteuer-Identifikationsnummer des Kaeufers","Artikelnummer des Lieferanten"]
["77","a35#04","an35","Bestelldatum/-zeit",null,"Nr. der Einkaufsabteilung beim Kaeufer"]
["78","a35#05","an35",null,null,"zusaetzliche Partneridentifikation "]
["79","a35#06","an35","Auftrags-/ Bestellnummer des Kaeufers ",null,"Umsatz-St.-ID des Rechnungsempfaengers","Produkt-/Leistungsbeschreibung 1"]
["80","a35#07","an35","Dokumenten-/ Nachrichtennummer",null,"Lieferant: Name ","Produkt-/Leistungsbeschreibung 2"]
["81","a35#08","an35",null,null,"Lieferant: Strasse und Hausnummer / Postfach"]
["82","a35#09","an35"," ",null,"Lieferant: Ort "]
["83","a35#10","an35","Aktions-/ Werbungsnummer ",null,"Kaeufer: Name "]
["84","a35#11","an35","Lieferdatum, spaetestes (CCJJMMTT)",null,"Kaeufer: Strasse und Hausnummer / Postfach  ","Interne Artikelgruppennummer (nur wenn keine EAN übermittelt wird)"]
["85","a35#12","an35","Lieferdatum, fruehestes (CCJJMMTT) ",null,"Kaeufer: Ort  "]
["86","a35#13","an35"]
["87","a35#14","an35","Rahmenauftragsnr.",null,"Warenempfaenger: Name "]
["88","a35#15","an35","Auftragslieferung Gruppierungsreferenz  ",null,"Warenempfaenger: Strasse","Europaeische Abfallkatalog"]
["89","a35#16","an35","Dokumenten-/ Nachrichtenname ",null,"Warenempfaenger: Ort "]
["90","a70#1","an70",null,"Freier Text 1","Telefonnummer des Auftragskontaktes/ Ansprechpartner",null,"Freier Text 1"]
["91","a70#2","an70",null,"Freier Text 2","Telefaxnummer des Auftragskontaktes/ Ansprechpartners",null,"Freier Text 2"]
["92","a70#03","an70",null,"Freier Text 3",null,"Produktbeschreibung (Farbe)","Freier Text 3"]
["93","a70#4","an70",null,"Freier Text 4","Warenendempfaenger: Name","Produktbeschreibung (Groesse)","Freier Text 4"]
["94","a70#5","an70",null,"Freier Text 5","Warenendempfaenger: Strasse","Chargennummer","Freier Text 5"]
["95","a70#06","an70",null,null,"Warenendempfaenger: Ort ","Rahmenauftragsnummer "]
["96","a70#07","an70",null,null,"Warenendempfaenger: Name 2"]
["97","a70#08","an70",null,null,"Rechnungsempfaenger: Name"]
["98","a70#09","an70",null,null,"Rechnungsempfaenger: Strasse und Hausnummer / Postfach "]
["99","a70#10","an70",null,null,"Ansprechpartner, Auftragskontakt"]
["100","a70#11","an70",null,null,"Rechnungsempfaenger: Ort"]
["101","a70#12","an70",null,null,"Steuernummer des Rechnungsempfaengers"]
["102","a70#13","an70",null,null,"Lieferort (Warenempfaenger)"]
["103","a70#14","an70",null,null,"Kontakt Wareneingang "]
["104","a70#15","an70",null,null,"interne Verkaeufernummer "]
["105","a70#16","an70"]
["106","n1#1","n1"]
["107","n1#2","n1"]
["108","n1#3","n1"]
["109","n2#1","n2"]
["110","n2#2","n2"]
["111","n3#1","n3"]
["112","n4#1","n4","Verlaengerung des Nettofaelligkeitsdatums in Tagen "]
["113","n6#1","n6",null,null,null,"Positionsnummer"]
["114","n6#2","n6"]
["115","n6#3","n6"]
["116","n6#4","n6"]
["117","n8#1","n8",null,null,null,"Anzahl der Packstuecke, innere Verpackung"]
["118","n8#2","n8",null,null,null,"Anzahl der Packstuecke, aeussere Verpackung "]
["119","n9#1","n9"]
["120","n15#1","n15"]
["121","n15#2","n15",null,null,null,"Preisbasis-Menge  "]
["122","n15#3","n15"]
["123","n15#4","n15"]
["124","n15#5","n15"]
["125","n15#6","n15"]
["126","n15#7","n15"]
["127","n15#8","n15"]
["128","n18#1","n18","Anzahl der Positionen "]
["129","n18#2","n18","Gesamtwert der Menge auf Positionsebene einer Nachricht"]
["130","n18#3","n18"]
["131","n18#4","n18"]
["132","n18#5","n18"]
["133","n18#6","n18"]
["134","n18#7","n18"]
["135","n18#8","n18"]
["136","np2#1","n12p2",null,null,null,"bestellte Menge",null,"Prozentsatz des Zu-/Abschlags"]
["137","np2#2","n12p2",null,null,null,"Preis je Einheit",null,"Zu-/Abschlagsbetrag"]
["138","np2#3","n12p2"]
["139","np2#4","n12p2"]
["140","np2#5","n12p2",null,null,null,"Nettopreis"]
["141","np2#6","n12p2",null,null,null,"Bruttopreis"]
["142","np3#1","n12p3"]
["143","np3#2","n12p3",null,null,null,"Positionsbetrag "]
["144","np3#3","n12p3"]
["145","np3#4","n12p3"]
["146","np3#5","n12p3"]
["147","np3#6","n12p3"]
["148","np5#1","n12p5"]
["149","np5#2","n12p5"]
["150","np5#3","n12p5"]
["151","np5#4","n12p5"]
["152","np5#5","n12p5"]
["153","np5#6","n12p5"]
["154","MsgCtl","an14","Datenaustausch-referenz"]
["155","AppRef","an14","Nachrichten-Referenznummer"]
["156","UpdTim","an6"]
["157","UpdDat","an8"]
["158","WrtTim","an6","Zeit HHMMSS","<---","<---","<---","<---","<---"]
["159","WrtDat","an8","Datum YYYYMMDD","<---","<---","<---","<---","<---"]
["160","UserNm","an35"]
["161","PgmNm","an35"]
["162","XeorF","an1","V = vollständig empfangen"]
["163","ScdTim","an6","m@gic EDDY Counter","<---","<---","<---","<---","<---"]
["164","ScdDat","an8","m@gic EDDY Lizenznummer","<---","<---","<---","<---","<---"]

{"sheet":"Kopf-Rahmen","index":1,"n_rows":173,"n_cols":6,"rows_kept":173,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["B&N RCV-ORDERS",null,null,"Erstellt am 07.06.2005"]
["Kopf: Rahmeninformationen"]
[]
["#","Feld","Format","Beschreibung","cd2000-Bemerkung","gegenüber Printus"]
["1","SndRec","an3","RCV"]
["2","PrtNum","an35","ILN des Daten-Absenders"]
["3","MsgTyp","an6","ORDERS"]
["4","MaiKey","an35","Eindeutige Nummer von m@gic EDDY vergeben"]
["5","HrcLvl","an9","100000000"]
["6","LinNum","n6","0"]
["7","a1#01","an1","Testkennzeichen: 1=Test, leer=produktiv","1 = Test wird nicht übernommen"]
["8","a1#02","an1","Syntax-Versionsnummer","?"]
[9,"a3#01","an3","                                                               "]
["10","a3#02","an3","Dokumententyp, codiert 220=Bestellung;50E=Transit-Auftrag","edi_belegart"]
[11,"a3#03","an3","                                                               "]
[12,"a3#04","an3","Dokumenten-/Nachrichtefunktion, codiert 9=Original; 7=Duplikat "]
[13,"a3#05 ","an3   ","                                                               "]
["14","a3#06","an3","Waehrung, codiert z.B. EUR=Euro        ","Umwandlung in waehrungscode über tab_waehrungen","neu"]
[15,"a3#07 ","an3   ","                                                               "]
[16,"a3#08 ","an3   ","                                                               "]
[17,"a3#09 ","an3   ","                                                               "]
[18,"a3#10 ","an3   ","                                                               "]
[19,"a3#11 ","an3   ","                                                               "]
[20,"a3#12 ","an3   ","                                                               "]
[21,"a3#13 ","an3   ","                                                               "]
[22,"a3#14 ","an3   ","                                                               "]
[23,"a3#15 ","an3   ","                                                               "]
[24,"a3#16 ","an3   ","                                                               "]
[25,"a3#17 ","an3   ","                                                               "]
[26,"a3#18 ","an3   ","                                                               "]
[27,"a3#19 ","an3   ","                                                               "]
[28,"a3#20 ","an3   ","                                                               "]
[29,"a3#21 ","an3   ","                                                               "]
[30,"a3#22 ","an3   ","                                                               "]
[31,"a3#23 ","an3   ","                                                               "]
[32,"a3#24 ","an3   ","                                                               "]
[33,"a3#25 ","an3   ","                                                               "]
[34,"a3#26 ","an3   ","                                                               "]
[35,"a3#27 ","an3   ","                                                               "]
[36,"a3#28 ","an3   ","                                                               "]
[37,"a3#29 ","an3   ","                                                               "]
[38,"a3#30 ","an3   ","                                                               "]
[39,"a3#31 ","an3   ","                                                               "]
["40","a3#32","an3","Sonderkondition (codiert)  ","?","neu"]
["41","a4#01","an4","Uhrzeit der Erstellung (HHMM)","dat_erstellung"]
[42,"a4#02  ","an4   ","                                                               "]
[43,"a4#03  ","an4   ","                                                               "]
[44,"a6#01  ","an6   ","                                                               "]
[45,"a6#02  ","an6   ","                                                               "]
[46,"a6#03  ","an6   ","                                                               "]
[47,"a6#04  ","an6   ","                                                               "]
[48,"a7#01  ","an7   ","                                                               "]
[49,"a7#02  ","an7   ","                                                               "]
[50,"a8#01  ","an8   ","Datum der Erstellung (JJMMTT)                                  ",null,"1 2 3"]
[51,"a9#01  ","an9   ","                                                               "]
[52,"a9#02  ","an9   ","                                                               "]
[53,"a11#01 ","an11  ","                                                               "]
[54,"a11#02 ","an11  ","                                                               "]
["55","a12#01","an12","Rueckleitungsadresse","?","neu"]
["56","a14#01","an14","Weiterleitungsadresse","?","neu"]
[57,"a14#02 ","an14  ","                                                               "]
[58,"a14#03 ","an14  ","                                                               "]
[59,"a14#04 ","an14  ","                                                               "]
[60,"a14#05 ","an14  ","                                                               "]
[61,"a14#06 ","an14  ","                                                               "]
[62,"a14#07 ","an14  ","                                                               "]
[63,"a14#08 ","an14  ","                                                               "]
["64","a17#01","an17","Referenz für den Empfaenger   ","?","neu"]
[65,"a17#02 ","an17  ","                                                               "]
[66,"a17#03 ","an17  ","                                                               "]
[67,"a17#04 ","an17  ","                                                               "]
[68,"a17#05 ","an17  ","                                                               "]
[69,"a17#06 ","an17  ","                                                               "]
[70,"a17#07 ","an17  ","                                                               "]
[71,"a17#08 ","an17  ","                                                               "]
[72,"a25#01 ","an25  ","                                                               "]
[73,"a25#02 ","an25  ","                                                               "]
["74","a35#01","an35","ILN des Daten-Empfaengers","mit eigener iln_nummer vergleichen"]
["75","a35#02","an35","Dokumenten-/Nachrichtendatum (CCJJMMTT)","?"]
["76","a35#03","an35","Liefertermin, gefordert (CCJJMMTT)","liefertermin(6-stellig: TTMMJJ)"]
["77","a35#04","an35","Bestelldatum/-zeit, Datum der Markteinrichtung (CCJJMMTT) ","?"]
[78,"a35#05","an35  ","                                                               "]
["79","a35#06","an35","Auftrags-/Bestellnummer des Kaeufers ","ihre_auftrags_nr","neu"]
["80","a35#07","an35","Dokumenten-/Nachrichtennummer","?"]
[81,"a35#08","an35  ","                                                               "]
[82,"a35#09","an35  ","                                                               "]
["83","a35#10","an35","Aktions-/Werbungsnummer ","?","neu"]
["84","an35#11","an35","Lieferdatum, spaetestes (CCJJMMTT)","?","neu"]
["85","an35#12","an35","Lieferdatum, fruehestes (CCJJMMTT) ","?","neu"]
["86","an35#13","an35"]
["87","an35#14","an35","Rahmenauftragsnummer  ","r_ihre_auftrags_nr","neu"]
["88","an35#15","an35","Auftragslieferung Gruppierungsreferenz  ","?","neu"]
["89","an35#16","an35","Dokumenten-/Nachrichtenname   ","?","neu"]
[90,"a70#01","an70","                                                               "]
[91,"a70#02","an70","                                                               "]
[92,"a70#03","an70","                                                               "]
[93,"a70#04","an70","                                                               "]
[94,"a70#05","an70","                                                               "]
[95,"a70#06","an70  ","                                                               "]
[96,"a70#07","an70  ","                                                               "]
[97,"a70#08","an70  ","                                                               "]
[98,"a70#09","an70  ","                                                               "]
[99,"a70#10","an70  ","                                                               "]
[100,"a70#11","an70  ","                                                               "]
[101,"a70#12","an70  ","                                                               "]
[102,"a70#13","an70  ","                                                               "]
[103,"a70#14","an70  ","                                                               "]
[104,"a70#15","an70  ","                                                               "]
[105,"a70#16","an70  ","                                                               "]
[106,"n1#01  ","n1    ","                                                               "]
[107,"n1#02  ","n1    ","                                                               "]
[108,"n1#03  ","n1    ","                                                               "]
[109,"n2#01  ","n2    ","                                                               "]
[110,"n2#02  ","n2    ","                                                               "]
[111,"n3#01  ","n3    ","                                                               "]
["112","n4#01","n4","Verlaengerung des Nettofaelligkeitsdatums in Tagen ","?","neu"]
[113,"n6#01  ","n6    ","                                                               "]
[114,"n6#02  ","n6    ","                                                               "]
[115,"n6#03  ","n6    ","                                                               "]
[116,"n6#04  ","n6    ","                                                               "]
[117,"n8#01  ","n8    ","                                                               "]
[118,"n8#02  ","n8    ","                                                               "]
[119,"n9#01  ","n9    ","                                                               "]
[120,"n15#01 ","n15   ","                                                               "]
[121,"n15#02 ","n15   ","                                                               "]
[122,"n15#03 ","n15   ","                                                               "]
[123,"n15#04 ","n15   ","                                                               "]
[124,"n15#05 ","n15   ","                                                               "]
[125,"n15#06 ","n15   ","                                                               "]
[126,"n15#07 ","n15   ","                                                               "]
[127,"n15#08 ","n15   ","                                                               "]
["128","n18#01","n18","Anzahl der Positionen ","?","neu"]
["129","n18#02","n18","Gesamtwert der Menge auf Positionsebene einer Nachricht","?","neu"]
[130,"n18#03 ","n18   ","                                                               "]
[131,"n18#04 ","n18   ","                                                               "]
[132,"n18#05 ","n18   ","                                                               "]
[133,"n18#06 ","n18   ","                                                               "]
[134,"n18#07 ","n18   ","                                                               "]
[135,"n18#08 ","n18   ","                                                               "]
[136,"np2#01 ","n12p2 ","                                                               "]
[137,"np2#02 ","n12p2 ","                                                               "]
[138,"np2#03 ","n12p2 ","                                                               "]
[139,"np2#04 ","n12p2 ","                                                               "]
[140,"np2#05 ","n12p2 ","                                                               "]
[141,"np2#06 ","n12p2 ","                                                               "]
[142,"np3#01 ","n12p3 ","                                                               "]
[143,"np3#02 ","n12p3 ","                                                               "]
[144,"np3#03 ","n12p3 ","                                                               "]
[145,"np3#04 ","n12p3 ","                                                               "]
[146,"np3#05 ","n12p3 ","                                                               "]
[147,"np3#06 ","n12p3 ","                                                               "]
[148,"np5#01 ","n12p5 ","                                                               "]
[149,"np5#02 ","n12p5 ","                                                               "]
[150,"np5#03 ","n12p5 ","                                                               "]
[151,"np5#04 ","n12p5 ","                                                               "]
[152,"np5#05 ","n12p5 ","                                                               "]
[153,"np5#06 ","n12p5 ","                                                               "]
[154,"MsgCtl","an14  ","Datenaustauschreferenz                                                 ",null,"1 2"]
[155,"AppRef","an14  ","Nachrichten-Referenznummer                                             ",null,"1 2"]
[156,"UpdTim","an6   "]
[157,"UpdDat","an8   "]
[158,"WrtTim","an6   ","Zeit HHMMSS                                            "]
[159,"WrtDat","an8   ","Datum YYYYMMDD                                         "]
[160,"UserNm","an35  ","                                                       "]
[161,"PgmNm ","an35  ","                                                       "]
[162,"XeorF ","an1   ","                                                       "]
[163,"ScdTim","an6   ","m@gic EDDY Counter                                     "]
[164,"ScdDat","an8   ","m@gic EDDY Lizenznummer                                "]
[]
[]
[{"$nulls":4},"1       Leopold Kostal für Unimet        "]
[{"$nulls":4},"2       Johnson Controls für Carl Müller "]
[{"$nulls":4},"3       Delphi"]

{"sheet":"Kopf-Freier-Text","index":2,"n_rows":173,"n_cols":6,"rows_kept":173,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["B&N RCV-ORDERS",null,null,"Erstellt am 07.06.2005"]
["Kopf: Freier Text"]
[]
["#","Feld","Format","Beschreibung","cd2000-Bemerkung","gegenüber Printus"]
["1","SndRec","an3","RCV"]
["2","PrtNum","an35","ILN des Daten-Absenders"]
["3","MsgTyp","an6","ORDERS"]
["4","MaiKey","an35","Eindeutige Nummer von m@gic EDDY vergeben"]
["5","HrcLvl","an9","110000000"]
["6","LinNum","n6","laufende Nummer über alle Sätze"]
["7","a1#01","an1"]
["8","a1#02","an1"]
["9","a3#01","an3","Textzuordnung, codiert","?"]
["10","a3#02","an3","Freier Text, codiert","?"]
["11","a3#03","an3","Codeliste, Qualifier","?"]
["12","a3#04","an3","Sprache, codiert","?","neu"]
[13,"a3#05 ","an3   "]
["14","a3#06","an3"]
[15,"a3#07 ","an3   "]
[16,"a3#08 ","an3   "]
[17,"a3#09 ","an3   "]
[18,"a3#10 ","an3   "]
[19,"a3#11 ","an3   "]
[20,"a3#12 ","an3   "]
[21,"a3#13 ","an3   "]
[22,"a3#14 ","an3   "]
[23,"a3#15 ","an3   "]
[24,"a3#16 ","an3   "]
[25,"a3#17 ","an3   "]
[26,"a3#18 ","an3   "]
[27,"a3#19 ","an3   "]
[28,"a3#20 ","an3   "]
[29,"a3#21 ","an3   "]
[30,"a3#22 ","an3   "]
[31,"a3#23 ","an3   "]
[32,"a3#24 ","an3   "]
[33,"a3#25 ","an3   "]
[34,"a3#26 ","an3   "]
[35,"a3#27 ","an3   "]
[36,"a3#28 ","an3   "]
[37,"a3#29 ","an3   "]
[38,"a3#30 ","an3   "]
[39,"a3#31 ","an3   "]
["40","a3#32","an3"]
["41","a4#01","an4"]
[42,"a4#02  ","an4   "]
[43,"a4#03  ","an4   "]
[44,"a6#01  ","an6   "]
[45,"a6#02  ","an6   "]
[46,"a6#03  ","an6   "]
[47,"a6#04  ","an6   "]
[48,"a7#01  ","an7   "]
[49,"a7#02  ","an7   "]
[50,"a8#01  ","an8   "]
[51,"a9#01  ","an9   "]
[52,"a9#02  ","an9   "]
[53,"a11#01 ","an11  "]
[54,"a11#02 ","an11  "]
["55","a12#01","an12"]
["56","a14#01","an14"]
[57,"a14#02 ","an14  "]
[58,"a14#03 ","an14  "]
[59,"a14#04 ","an14  "]
[60,"a14#05 ","an14  "]
[61,"a14#06 ","an14  "]
[62,"a14#07 ","an14  "]
[63,"a14#08 ","an14  "]
["64","a17#01","an17"]
[65,"a17#02 ","an17  "]
[66,"a17#03 ","an17  "]
[67,"a17#04 ","an17  "]
[68,"a17#05 ","an17  "]
[69,"a17#06 ","an17  "]
[70,"a17#07 ","an17  "]
[71,"a17#08 ","an17  "]
[72,"a25#01 ","an25  "]
[73,"a25#02 ","an25  "]
["74","a35#01","an35"]
["75","a35#02","an35"]
["76","a35#03","an35"]
["77","a35#04","an35"]
[78,"a35#05","an35  "]
["79","a35#06","an35"]
["80","a35#07","an35"]
[81,"a35#08","an35  "]
[82,"a35#09","an35  "]
["83","a35#10","an35"]
["84","an35#11","an35"]
["85","an35#12","an35"]
["86","an35#13","an35"]
["87","an35#14","an35"]
["88","an35#15","an35"]
["89","an35#16","an35"]
["90","a70#01","an70","Freier Text 1","wird in 40-stellige Felder abgestellt(evtl. 2 Sätze)"]
["91","a70#02","an70","Freier Text 2","wird in 40-stellige Felder abgestellt(evtl. 2 Sätze)"]
["92","a70#03","an70","Freier Text 3","wird in 40-stellige Felder abgestellt(evtl. 2 Sätze)"]
["93","a70#04","an70","Freier Text 4","wird in 40-stellige Felder abgestellt(evtl. 2 Sätze)"]
["94","a70#05","an70","Freier Text 5","wird in 40-stellige Felder abgestellt(evtl. 2 Sätze)"]
[95,"a70#06","an70  "]
[96,"a70#07","an70  "]
[97,"a70#08","an70  "]
[98,"a70#09","an70  "]
[99,"a70#10","an70  "]
[100,"a70#11","an70  "]
[101,"a70#12","an70  "]
[102,"a70#13","an70  "]
[103,"a70#14","an70  "]
[104,"a70#15","an70  "]
[105,"a70#16","an70  "]
[106,"n1#01  ","n1    "]
[107,"n1#02  ","n1    "]
[108,"n1#03  ","n1    "]
[109,"n2#01  ","n2    "]
[110,"n2#02  ","n2    "]
[111,"n3#01  ","n3    "]
["112","n4#01","n4"]
[113,"n6#01  ","n6    "]
[114,"n6#02  ","n6    "]
[115,"n6#03  ","n6    "]
[116,"n6#04  ","n6    "]
[117,"n8#01  ","n8    "]
[118,"n8#02  ","n8    "]
[119,"n9#01  ","n9    "]
[120,"n15#01 ","n15   "]
[121,"n15#02 ","n15   "]
[122,"n15#03 ","n15   "]
[123,"n15#04 ","n15   "]
[124,"n15#05 ","n15   "]
[125,"n15#06 ","n15   "]
[126,"n15#07 ","n15   "]
[127,"n15#08 ","n15   "]
["128","n18#01","n18"]
["129","n18#02","n18"]
[130,"n18#03 ","n18   "]
[131,"n18#04 ","n18   "]
[132,"n18#05 ","n18   "]
[133,"n18#06 ","n18   "]
[134,"n18#07 ","n18   "]
[135,"n18#08 ","n18   "]
[136,"np2#01 ","n12p2 "]
[137,"np2#02 ","n12p2 "]
[138,"np2#03 ","n12p2 "]
[139,"np2#04 ","n12p2 "]
[140,"np2#05 ","n12p2 "]
[141,"np2#06 ","n12p2 "]
[142,"np3#01 ","n12p3 "]
[143,"np3#02 ","n12p3 "]
[144,"np3#03 ","n12p3 "]
[145,"np3#04 ","n12p3 "]
[146,"np3#05 ","n12p3 "]
[147,"np3#06 ","n12p3 "]
[148,"np5#01 ","n12p5 "]
[149,"np5#02 ","n12p5 "]
[150,"np5#03 ","n12p5 "]
[151,"np5#04 ","n12p5 "]
[152,"np5#05 ","n12p5 "]
[153,"np5#06 ","n12p5 "]
[154,"MsgCtl","an14  "]
[155,"AppRef","an14  "]
[156,"UpdTim","an6   "]
[157,"UpdDat","an8   "]
[158,"WrtTim","an6   ","Zeit HHMMSS                                            "]
[159,"WrtDat","an8   ","Datum YYYYMMDD                                         "]
[160,"UserNm","an35  ","                                                       "]
[161,"PgmNm ","an35  ","                                                       "]
[162,"XeorF ","an1   ","                                                       "]
[163,"ScdTim","an6   ","m@gic EDDY Counter                                     "]
[164,"ScdDat","an8   ","m@gic EDDY Lizenznummer                                "]
[]
[]
[{"$nulls":4},"1       Leopold Kostal für Unimet        "]
[{"$nulls":4},"2       Johnson Controls für Carl Müller "]
[{"$nulls":4},"3       Delphi"]

{"sheet":"Kopf-Beteiligte","index":3,"n_rows":173,"n_cols":7,"rows_kept":173,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["B&N RCV-ORDERS",null,null,"Erstellt am 07.06.2005"]
["Kopf: Beteiligte"]
[]
["#","Feld","Format","Beschreibung","cd2000-Bemerkung","gegenüber Printus"]
["1","SndRec","an3","RCV",null,null,"RCV                                           "]
["2","PrtNum","an35","ILN des Daten-Absenders",null,null,"ILN des Daten-Absenders                       "]
["3","MsgTyp","an6","ORDERS",null,null,"ORDERS                                        "]
["4","MaiKey","an35","Eindeutige Nummer von m@gic EDDY vergeben",null,null,"Eindeutige Nummer von m@gic EDDY vergeben     "]
["5","HrcLvl","an9","120000000",null,null,120000000]
["6","LinNum","n6","laufende Nummer über alle Sätze",null,null,"laufende Nummer über alle Sätze               "]
["7","a1#01","an1",null,null,null,"                                              "]
["8","a1#02","an1",null,null,null,"                                              "]
["9","a3#01","an3","Beteiligter = leer, sonst Einzelsätze",null,null,"Beteiligter, Qual.SU=Lieferant,IV=Rg-Empf,BY=K"]
["10","a3#02","an3","Qualifier 1(TE=Telefonnr.,FX=Telefaxnr.)","?","neu","Abteilung oder Bearbeiter , Qual. IC=Informati"]
["11","a3#03","an3","Qualifier 2(TE=Telefonnr.,FX=Telefaxnr.)","?","neu","                                              "]
["12","a3#04","an3",null,null,null,"                                              "]
[13,"a3#05 ","an3   ",null,null,null,"                                              "]
["14","a3#06","an3",null,null,null,"                                              "]
[15,"a3#07 ","an3   ",null,null,null,"                                              "]
[16,"a3#08 ","an3   ",null,null,null,"                                              "]
[17,"a3#09 ","an3   ",null,null,null,"                                              "]
[18,"a3#10 ","an3   ",null,null,null,"Qualifier 1(TE=Telefonnr.,FX=Telefaxnr.)      "]
[19,"a3#11 ","an3   ",null,null,null,"Qualifier 2(TE=Telefonnr.,FX=Telefaxnr.)      "]
[20,"a3#12 ","an3   ",null,null,null,"                                              "]
[21,"a3#13 ","an3   ",null,null,null,"                                              "]
[22,"a3#14 ","an3   ",null,null,null,"                                              "]
[23,"a3#15 ","an3   ",null,null,null,"                                              "]
[24,"a3#16 ","an3   ",null,null,null,"                                              "]
[25,"a3#17 ","an3   ",null,null,null,"                                              "]
[26,"a3#18 ","an3   ",null,null,null,"                                              "]
[27,"a3#19 ","an3   ",null,null,null,"                                              "]
[28,"a3#20 ","an3   ",null,null,null,"                                              "]
[29,"a3#21 ","an3   ",null,null,null,"                                              "]
[30,"a3#22 ","an3   ",null,null,null,"                                              "]
[31,"a3#23 ","an3   ",null,null,null,"                                              "]
[32,"a3#24 ","an3   ",null,null,null,"                                              "]
[33,"a3#25 ","an3   ",null,null,null,"                                              "]
[34,"a3#26 ","an3   ",null,null,null,"                                              "]
[35,"a3#27 ","an3   ",null,null,null,"                                              "]
[36,"a3#28 ","an3   ","Warenendempfaenger: Land, codiert (DE=Deutschland)","?","neu","                                              "]
[37,"a3#29 ","an3   ","Lieferant: Land, codiert (DE=Deutschland)","?","neu","                                              "]
[38,"a3#30 ","an3   ","Rechnungsempfaenger: Land, codiert (DE=Deutschland)","land, edi_rechnungsanschrift","neu","                                              "]
[39,"a3#31 ","an3   ","Warenempfaenger: Land, codiert (DE=Deutschland)","land, edi_lieferanschrift",null,"Beteiligter: Land, cod. DE=Deutschland        "]
["40","a3#32","an3","Kaeufer: Land, codiert (DE=Deutschland)","land, auf_ab_anschrift","neu","                                              "]
["41","a4#01","an4",null,null,null,"                                              "]
[42,"a4#02  ","an4   ",null,null,null,"                                              "]
[43,"a4#03  ","an4   ",null,null,null,"                                              "]
[44,"a6#01  ","an6   ",null,null,null,"                                              "]
[45,"a6#02  ","an6   ",null,null,null,"                                              "]
[46,"a6#03  ","an6   ",null,null,null,"                                              "]
[47,"a6#04  ","an6   ",null,null,null,"                                              "]
[48,"a7#01  ","an7   ",null,null,null,"                                              "]
[49,"a7#02  ","an7   ",null,null,null,"                                              "]
[50,"a8#01  ","an8   ",null,null,null,"                                              "]
[51,"a9#01  ","an9   ","Warenempfaenger: PLZ","postleitzahl_char, edi_lieferanschrift",null,"Beteiligter: PLZ                              "]
[52,"a9#02  ","an9   ","Kaeufer: PLZ  ","postleitzahl_char, auf_ab_anschriftt","neu","Beteiligter: Region                           "]
[53,"a11#01 ","an11  ","Rechnungsempfaenger: PLZ ","postleitzahl_char, edi_rechnungsanschrift","neu","                                              "]
[54,"a11#02 ","an11  ","Lieferant: PLZ  ","?","neu","                                              "]
["55","a12#01","an12","Warenendempfaenger: PLZ   ","?","neu","                                              "]
["56","a14#01","an14",null,null,null,"                                              "]
[57,"a14#02 ","an14  ",null,null,null,"                                              "]
[58,"a14#03 ","an14  ",null,null,null,"                                              "]
[59,"a14#04 ","an14  ",null,null,null,"                                              "]
[60,"a14#05 ","an14  ",null,null,null,"                                              "]
[61,"a14#06 ","an14  ",null,null,null,"                                              "]
[62,"a14#07 ","an14  ",null,null,null,"                                              "]
[63,"a14#08 ","an14  ","Telefonnr. Wareneingang","?","neu","                                              "]
["64","a17#01","an17","ILN Lieferant ","?",null,"Beteiligter: ILN                              "]
[65,"a17#02 ","an17  ","ILN Kaeufer  ","iln_nummer, auf_ab_anschrift, Ermittlung des Kunden","neu","                                              "]
[66,"a17#03 ","an17  ","ILN Warenempfaenger","iln_nummer, edi_lieferanschrift","neu","                                              "]
[67,"a17#04 ","an17  ","ILN Rechnungsempfaenger","iln_nummer, edi_rechnungsanschrift","neu","                                              "]
[68,"a17#05 ","an17  ","ILN Warenendempfaenger ","?","neu","Abteilung oder Bearbeiter des Beteiligten, Ide"]
[69,"a17#06 ","an17  ","ID Lieferort (Kaeufer)","?","neu","                                              "]
[70,"a17#07 ","an17  ","ID Lieferort (Warenempfaenger)","?","neu","                                              "]
[71,"a17#08 ","an17  ","ILN Endempfaenger  ","?","neu","                                              "]
[72,"a25#01 ","an25  ","Umsatz-ID des Lieferanten ","?","geändert","                                              "]
[73,"a25#02 ","an25  ","Interne Kundennummer des Lieferanten","? wird über a17_02 ermittelt, unsere_nr_beim_kunden","neu","                                              "]
["74","a35#01","an35","Lieferort (Kaeufer)","? (lb_bestimmungsort)","neu","Abteilung oder Bearbeiter des Beteiligten     "]
["75","a35#02","an35","Ansprechpartner, Auftragskontakt, Identifikation ","?","neu","                                              "]
["76","a35#03","an35","Umsatzsteuer-Identifikationsnummer des Kaeufers","?, wird nicht gebraucht(stammdaten)","neu","                                              "]
["77","a35#04","an35","Nr. der Einkaufsabteilung beim Kaeufer","?","neu","Beteiligter: Name und Anschrift               "]
[78,"a35#05","an35  ","zusaetzliche Partneridentifikation ","?","neu","Beteiligter: Name                             "]
["79","a35#06","an35","Umsatz-St.-ID des Rechnungsempfaengers","?, wird nicht gebraucht(stammdaten)","geändert","Beteiligter: Name 2                           "]
["80","a35#07","an35","Lieferant: Name ",null,"neu","                                              "]
[81,"a35#08","an35  ","Lieferant: Strasse und Hausnummer / Postfach",null,"neu","                                              "]
[82,"a35#09","an35  ","Lieferant: Ort ",null,"neu","                                              "]
["83","a35#10","an35","Kaeufer: Name ","name_zeile1, auf_ab_anschrift","neu","Beteiligter: Strasse                          "]
["84","an35#11","an35","Kaeufer: Strasse und Hausnummer / Postfach  ","strasse, auf_ab_anschrift","neu","Beteiligter: Ort                              "]
["85","an35#12","an35","Kaeufer: Ort  ","ort, auf_ab_anschrift","neu","                                              "]
["86","an35#13","an35",null,null,"geändert","                                              "]
["87","an35#14","an35","Warenempfaenger: Name ","name_zeile1, edi_lieferanschrift","geändert","                                              "]
["88","an35#15","an35","Warenempfaenger: Strasse","strasse, edi_lieferanschrift","geändert","                                              "]
["89","an35#16","an35","Warenempfaenger: Ort ","ort, edi_lieferanschrift","geändert","                                              "]
["90","a70#01","an70","Telefonnummer des Auftragskontaktes/ Ansprechpartner","?",null,"Telefonnummer                                 "]
["91","a70#02","an70","Telefaxnummer des Auftragskontaktes/ Ansprechpartners","?",null,"Telefaxnummer                                 "]
["92","a70#03","an70",null,null,"geändert","                                              "]
["93","a70#04","an70","Warenendempfaenger: Name","?","geändert","                                              "]
["94","a70#05","an70","Warenendempfaenger: Strasse","?","geändert","                                              "]
[95,"a70#06","an70  ","Warenendempfaenger: Ort ","?","neu","                                              "]
[96,"a70#07","an70  ","Warenendempfaenger: Name 2","?","neu","                                              "]
[97,"a70#08","an70  ","Rechnungsempfaenger: Name","name_zeile1, edi_rechnungsanschrift","neu","                                              "]
[98,"a70#09","an70  ","Rechnungsempfaenger: Strasse und Hausnummer / Postfach ","strasse, edi_rechnungsanschrift","neu","                                              "]
[99,"a70#10","an70  ","Ansprechpartner, Auftragskontakt","?, auftrag_ert_durch","neu","                                              "]
[100,"a70#11","an70  ","Rechnungsempfaenger: Ort","ort, edi_rechnungsanschrift","neu","                                              "]
[101,"a70#12","an70  ","Steuernummer des Rechnungsempfaengers","?, wird nicht gebraucht(stammdaten)","neu","                                              "]
[102,"a70#13","an70  ","Lieferort (Warenempfaenger)","lb_bestimmungsort, edi_lieferanschrift(25-stellig)","neu","                                              "]
[103,"a70#14","an70  ","Kontakt Wareneingang ","?","neu","                                              "]
[104,"a70#15","an70  ","interne Verkaeufernummer ","?","neu","                                              "]
[105,"a70#16","an70  ",null,null,"geändert","                                              "]
[106,"n1#01  ","n1    ",null,null,null,"                                              "]
[107,"n1#02  ","n1    ",null,null,null,"                                              "]
[108,"n1#03  ","n1    ",null,null,null,"                                              "]
[109,"n2#01  ","n2    ",null,null,null,"                                              "]
[110,"n2#02  ","n2    ",null,null,null,"                                              "]
[111,"n3#01  ","n3    ",null,null,null,"                                              "]
["112","n4#01","n4",null,null,null,"                                              "]
[113,"n6#01  ","n6    ",null,null,null,"                                              "]
[114,"n6#02  ","n6    ",null,null,null,"                                              "]
[115,"n6#03  ","n6    ",null,null,null,"                                              "]
[116,"n6#04  ","n6    ",null,null,null,"                                              "]
[117,"n8#01  ","n8    ",null,null,null,"                                              "]
[118,"n8#02  ","n8    ",null,null,null,"                                              "]
[119,"n9#01  ","n9    ",null,null,null,"                                              "]
[120,"n15#01 ","n15   ",null,null,null,"                                              "]
[121,"n15#02 ","n15   ",null,null,null,"                                              "]
[122,"n15#03 ","n15   ",null,null,null,"                                              "]
[123,"n15#04 ","n15   ",null,null,null,"                                              "]
[124,"n15#05 ","n15   ",null,null,null,"                                              "]
[125,"n15#06 ","n15   ",null,null,null,"                                              "]
[126,"n15#07 ","n15   ",null,null,null,"                                              "]
[127,"n15#08 ","n15   ",null,null,null,"                                              "]
["128","n18#01","n18",null,null,null,"                                              "]
["129","n18#02","n18",null,null,null,"                                              "]
[130,"n18#03 ","n18   ",null,null,null,"                                              "]
[131,"n18#04 ","n18   ",null,null,null,"                                              "]
[132,"n18#05 ","n18   ",null,null,null,"                                              "]
[133,"n18#06 ","n18   ",null,null,null,"                                              "]
[134,"n18#07 ","n18   ",null,null,null,"                                              "]
[135,"n18#08 ","n18   ",null,null,null,"                                              "]
[136,"np2#01 ","n12p2 ",null,null,null,"                                              "]
[137,"np2#02 ","n12p2 ",null,null,null,"                                              "]
[138,"np2#03 ","n12p2 ",null,null,null,"                                              "]
[139,"np2#04 ","n12p2 ",null,null,null,"                                              "]
[140,"np2#05 ","n12p2 ",null,null,null,"                                              "]
[141,"np2#06 ","n12p2 ",null,null,null,"                                              "]
[142,"np3#01 ","n12p3 ",null,null,null,"                                              "]
[143,"np3#02 ","n12p3 ",null,null,null,"                                              "]
[144,"np3#03 ","n12p3 ",null,null,null,"                                              "]
[145,"np3#04 ","n12p3 ",null,null,null,"                                              "]
[146,"np3#05 ","n12p3 ",null,null,null,"                                              "]
[147,"np3#06 ","n12p3 ",null,null,null,"                                              "]
[148,"np5#01 ","n12p5 ",null,null,null,"                                              "]
[149,"np5#02 ","n12p5 ",null,null,null,"                                              "]
[150,"np5#03 ","n12p5 ",null,null,null,"                                              "]
[151,"np5#04 ","n12p5 ",null,null,null,"                                              "]
[152,"np5#05 ","n12p5 ",null,null,null,"                                              "]
[153,"np5#06 ","n12p5 ",null,null,null,"                                              "]
[154,"MsgCtl","an14  ",null,null,null,"                                              "]
[155,"AppRef","an14  ",null,null,null,"                                              "]
[156,"UpdTim","an6   ",null,null,null,"                                              "]
[157,"UpdDat","an8   ",null,null,null,"                                              "]
[158,"WrtTim","an6   ","Zeit HHMMSS                                            ",null,null,"Zeit HHMMSS                                   "]
[159,"WrtDat","an8   ","Datum YYYYMMDD                                         ",null,null,"Datum YYYYMMDD                                "]
[160,"UserNm","an35  ","                                                       ",null,null,"                                              "]
[161,"PgmNm ","an35  ","                                                       ",null,null,"                                              "]
[162,"XeorF ","an1   ","                                                       ",null,null,"                                              "]
[163,"ScdTim","an6   ","m@gic EDDY Counter                                     ",null,null,"m@gic EDDY Counter                            "]
[164,"ScdDat","an8   ","m@gic EDDY Lizenznummer                                ",null,null,"m@gic EDDY Lizenznummer                       "]
[]
[]
[{"$nulls":4},"1       Leopold Kostal für Unimet        "]
[{"$nulls":4},"2       Johnson Controls für Carl Müller "]
[{"$nulls":4},"3       Delphi"]

{"sheet":"Kopf-Beteiligte einzeln","index":4,"n_rows":168,"n_cols":6,"rows_kept":168,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["B&N RCV-ORDERS",null,null,"Erstellt am 07.06.2005"]
["Kopf: Beteiligte"]
[]
["#","Feld","Format","Beschreibung","cd2000-Bemerkung","gegenüber Printus"]
["1","SndRec","an3","RCV                                           "]
["2","PrtNum","an35","ILN des Daten-Absenders                       "]
["3","MsgTyp","an6","ORDERS                                        "]
["4","MaiKey","an35","Eindeutige Nummer von m@gic EDDY vergeben     "]
["5","HrcLvl","an9","120000000                                     "]
["6","LinNum","n6","laufende Nummer über alle Sätze               "]
["7","a1#01","an1","                                              "]
["8","a1#02","an1","                                              "]
["9","a3#01","an3","Beteiligter, Qual.IV=Rg-Empf,BY=Käufer, MI = Besteller, ST=SendTo, SU=Lieferant"]
["10","a3#02","an3","Abteilung oder Bearbeiter , Qual. IC=Informati"]
["11","a3#03","an3","                                              "]
["12","a3#04","an3","                                              "]
[13,"a3#05 ","an3   ","                                              "]
["14","a3#06","an3","                                              "]
[15,"a3#07 ","an3   ","                                              "]
[16,"a3#08 ","an3   ","                                              "]
[17,"a3#09 ","an3   ","                                              "]
[18,"a3#10 ","an3   ","Qualifier 1(TE=Telefonnr.,FX=Telefaxnr.)      "]
[19,"a3#11 ","an3   ","Qualifier 2(TE=Telefonnr.,FX=Telefaxnr.)      "]
[20,"a3#12 ","an3   ","                                              "]
[21,"a3#13 ","an3   ","                                              "]
[22,"a3#14 ","an3   ","                                              "]
[23,"a3#15 ","an3   ","                                              "]
[24,"a3#16 ","an3   ","                                              "]
[25,"a3#17 ","an3   ","                                              "]
[26,"a3#18 ","an3   ","                                              "]
[27,"a3#19 ","an3   ","                                              "]
[28,"a3#20 ","an3   ","                                              "]
[29,"a3#21 ","an3   ","                                              "]
[30,"a3#22 ","an3   ","                                              "]
[31,"a3#23 ","an3   ","                                              "]
[32,"a3#24 ","an3   ","                                              "]
[33,"a3#25 ","an3   ","                                              "]
[34,"a3#26 ","an3   ","                                              "]
[35,"a3#27 ","an3   ","                                              "]
[36,"a3#28 ","an3   ","                                              "]
[37,"a3#29 ","an3   ","                                              "]
[38,"a3#30 ","an3   ","                                              "]
[39,"a3#31 ","an3   ","Beteiligter: Land, cod. DE=Deutschland        "]
["40","a3#32","an3","                                              "]
["41","a4#01","an4","                                              "]
[42,"a4#02  ","an4   ","                                              "]
[43,"a4#03  ","an4   ","                                              "]
[44,"a6#01  ","an6   ","                                              "]
[45,"a6#02  ","an6   ","                                              "]
[46,"a6#03  ","an6   ","                                              "]
[47,"a6#04  ","an6   ","                                              "]
[48,"a7#01  ","an7   ","                                              "]
[49,"a7#02  ","an7   ","                                              "]
[50,"a8#01  ","an8   ","                                              "]
[51,"a9#01  ","an9   ","Beteiligter: PLZ                              "]
[52,"a9#02  ","an9   ","Beteiligter: Region                           "]
[53,"a11#01 ","an11  ","                                              "]
[54,"a11#02 ","an11  ","                                              "]
["55","a12#01","an12","                                              "]
["56","a14#01","an14","                                              "]
[57,"a14#02 ","an14  ","                                              "]
[58,"a14#03 ","an14  ","                                              "]
[59,"a14#04 ","an14  ","                                              "]
[60,"a14#05 ","an14  ","                                              "]
[61,"a14#06 ","an14  ","                                              "]
[62,"a14#07 ","an14  ","                                              "]
[63,"a14#08 ","an14  ","                                              "]
["64","a17#01","an17","Beteiligter: ILN                              "]
[65,"a17#02 ","an17  ","                                              "]
[66,"a17#03 ","an17  ","                                              "]
[67,"a17#04 ","an17  ","                                              "]
[68,"a17#05 ","an17  ","Abteilung oder Bearbeiter des Beteiligten, Ide"]
[69,"a17#06 ","an17  ","                                              "]
[70,"a17#07 ","an17  ","                                              "]
[71,"a17#08 ","an17  ","                                              "]
[72,"a25#01 ","an25  ","                                              "]
[73,"a25#02 ","an25  ","                                              "]
["74","a35#01","an35","Abteilung oder Bearbeiter des Beteiligten     "]
["75","a35#02","an35","                                              "]
["76","a35#03","an35","                                              "]
["77","a35#04","an35","Beteiligter: Name und Anschrift               "]
[78,"a35#05","an35  ","Beteiligter: Name                             "]
["79","a35#06","an35","Beteiligter: Name 2                           "]
["80","a35#07","an35","                                              "]
[81,"a35#08","an35  ","                                              "]
[82,"a35#09","an35  ","                                              "]
["83","a35#10","an35","Beteiligter: Strasse                          "]
["84","an35#11","an35","Beteiligter: Ort                              "]
["85","an35#12","an35","                                              "]
["86","an35#13","an35","                                              "]
["87","an35#14","an35","                                              "]
["88","an35#15","an35","                                              "]
["89","an35#16","an35","                                              "]
["90","a70#01","an70","Telefonnummer                                 "]
["91","a70#02","an70","Telefaxnummer                                 "]
["92","a70#03","an70","                                              "]
["93","a70#04","an70","                                              "]
["94","a70#05","an70","                                              "]
[95,"a70#06","an70  ","                                              "]
[96,"a70#07","an70  ","                                              "]
[97,"a70#08","an70  ","                                              "]
[98,"a70#09","an70  ","                                              "]
[99,"a70#10","an70  ","                                              "]
[100,"a70#11","an70  ","                                              "]
[101,"a70#12","an70  ","                                              "]
[102,"a70#13","an70  ","                                              "]
[103,"a70#14","an70  ","                                              "]
[104,"a70#15","an70  ","                                              "]
[105,"a70#16","an70  ","                                              "]
[106,"n1#01  ","n1    ","                                              "]
[107,"n1#02  ","n1    ","                                              "]
[108,"n1#03  ","n1    ","                                              "]
[109,"n2#01  ","n2    ","                                              "]
[110,"n2#02  ","n2    ","                                              "]
[111,"n3#01  ","n3    ","                                              "]
["112","n4#01","n4","                                              "]
[113,"n6#01  ","n6    ","                                              "]
[114,"n6#02  ","n6    ","                                              "]
[115,"n6#03  ","n6    ","                                              "]
[116,"n6#04  ","n6    ","                                              "]
[117,"n8#01  ","n8    ","                                              "]
[118,"n8#02  ","n8    ","                                              "]
[119,"n9#01  ","n9    ","                                              "]
[120,"n15#01 ","n15   ","                                              "]
[121,"n15#02 ","n15   ","                                              "]
[122,"n15#03 ","n15   ","                                              "]
[123,"n15#04 ","n15   ","                                              "]
[124,"n15#05 ","n15   ","                                              "]
[125,"n15#06 ","n15   ","                                              "]
[126,"n15#07 ","n15   ","                                              "]
[127,"n15#08 ","n15   ","                                              "]
["128","n18#01","n18","                                              "]
["129","n18#02","n18","                                              "]
[130,"n18#03 ","n18   ","                                              "]
[131,"n18#04 ","n18   ","                                              "]
[132,"n18#05 ","n18   ","                                              "]
[133,"n18#06 ","n18   ","                                              "]
[134,"n18#07 ","n18   ","                                              "]
[135,"n18#08 ","n18   ","                                              "]
[136,"np2#01 ","n12p2 ","                                              "]
[137,"np2#02 ","n12p2 ","                                              "]
[138,"np2#03 ","n12p2 ","                                              "]
[139,"np2#04 ","n12p2 ","                                              "]
[140,"np2#05 ","n12p2 ","                                              "]
[141,"np2#06 ","n12p2 ","                                              "]
[142,"np3#01 ","n12p3 ","                                              "]
[143,"np3#02 ","n12p3 ","                                              "]
[144,"np3#03 ","n12p3 ","                                              "]
[145,"np3#04 ","n12p3 ","                                              "]
[146,"np3#05 ","n12p3 ","                                              "]
[147,"np3#06 ","n12p3 ","                                              "]
[148,"np5#01 ","n12p5 ","                                              "]
[149,"np5#02 ","n12p5 ","                                              "]
[150,"np5#03 ","n12p5 ","                                              "]
[151,"np5#04 ","n12p5 ","                                              "]
[152,"np5#05 ","n12p5 ","                                              "]
[153,"np5#06 ","n12p5 ","                                              "]
[154,"MsgCtl","an14  ","                                              "]
[155,"AppRef","an14  ","                                              "]
[156,"UpdTim","an6   ","                                              "]
[157,"UpdDat","an8   ","                                              "]
[158,"WrtTim","an6   ","Zeit HHMMSS                                   "]
[159,"WrtDat","an8   ","Datum YYYYMMDD                                "]
[160,"UserNm","an35  ","                                              "]
[161,"PgmNm ","an35  ","                                              "]
[162,"XeorF ","an1   ","                                              "]
[163,"ScdTim","an6   ","m@gic EDDY Counter                            "]
[164,"ScdDat","an8   ","m@gic EDDY Lizenznummer                       "]

{"sheet":"Position","index":5,"n_rows":173,"n_cols":6,"rows_kept":173,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["B&N RCV-ORDERS",null,null,"Erstellt am 07.06.2005"]
["Position"]
[]
["#","Feld","Format","Beschreibung","cd2000-Bemerkung","gegenüber Printus"]
["1","SndRec","an3","RCV"]
["2","PrtNum","an35","ILN des Daten-Absenders"]
["3","MsgTyp","an6","ORDERS"]
["4","MaiKey","an35","Eindeutige Nummer von m@gic EDDY vergeben"]
["5","HrcLvl","an9","150000000"]
["6","LinNum","n6","laufende Nummer über alle Sätze"]
["7","a1#01","an1"]
["8","a1#02","an1"]
["9","a3#01","an3","Masseinheit der bestellte Menge, Qual. z.B. PCE=Stueck","? (mengeneinheit_vk aus sta_artikelstamm)"]
["10","a3#02","an3",null,"?","geändert"]
["11","a3#03","an3","Preisart, Qualifier Nettopreis ","?","geändert"]
["12","a3#04","an3","Preisart, Qualifier Bruttopreis","?"]
[13,"a3#05 ","an3   "]
["14","a3#06","an3","Währung, codiert",null,"neu"]
[15,"a3#07 ","an3   "]
[16,"a3#08 ","an3   ","Masseinheit der Preisbasis-Menge, Qual. z.B. PCE=Stueck","?","neu"]
[17,"a3#09 ","an3   "]
[18,"a3#10 ","an3   ","Qualifier Artikelnummer 1","?","neu"]
[19,"a3#11 ","an3   ","Qualifier Artikelnummer 2","?","neu"]
[20,"a3#12 ","an3   ","Qualifier Artikelnummer 3","?","neu"]
[21,"a3#13 ","an3   "]
[22,"a3#14 ","an3   "]
[23,"a3#15 ","an3   ","Qualifier LIN-Artikelnummer 1","?","neu"]
[24,"a3#16 ","an3   ","Qualifier LIN-Artikelnummer 2","?","neu"]
[25,"a3#17 ","an3   "]
[26,"a3#18 ","an3   "]
[27,"a3#19 ","an3   "]
[28,"a3#20 ","an3   "]
[29,"a3#21 ","an3   "]
[30,"a3#22 ","an3   "]
[31,"a3#23 ","an3   "]
[32,"a3#24 ","an3   "]
[33,"a3#25 ","an3   "]
[34,"a3#26 ","an3   "]
[35,"a3#27 ","an3   "]
[36,"a3#28 ","an3   "]
[37,"a3#29 ","an3   "]
[38,"a3#30 ","an3   "]
[39,"a3#31 ","an3   "]
["40","a3#32","an3"]
["41","a4#01","an4"]
[42,"a4#02  ","an4   "]
[43,"a4#03  ","an4   "]
[44,"a6#01  ","an6   "]
[45,"a6#02  ","an6   "]
[46,"a6#03  ","an6   "]
[47,"a6#04  ","an6   "]
[48,"a7#01  ","an7   "]
[49,"a7#02  ","an7   "]
[50,"a8#01  ","an8   "]
[51,"a9#01  ","an9   "]
[52,"a9#02  ","an9   "]
[53,"a11#01 ","an11  "]
[54,"a11#02 ","an11  "]
["55","a12#01","an12"]
["56","a14#01","an14"]
[57,"a14#02 ","an14  "]
[58,"a14#03 ","an14  "]
[59,"a14#04 ","an14  "]
[60,"a14#05 ","an14  "]
[61,"a14#06 ","an14  "]
[62,"a14#07 ","an14  "]
[63,"a14#08 ","an14  "]
["64","a17#01","an17","Liefertermin, gefordert (CCJJMMTT)","liefertermin(edi_artikel)","neu"]
[65,"a17#02 ","an17  ","Mindestrestlaufzeit in Tagen   ","?","neu"]
[66,"a17#03 ","an17  "]
[67,"a17#04 ","an17  "]
[68,"a17#05 ","an17  "]
[69,"a17#06 ","an17  "]
[70,"a17#07 ","an17  ","Art der Verpackung auf innerer Ebene; PK=Packstueck, 201=Europalette","?","neu"]
[71,"a17#08 ","an17  ","Art der Verpackung auf aeussere Ebene; PK=Packstueck, 201=Europalette","?","neu"]
[72,"a25#01 ","an25  "]
[73,"a25#02 ","an25  "]
["74","a35#01","an35","EAN-Artikelnummer","ean_nummer(edi_artikel)"]
["75","a35#02","an35","Artikelnummer des Kaeufers","kundenartikel_nr(edi_artikel)"]
["76","a35#03","an35","Artikelnummer des Lieferanten","artikel_verkaeufer(edi_artikel)"]
["77","a35#04","an35"]
[78,"a35#05","an35  "]
["79","a35#06","an35","Produkt-/Leistungsbeschreibung 1","?","neu"]
["80","a35#07","an35","Produkt-/Leistungsbeschreibung 2","?","neu"]
[81,"a35#08","an35  "]
[82,"a35#09","an35  "]
["83","a35#10","an35"]
["84","an35#11","an35","Interne Artikelgruppennummer (nur wenn keine EAN übermittelt wird)","?","neu"]
["85","an35#12","an35"]
["86","an35#13","an35"]
["87","an35#14","an35"]
["88","an35#15","an35","Europaeische Abfallkatalog","?","neu"]
["89","an35#16","an35"]
["90","a70#01","an70",null,null,"geändert"]
["91","a70#02","an70",null,null,"geändert"]
["92","a70#03","an70","Produktbeschreibung (Farbe)","?","neu"]
["93","a70#04","an70","Produktbeschreibung (Groesse)","?","neu"]
["94","a70#05","an70","Chargennummer","?","neu"]
[95,"a70#06","an70  ","Rahmenauftragsnummer ","(wird bereits im kopf gehandelt)","neu"]
[96,"a70#07","an70  "]
[97,"a70#08","an70  "]
[98,"a70#09","an70  "]
[99,"a70#10","an70  "]
[100,"a70#11","an70  "]
[101,"a70#12","an70  "]
[102,"a70#13","an70  "]
[103,"a70#14","an70  "]
[104,"a70#15","an70  "]
[105,"a70#16","an70  "]
[106,"n1#01  ","n1    "]
[107,"n1#02  ","n1    "]
[108,"n1#03  ","n1    "]
[109,"n2#01  ","n2    "]
[110,"n2#02  ","n2    "]
[111,"n3#01  ","n3    "]
["112","n4#01","n4"]
[113,"n6#01  ","n6    ","Positionsnummer","positions_nr(edi_artikel)"]
[114,"n6#02  ","n6    "]
[115,"n6#03  ","n6    "]
[116,"n6#04  ","n6    "]
[117,"n8#01  ","n8    ","Anzahl der Packstuecke, innere Verpackung","?","neu"]
[118,"n8#02  ","n8    ","Anzahl der Packstuecke, aeussere Verpackung ","?","neu"]
[119,"n9#01  ","n9    "]
[120,"n15#01 ","n15   "]
[121,"n15#02 ","n15   ","Preisbasis-Menge  ","preiseinheit(edi_artikel)","neu"]
[122,"n15#03 ","n15   "]
[123,"n15#04 ","n15   "]
[124,"n15#05 ","n15   "]
[125,"n15#06 ","n15   "]
[126,"n15#07 ","n15   "]
[127,"n15#08 ","n15   "]
["128","n18#01","n18"]
["129","n18#02","n18"]
[130,"n18#03 ","n18   "]
[131,"n18#04 ","n18   "]
[132,"n18#05 ","n18   "]
[133,"n18#06 ","n18   "]
[134,"n18#07 ","n18   "]
[135,"n18#08 ","n18   "]
[136,"np2#01 ","n12p2 ","bestellte Menge","menge(edi_artikel)"]
[137,"np2#02 ","n12p2 ","Preis je Einheit"]
[138,"np2#03 ","n12p2 "]
[139,"np2#04 ","n12p2 "]
[140,"np2#05 ","n12p2 ","Nettopreis","nettopreis, evtl. edi_preis(edi_artikel)"]
[141,"np2#06 ","n12p2 ","Bruttopreis",null,"neu"]
[142,"np3#01 ","n12p3 "]
[143,"np3#02 ","n12p3 ","Positionsbetrag ","positions_wert(edi_artikel)","neu"]
[144,"np3#03 ","n12p3 "]
[145,"np3#04 ","n12p3 "]
[146,"np3#05 ","n12p3 "]
[147,"np3#06 ","n12p3 "]
[148,"np5#01 ","n12p5 "]
[149,"np5#02 ","n12p5 "]
[150,"np5#03 ","n12p5 "]
[151,"np5#04 ","n12p5 "]
[152,"np5#05 ","n12p5 "]
[153,"np5#06 ","n12p5 "]
[154,"MsgCtl","an14  "]
[155,"AppRef","an14  "]
[156,"UpdTim","an6   "]
[157,"UpdDat","an8   "]
[158,"WrtTim","an6   ","Zeit HHMMSS                                            "]
[159,"WrtDat","an8   ","Datum YYYYMMDD                                         "]
[160,"UserNm","an35  ","                                                       "]
[161,"PgmNm ","an35  ","                                                       "]
[162,"XeorF ","an1   ","                                                       "]
[163,"ScdTim","an6   ","m@gic EDDY Counter                                     "]
[164,"ScdDat","an8   ","m@gic EDDY Lizenznummer                                "]
[]
[]
[{"$nulls":4},"1       Leopold Kostal für Unimet        "]
[{"$nulls":4},"2       Johnson Controls für Carl Müller "]
[{"$nulls":4},"3       Delphi"]

{"sheet":"PosText","index":6,"n_rows":173,"n_cols":6,"rows_kept":173,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["B&N RCV-ORDERS",null,null,"Erstellt am 07.06.2005"]
["Position: Freier Text"]
[]
["#","Feld","Format","Beschreibung","cd2000-Bemerkung","gegenüber Printus"]
["1","SndRec","an3","RCV"]
["2","PrtNum","an35","ILN des Daten-Absenders"]
["3","MsgTyp","an6","ORDERS"]
["4","MaiKey","an35","Eindeutige Nummer von m@gic EDDY vergeben"]
["5","HrcLvl","an9","154000000"]
["6","LinNum","n6","laufende Nummer über alle Sätze"]
["7","a1#01","an1"]
["8","a1#02","an1"]
["9","a3#01","an3","Textzuordnung, codiert ; AAK=Preiskonditionen, PUR=Beschaffungsinforma"]
["10","a3#02","an3"]
["11","a3#03","an3"]
["12","a3#04","an3"]
[13,"a3#05 ","an3   "]
["14","a3#06","an3"]
[15,"a3#07 ","an3   "]
[16,"a3#08 ","an3   "]
[17,"a3#09 ","an3   "]
[18,"a3#10 ","an3   "]
[19,"a3#11 ","an3   "]
[20,"a3#12 ","an3   "]
[21,"a3#13 ","an3   "]
[22,"a3#14 ","an3   "]
[23,"a3#15 ","an3   "]
[24,"a3#16 ","an3   "]
[25,"a3#17 ","an3   "]
[26,"a3#18 ","an3   "]
[27,"a3#19 ","an3   "]
[28,"a3#20 ","an3   "]
[29,"a3#21 ","an3   "]
[30,"a3#22 ","an3   "]
[31,"a3#23 ","an3   "]
[32,"a3#24 ","an3   "]
[33,"a3#25 ","an3   "]
[34,"a3#26 ","an3   "]
[35,"a3#27 ","an3   "]
[36,"a3#28 ","an3   "]
[37,"a3#29 ","an3   "]
[38,"a3#30 ","an3   "]
[39,"a3#31 ","an3   "]
["40","a3#32","an3"]
["41","a4#01","an4"]
[42,"a4#02  ","an4   "]
[43,"a4#03  ","an4   "]
[44,"a6#01  ","an6   "]
[45,"a6#02  ","an6   "]
[46,"a6#03  ","an6   "]
[47,"a6#04  ","an6   "]
[48,"a7#01  ","an7   "]
[49,"a7#02  ","an7   "]
[50,"a8#01  ","an8   "]
[51,"a9#01  ","an9   "]
[52,"a9#02  ","an9   "]
[53,"a11#01 ","an11  "]
[54,"a11#02 ","an11  "]
["55","a12#01","an12"]
["56","a14#01","an14"]
[57,"a14#02 ","an14  "]
[58,"a14#03 ","an14  "]
[59,"a14#04 ","an14  "]
[60,"a14#05 ","an14  "]
[61,"a14#06 ","an14  "]
[62,"a14#07 ","an14  "]
[63,"a14#08 ","an14  "]
["64","a17#01","an17"]
[65,"a17#02 ","an17  "]
[66,"a17#03 ","an17  "]
[67,"a17#04 ","an17  "]
[68,"a17#05 ","an17  "]
[69,"a17#06 ","an17  "]
[70,"a17#07 ","an17  "]
[71,"a17#08 ","an17  "]
[72,"a25#01 ","an25  "]
[73,"a25#02 ","an25  "]
["74","a35#01","an35"]
["75","a35#02","an35"]
["76","a35#03","an35"]
["77","a35#04","an35"]
[78,"a35#05","an35  "]
["79","a35#06","an35"]
["80","a35#07","an35"]
[81,"a35#08","an35  "]
[82,"a35#09","an35  "]
["83","a35#10","an35"]
["84","an35#11","an35"]
["85","an35#12","an35"]
["86","an35#13","an35"]
["87","an35#14","an35"]
["88","an35#15","an35"]
["89","an35#16","an35"]
["90","a70#01","an70","Freier Text 1","edi_textdaten"]
["91","a70#02","an70","Freier Text 2","edi_textdaten"]
["92","a70#03","an70","Freier Text 3","edi_textdaten"]
["93","a70#04","an70","Freier Text 4","edi_textdaten","neu"]
["94","a70#05","an70","Freier Text 5","edi_textdaten","neu"]
[95,"a70#06","an70  "]
[96,"a70#07","an70  "]
[97,"a70#08","an70  "]
[98,"a70#09","an70  "]
[99,"a70#10","an70  "]
[100,"a70#11","an70  "]
[101,"a70#12","an70  "]
[102,"a70#13","an70  "]
[103,"a70#14","an70  "]
[104,"a70#15","an70  "]
[105,"a70#16","an70  "]
[106,"n1#01  ","n1    "]
[107,"n1#02  ","n1    "]
[108,"n1#03  ","n1    "]
[109,"n2#01  ","n2    "]
[110,"n2#02  ","n2    "]
[111,"n3#01  ","n3    "]
["112","n4#01","n4"]
[113,"n6#01  ","n6    "]
[114,"n6#02  ","n6    "]
[115,"n6#03  ","n6    "]
[116,"n6#04  ","n6    "]
[117,"n8#01  ","n8    "]
[118,"n8#02  ","n8    "]
[119,"n9#01  ","n9    "]
[120,"n15#01 ","n15   "]
[121,"n15#02 ","n15   "]
[122,"n15#03 ","n15   "]
[123,"n15#04 ","n15   "]
[124,"n15#05 ","n15   "]
[125,"n15#06 ","n15   "]
[126,"n15#07 ","n15   "]
[127,"n15#08 ","n15   "]
["128","n18#01","n18"]
["129","n18#02","n18"]
[130,"n18#03 ","n18   "]
[131,"n18#04 ","n18   "]
[132,"n18#05 ","n18   "]
[133,"n18#06 ","n18   "]
[134,"n18#07 ","n18   "]
[135,"n18#08 ","n18   "]
[136,"np2#01 ","n12p2 "]
[137,"np2#02 ","n12p2 "]
[138,"np2#03 ","n12p2 "]
[139,"np2#04 ","n12p2 "]
[140,"np2#05 ","n12p2 "]
[141,"np2#06 ","n12p2 "]
[142,"np3#01 ","n12p3 "]
[143,"np3#02 ","n12p3 "]
[144,"np3#03 ","n12p3 "]
[145,"np3#04 ","n12p3 "]
[146,"np3#05 ","n12p3 "]
[147,"np3#06 ","n12p3 "]
[148,"np5#01 ","n12p5 "]
[149,"np5#02 ","n12p5 "]
[150,"np5#03 ","n12p5 "]
[151,"np5#04 ","n12p5 "]
[152,"np5#05 ","n12p5 "]
[153,"np5#06 ","n12p5 "]
[154,"MsgCtl","an14  "]
[155,"AppRef","an14  "]
[156,"UpdTim","an6   "]
[157,"UpdDat","an8   "]
[158,"WrtTim","an6   ","Zeit HHMMSS                                            "]
[159,"WrtDat","an8   ","Datum YYYYMMDD                                         "]
[160,"UserNm","an35  ","                                                       "]
[161,"PgmNm ","an35  ","                                                       "]
[162,"XeorF ","an1   ","                                                       "]
[163,"ScdTim","an6   ","m@gic EDDY Counter                                     "]
[164,"ScdDat","an8   ","m@gic EDDY Lizenznummer                                "]
[]
[]
[{"$nulls":4},"1       Leopold Kostal für Unimet        "]
[{"$nulls":4},"2       Johnson Controls für Carl Müller "]
[{"$nulls":4},"3       Delphi"]

{"sheet":"Zu-Abschläge","index":7,"n_rows":173,"n_cols":6,"rows_kept":173,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["B&N RCV-ORDERS",null,null,"Erstellt am 07.06.2005"]
["Position / Zu-Abschläge"]
[]
["#","Feld","Format","Beschreibung","cd2000-Bemerkung","gegenüber Printus"]
["1","SndRec","an3","RCV"]
["2","PrtNum","an35","ILN des Daten-Absenders"]
["3","MsgTyp","an6","ORDERS"]
["4","MaiKey","an35","Eindeutige Nummer von m@gic EDDY vergeben"]
["5","HrcLvl","an9","155000000"]
["6","LinNum","n6","laufende Nummer über alle Sätze"]
["7","a1#01","an1"]
["8","a1#02","an1"]
["9","a3#01","an3","Zu- oder Abschlag, Qualifier A=Abschlag, C=Zuschlag","rabatt oder zuschlag"]
["10","a3#02","an3","Kalkulations-Folge-Anzeiger,cod. 1=Erste Kalkulationsstufe, 2=... ","?"]
["11","a3#03","an3","Zu-/Abschlaege, cod. DI=Abzug, EAB-Skonto, FC-Frachtgeb.           ","?"]
["12","a3#04","an3","Verantwortliche Stelle für die Codepflege zu Dienst/Leistung;; 9=EAN,","?"]
[13,"a3#05 ","an3   "]
["14","a3#06","an3"]
[15,"a3#07 ","an3   "]
[16,"a3#08 ","an3   "]
[17,"a3#09 ","an3   "]
[18,"a3#10 ","an3   "]
[19,"a3#11 ","an3   "]
[20,"a3#12 ","an3   "]
[21,"a3#13 ","an3   "]
[22,"a3#14 ","an3   "]
[23,"a3#15 ","an3   "]
[24,"a3#16 ","an3   "]
[25,"a3#17 ","an3   "]
[26,"a3#18 ","an3   "]
[27,"a3#19 ","an3   "]
[28,"a3#20 ","an3   "]
[29,"a3#21 ","an3   "]
[30,"a3#22 ","an3   "]
[31,"a3#23 ","an3   "]
[32,"a3#24 ","an3   "]
[33,"a3#25 ","an3   "]
[34,"a3#26 ","an3   "]
[35,"a3#27 ","an3   "]
[36,"a3#28 ","an3   "]
[37,"a3#29 ","an3   "]
[38,"a3#30 ","an3   "]
[39,"a3#31 ","an3   "]
["40","a3#32","an3"]
["41","a4#01","an4"]
[42,"a4#02  ","an4   "]
[43,"a4#03  ","an4   "]
[44,"a6#01  ","an6   "]
[45,"a6#02  ","an6   "]
[46,"a6#03  ","an6   "]
[47,"a6#04  ","an6   "]
[48,"a7#01  ","an7   "]
[49,"a7#02  ","an7   "]
[50,"a8#01  ","an8   "]
[51,"a9#01  ","an9   "]
[52,"a9#02  ","an9   "]
[53,"a11#01 ","an11  "]
[54,"a11#02 ","an11  "]
["55","a12#01","an12"]
["56","a14#01","an14"]
[57,"a14#02 ","an14  "]
[58,"a14#03 ","an14  "]
[59,"a14#04 ","an14  "]
[60,"a14#05 ","an14  "]
[61,"a14#06 ","an14  "]
[62,"a14#07 ","an14  "]
[63,"a14#08 ","an14  "]
["64","a17#01","an17"]
[65,"a17#02 ","an17  "]
[66,"a17#03 ","an17  "]
[67,"a17#04 ","an17  "]
[68,"a17#05 ","an17  "]
[69,"a17#06 ","an17  "]
[70,"a17#07 ","an17  "]
[71,"a17#08 ","an17  "]
[72,"a25#01 ","an25  "]
[73,"a25#02 ","an25  "]
["74","a35#01","an35"]
["75","a35#02","an35"]
["76","a35#03","an35"]
["77","a35#04","an35"]
[78,"a35#05","an35  "]
["79","a35#06","an35"]
["80","a35#07","an35"]
[81,"a35#08","an35  "]
[82,"a35#09","an35  "]
["83","a35#10","an35"]
["84","an35#11","an35"]
["85","an35#12","an35"]
["86","an35#13","an35"]
["87","an35#14","an35"]
["88","an35#15","an35"]
["89","an35#16","an35"]
["90","a70#01","an70"]
["91","a70#02","an70"]
["92","a70#03","an70"]
["93","a70#04","an70"]
["94","a70#05","an70"]
[95,"a70#06","an70  "]
[96,"a70#07","an70  "]
[97,"a70#08","an70  "]
[98,"a70#09","an70  "]
[99,"a70#10","an70  "]
[100,"a70#11","an70  "]
[101,"a70#12","an70  "]
[102,"a70#13","an70  "]
[103,"a70#14","an70  "]
[104,"a70#15","an70  "]
[105,"a70#16","an70  "]
[106,"n1#01  ","n1    "]
[107,"n1#02  ","n1    "]
[108,"n1#03  ","n1    "]
[109,"n2#01  ","n2    "]
[110,"n2#02  ","n2    "]
[111,"n3#01  ","n3    "]
["112","n4#01","n4"]
[113,"n6#01  ","n6    "]
[114,"n6#02  ","n6    "]
[115,"n6#03  ","n6    "]
[116,"n6#04  ","n6    "]
[117,"n8#01  ","n8    "]
[118,"n8#02  ","n8    "]
[119,"n9#01  ","n9    "]
[120,"n15#01 ","n15   "]
[121,"n15#02 ","n15   "]
[122,"n15#03 ","n15   "]
[123,"n15#04 ","n15   "]
[124,"n15#05 ","n15   "]
[125,"n15#06 ","n15   "]
[126,"n15#07 ","n15   "]
[127,"n15#08 ","n15   "]
["128","n18#01","n18"]
["129","n18#02","n18"]
[130,"n18#03 ","n18   "]
[131,"n18#04 ","n18   "]
[132,"n18#05 ","n18   "]
[133,"n18#06 ","n18   "]
[134,"n18#07 ","n18   "]
[135,"n18#08 ","n18   "]
[136,"np2#01 ","n12p2 ","Prozentsatz des Zu-/Abschlags"]
[137,"np2#02 ","n12p2 ","Zu-/Abschlagsbetrag"]
[138,"np2#03 ","n12p2 "]
[139,"np2#04 ","n12p2 "]
[140,"np2#05 ","n12p2 "]
[141,"np2#06 ","n12p2 "]
[142,"np3#01 ","n12p3 "]
[143,"np3#02 ","n12p3 "]
[144,"np3#03 ","n12p3 "]
[145,"np3#04 ","n12p3 "]
[146,"np3#05 ","n12p3 "]
[147,"np3#06 ","n12p3 "]
[148,"np5#01 ","n12p5 "]
[149,"np5#02 ","n12p5 "]
[150,"np5#03 ","n12p5 "]
[151,"np5#04 ","n12p5 "]
[152,"np5#05 ","n12p5 "]
[153,"np5#06 ","n12p5 "]
[154,"MsgCtl","an14  "]
[155,"AppRef","an14  "]
[156,"UpdTim","an6   "]
[157,"UpdDat","an8   "]
[158,"WrtTim","an6   ","Zeit HHMMSS                                            "]
[159,"WrtDat","an8   ","Datum YYYYMMDD                                         "]
[160,"UserNm","an35  ","                                                       "]
[161,"PgmNm ","an35  ","                                                       "]
[162,"XeorF ","an1   ","                                                       "]
[163,"ScdTim","an6   ","m@gic EDDY Counter                                     "]
[164,"ScdDat","an8   ","m@gic EDDY Lizenznummer                                "]
[]
[]
[{"$nulls":4},"1       Leopold Kostal für Unimet        "]
[{"$nulls":4},"2       Johnson Controls für Carl Müller "]
[{"$nulls":4},"3       Delphi"]