{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["薪資轉帳","臺幣_整批轉帳","臺幣_整批匯款","薪資單明細","常用薪資明細項目字典"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":55,"n_cols":7,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["表單資訊填入後，按下「產生檔案」按鈕即可產出上傳檔案"]
[]
["區別碼","委託單位代號","存摺摘要","檢查身分證字號(Y/N)","轉帳日","轉帳發薪總額"]
["K","7151234","00000","N","1091231",111]
["區別碼","委託單位代號","補零","員工北富銀之帳號","補入英文或數字","員工入帳薪資","員工身份證字號"]
["C","7151234","00000","00715168123456","000000",111,"A123456789"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]
["C",null,"00000",null,"000000"]

{"sheet":"臺幣_整批轉帳","index":1,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["表單資訊填入後，按下「產生檔案」按鈕即可產出上傳檔案"]
[]
["區別碼(*)","預訂交易日期(*)","總筆數(*)","總金額(*)"]
["H","20201231","2",8888]
["區別碼(*)","轉入行庫代碼(*)","轉入帳號(*)","轉帳金額(*)","帳戶暱稱","交易明細留言(存摺附註)","email通知收件者","email通知內容"]
["C","012","00715000111222",7000,"廠商一","202008貨款","test1@fubon.com;test2@fubon.com","202012貨款from良心企業"]
["C","013","74581236987411",1888,"廠商二","零用金支出"]
["C"]
["C"]
["C"]
["C"]
["C"]
["C"]
["C"]
["C"]
["C"]
["C"]
["C"]
["C"]
["C"]
["C"]
["C"]
["C"]
["C"]
["C"]
["C"]
["C"]
["C"]
["C"]
["C"]
["C"]
["C"]
["C"]
["C"]
["C"]

{"sheet":"臺幣_整批匯款","index":2,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["表單資訊填入後，按下「產生檔案」按鈕即可產出上傳檔案"]
[]
["總筆數(*)","預訂交易日期(*)","總金額(*)"]
[3,"20201231",606]
["收款行代號(*)","收款人帳號(*)","金額(*)","收款人姓名(*)","匯款人姓名(*)","交易明細留言(存摺附註)"]
["8220099","9990001118610",101,"世界企業","範例公司"]
["8220011","00301168608861",202,"太平企業","範例公司","貨款202012"]
["0127152","00715999000000",303,"大方公司","範例公司"]

{"sheet":"薪資單明細","index":3,"n_rows":15,"n_cols":102,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["表單資訊填入後，按下「產生檔案」按鈕即可產出上傳檔案"]
[]
["欄位代號","H001","H002","H003","H004","H005","D101","D102","D103","D104","D105","D106","D107","D108","D109","D110","D111","D112","D113","D114","D115","D116","D117","D118","D119","D120","D121","D122","D123","D124","D125","D126","D127","D128","D129","D130","D131","D132","D133","D134","D201","D202","D203","D204","D205","D206","D207","D208","D209","D210","D211","D212","D213","D214","D215","D216","D217","D218","D219","D220","D221","D222","D223","D224","D225","D226","D227","D228","D229","D230","D231","D232","D301","D302","D303","D304","D305","D306","D307","D308","D309","D310","D311","D312","D313","D314","D315","D316","D317","D318","D319","D320","D321","D322","D323","D324","D325","D326","D327","D328","D329","D330"]
["字元長度",10,2,8,3,7,10,6,10,20,16,9,5,5,5,5,5,5,5,5,5,5,5,5,33,33,33,33,33,33,20,9,20,9,20,9,20,9,20,9,20,9,20,9,20,9,20,9,20,9,20,9,20,9,20,9,20,9,20,9,20,9,20,9,20,9,20,9,20,9,20,9,20,9,20,9,20,9,20,9,20,9,20,9,20,9,20,9,20,9,20,9,20,9,20,9,20,9,20,9,20,9]
["欄位名稱","公司統一編號","資料格式別","發薪日期","當日發薪批號","員工代號","身分證號","部門代號","員工姓名","發放內容","帳號","實發","本月假勤\n平日加班","本月假勤\n假日加班","本月假勤\n事假","本月假勤\n病假","本月假勤\n特休","本月假勤\n其他","年度特休\n可休","年度特休\n已休","年度特休\n結餘","年度補修\n可休","年度補修\n已休","年度補修\n結餘","說明文字一","說明文字二","說明文字三","說明文字四","說明文字五","說明文字六","薪資明細項目1","薪資明細金額1","薪資明細項目2","薪資明細金額2","薪資明細項目3","薪資明細金額3","薪資明細項目4","薪資明細金額4","薪資明細項目5","薪資明細金額5","薪資明細項目6","薪資明細金額6","薪資明細項目7","薪資明細金額7","薪資明細項目8","薪資明細金額8","薪資明細項目9","薪資明細金額9","薪資明細項目10","薪資明細金額10","薪資明細項目11","薪資明細金額11","薪資明細項目12","薪資明細金額12","薪資明細項目13","薪資明細金額13","薪資明細項目14","薪資明細金額14","薪資明細項目15","薪資明細金額15","薪資明細項目16","薪資明細金額16","薪資明細項目17","薪資明細金額17","薪資明細項目18","薪資明細金額18","薪資明細項目19","薪資明細金額19","薪資明細項目20","薪資明細金額20","薪資明細項目21","薪資明細金額21","薪資明細項目22","薪資明細金額22","薪資明細項目23","薪資明細金額23","薪資明細項目24","薪資明細金額24","薪資明細項目25","薪資明細金額25","薪資明細項目26","薪資明細金額26","薪資明細項目27","薪資明細金額27","薪資明細項目28","薪資明細金額28","薪資明細項目29","薪資明細金額29","薪資明細項目30","薪資明細金額30","薪資明細項目31","薪資明細金額31","薪資明細項目32","薪資明細金額32","薪資明細項目33","薪資明細金額33","薪資明細項目34","薪資明細金額34","薪資明細項目35","薪資明細金額35","薪資明細項目36","薪資明細金額36"]
["員工1","12345678","01","20201210","001","000","A123456789","V128","蔡小美","10909薪資單","00715123456789","31800","10","0","0","0","2","0","8","2","6","2","2","0",null,null,null,null,null,null,"本薪(+)","22133","餐費(+)","3600","職等加給(+)","1800","業績獎金(+)","1500","交通津貼(+)","800","加班費(+)","2500","全勤獎金(+)","500","其他加項(+)","3800","代扣所得稅(-)","1600","自提退休金(-)","1500","健保費(-)","800","勞保費(-)","800","其他扣款(-)","0"]
["員工2","12345678","01","20201210","001","000","A123456789","V128","蔡小美","10909薪資單","00715123456789","31800","10","0","0","0","2","0","8","2","6","2","2","0",null,null,null,null,null,null,"本薪(+)","22133","餐費(+)","3600","職等加給(+)","1800","業績獎金(+)","1500","交通津貼(+)","800",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,null,null,null,null,null,null,null,"加班費(+)","2500","全勤獎金(+)","500","其他加項(+)","3800","代扣所得稅(-)","1600","自提退休金(-)","1500","健保費(-)","800","勞保費(-)","800","其他扣款(-)","0"]
["員工3","12345678","01","20201210","001","000","A123456789","V128","蔡小美","10909薪資單","00715123456789","31800","10","0","0","0","2","0","8","2","6","2","2","0",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"加班費(+)","2500","全勤獎金(+)","500","其他加項(+)","3800","代扣所得稅(-)","1600","自提退休金(-)","1500","健保費(-)","800","勞保費(-)","800","其他扣款(-)","0",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"加班費(+)","2500","全勤獎金(+)","500","其他加項(+)","3800","代扣所得稅(-)","1600","自提退休金(-)","1500","健保費(-)","800","勞保費(-)","800","其他扣款(-)","0"]
["員工4"]
["員工5"]
["員工6"]
["員工7"]
["員工8"]
["員工9"]
["員工10"]

{"sheet":"常用薪資明細項目字典","index":4,"n_rows":33,"n_cols":9,"rows_kept":33,"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,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,null,"營業獎金"]
[null,null,"績效獎金    "]
[null,null,"獎勵金"]
[null,null,"佣金"]
[null,null,"季獎金"]