{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["外匯整批匯款","外匯整批轉帳","sheet3"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":6,"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":[[1,27,2,27],[0,0,0,27],[1,10,2,10],[1,11,2,11],[1,12,2,15],[1,16,2,16],[1,22,2,22],[1,3,1,4],[1,5,1,6],[1,8,1,9],[1,24,2,24],[1,25,2,25],[1,26,2,26],[3,6,3,9],[3,18,3,21],[3,12,3,15],[1,17,2,21],[1,23,2,23],[2,6,2,9]]}
["                                                                                    MyB2B OBU外匯整批匯款媒體格式編輯"]
[null,"預定交易日期\n(Ex:20131231)",null,"付款人統編",null,null,null,"付款人帳號",null,null,"收款人是否電告","電告設備號碼","收款人英文姓名及地址",null,null,null,"收款銀行格式","收款銀行名稱及地址",null,null,null,null,"收款國家別","電文發送方式","交易類別","郵電費收取","中間銀行\n(收款銀行之設帳行)","受款人為TW(OBU)境內法人授信目的帳戶"]
[null,"收款人帳號","匯款幣別","匯款金額","匯款分類","收款人身分別","匯款附言"]
["請從Ｂ6欄開始輸入，完成後請按『轉換』。","非國泰世華銀行OBU帳號","SWIFT CURRENCY CODE  詳sheet3"," ex:100.21元→100.21","01:進口貨款\n02:委外加工及商仲貿易支出\n03:服務支出       04:存放國外銀行\n05:投資款\n06:借出款\n07:投資款匯出\n08:匯出投資所得\n09:償還借款\n10:接濟、捐贈等移轉性支出\n90:其他","1:政府\n2:公營企業\n3:民間","1.限依序輸入於[G]→[J]欄，每欄限35個字元)\n2.不可輸入中文、特殊字元且每一欄位第一個字元不可輸入\":\"或\"-\"",null,null,null,"0:不通知；1:e-mail","限輸入e-mail address","1.限依序輸入於[M]→[P]欄，每欄限35個字元)\n2.不可輸入中文、特殊字元且每一欄位第一個字元不可輸入\":\"或\"-\"",null,null,null,"A:SWIFT CODE  D:銀行名稱、地址","收款銀行若為D格式，如有ABA、SC、BSB 資料請輸入此欄","1.收款銀行A格式，輸入銀行SWIFTCODE 格式(限輸入於[S]欄)\n2.收款銀行D格式，輸入詳細之收款銀行名稱、地址(限依序輸入於[S]→[V]欄，每欄限35個字元)",null,null,null,"詳sheet3說明","0:非全額入帳1:全額入帳(受款行)","TRN: 約定戶  SPU: 非約定戶","0:內扣\n1:外加","銀行SWIFT CODE","Y:是  否不須選填\n若為Y，則收款國家別須為 TW\n"]
["範例","123456789010","USD","100.21","01","3","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":10,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,7,1,9],[1,4,1,5]]}
["MyB2B OBU外匯整批轉帳媒體格式編輯"]
[null,"預定交易日期\n(Ex:20131231)",null,"付款人帳號",null,null,"付款人統編"]
[null,"收款人帳號","轉帳幣別","轉帳金額","收款人統編","收款人戶名","收款人\n是否電告","電告設備號碼","備註","交易類別"]
["請從Ｂ6欄位開始輸入；輸入完成後請按『轉換』即可。","限國泰世華銀行OBU帳號","SWIFT CURRENCY CODE, EX:USD  詳sheet3說明"," ex:100.21元→100.21",null,null,"0:不通知\n1:e-mail",null,null,"TRN: 約定戶  SPU: 非約定戶"]
["範例","033080200005","NZD",100.21,"K123456788",null,"1","123@yahoo.com",null,"TRN"]

