{"text_format":"2","workbook":"xls","n_sheets":2,"sheets":["xbde_rueck_material","Historie"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":12,"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_rueck_material","index":0,"n_rows":45,"n_cols":15,"rows_kept":45,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Stand: 22.11.2019, WK",null,null,null,"Schnittstellenbeschreibung Datenimport cimERP",null,"Manuelle Abgangsbuchung","Manuelle Zugangsbuchung","Fertigungszugang BDZ","Materialkarten- abbuchung MAB","Interne Bedarfsmeldung","Inventur-Buchung","Materialabbuchung ungeplant","Fertigungszugang ungeplant","Fertigungsfreigabe"]
["xbde_rueck_material","Datentyp","Länge","Muss/Kann","Beschreibung",null,"Rückgabeart = \"A\" oder \"UA\", Planungsart = \"M\"","Rückgabeart = \"Z\" oder \"UZ\", Planungsart = \"M\"","Rückgabeart = \"F\"= Fertigung, Planungsart = \"G\"=Geplant","Rückgabeart = \"V\"= Verbrauch, Planungsart = \"G\"=Geplant","Rückgabeart = \"BEME\", Planungsart = \"M\"","Rückgabeart = \"I\", Planungsart = \"M\"","Rückgabeart = \"V\"= Verbrauch, Planungsart = \"U\"=Ungeplant","Rückgabeart = \"F\"= Fertigung, Planungsart = \"U\"=Ungeplant","Rückgabeart = \"FREIGABE\"\nPlanungsart = \"FA\", \"FAPOS\", \"FAPOSBK\""]
["row_tid","integer        ",null,"M","Eindeutiger Satzkenner für die Rückgabe",null,"M","M","M","M","M","M","M","M","M"]
["aknr","varchar",15,"M/K","Kombinierte Auftrags-Nr. Stellen1-2=Betriebs-Nummer"]
["auftrags_nr","integer        ",null,"M/K","Auftragsnummer",null,"K (Nachkalkulation)",null,"K (Nachkalkulation)","K (Nachkalkulation)",null,null,"K (Nachkalkulation)","K (Nachkalkulation)","M"]
["pos_nr1                 ","integer        ",null,"M/K","Auftragsposition",null,"K (Nachkalkulation)",null,"K (Nachkalkulation)","K (Nachkalkulation)",null,null,"K (Nachkalkulation)","K (Nachkalkulation)","M/K"]
["pos_nr2                 ","integer        ",null,"M/K","Baukasten-Nummer",null,"K (Nachkalkulation)",null,"K (Nachkalkulation)","K (Nachkalkulation)",null,null,"K (Nachkalkulation)","K (Nachkalkulation)","M/K"]
["lfd_nummer              ","integer        ",null,"M/K","Eindeutige Laufnummer (1=Baukasten, 2...=Material)"]
["artikel_ueber           ","varchar",18,"M/K","Baukastenartikel",null,null,null,"M (Artikel-Nummer)",null,"M (Artikel-Nummer)",null,null,"M (Artikel-Nummer)"]
["artikel_unter           ","varchar",18,"M/K","Positionsartikel",null,"M (Artikel-Nummer)","M (Artikel-Nummer)",null,"M (Artikel-Nummer)",null,"M (Artikel-Nummer)","M (Artikel-Nummer)"]
["serien_nr               ","varchar",10,"not used","Seriennummer"]
["variante_1              ","varchar",6,"K","Variante 1",null,"K","K","K","K",null,"K","K","K"]
["variante_2              ","varchar",6,"K","Variante 2",null,"K","K","K","K",null,"K","K","K"]
["variante_3              ","varchar",6,"K","Variante 3",null,"K","K","K","K",null,"K","K","K"]
["variante_4              ","varchar",6,"K","Variante 4",null,null,null,"K","K"]
["variante_5              ","varchar",6,"K","Variante 5",null,null,null,"K","K"]
["materialkarten_nr       ","integer        ",null,"M/K","Materialkarten-Nummer",{"$nulls":4},"M"]
["materialkarten_pos      ","integer        ",null,"M/K","Materialkarten-Positions-Nummer",{"$nulls":4},"M"]
["bde_nr                  ","integer        ",null,"M/K","BDE-Nummer für BDZ",null,null,null,"M"]
["istmenge                ","float          ",null,"M","Istmenge",null,"M","M","M","M","M","M","M","M"]
["ausschuss_menge         ","float          ",null,"not used","Ausschusssmenge"]
["kz_menge                ","integer        ",null,"not used","Mengenkennzeichen"]
["chargen_nr","varchar",20,"K","Chargen-Nummer",null,"K","K","K","K",null,"K","K","K"]
["lager                   ","integer        ",null,"M/K","Lager (0=Hauptlager)",null,"M","M","M","M","M","M","M","M"]
["lagerort","integer        ",null,"not used","Lagerort"]
["lagerbereich","integer        ",null,"K","Lagerbereich",null,"K (chaotisches Lager)","K (chaotisches Lager)","K (chaotisches Lager)","K (chaotisches Lager)",null,"K (chaotisches Lager)","K (chaotisches Lager)","K (chaotisches Lager)"]
["regal","integer        ",null,"K","Lager-Regal",null,"K (chaotisches Lager)","K (chaotisches Lager)","K (chaotisches Lager)","K (chaotisches Lager)",null,"K (chaotisches Lager)","K (chaotisches Lager)","K (chaotisches Lager)"]
["hoehe","integer        ",null,"K","Lager-Höhe",null,"K (chaotisches Lager)","K (chaotisches Lager)","K (chaotisches Lager)","K (chaotisches Lager)",null,"K (chaotisches Lager)","K (chaotisches Lager)","K (chaotisches Lager)"]
["laenge","integer        ",null,"K","Lager-Länge",null,"K (chaotisches Lager)","K (chaotisches Lager)","K (chaotisches Lager)","K (chaotisches Lager)",null,"K (chaotisches Lager)","K (chaotisches Lager)","K (chaotisches Lager)"]
["status                  ","integer        ",null,"K","Status",null,null,null,"K","K"]
["kz_rueck_art","varchar",10,"M","Kennzeichen Rückgabeart: \"F\"=Fertigung, \"V\"=Verbrauch, \"A\"=Abgangsbuchung, \"Z\"=Zugangsbuchung, \"I\"=Inventurbuchung, \"UA\"=Umbuchung-Abgangsbuchung, \"UZ\"=Umbuchung-Zugangsbuchung, \"BEME\"=Interne Bedarfsmeldung, \"FREIGABE\"=Fertigungsfreigabe",null,"M","M","M","M","M","M","M","M","M (\"FREIGABE\")"]
["kz_planung","varchar",10,"M","Kennzeichen Planungsart \"G\"=Geplant, \"U\"=Ungeplant, \"M\"=Manuell",null,"M","M","M","M","M","M","M","M","M (\"FA\", \"FAPOS\", \"FAPOSBK\")"]
["personal_nr","integer        ",null,"K","Personal-Nummer",null,"K","K","K","K","M","K","K","K","K"]
["satzart","varchar",3,"K","indiv. Buchungssatzart",null,"K","K",{"$nulls":4},"K","K"]
["ascii_datensatz","varchar",2000,"K","Datensatz bei Import aus ASCII-Datei über einen Konverter"]
["benutzerfeld_int","integer        ",null,"K","Benutzerfeld"]
["sperrgrund_nr","integer        ",null,"K","Sperrgrund-Nummer",null,null,"K",{"$nulls":5},"K"]
["bewegungs_datum","date",null,"K","optionales Bewegungsdatum",null,"K","K","K","K","M",null,"K","K"]
["kst_traeger","varchar",20,"K","Kostenträger",null,"K","K",{"$nulls":4},"K","K"]
["kst_stelle","varchar",20,"K","Kostenstelle"]
["kst_objekt","varchar",20,"K","Kostenobjekt"]
["lieferanten_nr","integer        ",null,"K","Lieferantennummer",{"$nulls":5},"K"]
["term_11","integer(NULL)",null,"M/K","Bedarfstermin 11",{"$nulls":5},"M"]
["term_22","integer(NULL)",null,"M/K","Bedarfstermin 22",{"$nulls":5},"M"]
["term_33","integer(NULL)",null,"M/K","Bedarfstermin 33",{"$nulls":5},"M"]

{"sheet":"Historie","index":1,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Historie"]
["Datum ","Kommentar","Kürzel"]
["2019-11-22","Neuer Funktionscode \"FREIGABE\"","WK"]