{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["薪資付款","匯款性質(Purpose of Payment)","parameter","操作說明(Instructions)"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":1,"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":7,"n_cols":15,"rows_kept":7,"cut":false,"hidden":false,"merged":[[2,0,2,6],[35,3,35,4],[36,3,36,4],[37,3,37,4],[38,3,38,4],[39,3,39,4],[30,3,30,4],[31,3,31,4],[32,3,32,4],[33,3,33,4],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4],[0,0,1,0],[4,3,4,4],[1,2,1,3],[0,2,0,3],[5,3,5,4],[3,3,3,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[19,3,19,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[49,3,49,4],[40,3,40,4],[41,3,41,4],[42,3,42,4],[43,3,43,4],[44,3,44,4],[56,3,56,4],[57,3,57,4],[58,3,58,4],[59,3,59,4],[50,3,50,4],[51,3,51,4],[52,3,52,4],[53,3,53,4],[54,3,54,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[23,3,23,4],[24,3,24,4],[55,3,55,4],[45,3,45,4],[46,3,46,4],[47,3,47,4],[48,3,48,4],[34,3,34,4],[25,3,25,4],[26,3,26,4],[27,3,27,4],[28,3,28,4],[29,3,29,4],[65,3,65,4],[66,3,66,4],[67,3,67,4],[68,3,68,4],[69,3,69,4],[60,3,60,4],[61,3,61,4],[62,3,62,4],[63,3,63,4],[64,3,64,4],[75,3,75,4],[76,3,76,4],[77,3,77,4],[78,3,78,4],[79,3,79,4],[70,3,70,4],[71,3,71,4],[72,3,72,4],[73,3,73,4],[74,3,74,4],[85,3,85,4],[86,3,86,4],[87,3,87,4],[88,3,88,4],[89,3,89,4],[80,3,80,4],[81,3,81,4],[82,3,82,4],[83,3,83,4],[84,3,84,4],[95,3,95,4],[96,3,96,4],[97,3,97,4],[98,3,98,4],[99,3,99,4],[90,3,90,4],[91,3,91,4],[92,3,92,4],[93,3,93,4],[94,3,94,4],[105,3,105,4],[106,3,106,4],[107,3,107,4],[108,3,108,4],[109,3,109,4],[100,3,100,4],[101,3,101,4],[102,3,102,4],[103,3,103,4],[104,3,104,4],[115,3,115,4],[116,3,116,4],[117,3,117,4],[118,3,118,4],[119,3,119,4],[110,3,110,4],[111,3,111,4],[112,3,112,4],[113,3,113,4],[114,3,114,4],[125,3,125,4],[126,3,126,4],[127,3,127,4],[128,3,128,4],[129,3,129,4],[120,3,120,4],[121,3,121,4],[122,3,122,4],[123,3,123,4],[124,3,124,4],[135,3,135,4],[136,3,136,4],[137,3,137,4],[138,3,138,4],[139,3,139,4],[130,3,130,4],[131,3,131,4],[132,3,132,4],[133,3,133,4],[134,3,134,4],[145,3,145,4],[146,3,146,4],[147,3,147,4],[148,3,148,4],[149,3,149,4],[140,3,140,4],[141,3,141,4],[142,3,142,4],[143,3,143,4],[144,3,144,4],[155,3,155,4],[156,3,156,4],[157,3,157,4],[158,3,158,4],[159,3,159,4],[150,3,150,4],[151,3,151,4],[152,3,152,4],[153,3,153,4],[154,3,154,4],[165,3,165,4],[166,3,166,4],[167,3,167,4],[168,3,168,4],[169,3,169,4],[160,3,160,4],[161,3,161,4],[162,3,162,4],[163,3,163,4],[164,3,164,4],[175,3,175,4],[176,3,176,4],[177,3,177,4],[178,3,178,4],[179,3,179,4],[170,3,170,4],[171,3,171,4],[172,3,172,4],[173,3,173,4],[174,3,174,4],[185,3,185,4],[186,3,186,4],[187,3,187,4],[188,3,188,4],[189,3,189,4],[180,3,180,4],[181,3,181,4],[182,3,182,4],[183,3,183,4],[184,3,184,4],[195,3,195,4],[196,3,196,4],[197,3,197,4],[198,3,198,4],[199,3,199,4],[190,3,190,4],[191,3,191,4],[192,3,192,4],[193,3,193,4],[194,3,194,4],[205,3,205,4],[206,3,206,4],[207,3,207,4],[208,3,208,4],[209,3,209,4],[200,3,200,4],[201,3,201,4],[202,3,202,4],[203,3,203,4],[204,3,204,4],[215,3,215,4],[216,3,216,4],[217,3,217,4],[218,3,218,4],[219,3,219,4],[210,3,210,4],[211,3,211,4],[212,3,212,4],[213,3,213,4],[214,3,214,4],[225,3,225,4],[226,3,226,4],[227,3,227,4],[228,3,228,4],[229,3,229,4],[220,3,220,4],[221,3,221,4],[222,3,222,4],[223,3,223,4],[224,3,224,4],[235,3,235,4],[236,3,236,4],[237,3,237,4],[238,3,238,4],[239,3,239,4],[230,3,230,4],[231,3,231,4],[232,3,232,4],[233,3,233,4],[234,3,234,4],[245,3,245,4],[246,3,246,4],[247,3,247,4],[248,3,248,4],[249,3,249,4],[240,3,240,4],[241,3,241,4],[242,3,242,4],[243,3,243,4],[244,3,244,4],[255,3,255,4],[256,3,256,4],[257,3,257,4],[258,3,258,4],[259,3,259,4],[250,3,250,4],[251,3,251,4],[252,3,252,4],[253,3,253,4],[254,3,254,4],[265,3,265,4],[266,3,266,4],[267,3,267,4],[268,3,268,4],[269,3,269,4],[260,3,260,4],[261,3,261,4],[262,3,262,4],[263,3,263,4],[264,3,264,4],[275,3,275,4],[276,3,276,4],[277,3,277,4],[278,3,278,4],[279,3,279,4],[270,3,270,4],[271,3,271,4],[272,3,272,4],[273,3,273,4],[274,3,274,4],[285,3,285,4],[286,3,286,4],[287,3,287,4],[288,3,288,4],[289,3,289,4],[280,3,280,4],[281,3,281,4],[282,3,282,4],[283,3,283,4],[284,3,284,4],[295,3,295,4],[296,3,296,4],[297,3,297,4],[298,3,298,4],[299,3,299,4],[290,3,290,4],[291,3,291,4],[292,3,292,4],[293,3,293,4],[294,3,294,4],[305,3,305,4],[306,3,306,4],[307,3,307,4],[308,3,308,4],[309,3,309,4],[300,3,300,4],[301,3,301,4],[302,3,302,4],[303,3,303,4],[304,3,304,4],[315,3,315,4],[316,3,316,4],[317,3,317,4],[318,3,318,4],[319,3,319,4],[310,3,310,4],[311,3,311,4],[312,3,312,4],[313,3,313,4],[314,3,314,4],[325,3,325,4],[326,3,326,4],[327,3,327,4],[328,3,328,4],[329,3,329,4],[320,3,320,4],[321,3,321,4],[322,3,322,4],[323,3,323,4],[324,3,324,4],[335,3,335,4],[336,3,336,4],[337,3,337,4],[338,3,338,4],[339,3,339,4],[330,3,330,4],[331,3,331,4],[332,3,332,4],[333,3,333,4],[334,3,334,4],[345,3,345,4],[346,3,346,4],[347,3,347,4],[348,3,348,4],[349,3,349,4],[340,3,340,4],[341,3,341,4],[342,3,342,4],[343,3,343,4],[344,3,344,4],[355,3,355,4],[356,3,356,4],[357,3,357,4],[358,3,358,4],[359,3,359,4],[350,3,350,4],[351,3,351,4],[352,3,352,4],[353,3,353,4],[354,3,354,4],[365,3,365,4],[366,3,366,4],[367,3,367,4],[368,3,368,4],[369,3,369,4],[360,3,360,4],[361,3,361,4],[362,3,362,4],[363,3,363,4],[364,3,364,4],[375,3,375,4],[376,3,376,4],[377,3,377,4],[378,3,378,4],[379,3,379,4],[370,3,370,4],[371,3,371,4],[372,3,372,4],[373,3,373,4],[374,3,374,4],[385,3,385,4],[386,3,386,4],[387,3,387,4],[388,3,388,4],[389,3,389,4],[380,3,380,4],[381,3,381,4],[382,3,382,4],[383,3,383,4],[384,3,384,4],[395,3,395,4],[396,3,396,4],[397,3,397,4],[398,3,398,4],[399,3,399,4],[390,3,390,4],[391,3,391,4],[392,3,392,4],[393,3,393,4],[394,3,394,4],[405,3,405,4],[406,3,406,4],[407,3,407,4],[408,3,408,4],[409,3,409,4],[400,3,400,4],[401,3,401,4],[402,3,402,4],[403,3,403,4],[404,3,404,4],[415,3,415,4],[416,3,416,4],[417,3,417,4],[418,3,418,4],[419,3,419,4],[410,3,410,4],[411,3,411,4],[412,3,412,4],[413,3,413,4],[414,3,414,4],[425,3,425,4],[426,3,426,4],[427,3,427,4],[428,3,428,4],[429,3,429,4],[420,3,420,4],[421,3,421,4],[422,3,422,4],[423,3,423,4],[424,3,424,4],[435,3,435,4],[436,3,436,4],[437,3,437,4],[438,3,438,4],[439,3,439,4],[430,3,430,4],[431,3,431,4],[432,3,432,4],[433,3,433,4],[434,3,434,4],[445,3,445,4],[446,3,446,4],[447,3,447,4],[448,3,448,4],[449,3,449,4],[440,3,440,4],[441,3,441,4],[442,3,442,4],[443,3,443,4],[444,3,444,4],[455,3,455,4],[456,3,456,4],[457,3,457,4],[458,3,458,4],[459,3,459,4],[450,3,450,4],[451,3,451,4],[452,3,452,4],[453,3,453,4],[454,3,454,4],[465,3,465,4],[466,3,466,4],[467,3,467,4],[468,3,468,4],[469,3,469,4],[460,3,460,4],[461,3,461,4],[462,3,462,4],[463,3,463,4],[464,3,464,4],[475,3,475,4],[476,3,476,4],[477,3,477,4],[478,3,478,4],[479,3,479,4],[470,3,470,4],[471,3,471,4],[472,3,472,4],[473,3,473,4],[474,3,474,4],[485,3,485,4],[486,3,486,4],[487,3,487,4],[488,3,488,4],[489,3,489,4],[480,3,480,4],[481,3,481,4],[482,3,482,4],[483,3,483,4],[484,3,484,4],[495,3,495,4],[496,3,496,4],[497,3,497,4],[498,3,498,4],[499,3,499,4],[490,3,490,4],[491,3,491,4],[492,3,492,4],[493,3,493,4],[494,3,494,4],[505,3,505,4],[506,3,506,4],[507,3,507,4],[508,3,508,4],[509,3,509,4],[500,3,500,4],[501,3,501,4],[502,3,502,4],[503,3,503,4],[504,3,504,4],[515,3,515,4],[516,3,516,4],[517,3,517,4],[518,3,518,4],[519,3,519,4],[510,3,510,4],[511,3,511,4],[512,3,512,4],[513,3,513,4],[514,3,514,4],[525,3,525,4],[526,3,526,4],[527,3,527,4],[528,3,528,4],[529,3,529,4],[520,3,520,4],[521,3,521,4],[522,3,522,4],[523,3,523,4],[524,3,524,4],[535,3,535,4],[536,3,536,4],[537,3,537,4],[538,3,538,4],[539,3,539,4],[530,3,530,4],[531,3,531,4],[532,3,532,4],[533,3,533,4],[534,3,534,4],[545,3,545,4],[546,3,546,4],[547,3,547,4],[548,3,548,4],[549,3,549,4],[540,3,540,4],[541,3,541,4],[542,3,542,4],[543,3,543,4],[544,3,544,4],[555,3,555,4],[556,3,556,4],[557,3,557,4],[558,3,558,4],[559,3,559,4],[550,3,550,4],[551,3,551,4],[552,3,552,4],[553,3,553,4],[554,3,554,4],[565,3,565,4],[566,3,566,4],[567,3,567,4],[568,3,568,4],[569,3,569,4],[560,3,560,4],[561,3,561,4],[562,3,562,4],[563,3,563,4],[564,3,564,4],[575,3,575,4],[576,3,576,4],[577,3,577,4],[578,3,578,4],[579,3,579,4],[570,3,570,4],[571,3,571,4],[572,3,572,4],[573,3,573,4],[574,3,574,4],[585,3,585,4],[586,3,586,4],[587,3,587,4],[588,3,588,4],[589,3,589,4],[580,3,580,4],[581,3,581,4],[582,3,582,4],[583,3,583,4],[584,3,584,4],[595,3,595,4],[596,3,596,4],[597,3,597,4],[598,3,598,4],[599,3,599,4],[590,3,590,4],[591,3,591,4],[592,3,592,4],[593,3,593,4],[594,3,594,4],[605,3,605,4],[606,3,606,4],[607,3,607,4],[608,3,608,4],[609,3,609,4],[600,3,600,4],[601,3,601,4],[602,3,602,4],[603,3,603,4],[604,3,604,4],[615,3,615,4],[616,3,616,4],[617,3,617,4],[618,3,618,4],[619,3,619,4],[610,3,610,4],[611,3,611,4],[612,3,612,4],[613,3,613,4],[614,3,614,4],[625,3,625,4],[626,3,626,4],[627,3,627,4],[628,3,628,4],[629,3,629,4],[620,3,620,4],[621,3,621,4],[622,3,622,4],[623,3,623,4],[624,3,624,4],[635,3,635,4],[636,3,636,4],[637,3,637,4],[638,3,638,4],[639,3,639,4],[630,3,630,4],[631,3,631,4],[632,3,632,4],[633,3,633,4],[634,3,634,4],[645,3,645,4],[646,3,646,4],[647,3,647,4],[648,3,648,4],[649,3,649,4],[640,3,640,4],[641,3,641,4],[642,3,642,4],[643,3,643,4],[644,3,644,4],[655,3,655,4],[656,3,656,4],[657,3,657,4],[658,3,658,4],[659,3,659,4],[650,3,650,4],[651,3,651,4],[652,3,652,4],[653,3,653,4],[654,3,654,4],[665,3,665,4],[666,3,666,4],[667,3,667,4],[668,3,668,4],[669,3,669,4],[660,3,660,4],[661,3,661,4],[662,3,662,4],[663,3,663,4],[664,3,664,4],[675,3,675,4],[676,3,676,4],[677,3,677,4],[678,3,678,4],[679,3,679,4],[670,3,670,4],[671,3,671,4],[672,3,672,4],[673,3,673,4],[674,3,674,4],[685,3,685,4],[686,3,686,4],[687,3,687,4],[688,3,688,4],[689,3,689,4],[680,3,680,4],[681,3,681,4],[682,3,682,4],[683,3,683,4],[684,3,684,4],[695,3,695,4],[696,3,696,4],[697,3,697,4],[698,3,698,4],[699,3,699,4],[690,3,690,4],[691,3,691,4],[692,3,692,4],[693,3,693,4],[694,3,694,4],[705,3,705,4],[706,3,706,4],[707,3,707,4],[708,3,708,4],[709,3,709,4],[700,3,700,4],[701,3,701,4],[702,3,702,4],[703,3,703,4],[704,3,704,4],[715,3,715,4],[716,3,716,4],[717,3,717,4],[718,3,718,4],[719,3,719,4],[710,3,710,4],[711,3,711,4],[712,3,712,4],[713,3,713,4],[714,3,714,4],[725,3,725,4],[726,3,726,4],[727,3,727,4],[728,3,728,4],[729,3,729,4],[720,3,720,4],[721,3,721,4],[722,3,722,4],[723,3,723,4],[724,3,724,4],[735,3,735,4],[736,3,736,4],[737,3,737,4],[738,3,738,4],[739,3,739,4],[730,3,730,4],[731,3,731,4],[732,3,732,4],[733,3,733,4],[734,3,734,4],[745,3,745,4],[746,3,746,4],[747,3,747,4],[748,3,748,4],[749,3,749,4],[740,3,740,4],[741,3,741,4],[742,3,742,4],[743,3,743,4],[744,3,744,4],[755,3,755,4],[756,3,756,4],[757,3,757,4],[758,3,758,4],[759,3,759,4],[750,3,750,4],[751,3,751,4],[752,3,752,4],[753,3,753,4],[754,3,754,4],[765,3,765,4],[766,3,766,4],[767,3,767,4],[768,3,768,4],[769,3,769,4],[760,3,760,4],[761,3,761,4],[762,3,762,4],[763,3,763,4],[764,3,764,4],[775,3,775,4],[776,3,776,4],[777,3,777,4],[778,3,778,4],[779,3,779,4],[770,3,770,4],[771,3,771,4],[772,3,772,4],[773,3,773,4],[774,3,774,4],[785,3,785,4],[786,3,786,4],[787,3,787,4],[788,3,788,4],[789,3,789,4],[780,3,780,4],[781,3,781,4],[782,3,782,4],[783,3,783,4],[784,3,784,4],[795,3,795,4],[796,3,796,4],[797,3,797,4],[798,3,798,4],[799,3,799,4],[790,3,790,4],[791,3,791,4],[792,3,792,4],[793,3,793,4],[794,3,794,4],[805,3,805,4],[806,3,806,4],[807,3,807,4],[808,3,808,4],[809,3,809,4],[800,3,800,4],[801,3,801,4],[802,3,802,4],[803,3,803,4],[804,3,804,4],[815,3,815,4],[816,3,816,4],[817,3,817,4],[818,3,818,4],[819,3,819,4],[810,3,810,4],[811,3,811,4],[812,3,812,4],[813,3,813,4],[814,3,814,4],[825,3,825,4],[826,3,826,4],[827,3,827,4],[828,3,828,4],[829,3,829,4],[820,3,820,4],[821,3,821,4],[822,3,822,4],[823,3,823,4],[824,3,824,4],[835,3,835,4],[836,3,836,4],[837,3,837,4],[838,3,838,4],[839,3,839,4],[830,3,830,4],[831,3,831,4],[832,3,832,4],[833,3,833,4],[834,3,834,4],[845,3,845,4],[846,3,846,4],[847,3,847,4],[848,3,848,4],[849,3,849,4],[840,3,840,4],[841,3,841,4],[842,3,842,4],[843,3,843,4],[844,3,844,4],[855,3,855,4],[856,3,856,4],[857,3,857,4],[858,3,858,4],[859,3,859,4],[850,3,850,4],[851,3,851,4],[852,3,852,4],[853,3,853,4],[854,3,854,4],[865,3,865,4],[866,3,866,4],[867,3,867,4],[868,3,868,4],[869,3,869,4],[860,3,860,4],[861,3,861,4],[862,3,862,4],[863,3,863,4],[864,3,864,4],[875,3,875,4],[876,3,876,4],[877,3,877,4],[878,3,878,4],[879,3,879,4],[870,3,870,4],[871,3,871,4],[872,3,872,4],[873,3,873,4],[874,3,874,4],[885,3,885,4],[886,3,886,4],[887,3,887,4],[888,3,888,4],[889,3,889,4],[880,3,880,4],[881,3,881,4],[882,3,882,4],[883,3,883,4],[884,3,884,4],[895,3,895,4],[896,3,896,4],[897,3,897,4],[898,3,898,4],[899,3,899,4],[890,3,890,4],[891,3,891,4],[892,3,892,4],[893,3,893,4],[894,3,894,4],[905,3,905,4],[906,3,906,4],[907,3,907,4],[908,3,908,4],[909,3,909,4],[900,3,900,4],[901,3,901,4],[902,3,902,4],[903,3,903,4],[904,3,904,4],[915,3,915,4],[916,3,916,4],[917,3,917,4],[918,3,918,4],[919,3,919,4],[910,3,910,4],[911,3,911,4],[912,3,912,4],[913,3,913,4],[914,3,914,4],[925,3,925,4],[926,3,926,4],[927,3,927,4],[928,3,928,4],[929,3,929,4],[920,3,920,4],[921,3,921,4],[922,3,922,4],[923,3,923,4],[924,3,924,4],[935,3,935,4],[936,3,936,4],[937,3,937,4],[938,3,938,4],[939,3,939,4],[930,3,930,4],[931,3,931,4],[932,3,932,4],[933,3,933,4],[934,3,934,4],[945,3,945,4],[946,3,946,4],[947,3,947,4],[948,3,948,4],[949,3,949,4],[940,3,940,4],[941,3,941,4],[942,3,942,4],[943,3,943,4],[944,3,944,4],[955,3,955,4],[956,3,956,4],[957,3,957,4],[958,3,958,4],[959,3,959,4],[950,3,950,4],[951,3,951,4],[952,3,952,4],[953,3,953,4],[954,3,954,4],[965,3,965,4],[966,3,966,4],[967,3,967,4],[968,3,968,4],[969,3,969,4],[960,3,960,4],[961,3,961,4],[962,3,962,4],[963,3,963,4],[964,3,964,4],[975,3,975,4],[976,3,976,4],[977,3,977,4],[978,3,978,4],[979,3,979,4],[970,3,970,4],[971,3,971,4],[972,3,972,4],[973,3,973,4],[974,3,974,4],[985,3,985,4],[986,3,986,4],[987,3,987,4],[988,3,988,4],[989,3,989,4],[980,3,980,4],[981,3,981,4],[982,3,982,4],[983,3,983,4],[984,3,984,4],[995,3,995,4],[996,3,996,4],[997,3,997,4],[998,3,998,4],[999,3,999,4],[990,3,990,4],[991,3,991,4],[992,3,992,4],[993,3,993,4]],"merged_total":1001,"flags":["merged_cut"]}
["說明 (橘色為必填資訊) \nRemark (orange fields are mandatory)","交易生效日\nPayment date (DDMMYYYY)","付款人扣款帳號\n(一個檔案限用一個扣款帳號)\nDebit Account Number (One file for one debit account)",null,"付款人公司編號\nOrg ID","付款人戶名\nPayer Name","總筆數\nToal number of transaction",null,null,{"$f":"SUMIF(A:A,\"Y\",F:F)","v":31},"SAL"]
[null,"10012022","300001XXXXX",null,"TWGTS","GTS OF DBS TW",{"$f":"COUNTIF(A:A,\"Y\")","v":3}]
["上方  付款人資訊 (Above: Payer Information)      下方 受款人資訊 (Below: Beneficiary Information)"]
["\n資料欄位\nData","銀行代碼\nBank Code","分行代碼\nBranch Code","受款人帳號\nBeneficiary Account Number",null,"匯款金額\nAmount","受款人戶名 \nBeneficiary Name ","手續費\n付款方\nBank Charge",null,"客戶參考編號\nCustomer Reference","Batch ID","付款明細\nPayment Details (78 characters)","受款人通知(電子郵件)\nBeneficiary Advice (email)","發票明細\nInvoice Details","受款人參考編號Payee Reference"]
["Y","822","0023","1234567890",null,10,"Jesse Niu","OUR",null,null,null,null,"demileecc@dbs.com","Bonus","Ref1"]
["Y","810","0012","123213213",null,20,"陳天天","OUR",null,null,null,null,null,null,"Ref2"]
["Y","812","0023","145353",null,1,"Demi","OUR",null,null,null,null,null,null,"Ref2"]

{"sheet":"匯款性質(Purpose of Payment)","index":1,"n_rows":212,"n_cols":4,"rows_kept":212,"cut":false,"hidden":true,"merged":[[7,1,8,1],[9,1,10,1],[11,1,12,1],[3,1,4,1],[5,1,6,1],[21,1,22,1],[23,1,24,1],[25,1,26,1],[13,1,14,1],[15,1,16,1],[17,1,18,1],[19,1,20,1],[33,1,34,1],[35,1,36,1],[37,1,38,1],[27,1,28,1],[29,1,30,1],[31,1,32,1],[64,0,65,0],[64,1,65,1],[39,1,40,1],[41,0,42,0],[41,1,42,1],[43,0,44,0],[43,1,44,1],[45,0,46,0],[45,1,46,1],[47,0,48,0],[47,1,48,1],[49,0,50,0],[49,1,50,1],[51,0,52,0],[51,1,52,1],[53,0,54,0],[53,1,54,1],[55,0,56,0],[55,1,56,1],[58,0,59,0],[58,1,59,1],[60,0,61,0],[60,1,61,1],[62,0,63,0],[62,1,63,1],[88,0,89,0],[88,1,89,1],[90,0,91,0],[90,1,91,1],[66,0,67,0],[66,1,67,1],[68,0,69,0],[68,1,69,1],[70,0,71,0],[70,1,71,1],[72,0,73,0],[72,1,73,1],[74,0,75,0],[74,1,75,1],[76,0,77,0],[76,1,77,1],[78,1,79,1],[80,0,81,0],[80,1,81,1],[82,0,83,0],[82,1,83,1],[84,0,85,0],[84,1,85,1],[86,0,87,0],[86,1,87,1],[116,0,117,0],[116,1,117,1],[92,0,93,0],[92,1,93,1],[94,0,95,0],[94,1,95,1],[96,0,97,0],[96,1,97,1],[102,0,103,0],[102,1,103,1],[104,0,105,0],[104,1,105,1],[100,1,101,1],[98,0,99,0],[98,1,99,1],[106,0,107,0],[106,1,107,1],[108,0,109,0],[108,1,109,1],[110,0,111,0],[110,1,111,1],[112,0,113,0],[112,1,113,1],[114,0,115,0],[114,1,115,1],[128,3,129,3],[130,0,131,0],[130,1,131,1],[118,0,119,0],[118,1,119,1],[120,0,121,0],[120,1,121,1],[122,0,123,0],[122,1,123,1],[124,0,125,0],[150,0,151,0],[150,1,151,1],[140,0,141,0],[140,1,141,1],[142,0,143,0],[142,1,143,1],[144,0,145,0],[144,1,145,1],[124,1,125,1],[126,1,127,1],[128,1,129,1],[146,0,147,0],[146,1,147,1],[148,0,149,0],[148,1,149,1],[132,1,133,1],[134,1,135,1],[136,0,137,0],[136,1,137,1],[138,0,139,0],[138,1,139,1],[158,0,159,0],[158,1,159,1],[160,0,161,0],[160,1,161,1],[152,1,153,1],[154,0,155,0],[154,1,155,1],[156,0,157,0],[156,1,157,1],[180,0,181,0],[180,1,181,1],[182,1,183,1],[168,0,169,0],[168,1,169,1],[170,0,171,0],[170,1,171,1],[162,0,163,0],[162,1,163,1],[164,1,165,1],[210,0,211,0],[210,1,211,1],[0,0,0,3],[204,0,205,0],[204,1,205,1],[206,1,207,1],[206,3,207,3],[208,0,209,0],[208,1,209,1],[198,0,199,0],[172,1,173,1],[174,0,175,0],[174,1,175,1],[176,0,177,0],[176,1,177,1],[178,0,179,0],[178,1,179,1],[164,3,165,3],[166,1,167,1],[166,3,167,3],[188,0,189,0],[188,1,189,1],[190,0,191,0],[190,1,191,1],[184,3,185,3],[186,0,187,0],[186,1,187,1],[198,1,199,1],[200,0,201,0],[200,1,201,1],[184,1,185,1],[202,1,203,1],[202,3,203,3],[192,0,193,0],[192,1,193,1],[194,0,195,0],[194,1,195,1],[196,1,197,1],[196,3,197,3]]}
["匯出匯款之分類及說明\nCode and Description of Outward Remittance Classification"]
["大項","分類編號","項     目","說                     明"]
["Category","Code","Item","Description"]
["一",null,"服務支出","分為運輸、保險、旅行及其他四大項。"]
[null,null,"Service expenditures","Classified into four categories –transportation, insurance, travel and others"]
["(一)",null,"運輸支出","居民支付非居民海陸空之客貨運輸支出，分為下列各項："]
[null,null,"Transportation expenditures","Payments to non-residents by residents for transportation service by sea, land and air:"]
[null,111,"海運貨運費支出","支付海上貨物運輸費用。"]
[null,null,"Cargo shipping expenditures","To pay for cargo shipping service."]
[null,112,"海運客運費支出","支付海上旅客運輸費用。"]
[null,null,"Passenger shipping expenditures","To pay for passenger shipping service."]
[null,115,"航空貨運費支出","支付航空貨物運輸費用。"]
[null,null,"Airfreight expenditures","To pay for airfreight service."]
[null,116,"航空客運費支出","支付航空旅客運輸費用。"]
[null,null,"Air passenger service expenditures","To pay for airline passenger service."]
[null,119,"其他運輸支出","上述各項以外之運輸支出，請詳述性質，如陸路運輸、貨物裝卸、倉儲、港口機場費用、客貨運有關的佣金及代理費等支出。"]
[null,null,"Other transportation-related expenditures","Transportation expenditures other than those items described above (please specify the purpose (residents)/source (non-residents) of payment), such as expenditures incurred from land transportation, loading/unloading, warehousing, harbor/airport fees, commissions and agency fees related to cargo and passenger transportation."]
["(二)",null,"保險支出","各種保險之保費、再保費及保險業之理賠支出，分為下列各項："]
[null,null,"Insurance expenditures","Insurance premiums, reinsurance fees, and insurance claims, which are classified as follows:"]
[null,121,"財產保險支出","居民投保財產保險之保費及再保費支出。"]
[null,null,"Non-life insurance expenditures","Residents paying for non-life insurance premiums and reinsurance fees."]
[null,122,"財產保險理賠支出","居民承保財產保險及再保險所支付之保險賠款與給付(包括透過保險經紀人安排者)。若非因保險之損害賠償或撫恤金等，請填報(599)「其他移轉支出」。"]
[null,null,"Payments for non-life insurance claim","Claims and benefits paid by residents for non-life insurance and reinsurance underwritten (including underwriting arranged through insurance brokers).  For non-insurance related indemnities or relief payments, fill in“599” – Other transfer payments."]
[null,123,"人身保險支出","居民投保人身保險之保費及再保費支出。"]
[null,null,"Life insurance expenditures","Residents paying for life insurance premiums and reinsurance fees."]
[null,129,"人身保險理賠支出","居民承保人身保險及再保險所支付之保險賠款與給付(包括透過保險經紀人安排者)。若非因保險之損害賠償或撫恤金等，請填報(599)「其他移轉支出」。"]
[null,null,"Payments for life insurance claim","Claims and benefits paid by residents for life insurance and reinsurance underwritten (including underwriting arranged through insurance brokers).  For non-insurance related indemnities or consolation payments, fill in “599” – Other transfer payments."]
["(三)",null,"旅行支出","居民出國旅行支出或在國外短期居留（未滿一年）之支出（不含進出國境之機船票款，該款項請列入運輸支出），分為下列各項："]
[null,null,"Traveling expenditures","Expenditures of residents incurred from traveling abroad or short stay abroad (less than one year) (excluding cross-border air fare and steamer ticket which should be classified as transportation expenditures), which are classified as follows:"]
[null,131,"商務支出","居民出國洽辦商務之旅費支出。"]
[null,null,"Business expenditures","Traveling expenditures of residents taking business trips abroad."]
[null,132,"觀光支出","居民出國觀光旅費支出，含旅行社團費、遊學等。"]
[null,null,"Tourism expenditures","Traveling expenditures of residents for tours abroad, including charges of the traveling agency and short-term course."]
[null,134,"留學支出","居民留學（居留國外可一年以上）之學費及生活費。"]
[null,null,"Expenditures of studying abroad","Residents paying for the tuition and living expenditures of students studying abroad (including students staying abroad for more than one year)."]
[null,135,"信用卡支出","居民在國外之信用卡、金融卡消費支出。"]
[null,null,"Credit card payment","Residents paying for credit cards or debit cards charges incurred abroad."]
[null,139,"其他旅行支出","上述各項以外之旅行支出，請詳述性質，如講學、就醫（居留國外可一年以上）、競賽等。"]
[null,null,"Other traveling expenditures","Traveling expenditures other than those described above (please specify the purpose of payment), such as giving lectures, seeking medical treatments (including expenditures of those staying abroad for more than one year), or participating in tournaments or contests. "]
["(四)",null,"運保費及旅行以外之其他服務支出","分為下列各項："]
[null,null,"Other service expenditures for services other than those of transportation, insurance and traveling","Classified into the following items:"]
[null,191,"文化及休閒支出","居民支付國外所提供博物館及其他文化、體育與休閒娛樂有關的活動支出，包括函授課程及遠距教學費用。"]
[null,null,"Cultural and leisure expenditures","Expenditures incurred by residents for museum visits and other culture, sports, leisure and entertainment related activities provided abroad, including expenditures of correspondence and distance learning courses. "]
[null,192,"貿易佣金及代理費支出","居民支付國外所提供與貿易有關的服務之佣金及代理費用。"]
[null,null,"Trade commission and agency expenditures","Residents paying for commissions and agency fees for trade-related services provided abroad."]
[null,193,"營建支出","居民支付非居民承包國內營建工程(包括建築及土木工程之興建、修繕、土地整理及其相關之管線、系統工程的安裝及建案管理)的支出，或居民承包國外工程匯出支付在國外採購的商品及服務支出。若屬建築設計支出請填報(19D)「專業技術事務支出」。"]
[null,null,"Payments related to local construction project","Residents paying non-resident contractors of local construction projects (including construction, repair, and land consolidation services for buildings and civil engineering projects, related pipeline and system installation, and project management services), or residents paying for purchase of products and services abroad in connection with overseas contracted project.  For architectural design expenditures, fill in “19D” - Professional and technical service expenditures."]
[null,194,"金融服務支出","居民支付國外為辦理各種金融業務(如外匯交易、證券交易、衍生金融商品交易、資產管理、代客金融操作與證券保管等服務)所產生的手續費及佣金支出。"]
[null,null,"Financial service expenditures","Residents paying for fees and commissions for financial services (e.g. transactions of foreign exchange, securities, and financial derivatives, asset management, discretionary account services, and securities custody services) provided by a foreign company or individual. "]
[null,195,"使用智慧財產權支出","居民支付使用國外智慧財產權(例如專利權、商標、經銷權、版權、著作權或工業製程與設計等)之費用，包括影視、廣播及音樂等播送權或重製權所支付之權利金。若係購買智慧財產權，請按交易性質分別填報(19P)「購買研發成果資產之支出」或(540)「購買自然資源與非研發成果資產支出」。"]
[null,null,"Payments for authorized use of intellectual property rights","Residents paying for expenditures incurred from the use of foreign intellectual property rights (e.g. patents, trademarks, distribution rights, publication rights, copyrights or industrial processes and designs), including royalties paid for the right to broadcast or reproduce film, television, radio and musical productions. For the purchase of intellectual property rights, fill in“19P” –R&D assets purchase expenditures or “540”- Natural resources and non- R&D assets purchase expenditures”, depending on the nature of transaction."]
[null,196,"我國民間機構在國外辦公費用","居民支付在國外非營利組織或無營利事業登記之分支機構、辦事處或聯絡處之辦公費用(包括派駐國外人員薪資)。若為當地雇員薪資，請填報(410)「非居民薪資匯出」。"]
[null,null,"Overseas office expenses","Residents paying for office expenses (including wages and salaries of employees stationed abroad) of a non-profit organization, or a branch office, a representative office or a liaison office that without business registration abroad.  For wages and salaries of local employees, fill in “410” - Outward remittance of non-resident’s wages and salaries."]
[null,"19A","郵務與快遞支出","居民使用國外郵務與快遞服務支出。"]
[null,null,"Postal and courier service expenses","Residents paying for postal and courier services abroad."]
[null,"19B","電腦與資訊支出","居民支付國外提供的電腦、資訊與新聞相關之服務，包括一、支付國外有關電腦軟硬體的開發、設計、諮詢、管理、安裝、資料處理及相關設備維修的費用。二、使用國外資料庫、圖書館及檔案管理等服務的費用。三、向國外訂購報紙、期刊及書籍（未經進口報關）的支出。四、支付國外新聞代理、照片和報導的費用。"]
[null,null,"Computer and information expenditures","Residents paying for computer, information and news related services provided abroad, including 1. Expenditures for the development of software and hardware, design, consultation, management, installation, data processing, and maintenance of related computer equipment; 2. Expenditures for the use of foreign database, library and file management services; 3. Expenditures for the subscription of newspapers, journals, and books (not by customs declaration); and 4. Expenditures for overseas news agencies, photos and reports."]
[]
[null,"19C","營業租賃支出","居民租用國外營運器具所支付的租金（如運輸設備租金支出），惟資本租賃除外。"]
[null,null,"Leasing expenditures","Residents paying for rental for the leasing of operating facilities (such as leasing of transportation equipment), but excluding capital leasing."]
[null,"19D","專業技術事務支出","居民支付國外有關法律、會計、管理顧問、公關、廣告、市場調查、民意測驗、商業展覽、公證、檢驗及建築設計等服務之支出，包括董監事酬勞。"]
[null,null,"Professional and technical service expenditures","Residents paying for professional services such as legal, accountant, management consultant, public relations, advertising, market survey, poll, commercial exhibition, public notary, examination, architectural design, etc., including remuneration of directors and supervisors."]
[null,"19E","視聽支出","居民支付國外製作及演出影視、廣播與音樂等報酬，或支付自國外下載影音及收看頻道的費用。若屬前述視聽播送權或重製權之權利金費用，請填報(195)「使用智慧財產權支出」。"]
[null,null,"Video-audio expenditures","Residents paying for remuneration for film, television, radio and musical productions and performances abroad, or for expenses incurred in video/audio downloads, and channel rental; for royalties paid for the right to broadcast or reproduce video/audio productions described above, fill in“195”- Payments for authorized use of intellectual property. "]
[null,"19F","外國政府機構之服務收入匯出款","外國使領館及其他政府機構在台收取的領事簽證費、規費，及居民自行支付外國政府簽證費、規費的匯出。"]
[null,null,"Outward remittance of service income of foreign government agency","Outward remittance of visa fees and service fees received by foreign consulates in the R.O.C., and payment of visa fees and service fees to foreign government by residents."]
[null,"19G","軍政機關其他服務支出","上述各項以外之我軍政機關服務支出，包括匯往我駐外單位之款項(含派駐人員薪資)。若為當地雇員薪資，請填報(410)「非居民薪資匯出」。軍政機關如有旅行或對外採購軍品物資等非屬本項支出，應填相關之匯款分類。"]
[null,null,"Other service expenditures of civil or military organs","Payments for services other than those described above by civil or military organs, including money remitted to government’s representative offices abroad (including wages and salaries of employees stationed abroad).  For wages and salaries of local employees, fill in “410” - Outward remittance of non-resident’s wages and salaries. Other expenditures of civil or military organs not included under this item, such as expenses of traveling or purchase of military supply should be put down relevant remittance code."]
[null,"19H","加工費支出","居民支付國外加工、組裝服務之費用。"]
[null,null,"Processing fee expenditures","Residents paying for processing and assembly services provided abroad. "]
[null,"19J","電信支出","居民支付國外電信服務之費用。"]
[null,null,"Telecommunication expenditures","Residents paying for telecommunication services provided abroad."]
[null,"19K","維修支出","居民支付國外維修服務之費用，如船舶、航空器及其他運輸工具之維修，但建築或電腦的維修請分別填報(193)「營建支出」及(19B)「電腦與資訊支出」。"]
[null,null,"Repair/maintenance expenditures","Residents paying for repair/maintenance services provided abroad, such as repair/maintenance of ships, aircrafts and other transportation vehicles.  For repair/maintenance of buildings or computers, fill in“193” - Payments related to local construction project or “19B” - Computer and information expenditures."]
[null,"19P","購買研發成果資產之支出","居民購買國外的研發成果所有權(例如專利權、版權、工業製程與設計等)之支出。若購買品牌、商標、經銷權等請填報(540)「購買自然資源與非研發成果資產支出」；若係支付國外使用研發成果之支出，請填報(195)「使用智慧財產權支出」。"]
[null,null,"R&D asset purchase expenditures","Residents paying for acquisition of R&D asset ownership (e.g. patents, publication rights, industrial processes and designs, etc.).  For purchase of trade names, trademarks or distribution rights, fill in “540” - Natural resources and non- R&D assets purchase expenditures.  For expenses incurred in the use of foreign R&D assets, fill in “195” - Payments for authorized use of intellectual property rights. "]
[null,199,"其他服務支出","上述各項以外的無相關主體項目(如服裝設計費)之服務支出，請詳述性質。若有主體項目則歸入前述各項，如建築設計支出請填報(19D)「專業技術事務支出」。"]
[null,null,"Other service expenditures","Payments for services other than those described above and not relating to any subject matter project (e.g. fashion design fee), specify the purpose (residents)/source (non-residents) of payment. If there is a subject matter project, put the payment under relevant items described above. For example, for architectural design expenses, fill in “19D”- Professional and technical service expenditures.  "]
["二",null,"本國資金流出","分為下列各項："]
[null,null,"Outflow of domestic funds","Classified into the following items:"]
[null,210,"對外股本投資","居民直接投資國外事業之股本，包括股本轉讓及分公司營運資金。"]
[null,null,"Outward direct investments","Resident’s direct investments in the capital stock of a foreign business, including the transfer of capital stock and operating funds of branch offices."]
[null,220,"對外貸款投資","居民對其在國外直接投資事業之貸款。"]
[null,null,"Outward loan investments","Residents’ loans to their direct overseas investments."]
[null,250,"存放國外銀行","居民存放資金於國外銀行。匯款時可決定嗣後在國外之用途者不得列入本項，應依其用途作適當的分類。"]
[null,null,"Deposits overseas","Funds deposited overseas by residents.  The remittance should be put under the proper item instead of this item if subsequent use of the funds abroad is decided at the time of remittance. "]
[null,262,"投資國外股權證券","居民投資國外股份、股票、權證、存託憑證、共同基金及投資信託之資金。"]
[null,null,"Investments in overseas equity stocks","Residents’ investments (principal) in overseas shareholdings, stocks, warrants, depository receipts, mutual funds and investment trusts."]
[null,263,"投資國外長期債票券","居民投資國外長期（發行期限超過一年）債票券。若為居民投資非居民在台發行長期債票券，請填報(282)「外人在台發行長期債票券」。"]
[null,null,"Investments in overseas long-term bonds and notes","Residents’ investments (principal) in overseas long-term bonds and notes (with an original maturity longer than one year).  In case of residents investing in long-term bonds and notes issued by non-residents in the R.O.C., fill in“282” - Issuance of long-term bonds and notes in the R.O.C. by overseas nationals."]
[null,264,"投資國外短期債票券","居民投資國外短期（發行期限一年及一年以下）債票券。"]
[null,null,"Investments in overseas short-term notes and bills","Resident’s investments in overseas short-term notes and bills (with an original maturity of one year or less)."]
[null,266,"國外有本金交割的遠匯及換匯之資金匯出","居民支付國外有本金交割的外匯遠期及換匯之資金；但與國內銀行交易者不得列入本項，請依性質列入「其他匯出款—國內交易」之相關細項。"]
[null,null,"Outward remittance of funds for overseas deliverable forward and swap transactions","Residents paying for overseas deliverable forward (DF) foreign exchange and swap transactions.  Funds remitted for transactions with domestic banks may not be put under this item but under the related sub-item of “Other outward remittances –Domestic transactions” based on the nature of remittance."]
[null,267,"國外無本金交割的衍生金融商品之資金匯出","居民支付與非居民有本金交割以外的衍生金融商品之資金，包括匯出的保證金、權利金及損失等；但與國內銀行交易者不得列入本項，請依性質列入「其他匯出款—國內交易」之相關細項。"]
[null,null,"Outward remittance of funds for overseas non-deliverable derivative transactions ","Residents paying for overseas non-deliverable derivative transactions with non-residents, including margins, premiums and losses incurred.  Funds remitted for transactions with domestic banks may not be put under this item but under the related sub-item of “Other outward remittances –Domestic transactions” based on the nature of remittance."]
[null,270,"投資國外不動產","居民投資國外土地、房屋等不動產之資金。"]
[null,null,"Investments in overseas real estate","Resident’s investments in overseas real estate, such as land and houses."]
[null,280,"對外融資貸款","居民融資貸款予非居民，包括代墊款、週轉金等；若係對國外直接投資事業之貸款，請填報(220)「對外貸款投資」。"]
[null,null,"Loan financing to non-resident abroad","Resident’s loan financing to non-residents, including advances, working funds etc. For loans to direct overseas investments, fill in“220” - Outward loan investments. "]
["三",null,"外國資金流出","非居民收回各項投資本國的資金(含資本利得與損失)；但固定期間配發的各項所得(如利息、股利等)，請依性質列入「外資投資所得」各細項。外國資金流出分為下列各項："]
[null,null,"Outflows of foreign funds","Non-residents recovering funds from investment in the R.O.C. (including capital gain and loss); but for income distributed on a regular basis (e.g. interest and dividend), put under the sub-items of “Foreigner’s investment income”; outflows of foreign funds are classified into the following items:"]
[null,330,"國外信託資金匯出","國內證券投信業者匯出原投資於我國之國外信託資金。"]
[null,null,"Outward remittance of foreign trust funds invested in the R.O.C.","Domestic investment trust business remitting original investments in foreign trust funds in the R.O.C."]
[null,340,"償還國外借款","居民償還向國外借入之資金，包括代墊款、週轉金等，銀行對外履行借款保證責任時亦屬之；若屬償還外資直接投資股東之貸款投資款，請填報(320)「償還僑外貸款投資」。"]
[null,null,"Repayments of overseas borrowing ","Residents paying back funds borrowed abroad, including advances and working funds etc., as well as bank’s guarantee payments (fulfilling the guarantee responsibility). For repaying loan investment from direct non-resident shareholder, fill in“320” - Repayments of loan investments by foreign nationals and overseas Chinese."]
[null,341,"償還海外公司債","居民贖回其海外公司債之資金匯出，包括轉換股票後在國內股票市場售出所得資金匯出。"]
[null,null,"Repayments of corporate bonds issued overseas","Residents remitting outward funds for the redemption of corporate bonds issued overseas, including the proceeds from sale of converted stocks in the domestic stock exchange."]
[null,350,"外人存款收回","非居民收回存放於我國之存款（非證券投資戶）。"]
[null,null,"Withdrawal of deposits by foreign nationals","Non-residents withdrawing deposits in the R.O.C. (not for the local securities investments)."]
[null,360,"外人證券投資匯回","非居民匯回投資國內證券之資金(含資本利得與損失)。"]
[null,null,"Outward remittance of securities investments by foreign nationals","Non-residents remitting outward funds invested in local securities (including capital gain and loss)."]
[null,365,"外人交易衍生金融商品匯回","非居民匯回其原與國內交易衍生金融商品之資金，包括保證金、權利金及利得等。"]
[null,null,"Outward remittance of proceeds from financial derivative transactions by foreign nationals","Non-residents remitting outward proceeds from financial derivative transactions in the R.O.C., including margins, premiums and gains."]
[null,366,"外人借券保證金匯出","非居民匯回其借券交易之保證金。"]
[null,null,"Outward remittance of cash collateral received by foreign nationals for securities lending","Non-residents remitting outward cash collateral received for securities lending transactions."]
[null,370,"外人收回不動產投資","非居民收回投資國內不動產之資金。"]
[null,null,"Withdrawal of real estate investment by foreign nationals","Non-residents withdrawing funds invested in local real estate."]
[null,380,"海外存託憑證贖回","居民為贖回其海外存託憑證所匯出之資金。"]
[null,null,"Redemption of global depository receipts","Residents remitting outward funds to redeem his global depository receipts."]
[null,391,"償還分期付款進口融資","居民償還國外賣方之進口融資。"]
[null,null,"Installment payments for import financing","Residents paying back principal of import financing by foreign sellers in installments."]
[null,392,"資本租賃支出","居民向國外以融資方式承租物品之租金支出。"]
[null,null,"Capital leasing expenditures","Resident paying for foreign financing of leasing (principal)."]
[null,399,"其他外國資金流出","上述各項以外之外國資金流出，請詳述性質，如匯回押標金、保證金(不含交易衍生金融商品及借券交易之保證金)等"]
[null,null,"Other outflows of foreign funds","Outflows of foreign funds other than those described above (please specify the purpose (residents)/source (non-residents) of payment), such as bid bonds or performance bonds (excluding margins or cash collaterals for financial derivatives or securities lending)."]
["四",null,"所得支出","分為薪資支出及外資投資所得支出兩大項。"]
[null,null,"Payments for gains and income","Classified into two subcategories as payments for salaries and payments for foreigner’s investments income."]
["(一)",null,"薪資支出"]
[null,null,"Payments for salaries"]
[null,410,"非居民薪資匯出","在台外籍人員（憑護照或未滿一年之居留證）薪資匯出（或由其雇主代匯），及支付駐外軍政機關或無營利事業登記之國外分支機構當地雇員薪資款。若在台居留超過一年者，請填報(511)「工作者移轉支出」。"]
[null,null,"Outward remittance of non-resident’s wages and salaries","Outward remittance of wages and salaries of foreign employees in the R.O.C. (based on passport or residence permit showing stay of less than one year, or remitted by the employer), and payments for wages and salaries of local employees at an overseas branch office of a civil or military organ or the overseas branch office without business registration; for foreign employees who have stayed in the R.O.C. for more than one year, fill in “511” – Outward remittance by guest workers."]
["(二)",null,"外資投資所得(不含資本利得或損失)","投資所得係指固定期間所配發的利息、紅利、盈餘或股利；若是外資投資所產生買賣的價差視為「資本利得或損失」，不得列入各項投資所得，請依性質列「外國資金流出」各細項。外資投資所得分為下列各項："]
[null,null," investment income of foreign nationals (excluding capital gain or loss)","Investment income refers to interest, bonus, surplus or dividends distributed periodically; the difference between buying and selling prices incurred in foreigner’s investment is treated as “capital gain or loss”, which may not be put under investment gain, but under the sub-items of “Outflows of foreign funds” based on the nature of remittance. Investment income of foreign nationals is classified into the following items:"]
[null,440,"國外借款利息","居民向國外借款所支付之利息，包括資本租賃之利息支出。"]
[null,null,"Interest of overseas borrowing","Interest paid by resident for foreign borrowing, including interest expenditures of capital leasing."]
[null,441,"僑外股本投資的盈餘或股利","非居民直接投資於國內產業股本之紅利、盈餘及股利所得。"]
[null,null,"Surplus or dividend income of foreign nationals and overseas Chinese from equity investments in the R.O.C.","Bonus, surplus and dividends earned by non-residents from direct equity investments in R.O.C. enterprises."]
[null,442,"股權證券股利","非居民投資國內股份、股票、權證、存託憑證、共同基金及投資信託等股權證券之股利，或居民匯出配發在國外發行的股票、存託憑證等股權證券股利之款項。"]
[null,null,"Dividend income from equity securities","Non-resident’s dividend income from equity securities such as domestic shareholding, stocks, warrants, depository receipts, mutual funds and investment trusts or resident’s outward remittance of dividends on stocks or depository receipts issued overseas."]
[null,443,"外人存款利息","非居民匯出在國內存款之利息所得。"]
[null,null,"Deposit interest of foreign nationals","Outward remittances of interest from deposits in R.O.C banks by non-residents."]
[null,444,"有關進口之利息","居民支付國外賣方遠期信用狀、託收或分期付款進口融資等之利息支出。"]
[null,null,"Import finance related interest","Residents paying for the interest incurred from a foreign seller’s usance L/C, collection of payment or import financing by installment payment."]
[null,445,"長期債票券利息","非居民投資國內長期(發行期限超過一年)債票券的利息，或居民匯出配發海外長期債票券的利息。"]
[null,null,"Interest earned from long-term bonds and notes","Interest received by non-residents from long-term bonds and notes in R.O.C. (with an original maturity longer than one year) or residents remitting out interest income from overseas long-term bonds and notes."]
[null,446,"短期債票券利息","非居民投資短期(發行期限一年及一年以下)債票券的利息，或居民匯出配發海外短期債票券的利息。"]
[null,null,"Interest earned from short-term notes and bills","Interest received by non-residents from short-term notes and bills in R.O.C. (with an original maturity of one year or less) or a resident remitting out interest income from overseas short-term notes and bills."]
[null,448,"僑外貸款投資利息","居民支付非居民直接投資股東之貸款利息。"]
[null,null,"Interest on loan investments by foreign nationals and overseas Chinese","Residents paying interest on loans from direct non-resident shareholders."]
[null,449,"其他外資投資所得","上述各項以外之外資投資所得匯出，請詳述性質，如房屋、土地的租金支出。"]
[null,null,"Other investment income of  foreign nationals","Outward remittance of investment income of non-residents other than those described above (please specify the purpose (residents)/source (non-residents) of remittance), such as house or land rental."]
["五",null,"移轉支出","無償性或無相對報酬性之支出，分為下列各項："]
[null,null,"Transfer payments","Free-gratis or non-compensated payments are classified into the following items:"]
[null,511,"工作者匯款支出","在台居留一年以上之外籍工作者的薪資匯出款（或由其雇主代匯）。"]
[null,null,"Outward remittance by guest workers","Outward remittance of wages and salaries of foreign workers staying in R.O.C. for more than one year (or remitted by the employers)."]
[null,520,"捐贈匯款支出","軍政機關以外之居民對國外之捐獻或贈與款。"]
[null,null,"Donation remittance","Residents other than civil or military organs making donations to other countries."]
[null,540,"購買自然資源與非研發成果資產支出","向國外購買自然資源(包括土地、採礦權、伐木權、漁獵權、水域及領空等)及無形資產(包括品牌、商標、經銷權、網域名稱等)所有權的支出。若購買專利權、版權等請填報(19P)「購買研發成果資產之支出」。"]
[null,null,"Natural resources and non- R&D assets purchase expenditures","Expenses incurred in acquiring natural resources (including land, mining rights, logging rights, fishing and hunting rights, waters and air space)  and ownership of intangible assets (including trade names, trademarks, distribution rights, domain names, etc.) abroad; for the purchase of patents or copyrights, fill in“19P” –R&D assets purchase expenditures."]
[null,580,"政府移轉支出","我軍政機關對國外之移轉支出，如捐贈、繳交國際組織會費等。"]
[null,null,"Government transfer payments","Transfer payments of civil or military organs, such as donations and membership fees for international organizations."]
[null,599,"其他移轉支出","上述各項以外之移轉支出，請詳述性質，如違約金、補助款、獎學金、會員費、非居民合法繼承台灣地區人民遺產及其孳息、支付稅款、規費、彩券票款或獎金、非因保險給付之損害賠償、撫恤金等。"]
[null,null,"Other transfer payments","Transfer payments other than those described above (please specify the purpose (residents)/source (non-residents) of payment), such as default penalty, aid, scholarship, membership fees, non-resident’s legal inheritance of assets of residents and interest accrued, payment of tax and fees, lottery or prize, non-insurance related indemnity or relief payment. "]
["六",null,"其他匯出款"]
[null,null,"Other remittances items"]
["(一)",null,"其他國外交易"]
[null,null,"Other overseas transactions"]
[null,611,"出口貨款退回","包括出口貨款退回、出口貨款折讓及出口貨品瑕疵理賠等。若係跟單交易之貨款退回或拒付還款請列報為原來出口之減項。"]
[null,null,"Returns of export payments","Including returns of export payments, and payments for claims of defect. In the case of returns of payments in L/C negotiations or unpaid after L/C negotiations, declare as a minus item under the export L/C negotiation item on “Daily Transaction Report”."]
[null,619,"其他匯出款","除資本項目（2、3字頭）及611、612以外之其他匯入匯款退匯。詳述性質時，請註明原匯入匯款分類編號或項目名稱。"]
[null,null,"Other outward remittances","Returns of inward remittances other than 611, 612 and capital items (with prefix 2 or 3); when specifying the nature of remittance, please note the code or item name of the original inward remittance."]
["(二)",null,"國內交易","發生於國內之外匯交易（包括衍生金融商品交易），國別應填報為本國；若匯出至國際金融業務分行OBU者，不得列入國內交易，請依國外交易的匯款性質作適當分類，分為下列各項："]
[null,null,"Domestic transactions","For foreign exchange transactions (including financial derivative transactions) executed within the R.O.C., the country should be indicated as the R.O.C.; outward remittance to OBUs may not be put under domestic transactions, but should be classified into the foreign transaction’s items based on the nature of outward remittance. The domestic transaction’s items are classified as follows:"]
[null,692,"兌購外匯存外匯存款","客戶以新台幣結購外匯存入外匯存款時，不論其外匯支出之性質為何，指定銀行於水單上皆編製本項分類編號，並請加註客戶原結購性質；未以新台幣結購外匯者不得列入本項。"]
[null,null,"Purchase of foreign exchange and deposit into foreign currency deposit account","When a customer buys foreign currency with the New Taiwan dollar and deposits it in a foreign currency account, the authorized bank shall put down this code on the “Foreign Exchange Memo”, regardless the nature of the foreign exchange payment, and annotate customer’s original intent; do not use this code if the foreign exchange is not settled with the New Taiwan dollar."]
[null,693,"由本行轉往國內他行之外匯","本項非屬客戶填報之性質，而為指定銀行使用之分類編號。當外匯轉往國內他行時（不含聯行及各國際金融業務分行OBU），不論是否需經國外銀行轉帳，指定銀行於水單或憑證上皆編製本項分類編號，並請加註客戶原支出性質。匯往國際金融業務分行OBU者，不得列入本項，應依其原匯款性質作適當的分類。"]
[null,null,"Foreign exchange transferred to another domestic bank","This code is used only by authorized banks. When foreign exchange is transferred to another domestic bank (excluding  inter-branch transfer and with OBUs), the authorized bank should put down this code and note the original nature of payment by customer on the “Foreign Exchange Memo” or “Transactions Memo”, regardless whether the remittance transferred through  banks abroad. If the remittance is transferred to OBUs, do not use this code; use the code for the original nature of remittance instead."]
[null,694,"外幣互換兌出","兩種不同外幣間之互相轉換，轉換前之外幣列報本項。"]
[null,null,"Converting one foreign currency to another","Foreign currency converted from another foreign currency shall be reported. The original foreign currency should be put down in this item."]
[null,695,"未有資金流動之交易","客戶之外匯資金僅在同一銀行內部（包括聯行間但不含OBU）轉帳未匯出至他行者，如外匯活存定存互轉、定存到期展期續存、不同客戶間外匯轉讓、償還國內銀行外幣貸款、應收帳款承購收回、外幣貸款利息、支付國內銀行外幣手續費、呆帳沖銷、國內外匯交易損失、外匯交易保證金提存、結購外幣供保值等，請詳述性質。"]
[null,null,"Transaction without flow of funds","If a customer’s foreign exchange is transferred within the bank (including inter-branches, but not including OBU’s), for example transfers between time deposit and demand deposit, carry over of time deposit, foreign exchange transfers between customers, repayment of foreign currency loans extended by domestic banks, buyback of accounts receivables, interest payment of foreign currency loans, paying foreign currency service fees to authorized banks, write-off,  foreign currency transaction losses (incurred inside the country), deposit/withdrawal of foreign exchange transaction margin, or buying foreign currency for maintenance of value, please specify the nature of these transactions."]
["七",null,"支付商品貿易之貨款(含非居民於國內供貨及國外供貨)","支付商品貿易之貨款分為下列各項；若為分期付款與金融租賃的貨款本金支出請分別填報於(391)「償還分期付款進口融資」與(392)「資本租賃支出」。"]
[null,null,"Payments for imported goods (including onshore and offshore deliveries by non-residents)","Payments for imported goods are classified into the following items: for installment payments or capital leasing (principal), fill in “391” - Installment payments for import financing or “392”- Capital leasing expenditures."]
["(一)",null,"進口通關的貨款"]
[null,null,"Payments for customs-cleared imported goods"]
[null,"70A","付款人已自行辦理進口通關的貨款","貨品已由付款人辦理進口通關的貨款，包括個人進口之貨款。"]
[null,null,"Payments for imported goods with customs clearance handled by payee ","Payments for imported goods with customs clearance handled by payee, including payments for personal purchase."]
[null,701,"尚未進口之預付貨款","預付之進口貨品價款，貨品將在國內通關進口。"]
[null,null,"Prepayments for goods not yet imported","To pay for goods to be imported in advance. Such goods will be cleared through customs and imported into the R.O.C."]
[null,702,"燃油費及補給支出","我國運輸工具在國外港口或機場接受油料或物資等補給之支出。"]
[null,null,"Fuel and supply payments","To pay for fuel or supply received by transportation vehicle from R.O.C. at a foreign port."]
[null,704,"樣品費支出","居民支付國外樣品費。"]
[null,null,"Payments for samples","Residents paying for samples from abroad."]
[null,706,"非由付款人自行辦理進口通關的貨款","付款人提供相關文件證明貨物已由國內其他業者辦理進口通關，但貨款由其支付國外，否則，請填報(801)。"]
[null,null,"Payments for imported goods with customs clearance not handled by payee","Payments for imported goods with payee providing relevant proof documents showing that customs clearance formalities have been handled by the other domestic entities.  If relevant proof documents are not presented, fill in“801”."]
["(二)",null,"未經我國進口通關的國外貨款支出"]
[null,null,"Payments for goods not cleared through R.O.C. customs"]
[null,710,"委外加工貿易支出","居民國外購料委託國外加工，且貨品未經我國進口通關的貨款支出。"]
[null,null,"Payments for processing trade","Payments for goods with materials purchased and processed abroad and not cleared through R.O.C. customs."]
[null,711,"商仲貿易支出","居民購買貨品（包括原料、半成品及成品）後，不經加工直接在國外銷售，且過程中均未經我國通關，但由我國支付之貨款。"]
[null,null,"Payments for merchanting trade","Payments for purchase of merchandise (including raw materials, work-in-process and finished goods) that are sold directly abroad without further processing and never cleared through R.O.C. customs."]
["(三)",null,"支付國外但供貨來自境內之貨款"]
[null,null,"Payments for goods supplied onshore"]
[null,720,"國外訂貨但由境內供貨的貨款","付款人向國外訂貨，依照訂單或合約，其中部分貨品在境內取得，惟貨款須支付給國外，且提供相關證明文件，否則，請填報(802)。"]
[null,null,"Payments for goods ordered offshore but supplied onshore","Payments for goods ordered offshore, partly delivered onshore according to order or contract but payments made overseas, with the presentation of relevant proof documents.  If relevant proof documents are not presented, fill in“802”."]
["八",null,"其他貨款"]
[null,null,"Other payments for goods"]
[null,801,"非由付款人自行辦理進口通關的貨款(無證明文件)","匯出性質與(706)相同，但付款人無法提供證明文件之貨款，結購時累積超過新台幣50萬元以上，應計入付款人當年累積結匯金額。"]
[null,null,"Payments for imported goods with customs clearance not handled by payee (without proof documents)","The nature of outward remittance is the same of “706”, but the payee is unable to provide relevant proof documents; when accumulated settlement of foreign currency purchase exceeds NT$500,000, it should be counted into payee’s accumulated exchange settlement for the year."]
[null,802,"國外訂貨但由境內供貨的貨款(無證明文件)","匯出性質與(720)相同，但付款人無法提供證明文件之貨款，結購時累積超過新台幣50萬元以上，應計入付款人當年累積結匯金額。"]
[null,null,"Payments for goods ordered offshore but supplied onshore (without proof documents)","The nature of outward remittance is the same of “720”, but the payee is unable to provide relevant proof documents; when accumulated settlement of foreign currency purchase exceeds NT$500,000, it should be counted into payee’s accumulated exchange settlement for the year."]

{"sheet":"parameter","index":2,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["參數_header","HEADER"]
["參數_payment","PAYMENT"]
["付款類型",{"$f":"薪資付款!K1","v":"SAL"}]
["扣款貨幣","TWD"]
["參數_0",0]
["整批或薪資(20/22)"]
["入帳貨幣","TWD"]
["參數_表尾","TRAILER"]
["分隔符號",","]
["今日",{"$f":"NOW()","v":"2022-01-19T10:21:53.800"},{"$f":"TEXT(TODAY(),\"dd,mm,yyyy\")","v":"19,01,2022"},{"$f":"CONCATENATE(TEXT(TODAY(),\"ddmmyy\"),TEXT(NOW(),\"HHMM\"))","v":"1901221021"}]
[null,null,{"$f":"LEFT(B11,1)","v":""}]
["表頭",{"$f":"CONCATENATE(B1,B9,TEXT(TODAY(),\"ddmmyyyy\"),B9,薪資付款!E2,B9,LEFT(薪資付款!F2,35))","v":"HEADER,19012022,TWGTS,GTS OF DBS TW"}]
["表資料",{"$f":"CONCATENATE(B2,B9,B3,B9,薪資付款!C2,B9,B4,B9)","v":"PAYMENT,SAL,300001XXXXX,TWD,"}]
["表尾",{"$f":"CONCATENATE(B8,B9,薪資付款!G2,B9,薪資付款!J1)","v":"TRAILER,3,31"}]
["最大處理筆數",1000]
["暫存"]
[]
[]
["亂數",{"$f":"INT(RAND()*99999)","v":43548}]

{"sheet":"操作說明(Instructions)","index":3,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["上傳批次檔案10步驟    如有任何問題，請洽星展(台灣)客服專線 02 6606 0302\n若無法轉檔EXCEL 2003 請至工具，巨集，安全性，把安全性層級調低即可。\n                    EXCEL 2007 請至EXCEL選項，信任中心，信任中心選項，啟用所有巨集  "]
["圖示","說明"]
[null,"1.登入IDEAL企業網路銀行\nhttps://ideal.dbs.com"]
[null,"2.點選\n>【現金管理】\n>【檔案傳輸】\n>【匯入設定檔】。"]
[null,"3填入設定檔名稱，\n>檔案類型選【全部】、\n>檔案格式點選【UFF】，\n>完畢後點選【繼續】\n>確認無誤後，畫面右下角點選【建立】"]
[null,"4.確認是否允許更改付款日期\n>確認是否讓其他使用者存取此設定檔\n>點選【預覽匯入設定檔】。"]
[null,"5.確認預覽畫面無誤後\n>右下角點選【建立匯入設定檔】。"]
[null,"6.匯入設定檔清單內出現新的設定檔\n>在【動作】項目拉下並選取【執行】\n>系統會自動帶入頁面。"]
[null,"7.選取【Choose File】\n>選取檔案之後按【匯入檔案】\n>需等待幾分鐘時間轉檔。"]
[null,"8.利用本程式Main下的轉檔按鈕轉檔並儲存\n>選取所儲存的整批付款之檔案\n>其附檔名應為.txt\n>選取完畢後，點選【匯入檔案】。"]
[null,"9.系統自動轉到【匯入檔歷史紀錄】\n>狀態中出現【處理中】\n>等待約三分鐘後\n>狀態會自動更新至【等待授權】"]
[null,"10.選擇【現金管理】\n>【管理授權】\n> 顯示出所有正等待授權的交易\n> 待授權完畢後，即完成付款交易。"]
[null,"備註:若狀態出現【失敗】或【已完成】\n>可在【其他資訊】查詢錯誤訊息之內容。"]