{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["xbde_arbeitsgang"],"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_arbeitsgang","index":0,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Datenbank-Schnittstelle cimERP -> Externes BDE"]
[]
["xbde_arbeitsgang","Arbeitgangdaten OP Zeit"]
[]
["Column Name","Type","Length","Nulls","Default","Key","Beschreibung","Muss/Kann","Format/Bemerkungen"]
["Ifdnr","integer4",null,"no","yes",1,"Laufende Nummer","M","eindeutiger Zählbegriff"]
["modus","char",1,"no","yes",null,"Satzmodus (N=neu, C=geändert, S=gelöscht, E=Ende)","M"]
["aknr","varchar",20,"no","yes",null,"Kombinierte F-Auftragsnummer für externes BDE","M","Formatierung mHub-MES:","Formatierung IOS-BDE:","Formatierung andere BDE-Systeme:"]
[{"$nulls":8},"2 Stellen Betriebsnummer (mit führenden Nullen)","2 Stellen Betriebsnummer (mit führenden Nullen)","2 Stellen Betriebsnummer (mit führenden Nullen)"]
[{"$nulls":8},"9 Stellen F-Auftrags-Nr. (mit f. Nullen)","9 Stellen F-Auftrags-Nr. (mit f. Nullen)","8 Stellen F-Auftrags-Nr."]
[{"$nulls":8},"6 Stellen F-Positions-Nr. 1 (mit f. Nullen)","6 Stellen F-Positions-Nr. 1 (mit f. Nullen)","3 Stellen F-Positions-Nr. 1"]
[{"$nulls":8},"3 Stellen F-Pos-Nr. 2 (mit f. Nullen)","3 Stellen F-Pos-Nr. 2 (mit f. Nullen)","2 Stellen F-Pos-Nr. 2"]
["agnr","varchar",4,"no","yes",null,"Arbeitsgangnummer","M","max. 4 stellig, mit führenden Nullen"]
["asnr","varchar",2,"no","yes",null,"Splitt-Nr. Arbeitsgang","M"]
["ag ruecknr","varchar",15,"no","yes",null,"BDE-Lohnscheinnummer","M"]
["agbez","varchar",78,"no","yes",null,"Arbeitsgangbezeichnung (1 Zeile)","K","1. Zeile aus AG-Positionstext, max 50 Stellen"]
["aplnr","varchar",12,"no","yes",null,"Arbeitsplatznummer","K","insges. max 7 Stellen, davon die ersten 2 Stellen = Betriebsnummer"]
["prio","integer4",null,"no","yes",null,"Priorität","K"]
["datw min str","varchar",14,"no","yes",null,"Anfangstermin Arbeitsgang","M","yyyymmddhhmiss"]
["datw max str","varchar",14,"no","yes",null,"Endtermin Arbeitsgang","M","yyyymmddhhmiss"]
["smenge_ag_min","float8",null,"yes","null",null,"Sollmenge - minimal","K","über % lt. Arbeitsplatz-Unterlieferung"]
["smenge_ag","float8",null,"no","yes",null,"Sollmenge Arbeitsgang","M"]
["smenge_ag_max","float8",null,"yes","null",null,"Sollmenge - maximal","K","über % lt. Arbeitsplatz-Überlieferung"]
["wmenge_ag","float8",null,"no","yes",null,"Weitergabemenge","K","zur Zeit = Sollmenge"]
["me","varchar",6,"no","yes",null,"Mengeneinheit (STK, kg, …)","M","des Artikels als Text"]
["trsoll","float8",null,"no","yes",null,"Rüstzeit SOLL","K"]
["tr_einh","varchar",3,"no","yes",null,"Zeiteinheit RÜSTEN","M","Stunde oder Minute (\"Std\", \"Min\")"]
["tesoll","float8",null,"no","yes",null,"Bearbeitungszeit SOLL","M","pro Stück"]
["te_einh","varchar",3,"no","yes",null,"Zeiteinheit BEARBEITEN","M","Stunde oder Minute (\"Std\", \"Min\")"]
["mengesoll","float8",null,"no","yes",null,"Sollstückzahl pro Zeiteinheit tesoll","M","(ab Version vom 24.07.2018)"]
["gruppierung","varchar",30,"no","yes",null,"AG-Gruppierung; Teilegruppe-1 aus Artikelstamm","K"]
["agnr_lang","varchar",512,"no","yes",null,"Arbeitsgangtext lang","K","alle Zeilen AG-Text"]
["anz_nester","integer4",null,"no","yes",null,"Anzahl Nester / Kavität","K","aus Werkzeugkombinationen ermittelt"]
["tepuffer","float8",null,"no","yes",null,"Pufferzeit","M"]
["tp_einh","varchar",3,"no","yes",null,"Zeiteinheit PUFFERZEIT","M","Stunde oder Minute (\"Std\", \"Min\")"]
["splitt_nr","integer4",null,"no","yes",null,"Splitt-Nr. Arbeitsgang","M","(Optional zu asnr)"]
["file_info","varchar",256,"no","yes",null,"Übergabe von Dateilink möglich","K","indiv. Verwendungsmöglichkeit"]
[]
[]
["W. Köpplinger, 24.07.2018"]