{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["xbde_auftrag"],"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_auftrag","index":0,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Datenbank-Schnittstelle cimERP-Externes BDE"]
[]
["xbde_auftrag","Auftragsdaten Baukasten"]
[]
["Column Name","Type","Length","Nulls","Default","Key","Beschreibung","Muss/Kann","Format/Bemerkungen"]
["modus","char",1,"no","yes",null,"Satzmodus (N=neu, C=geändert, S=gelöscht, E=Ende)","M","modus"]
["aknr","varchar",20,"no","yes",1,"Kombinierte F-Auftragsnummer für externes BDE","M","Formatierung siehe xbde_arbeitsgang"]
["kafnr","varchar",15,"no","yes",null,"Kundenauftragsnummer mit Position","K","Formatierung:"]
[{"$nulls":8},"2 Stellen Betriebsnummer (mit führenden Nullen)"]
[{"$nulls":8},"9 Stellen KA-Auftrags-Nr. (mit f. Nullen)"]
[{"$nulls":8},"3 Stellen KA-Positions-Nr. (mit f. Nullen)"]
["erznr","varchar",20,"no","yes",null,"Artikelnummer","M"]
["aknr_lang","varchar",512,"no","yes",null,"Varianten + Variantentexte","K","mit '\\n' als Zeilentrenner, 6 Stellen Variante + 30 Stellen Variantenbezeichnung"]
["ser_nr","varchar",10,"no","yes",null,"Seriennummer aus Fertigungsauftag","K"]
["kd_nr_f","integer4",null,"no","yes",null,"Kundennummer Fertigungsauftrag","M"]
["kd_bez1_f","varchar",64,"no","yes",null,"Kundenbezeichnung 1 Fertigungsauftrag","M"]
["kd_bez2_f","varchar",64,"no","yes",null,"Kundenbezeichnung 2 Fertigungsauftrag","K"]
["kd_bez3_f","varchar",64,"no","yes",null,"Kundenbezeichnung 3 Fertigungsauftrag","K"]
["kd_ort_f","varchar",64,"no","yes",null,"Ort des Kunden aus Fertigungsauftrag","K"]
["kd_nr_k","integer4",null,"no","yes",null,"Kundennummer zugehöriger Kundenauftrag","M"]
["kd_bez1_k","varchar",64,"no","yes",null,"Kundenbezeichnung 1 zug. Kundenauftrag","M"]
["kd_bez2_k","varchar",64,"no","yes",null,"Kundenbezeichnung 2 zug Kundenauftrag","K"]
["kd_bez3_k","varchar",64,"no","yes",null,"Kundenbezeichnung 3 zug. Kundenauftrag","K"]
["kd_ort_k","varchar",64,"no","yes",null,"Ort des Kunden aus Kundenauftrag","K"]
[]
[]
["W. Köpplinger, 23.07.2015"]