{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Sheet1","index":0,"n_rows":38,"n_cols":10,"rows_kept":38,"merged":[[0,0,0,9]],"flags":["formulas_cached_only"]}
["genieERP 單據決策樹圖"]
[null,null,"理論數量","實際數量","成本","帳款","業績","發票","傳票","說明"]
[1,"進貨單","＋","＋","●","●",null,"●","●"]
[2,"進貨退出單","—","—","●","●",null,"●","●"]
[3,"調整單","＋/—","＋/—","●",{"$nulls":3},"●"]
[4,"調撥單","＋/—","撥入＋/撥出—"]
[5,"出貨單","—","—",null,"●","●","●","●"]
[6,"出貨退回單","＋","＋",null,"●","●","●","●"]
[7,"借出單",null,"—"]
[8,"借出歸還單",null,"＋"]
[9,"借入單",null,"＋"]
[10,"借入還回單",null,"—"]
[11,"進貨入庫單","＋","＋","●",{"$nulls":3},"●","採購轉入/驗收轉入/進口轉入會有成本, 但非轉單者要自行輸入"]
[12,"銷貨出庫單","—","—",null,null,"●(報表可選)",null,"●"]
[13,"非存貨出貨單",{"$nulls":3},"●","●","●","●","一般如維護合約/維修費等出貨(表身產品不扣數量)"]
[14,"發票立帳進貨單","發票庫存","發票庫存",null,"●",null,"●","●","進貨發票"]
[15,"發票立帳銷貨單","發票庫存","發票庫存",null,"●",null,"●","●","銷項發票"]
[16,"發票立帳調整單","發票庫存","發票庫存",{"$nulls":5},"純粹為了發票庫存"]
[17,"出口 Invoice",{"$nulls":3},"●","●(出口 Only)","●(特殊需求)","●","透過轉 [銷貨出庫單], 影響庫存量 "]
[18,"出口押匯",{"$nulls":7},"押匯記錄, 類似應收票據, 不影響任何數字"]
[19,"出口退貨作業",{"$nulls":3},"●","●(出口 Only)",null,"●"]
[20,"Sample Invoice",{"$nulls":7},"純粹的文件製作, 不影響任何數字(包括帳款)"]
[21,"預付購料作業",{"$nulls":7},"類似 L/C 開狀作業, 仍要到帳款系統執行預付作業"]
[22,"裝貨通知 S/I",{"$nulls":7},"只是到貨通知, 不影響任何數字"]
[23,"進口報關/贖單",{"$nulls":7},"贖單記錄, 類似應付票據, 不影響本表數字"]
[24,"銀行還款作業",{"$nulls":7},"付款贖單已處理銀行還款, 不需此作業(但要改NOE)"]
[25,"客戶/廠商索賠",{"$nulls":3},"●",null,null,"●"]
[26,"收入/費用單",{"$nulls":3},"●",null,"●","●"]
[27,"存/提款/轉帳",{"$nulls":6},"●"]
[28,"應收付票據",{"$nulls":6},"●"]
[29,"批次收/付款單",{"$nulls":3},"●",null,null,"●"]
[30,"委外加工帳單",{"$nulls":3},"●",null,"●","●","類似銷貨發票單"]
[31,"領送(退)料單","廠倉＋/料倉—","廠倉＋/料倉—",{"$nulls":4},"●"]
[32,"入庫/委外入庫","母件＋/子件—","母件＋/子件—",{"$nulls":4},"●","子件扣料部份, 要配合扣料方式, 表單會有含不含表身2種"]
[33,"過站憑單","線邊倉子件—","線邊倉子件—",null,"●",null,null,"●","Route 的移轉用料記錄, 若委外則會產生應付"]
[34,"維修單",{"$nulls":3},"●",null,"●","●","表頭記錄維修金額, 表身是耗用(調整)料 (與帳款無關)"]
[35,"原廠送修單",{"$nulls":3},"●",null,"●","●"]
[36,"維護合約",{"$nulls":7},"純粹的記錄合約內容, 應配合 [非存貨出貨單]"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}