{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["xbde_arbeitsplatz"],"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_arbeitsplatz","index":0,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Datenbank-Schnittstelle cimERP-Externes BDE"]
[]
["xbde_arbeitsplatz","Arbeitsplatzstammdaten"]
[]
["Column Name","Type","Length","Nulls","Default","Key","Beschreibung","Muss/Kann","Format/Bemerkungen"]
["modus","char",1,"no","yes",1,"Satzmodus (N=neu, C=geändert, S=gelöscht)","M"]
["arbplatz","varchar",9,"no","no",2,"Arbeitsplatz","M","insges. max 9 Stellen, davon die ersten 2 Stellen = Betriebsnummer"]
["arbplbez","varchar",50,"no","yes",null,"Arbeitsplatzbezeichnung","M"]
["mgr","integer4",null,"no","yes",null,"Maschinengruppe","K"]
["kostst","integer4",null,"no","yes",null,"Kostenstelle aus Arbeitsplatz","K"]
["anzma","integer4",null,"no","yes",null,"Anzahl Maschinen","M"]
["kz bde","integer4",null,"no","yes",null,"Kennz. BDE-Meldung Ja/Nein","K","0=Nein, 1=Ja"]
["Istgfak","float8",4,"no","yes",null,"Leistungsgradfaktor","K"]
["unterlief","float8",null,"no","null",null,"Prozentsatz zulässige Unterlieferung","K","bei null = keine Prüfung, 0 = keine Abweichung zulässig"]
["ueberlief","float8",null,"no","null",null,"Prozentsatz zulässige Überlieferung","K","bei null = keine Prüfung, 0 = keine Abweichung zulässig"]
["kst_stelle","varchar",20,"no","yes",null,"Kostenstelle aus Arbeitsplatz (lang)","K"]
["kst_objekt","varchar",20,"no","yes",null,null,null,"nicht in Verwendung"]
["kst_traeger","varchar",20,"no","yes",null,"Kostenträger Artikelstamm","K"]
["kst_fuer_auftrag","varchar",20,"no","yes",null,null,null,"nicht in Verwendung"]
[]
[]
["Für die Erstübernahme besteht ein Sonderablauf, danach nur Änderungen oder Löschungen (KZ-Basisparameter BDE)"]
["Die zu übertragenenden Datensätze werden auf Datenbankebene über Events erkannt und an die Schnittstelle übergeben"]
[]
[]
["W. Köpplinger, 23.07.2015"]