{"sheet":"sheet3","index":2,"n_rows":180,"n_cols":4,"rows_kept":180,"cut":false,"hidden":false,"merged":[]}
["1. SWIFT CURRENCY CODE："]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["本行OBU網路銀行人民幣匯款國別須為台灣(TW)、台灣OBU(XA)、香港(HK)及中國(CN)"]
["國別表"]
["國別簡碼","國家名稱","國別簡碼","國家名稱"]
["AD","安道爾(ANDORRA) ","CK","科克群島(COOK ISLANDS) "]
["AE","阿拉伯聯合大公國(UNITED ARAB EMIRATES) ","CL","智利(CHILE) "]
["AF","阿富汗(AFGHANISTAN) ","CM","喀麥隆(CAMEROON) "]
["AG","安地卡及巴布達(ANTIGUA AND BARBUDA) ","CN","中國大陸(CHINA) "]
["AI","英屬安圭拉(ANGUILLA) ","CN","中華人民共和國(CHINA) "]
["AL","阿爾巴尼亞(ALBANIA) ","CO","哥倫比亞(COLOMBIA) "]
["AM","亞美尼亞(ARMENIA) ","CR","哥斯大黎加(COSTA RICA) "]
["AN","荷屬安地列斯(NETH.ANTILLES) ","CS","塞爾維亞及蒙特內格羅(SERBIA AND MONTENEGRO) "]
["AO","安哥拉(ANGOLA) ","CU","古巴(CUBA) "]
["AQ","南極洲(ANTARCTICA) ","CV","佛德角(CAPE VERDE) "]
["AR","阿根廷(ARGENTINA) ","CX","聖誕島(CHRISTMAS ISLAND) "]
["AS","美屬薩摩亞(AMERICAN SAMOA) ","CY","賽普路斯(CYPRUS) "]
["AT","奧地利(AUSTRIA) ","CZ","捷克(CZECH REPUBLIC) "]
["AU","澳大利亞(AUSTRALIA) ","DE","德國(GERMANY) "]
["AW","阿魯巴(ARUBA) ","DJ","吉布地(DJIBOUTI) "]
["AZ","亞賽拜然(AZERBAIJAN) ","DK","丹麥(DENMARK) "]
["BA","波士尼亞(BOSNIA AND HERZEGOVINA) ","DM","多米尼克(DOMINICA) "]
["BB","巴貝多(BARBADOS) ","DO","多明尼加(DOMINICAN REPUBLIC) "]
["BD","孟加拉(BANGLADESH) ","DZ","阿爾及利亞(ALGERIA) "]
["BE","比利時(BELGIUM) ","EC","厄瓜多爾(ECUADOR) "]
["BF","上伏塔﹝布吉納法索﹞(BURKINA FASO) ","EE","愛沙尼亞(ESTONIA) "]
["BG","保加利亞(BULGARIA) ","EG","埃及(EGYPT) "]
["BH","巴林(BAHRAIN) ","EH","西撒哈拉(WESTERN SAHARA) "]
["BI","蒲隆地(BURUNDI) ","ER","厄利垂亞(ERITREA) "]
["BJ","貝南﹝達荷美﹞(BENIN) ","ES","西班牙(SPAIN) "]
["BM","百慕達(BERMUDA) ","ET","衣索比亞(ETHIOPIA) "]
["BN","汶萊(BRUNEI DARUSSALAM) ","FI","芬蘭(FINLAND) "]
["BO","玻利維亞(BOLIVIA) ","FJ","斐濟(FIJI) "]
["BR","巴西(BRAZIL) ","FK","福克蘭群島(FALKLAND ISLANDS (MALVINAS)) "]
["BS","巴哈馬(BAHAMAS) ","FM","密克羅尼西亞(MICRONESIA(FEDERATED STATES OF) "]
["BT","不丹(BHUTAN) ","FO","法羅群島(FAEROE ISLANDS) "]
["BV","波維特島(BOUVET ISLAND) ","FR","法國(FRANCE) "]
["BW","波札那(BOTSWANA) ","GA","加彭(GABON) "]
["BY","白俄羅斯(BELARUS) ","GB","英國(UNITED KINGDOM) "]
["BZ","貝里斯(BELIZE) ","GD","格瑞那達(GRENADA) "]
["CA","加拿大(CANADA) ","GE","喬治亞(GEORGIA) "]
["CC","可可亞群島(COCOS (KEELING) ISLANDS) ","GF","法屬圭亞那(FRENCH GUIANA) "]
["CD","薩伊(CONGO.THE DEMOCRATIC REP.OFTHE) ","GG","無(GUERNSEY.C.I) "]
["CF","中非共和國(CENTRAL AFRICAN REPUBLIC) ","GH","迦納(GHANA) "]
["CG","剛果(CONGO) ","GI","直布羅陀(GIBRALTAR) "]
["CH","瑞士(SWITZERLAND) ","GL","格陵蘭(GREENLAND) "]
["CI","象牙海岸(COTE D) ","GM","甘比亞(GAMBIA) "]
["GN","幾內亞(GUINEA) ","LA","寮國(LAO PEOPLES DEMOCRATIC REPUBLI) "]
["GP","瓜德魯普島(GUADELOUPE) ","LB","黎巴嫩(LEBANON) "]
["GQ","赤道幾內亞(EQUATORIAL GUINEA) ","LC","聖露西亞(SAINT LUCIA) "]
["GR","希臘(GREECE) ","LI","列支敦斯堡(LIECHTENSTEIN) "]
["GS","南喬治亞及南桑威奇群島(SOUTH GEORGIA AND SOUTH SANDWI) ","LK","斯里蘭卡(SRILANKA) "]
["GT","瓜地馬拉(GUATEMALA) ","LR","賴比瑞亞(LIBERIA) "]
["GU","關島(GUAM) ","LS","賴索托(LESOTHO) "]
["GW","幾內亞比索(GUINEA-BISSAU) ","LT","立陶宛(LITHUANIA) "]
["GY","蓋亞那(GUYANA) ","LU","盧森堡(LUXEMBOURG) "]
["HK","香港(HONG KONG) ","LV","拉脫維亞(LATVIA) "]
["HK","香港(HONGKONG) ","LY","利比亞(LIBYAN ARAB JAMAHIRIYA) "]
["HM","赫德及麥當勞群島(HEARD AND McDonald ISLANDS) ","MA","摩洛哥(MOROCCO) "]
["HN","宏都拉斯(HONDURAS) ","MC","摩納哥(MONACO) "]
["HR","克羅埃西亞(CROATIA) ","MD","摩爾多瓦(MOLDOVA.REPUBLIC OF) "]
["HT","海地(HAITI) ","MG","馬達加斯加(MADAGASCAR) "]
["HU","匈牙利(HUNGARY) ","MH","馬紹爾群島(MARSHALL ISLANDS) "]
["ID","印尼(INDONESIA) ","MK","馬其頓(MACEDONIA.THE FORMER YUGOSLA) "]
["IE","愛爾蘭(IRELAND) ","ML","馬利(MALI) "]
["IL","以色列(ISRAEL) ","MM","緬甸(MYANMAR) "]
["IM","無(ISLE OF MAN) ","MN","蒙古(MONGOLIA) "]
["IN","印度(INDIA) ","MO","澳門(MACAU) "]
["IO","英屬印度洋地區(BRITISH INDIAN OCEAN TERRITORY) ","MP","北里亞納群島(NORTHERN MARIANA ISLANDS) "]
["IQ","伊拉克(IRAQ) ","MQ","法屬馬丁尼克(MARTINIQUE) "]
["IR","伊朗(IRAN(ISLAMIC REPUBLIC OF)) ","MR","茅利塔尼亞(MAURITANIA) "]
["IS","冰島(ICELAND) ","MS","蒙瑟拉特島(MONTSERRAT) "]
["IT","義大利(ITALY) ","MT","馬爾他(MALTA) "]
["JE","無(JERSEY. C.I) ","MU","模里西斯(MAURITIUS) "]
["JM","牙買加(JAMAICA) ","MV","馬爾地夫(MALDIVES) "]
["JO","約旦(JORDAN) ","MW","馬拉威(MALAWI) "]
["JP","日本(JAPAN) ","MX","墨西哥(MEXICO) "]
["JP","日本(JAPAN) ","MY","馬來西亞(MALAYSIA) "]
["KE","肯亞(KENYA) ","MZ","莫三鼻給(MOZAMBIQUE) "]
["KG","吉爾吉斯(KYRGYZSTAN) ","NA","納米比亞(NAMIBIA) "]
["KH","高棉(CAMBODIA) ","NC","新喀里多尼亞(NEW CALEDONIA) "]
["KI","吉里巴斯(KIRIBATI) ","NE","尼日(NIGER) "]
["KM","葛摩(COMOROS) ","NF","諾福克群島(NORFOLK ISLAND) "]
["KN","聖克里斯多福(SAINT KITTS AND NEVIS) ","NG","奈及利亞(NIGERIA) "]
["KP","北韓(KOREA.DEMOCRATIC PEOPLE) ","NI","尼加拉瓜(NICARAGUA) "]
["KR","大韓民國(KOREA.REPUBLIC OF) ","NL","荷蘭(NETHERLANDS) "]
["KW","科威特(KUWAIT) ","NO","挪威(NORWAY) "]
["KY","開曼群島(CAYMAN ISLANDS) ","NP","尼泊爾(NEPAL) "]
["KZ","哈薩克(KAZAKHSTAN) ","NR","諾魯(NAURU) "]
["NU","紐威島(NIUE) ","ST","聖托馬─普林斯浦(SAO TOME AND PRINCIPE) "]
["NZ","紐西蘭(NEW ZEALAND) ","SV","薩爾瓦多(EL SALVADOR) "]
["OM","阿曼(OMAN) ","SY","敘利亞(SYRIAN ARAB REPUBLIC) "]
["PA","巴拿馬(PANAMA) ","SZ","史瓦濟蘭(SWAZILAND) "]
["PE","祕魯(PERU) ","TC","土克斯及開科斯群島(TURKS AND CAICONS ISLANDS) "]
["PF","法屬玻里尼西亞(FRENCH POLYNESIA) ","TD","查德(CHAD) "]
["PG","巴布亞新幾內亞(PAPUA NEW GUINEA) ","TF","法屬南部屬地(FRENCH SOUTHERN TERRITORIES) "]
["PH","菲律賓(PHILIPPINES) ","TG","多哥(TOGO) "]
["PK","巴基斯坦(PAKISTAN) ","TH","泰國(THAILAND) "]
["PL","波蘭(POLAND) ","TJ","塔吉克(TAJIKISTAN) "]
["PM","聖匹及密啟倫群島(SAINT PIERRE AND MIQUELON) ","TK","托克勞群島(TOKELAU) "]
["PN","皮特康群島(PITCAIRN) ","TM","土庫曼(TURKMENISTAN) "]
["PR","波多黎各(PUERTO RICO) ","TN","突尼西亞(TUNISIA) "]
["PT","葡萄牙(PORTUGAL) ","TO","東加(TONGA) "]
["PT","葡萄牙(PORTUGAL) ","TP","帝汶(EAST TIMOR) "]
["PW","帛琉(PALAU) ","TR","土耳其(TURKIYE) "]
["PY","巴拉圭(PARAGUAY) ","TT","千里達─托貝哥(TRINIDAD AND TOBAGO) "]
["PZ","巴拿馬運河區(PANAMA CANAL ZONE) ","TV","吐瓦魯(TUVALU) "]
["QA","庫達﹝卡達﹞(QATAR) ","TW","中華民國(R.O.C.) "]
["RE","留尼旺(REUNION) ","TW","中華民國(TAIWAN) "]
["RO","羅馬尼亞(ROMANIA) ","TZ","坦尚尼亞(TANZANIA.UNITED REPUBLIC OF) "]
["RU","俄羅斯聯邦(RUSSIAN FEDERATION) ","UA","烏克蘭(UKRAINE) "]
["RW","盧安達(RWANDA) ","UG","烏干達(UGANDA) "]
["SA","沙烏地阿拉伯(SAUDI ARABIA) ","UM","美屬邊疆群島(UNITED STATES MINOR OUTLYING I) "]
["SB","索羅門群島(SOLOMON ISLANDS) ","US","美國(UNITED STATES) "]
["SC","塞席爾(SEYCHELLES) ","UY","烏拉圭(URUGUAY) "]
["SD","蘇丹(SUDAN) ","UZ","烏茲別克(UZBEKISTAN) "]
["SE","瑞典(SWEDEN) ","VA","教廷(HOLY SEE(VATICAN CITY STATE)) "]
["SE","瑞典(SWEDEN) ","VC","聖文森(SAINT VINCENT AND THE GRENADIN) "]
["SG","新加坡(SINGAPORE) ","VE","委內瑞拉(VENEZUELA) "]
["SH","聖赫勒拿島(SAINT HELENA) ","VG","英屬維爾京群島(VIRGIN ISLANDS.BRITISH) "]
["SI","斯洛伐尼亞(SLOVENIA) ","VI","美屬維爾京群島(VIRGIN ISLANDS U.S) "]
["SJ","斯瓦巴及尖棉島(SVALBARD AND JAN MAYEN ISLANDS) ","VN","越南(VIETNAM) "]
["SK","斯洛伐克(SLOVAKIA) ","VU","萬那杜(VANUATU) "]
["SL","獅子山(SIERRA LEONE) ","WF","沃里斯及伏塔那島(WALLIS AND FUTUNA ISLANDS) "]
["SM","聖馬利諾(SAN MARINO) ","WS","薩摩亞群島(SAMOA) "]
["SN","塞內加爾(SENEGAL) ","WS","薩摩亞群島(SAMOA) "]
["SO","索馬利亞(SOMALIA) ","XA","中華民國﹝ＯＢＵ﹞(TAIWAN(OBU)) "]
["SR","蘇利南(SURINAME) ","XB","ＡＴＭ提現鈔(XB) "]
["XC","國際機場結匯(XC) "]
["XD","其他亞洲地區(XD) "]
["XE","其他中東地區及近東地區(XE) "]
["XF","其他歐洲地區(XF) "]
["XG","其他非洲地區(XG) "]
["XH","其他北美洲地區(XH) "]
["XI","其他中美洲地區(XI) "]
["XJ","其他南美洲地區(XJ) "]
["XK","其他大洋洲地區(XK) "]
["YE","北葉門(YEMEN) "]
["YT","美亞特(MAYOTTE) "]
["YU","南斯拉夫(YUGOSLAVIA) "]
["ZA","南非共和國(SOUTH AFRICA) "]
["ZM","尚比亞(ZAMBIA) "]
["ZW","辛巴威﹝羅德西亞﹞(ZIMBABWE) "]