{"text_format":"2","workbook":"xls","n_sheets":2,"sheets":["xbde_material","Historie"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"xbde_material","index":0,"n_rows":43,"n_cols":9,"rows_kept":43,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Stand: 24.03.2021","Datenbank-Schnittstelle cimERP-Externes BDE/MES"]
[]
[null,"Artikeldaten Baukasten und Komponenten"]
[{"$nulls":8},"_"]
["xbde_material","Datentyp","Länge","Nulls","Default","Key","Beschreibung","Muss/Kann","Format/Bemerkungen"]
["modus","char",1,"no","yes",null,"Satzmodus (N=neu, C=geändert, S=gelöscht/Storno)","M"]
["aknr","varchar",20,"no","yes",1,"Kombinierte FA-Auftragsnummer für externes BDE","M","Formatierung siehe xbde_arbeitsgang"]
["auftrags_nr","integer",null,"no","yes",2,"Auftragsnummer FA","M"]
["pos_nr1                 ","integer",null,"no","yes",3,"Auftragsposition","M"]
["pos_nr2                 ","integer",null,"no","yes",4,"Baukasten-Nummer","M"]
["lfd_nummer              ","integer",null,"no","yes",5,"Eindeutige Laufnummer (1=Baukasten, 2...=Material)","M"]
["kunden_nr","integer",null,"no","yes",null,"Kundennummer","K"]
["artikel_ueber","varchar",18,"no","yes",null,"Baukastenartikel","M"]
["artikel_unter","varchar",18,"no","yes",null,"Positionsartikel","M"]
["serien_nr","varchar",32,"no","yes",null,"Seriennummer","K"]
["variante_1","varchar",6,"no","yes",null,"Variante 1","K"]
["variante_2","varchar",6,"no","yes",null,"Variante 2","K"]
["variante_3","varchar",6,"no","yes",null,"Variante 3","K"]
["variante_4","varchar",6,"no","yes",null,"Variante 4","K"]
["variante_5","varchar",6,"no","yes",null,"Variante 5","K"]
["sollmenge","float",null,"no","yes",null,"Sollmenge","K"]
["istmenge","float",null,"no","yes",null,"Istmenge","K"]
["kz_menge","integer",null,"no","yes",null,"Mengenkennzeichen","K"]
["lager","integer",null,"no","yes",null,"Lager (0=Hauptlager)","K"]
["verbuchte_menge","float",null,"no","yes",null,"Restmenge in Dispo","K"]
["arbeitsgang","integer",null,"no","yes",null,"zugeordneter Arbeitsgang","K"]
["bde_nr","integer",null,"no","yes",null,"BDE-Nummer für BDZ","K"]
["status","integer",null,"no","yes",null,"Status: 1=freigegeben, 3=rückgemeldet, 5=erledigt","M"]
["materialkarten_nr","integer",null,"no","yes",null,"Materialkarten-Nummer","K"]
["materialkarten_pos","integer",null,"no","yes",null,"Materialkarten-Positions-Nummer","K"]
["baugruppenmenge","float",null,"no","yes",null,"Baugruppenmenge","K"]
["ausschuss","float",null,"no","yes",null,"Ausschuss in Prozent","K"]
["position_stl","integer",null,"no","yes",null,"Stücklisten-Positionsnummer","K"]
["ausschuss_menge","float",null,"no","yes",null,"Ausschussmenge","K"]
["aenderungsgrund_nummer","integer",null,"no","yes",null,"Änderungsgrundnummer","K"]
["stl_menge","float",null,"no","yes",null,"Stücklisten-Menge","K"]
["pruefplan","varchar",18,"no","yes",null,"Prüfplan","K"]
["benutzerfeld_1","float",null,"no","yes",null,"Benutzerfeld 1 OP Material","K"]
["benutzerfeld_2","float",null,"no","yes",null,"Benutzerfeld 2 OP Material","K"]
["satzart","varchar",3,"no","yes",null,"Satzart","not used"]
["produktionsart","varchar",1,"no","yes",null,"Produktionsart: \"K\" = Koppelproduktion","K","neu ab 24.03.2021 (Version 3.09)"]
["id_koppelprodukt","integer",null,"no","yes",6,"Eindeutige ID des Baukasten/Koppelproduktes\n0 = Primär-Artikel, \n1,2,3… = Koppel-Artikel","M","neu ab 24.03.2021 (Version 3.09)"]
["datum_l_aend","date",null,"no","yes",null,"Timestamp der letzten Änderung des Datensatzes (TT.MM.JJJJ HH:MM:SS)","K","neu ab 24.03.2021 (Version 3.09)"]

{"sheet":"Historie","index":1,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Historie zur Schnittstelle \"xbde_material\""]
[]
["Datum","Feld","Beschreibung","Autor"]
[]
["2021-03-24","produktionsart","Produktionsart: K = Koppelproduktion; \nHandelt es sich bei dem Datensatz um ein Koppelprodukt / Koppel-Baukasten, dann steht in diesem Feld der Wert \"K\"","W. Köpplinger"]
["2021-03-24","id_koppelprodukt","Dieses Feld wurde als neues Schlüsselfeld hinzugefügt. Werden Koppelprodukt-Artikel mit ausgegeben, dann wird hier die entsprechende laufende ID ausgegeben.\n0 = Primär-Artikel\n1,2,3 … = Koppel-Artikel","W. Köpplinger"]
["2021-03-24","datum_l_aend","Zeitstempel/Timestamp","W. Köpplinger"]