{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Orders","常用產品","常用客戶主檔","訂單編碼","設定","toyoushop","匯入作業說明"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":1,"defined_names":3,"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":"Orders","index":0,"n_rows":3,"n_cols":39,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["BillingNo","UTCInvoiceDateTime","ProductID","ProductName","Quantity","UnitPrice","BuyerEmailAddress","BuyerName","BuyerInvoiceTitle","BuyerID","BuyerTelNo","SalesAmount","TaxType","TaxAmount","TotalAmount","MainRemark","CarrierId","NPOBAN","InvoiceFor","BuyerAddress","DetailID","SubTotal","SalesID","DeptID","CarrierType","RandomNumber","RelateNumber","Remark","CustomsClearanceMark","ItemTaxDiff","CheckNumber","BondedArea","Unit","BuyerCustomerNumber","Currency","ExchangeRate","OriginalCurrencyAmount","CompanyID","UseFor"]
["帳單或訂單號\n不可重複","發票日期\n系統產生","20字內(選填)","銷售產品品名","銷售數量","二聯含稅，三聯未稅","(選填)通知客戶用","二聯選填","三聯必填","B類必填/無統編法人可填00000000","選填","B類銷售額為單身小計總合(未稅)，C為含稅。","1:應稅 2:零稅率 3:免稅","二聯-0\n三聯- 5%\n","銷售總額+總稅額之和","備註 50字內(選填)作廢填寫作廢原因、信用卡號","1.手機條碼(選填)","C類捐贈時使用(選填)","二聯-C\n三聯-B","選填","若無\n系統可補","小計=數量*單價(銷售或折讓額)","業務姓名(選填)","(選填)","(選填)","(選填)","(選填)","(選填)","1：非經海關2：經海關出口(零稅率必填)","產品單價如非預設時請註記為Y。","系統上傳格式轉換用"," 1:保稅區2:遠洋漁業3:自由貿易港區;","單位","選填","幣別","匯率","原幣金額","匯入\n需填","選填"]
["訂單/Seq No.","訂單日期","產品代號","產品名稱","購買數量","產品單價","客戶電子郵件","買受人名稱","買受人發票抬頭","買受人統編","客戶行動電話","訂單總額","課稅類別","應稅稅額","發票總額","主備註","歸戶條碼","捐贈碼","傳輸類型","發票地址","單身項次","產品小計","業務姓名","部門","載具類型","隨機碼","關聯號碼","單身備註","通關註記","系統註記","檢查碼","零稅率註記","單位","客戶編號","幣別","匯率","原幣金額","統編","發票組別"]

{"sheet":"常用產品","index":1,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["可以先將常用品號品名先在此建檔選用\n(注意:單價不可為空白，無品號系統重整會自編)"]
["產品代號 20碼內","產品名稱 (盡可能不重複)","單價未稅","備註"]

{"sheet":"常用客戶主檔","index":2,"n_rows":2,"n_cols":11,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["你可將常用客戶先建檔 待選用"]
["客戶編碼 / E-mail","買受人名稱","買受人發票抬頭","買受人統編","客戶行動電話","歸戶碼","愛心碼","發票類型","傳輸方式","發票地址","預設備住"]

{"sheet":"訂單編碼","index":3,"n_rows":28,"n_cols":27,"rows_kept":28,"cut":false,"hidden":false,"merged":[[4,0,4,1],[4,4,4,5],[4,2,4,3],[0,0,0,2],[5,2,5,8],[5,0,5,1],[0,4,0,5],[0,6,0,8],[3,0,3,1],[3,3,3,8],[6,0,6,1],[15,0,15,8],[16,0,16,8],[14,0,14,8],[13,0,13,8],[7,0,12,8]]}
["可自由選填1-3欄英數字母",null,null,"選擇一種格式","FTP通行碼:",null,null,null,null,null,"","2023-06-12T14:08:38",{"$f":"IF($K$1=\"\",1,MID($K$1,1,1)+MID($K$1,2,1))","v":1},{"$f":"IF($K$1=\"\",1,MID($K$1,3,1)+MID($K$1,4,1))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,"B"]
["編碼一","編碼二","編碼三","日期編碼四","序號碼數","序號","編碼結果","總共碼數","驗證",null,"No","2023-06-12T14:09:32",{"$f":"VLOOKUP(M1,$M$3:$N$28,2)","v":"B"},{"$f":"VLOOKUP(N1,$M$3:$N$28,2)","v":"B"},null,null,"允許統編",null,null,null,null,null,null,null,null,null,"C"]
["E","B",null,"2民國yyymmdd","4碼",1,{"$f":"A3&B3&C3&VLOOKUP(D3,$K$3:$M$7,2)&TEXT(F3,\"0000\")","v":"BB11206120001"},{"$f":"LEN(G3)","v":13},{"$f":"IF(H3>16,\"超過長度\",\"OK\")","v":"OK"},null,"1民國yyymm",{"$f":"TEXT(YEAR(NOW())-1911,\"000\")&TEXT(MONTH(NOW()),\"00\")","v":"11206"},0,"A","2碼",{"$f":"TEXT(F3,\"00\")","v":"01"},89430377]
["設定指定日期取號",null,null,"注意:要使用指定日期取號須先申請設定好配號切本相關功能方可使用。",null,null,null,null,null,null,"2民國yyymmdd",{"$f":"TEXT(YEAR(NOW())-1911,\"000\")&TEXT(MONTH(NOW()),\"00\")&TEXT(DAY(NOW()),\"00\")","v":"1120612"},1,"B","3碼",{"$f":"TEXT(F3,\"000\")","v":"001"},11916803,null,null,null,null,null,null,null,null,null,"單價含稅"]
["預設自收mail",null,null,null,"預設部門",null,null,"品號轉入否","N",null,"3簡年yy",{"$f":"TEXT(YEAR(NOW())-2000,\"00\")","v":"23"},2,"C","4碼",{"$f":"TEXT(F3,\"0000\")","v":"0001"},null,null,null,null,null,null,null,null,null,null,"單價未稅"]
["預設輸出路徑",null,null,null,null,null,null,null,null,null,"4簡年月yymm",{"$f":"TEXT(YEAR(NOW())-2000,\"00\")&TEXT(MONTH(NOW()),\"00\")","v":"2306"},3,"D","5碼",{"$f":"TEXT(F3,\"00000\")","v":"00001"}]
["小計小數位數",null,2,null,null,null,null,null,null,null,"5年月yyyymm",{"$f":"TEXT(YEAR(NOW()),\"0000\")&TEXT(MONTH(NOW()),\"00\")","v":"202306"},4,"E"]
["你可以設定你公司的訂單編碼供新訂單時取號用。\n編碼限制總長度為16碼以內。你可以自訂自己公司的編碼原則。\n部分欄位可以下拉選擇，編碼結果是目前可以用的號碼",null,null,null,null,null,null,null,null,null,"6完整yyyymmdd",{"$f":"TEXT(YEAR(NOW()),\"0000\")&TEXT(MONTH(NOW()),\"00\")&TEXT(DAY(NOW()),\"00\")","v":"20230612"},5,"F"]
[null,null,null,null,null,null,null,null,null,null,null,null,6,"G",null,null,"B-三聯"]
[null,null,null,null,null,null,null,null,null,null,null,null,7,"H",null,null,"C-二聯"]
[null,null,null,null,null,null,null,null,null,null,null,null,8,"X"]
[null,null,null,null,null,null,null,null,null,null,"N","Y",9,"J"]
[null,null,null,null,null,null,null,null,null,null,null,"N",10,"K"]
[null,null,null,null,null,null,null,null,null,null,null,null,11,"L"]
[null,null,null,null,null,null,null,null,null,null,0,null,12,"M"]
[null,null,null,null,null,null,null,null,null,null,2,null,13,"N"]
[null,null,null,null,null,null,null,null,null,null,4,null,14,"Y"]
["dc:e4:48:3d:bc:70:6b:b6:98:b2:83:36:04:c3:d3:4a",null,null,null,null,null,null,null,null,null,7,null,15,"P"]
["21:36:76:9c:00:a0:01:d9:12:8d:a3:ed:3b:bd:ad:97",null,null,null,null,null,null,null,null,null,null,null,16,"Q"]
["dc:e4:48:3d:bc:70:6b:b6:98:b2:83:36:04:c3:d3:4a",null,null,null,null,null,null,null,null,null,"TWD",null,17,"R"]
[null,null,null,null,null,null,null,null,null,null,"USD",null,18,"S"]
[null,null,null,null,null,null,null,null,null,null,"CNY",null,19,"T"]
[null,null,null,null,null,null,null,null,null,null,"EUR",null,20,"U"]
[null,null,null,null,null,null,null,null,null,null,"JPY",null,21,"V"]
[null,null,null,null,null,null,null,null,null,null,"HKD",null,22,"W"]
[null,null,null,null,null,null,null,null,null,null,null,null,23,"X"]
[null,null,null,null,null,null,null,null,null,null,null,null,24,"Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,25,"Z"]

{"sheet":"設定","index":4,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"SFTP2API"]
[null,null,null,null,null,"tsftp.einv.systemlead.com"]
[null,null,null,null,null,26039959]
[null,null,null,null,null," M0E3MUYwNDlBRkFEQjAwMQ=="]

{"sheet":"toyoushop","index":5,"n_rows":8,"n_cols":24,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["建議8-12碼","訂單日期","C-二聯 B-三聯","B 抬頭與統編必填 C 不限","買受人發票抬頭","買受人統編","通知客戶(必填)","16碼為限","訂單總額=訂單小計加總","稅別:1:應稅","發票稅額(發票類型C:稅額為0、B:稅額為訂單總額*稅額(0.05))，含稅總額=訂單總額+發票稅額","發票總額","列印發票明細用(產品單價C含稅、B未稅)","產品名稱","購買數量","產品單價","產品小計","單身(100字)","單頭備註","1.財政部 2自然人3.會員載具","載具號碼","捐贈愛心碼","客戶郵寄地址","Y/N"]
["訂單號碼","訂單日期","發票類型","買受人名稱","買受人發票抬頭","買受人統編","客戶電子郵件","客戶行動電話","訂單總額","課稅類別","應稅稅額","發票總額","產品代號","產品名稱","購買數量","產品單價","產品小計","備註","信用卡號後四碼","載具類型","載具號碼","捐贈愛心碼","客戶郵寄地址","索取紙本"]
["RH10711220019","2018-11-22","B","民間團體","好好人協會","00000000","18111611510005@nomail","0900000123","60",1,"3","63","","產品A03","1","30",30,null,null,null,null,"",""]
["RH10711220019","2018-11-22","B","民間團體","好好人協會","00000000","18111611510005@nomail","0900000123","60",1,"3","63","","產品A03","1","30",30,null,null,null,null,"",""]
["RH10711220020","2018-11-22","C","機關學校","高雄市最佳里政府","89423038","18111611480004@nomail","0900000125","20",1,0,"20","","產品B01","1","11",11,null,null,null,null,"",""]
["RH10711220020","2018-11-22","C","機關學校","高雄市最佳里政府","89423038","18111611480004@nomail","0900000125","20",1,0,"20","","產品B02","1","8.526",9,null,null,null,null,"",""]
["RH10711220021","2018-11-22","B","營業人客戶","某大股份有限公司","89423037","18111611450003@nomail","0900000126","13",1,"1","14","","產品B02","1","8.12",8,null,null,null,null,"",""]
["RH10711220021","2018-11-22","B","營業人客戶","某大股份有限公司","89423037","18111611450003@nomail","0900000126","13",1,"1","14","","產品B03","1","5.123",5,null,null,null,null,"",""]

{"sheet":"匯入作業說明","index":6,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"操作步驟說明","示範圖例 說明","我已經清楚操作並啟動"]
[null,1,"請允許啟動 EXCEL 的編輯與 巨集 權限"]
[null,2,"你可以先將這份EXCEL 選定你經常作業目錄後另存後再重新開啟excel"," 第一次啟動需要輸入基本資料與註冊"]
[null,3,"第一列上有巨集按鈕可以方便作業。\n你可以設定 產出的EXCEL 匯出檔的路徑(方便匯入時找到檔案)。\n可以清空測試資料。",null,"無法啟動巨集有安全性問題"]
[null,4,"你可以將要開立的發票使用巨集輸入","可使用巨集功能輸入訂單資料"]
[null,5,"注意 資料完成後此步驟一定要執行\n輸入完畢後點選 轉出(會產生一個純文字的匯入檔)。\n主要檢查一些必要欄位是否遺漏與錯誤，金額是否計算錯誤。"]
[null,6,"到e首發票後台進入後選擇匯入產生的檔案開立電子發票。\n不是匯入原來巨集的檔案。"]