{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["外匯整批匯款","外匯整批轉帳","sheet3","央行申報"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":0,"defined_names":13,"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":5,"n_cols":28,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,10],[3,7,3,10],[2,7,2,10],[3,19,3,22],[3,13,3,16],[1,9,1,10],[1,3,1,5],[1,6,1,7],[1,13,2,16],[1,12,2,12],[1,19,2,22],[1,18,2,18],[1,17,2,17],[1,11,2,11],[1,23,2,23],[1,24,2,24],[1,25,2,25],[1,26,2,26],[1,27,2,27]]}
["                                                                                    MyB2B DBU外匯整批匯款媒體格式編輯"]
[null,"交易日期\n(ex:20201231)",null,"付款人統編",null,null,null,null,"付款人帳號",null,null,"收款人是否通知","電子郵件信箱","收款人英文姓名及地址",null,null,null,"收款銀行格式","收款銀行代碼","收款銀行名稱及地址",null,null,null,"收款國家別","電文發送方式","交易類別","郵電費收取","中間銀行\n(收款銀行之設帳行)"]
[null,"收款人帳號","匯款幣別","匯款金額","收款人身分別","匯款分類","匯出款資金來源\n(匯款分類693時)","匯款附言"]
["請從Ｂ6欄開始輸入，完成後請按『轉換』。","(IBAN 資料\n請輸入此欄)","CURRENCY CODE"," ex:100.21元→100.21","請先選擇收款人身分別再選匯款分類。 必選","請先選擇收款人身分別再選匯款分類。 必選","0：自行以新台幣結購\n1：國外或國內他行匯入之外匯","1.限依序輸入於[H]→[K]欄，每欄限35個字元)\n2.不可輸入中文、特殊字元且每一欄位第一個字元不可輸入\":\"或\"-\"",null,null,null,"0:不通知\n1:e-mail","限輸入e-mail address","1.限依序輸入於[N]→[Q]欄，每欄限35個字元)\n2.不可輸入中文、特殊字元且每一欄位第一個字元不可輸入\":\"或\"-\"",null,null,null,"A:SWIFT CODE  \nD:銀行名稱、地址","收款銀行為D格式，如有ABA、SC、BSB 資料輸入，詳sheet3收款銀行D格式說明","1.收款銀行A格式，輸入銀行SWIFTCODE 格式(限輸入於[T]欄)\n2.收款銀行D格式，輸入詳細之收款銀行名稱、地址(限依序輸入於[T]→[W]欄，每欄限35個字元)",null,null,null,"收款國家別詳sheet3國別表說明","0:非全額入帳\n1:全額入帳(受款行)","TRN: 約定戶  SPU: 非約定戶","0:內扣\n1:外加","銀行SWIFT CODE"]
["範例","002080200XXX","USD","100.21","民營企業","115      - 航空貨運費支出                                   ","1","goodguy",null,null,null,"1","123@yahoo.com","Macgyver",null,null,null,"A",null,"SCBLHKHH",null,null,null,"US","1","SPU","1"]

{"sheet":"外匯整批轉帳","index":1,"n_rows":5,"n_cols":12,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,4,1,5],[0,0,0,11],[1,7,1,8],[1,9,1,11]]}
["MyB2B DBU外匯整批轉帳媒體格式編輯"]
[null,"交易日期\n(ex:20201231)",null,"付款人帳號",null,null,"付款人統編"]
[null,"收款人帳號","轉帳幣別","轉帳金額","收款人統編","收款人戶名","收款人是否通知","電子郵件信箱","備註","交易類別","收款人分類","匯款分類"]
["請從Ｂ6欄位開始輸入，輸入完成後請按『轉換』。","限本行DBU外幣帳號","CURRENCY CODE, EX:USD"," ex:100.21元→100.21",null,null,"0:不通知\n1:e-mail","限輸入e-mail address",null,"TRN: 約定戶  SPU: 非約定戶","請先選擇收款人身分別再選匯款分類。 必選","請先選擇收款人身分別再選匯款分類。 必選"]
["範例","002080200XXX","NZD",100.21,"K1234567XX",null,"1","123@yahoo.com",null,"TRN","本人","695T-客戶間國內贍家、捐贈、繼承等移轉收支"]

