{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Sheet1","تسجيل البيانات","Compte magasin","SearchData"],"not_rendered":{"charts":0,"images":0,"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":"Sheet1","index":0,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["كود","اسم الصنف","اسم المخزن","وحدة","سعر","كمية المخزون","صلاحية المنتج"]
[100,"صنف1","مخزن رئيسى",6,30,5,"2024-01-01"]
[100,"صنف1","مخزن فرعى",12,30,38,"2024-01-01"]
[101,"صنف2","مخزن رئيسى",6,30,37,"2024-01-01"]
[102,"صنف3","مخزن فرعى",12,30,60,"2024-01-01"]
[103,"صنف4","مخزن رئيسى",6,30,58,"2024-01-01"]
[104,"صنف5","مخزن رئيسى",12,30,50,"2024-01-01"]
[105,"صنف6","مخزن رئيسى",6,30,90,"2024-01-01"]
[106,"صنف7","مخزن فرعى",12,30,80,"2024-01-01"]
[101,"صنف2","مخزن فرعى",6,30,20,"2024-01-01"]
[103,"صنف4","مخزن فرعى",12,30,62,"2024-01-01"]
[100,"صنف1","مخزن فرعى",12,30,77,"2024-05-01"]
[100,"صنف1","مخزن رئيسى",12,30,82,"2024-01-05"]
[100,"صنف1","مخزن فرعى",12,30,87,"2024-01-05"]
[100,"صنف1","مخزن رئيسى",12,30,93,"2024-05-01"]
[100,"صنف1","مخزن رئيسى",12,30,10,"2024-12-29"]
[103,"صنف4","مخزن رئيسى",6,30,61,"2024-01-05"]
[103,"صنف4","مخزن رئيسى",6,30,9,"2024-12-01"]
[103,"صنف4","مخزن رئيسى",6,30,5,"2024-12-01"]
[100,"صنف1","مخزن رئيسى",6,30,10,"2024-12-01"]
[100,"صنف1","مخزن رئيسى",6,30,5,"2024-12-01"]
[101,"صنف2","مخزن رئيسى",6,30,5,"2024-12-01"]

{"sheet":"تسجيل البيانات","index":1,"n_rows":12,"n_cols":16,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["مسلسل","التاريخ","نوع الحركة","كود الصنف","اسم الصنف","من مخزن","الى مخزن","وحدة","السعر","الكمية","القيمة","خصم %","خصم نقدى","صافى القيمة","تاريخ صلاحية المنتج","تاريخ التسجيل"]
["1","11/12/2024","تحويل",100,"صنف1","مخزن رئيسى","مخزن فرعى",6,30,2,60,null,null,null,"2024-01-05","الأربعاء 12/11/2024 11:11:24 PM"]
["2","11/12/2024","تحويل",101,"صنف2","مخزن رئيسى","مخزن فرعى",6,30,2,60,null,null,null,"2024-01-01","الأربعاء 12/11/2024 11:17:30 PM"]
["3","11/12/2024","تحويل",103,"صنف4","مخزن رئيسى","مخزن فرعى",6,30,2,60,null,null,null,"2024-01-01","الأربعاء 12/11/2024 11:26:50 PM"]
["4","12/12/2024","تحويل",100,"صنف1","مخزن رئيسى","مخزن فرعى",12,30,5,150,null,null,null,"2024-01-01","الخميس 12/12/2024 02:34:10 PM"]
["5","12/12/2024","تحويل",100,"صنف1","مخزن رئيسى","مخزن فرعى",12,30,4,60,null,null,null,"2024-01-01","الخميس 12/12/2024 02:41:46 PM"]
["6","18/12/2024","شراء",100,"صنف1","مخزن رئيسى","مورد الشركة",6,30,10,300,5,8,277,"2024-01-05","الأربعاء 12/18/2024 09:23:51 AM"]
["6","18/12/2024","شراء",100,"صنف1","مخزن رئيسى","مورد الشركة",6,30,10,300,5,8,277,"2024-05-01","الأربعاء 12/18/2024 09:24:18 AM"]
["7","18/12/2024","شراء",103,"صنف4","مخزن رئيسى","مورد الشركة",6,30,5,150,null,null,150,"2024-01-12","الأربعاء 12/18/2024 09:28:44 AM"]
["8","18/12/2024","شراء",100,"صنف1","مخزن رئيسى","مورد الشركة",6,30,10,300,null,null,300,"2024-01-12","الأربعاء 12/18/2024 10:08:38 AM"]
["9","18/12/2024","شراء",100,"صنف1","مخزن رئيسى","مورد الشركة",6,30,5,150,null,null,150,"2024-01-12","الأربعاء 12/18/2024 10:26:39 AM"]
["10","18/12/2024","شراء",101,"صنف2","مخزن رئيسى","مورد الشركة",6,30,5,150,null,null,150,"2024-01-12","الأربعاء 12/18/2024 10:28:26 AM"]

{"sheet":"Compte magasin","index":2,"n_rows":9,"n_cols":23,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["نوع الحركة","اسم الخزن",null,null,null,null,null,null,null,null,null,null,null,"كود الصنف","اسم الصنف","وحدة","السعر",null,null,"اسم المورد",null,"اسم المخزن","اسم العميل"]
["تحويلات","مخزن رئيسى",null,null,null,null,null,null,null,null,null,null,null,100,"صنف1",12,30,null,null,"مورد الشركة"]
["شراء","مخزن فرعى",null,null,null,null,null,null,null,null,null,null,null,101,"صنف2",6,30,null,null,"مورد 1"]
["بيع","مخزن 2",null,null,null,null,null,null,null,null,null,null,null,102,"صنف3",12,30,null,null,"مورد 2"]
["مرتجع بيع","مخزن 3",null,null,null,null,null,null,null,null,null,null,null,103,"صنف4",6,30,null,null,"مورد 3"]
["مرتجع شراء","مخزن 4",null,null,null,null,null,null,null,null,null,null,null,104,"صنف5",12,30,null,null,"مورد 4"]
["تالف","مخزن 5",null,null,null,null,null,null,null,null,null,null,null,105,"صنف6",6,30,null,null,"مورد 5"]
[null,"مخزن 6",null,null,null,null,null,null,null,null,null,null,null,106,"صنف7",12,30,null,null,"مورد 6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"مورد 1"]

{"sheet":"SearchData","index":3,"n_rows":3,"n_cols":8,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["مسلسل","التاريخ","نوع الحركة","اسم الصنف","من مخزن","الى مخزن","الكمية","تاريخ التسجيل"]
[1,"2024-08-12","تحويل","صنف4","مخزن رئيسى","مخزن فرعى",2,"الأحد 12/08/2024 12:20:59 AM"]
[2,"2024-08-12","تحويل","صنف2","مخزن رئيسى","مخزن فرعى",1,"الأحد 12/08/2024 12:26:14 AM"]