{"text_format":"1","workbook":"xlsx","n_sheets":22,"sheets":["erfasste Teile","Orders","Attributes","Order Lines","Order Line Attributes","Products","Product Options","Organizations","Addresses","Identity","Form_Material","Form_ObfArt","Form_Dicke","Form_Struktur","Attachments","Deposits","Order Styles","Order Style Options","Order Line Attachments","GlobalOptions","Order Line Price Rules","Price Rules"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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"}

{"sheet":"erfasste Teile","index":0,"n_rows":1,"n_cols":15,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Teile Bezeichnung","Anzahl (Stk.)","Material","Oberflächen Art","Dicke","Struktur","Länge","Breite","Farbe oben","Farbe unten","Kante1","Kante 2","Kante 3","Kante 4","Schablonen Teil"]

{"sheet":"Orders","index":1,"n_rows":2,"n_cols":42,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["OrderNo","QuoteNo","Description","OrderDate","CustomerOrderDate","RequestDate","RequestDateIsWeek","OrderTypeCode","PONumber","PaymentTermsCode","CreatedBy","CreatedOn","PlantCode","CurrencyCode","TaxCode","Info1","Info2","Info3","PriceDate","ProjectCode","ProjectInfo1","ProjectInfo2","ProjectInfo3","ProjectInfo4","ProjectInfo5","SchedShipDate","SchedShipDateIsWeek","NetPrice","ShipmentModeCode","FreightTermsCode","CarrierCode","ShipingZoneCode","ShipInstructions","RequireDeposit","DepositPercent","ExchangeRate","NetPriceBase","SystemCode","OrderNoForeign","BuyingGroupCode","MarketCode","BusinessTypeCode"]
[1,null,"Vorlage KA-Import 07.06.2023","2023-06-01",null,"2023-06-01",null,"4STD",null,"30T",null,null,"Loosli1","CHF","USt77",null,null,null,"2023-06-01",null,null,null,null,null,null,"2023-06-01",null,0,null,null,null,null,null,0,null,1,0,null,null,"PRIVATKUPRPRIVA1","Loosli"]

{"sheet":"Attributes","index":2,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["OrderNo_link","AttributeCode","Value","ValueExt","AttributeCategoryCode"]
[1,"Schnelllaeufer",1,null,"04-Tour"]
[1,"Verkäufer","D.Jenzer",null,"02-Pers./Niederl./Term."]
[1,"Niederlassung","Wyssachen",null,"02-Pers./Niederl./Term."]
[1,"Test?",1,null,"02-Pers./Niederl./Term."]

{"sheet":"Order Lines","index":3,"n_rows":1,"n_cols":12,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["OrderNo_link","LineNo","Description","SalesOrderLineTypeCode","LineNoParent","LineNoForeign","LineNoForeignParent","SystemCode","DisplaySequence","OutlineNo","OrderIDForeign","IDForeign"]

{"sheet":"Order Line Attributes","index":4,"n_rows":1,"n_cols":6,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["OrderNo_link","LineNo_link","AttributeCode","Value","AttributeCategoryCode","ValueExt"]

{"sheet":"Products","index":5,"n_rows":1,"n_cols":18,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["OrderNo_link","LineNo_link","CatalogCode","CatalogVersionNo","ProductCode","ProductVersionNo","Qty","ProductUOMCode","ProductUOMCodeISO","NetPrice","NetPriceBase","StyleInstanceID","ConfiguredDescription","DueDate","Manufacturer","IdentityMethodCode","IdentityNumber","IdentityDescription"]

{"sheet":"Product Options","index":6,"n_rows":1,"n_cols":11,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["OrderNo_link","LineNo_link","ProductCode_link","FeatureCode","OptionCode","ValueKeyed","EngValue","OptionOriginID","Origin","IsEditable","StateID"]

{"sheet":"Organizations","index":7,"n_rows":2,"n_cols":14,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["OrderNo_link","OrganizationCode","OrganizationID","Type","Name","NameExt","Website","Info1","Info2","Info3","CodeExt","Effective","Inactive","AccountNo"]
[1,"VORLAGEKVOVORLA1"]

{"sheet":"Addresses","index":8,"n_rows":4,"n_cols":33,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["OrderNo_link","OrganizationCode_link","Type","LocationCode","LocationName","LocationNameExt","Address1","Address2","Address3","City","State","Zip","Country","Phone","PhoneExtension","Fax","FaxExtension","Notes","Info1","Info2","Info3","IsDefault","Effective","Inactive","ShipmentModeCode","ShipInstructions","CarrierCode","Language","FreightTermsCode","ShippingZoneCode","TaxCode","StatPercent","GLN"]
[1,"VORLAGEKVOVORLA1","MAIL","AdrNr00012946",null,null,"_______________",null,null,"______________",null,0,"CH",null,null,null,null,null,null,null,null,1,"1900-01-01","2079-01-01",null,null,null,"Deutsch",null,null,"USt80"]
[1,"VORLAGEKVOVORLA1","SHIP","AdrNr00012946",null,null,"_______________",null,null,"______________",null,0,"CH",null,null,null,null,null,null,null,null,1,"1900-01-01","2079-01-01",null,null,null,"Deutsch",null,null,"USt80"]
[1,"VORLAGEKVOVORLA1","BILL","AdrNr00012946",null,null,"_______________",null,null,"______________",null,0,"CH",null,null,null,null,null,null,null,null,1,"1900-01-01","2079-01-01",null,null,null,"Deutsch",null,null,"USt80"]

{"sheet":"Identity","index":9,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["DocumentType","Version"]
["SalesOrder","10.6.0"]

{"sheet":"Form_Material","index":10,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["SPA"]
["MDF"]

{"sheet":"Form_ObfArt","index":11,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["beschichtet"]
["belegt"]

{"sheet":"Form_Dicke","index":12,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[16]
[19]
[19.600000000000001]
[22]
[22.6]

{"sheet":"Form_Struktur","index":13,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["-"]
["V"]
["H"]

{"sheet":"Attachments","index":14,"n_rows":1,"n_cols":8,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["OrderNo_link","AttachmentTypeCode","AttachmentFormatCode","Identifier","FileName","CreatedBy","CreatedOn","Attachment"]

{"sheet":"Deposits","index":15,"n_rows":1,"n_cols":10,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["OrderNo_link","Instance","DepositTypeCode","Amount","Authorization","CardNumber","CheckBookID","ReceivedDate","ReceivedBy","Comment"]

{"sheet":"Order Styles","index":16,"n_rows":1,"n_cols":9,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["OrderNo_link","StyleInstanceID","CatalogCode","CatalogVersionNo","StyleCode","StyleVersionNo","Description","Sequence","StyleInstanceIDForeign"]

{"sheet":"Order Style Options","index":17,"n_rows":1,"n_cols":10,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["OrderNo_link","StyleInstanceID_link","FeatureCode","OptionCode","ValueKeyed","EngValue","OptionOriginID","Origin","StateID","IsEditable"]

{"sheet":"Order Line Attachments","index":18,"n_rows":1,"n_cols":18,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["OrderNo_link","LineNo_link","AttachmentTypeCode","AttachmentFormatCode","Identifier","FileName","CreatedBy","CreatedOn","Attachment","Description","User1","User2","User3","User4","User5","User6","User7","User8"]

{"sheet":"GlobalOptions","index":19,"n_rows":1,"n_cols":12,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["OrderNo_link","LineNo_link","CatalogCode","CatalogVersionNo","FeatureCode","OptionCode","ValueKeyed","EngValue","OptionOriginID","Origin","StateID","IsEditable"]

{"sheet":"Order Line Price Rules","index":20,"n_rows":1,"n_cols":17,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["OrderNo_link","LineNo_link","PriceRuleCode","Value","RunningTotal","Sequence","Calculation","BaseValue","CalculationBase","PriceListCode","PriceRuleValueSetID","ValueSetValueInstanceID","Category","GLClass","DebitAccount","CreditAccount","TaxLocationCode"]

{"sheet":"Price Rules","index":21,"n_rows":1,"n_cols":16,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["OrderNo_link","PriceRuleCode","Value","RunningTotal","Sequence","Calculation","BaseValue","CalculationBase","PriceListCode","PriceRuleValueSetID","ValueSetValueInstanceID","Category","GLClass","DebitAccount","CreditAccount","TaxLocationCode"]