{"sheet":"sheet3","index":2,"n_rows":9,"n_cols":1,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["收款銀行D格式說明"]
[]
[]
[]
[]
[]
[]
[]
["國別表"]

{"sheet":"央行申報","index":3,"n_rows":78,"n_cols":13,"rows_kept":78,"cut":false,"hidden":true,"merged":[[0,10,0,12]]}
["政府","公營企業","民營企業","他人帳戶693用","本人帳戶693用",null,null,null,null,null,"整批轉帳"]
["111      - 海運貨運費支出                                   ","111      - 海運貨運費支出                                   ","111      - 海運貨運費支出                                   ","693R     -由本行轉往國內他行之外匯-國內貨款收付    ","693      -由本行轉往國內他行之外匯(結購外匯僅作外存不再匯出)",null,null,null,null,null,"他人本人","本人","他人"]
["112      - 海運客運費支出                                   ","112      - 海運客運費支出                                   ","112      - 海運客運費支出                                   ","693S01   -由本行轉往國內他行之外匯-購買國內外幣保單","693A210  -由本行轉往國內他行之外匯-對外股本投資-無核准函且最終受款地不得為中國",null,null,null,null,null,null,"695R-客戶間國內貨款之收付","695R-客戶間國內貨款之收付"]
["115      - 航空貨運費支出                                   ","115      - 航空貨運費支出                                   ","115      - 航空貨運費支出                                   ","693S02   -由本行轉往國內他行之外匯-購買國內外幣基金","693A250  -由本行轉往國內他行之外匯-存放國外存款",null,null,null,null,null,null,"695S-國內外幣保單、基金、債券等投資款項\n含孳息等收益 之收付 本人","695S-國內外幣保單、基金、債券等投資款項\n含孳息等收益 之收付 本人"]
["116      - 航空客運費支出                                   ","116      - 航空客運費支出                                   ","116      - 航空客運費支出                                   ","693S03   -由本行轉往國內他行之外匯-購買國內外幣債券","693A262  -由本行轉往國內他行之外匯-投資國外股權證券",null,null,null,null,null,null,"695T-客戶間國內贍家、捐贈、繼承等移轉收支","695T-客戶間國內贍家、捐贈、繼承等移轉收支"]
["119    01-其他運輸支出-陸路運輸費用               ","119    01-其他運輸支出-陸路運輸費用               ","119    01-其他運輸支出-陸路運輸費用               ","693S04   -由本行轉往國內他行之外匯-其他國內投資款項","693A263  -由本行轉往國內他行之外匯-投資國外長期債票券",null,null,null,null,null,null,"695L-客戶間國內外幣借貸之收付","695L-客戶間國內外幣借貸之收付"]
["119    02-其他運輸支出-貨物裝卸費用               ","119    02-其他運輸支出-貨物裝卸費用               ","119    02-其他運輸支出-貨物裝卸費用               ","693T     -由本行轉往國內他行之外匯-國內贍家、捐贈、繼承等移轉收支","693A264  -由本行轉往國內他行之外匯-投資國外短期債票券",null,null,null,null,null,null,"695P-客戶間國內服務之收付","695P-客戶間國內服務之收付"]
["119    03-其他運輸支出-港口機場費用               ","119    03-其他運輸支出-港口機場費用               ","119    03-其他運輸支出-港口機場費用               ","693L     -由本行轉往國內他行之外匯-國內外幣借貸之收付","693A266  -由本行轉往國內他行之外匯-國外有本金交割的遠匯及換匯之資金匯出",null,null,null,null,null,null,"695Z-同一客戶外幣資金異動係涉及國外交易之收支"]
["119    04-其他運輸支出-倉儲費用               ","119    04-其他運輸支出-倉儲費用               ","119    04-其他運輸支出-倉儲費用               ","693P     -由本行轉往國內他行之外匯-國內服務之收付","693A267  -由本行轉往國內他行之外匯-國外無本金交割的衍生金融商品之資金匯出",null,null,null,null,null,null,"695 -同一客戶其結購外匯僅作外存不再匯至國內他人帳戶或國外、或結\n售之外匯原係以新臺幣結購存入"]
["119    05-其他運輸支出-客貨運有關的佣金及代理費","119    05-其他運輸支出-客貨運有關的佣金及代理費","119    05-其他運輸支出-客貨運有關的佣金及代理費",null,"693A270  -由本行轉往國內他行之外匯-投資國外不動產    "]
["121      -財產保險支出              ","121      -財產保險支出              ","121      -財產保險支出              ",null,"693B220  -由本行轉往國內他行之外匯-對外貸款投資    "]
["122      -財產保險理賠支出          ","122      -財產保險理賠支出          ","122      -財產保險理賠支出          ",null,"693B280  -由本行轉往國內他行之外匯-對外融資貸款    "]
["123      -人身保險支出              ","123      -人身保險支出              ","123      -人身保險支出              ",null,"693B340  -由本行轉往國內他行之外匯-償還國外借款"]
["129      -人身保險理賠支出          ","129      -人身保險理賠支出          ","129      -人身保險理賠支出          ",null,"693C440  -由本行轉往國內他行之外匯-國外借款利息    "]
["131      -商務支出                  ","131      -商務支出                  ","131      -商務支出                  ",null,"693D710  -由本行轉往國內他行之外匯-委外加工        "]
["132      -觀光支出                  ","132      -觀光支出                  ","132      -觀光支出                  ",null,"693D711  -由本行轉往國內他行之外匯-商仲貿易貨款收支"]
["134      -留學支出                  ","134      -留學支出                  ","134      -留學支出                  ",null,"693E111  -由本行轉往國內他行之外匯-海運貨運費支出  "]
["135      -信用卡支出 ","135      -信用卡支出 ","135      -信用卡支出 ",null,"693E112  -由本行轉往國內他行之外匯-海運客運費支出  "]
["191      -文化及休閒支出            ","191      -文化及休閒支出            ","191      -文化及休閒支出            ",null,"693E115  -由本行轉往國內他行之外匯-航空貨運費支出  "]
["192      -貿易佣金及代理費支出      ","192      -貿易佣金及代理費支出      ","192      -貿易佣金及代理費支出      ",null,"693E116  -由本行轉往國內他行之外匯-航空客運費支出  "]
["193      -營建支出                  ","193      -營建支出                  ","193      -營建支出                  ",null,"693E11901-由本行轉往國內他行之外匯-其他運輸支出-陸路運輸費用                "]
["194      -金融服務支出              ","194      -金融服務支出              ","194      -金融服務支出              ",null,"693E11902-由本行轉往國內他行之外匯-其他運輸支出-貨物裝卸費用               "]
["195      -使用智慧財產權支出        ","195      -使用智慧財產權支出        ","195      -使用智慧財產權支出        ",null,"693E11903-由本行轉往國內他行之外匯-其他運輸支出-港口機場費用               "]
["196      -我國民間機構在國外辦公費用","196      -我國民間機構在國外辦公費用","196      -我國民間機構在國外辦公費用",null,"693E11904-由本行轉往國內他行之外匯-其他運輸支出-倉儲費用                   "]
["199    01-其他服務支出-翻譯費                    ","199    01-其他服務支出-翻譯費                    ","199    01-其他服務支出-翻譯費                    ",null,"693E11905-由本行轉往國內他行之外匯-其他運輸支出客貨運有關的佣金及代理費支出"]
["199    02-其他服務支出-加工費（加工後不再進口者）","199    02-其他服務支出-加工費（加工後不再進口者）","199    02-其他服務支出-加工費（加工後不再進口者）",null,"693E121  -由本行轉往國內他行之外匯-財產保險支出                "]
["199    03-其他服務支出-與建築設計類無關之設計費  ","199    03-其他服務支出-與建築設計類無關之設計費  ","199    03-其他服務支出-與建築設計類無關之設計費  ",null,"693E122  -由本行轉往國內他行之外匯-財產保險理賠支出          "]
["199    04-其他服務支出-與建築設計類無關之稿費    ","199    04-其他服務支出-與建築設計類無關之稿費    ","199    04-其他服務支出-與建築設計類無關之稿費    ",null,"693E123  -由本行轉往國內他行之外匯-人身保險支出              "]
["199    05-其他服務支出-與電腦資訊類無關之維修費  ","199    05-其他服務支出-與電腦資訊類無關之維修費  ","199    05-其他服務支出-與電腦資訊類無關之維修費  ",null,"693E129  -由本行轉往國內他行之外匯-人身保險理賠支出          "]
["199    06-其他服務支出-服裝設計費                ","199    06-其他服務支出-服裝設計費                ","199    06-其他服務支出-服裝設計費                ",null,"693E131  -由本行轉往國內他行之外匯-商務支出                  "]
["199    07-其他服務支出-報關行之報關費            ","199    07-其他服務支出-報關行之報關費            ","199    07-其他服務支出-報關行之報關費            ",null,"693E132  -由本行轉往國內他行之外匯-觀光支出"]
["199    08-其他服務支出-與貿易無關之行銷佣金      ","199    08-其他服務支出-與貿易無關之行銷佣金      ","199    08-其他服務支出-與貿易無關之行銷佣金      ",null,"693E133  -由本行轉往國內他行之外匯-探親支出                  "]
["199    09-其他服務支出-大樓管理費                ","199    09-其他服務支出-大樓管理費                ","199    09-其他服務支出-大樓管理費                ",null,"693E134  -由本行轉往國內他行之外匯-留學支出                  "]
["19A      -郵務與快遞支出                        ","19A      -郵務與快遞支出                        ","19A      -郵務與快遞支出                        ",null,"693E135  -由本行轉往國內他行之外匯-信用卡支出"]
["19B      -電腦與資訊支出                        ","19B      -電腦與資訊支出                        ","19B      -電腦與資訊支出                        ",null,"693E191  -由本行轉往國內他行之外匯-文化及休閒支出            "]
["19C      -營業租賃支出                          ","19C      -營業租賃支出                          ","19C      -營業租賃支出                          ",null,"693E192  -由本行轉往國內他行之外匯-貿易佣金及代理費支出      "]
["19D      -專業技術事務支出                      ","19D      -專業技術事務支出                      ","19D      -專業技術事務支出                      ",null,"693E193  -由本行轉往國內他行之外匯-營建支出                  "]
["19E      -視聽支出                              ","19E      -視聽支出                              ","19E      -視聽支出                              ",null,"693E194  -由本行轉往國內他行之外匯-金融服務支出              "]
["19F      -外國政府機構之服務收入匯出款          ","19F      -外國政府機構之服務收入匯出款          ","19F      -外國政府機構之服務收入匯出款          ",null,"693E195  -由本行轉往國內他行之外匯-使用智慧財產權支出        "]
["19H      -加工費支出                            ","19H      -加工費支出                            ","19H      -加工費支出                            ",null,"693E196  -由本行轉往國內他行之外匯-我國民間機構在國外辦公費用"]
["19J      -電信支出                              ","19J      -電信支出                              ","19J      -電信支出                              ",null,"693E19901-由本行轉往國內他行之外匯-其他服務支出-翻譯費                  "]
["19K      -維修支出                              ","19K      -維修支出                              ","19K      -維修支出                              ",null,"693E19902-由本行轉往國內他行之外匯-其他服務支出-加工費                  "]
["19P      -購買研發成果資產之支出                ","19P      -購買研發成果資產之支出                ","19P      -購買研發成果資產之支出                ",null,"693E19903-由本行轉往國內他行之外匯-其他服務支出-與建築設計類無關之設計費"]
["210      -對外股本投資-無核准函                 ","210      -對外股本投資-無核准函                 ","210      -對外股本投資-無核准函                 ",null,"693E19904-由本行轉往國內他行之外匯-其他服務支出-與建築設計類無關之稿費  "]
["250      -存放國外銀行                          ","250      -存放國外銀行                          ","250      -存放國外銀行                          ",null,"693E19905-由本行轉往國內他行之外匯-其他服務支出-與電腦資訊類無關之維修費"]
["262      -投資國外股權證券                      ","262      -投資國外股權證券                      ","262      -投資國外股權證券                      ",null,"693E19906-由本行轉往國內他行之外匯-其他服務支出-服裝設計費              "]
["263      -投資國外長期債票券                    ","263      -投資國外長期債票券                    ","263      -投資國外長期債票券                    ",null,"693E19907-由本行轉往國內他行之外匯-其他服務支出-報關行之報關費          "]
["264      -投資國外短期債票券                    ","264      -投資國外短期債票券                    ","264      -投資國外短期債票券                    ",null,"693E19908-由本行轉往國內他行之外匯-其他服務支出-與貿易無關之行銷佣金    "]
["266      -國外有本金交割的遠匯及換匯之資金匯出  ","266      -國外有本金交割的遠匯及換匯之資金匯出  ","266      -國外有本金交割的遠匯及換匯之資金匯出  ",null,"693E19909-由本行轉往國內他行之外匯-其他服務支出-大樓管理費              "]
["267      -國外無本金交割的衍生金融商品之資金匯出","267      -國外無本金交割的衍生金融商品之資金匯出","267      -國外無本金交割的衍生金融商品之資金匯出",null,"693E19A  -由本行轉往國內他行之外匯-郵務與快遞支出                "]
["270      -投資國外不動產                        ","270      -投資國外不動產                        ","270      -投資國外不動產                        ",null,"693E19B  -由本行轉往國內他行之外匯-電腦與資訊支出                "]
["280      -對外融資貸款                          ","280      -對外融資貸款                          ","280      -對外融資貸款                          ",null,"693E19C  -由本行轉往國內他行之外匯-營業租賃支出                  "]
["340      -償還國外借款                          ","340      -償還國外借款                          ","340      -償還國外借款                          ",null,"693E19D  -由本行轉往國內他行之外匯-專業技術事務支出              "]
["410      -非居民薪資匯出（限雇主匯出）          ","410      -非居民薪資匯出（限雇主匯出）          ","410      -非居民薪資匯出（限雇主匯出）          ",null,"693E19E  -由本行轉往國內他行之外匯-視聽支出                      "]
["440      -國外借款利息                          ","440      -國外借款利息                          ","440      -國外借款利息                          ",null,"693E19F  -由本行轉往國內他行之外匯-外國政府機構之服務收入匯出款  "]
["511      -工作者匯款支出（限雇主匯出）          ","511      -工作者匯款支出（限雇主匯出）          ","511      -工作者匯款支出（限雇主匯出）          ",null,"693E19H  -由本行轉往國內他行之外匯-加工費支出                    "]
["520      -捐贈匯款支出                          ","520      -捐贈匯款支出                          ","520      -捐贈匯款支出                          ",null,"693E19J  -由本行轉往國內他行之外匯-電信支出                      "]
["540      -購買自然資源與非研發成果資產支出      ","540      -購買自然資源與非研發成果資產支出      ","540      -購買自然資源與非研發成果資產支出      ",null,"693E19K  -由本行轉往國內他行之外匯-維修支出                      "]
["611      -出口貨款退回                          ","611      -出口貨款退回                          ","611      -出口貨款退回                          ",null,"693E19P  -由本行轉往國內他行之外匯-購買研發成果資產之支出 "]
["70A      -付款人已自行辦理進口通關的貨款                      ","70A      -付款人已自行辦理進口通關的貨款                      ","70A      -付款人已自行辦理進口通關的貨款                      ",null,"693F520  -由本行轉往國內他行之外匯-對國外捐獻或贈與款"]
["701      -尚未進口之預付貨款","701      -尚未進口之預付貨款","701      -尚未進口之預付貨款",null,"693F540  -由本行轉往國內他行之外匯-購買自然資源與非研發成果資產支出"]
["702      -燃油費及補給支出                                  ","702      -燃油費及補給支出                                  ","702      -燃油費及補給支出                                  ",null,"693G410  -由本行轉往國內他行之外匯-非居民薪資匯出（限雇主匯出）"]
["704      -樣品費支出                                          ","704      -樣品費支出                                          ","704      -樣品費支出                                          ",null,"693G511  -由本行轉往國內他行之外匯-工作者匯款支出（限雇主匯出）            "]
["710      -委外加工貿易支出","710      -委外加工貿易支出","710      -委外加工貿易支出",null,"693I70A  -由本行轉往國內他行之外匯-付款人已自行辦理進口通關的貨款"]
["710A     -大陸出、進口之委外加工貿易支出","710A     -大陸出、進口之委外加工貿易支出","710A     -大陸出、進口之委外加工貿易支出",null,"693I701  -由本行轉往國內他行之外匯-尚未進口之預付貨款            "]
["710F     -大陸出、進口經OBU之委外加工貿易支出(受款國別限TW(OBU))                                    ","710F     -大陸出、進口經OBU之委外加工貿易支出(受款國別限TW(OBU))                                    ","710F     -大陸出、進口經OBU之委外加工貿易支出(受款國別限TW(OBU))                                    ",null,"693I702  -由本行轉往國內他行之外匯-燃油費及補給支出"]
["711      -商仲貿易支出","711      -商仲貿易支出","711      -商仲貿易支出",null,"693I704  -由本行轉往國內他行之外匯-樣品費支出               "]
["711A     -大陸出、進口之商仲貿易支出","711A     -大陸出、進口之商仲貿易支出","711A     -大陸出、進口之商仲貿易支出",null,"693R     -由本行轉往國內他行之外匯-國內貨款收付    "]
["711F     -大陸出、進口經OBU之商仲貿支出(受款國別限TW(OBU))                                        ","711F     -大陸出、進口經OBU之商仲貿支出(受款國別限TW(OBU))                                        ","711F     -大陸出、進口經OBU之商仲貿支出(受款國別限TW(OBU))                                        ",null,"693S01   -由本行轉往國內他行之外匯-購買國內外幣保單"]
["801      -非由付款人自行辦理進口通關的貨款(無證明文件)        ","801      -非由付款人自行辦理進口通關的貨款(無證明文件)        ","801      -非由付款人自行辦理進口通關的貨款(無證明文件)        ",null,"693S02   -由本行轉往國內他行之外匯-購買國內外幣基金"]
["802      -國外訂貨但由境內供貨的貨款(無證明文件)","802      -國外訂貨但由境內供貨的貨款(無證明文件)","802      -國外訂貨但由境內供貨的貨款(無證明文件)",null,"693S03   -由本行轉往國內他行之外匯-購買國內外幣債券"]
[null,null,null,null,"693S04   -由本行轉往國內他行之外匯-其他國內投資款項"]
[null,null,null,null,"693T     -由本行轉往國內他行之外匯-國內贍家、捐贈、繼承等移轉收支"]
[null,null,null,null,"693L     -由本行轉往國內他行之外匯-國內外幣借貸之收付"]
[null,null,null,null,"693P     -由本行轉往國內他行之外匯-國內服務之收付"]
[null,null,null,null,"693Z611  -由本行轉往國內他行之外匯-出口貨款退回"]
[null,null,null,null,"693Z801  -由本行轉往國內他行之外匯-非由付款人自行辦理進口通關的貨款(無證明文件)"]
[null,null,null,null,"693Z802  -由本行轉往國內他行之外匯-國外訂貨但由境內供貨的貨款(無證明文件)"]