{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["匯入作業說明","訂單版標準版","log","初始值"],"not_rendered":{"charts":0,"images":8,"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":"匯入作業說明","index":0,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"操作步驟","示範圖例 說明","我已經清楚巨集操作"]
[null,1,"新版範本 含有免費升級許多功能。建議優先使用\n這個檔案含有檢查與轉換格式的巨集程式。\n建議使用該巨集減少發票開立錯誤問題。\n請允許啟動 EXCEL 的編輯與巨集程式權限",null,"第一次執行匯出後\n不再出現此說明頁"]
[null,2,"剛下載請先將這份EXCEL 選定你經常作業目錄後另存"]
[null,3,"第一列上有巨集按鈕可以方便作業。\n你可以設定 產出的EXCEL 匯出檔的路徑(方便匯入時找到檔案)。\n可以清空測試資料。\n可以利用隱藏不常用欄位作為貼入或輸入的方便選擇。",null,"無法執行巨集\nEXCEL巨集安全性設定"]
[null,4,"你可以將要開立的發票資料貼入或是輸入(注意訂單號碼重複不匯入)"]
[null,5,"重要 輸入完畢後點選 檢查與轉出(會產生一個純文字的匯入檔)。\n巨集協助檢查一些必要欄位是否遺漏與填寫錯誤，金額是否計算錯誤。\n也將格式中文數字轉換成標準匯入格式，避免錯誤。"]
[null,6,"到e首發票後台匯入上述產生的純文字的匯入檔 開立電子發票。\n不是匯入原來巨集的檔案。"]

{"sheet":"訂單版標準版","index":1,"n_rows":3,"n_cols":39,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["BillingNo","UTCInvoiceDateTime","InvoiceFor","BuyerID","BuyerInvoiceTitle","BuyerName","BuyerTelNo","BuyerEmailAddress","BuyerCustomerNumber","BuyerAddress","CheckNumber","RandomNumber","RelateNumber","NPOBAN","CarrierId","CarrierType","DeptID","SalesID","TaxType","SalesAmount","TaxAmount","TotalAmount","MainRemark","DetailID","ProductID","ProductName","Quantity","UnitPrice","SubTotal","Remark","CustomsClearanceMark","BondedArea","ItemTaxDiff","Unit","Currency","ExchangeRate","OriginalCurrencyAmount","CompanyID","UseFor"]
["不可重複","系統產生免填","三聯B、\n二聯C類","B類必填","B類必填","C類選填","請填手機","選填","客戶會員標號","選填","4碼 for B類發票，若無系統可補(選填)","4碼 for B2C，若無系統可補(選填)","紀錄訂單、採購單編號(選填)","C類捐贈時使用(選填)","電子發票載具使用(選填)","手機條碼(3J0002)\n自然人憑證(CQ0001)","空白預設公司(選填)","業務姓名(選填)","1:應稅 2:零稅率 3:免稅","單身小計總和。","銷售額*0.05。C類為0。計算稅額在±2元以上會自動調整並記錄","銷售總額+總稅額之和","備註 100字內(選填)作廢發票可填寫作廢說明","若無\n系統可補","選填","銷售產品名稱","(銷售或折讓數量)","預設C類含稅，B類未稅。(銷售或折讓單價)","小計=數量*單價(銷售或折讓額)","單身備註40字內(選填)","1：非經海關\n2：經海關\n(零稅率必填)"," 1:保稅區 2:遠洋漁業3:自由貿易港區","選填","選填","選填","選填","選填","請填入營業人統編","選填"]
["帳單編號","開立日期(免填)","開立對象:B/C","買方統編","買方抬頭","買受人名稱","買方手機號碼","買方電子郵件帳號","客戶編號","買方地址","檢查碼","隨機碼","關聯號碼","愛心碼","載具編號","載具類型","部門","業務人員","課稅別","銷售總額","總稅額","總金額","發票總備註","三碼項次編碼","產品代碼","產品名稱","數量","單價","小計","明細備註","通關方式列表","零稅率註記","保留","單位","幣別","匯率","原幣金額","賣方統編","發票組別"]

{"sheet":"log","index":2,"n_rows":1,"n_cols":5,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["匯出時間","訂單號","統編","C:\\Temp\\e-inv","請勿刪除此列"]

{"sheet":"初始值","index":3,"n_rows":4,"n_cols":35,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["帳單編號","開立日期(免填)","發票開立對象:B類/C類","買方統編","買方抬頭","買受人名稱","買方電話號碼","買方電子郵件帳號","買方地址","檢查碼","隨機碼","關聯號碼","愛心碼","載具編號","載具類型","部門","業務人員","課稅別","銷售總額","總稅額","總金額","發票總備註","三碼項次編碼","產品代碼","產品名稱","數量","單價","小計","明細備註","通關方式列表","零稅率註記","單價稅額異常註記","單位","客戶編號","賣方統編"]
["O-143036200034",null,"B","89430377","有統編單筆有限公司","李一筆","0900-000-000","Lee@Nogmail.com","900屏東市","","","PO-110837",null,null,null,"",null,"1","5000","250","5250","",null,"","好產品一","10","500",5000]
["O-143036200035",null,"C",null,null,"陳客戶","0988-888-888","lotus@gmail.nomail","900屏東市","","","PO-110837",null,null,null,"",null,"1","900","0","900","",null,"","好產品二","20",45,900]
["O-143036200036",null,"C","00146877","C類發票公司","顏如珊","0932-333-333","Cathy@gmail.com","900屏東市","","","PO-455850",null,null,null,"",null,"1","900","0","900","",null,"","文具二","50",18,900]