{"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":71,"n_cols":11,"rows_kept":71,"merged":[[0,0,0,10]],"flags":["formulas_cached_only"]}
["genieERP 單據決策樹圖"]
[null,null,"Flag","理論數量","實際數量","成本","帳款","業績","發票","傳票","說明"]
[null,"OPO"]
[1,"報價單",21]
[2,"客戶訂單",22]
[3,"請購單",24]
[4,"採購單",23]
[5,"採購驗收單",25]
[6,"採購建議清單",26]
[null,"INV"]
[7,"進貨單",31,"＋","＋","●","●",null,"●","●"]
[8,"進貨退出單",32,"—","—","●","●",null,"●","●"]
[9,"調整單",33,"＋/—","＋/—","●",{"$nulls":3},"●"]
[10,"調撥單",34,"＋/—","撥入＋/撥出—"]
[11,"出貨單",35,"—","—",null,"●","●","●","●"]
[12,"出貨退回單",36,"＋","＋",null,"●","●","●","●"]
[13,"借出單",41,null,"—",{"$nulls":5},"與帳款無關, 僅進銷存內部使用代號"]
[14,"借出歸還單",42,null,"＋"]
[15,"借入單",43,null,"＋"]
[16,"借入還回單",44,null,"—"]
[17,"進貨入庫單",91,"＋","＋","●",{"$nulls":3},"●","採購轉入/驗收轉入/進口轉入會有成本, 但非轉單者要自行輸入"]
[18,"銷貨出庫單",95,"—","—",null,null,"●(報表可選)",null,"●"]
[19,"非存貨出貨單",96,{"$nulls":3},"●","●","●","●","一般如維護合約/維修費等出貨(表身產品不扣數量)"]
[20,"發票立帳進貨單",97,"發票庫存","發票庫存",null,"●",null,"●","●","進貨發票"]
[21,"發票立帳銷貨單",98,"發票庫存","發票庫存",null,"●",null,"●","●","銷項發票"]
[22,"發票立帳調整單",99,"發票庫存","發票庫存",{"$nulls":5},"純粹為了發票庫存"]
[null,"ETS"]
[23,"出口 Invoice",65,{"$nulls":3},"●","●(出口 Only)","●(特殊需求)","●","透過轉 [銷貨出庫單], 影響庫存量 "]
[24,"出口押匯",67,{"$nulls":7},"押匯記錄, 類似應收票據, 不影響任何數字"]
[25,"出口退貨作業",66,{"$nulls":3},"●","●(出口 Only)",null,"●"]
[26,"Sample Invoice",68,{"$nulls":7},"純粹的文件製作, 不影響任何數字(包括帳款)"]
[null,"ITS"]
[27,"預付購料作業",71,{"$nulls":7},"類似 L/C 開狀作業, 仍要到帳款系統執行預付作業"]
[28,"裝貨通知 S/I",72,{"$nulls":7},"只是到貨通知, 不影響任何數字"]
[29,"進口報關/贖單",73,{"$nulls":7},"贖單記錄, 類似應付票據, 不影響本表數字"]
[30,"銀行還款作業",74,{"$nulls":7},"付款贖單已處理銀行還款, 不需此作業(但要改NOE)"]
[31,"客戶/廠商索賠",{"$nulls":4},"●",null,null,"●"]
[null,"APR"]
[32,"收入單",41,{"$nulls":3},"●",null,"●","●"]
[33,"費用單",42]
[34,"批次收款單",43,{"$nulls":3},"●",null,null,"●"]
[35,"批次付款單",44]
[null,"ACT&NOE"]
[36,"傳票維護",0]
[37,"存款",1,{"$nulls":6},"●"]
[38,"提款",2,{"$nulls":6},"●"]
[39,"轉帳",3,{"$nulls":6},"●"]
[40,"應收票據",4,{"$nulls":6},"●"]
[41,"應付票據",5,{"$nulls":6},"●"]
[null,"MMS"]
[42,"委外加工帳單",88,{"$nulls":3},"●",null,"●","●","類似銷貨發票單"]
[43,"領料單",81,"廠倉＋/料倉—","廠倉＋/料倉—",{"$nulls":4},"●"]
[44,"退料單",82,"廠倉—/料倉＋","廠倉—/料倉＋",{"$nulls":4},"●"]
[45,"委外送料單",83,"廠倉＋/料倉—","廠倉＋/料倉—",{"$nulls":4},"●"]
[46,"委外退料單",84,"廠倉—/料倉＋","廠倉—/料倉＋",{"$nulls":4},"●"]
[47,"廠內入庫",85,"母件＋/子件—","母件＋/子件—",{"$nulls":4},"●","子件扣料部份, 要配合扣料方式, 表單會有含不含表身2種"]
[48,"委外入庫",86,"母件＋/子件—","母件＋/子件—",{"$nulls":4},"●","子件扣料部份, 要配合扣料方式, 表單會有含不含表身2種"]
[49,"過站憑單",87,"線邊倉子件—","線邊倉子件—",null,"●",null,null,"●","Route 的移轉用料記錄, 若委外則會產生應付"]
[null,"CRM"]
[50,"維修單",51,{"$nulls":3},"●",null,"●","●","表頭記錄維修金額, 表身是耗用(調整)料 (與帳款無關)"]
[51,"原廠送修單",52,{"$nulls":3},"●",null,"●","●"]
[52,"維護合約",53,{"$nulls":7},"純粹的記錄合約內容, 應配合 [非存貨出貨單]"]
[]
[null,"單別說明(通常是單據間的關連, 須要一個全系統單別的代號)"]
[null,"OPO",null,"21-29"]
[null,"INV",null,"31-39","40, 90以上"]
[null,"APR",null,"41-49"]
[null,"EIP/CRM/ESS",null,"51-59"]
[null,"ETS",null,"61-69"]
[null,"ITS",null,"71-79"]
[null,"MMS",null,"81-89"]

{"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"]}