{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["xbde_artikel"],"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_artikel","index":0,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Datenbank-Schnittstelle cimERP-Extemes BDE"]
[]
["xbde_artikel","Artikelstammdaten"]
[]
["Column Name","Type","Length","Nulls","Default","Key","Beschreibung","Muss/Kann","Format/Bemerkungen"]
["erznr","varchar",20,"no","yes",1,"Artikelnummer","M","max. 18 Stellen"]
["erzbez1","varchar",64,"no","yes",null,"Artikelbezeichnung 1","M"]
["erzbez2","varchar",64,"no","yes",null,"Artikelbezeichnung 2","K"]
["erzgr","varchar",20,"no","yes",null,"Teilegruppe 1","K","max. 3 Stellen"]
["zeichnr","varchar",20,"no","yes",null,"Zeichnungsnummer","K"]
["kotr","varchar",4,"no","yes",null,"Kostenträger Artikelstamm (kurz)","K"]
["erznr_lang","varchar",512,"no","yes",null,"Artikelbeschreibung","K","Seite 30 = Fertigung"]
["modus","char",1,"no","yes",2,"Satzmodus (N=neu, C=geändert, S=gelöscht)","M"]
["br_gewicht","float8",null,"no","yes",null,"Sollgewicht Artikel","K","Bruttogewicht aus Artikelstamm (Feld 'gewicht')"]
["kst_stelle","varchar",20,"no","yes",null,null,null,"nicht in Verwendung"]
["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"]
["kz_zuk_prod","integer4",null,"no","yes",null,"Kennz. Zukauf/Produktion","M","siehe Artikelstamm"]
["kz_best_fuehr","integer4",null,"no","yes",null,"Kennz. Bestandsführung","M","0=mit Best.-Führ., 1=ohne, 2=Best.-Führ. mit Charge"]
[]
[]
["Für die Erstübenahme besteht ein Sonderablauf, danach nur Änderungen (KZ-Basisparameter BDE)"]
[]
[]
["W. Köpplinger, 23.07.2015"]