Ejemplo n.º 1
0
 /**
  * Run the database seeds.
  *
  * @return void
  */
 public function run()
 {
     DB::table('banks')->truncate();
     Bank::create(['name' => 'Access Bank Plc', 'coa_id' => 0]);
     Bank::create(['name' => 'Citibank Nigeria Limited', 'coa_id' => 0]);
     Bank::create(['name' => 'Diamond Bank Plc', 'coa_id' => 0]);
     Bank::create(['name' => 'Ecobank Nigeria Plc', 'coa_id' => 0]);
     Bank::create(['name' => 'Enterprise Bank', 'coa_id' => 0]);
     Bank::create(['name' => 'Fidelity Bank Plc', 'coa_id' => 0]);
     Bank::create(['name' => 'First Bank of Nigeria Plc', 'coa_id' => 0]);
     Bank::create(['name' => 'First City Monument Bank Plc', 'coa_id' => 0]);
     Bank::create(['name' => 'Guaranty Trust Bank Plc', 'coa_id' => 0]);
     Bank::create(['name' => 'Heritage Banking Company Ltd', 'coa_id' => 0]);
     Bank::create(['name' => 'Key Stone Bank', 'coa_id' => 0]);
     Bank::create(['name' => 'MainStreet Bank', 'coa_id' => 0]);
     Bank::create(['name' => 'Skye Bank Plc', 'coa_id' => 0]);
     Bank::create(['name' => 'Stanbic IBTC Bank Ltd', 'coa_id' => 0]);
     Bank::create(['name' => 'Standard Chartered Bank Nigeria Ltd 	', 'coa_id' => 0]);
     Bank::create(['name' => 'Sterling Bank Plc', 'coa_id' => 0]);
     Bank::create(['name' => 'Union Bank of Nigeria Plc', 'coa_id' => 0]);
     Bank::create(['name' => 'United Bank For Africa Plc', 'coa_id' => 0]);
     Bank::create(['name' => 'Unity Bank Plc', 'coa_id' => 0]);
     Bank::create(['name' => 'Wema Bank Plc', 'coa_id' => 0]);
     Bank::create(['name' => 'Zenith Bank Plc', 'coa_id' => 0]);
 }
Ejemplo n.º 2
0
 /**
  * Show the form for editing the specified resource.
  *
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function edit(Stack $stack)
 {
     // Edit an exisiting stack
     $brands = Brand::lists('short_name', 'id');
     $banks = Bank::lists('name', 'id');
     $types = Type::whereIn('tablename', ['all', 'stacks'])->lists('name', 'id');
     return view('stacks.edit', compact('stack', 'brands', 'banks', 'users', 'types'));
 }
Ejemplo n.º 3
0
 public function bankPost(Request $request)
 {
     $validation = Validator::make($request->all(), ['short_name' => 'required|min:3', 'name' => 'required']);
     // return $validation->errors();
     if ($validation->fails()) {
         Session::flash('error', 'Gagal. Bank gagal direkodkan.');
         return redirect()->back();
     }
     $bank = new Bank();
     $bank->short_name = strtoupper($request->short_name);
     $bank->name = strtoupper($request->name);
     if ($bank->save()) {
         Session::flash('success', 'Berjaya. Bank berjaya direokdkan.');
     } else {
         Session::flash('error', 'Gagal. Bank gagal direkodkan...');
     }
     return redirect()->back();
 }
Ejemplo n.º 4
0
 /**
  * Show the form for editing the specified resource.
  *
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function edit($id)
 {
     $cuenta = BankAccount::where('enterprise_id', $id)->first();
     $bancos = Bank::lists('nombre', 'id');
     if ($cuenta) {
         return view('banks_accounts.edit', compact('cuenta', 'id', 'bancos'));
     } else {
         return view('banks_accounts.create', compact('id', 'bancos'));
     }
 }
Ejemplo n.º 5
0
 public function show($alpha2, $id)
 {
     $links[1] = 'active';
     try {
         $bank = Bank::findOrFail($id);
         $country = Country::findOrFail($alpha2);
     } catch (ModelNotFoundException $ex) {
         return view('errors.404');
     }
     return view('bank.show', ['bank' => $bank, 'country' => $country, 'links' => $links]);
 }
 public function loadEASTWEST(Request $request)
 {
     if ($request->ajax()) {
         $bank = Bank::where('account_id', '200009019676')->select('account_id', 'name', 'account_name')->first();
         $mop = $bank->name;
         $account_name = $bank->account_name;
         $account_id = $bank->account_id;
         $address = null;
         return \Response::json(\View::make('layouts.forms.paymentdetails')->with(compact('mop', 'account_name', 'account_id', 'address'))->render());
     }
 }
Ejemplo n.º 7
0
 /**
  * 申请提现页面
  *  
  * @date   2015-10-07
  * @return [type]     [description]
  */
 public function withdraw()
 {
     $data = [];
     $user = Auth::user();
     $data['username'] = $user->username;
     $userBank = UserBank::where('user_id', $user->id)->where('is_lock', 1)->first();
     $data['userBank'] = $userBank;
     if (!$userBank) {
         $data['banks'] = Bank::where('withdraw_status', 1)->select(['name', 'alias'])->get();
     }
     $data['is_payment'] = $user->payment_password == '' ? true : false;
     $data['cashes'] = $user->cashes;
     return view('banks.withdraw', $data);
 }
Ejemplo n.º 8
0
 /**
  * Получаем информацию по банкам с количеством
  * кредитных предложений, разбитыми на блоки
  * пагинации
  *
  * @param int $countPage
  * @return mixed
  */
 public function getPaginateBank($countPage = 10)
 {
     // выводить только опубликованные записи(publish = 1)
     $banks = Bank::select(['id', 'title', 'pic_bank', 'url', 'rank', 'site'])->where('publish', '=', '1')->orderBy('id', 'desc')->paginate($countPage);
     foreach ($banks as $bank) {
         $bank->countOffersNal = \DB::table('offers_nal')->where('bank_id', '=', $bank->id)->count('id');
         $bank->countOffersCard = \DB::table('offers_card')->where('bank_id', '=', $bank->id)->count('id');
         $bank->countOffersMicro = \DB::table('offers_micro')->where('bank_id', '=', $bank->id)->count('id');
         $bank->countOffersMort = \DB::table('offers_mort')->where('bank_id', '=', $bank->id)->count('id');
         $bank->countOffersAuto = \DB::table('offers_auto')->where('bank_id', '=', $bank->id)->count('id');
         $bank->countOffersHold = \DB::table('offers_hold')->where('bank_id', '=', $bank->id)->count('id');
     }
     return $banks;
 }
 public function bank()
 {
     $banks = \App\Bank::with('tax')->where('active', 1)->get();
     $data = [];
     foreach ($banks as $bank) {
         $row = ['bank_id' => $bank->id, 'nama_bank' => $bank->nama_bank];
         foreach ($bank->tax as $bt) {
             $type = 'tax_' . $bt->type;
             $row[$type] = $bt->tax;
         }
         array_push($data, $row);
     }
     $display['bank'] = $data;
     return $display;
 }
Ejemplo n.º 10
0
 public function store()
 {
     if (!Request::has('bank', 'name', 'account')) {
         return failure('参数错误');
     }
     $bank = Bank::find(Request::input('bank'));
     if (!$bank) {
         return failure('银行不存在');
     }
     $adminBank = AdminBank::add($bank, Request::input('name'), Request::input('account'), Request::input('address'));
     if (!$adminBank) {
         return failure('添加银行失败');
     }
     return success('添加银行成功');
 }
Ejemplo n.º 11
0
 public function run()
 {
     Bank::create(['short_name' => strtoupper('CIMB'), 'name' => strtoupper('CIMB Bank berhad')]);
     Bank::create(['short_name' => strtoupper('Maybank'), 'name' => strtoupper('maybank berhad')]);
     Bank::create(['short_name' => strtoupper('Agro'), 'name' => strtoupper('agrobank')]);
     Bank::create(['short_name' => strtoupper('bank islam'), 'name' => strtoupper('bank islam malaysia berhad')]);
     Bank::create(['short_name' => strtoupper('ambank'), 'name' => strtoupper('ambank berhad')]);
     Bank::create(['short_name' => strtoupper('rhb'), 'name' => strtoupper('rhb bank berhad')]);
     Bank::create(['short_name' => strtoupper('public bank'), 'name' => strtoupper('public bank berhad')]);
     Bank::create(['short_name' => strtoupper('hsbc'), 'name' => strtoupper('hsbc bank berhad')]);
     Bank::create(['short_name' => strtoupper('ocbc'), 'name' => strtoupper('ocbc bank berhad')]);
     Bank::create(['short_name' => strtoupper('affin'), 'name' => strtoupper('affin bank berhad')]);
     Bank::create(['short_name' => strtoupper('hong leong'), 'name' => strtoupper('hong leong bank berhad')]);
     Bank::create(['short_name' => strtoupper('standard chartered'), 'name' => strtoupper('standard chartered bank (m) berhad')]);
     Bank::create(['short_name' => strtoupper('BSN'), 'name' => strtoupper('bank simpanan nasional')]);
 }
Ejemplo n.º 12
0
 public function withdraw()
 {
     $user = Auth::user();
     $input = Input::get('amount');
     $bank = Bank::where('name', '=', $user->name)->first();
     if ($input <= $bank->money) {
         $bank->money -= $input;
         $bank->save();
         $user->money += $input;
         $user->save();
         session()->flash('flash_message', 'You withdrew your money!');
         return redirect('/bank');
     } else {
         session()->flash('flash_message_important', 'You failed to withdraw your money!');
         return redirect('/bank');
     }
 }
Ejemplo n.º 13
0
 public function permohonan2(Request $request)
 {
     // ###########################  SESSION  #################################
     Session::put('tahunBerakhir', Carbon::parse($request->get('tarikh'))->format('d M Y'));
     // ########################  END SESSION  ################################
     $existed = 0;
     $year = Carbon::parse($request->get('tarikh'))->format('Y');
     $lampiranbsatu = Lampiranbsatu::where('ppk_id', Auth::user()->ppk_id)->where('tahun', $year)->first();
     if ($lampiranbsatu != null) {
         $existed = 1;
     }
     $banks = Bank::lists('name', 'id');
     if ($existed) {
         return View('ppk.rekod.forms._permohonan2', compact('banks', 'existed', 'lampiranbsatu'));
     } else {
         return View('ppk.rekod.permohonan2', compact('banks'));
     }
 }
Ejemplo n.º 14
0
 /**
  * Отображаем конкретный банк по url
  *
  * @param $id
  * @param Bank $bank
  * @return \Illuminate\View\View
  */
 public function getOnId($id, Bank $bank)
 {
     $bankInfo = $bank->getBankInfo($id);
     //доделать
     return view('banks.bankPost', ['bank' => $bankInfo]);
 }
 public function closeOrder($id)
 {
     if (Gate::denies('order.close')) {
         return view(config('app.template') . '.error.403');
     }
     $order = Order::with(['karyawan', 'detail.produk', 'detail.detailReturn', 'place.place.kategori'])->find($id);
     if (!$order) {
         return view(config('app.template') . '.error.404');
     }
     // Detail Order
     $orderDetail = [];
     foreach ($order->detail->toArray() as $od) {
         $odQty = $od['qty'] - ($od['detail_return'] != null ? $od['detail_return']['qty'] : 0);
         $in = array_only($od, ['harga_jual', 'satuan']) + ['nama' => $od['produk']['nama'], 'qty' => $odQty, 'subtotal' => $od['harga_jual'] * $odQty];
         array_push($orderDetail, $in);
     }
     $current_place = implode(', ', array_column(array_column($order->place->toArray(), 'place'), 'nama'));
     $orderPlaces = [];
     foreach ($order->place as $op) {
         if ($op->harga > 0) {
             array_push($orderPlaces, ['nama' => $op->place->nama . ' - ' . $op->place->kategori->nama, 'harga' => $op->harga]);
         }
     }
     $data = ['order' => $order, 'orderDetail' => $orderDetail, 'orderPlaces' => $orderPlaces, 'tanggal' => $order->tanggal->format('Y-m-d'), 'current_place' => $current_place, 'init_tax' => Tax::where('active', 1)->first(), 'taxes' => Tax::where('active', 1)->lists('type', 'id'), 'banks' => Bank::where('active', 1)->lists('nama_bank', 'id')];
     return view(config('app.template') . '.order.close', $data);
 }
Ejemplo n.º 16
0
 public function jsonIndex()
 {
     return response()->json(Bank::distinct()->orderBy('date', 'desc')->groupBy('name')->select(['id', 'name', 'date', 'value'])->get());
 }
Ejemplo n.º 17
0
 /**
  * Show the form for editing the specified resource.
  *
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function edit($id)
 {
     $data['school'] = School::find(1);
     $data['banks'] = Bank::lists('name', 'id')->prepend('Please Select');
     return view('settings.school.edit', $data);
 }
Ejemplo n.º 18
0
 /**
  * Remove the specified resource from storage.
  *
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function destroy(Bank $bank)
 {
     // Delete a bank
     $bank->delete();
     flash()->success('Bank has been deleted!');
     return redirect('banks');
 }
Ejemplo n.º 19
0
 /**
  * Get amount in bank
  */
 public function bank()
 {
     return config('default.starting_bank') + Bank::dateRangeTo($this->to)->sum('amount');
 }
 /**
  * Display the specified resource.
  *
  * @param  int $id
  * @return Response
  */
 public function getShowproduct($id)
 {
     $bank = Bank::findOrFail($id);
     return view('admin.showproduct', compact('bank'));
 }
Ejemplo n.º 21
0
 /**
  * Bank an amount
  *
  * @param WithdrawRequest $request
  * @return \Illuminate\Http\RedirectResponse
  */
 public function withdraw(WithdrawRequest $request)
 {
     Bank::create(['amount' => -1 * $request->amountToWithdraw]);
     return redirect()->route('report.trial-balance')->with('success', 'Amount Withdrawn');
 }
 public function ajaxLoad(Request $request)
 {
     if ($request->get('id')) {
         return \App\BankTax::join('banks', 'bank_taxes.bank_id', '=', 'banks.id')->where('banks.active', 1)->where('bank_id', $request->get('id'))->where('type', $request->get('type'))->first();
     }
     return Bank::with('tax')->where('active', 1)->get();
 }
 protected function _jurnalBank($request)
 {
     $bank = $request->get('bank') ? $request->get('bank') : Bank::where('active', 1)->first()->id;
     $tanggal = $request->get('tanggal') ? $request->get('tanggal') : date('Y-m-d');
     $CTanggal = Carbon::createFromFormat('Y-m-d', $tanggal);
     $to_tanggal = $request->get('to_tanggal') ? $request->get('to_tanggal') : $tanggal;
     $CToTanggal = Carbon::createFromFormat('Y-m-d', $to_tanggal);
     $CYesterday = $CTanggal->copy()->addDays(-1);
     $yesterday = $CYesterday->format('Y-m-d');
     $banks = Bank::where('active', 1)->lists('nama_bank', 'id')->toArray();
     $start = $CTanggal->copy();
     $end = $CToTanggal->copy();
     $dates = [];
     while ($start->lte($end)) {
         $dates[] = $start->copy();
         $start->addDay();
     }
     // Account Saldo for sisa saldo
     $totalAccountSaldo = 0;
     $firstAccountSaldo = AccountSaldo::orderBy('tanggal')->limit(1)->first();
     if ($firstAccountSaldo) {
         if ($firstAccountSaldo->tanggal->lte($CYesterday)) {
             $firstDate = $firstAccountSaldo->tanggal->format('Y-m-d');
             $where = "(account_saldos.`tanggal` BETWEEN '{$firstDate}' AND '{$yesterday}') and relation_id = '{$bank}' AND";
             $column = "IF(account_saldos.`type` = 'kredit', account_saldos.`nominal`, -ABS(account_saldos.`nominal`))";
             $totalAccountSaldo = ConvertRawQueryToArray(Account::TotalAccountSaldo($column, $where, 'jurnal'))[0]['total'];
         }
     }
     $tableTemp = [];
     // Sisa Saldo Pertanggal $tanggal (-1)
     $sisaSaldo = $totalAccountSaldo;
     $saldo = $sisaSaldo;
     array_push($tableTemp, ['tanggal' => $CYesterday->format('Y-m-d'), 'keterangan' => 'Sisa Saldo ' . $CYesterday->format('d M Y'), 'debet' => '', 'kredit' => '', 'saldo' => $sisaSaldo]);
     // Account Saldo range $tanggal s/d $to_tanggal
     $accountSaldos = AccountSaldo::with('bank')->join('accounts', 'account_saldos.account_id', '=', 'accounts.id')->leftJoin(DB::raw("(SELECT accounts.`id` AS account_id, accounts.`nama_akun`, reports.display\n                    FROM accounts\n                    INNER JOIN account_report ON accounts.`id` = account_report.`account_id`\n                    INNER JOIN reports ON account_report.`report_id` = reports.id\n                    WHERE reports.key = 'jurnal')temp_report"), function ($join) {
         $join->on('accounts.id', '=', 'temp_report.account_id');
     })->where('relation_id', $bank)->whereBetween('tanggal', [$tanggal, $to_tanggal])->whereNotNull('temp_report.account_id')->select(['account_saldos.*', DB::raw('accounts.nama_akun as nama_akun'), DB::raw('tanggal as _date')])->get()->groupBy('_date');
     foreach ($dates as $date) {
         // Account Saldo
         if (isset($accountSaldos[$date->format('Y-m-d')])) {
             $acs = $accountSaldos[$date->format('Y-m-d')];
             foreach ($acs as $as) {
                 $bankName = $as['bank'] != null ? $as['bank']['nama_bank'] : '';
                 if ($as['type'] == 'debet') {
                     $saldo -= $as['nominal'];
                     array_push($tableTemp, ['tanggal' => $date->format('Y-m-d'), 'keterangan' => $as['nama_akun'] . ' ' . $bankName, 'debet' => '', 'kredit' => $as['nominal'], 'saldo' => $saldo]);
                 } else {
                     // kredit
                     $saldo += $as['nominal'];
                     array_push($tableTemp, ['tanggal' => $date->format('Y-m-d'), 'keterangan' => $as['nama_akun'] . ' ' . $bankName, 'debet' => $as['nominal'], 'kredit' => '', 'saldo' => $saldo]);
                 }
             }
         }
     }
     $tableTemp = collect($tableTemp)->groupBy('tanggal');
     return ['tanggal' => $CTanggal, 'to_tanggal' => $CToTanggal, 'bank' => $bank, 'banks' => $banks, 'table' => $tableTemp];
 }
Ejemplo n.º 24
0
             return Redirect::back();
         });
         Route::get('users/{id}', function ($id) {
             $user = \App\User::findOrFail($id);
             $level = \App\Level::lists('name', 'id');
             $ppk = \App\Ppk::lists('name', 'id');
             return View('admin.preset.users.edit', compact('user', 'level', 'ppk'));
         });
         Route::post('users/kemaskini', ['as' => 'admin.preset.users.kemaskini', 'uses' => 'Admin\\PresetController@kemaskini']);
         /**************************************
          *                 Bank
          **************************************/
         Route::get('bank', ['as' => 'admin.preset.bank', 'uses' => 'Admin\\BankController@bank']);
         Route::post('bank', ['as' => 'admin.preset.bank', 'uses' => 'Admin\\BankController@bankPost']);
         Route::get('bank/{id}', function ($id) {
             if (\App\Bank::destroy($id)) {
                 Session::flash('success', 'Berjaya. Permarkahan berjaya dihapus.');
             } else {
                 Session::flash('error', 'Gagal. Permarkahan gagal dihapus.');
             }
             return redirect()->back();
         });
     });
 });
 /******************************************************
  *                         PPK
  ******************************************************/
 Route::group(['prefix' => 'ppk'], function () {
     Route::group(['prefix' => 'rekod'], function () {
         /*
          * User
Ejemplo n.º 25
0
 /**
  * Run the database seeds.
  *
  * @return void
  */
 public function run()
 {
     DB::table('banks')->delete();
     /* Argentina */
     Bank::create(['country_id' => '32', 'code' => 'BICAARBS', 'name' => 'BANCO BICA S.A.', 'city' => 'SANTA FE']);
     Bank::create(['country_id' => '32', 'code' => 'BBDEARBA', 'name' => 'BANCO BRADESCO ARGENTINA S/A', 'city' => 'BUENOS AIRES']);
     Bank::create(['country_id' => '32', 'code' => 'BCRAARBA', 'name' => 'BANCO CENTRAL DE LA REPUBLICA ARGENTINA', 'city' => 'BUENOS AIRES']);
     Bank::create(['country_id' => '32', 'code' => 'CMFBARBA', 'name' => 'BANCO CMF S.A.', 'city' => 'BUENOS AIRES']);
     Bank::create(['country_id' => '32', 'code' => 'QUILARBA', 'name' => 'BANCO COMAFI S.A.', 'city' => 'BUENOS AIRES']);
     Bank::create(['country_id' => '32', 'code' => 'BCOOARBA', 'name' => 'BANCO CREDICOOP COOPERATIVO LIMITADO', 'city' => 'BUENOS AIRES']);
     Bank::create(['country_id' => '32', 'code' => 'BCORARBC', 'name' => 'BANCO DE CORRIENTES S.A.', 'city' => 'CORRIENTES']);
     Bank::create(['country_id' => '32', 'code' => 'BFSAARBF', 'name' => 'BANCO DE FORMOSA S.A.', 'city' => 'FORMOSA']);
     Bank::create(['country_id' => '32', 'code' => 'GABAARBA', 'name' => 'BANCO DE GALICIA Y BUENOS AIRES', 'city' => 'BUENOS AIRES']);
     Bank::create(['country_id' => '32', 'code' => 'BICXARBA', 'name' => 'BANCO DE INVERSION Y COMERCIO EXTERIOR S.A.', 'city' => 'BUENOS AIRES']);
     Bank::create(['country_id' => '32', 'code' => 'BACIARBA', 'name' => 'BANCO DE LA CIUDAD DE BUENOS AIRES', 'city' => 'BUENOS AIRES']);
     Bank::create(['country_id' => '32', 'code' => 'NACNARBABAH', 'name' => 'BANCO DE LA NACION ARGENTINA', 'city' => 'BAHIA BLANCA']);
     Bank::create(['country_id' => '32', 'code' => 'NACNARBACCL', 'name' => 'BANCO DE LA NACION ARGENTINA', 'city' => 'BUENOS AIRES']);
     Bank::create(['country_id' => '32', 'code' => 'NACNARBA', 'name' => 'BANCO DE LA NACION ARGENTINA', 'city' => 'BUENOS AIRES']);
     Bank::create(['country_id' => '32', 'code' => 'NACNARBACON', 'name' => 'BANCO DE LA NACION ARGENTINA', 'city' => 'CONCORDIA']);
     Bank::create(['country_id' => '32', 'code' => 'NACNARBACOR', 'name' => 'BANCO DE LA NACION ARGENTINA', 'city' => 'CORDOBA']);
     Bank::create(['country_id' => '32', 'code' => 'NACNARBACTS', 'name' => 'BANCO DE LA NACION ARGENTINA', 'city' => 'CORRIENTES']);
     Bank::create(['country_id' => '32', 'code' => 'NACNARBAMPL', 'name' => 'BANCO DE LA NACION ARGENTINA', 'city' => 'MAR DEL PLATA']);
     Bank::create(['country_id' => '32', 'code' => 'NACNARBAMEN', 'name' => 'BANCO DE LA NACION ARGENTINA', 'city' => 'MENDOZA']);
     Bank::create(['country_id' => '32', 'code' => 'NACNARBANEU', 'name' => 'BANCO DE LA NACION ARGENTINA', 'city' => 'NEUQUEN']);
     Bank::create(['country_id' => '32', 'code' => 'NACNARBAPER', 'name' => 'BANCO DE LA NACION ARGENTINA', 'city' => 'PERGAMINO']);
     Bank::create(['country_id' => '32', 'code' => 'NACNARBAPOS', 'name' => 'BANCO DE LA NACION ARGENTINA', 'city' => 'POSADAS']);
     Bank::create(['country_id' => '32', 'code' => 'NACNARBARAF', 'name' => 'BANCO DE LA NACION ARGENTINA', 'city' => 'RAFAELA']);
     Bank::create(['country_id' => '32', 'code' => 'NACNARBAREC', 'name' => 'BANCO DE LA NACION ARGENTINA', 'city' => 'RECONQUISTA']);
     Bank::create(['country_id' => '32', 'code' => 'NACNARBARCU', 'name' => 'BANCO DE LA NACION ARGENTINA', 'city' => 'RIO CUARTO']);
     Bank::create(['country_id' => '32', 'code' => 'NACNARBAROS', 'name' => 'BANCO DE LA NACION ARGENTINA', 'city' => 'ROSARIO']);
     Bank::create(['country_id' => '32', 'code' => 'NACNARBASAL', 'name' => 'BANCO DE LA NACION ARGENTINA', 'city' => 'SALTA']);
     Bank::create(['country_id' => '32', 'code' => 'NACNARBASJU', 'name' => 'BANCO DE LA NACION ARGENTINA', 'city' => 'SAN JUAN']);
     Bank::create(['country_id' => '32', 'code' => 'NACNARBASMT', 'name' => 'BANCO DE LA NACION ARGENTINA', 'city' => 'SAN MIGUEL DE TUCUMAN']);
     Bank::create(['country_id' => '32', 'code' => 'NACNARBASRA', 'name' => 'BANCO DE LA NACION ARGENTINA', 'city' => 'SAN RAFAEL']);
     Bank::create(['country_id' => '32', 'code' => 'NACNARBASFE', 'name' => 'BANCO DE LA NACION ARGENTINA', 'city' => 'SANTA FE']);
     Bank::create(['country_id' => '32', 'code' => 'NACNARBAVMA', 'name' => 'BANCO DE LA NACION ARGENTINA', 'city' => 'VILLA MARIA']);
     Bank::create(['country_id' => '32', 'code' => 'PAMPARBA', 'name' => 'BANCO DE LA PAMPA S.E.M.', 'city' => 'BUENOS AIRES']);
     Bank::create(['country_id' => '32', 'code' => 'PAMPARBA200', 'name' => 'BANCO DE LA PAMPA S.E.M.', 'city' => 'GENERAL PICO']);
     Bank::create(['country_id' => '32', 'code' => 'PAMPARBA001', 'name' => 'BANCO DE LA PAMPA S.E.M.', 'city' => 'SANTA ROSA']);
     Bank::create(['country_id' => '32', 'code' => 'PRBAARBABAH', 'name' => 'BANCO DE LA PROVINCIA DE BUENOS AIRES', 'city' => 'BAHIA BLANCA']);
     Bank::create(['country_id' => '32', 'code' => 'PRBAARBADIV', 'name' => 'BANCO DE LA PROVINCIA DE BUENOS AIRES', 'city' => 'BUENOS AIRES']);
     Bank::create(['country_id' => '32', 'code' => 'PRBAARBA', 'name' => 'BANCO DE LA PROVINCIA DE BUENOS AIRES', 'city' => 'BUENOS AIRES']);
     Bank::create(['country_id' => '32', 'code' => 'PRBAARBALPT', 'name' => 'BANCO DE LA PROVINCIA DE BUENOS AIRES', 'city' => 'LA PLATA']);
     Bank::create(['country_id' => '32', 'code' => 'PRBAARBAMP1', 'name' => 'BANCO DE LA PROVINCIA DE BUENOS AIRES', 'city' => 'MAR DEL PLATA']);
     Bank::create(['country_id' => '32', 'code' => 'CORDARBA', 'name' => 'BANCO DE LA PROVINCIA DE CORDOBA', 'city' => 'BUENOS AIRES']);
     Bank::create(['country_id' => '32', 'code' => 'CORDARBACOR', 'name' => 'BANCO DE LA PROVINCIA DE CORDOBA', 'city' => 'CORDOBA']);
     Bank::create(['country_id' => '32', 'code' => 'BPNEARBA', 'name' => 'BANCO DE LA PROVINCIA DEL NEUQUEN S.A.', 'city' => 'BUENOS AIRES']);
     Bank::create(['country_id' => '32', 'code' => 'BROUARBA', 'name' => 'BANCO DE LA REPUBLICA ORIENTAL DEL URUGUAY', 'city' => 'BUENOS AIRES']);
     Bank::create(['country_id' => '32', 'code' => 'BSJUARBJ', 'name' => 'BANCO DE SAN JUAN SA', 'city' => 'SAN JUAN']);
     Bank::create(['country_id' => '32', 'code' => 'BPSCARBA', 'name' => 'BANCO DE SANTA CRUZ S A', 'city' => 'RIO GALLEGOS']);
     Bank::create(['country_id' => '32', 'code' => 'BSTIARBA', 'name' => 'BANCO DE SERVICIOS Y TRANSACCIONES SA', 'city' => 'BUENOS AIRES']);
     Bank::create(['country_id' => '32', 'code' => 'BAVAARBA', 'name' => 'BANCO DE VALORES', 'city' => 'BUENOS AIRES']);
     Bank::create(['country_id' => '32', 'code' => 'BPCHARBA', 'name' => 'BANCO DEL CHUBUT S.A.', 'city' => 'BUENOS AIRES']);
     /* Bolivia */
     Bank::create(['country_id' => '68', 'code' => 'BANIBOLXCBB', 'name' => 'BANCO BISA S.A.', 'city' => 'COCHABAMBA']);
     Bank::create(['country_id' => '68', 'code' => 'BANIBOLX', 'name' => 'BANCO BISA S.A.', 'city' => 'LA PAZ']);
     Bank::create(['country_id' => '68', 'code' => 'BANIBOLXSCZ', 'name' => 'BANCO BISA S.A.', 'city' => 'SANTA CRUZ DE LA SIERRA']);
     Bank::create(['country_id' => '68', 'code' => 'BCEBBOLP', 'name' => 'BANCO CENTRAL DE BOLIVIA', 'city' => 'LA PAZ']);
     Bank::create(['country_id' => '68', 'code' => 'BCPLBOLXCBB', 'name' => 'BANCO DE CREDITO DE BOLIVIA S.A.', 'city' => 'COCHABAMBA']);
     Bank::create(['country_id' => '68', 'code' => 'BCPLBOLX', 'name' => 'BANCO DE CREDITO DE BOLIVIA S.A.', 'city' => 'LA PAZ']);
     Bank::create(['country_id' => '68', 'code' => 'BCPLBOLXSCZ', 'name' => 'BANCO DE CREDITO DE BOLIVIA S.A.', 'city' => 'SANTA CRUZ DE LA SIERRA']);
     Bank::create(['country_id' => '68', 'code' => 'NACNBOLP', 'name' => 'BANCO DE LA NACION ARGENTINA', 'city' => 'SANTA CRUZ DE LA SIERRA']);
     Bank::create(['country_id' => '68', 'code' => 'BRASBOLX', 'name' => 'BANCO DO BRASIL S.A.', 'city' => 'LA PAZ']);
     Bank::create(['country_id' => '68', 'code' => 'BOEOBO22CBB', 'name' => 'BANCO ECONOMICO S.A.', 'city' => 'COCHABAMBA']);
     Bank::create(['country_id' => '68', 'code' => 'BOEOBO22LPZ', 'name' => 'BANCO ECONOMICO S.A.', 'city' => 'LA PAZ']);
     Bank::create(['country_id' => '68', 'code' => 'BOEOBO22SCZ', 'name' => 'BANCO ECONOMICO S.A.', 'city' => 'SANTA CRUZ DE LA SIERRA']);
     Bank::create(['country_id' => '68', 'code' => 'BOEOBO22', 'name' => 'BANCO ECONOMICO S.A.', 'city' => 'SANTA CRUZ DE LA SIERRA']);
     Bank::create(['country_id' => '68', 'code' => 'BOEOBO22BEC', 'name' => 'BANCO ECONOMICO S.A.', 'city' => 'SANTA CRUZ DE LA SIERRA']);
     Bank::create(['country_id' => '68', 'code' => 'BSCFBO22', 'name' => 'BANCO FASSIL S.A.', 'city' => 'SANTA CRUZ DE LA SIERRA']);
     Bank::create(['country_id' => '68', 'code' => 'BFORBOLP', 'name' => 'BANCO FORTALEZA SA', 'city' => 'LA PAZ']);
     Bank::create(['country_id' => '68', 'code' => 'GNDRBO22', 'name' => 'BANCO GANADERO S.A.', 'city' => 'SANTA CRUZ DE LA SIERRA']);
     Bank::create(['country_id' => '68', 'code' => 'GNDRBO22CMI', 'name' => 'BANCO GANADERO S.A.', 'city' => 'SANTA CRUZ DE LA SIERRA']);
     Bank::create(['country_id' => '68', 'code' => 'GNDRBO22FIT', 'name' => 'BANCO GANADERO S.A.', 'city' => 'SANTA CRUZ DE LA SIERRA']);
     Bank::create(['country_id' => '68', 'code' => 'GNDRBO22GEB', 'name' => 'BANCO GANADERO S.A.', 'city' => 'SANTA CRUZ DE LA SIERRA']);
     Bank::create(['country_id' => '68', 'code' => 'MERBBOLXCBB', 'name' => 'BANCO MERCANTIL SANTA CRUZ S.A.', 'city' => 'COCHABAMBA']);
     Bank::create(['country_id' => '68', 'code' => 'MERBBOLX', 'name' => 'BANCO MERCANTIL SANTA CRUZ S.A.', 'city' => 'LA PAZ']);
     Bank::create(['country_id' => '68', 'code' => 'MERBBOLXSCZ', 'name' => 'BANCO MERCANTIL SANTA CRUZ S.A.', 'city' => 'SANTA CRUZ DE LA SIERRA']);
     Bank::create(['country_id' => '68', 'code' => 'BNBOBOLXCBB', 'name' => 'BANCO NACIONAL DE BOLIVIA', 'city' => 'COCHABAMBA']);
     Bank::create(['country_id' => '68', 'code' => 'BNBOBOLXLPZ', 'name' => 'BANCO NACIONAL DE BOLIVIA', 'city' => 'LA PAZ']);
     Bank::create(['country_id' => '68', 'code' => 'BNBOBOLXTES', 'name' => 'BANCO NACIONAL DE BOLIVIA', 'city' => 'LA PAZ']);
     Bank::create(['country_id' => '68', 'code' => 'BNBOBOLX', 'name' => 'BANCO NACIONAL DE BOLIVIA', 'city' => 'LA PAZ']);
     Bank::create(['country_id' => '68', 'code' => 'BNBOBOLXORU', 'name' => 'BANCO NACIONAL DE BOLIVIA', 'city' => 'ORURO']);
     Bank::create(['country_id' => '68', 'code' => 'BNBOBOLXPOI', 'name' => 'BANCO NACIONAL DE BOLIVIA', 'city' => 'POTOSI']);
     Bank::create(['country_id' => '68', 'code' => 'BNBOBOLXSCZ', 'name' => 'BANCO NACIONAL DE BOLIVIA', 'city' => 'SANTA CRUZ DE LA SIERRA']);
     Bank::create(['country_id' => '68', 'code' => 'BNBOBOLXSRE', 'name' => 'BANCO NACIONAL DE BOLIVIA', 'city' => 'SUCRE']);
     Bank::create(['country_id' => '68', 'code' => 'BNBOBOLXTJA', 'name' => 'BANCO NACIONAL DE BOLIVIA', 'city' => 'TARIJA']);
     Bank::create(['country_id' => '68', 'code' => 'PRCBBO22', 'name' => 'BANCO PYME LOS ANDES PROCREDIT S.A.', 'city' => 'SANTA CRUZ DE LA SIERRA']);
     Bank::create(['country_id' => '68', 'code' => 'BSOLBOLP', 'name' => 'BANCO SOLIDARIO S.A.', 'city' => 'LA PAZ']);
     Bank::create(['country_id' => '68', 'code' => 'BAUNBO22CBB', 'name' => 'BANCO UNION S.A.', 'city' => 'COCHABAMBA']);
     Bank::create(['country_id' => '68', 'code' => 'BAUNBO22LPZ', 'name' => 'BANCO UNION S.A.', 'city' => 'LA PAZ']);
     Bank::create(['country_id' => '68', 'code' => 'BAUNBO22SCZ', 'name' => 'BANCO UNION S.A.', 'city' => 'SANTA CRUZ DE LA SIERRA']);
     Bank::create(['country_id' => '68', 'code' => 'BAUNBO22', 'name' => 'BANCO UNION S.A.', 'city' => 'SANTA CRUZ DE LA SIERRA']);
     /* brazil */
     Bank::create(['country_id' => '76', 'code' => 'ABCBBRSP', 'name' => 'BANCO ABC BRASIL S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'ABNABRSP', 'name' => 'BANCO ABN AMRO S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'AUFABRSP', 'name' => 'BANCO ALFA DE INVESTIMENTO S.A., SAO PAULO', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'AZTKBRCR', 'name' => 'BANCO AZTECA DO BRASIL S/A', 'city' => 'RECIFE']);
     Bank::create(['country_id' => '76', 'code' => 'BCLYBRSP', 'name' => 'BANCO BARCLAYS SA', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BBINBRRJ', 'name' => 'BANCO BBM S.A.', 'city' => 'RIO DE JANEIRO']);
     Bank::create(['country_id' => '76', 'code' => 'BBMFBRSP', 'name' => 'BANCO BMFBOVESPA DE SERVICOS DE LIQUIDACAO E CUSTODIA S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BBMFBRSPDBL', 'name' => 'BANCO BMFBOVESPA DE SERVICOS DE LIQUIDACAO E CUSTODIA S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BNPABRSPB2S', 'name' => 'BANCO BNP PARIBAS BRASIL S/A', 'city' => 'BRASILIA']);
     Bank::create(['country_id' => '76', 'code' => 'BNPABRSP', 'name' => 'BANCO BNP PARIBAS BRASIL S/A', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BBONBRSP', 'name' => 'BANCO BONSUCESSO SA', 'city' => 'BELO HORIZONTE']);
     Bank::create(['country_id' => '76', 'code' => 'BBDEBRSPBLM', 'name' => 'BANCO BRADESCO S.A.', 'city' => 'BELEM']);
     Bank::create(['country_id' => '76', 'code' => 'BBDEBRSPBHE', 'name' => 'BANCO BRADESCO S.A.', 'city' => 'BELO HORIZONTE']);
     Bank::create(['country_id' => '76', 'code' => 'BBDEBRSPBNU', 'name' => 'BANCO BRADESCO S.A.', 'city' => 'BLUMENAU']);
     Bank::create(['country_id' => '76', 'code' => 'BBDEBRSPBSA', 'name' => 'BANCO BRADESCO S.A.', 'city' => 'BRASILIA']);
     Bank::create(['country_id' => '76', 'code' => 'BBDEBRSPCAS', 'name' => 'BANCO BRADESCO S.A.', 'city' => 'CAMPINAS']);
     Bank::create(['country_id' => '76', 'code' => 'BBDEBRSPCTA', 'name' => 'BANCO BRADESCO S.A.', 'city' => 'CURITIBA']);
     Bank::create(['country_id' => '76', 'code' => 'BBDEBRSPFLA', 'name' => 'BANCO BRADESCO S.A.', 'city' => 'FORTALEZA']);
     Bank::create(['country_id' => '76', 'code' => 'BBDEBRSPFAC', 'name' => 'BANCO BRADESCO S.A.', 'city' => 'FRANCA']);
     Bank::create(['country_id' => '76', 'code' => 'BBDEBRSPJVE', 'name' => 'BANCO BRADESCO S.A.', 'city' => 'JOINVILLE']);
     Bank::create(['country_id' => '76', 'code' => 'BBDEBRSPMNS', 'name' => 'BANCO BRADESCO S.A.', 'city' => 'MANAUS']);
     Bank::create(['country_id' => '76', 'code' => 'BBDEBRSPNHO', 'name' => 'BANCO BRADESCO S.A.', 'city' => 'NOVO HAMBURGO']);
     Bank::create(['country_id' => '76', 'code' => 'BBDEBRSPDAC', 'name' => 'BANCO BRADESCO S.A.', 'city' => 'OSASCO']);
     Bank::create(['country_id' => '76', 'code' => 'BBDEBRSPPAE', 'name' => 'BANCO BRADESCO S.A.', 'city' => 'PORTO ALEGRE']);
     Bank::create(['country_id' => '76', 'code' => 'BBDEBRSPRCE', 'name' => 'BANCO BRADESCO S.A.', 'city' => 'RECIFE']);
     Bank::create(['country_id' => '76', 'code' => 'BBDEBRSPRJO', 'name' => 'BANCO BRADESCO S.A.', 'city' => 'RIO DE JANEIRO']);
     Bank::create(['country_id' => '76', 'code' => 'BBDEBRSPSDR', 'name' => 'BANCO BRADESCO S.A.', 'city' => 'SALVADOR']);
     Bank::create(['country_id' => '76', 'code' => 'BBDEBRSPSTS', 'name' => 'BANCO BRADESCO S.A.', 'city' => 'SANTOS']);
     Bank::create(['country_id' => '76', 'code' => 'BBDEBRSPCON', 'name' => 'BANCO BRADESCO S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BBDEBRSPBEX', 'name' => 'BANCO BRADESCO S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BBDEBRSPSPO', 'name' => 'BANCO BRADESCO S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BBDEBRSPCSH', 'name' => 'BANCO BRADESCO S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BBDEBRSPOCO', 'name' => 'BANCO BRADESCO S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BBDEBRSPMTZ', 'name' => 'BANCO BRADESCO S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BBDEBRSP', 'name' => 'BANCO BRADESCO S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BBDEBRSPVTA', 'name' => 'BANCO BRADESCO S.A.', 'city' => 'VITORIA']);
     Bank::create(['country_id' => '76', 'code' => 'BRJBBRRJ', 'name' => 'BANCO BRJ S.A.', 'city' => 'RIO DE JANEIRO']);
     Bank::create(['country_id' => '76', 'code' => 'BPABBRRJ', 'name' => 'BANCO BTG PACTUAL S.A.', 'city' => 'RIO DE JANEIRO']);
     Bank::create(['country_id' => '76', 'code' => 'CGDIBRSP', 'name' => 'BANCO CAIXA GERAL-BRASIL S/A', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BCBZBRSP', 'name' => 'BANCO CARGILL S/A', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BCBRBRDFORG', 'name' => 'BANCO CENTRAL DO BRASIL', 'city' => 'BRASILIA']);
     Bank::create(['country_id' => '76', 'code' => 'BCBRBRDFINT', 'name' => 'BANCO CENTRAL DO BRASIL', 'city' => 'BRASILIA']);
     Bank::create(['country_id' => '76', 'code' => 'BCBRBRDFBSA', 'name' => 'BANCO CENTRAL DO BRASIL', 'city' => 'BRASILIA']);
     Bank::create(['country_id' => '76', 'code' => 'BCBRBRDFSNC', 'name' => 'BANCO CENTRAL DO BRASIL', 'city' => 'BRASILIA']);
     Bank::create(['country_id' => '76', 'code' => 'BCBRBRDF', 'name' => 'BANCO CENTRAL DO BRASIL', 'city' => 'BRASILIA']);
     Bank::create(['country_id' => '76', 'code' => 'BCBRBRDFRJO', 'name' => 'BANCO CENTRAL DO BRASIL', 'city' => 'RIO DE JANEIRO']);
     Bank::create(['country_id' => '76', 'code' => 'BCBRBRDFSPO', 'name' => 'BANCO CENTRAL DO BRASIL', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'CITIBRBR', 'name' => 'BANCO CITIBANK SA', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BKCOBRSP', 'name' => 'BANCO CONFIDENCE DE CAMBIO SA', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BCSIBRRS', 'name' => 'BANCO COOPERATIVO SICREDI SA - BANSICREDI', 'city' => 'PORTO ALEGRE']);
     Bank::create(['country_id' => '76', 'code' => 'BAGBBRSP', 'name' => 'BANCO CREDIT AGRICOLE BRASIL SA', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'AMABBRAB', 'name' => 'BANCO DA AMAZONIA S.A.', 'city' => 'BELEM']);
     Bank::create(['country_id' => '76', 'code' => 'DAYCBRSP', 'name' => 'BANCO DAYCOVAL S/A', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BIGABRRJHGF', 'name' => 'BANCO DE INVESTIMENTOS CREDIT SUISSE (BRASIL) S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BIGABRRJ', 'name' => 'BANCO DE INVESTIMENTOS CREDIT SUISSE (BRASIL) S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BIGABRRJSPO', 'name' => 'BANCO DE INVESTIMENTOS CREDIT SUISSE (BRASIL) S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'NACNBRSPRJO', 'name' => 'BANCO DE LA NACION ARGENTINA', 'city' => 'RIO DE JANEIRO']);
     Bank::create(['country_id' => '76', 'code' => 'NACNBRSP', 'name' => 'BANCO DE LA NACION ARGENTINA', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'PRBABRSP', 'name' => 'BANCO DE LA PROVINCIA DE BUENOS AIRES', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BROUBRSP', 'name' => 'BANCO DE LA REPUBLICA ORIENTAL DEL URUGUAY', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BOTKBRSX', 'name' => 'BANCO DE TOKYO-MITSUBISHI UFJ BRASIL S/A', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BRASBRRJBHE', 'name' => 'BANCO DO BRASIL S.A.', 'city' => 'BELO HORIZONTE']);
     Bank::create(['country_id' => '76', 'code' => 'BRASBRRJBNU', 'name' => 'BANCO DO BRASIL S.A.', 'city' => 'BLUMENAU']);
     Bank::create(['country_id' => '76', 'code' => 'BRASBRRJBSA', 'name' => 'BANCO DO BRASIL S.A.', 'city' => 'BRASILIA']);
     Bank::create(['country_id' => '76', 'code' => 'BRASBRRJPPC', 'name' => 'BANCO DO BRASIL S.A.', 'city' => 'BRASILIA']);
     Bank::create(['country_id' => '76', 'code' => 'BRASBRRJSUP', 'name' => 'BANCO DO BRASIL S.A.', 'city' => 'BRASILIA']);
     Bank::create(['country_id' => '76', 'code' => 'BRASBRRJGFN', 'name' => 'BANCO DO BRASIL S.A.', 'city' => 'BRASILIA']);
     Bank::create(['country_id' => '76', 'code' => 'BRASBRRJ', 'name' => 'BANCO DO BRASIL S.A.', 'city' => 'BRASILIA']);
     Bank::create(['country_id' => '76', 'code' => 'BRASBRRJCAS', 'name' => 'BANCO DO BRASIL S.A.', 'city' => 'CAMPINAS']);
     Bank::create(['country_id' => '76', 'code' => 'BRASBRRJCSL', 'name' => 'BANCO DO BRASIL S.A.', 'city' => 'CAXIAS DO SUL']);
     Bank::create(['country_id' => '76', 'code' => 'BRASBRRJCTA', 'name' => 'BANCO DO BRASIL S.A.', 'city' => 'CURITIBA']);
     Bank::create(['country_id' => '76', 'code' => 'BRASBRRJFLA', 'name' => 'BANCO DO BRASIL S.A.', 'city' => 'FORTALEZA']);
     Bank::create(['country_id' => '76', 'code' => 'BRASBRRJPAE', 'name' => 'BANCO DO BRASIL S.A.', 'city' => 'PORTO ALEGRE']);
     Bank::create(['country_id' => '76', 'code' => 'BRASBRRJRCE', 'name' => 'BANCO DO BRASIL S.A.', 'city' => 'RECIFE']);
     Bank::create(['country_id' => '76', 'code' => 'BRASBRRJRPO', 'name' => 'BANCO DO BRASIL S.A.', 'city' => 'RIBEIRAO PRETO']);
     Bank::create(['country_id' => '76', 'code' => 'BRASBRRJCGR', 'name' => 'BANCO DO BRASIL S.A.', 'city' => 'RIO DE JANEIRO']);
     Bank::create(['country_id' => '76', 'code' => 'BRASBRRJRJ1', 'name' => 'BANCO DO BRASIL S.A.', 'city' => 'RIO DE JANEIRO']);
     Bank::create(['country_id' => '76', 'code' => 'BRASBRRJADR', 'name' => 'BANCO DO BRASIL S.A.', 'city' => 'RIO DE JANEIRO']);
     Bank::create(['country_id' => '76', 'code' => 'BRASBRRJRJO', 'name' => 'BANCO DO BRASIL S.A.', 'city' => 'RIO DE JANEIRO']);
     Bank::create(['country_id' => '76', 'code' => 'BRASBRRJRJ3', 'name' => 'BANCO DO BRASIL S.A.', 'city' => 'RIO DE JANEIRO']);
     Bank::create(['country_id' => '76', 'code' => 'BRASBRRJSDR', 'name' => 'BANCO DO BRASIL S.A.', 'city' => 'SALVADOR']);
     Bank::create(['country_id' => '76', 'code' => 'BRASBRRJIBR', 'name' => 'BANCO DO BRASIL S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BRASBRRJSBO', 'name' => 'BANCO DO BRASIL S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BRASBRRJSPO', 'name' => 'BANCO DO BRASIL S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BRASBRRJOCO', 'name' => 'BANCO DO BRASIL S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BRASBRRJVTA', 'name' => 'BANCO DO BRASIL S.A.', 'city' => 'VITORIA']);
     Bank::create(['country_id' => '76', 'code' => 'BEPABRAB', 'name' => 'BANCO DO ESTADO DO PARA S.A.', 'city' => 'BELEM']);
     Bank::create(['country_id' => '76', 'code' => 'BRGSBRRSPAE', 'name' => 'BANCO DO ESTADO DO RIO GRANDE DO SUL S/A', 'city' => 'PORTO ALEGRE']);
     Bank::create(['country_id' => '76', 'code' => 'BRGSBRRS', 'name' => 'BANCO DO ESTADO DO RIO GRANDE DO SUL S/A', 'city' => 'PORTO ALEGRE']);
     Bank::create(['country_id' => '76', 'code' => 'BNBRBRCFBHE', 'name' => 'BANCO DO NORDESTE DO BRASIL S/A', 'city' => 'BELO HORIZONTE']);
     Bank::create(['country_id' => '76', 'code' => 'BNBRBRCF', 'name' => 'BANCO DO NORDESTE DO BRASIL S/A', 'city' => 'FORTALEZA']);
     Bank::create(['country_id' => '76', 'code' => 'BNBRBRCFFLA', 'name' => 'BANCO DO NORDESTE DO BRASIL S/A', 'city' => 'FORTALEZA']);
     Bank::create(['country_id' => '76', 'code' => 'BNBRBRCFMCO', 'name' => 'BANCO DO NORDESTE DO BRASIL S/A', 'city' => 'MACEIO']);
     Bank::create(['country_id' => '76', 'code' => 'BNBRBRCFNTL', 'name' => 'BANCO DO NORDESTE DO BRASIL S/A', 'city' => 'NATAL']);
     Bank::create(['country_id' => '76', 'code' => 'BNBRBRCFRCE', 'name' => 'BANCO DO NORDESTE DO BRASIL S/A', 'city' => 'RECIFE']);
     Bank::create(['country_id' => '76', 'code' => 'BNBRBRCFRJO', 'name' => 'BANCO DO NORDESTE DO BRASIL S/A', 'city' => 'RIO DE JANEIRO']);
     Bank::create(['country_id' => '76', 'code' => 'BNBRBRCFSDR', 'name' => 'BANCO DO NORDESTE DO BRASIL S/A', 'city' => 'SALVADOR']);
     Bank::create(['country_id' => '76', 'code' => 'BNBRBRCFSPO', 'name' => 'BANCO DO NORDESTE DO BRASIL S/A', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'FIBIBRSP', 'name' => 'BANCO FIBRA S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BIBRBRSP', 'name' => 'BANCO INDUSTRIAL DO BRASIL S/A', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BICBBRSP', 'name' => 'BANCO INDUSTRIAL E COMERCIAL S.A. BICBANCO', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'IDVLBRSP', 'name' => 'BANCO INDUSVAL S/A', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'CHASBRSPDCC', 'name' => 'BANCO JP MORGAN S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'CHASBRSPGCC', 'name' => 'BANCO JP MORGAN S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'CHASBRSPTSM', 'name' => 'BANCO JP MORGAN S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'CHASBRSPKEY', 'name' => 'BANCO JP MORGAN S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'CHASBRSP', 'name' => 'BANCO JP MORGAN S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'KODBBRSP', 'name' => 'BANCO KDB DO BRASIL S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'KOEXBRSP', 'name' => 'BANCO KEB DO BRASIL S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BLBCBRSP', 'name' => 'BANCO LUSO BRASILEIRO S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BMAXBRRJ', 'name' => 'BANCO MAXIMA S.A.', 'city' => 'RIO DE JANEIRO']);
     Bank::create(['country_id' => '76', 'code' => 'BMBRBRRB', 'name' => 'BANCO MERCANTIL DO BRASIL S.A.', 'city' => 'BELO HORIZONTE']);
     Bank::create(['country_id' => '76', 'code' => 'MLBOBRSXTRA', 'name' => 'BANCO MERRILL LYNCH DE INVESTIMENTOS S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'MLBOBRSX', 'name' => 'BANCO MERRILL LYNCH DE INVESTIMENTOS S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'WELABRSP', 'name' => 'BANCO MIZUHO DO BRASIL S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'MODABRRJ', 'name' => 'BANCO MODAL S.A.', 'city' => 'RIO DE JANEIRO']);
     Bank::create(['country_id' => '76', 'code' => 'MSDWBRSP', 'name' => 'BANCO MORGAN STANLEY DEAN WITTER S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'MSDWBRSPTSY', 'name' => 'BANCO MORGAN STANLEY DEAN WITTER S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'NACDBRRJ', 'name' => 'BANCO NACIONAL DE DESENVOLVIMENTO ECONOMICO E SOCIAL - BNDES', 'city' => 'RIO DE JANEIRO']);
     Bank::create(['country_id' => '76', 'code' => 'BJBSBRSP', 'name' => 'BANCO ORIGINAL DO AGRONEGOCIO S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BORIBRSP', 'name' => 'BANCO ORIGINAL S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'OURIBRSP', 'name' => 'BANCO OURINVEST S.A', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BPNMBRSP', 'name' => 'BANCO PAN S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'PAULBRSP', 'name' => 'BANCO PAULISTA S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'PBBRBRSP', 'name' => 'BANCO PINE S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'RABOBRSP', 'name' => 'BANCO RABOBANK INTERNATIONAL BRASIL S/A', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'RENDBRSP', 'name' => 'BANCO RENDIMENTO S/A', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'SAFRBRSPRJO', 'name' => 'BANCO SAFRA S.A.', 'city' => 'RIO DE JANEIRO']);
     Bank::create(['country_id' => '76', 'code' => 'SAFRBRSP', 'name' => 'BANCO SAFRA S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'SAFRBRSPSPO', 'name' => 'BANCO SAFRA S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BSCHBRSPAST', 'name' => 'BANCO SANTANDER (BRASIL) S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BSCHBRSP', 'name' => 'BANCO SANTANDER (BRASIL) S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BSCHBRSPSPO', 'name' => 'BANCO SANTANDER (BRASIL) S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BSCHBRSPSEC', 'name' => 'BANCO SANTANDER (BRASIL) S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BSCHBRSPBKR', 'name' => 'BANCO SANTANDER (BRASIL) S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BSCHBRSPGEB', 'name' => 'BANCO SANTANDER (BRASIL) S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BSOGBRSP', 'name' => 'BANCO SOCIETE GENERALE BRASIL S/A', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BSBSBRSP', 'name' => 'BANCO SOFISA S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'SUBRBRSP', 'name' => 'BANCO SUMITOMO MITSUI BRASILEIRO S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'TOPZBRRS', 'name' => 'BANCO TOPAZIO S.A.', 'city' => 'PORTO ALEGRE']);
     Bank::create(['country_id' => '76', 'code' => 'BAVOBRSP', 'name' => 'BANCO VOTORANTIM S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BAVOBRSPCST', 'name' => 'BANCO VOTORANTIM S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'HVBKBRSP', 'name' => 'BANCO WOORI BANK DO BRASIL', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BEESBRRJ', 'name' => 'BANESTES S.A. - BANCO DO ESTADO DO ESPIRITO SANTO', 'city' => 'VITORIA']);
     Bank::create(['country_id' => '76', 'code' => 'BNIFBRRJ', 'name' => 'BANIF-BANCO INTERNACIONAL DO FUNCHAL (BRASIL), SA', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'MLBOBRSP', 'name' => 'BANK OF AMERICA MERRILL LYNCH BANCO MULTIPLO S.A', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BKCHBRSP', 'name' => 'BANK OF CHINA BRASIL S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BBMIBRRJ', 'name' => 'BBM I GESTAO DE RECURSOS LTDA', 'city' => 'RIO DE JANEIRO']);
     Bank::create(['country_id' => '76', 'code' => 'SCHABRSP', 'name' => 'BCV - BANCO DE CREDITO E VAREJO S.A', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BDMGBRRB', 'name' => 'BDMG-BANCO DE DESENVOLVIMENTO DE MINAS GERAIS', 'city' => 'BELO HORIZONTE']);
     Bank::create(['country_id' => '76', 'code' => 'BESBBRSPBES', 'name' => 'BES INVESTIMENTO DO BRASIL S/A-BANCO DE INVESTIMENTO', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BESBBRSP', 'name' => 'BES INVESTIMENTO DO BRASIL S/A-BANCO DE INVESTIMENTO', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'XBMFBRBRCRD', 'name' => 'BMF - CAMARA DE DERIVATIVOS', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'XBMFBRBR', 'name' => 'BMF - CAMARA DE DERIVATIVOS', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BNYMBRRJ', 'name' => 'BNY MELLON SERVICOS FINANCEIROS DTVM SA', 'city' => 'RIO DE JANEIRO']);
     Bank::create(['country_id' => '76', 'code' => 'XBMFBRSPDBL', 'name' => 'BOLSA DE MERCADORIAS E FUTUROS - BM E F', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'XBMFBRSPCRD', 'name' => 'BOLSA DE MERCADORIAS E FUTUROS - BM E F', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'XBMFBRSP', 'name' => 'BOLSA DE MERCADORIAS E FUTUROS - BM E F', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BPBMBRSP', 'name' => 'BPN BRASIL BANCO MULTIPLO S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BBDMBRSP', 'name' => 'BRAM-BRADESCO ASSET MANAGEMENT', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'PLURBRRJ', 'name' => 'BRASIL PLURAL S.A. BANCO MULTIPLO', 'city' => 'RIO DE JANEIRO']);
     Bank::create(['country_id' => '76', 'code' => 'BRBSBRDF', 'name' => 'BRB-BANCO DE BRASILIA S.A.', 'city' => 'BRASILIA']);
     Bank::create(['country_id' => '76', 'code' => 'CEFXBRSP', 'name' => 'CAIXA ECONOMICA FEDERAL', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'CCIPBRSP', 'name' => 'CAMARA INTERBANCARIA DE PAGAMENTOS-CIP', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'CITIBRSPRJO', 'name' => 'CITIBANK N.A.', 'city' => 'RIO DE JANEIRO']);
     Bank::create(['country_id' => '76', 'code' => 'CITIBRSPHOF', 'name' => 'CITIBANK N.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'CITIBRSPSEC', 'name' => 'CITIBANK N.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'CITIBRSP', 'name' => 'CITIBANK N.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'CITIBRSX', 'name' => 'CITIBANK N.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'CLCBBRRJ', 'name' => 'COMPANHIA BRASILEIRA DE LIQUIDACAO E CUSTODIA', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'DEUTBRSPRJO', 'name' => 'DEUTSCHE BANK S.A. - BANCO ALEMAO', 'city' => 'RIO DE JANEIRO']);
     Bank::create(['country_id' => '76', 'code' => 'DEUTBRSP', 'name' => 'DEUTSCHE BANK S.A. - BANCO ALEMAO', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'DEUTBRSPSPO', 'name' => 'DEUTSCHE BANK S.A. - BANCO ALEMAO', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BEXSBRSP', 'name' => 'DIDIER LEVY BANCO DE CAMBIO S/A', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'ESTRBRRJ', 'name' => 'ESTRATEGIA INVESTIMENTOS S/A CVC', 'city' => 'RIO DE JANEIRO']);
     Bank::create(['country_id' => '76', 'code' => 'GOLDBRSP', 'name' => 'GOLDMAN SACHS DO BRASIL BANCO MULTIPLO S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'GSBCBRSP', 'name' => 'GOLDMAN SACHS DO BRASIL CORRETORA DE VALORES MOBILIARIOS LTDA', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BCBBBRPRBLM', 'name' => 'HSBC BANK BRASIL S.A. - BANCO MULTIPLO', 'city' => 'BELEM']);
     Bank::create(['country_id' => '76', 'code' => 'BCBBBRPRBHE', 'name' => 'HSBC BANK BRASIL S.A. - BANCO MULTIPLO', 'city' => 'BELO HORIZONTE']);
     Bank::create(['country_id' => '76', 'code' => 'BCBBBRPRBNU', 'name' => 'HSBC BANK BRASIL S.A. - BANCO MULTIPLO', 'city' => 'BLUMENAU']);
     Bank::create(['country_id' => '76', 'code' => 'BCBBBRPRCAS', 'name' => 'HSBC BANK BRASIL S.A. - BANCO MULTIPLO', 'city' => 'CAMPINAS']);
     Bank::create(['country_id' => '76', 'code' => 'BCBBBRPRFDS', 'name' => 'HSBC BANK BRASIL S.A. - BANCO MULTIPLO', 'city' => 'CURITIBA']);
     Bank::create(['country_id' => '76', 'code' => 'BCBBBRPRTSY', 'name' => 'HSBC BANK BRASIL S.A. - BANCO MULTIPLO', 'city' => 'CURITIBA']);
     Bank::create(['country_id' => '76', 'code' => 'BCBBBRPRCTA', 'name' => 'HSBC BANK BRASIL S.A. - BANCO MULTIPLO', 'city' => 'CURITIBA']);
     Bank::create(['country_id' => '76', 'code' => 'BCBBBRPRFLA', 'name' => 'HSBC BANK BRASIL S.A. - BANCO MULTIPLO', 'city' => 'FORTALEZA']);
     Bank::create(['country_id' => '76', 'code' => 'BCBBBRPRJVE', 'name' => 'HSBC BANK BRASIL S.A. - BANCO MULTIPLO', 'city' => 'JOINVILLE']);
     Bank::create(['country_id' => '76', 'code' => 'BCBBBRPRMNS', 'name' => 'HSBC BANK BRASIL S.A. - BANCO MULTIPLO', 'city' => 'MANAUS']);
     Bank::create(['country_id' => '76', 'code' => 'BCBBBRPRPNG', 'name' => 'HSBC BANK BRASIL S.A. - BANCO MULTIPLO', 'city' => 'PARANAGUA']);
     Bank::create(['country_id' => '76', 'code' => 'BCBBBRPRPAE', 'name' => 'HSBC BANK BRASIL S.A. - BANCO MULTIPLO', 'city' => 'PORTO ALEGRE']);
     Bank::create(['country_id' => '76', 'code' => 'BCBBBRPRRCE', 'name' => 'HSBC BANK BRASIL S.A. - BANCO MULTIPLO', 'city' => 'RECIFE']);
     Bank::create(['country_id' => '76', 'code' => 'BCBBBRPRRJO', 'name' => 'HSBC BANK BRASIL S.A. - BANCO MULTIPLO', 'city' => 'RIO DE JANEIRO']);
     Bank::create(['country_id' => '76', 'code' => 'BCBBBRPRSDR', 'name' => 'HSBC BANK BRASIL S.A. - BANCO MULTIPLO', 'city' => 'SALVADOR']);
     Bank::create(['country_id' => '76', 'code' => 'BCBBBRPRSTS', 'name' => 'HSBC BANK BRASIL S.A. - BANCO MULTIPLO', 'city' => 'SANTOS']);
     Bank::create(['country_id' => '76', 'code' => 'BCBBBRPRCGB', 'name' => 'HSBC BANK BRASIL S.A. - BANCO MULTIPLO', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BCBBBRPR', 'name' => 'HSBC BANK BRASIL S.A. - BANCO MULTIPLO', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BCBBBRPROFS', 'name' => 'HSBC BANK BRASIL S.A. - BANCO MULTIPLO', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BCBBBRPRCOR', 'name' => 'HSBC BANK BRASIL S.A. - BANCO MULTIPLO', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BCBBBRPRNET', 'name' => 'HSBC BANK BRASIL S.A. - BANCO MULTIPLO', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BCBBBRPRSPO', 'name' => 'HSBC BANK BRASIL S.A. - BANCO MULTIPLO', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'BCBBBRPRVTA', 'name' => 'HSBC BANK BRASIL S.A. - BANCO MULTIPLO', 'city' => 'VITORIA']);
     Bank::create(['country_id' => '76', 'code' => 'ICATBRRJ', 'name' => 'ICATU DTVM LTDA.', 'city' => 'RIO DE JANEIRO']);
     Bank::create(['country_id' => '76', 'code' => 'ICBKBRSP', 'name' => 'INDUSTRIAL AND COMMERCIAL BANK OF CHINA(BRAZIL)', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'INGBBRSPATA', 'name' => 'ING BANK N.V.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'INGBBRSP', 'name' => 'ING BANK N.V.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'ITAUBRSPBHE', 'name' => 'ITAU UNIBANCO S/A', 'city' => 'BELO HORIZONTE']);
     Bank::create(['country_id' => '76', 'code' => 'ITAUBRSPBNU', 'name' => 'ITAU UNIBANCO S/A', 'city' => 'BLUMENAU']);
     Bank::create(['country_id' => '76', 'code' => 'ITAUBRSPCAS', 'name' => 'ITAU UNIBANCO S/A', 'city' => 'CAMPINAS']);
     Bank::create(['country_id' => '76', 'code' => 'ITAUBRSPCTA', 'name' => 'ITAU UNIBANCO S/A', 'city' => 'CURITIBA']);
     Bank::create(['country_id' => '76', 'code' => 'ITAUBRSPJVE', 'name' => 'ITAU UNIBANCO S/A', 'city' => 'JOINVILLE']);
     Bank::create(['country_id' => '76', 'code' => 'ITAUBRSPNHO', 'name' => 'ITAU UNIBANCO S/A', 'city' => 'NOVO HAMBURGO']);
     Bank::create(['country_id' => '76', 'code' => 'ITAUBRSPPAE', 'name' => 'ITAU UNIBANCO S/A', 'city' => 'PORTO ALEGRE']);
     Bank::create(['country_id' => '76', 'code' => 'ITAUBRSPRJO', 'name' => 'ITAU UNIBANCO S/A', 'city' => 'RIO DE JANEIRO']);
     Bank::create(['country_id' => '76', 'code' => 'ITAUBRSPADR', 'name' => 'ITAU UNIBANCO S/A', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'ITAUBRSPLOC', 'name' => 'ITAU UNIBANCO S/A', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'ITAUBRSPINT', 'name' => 'ITAU UNIBANCO S/A', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'ITAUBRSPISS', 'name' => 'ITAU UNIBANCO S/A', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'ITAUBRSP', 'name' => 'ITAU UNIBANCO S/A', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'ITAUBRSPSPO', 'name' => 'ITAU UNIBANCO S/A', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'CBBABRSPBHE', 'name' => 'ITAU UNIBANCO S/A (SUCCESSOR OF BANCO ITAU BBA S.A.)', 'city' => 'BELO HORIZONTE']);
     Bank::create(['country_id' => '76', 'code' => 'CBBABRSPCAS', 'name' => 'ITAU UNIBANCO S/A (SUCCESSOR OF BANCO ITAU BBA S.A.)', 'city' => 'CAMPINAS']);
     Bank::create(['country_id' => '76', 'code' => 'CBBABRSPPAE', 'name' => 'ITAU UNIBANCO S/A (SUCCESSOR OF BANCO ITAU BBA S.A.)', 'city' => 'PORTO ALEGRE']);
     Bank::create(['country_id' => '76', 'code' => 'CBBABRSPRJO', 'name' => 'ITAU UNIBANCO S/A (SUCCESSOR OF BANCO ITAU BBA S.A.)', 'city' => 'RIO DE JANEIRO']);
     Bank::create(['country_id' => '76', 'code' => 'CBBABRSP', 'name' => 'ITAU UNIBANCO S/A (SUCCESSOR OF BANCO ITAU BBA S.A.)', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'DABEBRSXIBA', 'name' => 'MERCEDES-BENZ DO BRASIL LTDA', 'city' => 'SAO BERNARDO DO CAMPO']);
     Bank::create(['country_id' => '76', 'code' => 'DABEBRSX', 'name' => 'MERCEDES-BENZ DO BRASIL LTDA', 'city' => 'SAO BERNARDO DO CAMPO']);
     Bank::create(['country_id' => '76', 'code' => 'MIAEBRSP', 'name' => 'MIRAE ASSET SECURITIES (BRASIL) CORRETORA DE CAMBIO, TITULOS E VALORES MOBILIARIOS LTDA.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'NESNBRSX', 'name' => 'NESTLE BRAZIL LTDA', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'COMEBRRS', 'name' => 'NOVO BANCO CONTINENTAL S.A.', 'city' => 'PORTO ALEGRE']);
     Bank::create(['country_id' => '76', 'code' => 'PARABRPR', 'name' => 'PARANA BANCO S.A.', 'city' => 'CURITIBA']);
     Bank::create(['country_id' => '76', 'code' => 'PEBRBRRJ001', 'name' => 'PETROLEO BRASILEIRO S.A.-PETROBRAS', 'city' => 'RIO DE JANEIRO']);
     Bank::create(['country_id' => '76', 'code' => 'PEBRBRRJ', 'name' => 'PETROLEO BRASILEIRO S.A.-PETROBRAS', 'city' => 'RIO DE JANEIRO']);
     Bank::create(['country_id' => '76', 'code' => 'SSSBBRSP', 'name' => 'SANTANDER SECURITIES SERVICES BRASIL DISTRIBUIDORA DE TTULOS E VALORES MOBILIRIOS S.A.', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'NOSCBRSP', 'name' => 'SCOTIABANK BRASIL S.A.-BANCO MULTIPLO', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'SCBLBRSP', 'name' => 'STANDARD CHARTERED BANK (BRASIL) S.A.-BANCO DE INVESTIMENTO', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'DATRBRSX', 'name' => 'STAREXPORT TRADING S.A.', 'city' => 'SAO BERNARDO DO CAMPO']);
     Bank::create(['country_id' => '76', 'code' => 'TRUIBRSP', 'name' => 'TRUSTEE INVESTMENTS S/A', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'VAEEBRRJ', 'name' => 'VALE S.A.', 'city' => 'RIO DE JANEIRO']);
     Bank::create(['country_id' => '76', 'code' => 'VCTMBRSP', 'name' => 'VOTORANTIM CORRETORA DE TIT E VAL MOB LTDA', 'city' => 'SAO PAULO']);
     Bank::create(['country_id' => '76', 'code' => 'WWIABRSP', 'name' => 'WWI ADMINISTRACAO DE RECURSOS LTDA', 'city' => 'SAO PAULO']);
     /* chile */
     Bank::create(['country_id' => '152', 'code' => 'BICECLRM', 'name' => 'BANCO BICE', 'city' => 'SANTIAGO']);
     Bank::create(['country_id' => '152', 'code' => 'BHIFCLRM', 'name' => 'BANCO BILBAO VIZCAYA ARGENTARIA, CHILE', 'city' => 'SANTIAGO']);
     Bank::create(['country_id' => '152', 'code' => 'BPABCLRM', 'name' => 'BANCO BTG PACTUAL CHILE', 'city' => 'SANTIAGO']);
     //Bank::create(['country_id' => '152', 'code' => 'BCECCLRD', 'name' => 'BANCO CENTRAL DE CHILE', 'city' => 'SANTIAGO']);
     //Bank::create(['country_id' => '152', 'code' => 'BCECCLRF', 'name' => 'BANCO CENTRAL DE CHILE', 'city' => 'SANTIAGO']);
     Bank::create(['country_id' => '152', 'code' => 'BCECCLRM', 'name' => 'BANCO CENTRAL DE CHILE', 'city' => 'SANTIAGO']);
     Bank::create(['country_id' => '152', 'code' => 'MNEXCLRM', 'name' => 'BANCO CONSORCIO', 'city' => 'SANTIAGO']);
     //Bank::create(['country_id' => '152', 'code' => 'BCHICLRMEXP', 'name' => 'BANCO DE CHILE', 'city' => 'SANTIAGO']);
     //Bank::create(['country_id' => '152', 'code' => 'BCHICLRMIMP', 'name' => 'BANCO DE CHILE', 'city' => 'SANTIAGO']);
     //Bank::create(['country_id' => '152', 'code' => 'BCHICLRMIOB', 'name' => 'BANCO DE CHILE', 'city' => 'SANTIAGO']);
     Bank::create(['country_id' => '152', 'code' => 'BCHICLRM', 'name' => 'BANCO DE CHILE', 'city' => 'SANTIAGO']);
     Bank::create(['country_id' => '152', 'code' => 'CITICLRS', 'name' => 'BANCO DE CHILE, AS LEGAL SUCCESOR OF CITIBANK CHILE', 'city' => 'SANTIAGO']);
     Bank::create(['country_id' => '152', 'code' => 'CREDCLRM', 'name' => 'BANCO DE CREDITO E INVERSIONES', 'city' => 'SANTIAGO']);
     Bank::create(['country_id' => '152', 'code' => 'NACNCLRM', 'name' => 'BANCO DE LA NACION ARGENTINA', 'city' => 'SANTIAGO']);
     Bank::create(['country_id' => '152', 'code' => 'BECHCLRM', 'name' => 'BANCO DEL ESTADO DE CHILE', 'city' => 'SANTIAGO']);
     Bank::create(['country_id' => '152', 'code' => 'BRASCLRM', 'name' => 'BANCO DO BRASIL S.A.', 'city' => 'SANTIAGO']);
     Bank::create(['country_id' => '152', 'code' => 'FALACLRM', 'name' => 'BANCO FALABELLA', 'city' => 'SANTIAGO']);
     Bank::create(['country_id' => '152', 'code' => 'BICHCLRM', 'name' => 'BANCO INTERNACIONAL', 'city' => 'SANTIAGO']);
     //Bank::create(['country_id' => '152', 'code' => 'ITAUCLRMSSO', 'name' => 'BANCO ITAU CHILE', 'city' => 'SANTIAGO']);
     Bank::create(['country_id' => '152', 'code' => 'ITAUCLRM', 'name' => 'BANCO ITAU CHILE', 'city' => 'SANTIAGO']);
     Bank::create(['country_id' => '152', 'code' => 'BCNPCLRM', 'name' => 'BANCO PARIS', 'city' => 'SANTIAGO']);
     Bank::create(['country_id' => '152', 'code' => 'BPENCLRM', 'name' => 'BANCO PENTA', 'city' => 'SANTIAGO']);
     Bank::create(['country_id' => '152', 'code' => 'RPLYCLRM', 'name' => 'BANCO RIPLEY', 'city' => 'SANTIAGO']);
     Bank::create(['country_id' => '152', 'code' => 'BSCHCLRM', 'name' => 'BANCO SANTANDER CHILE', 'city' => 'SANTIAGO']);
     //Bank::create(['country_id' => '152', 'code' => 'BSCHCLRMGST', 'name' => 'BANCO SANTANDER CHILE', 'city' => 'SANTIAGO']);
     Bank::create(['country_id' => '152', 'code' => 'BSCLCLRM', 'name' => 'BANCO SECURITY', 'city' => 'SANTIAGO']);
     Bank::create(['country_id' => '152', 'code' => 'BOTKCLRM', 'name' => 'BANK OF TOKYO-MITSUBISHI UFJ, LTD., THE', 'city' => 'SANTIAGO']);
     Bank::create(['country_id' => '152', 'code' => 'GINACLRM', 'name' => 'CASA DE CAMBIOS GUINAZU S.A.', 'city' => 'SANTIAGO']);
     Bank::create(['country_id' => '152', 'code' => 'ECCVCLRM', 'name' => 'CCLV, CONTRAPARTE CENTRAL S.A.', 'city' => 'SANTIAGO']);
     Bank::create(['country_id' => '152', 'code' => 'PCCACLRM', 'name' => 'COMBANC S.A.', 'city' => 'SANTIAGO']);
     //Bank::create(['country_id' => '152', 'code' => 'CDERCLRG', 'name' => 'COMDER CONTRAPARTE CENTRAL S.A.', 'city' => 'SANTIAGO']);
     Bank::create(['country_id' => '152', 'code' => 'CDERCLRM', 'name' => 'COMDER CONTRAPARTE CENTRAL S.A.', 'city' => 'SANTIAGO']);
     Bank::create(['country_id' => '152', 'code' => 'CONBCLRM', 'name' => 'CORP BANCA', 'city' => 'SANTIAGO']);
     Bank::create(['country_id' => '152', 'code' => 'DCVVCLRM', 'name' => 'DEPOSITO CENTRAL DE VALORES S.A.', 'city' => 'SANTIAGO']);
     Bank::create(['country_id' => '152', 'code' => 'DEUTCLRM', 'name' => 'DEUTSCHE BANK (CHILE) S.A.', 'city' => 'SANTIAGO']);
     Bank::create(['country_id' => '152', 'code' => 'DNBACLRM', 'name' => 'DNB BANK ASA, AGENCIA EN CHILE', 'city' => 'SANTIAGO']);
     Bank::create(['country_id' => '152', 'code' => 'BLICCLRM', 'name' => 'HSBC BANK (CHILE)', 'city' => 'SANTIAGO']);
     //Bank::create(['country_id' => '152', 'code' => 'CHASCLRMKEY', 'name' => 'JPMORGAN CHASE BANK, N.A.', 'city' => 'SANTIAGO']);
     Bank::create(['country_id' => '152', 'code' => 'CHASCLRM', 'name' => 'JPMORGAN CHASE BANK, N.A.', 'city' => 'SANTIAGO']);
     Bank::create(['country_id' => '152', 'code' => 'RABOCLRM', 'name' => 'RABOBANK CHILE', 'city' => 'SANTIAGO']);
     //Bank::create(['country_id' => '152', 'code' => 'BKSACLRM064', 'name' => 'SCOTIABANK CHILE', 'city' => 'ARICA']);
     //Bank::create(['country_id' => '152', 'code' => 'BKSACLRM068', 'name' => 'SCOTIABANK CHILE', 'city' => 'CONCEPCION']);
     //Bank::create(['country_id' => '152', 'code' => 'BKSACLRM055', 'name' => 'SCOTIABANK CHILE', 'city' => 'IQUIQUE']);
     Bank::create(['country_id' => '152', 'code' => 'BKSACLRM', 'name' => 'SCOTIABANK CHILE', 'city' => 'SANTIAGO']);
     //Bank::create(['country_id' => '152', 'code' => 'BKSACLRM061', 'name' => 'SCOTIABANK CHILE', 'city' => 'VALPARAISO']);
     Bank::create(['country_id' => '152', 'code' => 'FTLNCLRM', 'name' => 'TANNER SERVICIOS FINANCIEROS S.A.', 'city' => 'SANTIAGO']);
     /* Colombia */
     Bank::create(['country_id' => '170', 'code' => 'ACHCCOBB', 'name' => 'ACH COLOMBIA S.A.', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'HUBCCOBBLWE', 'name' => 'ALLIANCE ENTERPRISE S.A.S.', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'HUBCCOBB', 'name' => 'ALLIANCE ENTERPRISE S.A.S.', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'GEXICOBB', 'name' => 'ALMACENES EXITO S.A. (GRUPO EXITO)', 'city' => 'ENVIGADO']);
     Bank::create(['country_id' => '170', 'code' => 'CCAICOBB', 'name' => 'BANCO AGRARIO DE COLOMBIA S.A. (FORMERLY CAJA DE CREDITO AGRARIO INDUSTRIAL Y MINERO)', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'BAVICOBB', 'name' => 'BANCO AV VILLAS S.A.', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'GEROCOBBBO1', 'name' => 'BANCO BILBAO VIZCAYA ARGENTARIA COLOMBIA S.A.', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'GEROCOBB', 'name' => 'BANCO BILBAO VIZCAYA ARGENTARIA COLOMBIA S.A.', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'CASOCOBB', 'name' => 'BANCO CAJA SOCIAL', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'COLPCOBB', 'name' => 'BANCO COLPATRIA', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'BCTOCOBBBAQ', 'name' => 'BANCO CORPBANCA COLOMBIA S.A ( FORMERLY HELM BANK)', 'city' => 'BARRANQUILLA']);
     Bank::create(['country_id' => '170', 'code' => 'BCTOCOBB', 'name' => 'BANCO CORPBANCA COLOMBIA S.A ( FORMERLY HELM BANK)', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'BCTOCOBBCL1', 'name' => 'BANCO CORPBANCA COLOMBIA S.A ( FORMERLY HELM BANK)', 'city' => 'CALI']);
     Bank::create(['country_id' => '170', 'code' => 'BCTOCOBBMD1', 'name' => 'BANCO CORPBANCA COLOMBIA S.A ( FORMERLY HELM BANK)', 'city' => 'MEDELLIN']);
     Bank::create(['country_id' => '170', 'code' => 'BSCHCOBBBAQ', 'name' => 'BANCO CORPBANCA COLOMBIA S.A.', 'city' => 'BARRANQUILLA']);
     Bank::create(['country_id' => '170', 'code' => 'BSCHCOBBSSC', 'name' => 'BANCO CORPBANCA COLOMBIA S.A.', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'BSCHCOBB', 'name' => 'BANCO CORPBANCA COLOMBIA S.A.', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'BSCHCOBBBO1', 'name' => 'BANCO CORPBANCA COLOMBIA S.A.', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'BSCHCOBBCL1', 'name' => 'BANCO CORPBANCA COLOMBIA S.A.', 'city' => 'CALI']);
     Bank::create(['country_id' => '170', 'code' => 'CAFECOBBBAQ', 'name' => 'BANCO DAVIVIENDA S.A.(FORMERLY GRANBANCO BANCAFE S.A.)', 'city' => 'BARRANQUILLA']);
     Bank::create(['country_id' => '170', 'code' => 'CAFECOBB', 'name' => 'BANCO DAVIVIENDA S.A.(FORMERLY GRANBANCO BANCAFE S.A.)', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'CAFECOBBCL1', 'name' => 'BANCO DAVIVIENDA S.A.(FORMERLY GRANBANCO BANCAFE S.A.)', 'city' => 'CALI']);
     Bank::create(['country_id' => '170', 'code' => 'CAFECOBBMD1', 'name' => 'BANCO DAVIVIENDA S.A.(FORMERLY GRANBANCO BANCAFE S.A.)', 'city' => 'MEDELLIN']);
     Bank::create(['country_id' => '170', 'code' => 'BBOGCOBBBAQ', 'name' => 'BANCO DE BOGOTA', 'city' => 'BARRANQUILLA']);
     Bank::create(['country_id' => '170', 'code' => 'BBOGCOBBBO1', 'name' => 'BANCO DE BOGOTA', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'BBOGCOBB', 'name' => 'BANCO DE BOGOTA', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'BBOGCOBBBGA', 'name' => 'BANCO DE BOGOTA', 'city' => 'BUCARAMANGA']);
     Bank::create(['country_id' => '170', 'code' => 'BBOGCOBBCL1', 'name' => 'BANCO DE BOGOTA', 'city' => 'CALI']);
     Bank::create(['country_id' => '170', 'code' => 'BBOGCOBBCTG', 'name' => 'BANCO DE BOGOTA', 'city' => 'CARTAGENA']);
     Bank::create(['country_id' => '170', 'code' => 'BBOGCOBBCUC', 'name' => 'BANCO DE BOGOTA', 'city' => 'CUCUTA']);
     Bank::create(['country_id' => '170', 'code' => 'BBOGCOBBMZ1', 'name' => 'BANCO DE BOGOTA', 'city' => 'MANIZALES']);
     Bank::create(['country_id' => '170', 'code' => 'BBOGCOBBMD1', 'name' => 'BANCO DE BOGOTA', 'city' => 'MEDELLIN']);
     Bank::create(['country_id' => '170', 'code' => 'BBOGCOBBPEI', 'name' => 'BANCO DE BOGOTA', 'city' => 'PEREIRA']);
     Bank::create(['country_id' => '170', 'code' => 'BBOGCOBBADZ', 'name' => 'BANCO DE BOGOTA', 'city' => 'SAN ANDRES']);
     Bank::create(['country_id' => '170', 'code' => 'BCEXCOBB', 'name' => 'BANCO DE COMERCIO EXTERIOR S.A.', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'BREPCOBB', 'name' => 'BANCO DE LA REPUBLICA', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'OCCICOBCBAQ', 'name' => 'BANCO DE OCCIDENTE', 'city' => 'BARRANQUILLA']);
     Bank::create(['country_id' => '170', 'code' => 'OCCICOBCBO2', 'name' => 'BANCO DE OCCIDENTE', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'OCCICOBCBGA', 'name' => 'BANCO DE OCCIDENTE', 'city' => 'BUCARAMANGA']);
     Bank::create(['country_id' => '170', 'code' => 'OCCICOBCCL1', 'name' => 'BANCO DE OCCIDENTE', 'city' => 'CALI']);
     Bank::create(['country_id' => '170', 'code' => 'OCCICOBC', 'name' => 'BANCO DE OCCIDENTE', 'city' => 'CALI']);
     Bank::create(['country_id' => '170', 'code' => 'OCCICOBCCTG', 'name' => 'BANCO DE OCCIDENTE', 'city' => 'CARTAGENA']);
     Bank::create(['country_id' => '170', 'code' => 'OCCICOBCMD4', 'name' => 'BANCO DE OCCIDENTE', 'city' => 'MEDELLIN']);
     Bank::create(['country_id' => '170', 'code' => 'OCCICOBCADZ', 'name' => 'BANCO DE OCCIDENTE', 'city' => 'SAN ANDRES']);
     Bank::create(['country_id' => '170', 'code' => 'FALACOBB', 'name' => 'BANCO FALABELLA S.A.', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'BSUDCOBBBAQ', 'name' => 'BANCO GNB SUDAMERIS', 'city' => 'BARRANQUILLA']);
     Bank::create(['country_id' => '170', 'code' => 'BSUDCOBB', 'name' => 'BANCO GNB SUDAMERIS', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'BSUDCOBBBGA', 'name' => 'BANCO GNB SUDAMERIS', 'city' => 'BUCARAMANGA']);
     Bank::create(['country_id' => '170', 'code' => 'BSUDCOBBCL1', 'name' => 'BANCO GNB SUDAMERIS', 'city' => 'CALI']);
     Bank::create(['country_id' => '170', 'code' => 'BSUDCOBBCTG', 'name' => 'BANCO GNB SUDAMERIS', 'city' => 'CARTAGENA']);
     Bank::create(['country_id' => '170', 'code' => 'BSUDCOBBMZ1', 'name' => 'BANCO GNB SUDAMERIS', 'city' => 'MANIZALES']);
     Bank::create(['country_id' => '170', 'code' => 'BSUDCOBBMD1', 'name' => 'BANCO GNB SUDAMERIS', 'city' => 'MEDELLIN']);
     Bank::create(['country_id' => '170', 'code' => 'PICHCOBB', 'name' => 'BANCO PICHINCHA S.A.', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'BPOPCOBBAXM', 'name' => 'BANCO POPULAR-COLOMBIA', 'city' => 'ARMENIA']);
     Bank::create(['country_id' => '170', 'code' => 'BPOPCOBBBAQ', 'name' => 'BANCO POPULAR-COLOMBIA', 'city' => 'BARRANQUILLA']);
     Bank::create(['country_id' => '170', 'code' => 'BPOPCOBB', 'name' => 'BANCO POPULAR-COLOMBIA', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'BPOPCOBBBO1', 'name' => 'BANCO POPULAR-COLOMBIA', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'BPOPCOBBBO2', 'name' => 'BANCO POPULAR-COLOMBIA', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'BPOPCOBBBO3', 'name' => 'BANCO POPULAR-COLOMBIA', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'BPOPCOBBBGA', 'name' => 'BANCO POPULAR-COLOMBIA', 'city' => 'BUCARAMANGA']);
     Bank::create(['country_id' => '170', 'code' => 'BPOPCOBBCL1', 'name' => 'BANCO POPULAR-COLOMBIA', 'city' => 'CALI']);
     Bank::create(['country_id' => '170', 'code' => 'BPOPCOBBCTG', 'name' => 'BANCO POPULAR-COLOMBIA', 'city' => 'CARTAGENA']);
     Bank::create(['country_id' => '170', 'code' => 'BPOPCOBBIBE', 'name' => 'BANCO POPULAR-COLOMBIA', 'city' => 'IBAGUE']);
     Bank::create(['country_id' => '170', 'code' => 'BPOPCOBBMZ1', 'name' => 'BANCO POPULAR-COLOMBIA', 'city' => 'MANIZALES']);
     Bank::create(['country_id' => '170', 'code' => 'BPOPCOBBMD1', 'name' => 'BANCO POPULAR-COLOMBIA', 'city' => 'MEDELLIN']);
     Bank::create(['country_id' => '170', 'code' => 'BPOPCOBBPEI', 'name' => 'BANCO POPULAR-COLOMBIA', 'city' => 'PEREIRA']);
     Bank::create(['country_id' => '170', 'code' => 'BPOPCOBBADZ', 'name' => 'BANCO POPULAR-COLOMBIA', 'city' => 'SAN ANDRES']);
     Bank::create(['country_id' => '170', 'code' => 'PRCBCOBB', 'name' => 'BANCO PROCREDIT COLOMBIA SA', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'SANTCOBB', 'name' => 'BANCO SANTANDER DE NEGOCIOS COLOMBIA S.A.', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'COLOCOBMBAQ', 'name' => 'BANCOLOMBIA S.A.', 'city' => 'BARRANQUILLA']);
     Bank::create(['country_id' => '170', 'code' => 'COLOCOBMBGA', 'name' => 'BANCOLOMBIA S.A.', 'city' => 'BUCARAMANGA']);
     Bank::create(['country_id' => '170', 'code' => 'COLOCOBMCL1', 'name' => 'BANCOLOMBIA S.A.', 'city' => 'CALI']);
     Bank::create(['country_id' => '170', 'code' => 'COLOCOBMCTG', 'name' => 'BANCOLOMBIA S.A.', 'city' => 'CARTAGENA']);
     Bank::create(['country_id' => '170', 'code' => 'COLOCOBM', 'name' => 'BANCOLOMBIA S.A.', 'city' => 'MEDELLIN']);
     Bank::create(['country_id' => '170', 'code' => 'COLOCOBMMD1', 'name' => 'BANCOLOMBIA S.A.', 'city' => 'MEDELLIN']);
     Bank::create(['country_id' => '170', 'code' => 'COLOCOBMPEI', 'name' => 'BANCOLOMBIA S.A.', 'city' => 'PEREIRA']);
     Bank::create(['country_id' => '170', 'code' => 'FBBVCOBB', 'name' => 'BBVA ASSET MANAGEMENT SOCIEDAD FIDUCIARIA', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'BNPACOBBB2S', 'name' => 'BNP PARIBAS COLOMBIA CORPORACION FINANCIERA S.A.', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'BNPACOBB', 'name' => 'BNP PARIBAS COLOMBIA CORPORACION FINANCIERA S.A.', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'CCSFCOBB', 'name' => 'CAJA COLOMBIANA DE SUBSIDIO FAMILIAR COLSUBSIDIO', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'CCDCCOBB', 'name' => 'CAMARA DE COMPENSACION DE DIVISAS DE COLOMBIA S.A.', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'CTYSCOBC', 'name' => 'CARVAJAL SERVICIOS S.AS.', 'city' => 'CALI']);
     Bank::create(['country_id' => '170', 'code' => 'CTLHCOBB', 'name' => 'CENIT TRANSPORTE Y LOGISTICA DE HIDROCARBUROS S.A.S.', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'CITICOBB', 'name' => 'CITIBANK COLOMBIA', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'TIGOCOBB', 'name' => 'COLOMBIA MOVIL SA ESP', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'CLTECOBM', 'name' => 'COLTEFINANCIERA S.A. COMPANIA DE FINANCIAMIENTO COMERCIAL', 'city' => 'MEDELLIN']);
     Bank::create(['country_id' => '170', 'code' => 'PDBCCOBB', 'name' => 'COMPANIA DE PROFESIONALES DE BOLSA S.A.', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'CFVACOBCBAQ', 'name' => 'CORPORACION FINANCIERA COLOMBIANA (FORMERLY CORPORACION FINANCIERA DEL VALLE S.A.)', 'city' => 'BARRANQUILLA']);
     Bank::create(['country_id' => '170', 'code' => 'CFVACOBCBO1', 'name' => 'CORPORACION FINANCIERA COLOMBIANA (FORMERLY CORPORACION FINANCIERA DEL VALLE S.A.)', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'CFVACOBC', 'name' => 'CORPORACION FINANCIERA COLOMBIANA (FORMERLY CORPORACION FINANCIERA DEL VALLE S.A.)', 'city' => 'CALI']);
     Bank::create(['country_id' => '170', 'code' => 'CFVACOBCCL1', 'name' => 'CORPORACION FINANCIERA COLOMBIANA (FORMERLY CORPORACION FINANCIERA DEL VALLE S.A.)', 'city' => 'CALI']);
     Bank::create(['country_id' => '170', 'code' => 'CFVACOBCFXO', 'name' => 'CORPORACION FINANCIERA COLOMBIANA (FORMERLY CORPORACION FINANCIERA DEL VALLE S.A.)', 'city' => 'CALI']);
     Bank::create(['country_id' => '170', 'code' => 'CFVACOBCMD1', 'name' => 'CORPORACION FINANCIERA COLOMBIANA (FORMERLY CORPORACION FINANCIERA DEL VALLE S.A.)', 'city' => 'MEDELLIN']);
     Bank::create(['country_id' => '170', 'code' => 'CRVLCOBB', 'name' => 'CORREVAL S.A.', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'ECOPCOBB', 'name' => 'ECOPETROL S.A.', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'ETBCCOBB', 'name' => 'EMPRESA DE TELECOMUNICACIONES DE BOGOTA S.A E.SP.', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'FBOGCOBB', 'name' => 'FIDUCIARIA BOGOTA', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'FENSCOBB', 'name' => 'FINANCIERA DE DESARROLLO NACIONAL S.A. FORMALLY FINANCIERA ENERGETICA NACIONAL S.A.-FEN', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'FOGICOBB', 'name' => 'FONDO DE GARANTIAS DE INSTITUCIONES FINANCIERAS', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'FLARCOBB', 'name' => 'FONDO LATINOAMERICANO DE RESERVAS', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'GYDVCOBC', 'name' => 'GIROS Y FINANZAS C.F.C. S.A.', 'city' => 'CALI']);
     Bank::create(['country_id' => '170', 'code' => 'HCOLCOBB', 'name' => 'HOCOL S.A.', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'CBBACOBB', 'name' => 'ITAU BBA COLOMBIA SA CORPORACION FINANCEIRA', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'CHASCOBB', 'name' => 'JPMORGAN CORPORACION FINANCIERA S.A.', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'MCTBCOBB', 'name' => 'MACROFINANCIERA, S.A.', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'MUMDCOBM', 'name' => 'MUNICIPIO DE MEDELLIN', 'city' => 'MEDELLIN']);
     Bank::create(['country_id' => '170', 'code' => 'PPCOCOBB', 'name' => 'POLIPROPILENO DEL CARIBE S.A.', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'RCARCOB2PTA', 'name' => 'REFINERIA DE CARTAGENA S.A.', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'RCARCOB2', 'name' => 'REFINERIA DE CARTAGENA S.A.', 'city' => 'BOGOTA']);
     Bank::create(['country_id' => '170', 'code' => 'UNETCOBM', 'name' => 'UNE EPM TELECOMUNICACIONES S.A.', 'city' => 'MEDELLIN']);
     /* costa rica */
     Bank::create(['country_id' => '188', 'code' => 'BSNJCRSJ', 'name' => 'BANCO BAC SAN JOSE', 'city' => 'SAN JOSE']);
     Bank::create(['country_id' => '188', 'code' => 'CCIOCRSJBBI', 'name' => 'BANCO BCT S.A.', 'city' => 'SAN JOSE']);
     Bank::create(['country_id' => '188', 'code' => 'CCIOCRSJ', 'name' => 'BANCO BCT S.A.', 'city' => 'SAN JOSE']);
     Bank::create(['country_id' => '188', 'code' => 'KTAYCRSJ', 'name' => 'BANCO CATHAY DE COSTA RICA, S.A.', 'city' => 'SAN JOSE']);
     Bank::create(['country_id' => '188', 'code' => 'BCCRCRSJ', 'name' => 'BANCO CENTRAL DE COSTA RICA', 'city' => 'SAN JOSE']);
     Bank::create(['country_id' => '188', 'code' => 'BACUCRSJ', 'name' => 'BANCO CITIBANK DE COSTA RICA S.A.', 'city' => 'SAN JOSE']);
     Bank::create(['country_id' => '188', 'code' => 'BCACCRSJ', 'name' => 'BANCO CREDITO AGRICOLA DE CARTAGO', 'city' => 'SAN JOSE']);
     Bank::create(['country_id' => '188', 'code' => 'BXBACRSJ', 'name' => 'BANCO DAVIVIENDA (COSTA RICA), S.A.', 'city' => 'SAN JOSE']);
     Bank::create(['country_id' => '188', 'code' => 'BCRICRSJ', 'name' => 'BANCO DE COSTA RICA', 'city' => 'SAN JOSE']);
     Bank::create(['country_id' => '188', 'code' => 'BDSOCRSJ', 'name' => 'BANCO DE SOLUCIONES BANSOL DE COSTA RICA S.A. (FORMERLY FINANCIERA ACOBO S.A.)', 'city' => 'SAN PEDRO']);
     Bank::create(['country_id' => '188', 'code' => 'BAGECRSJ', 'name' => 'BANCO GENERAL (COSTA RICA), S.A.', 'city' => 'SAN JOSE']);
     Bank::create(['country_id' => '188', 'code' => 'BIMPCRSJ', 'name' => 'BANCO IMPROSA, S.A.', 'city' => 'SAN JOSE']);
     Bank::create(['country_id' => '188', 'code' => 'BCCECRSJ', 'name' => 'BANCO LAFISE S.A.', 'city' => 'SAN JOSE']);
     Bank::create(['country_id' => '188', 'code' => 'BNCRCRSJ', 'name' => 'BANCO NACIONAL DE COSTA RICA', 'city' => 'SAN JOSE']);
     Bank::create(['country_id' => '188', 'code' => 'BNCRCRSJGCI', 'name' => 'BANCO NACIONAL DE COSTA RICA', 'city' => 'SAN JOSE']);
     Bank::create(['country_id' => '188', 'code' => 'BPDCCRSJ', 'name' => 'BANCO POPULAR Y DE DESARROLLO COMUNAL', 'city' => 'SAN JOSE']);
     Bank::create(['country_id' => '188', 'code' => 'PRMKCRSJ', 'name' => 'BANCO PROMERICA', 'city' => 'SAN JOSE']);
     Bank::create(['country_id' => '188', 'code' => 'NOSCCRSJ', 'name' => 'SCOTIABANK DE COSTA RICA', 'city' => 'SAN JOSE']);
     /* cuba */
     Bank::create(['country_id' => '192', 'code' => 'BCCUCUHH', 'name' => 'BANCO CENTRAL DE CUBA', 'city' => 'LA HABANA']);
     Bank::create(['country_id' => '192', 'code' => 'BCCUCUHHSLB', 'name' => 'BANCO CENTRAL DE CUBA', 'city' => 'LA HABANA']);
     Bank::create(['country_id' => '192', 'code' => 'BCCUCUHHSUC', 'name' => 'BANCO CENTRAL DE CUBA', 'city' => 'LA HABANA']);
     Bank::create(['country_id' => '192', 'code' => 'BDCRCUHH', 'name' => 'BANCO DE CREDITO Y COMERCIO', 'city' => 'LA HABANA']);
     Bank::create(['country_id' => '192', 'code' => 'BICUCUHH', 'name' => 'BANCO DE INVERSIONES S.A.', 'city' => 'LA HABANA']);
     Bank::create(['country_id' => '192', 'code' => 'BECUCUHH', 'name' => 'BANCO EXTERIOR DE CUBA', 'city' => 'LA HABANA']);
     Bank::create(['country_id' => '192', 'code' => 'BFICCUHH', 'name' => 'BANCO FINANCIERO INTERNACIONAL, S.A.', 'city' => 'LA HABANA']);
     Bank::create(['country_id' => '192', 'code' => 'INDSCUHH', 'name' => 'BANCO INDUSTRIAL DE VENEZUELA- CUBA S.A.', 'city' => 'LA HABANA']);
     Bank::create(['country_id' => '192', 'code' => 'BIDCCUHH', 'name' => 'BANCO INTERNACIONAL DE COMERCIO S.A.', 'city' => 'LA HABANA']);
     Bank::create(['country_id' => '192', 'code' => 'BMNBCUHH', 'name' => 'BANCO METROPOLITANO S.A.', 'city' => 'LA HABANA']);
     Bank::create(['country_id' => '192', 'code' => 'BNACCUHH', 'name' => 'BANCO NACIONAL DE CUBA', 'city' => 'LA HABANA']);
     Bank::create(['country_id' => '192', 'code' => 'BNACCUHH011', 'name' => 'BANCO NACIONAL DE CUBA', 'city' => 'LA HABANA']);
     Bank::create(['country_id' => '192', 'code' => 'BNACCUHH613', 'name' => 'BANCO NACIONAL DE CUBA', 'city' => 'LA HABANA']);
     Bank::create(['country_id' => '192', 'code' => 'BPAHCUHH', 'name' => 'BANCO POPULAR DE AHORRO', 'city' => 'LA HABANA']);
     /* Ecuador */
     Bank::create(['country_id' => '218', 'code' => 'MUPIECEQ', 'name' => 'ASOCIACION MUTUALISTA DE AHORRO Y CREDITO PARA LA VIVIENDA PICHINCHA', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'BASAECEG', 'name' => 'BANCO AMAZONAS S.A.', 'city' => 'GUAYAQUIL']);
     Bank::create(['country_id' => '218', 'code' => 'BBOLECEG100', 'name' => 'BANCO BOLIVARIANO C.A.', 'city' => 'GUAYAQUIL']);
     Bank::create(['country_id' => '218', 'code' => 'BBOLECEG', 'name' => 'BANCO BOLIVARIANO C.A.', 'city' => 'GUAYAQUIL']);
     Bank::create(['country_id' => '218', 'code' => 'BBOLECEG500', 'name' => 'BANCO BOLIVARIANO C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'BCENECEQ120', 'name' => 'BANCO CENTRAL DEL ECUADOR', 'city' => 'GUAYAQUIL']);
     Bank::create(['country_id' => '218', 'code' => 'BCENECEQ', 'name' => 'BANCO CENTRAL DEL ECUADOR', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'BCENECEQ100', 'name' => 'BANCO CENTRAL DEL ECUADOR', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'GUAYECEG305', 'name' => 'BANCO DE GUAYAQUIL', 'city' => 'CUENCA']);
     Bank::create(['country_id' => '218', 'code' => 'GUAYECEG300', 'name' => 'BANCO DE GUAYAQUIL', 'city' => 'CUENCA']);
     Bank::create(['country_id' => '218', 'code' => 'GUAYECEG105', 'name' => 'BANCO DE GUAYAQUIL', 'city' => 'GUAYAQUIL']);
     Bank::create(['country_id' => '218', 'code' => 'GUAYECEG', 'name' => 'BANCO DE GUAYAQUIL', 'city' => 'GUAYAQUIL']);
     Bank::create(['country_id' => '218', 'code' => 'GUAYECEG100', 'name' => 'BANCO DE GUAYAQUIL', 'city' => 'GUAYAQUIL']);
     Bank::create(['country_id' => '218', 'code' => 'GUAYECEG505', 'name' => 'BANCO DE GUAYAQUIL', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'GUAYECEG500', 'name' => 'BANCO DE GUAYAQUIL', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'MMJAECEQ', 'name' => 'BANCO DE LA PRODUCCION S.A PRODUBAN(FORMELY BANCO PROMERICA S.A.)', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PRODECEQ100', 'name' => 'BANCO DE LA PRODUCCION S.A. PRODUBANCO', 'city' => 'GUAYAQUIL']);
     Bank::create(['country_id' => '218', 'code' => 'PRODECEQ', 'name' => 'BANCO DE LA PRODUCCION S.A. PRODUBANCO', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'LOJBECEL', 'name' => 'BANCO DE LOJA', 'city' => 'LOJA']);
     Bank::create(['country_id' => '218', 'code' => 'BMACECEG', 'name' => 'BANCO DE MACHALA, C.A.', 'city' => 'GUAYAQUIL']);
     Bank::create(['country_id' => '218', 'code' => 'BMACECEG0EG', 'name' => 'BANCO DE MACHALA, C.A.', 'city' => 'GUAYAQUIL']);
     Bank::create(['country_id' => '218', 'code' => 'BMACECEG0E4', 'name' => 'BANCO DE MACHALA, C.A.', 'city' => 'NARANJAL']);
     Bank::create(['country_id' => '218', 'code' => 'BMACECEG0E5', 'name' => 'BANCO DE MACHALA, C.A.', 'city' => 'PASAJE']);
     Bank::create(['country_id' => '218', 'code' => 'BMACECEG0E3', 'name' => 'BANCO DE MACHALA, C.A.', 'city' => 'PINAS']);
     Bank::create(['country_id' => '218', 'code' => 'BMACECEG0E8', 'name' => 'BANCO DE MACHALA, C.A.', 'city' => 'QUEVEDO']);
     Bank::create(['country_id' => '218', 'code' => 'BMACECEG0E7', 'name' => 'BANCO DE MACHALA, C.A.', 'city' => 'SANTA ROSA']);
     Bank::create(['country_id' => '218', 'code' => 'BMACECEG0E6', 'name' => 'BANCO DE MACHALA, C.A.', 'city' => 'ZARUMA']);
     Bank::create(['country_id' => '218', 'code' => 'AUSTECEQ305', 'name' => 'BANCO DEL AUSTRO S.A.', 'city' => 'CUENCA']);
     Bank::create(['country_id' => '218', 'code' => 'AUSTECEQ310', 'name' => 'BANCO DEL AUSTRO S.A.', 'city' => 'CUENCA']);
     Bank::create(['country_id' => '218', 'code' => 'AUSTECEQ315', 'name' => 'BANCO DEL AUSTRO S.A.', 'city' => 'CUENCA']);
     Bank::create(['country_id' => '218', 'code' => 'AUSTECEQ', 'name' => 'BANCO DEL AUSTRO S.A.', 'city' => 'CUENCA']);
     Bank::create(['country_id' => '218', 'code' => 'AUSTECEQ100', 'name' => 'BANCO DEL AUSTRO S.A.', 'city' => 'GUAYAQUIL']);
     Bank::create(['country_id' => '218', 'code' => 'AUSTECEQ500', 'name' => 'BANCO DEL AUSTRO S.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PACIECEG400', 'name' => 'BANCO DEL PACIFICO', 'city' => 'AMBATO']);
     Bank::create(['country_id' => '218', 'code' => 'PACIECEG300', 'name' => 'BANCO DEL PACIFICO', 'city' => 'CUENCA']);
     Bank::create(['country_id' => '218', 'code' => 'PACIECEG', 'name' => 'BANCO DEL PACIFICO', 'city' => 'GUAYAQUIL']);
     Bank::create(['country_id' => '218', 'code' => 'PACIECEG100', 'name' => 'BANCO DEL PACIFICO', 'city' => 'GUAYAQUIL']);
     Bank::create(['country_id' => '218', 'code' => 'PACIECEGIBA', 'name' => 'BANCO DEL PACIFICO', 'city' => 'IBARRA']);
     Bank::create(['country_id' => '218', 'code' => 'PACIECEG110', 'name' => 'BANCO DEL PACIFICO', 'city' => 'LA LIBERTAD']);
     Bank::create(['country_id' => '218', 'code' => 'PACIECEG200', 'name' => 'BANCO DEL PACIFICO', 'city' => 'MACHALA']);
     Bank::create(['country_id' => '218', 'code' => 'PACIECEG600', 'name' => 'BANCO DEL PACIFICO', 'city' => 'MANTA']);
     Bank::create(['country_id' => '218', 'code' => 'PACIECEG640', 'name' => 'BANCO DEL PACIFICO', 'city' => 'PORTOVIEJO']);
     Bank::create(['country_id' => '218', 'code' => 'PACIECEG500', 'name' => 'BANCO DEL PACIFICO', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PACIECEG350', 'name' => 'BANCO DEL PACIFICO', 'city' => 'RIOBAMBA']);
     Bank::create(['country_id' => '218', 'code' => 'PACIECEG871', 'name' => 'BANCO DEL PACIFICO', 'city' => 'SANTA CRUZ']);
     Bank::create(['country_id' => '218', 'code' => 'PACIECEG510', 'name' => 'BANCO DEL PACIFICO', 'city' => 'SANTO DOMINGO']);
     Bank::create(['country_id' => '218', 'code' => 'BGRMECEQ100', 'name' => 'BANCO GENERAL RUMINAHUI S.A.', 'city' => 'GUAYAQUIL']);
     Bank::create(['country_id' => '218', 'code' => 'BGRMECEQ200', 'name' => 'BANCO GENERAL RUMINAHUI S.A.', 'city' => 'MACHALA']);
     Bank::create(['country_id' => '218', 'code' => 'BGRMECEQ505', 'name' => 'BANCO GENERAL RUMINAHUI S.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'BGRMECEQ', 'name' => 'BANCO GENERAL RUMINAHUI S.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'BINTECEQ100', 'name' => 'BANCO INTERNACIONAL S.A.', 'city' => 'GUAYAQUIL']);
     Bank::create(['country_id' => '218', 'code' => 'BINTECEQ', 'name' => 'BANCO INTERNACIONAL S.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'BNFEECEQ', 'name' => 'BANCO NACIONAL DE FOMENTO', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ400', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'AMBATO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ450', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'AZOGUES']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ304', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'CUENCA']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ306', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'CUENCA']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ307', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'CUENCA']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ302', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'CUENCA']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ305', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'CUENCA']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ300', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'CUENCA']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ700', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'ESMERALDAS']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ370', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'GUARANDA']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ112', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'GUAYAQUIL']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ111', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'GUAYAQUIL']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ107', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'GUAYAQUIL']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ110', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'GUAYAQUIL']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ108', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'GUAYAQUIL']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ106', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'GUAYAQUIL']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ113', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'GUAYAQUIL']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ114', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'GUAYAQUIL']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ101', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'GUAYAQUIL']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ115', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'GUAYAQUIL']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ116', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'GUAYAQUIL']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ117', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'GUAYAQUIL']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ118', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'GUAYAQUIL']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ119', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'GUAYAQUIL']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ120', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'GUAYAQUIL']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ121', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'GUAYAQUIL']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ103', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'GUAYAQUIL']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ102', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'GUAYAQUIL']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ105', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'GUAYAQUIL']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ104', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'GUAYAQUIL']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ100', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'GUAYAQUIL']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ250', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'IBARRA']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ270', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'LATACUNGA']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ200', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'MACHALA']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ605', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'MANTA']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ600', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'MANTA']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ253', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'OTAVALO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ610', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'PORTOVIEJO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ804', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUEVEDO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ511', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ514', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ519', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ517', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ523', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ516', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ109', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ520', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ521', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ515', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ513', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ510', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ518', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ522', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ525', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ526', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ527', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ528', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ529', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ530', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ531', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ532', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ533', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ534', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ535', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ536', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ552', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ524', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ537', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ538', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ539', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ540', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ541', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ503', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ502', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ509', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ500', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ505', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ508', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ551', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ512', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ504', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ501', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ506', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ507', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ350', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'RIOBAMBA']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ550', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'SANTO DOMINGO']);
     Bank::create(['country_id' => '218', 'code' => 'PICHECEQ900', 'name' => 'BANCO PICHINCHA C.A.', 'city' => 'TULCAN']);
     Bank::create(['country_id' => '218', 'code' => 'PRCBECEQ', 'name' => 'BANCO PROCREDIT S.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'BSGEECEQ', 'name' => 'BANCO SOLIDARIO S.A.', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'CODSECEQ001', 'name' => 'COOPERATIVA DE AHORRO Y CREDITO DESARROLLO DE LOS PUEBLOS CODESARROLLO', 'city' => 'MARCABELI']);
     Bank::create(['country_id' => '218', 'code' => 'CODSECEQ', 'name' => 'COOPERATIVA DE AHORRO Y CREDITO DESARROLLO DE LOS PUEBLOS CODESARROLLO', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'CJEPECEQ', 'name' => 'COOPERATIVA DE AHORRO Y CREDITO JUVENTUD ECUATORIANA PROGRESISTA LTDA.', 'city' => 'CUENCA']);
     Bank::create(['country_id' => '218', 'code' => 'CFNAECEQ', 'name' => 'CORPORACION FINANCIERA NACIONAL', 'city' => 'QUITO']);
     Bank::create(['country_id' => '218', 'code' => 'FIREECEG', 'name' => 'FINANCIERA DE LA REPULICA S. A. FIR', 'city' => 'GUAYAQUIL']);
     /* El Salvador */
     Bank::create(['country_id' => '222', 'code' => 'BACUSVSS', 'name' => 'BANCO CITIBANK DE EL SALVADOR S.A.', 'city' => 'SAN SALVADOR']);
     Bank::create(['country_id' => '222', 'code' => 'BACUSVSSNOS', 'name' => 'BANCO CITIBANK DE EL SALVADOR S.A.', 'city' => 'SAN SALVADOR']);
     Bank::create(['country_id' => '222', 'code' => 'BAMCSVSS', 'name' => 'BANCO DE AMERICA CENTRAL, S.A.', 'city' => 'SAN SALVADOR']);
     Bank::create(['country_id' => '222', 'code' => 'BHSASVSS', 'name' => 'BANCO HIPOTECARIO DE EL SALVADOR S.A.', 'city' => 'SAN SALVADOR']);
     Bank::create(['country_id' => '222', 'code' => 'BPRASVSS', 'name' => 'BANCO PROMERICA, S.A.', 'city' => 'ANTIGUO CUSCATLAN']);
     Bank::create(['country_id' => '222', 'code' => 'BSALSVSS', 'name' => 'BANCO DAVIVIENDA SALVADORENO SA', 'city' => 'SAN SALVADOR']);
     Bank::create(['country_id' => '222', 'code' => 'CAGRSVSS', 'name' => 'BANCO AGRICOLA, S.A.', 'city' => 'SAN SALVADOR']);
     Bank::create(['country_id' => '222', 'code' => 'CENRSVSS', 'name' => 'BANCO CENTRAL DE RESERVA DE EL SALVADOR', 'city' => 'SAN SALVADOR']);
     Bank::create(['country_id' => '222', 'code' => 'CENRSVSSGTE', 'name' => 'BANCO CENTRAL DE RESERVA DE EL SALVADOR', 'city' => 'SAN SALVADOR']);
     Bank::create(['country_id' => '222', 'code' => 'GTCSSVSS', 'name' => 'BANCO G AND T CONTINENTAL EL SALVADOR', 'city' => 'SAN SALVADOR']);
     Bank::create(['country_id' => '222', 'code' => 'INDLSVSS', 'name' => 'BANCO INDUSTRIAL EL SALVADOR, S.A.', 'city' => 'SAN SALVADOR']);
     Bank::create(['country_id' => '222', 'code' => 'PRCBSVSS', 'name' => 'BANCO PROCREDIT, S.A.', 'city' => 'SAN SALVADOR']);
     Bank::create(['country_id' => '222', 'code' => 'BCSASVSS', 'name' => 'SCOTIABANK EL SALVADOR, S.A.', 'city' => 'SAN SALVADOR']);
     /* Guayana Francesa */
     Bank::create(['country_id' => '254', 'code' => 'BNPAGFGX', 'name' => 'BANQUE NATIONALE DE PARIS GUYANE', 'city' => 'CAYENNE']);
     /* Granada */
     Bank::create(['country_id' => '308', 'code' => 'NOSCGDGD', 'name' => 'BANK OF NOVA SCOTIA,THE', 'city' => 'ST. GEORGE\'S']);
     Bank::create(['country_id' => '308', 'code' => 'FCIBGDGD', 'name' => 'FIRSTCARIBBEAN INTERNATIONAL BANK', 'city' => 'ST. GEORGE\'S']);
     Bank::create(['country_id' => '308', 'code' => 'GVGDGDGD', 'name' => 'GOVERNMENT OF GRENADA', 'city' => 'ST. GEORGE\'S']);
     Bank::create(['country_id' => '308', 'code' => 'GROAGDGD', 'name' => 'GRENADA CO-OPERATIVE BANK LIMITED', 'city' => 'ST. GEORGE\'S']);
     Bank::create(['country_id' => '308', 'code' => 'RBTTGDGD', 'name' => 'RBTT BANK GRENADA LIMITED', 'city' => 'ST. GEORGE\'S']);
     Bank::create(['country_id' => '308', 'code' => 'NCBGGDGD', 'name' => 'REPUBLIC BANK GRENADA LIMITED', 'city' => 'ST. GEORGE\'S']);
     /* Guatemala */
     Bank::create(['country_id' => '320', 'code' => 'AGROGTGC', 'name' => 'BANCO AGROMERCANTIL DE GUATEMALA, S.A.', 'city' => 'GUATEMALA']);
     Bank::create(['country_id' => '320', 'code' => 'AMCNGTGT', 'name' => 'BANCO AMERICA CENTRAL SOCIEDAD ANONIMA', 'city' => 'GUATEMALA']);
     Bank::create(['country_id' => '320', 'code' => 'AZTKGTGC', 'name' => 'BANCO AZTECA DE GUATEMALA', 'city' => 'GUATEMALA']);
     Bank::create(['country_id' => '320', 'code' => 'CITBGTGC', 'name' => 'BANCO CITIBANK DE GUATEMALA, S.A.', 'city' => 'GUATEMALA']);
     Bank::create(['country_id' => '320', 'code' => 'BDCTGTGT', 'name' => 'BANCO DE CREDITO, S.A.', 'city' => 'GUATEMALA']);
     Bank::create(['country_id' => '320', 'code' => 'BAGUGTGB', 'name' => 'BANCO DE GUATEMALA', 'city' => 'GUATEMALA']);
     Bank::create(['country_id' => '320', 'code' => 'BAGUGTGC', 'name' => 'BANCO DE GUATEMALA', 'city' => 'GUATEMALA']);
     Bank::create(['country_id' => '320', 'code' => 'TRAJGTGC', 'name' => 'BANCO DE LOS TRABAJADORES', 'city' => 'GUATEMALA']);
     Bank::create(['country_id' => '320', 'code' => 'FCOHGTGC', 'name' => 'BANCO FICOHSA GUATEMALA', 'city' => 'GUATEMALA']);
     Bank::create(['country_id' => '320', 'code' => 'GTCOGTGC', 'name' => 'BANCO G AND T CONTINENTAL, S.A.', 'city' => 'GUATEMALA']);
     Bank::create(['country_id' => '320', 'code' => 'INDLGTGC', 'name' => 'BANCO INDUSTRIAL, S.A.', 'city' => 'GUATEMALA']);
     Bank::create(['country_id' => '320', 'code' => 'BINMGTGC', 'name' => 'BANCO INMOBILIARIO, S.A.', 'city' => 'GUATEMALA']);
     Bank::create(['country_id' => '320', 'code' => 'DIBIGTGC', 'name' => 'BANCO INTERNACIONAL, S.A.', 'city' => 'GUATEMALA']);
     Bank::create(['country_id' => '320', 'code' => 'BPRCGTGC', 'name' => 'BANCO PROMERICA, S.A.', 'city' => 'GUATEMALA']);
     Bank::create(['country_id' => '320', 'code' => 'CTRCGTGC', 'name' => 'BANCO REFORMADOR, S.A.', 'city' => 'GUATEMALA']);
     Bank::create(['country_id' => '320', 'code' => 'BRRLGTGC', 'name' => 'BANRURAL S.A.', 'city' => 'GUATEMALA']);
     Bank::create(['country_id' => '320', 'code' => 'CITIGTGC', 'name' => 'CITIBANK N.A. GUATEMALA', 'city' => 'GUATEMALA']);
     Bank::create(['country_id' => '320', 'code' => 'CHNAGTGC', 'name' => 'EL CREDITO HIPOTECARIO NACIONAL DE GUATEMALA', 'city' => 'GUATEMALA']);
     Bank::create(['country_id' => '320', 'code' => 'ICGSGTGC', 'name' => 'IMAGENES COMPUTARIZADAS DE GUATEMALA, S. A.', 'city' => 'GUATEMALA']);
     Bank::create(['country_id' => '320', 'code' => 'OCICGTGC', 'name' => 'OCCIDENTE INTERNATIONAL CORPORATION', 'city' => 'GUATEMALA']);
     /* Guyana */
     Bank::create(['country_id' => '328', 'code' => 'BARBGYGE', 'name' => 'BANK OF BARODA (GUYANA) INC.', 'city' => 'GEORGETOWN']);
     Bank::create(['country_id' => '328', 'code' => 'GUBAGYGG', 'name' => 'BANK OF GUYANA', 'city' => 'GEORGETOWN']);
     Bank::create(['country_id' => '328', 'code' => 'NOSCGYGE', 'name' => 'BANK OF NOVA SCOTIA,THE', 'city' => 'GEORGETOWN']);
     Bank::create(['country_id' => '328', 'code' => 'CBGIGYGG', 'name' => 'CITIZENS BANK GUYANA INC', 'city' => 'GEORGETOWN']);
     Bank::create(['country_id' => '328', 'code' => 'DMBKGYGT', 'name' => 'DEMERARA BANK LIMITED', 'city' => 'GEORGETOWN']);
     Bank::create(['country_id' => '328', 'code' => 'EXCAGYGT', 'name' => 'EXCEL CAPITAL INC.', 'city' => 'GEORGETOWN']);
     Bank::create(['country_id' => '328', 'code' => 'GUTIGYGE', 'name' => 'GUYANA BANK FOR TRADE AND INDUSTRY LTD.', 'city' => 'GEORGETOWN']);
     Bank::create(['country_id' => '328', 'code' => 'RBGLGYGG', 'name' => 'REPUBLIC BANK (GUYANA) LIMITED', 'city' => 'GEORGETOWN']);
     /* Haití */
     Bank::create(['country_id' => '332', 'code' => 'NOSCHTPP', 'name' => 'BANK OF NOVA SCOTIA,THE', 'city' => 'PORT AU PRINCE']);
     Bank::create(['country_id' => '332', 'code' => 'BRHAHTPP', 'name' => 'BANQUE DE LA REPUBLIQUE D\'HAITI', 'city' => 'PORT AU PRINCE']);
     Bank::create(['country_id' => '332', 'code' => 'BUHEHTPP', 'name' => 'BANQUE DE L\'UNION HAITIENNE', 'city' => 'PORT AU PRINCE']);
     Bank::create(['country_id' => '332', 'code' => 'BNCHHTPP', 'name' => 'BANQUE NATIONALE DE CREDIT (BNC)', 'city' => 'PORT AU PRINCE']);
     Bank::create(['country_id' => '332', 'code' => 'CPPLHTPP', 'name' => 'CAPITAL BANK S.A.', 'city' => 'PORT AU PRINCE']);
     Bank::create(['country_id' => '332', 'code' => 'SOGHHTPP', 'name' => 'SOCIETE GENERALE HAITIENNE DE BANQUE S.A.', 'city' => 'PORT AU PRINCE']);
     Bank::create(['country_id' => '332', 'code' => 'UBNKHTPP', 'name' => 'UNIBANK S.A.', 'city' => 'PETION-VILLE']);
     /* Honduras */
     Bank::create(['country_id' => '340', 'code' => 'ATTDHNTE', 'name' => 'BANCO ATLANTIDA', 'city' => 'TEGUCIGALPA']);
     Bank::create(['country_id' => '340', 'code' => 'AZTKHNTE', 'name' => 'BANCO AZTECA DE HONDURAS, SA', 'city' => 'TEGUCIGALPA']);
     Bank::create(['country_id' => '340', 'code' => 'BCEHHNTE', 'name' => 'BANCO CENTRAL DE HONDURAS', 'city' => 'TEGUCIGALPA']);
     Bank::create(['country_id' => '340', 'code' => 'BCEHHNTT', 'name' => 'BANCO CENTRAL DE HONDURAS BANCO CENTRAL', 'city' => 'TEGUCIGALPA']);
     Bank::create(['country_id' => '340', 'code' => 'BCIEHNTE', 'name' => 'BANCO CENTROAMERICANO DE INTEGRACION ECONOMICA', 'city' => 'TEGUCIGALPA']);
     Bank::create(['country_id' => '340', 'code' => 'CSPSHNTE0TD', 'name' => 'BANCO CONTINENTAL, S.A.', 'city' => 'DANLI']);
     Bank::create(['country_id' => '340', 'code' => 'CSPSHNTE0TC', 'name' => 'BANCO CONTINENTAL, S.A.', 'city' => 'LA CEIBA']);
     Bank::create(['country_id' => '340', 'code' => 'CSPSHNTE', 'name' => 'BANCO CONTINENTAL, S.A.', 'city' => 'SAN PEDRO SULA']);
     Bank::create(['country_id' => '340', 'code' => 'CSPSHNTE0TE', 'name' => 'BANCO CONTINENTAL, S.A.', 'city' => 'TEGUCIGALPA']);
     Bank::create(['country_id' => '340', 'code' => 'BACUHNTE', 'name' => 'BANCO CUSCATLAN DE HONDURAS', 'city' => 'TEGUCIGALPA']);
     Bank::create(['country_id' => '340', 'code' => 'BGAHHNTE', 'name' => 'BANCO DAVIVIENDA HONDURAS, S.A.', 'city' => 'TEGUCIGALPA']);
     Bank::create(['country_id' => '340', 'code' => 'BMILHNTE', 'name' => 'BANCO DE AMERICA CENTRAL HONDURAS, S.A.(BAC BAMER)', 'city' => 'TEGUCIGALPA']);
     Bank::create(['country_id' => '340', 'code' => 'HONAHNT2', 'name' => 'BANCO DE HONDURAS, S.A.', 'city' => 'TEGUCIGALPA']);
     Bank::create(['country_id' => '340', 'code' => 'BOCCHNTESPS', 'name' => 'BANCO DE OCCIDENTE S.A.', 'city' => 'SAN PEDRO SULA']);
     Bank::create(['country_id' => '340', 'code' => 'BOCCHNTESRC', 'name' => 'BANCO DE OCCIDENTE S.A.', 'city' => 'SANTA ROSA DE COPAN']);
     Bank::create(['country_id' => '340', 'code' => 'BOCCHNTE', 'name' => 'BANCO DE OCCIDENTE S.A.', 'city' => 'SANTA ROSA DE COPAN']);
     Bank::create(['country_id' => '340', 'code' => 'BOCCHNTETGU', 'name' => 'BANCO DE OCCIDENTE S.A.', 'city' => 'TEGUCIGALPA']);
     Bank::create(['country_id' => '340', 'code' => 'PISAHNTE', 'name' => 'BANCO DEL PAIS,S.A.', 'city' => 'SAN PEDRO SULA']);
     Bank::create(['country_id' => '340', 'code' => 'CABFHNTE', 'name' => 'BANCO FINANCIERA CENTROAMERICANA S.A. FICENSA', 'city' => 'TEGUCIGALPA']);
     Bank::create(['country_id' => '340', 'code' => 'FCOHHNTE', 'name' => 'BANCO FINANCIERA COMERCIAL HONDURENA S.A. (BANCO FICOHSA)', 'city' => 'TEGUCIGALPA']);
     Bank::create(['country_id' => '340', 'code' => 'BHCAHNTH', 'name' => 'BANCO HONDURENO DEL CAFE', 'city' => 'TEGUCIGALPA']);
     Bank::create(['country_id' => '340', 'code' => 'BCCEHNTE', 'name' => 'BANCO LAFISE,S.A.', 'city' => 'TEGUCIGALPA']);
     Bank::create(['country_id' => '340', 'code' => 'PRCBHNTE', 'name' => 'BANCO PROCREDIT HONDURAS S.A.', 'city' => 'TEGUCIGALPA']);
     Bank::create(['country_id' => '340', 'code' => 'BPRHHNTE', 'name' => 'BANCO PROMERICA, S.A.', 'city' => 'TEGUCIGALPA']);
     /* Jamaica */
     Bank::create(['country_id' => '388', 'code' => 'BAJAJMKN', 'name' => 'BANK OF JAMAICA', 'city' => 'KINGSTON']);
     Bank::create(['country_id' => '388', 'code' => 'NOSCJMKN', 'name' => 'BANK OF NOVA SCOTIA JAMAICA LTD., THE', 'city' => 'KINGSTON']);
     Bank::create(['country_id' => '388', 'code' => 'FILBJMKN', 'name' => 'FIRST GLOBAL BANK LIMITED', 'city' => 'KINGSTON']);
     Bank::create(['country_id' => '388', 'code' => 'FCIBJMKN', 'name' => 'FIRSTCARIBBEAN INTERNATIONAL BANK (JAMAICA) LIMITED', 'city' => 'KINGSTON']);
     Bank::create(['country_id' => '388', 'code' => 'JNBSJMKN', 'name' => 'JAMAICA NATIONAL BUILDING SOCIETY', 'city' => 'KINGSTON']);
     Bank::create(['country_id' => '388', 'code' => 'JNCBJMKX', 'name' => 'NATIONAL COMMERCIAL BANK JAMAICA LIMITED', 'city' => 'KINGSTON']);
     Bank::create(['country_id' => '388', 'code' => 'NAEBJMKI', 'name' => 'NATIONAL EXPORT-IMPORT BANK OF JAMAICA LIMITED', 'city' => 'KINGSTON']);
     Bank::create(['country_id' => '388', 'code' => 'SAJAJMKN', 'name' => 'SAGICOR BANK JAMAICA LIMITED', 'city' => 'KINGSTON']);
     Bank::create(['country_id' => '388', 'code' => 'SCNJJMKN', 'name' => 'SCOTIA INVESTMENTS JAMAICA LTD', 'city' => 'KINGSTON']);
     /* México */
     Bank::create(['country_id' => '484', 'code' => 'ACVLMXMM', 'name' => 'ACCIONES Y VALORES DE MEXICO, S.A. DE C.V. CASA DE BOLSA', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'AFIRMXMT', 'name' => 'BANCA AFIRME S.A.', 'city' => 'MONTERREY']);
     Bank::create(['country_id' => '484', 'code' => 'MIFEMXMM', 'name' => 'BANCA MIFEL SA INSTITUCION DE BANCA MULTIPLE GRUPO FINANCIERO MIFEL', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'ACIOMXMMACB', 'name' => 'BANCO ACTINVER SA INSTITUCION DE BANCA MULTIPLE GRUPO FINANCIERO ACTINVER', 'city' => 'CENTRO DE CIUDAD SANTA FE']);
     Bank::create(['country_id' => '484', 'code' => 'ACIOMXMMMMD', 'name' => 'BANCO ACTINVER SA INSTITUCION DE BANCA MULTIPLE GRUPO FINANCIERO ACTINVER', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'ACIOMXMMBRA', 'name' => 'BANCO ACTINVER SA INSTITUCION DE BANCA MULTIPLE GRUPO FINANCIERO ACTINVER', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'ACIOMXMMPAY', 'name' => 'BANCO ACTINVER SA INSTITUCION DE BANCA MULTIPLE GRUPO FINANCIERO ACTINVER', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'ACIOMXMM', 'name' => 'BANCO ACTINVER SA INSTITUCION DE BANCA MULTIPLE GRUPO FINANCIERO ACTINVER', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'ACIOMXMMFND', 'name' => 'BANCO ACTINVER SA INSTITUCION DE BANCA MULTIPLE GRUPO FINANCIERO ACTINVER', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'AZTKMXMM', 'name' => 'BANCO AZTECA, S.A. INSTITUCION DE BANCA MULTIPLE', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'AZTKMXMMEKT', 'name' => 'BANCO AZTECA, S.A. INSTITUCION DE BANCA MULTIPLE', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'AZTKMXMMTVA', 'name' => 'BANCO AZTECA, S.A. INSTITUCION DE BANCA MULTIPLE', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'BBSEMXMX', 'name' => 'BANCO BASE SA INSTITUCION DE BANCA MULTIPLE', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'CSFBMXMM', 'name' => 'BANCO CREDIT SUISSE (MEXICO) S.A.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'BDEMMXMM', 'name' => 'BANCO DE MEXICO', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'SEFIMXMM', 'name' => 'BANCO DEL AHORRO NACIONAL Y SERVICIOS FINANCIEROS S.N.C INSTITUCION DE BANCA DE DESARROLLO', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'BJIOMXML', 'name' => 'BANCO DEL BAJIO, S.A.', 'city' => 'LEON']);
     Bank::create(['country_id' => '484', 'code' => 'INBUMXMM', 'name' => 'BANCO INBURSA S.A.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'BITEMXMM', 'name' => 'BANCO INTERACCIONES', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'CHASMXMXGTS', 'name' => 'BANCO JP MORGAN S.A.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'CHASMXMX', 'name' => 'BANCO JP MORGAN S.A.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'MENOMXMTCCM', 'name' => 'BANCO MERCANTIL DEL NORTE, S.A.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'MENOMXMT', 'name' => 'BANCO MERCANTIL DEL NORTE, S.A.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'MENOMXMTMEX', 'name' => 'BANCO MERCANTIL DEL NORTE, S.A.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'MENOMXMTDER', 'name' => 'BANCO MERCANTIL DEL NORTE, S.A.', 'city' => 'MONTERREY,N.L.']);
     Bank::create(['country_id' => '484', 'code' => 'MENOMXMTFEX', 'name' => 'BANCO MERCANTIL DEL NORTE, S.A.', 'city' => 'MONTERREY,N.L.']);
     Bank::create(['country_id' => '484', 'code' => 'MENOMXMTWLS', 'name' => 'BANCO MERCANTIL DEL NORTE, S.A.', 'city' => 'MONTERREY,N.L.']);
     Bank::create(['country_id' => '484', 'code' => 'MENOMXMTPYM', 'name' => 'BANCO MERCANTIL DEL NORTE, S.A.', 'city' => 'MONTERREY,N.L.']);
     Bank::create(['country_id' => '484', 'code' => 'MONXMXMM', 'name' => 'BANCO MONEX, S.A.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'MIMMMXMX', 'name' => 'BANCO MULTIVA S.A. INSTITUCION DE BANCA MULTIPLE, GRUPO FINANCIERO MULTIVA', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'BNCEMXMM', 'name' => 'BANCO NACIONAL DE COMERCIO EXTERIOR, S.N.C.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'BNMXMXMMGUA', 'name' => 'BANCO NACIONAL DE MEXICO S.A.', 'city' => 'GUADALAJARA']);
     Bank::create(['country_id' => '484', 'code' => 'BNMXMXMMLEO', 'name' => 'BANCO NACIONAL DE MEXICO S.A.', 'city' => 'LEON']);
     Bank::create(['country_id' => '484', 'code' => 'BNMXMXMM', 'name' => 'BANCO NACIONAL DE MEXICO S.A.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'BNMXMXMMINV', 'name' => 'BANCO NACIONAL DE MEXICO S.A.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'BNMXMXMMMTI', 'name' => 'BANCO NACIONAL DE MEXICO S.A.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'BNMXMXMMPYM', 'name' => 'BANCO NACIONAL DE MEXICO S.A.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'BNMXMXMMCVT', 'name' => 'BANCO NACIONAL DE MEXICO S.A.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'BNMXMXMMMTY', 'name' => 'BANCO NACIONAL DE MEXICO S.A.', 'city' => 'MONTERREY']);
     Bank::create(['country_id' => '484', 'code' => 'BNMXMXMMPUE', 'name' => 'BANCO NACIONAL DE MEXICO S.A.', 'city' => 'PUEBLA']);
     Bank::create(['country_id' => '484', 'code' => 'EJERMXMM', 'name' => 'BANCO NACIONAL DEL EJERCITO, FUERZA AEREA Y ARMADA, S.N.C.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'RGIOMXMT', 'name' => 'BANCO REGIONAL DE MONTERREY, S.A.', 'city' => 'MONTERREY']);
     Bank::create(['country_id' => '484', 'code' => 'BMSXMXMMACA', 'name' => 'BANCO SANTANDER (MEXICO), S.A., INSTITUCION DE BANCA MULTIPLE, GRUPO FINANCIERO SANTANDER', 'city' => 'ACAPULCO']);
     Bank::create(['country_id' => '484', 'code' => 'BMSXMXMMCHI', 'name' => 'BANCO SANTANDER (MEXICO), S.A., INSTITUCION DE BANCA MULTIPLE, GRUPO FINANCIERO SANTANDER', 'city' => 'CHIHUAHUA']);
     Bank::create(['country_id' => '484', 'code' => 'BMSXMXMMGUA', 'name' => 'BANCO SANTANDER (MEXICO), S.A., INSTITUCION DE BANCA MULTIPLE, GRUPO FINANCIERO SANTANDER', 'city' => 'GUADALAJARA']);
     Bank::create(['country_id' => '484', 'code' => 'BMSXMXMMHMO', 'name' => 'BANCO SANTANDER (MEXICO), S.A., INSTITUCION DE BANCA MULTIPLE, GRUPO FINANCIERO SANTANDER', 'city' => 'HERMOSILLO']);
     Bank::create(['country_id' => '484', 'code' => 'BMSXMXMMLEO', 'name' => 'BANCO SANTANDER (MEXICO), S.A., INSTITUCION DE BANCA MULTIPLE, GRUPO FINANCIERO SANTANDER', 'city' => 'LEON']);
     Bank::create(['country_id' => '484', 'code' => 'BMSXMXMMMAZ', 'name' => 'BANCO SANTANDER (MEXICO), S.A., INSTITUCION DE BANCA MULTIPLE, GRUPO FINANCIERO SANTANDER', 'city' => 'MAZATLAN']);
     Bank::create(['country_id' => '484', 'code' => 'BMSXMXMMMER', 'name' => 'BANCO SANTANDER (MEXICO), S.A., INSTITUCION DE BANCA MULTIPLE, GRUPO FINANCIERO SANTANDER', 'city' => 'MERIDA']);
     Bank::create(['country_id' => '484', 'code' => 'BMSXMXMMSSS', 'name' => 'BANCO SANTANDER (MEXICO), S.A., INSTITUCION DE BANCA MULTIPLE, GRUPO FINANCIERO SANTANDER', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'BMSXMXMM', 'name' => 'BANCO SANTANDER (MEXICO), S.A., INSTITUCION DE BANCA MULTIPLE, GRUPO FINANCIERO SANTANDER', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'BMSXMXMMMEX', 'name' => 'BANCO SANTANDER (MEXICO), S.A., INSTITUCION DE BANCA MULTIPLE, GRUPO FINANCIERO SANTANDER', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'BMSXMXMMMTY', 'name' => 'BANCO SANTANDER (MEXICO), S.A., INSTITUCION DE BANCA MULTIPLE, GRUPO FINANCIERO SANTANDER', 'city' => 'MONTERREY']);
     Bank::create(['country_id' => '484', 'code' => 'BMSXMXMMPUE', 'name' => 'BANCO SANTANDER (MEXICO), S.A., INSTITUCION DE BANCA MULTIPLE, GRUPO FINANCIERO SANTANDER', 'city' => 'PUEBLA']);
     Bank::create(['country_id' => '484', 'code' => 'BMSXMXMMTIJ', 'name' => 'BANCO SANTANDER (MEXICO), S.A., INSTITUCION DE BANCA MULTIPLE, GRUPO FINANCIERO SANTANDER', 'city' => 'TIJUANA']);
     Bank::create(['country_id' => '484', 'code' => 'BMSXMXMMTOL', 'name' => 'BANCO SANTANDER (MEXICO), S.A., INSTITUCION DE BANCA MULTIPLE, GRUPO FINANCIERO SANTANDER', 'city' => 'TOLUCA']);
     Bank::create(['country_id' => '484', 'code' => 'BMSXMXMMVER', 'name' => 'BANCO SANTANDER (MEXICO), S.A., INSTITUCION DE BANCA MULTIPLE, GRUPO FINANCIERO SANTANDER', 'city' => 'VERACRUZ']);
     Bank::create(['country_id' => '484', 'code' => 'BCMRMXMMRFI', 'name' => 'BANCOMER RENTA FIJA INTERNACIONAL', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'BOFAMXMX', 'name' => 'BANK OF AMERICA, MEXICO S.A.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'BOFAMXMXMEX', 'name' => 'BANK OF AMERICA, MEXICO S.A.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'BOTKMXMX', 'name' => 'BANK OF TOKYO-MITSUBISHI UFJ (MEXICO) S.A.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'BARCMXMM', 'name' => 'BARCLAYS BANK MEXICO S.A.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'BCMRMXMMGUA', 'name' => 'BBVA BANCOMER, S.A.', 'city' => 'GUADALAJARA']);
     Bank::create(['country_id' => '484', 'code' => 'BCMRMXMMHIP', 'name' => 'BBVA BANCOMER, S.A.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'BCMRMXMMCOL', 'name' => 'BBVA BANCOMER, S.A.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'BCMRMXMMCOR', 'name' => 'BBVA BANCOMER, S.A.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'BCMRMXMMFID', 'name' => 'BBVA BANCOMER, S.A.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'BCMRMXMMEXT', 'name' => 'BBVA BANCOMER, S.A.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'BCMRMXMMFGN', 'name' => 'BBVA BANCOMER, S.A.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'BCMRMXMMOPC', 'name' => 'BBVA BANCOMER, S.A.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'BCMRMXMMDIV', 'name' => 'BBVA BANCOMER, S.A.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'BCMRMXMMDOC', 'name' => 'BBVA BANCOMER, S.A.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'BCMRMXMMOPE', 'name' => 'BBVA BANCOMER, S.A.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'BCMRMXMMPYM', 'name' => 'BBVA BANCOMER, S.A.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'BCMRMXMMREC', 'name' => 'BBVA BANCOMER, S.A.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'BCMRMXMMSEC', 'name' => 'BBVA BANCOMER, S.A.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'BCMRMXMMTIN', 'name' => 'BBVA BANCOMER, S.A.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'BCMRMXMM', 'name' => 'BBVA BANCOMER, S.A.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'BCMRMXMMMTY', 'name' => 'BBVA BANCOMER, S.A.', 'city' => 'MONTERREY']);
     Bank::create(['country_id' => '484', 'code' => 'CSFBMXMX', 'name' => 'CASA DE BOLSA CREDIT SUISSE (MEXICO), S.A. DE C.V.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'CXCXMXMT', 'name' => 'CEMEX S.A.B. DE C.V.', 'city' => 'SAN PEDRO GARZA GARCIA']);
     Bank::create(['country_id' => '484', 'code' => 'CIMXMXMMFID', 'name' => 'CIBANCO SA', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'CIMXMXMM', 'name' => 'CIBANCO SA', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'DCAGMXMM', 'name' => 'DAIMLER MEXICO, SA DE CV', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'DEUTMXMM', 'name' => 'DEUTSCHE BANK MEXICO, SA', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'GBMSMXMX', 'name' => 'GBM GRUPO BURSATIL MEXICANO, SA DE CV', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'TVSAMXMM', 'name' => 'GRUPO TELEVISA, S.A.B.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'BIMEMXMMCLS', 'name' => 'HSBC MEXICO, S.A. INSTITUCION DE BANCA MULTIPLE, GRUPO FINANCIER HSBC', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'BIMEMXMM397', 'name' => 'HSBC MEXICO, S.A. INSTITUCION DE BANCA MULTIPLE, GRUPO FINANCIER HSBC', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'BIMEMXMM', 'name' => 'HSBC MEXICO, S.A. INSTITUCION DE BANCA MULTIPLE, GRUPO FINANCIER HSBC', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'INTEMXMM', 'name' => 'INTERCAM BANCO SA INSTITUCION DE BANCA MULTIPLE INTERCAM GRUPO FINANCIERO', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'ICABMXMM', 'name' => 'INTERCAM CASA DE BOLSA S.A. DE C.V.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'GINSMXMM', 'name' => 'INVESTA BANK, S.A. INSTITUCION DE BANCA MULTIPLE', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'IXEBMXMMDER', 'name' => 'IXE BANCO S.A.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'IXEBMXMMFEX', 'name' => 'IXE BANCO S.A.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'IXEBMXMMWLS', 'name' => 'IXE BANCO S.A.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'IXEBMXMMPYM', 'name' => 'IXE BANCO S.A.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'IXEBMXMM', 'name' => 'IXE BANCO S.A.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'MSMCMXMM', 'name' => 'MORGAN STANLEY', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'NFSAMXMM', 'name' => 'NACIONAL FINANCIERA, S.N.C.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'INDEMXMM', 'name' => 'S.D. INDEVAL, S.A. DE C.V.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'MBCOMXMMGUA', 'name' => 'SCOTIABANK INVERLAT, S.A.', 'city' => 'GUADALAJARA']);
     Bank::create(['country_id' => '484', 'code' => 'MBCOMXMMINV', 'name' => 'SCOTIABANK INVERLAT, S.A.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'MBCOMXMMSEC', 'name' => 'SCOTIABANK INVERLAT, S.A.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'MBCOMXMM', 'name' => 'SCOTIABANK INVERLAT, S.A.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'MBCOMXMMFXA', 'name' => 'SCOTIABANK INVERLAT, S.A.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'MBCOMXMMMTY', 'name' => 'SCOTIABANK INVERLAT, S.A.', 'city' => 'MONTERREY']);
     Bank::create(['country_id' => '484', 'code' => 'MBCOMXMMPUE', 'name' => 'SCOTIABANK INVERLAT, S.A.', 'city' => 'PUEBLA']);
     Bank::create(['country_id' => '484', 'code' => 'TESRMXMM', 'name' => 'TESORED, S.A. DE C.V.', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'IRVTMXMX', 'name' => 'THE BANK OF NEW YORK MELLON, MEXICO CITY REPRESENTATIVE OFFICE', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'UBSWMXMM', 'name' => 'UBS BANK MEXICO, S.A. INSTITUCION DE BANCA MULTIPLE, UBS GRUPO FINANCIERO', 'city' => 'MEXICO']);
     Bank::create(['country_id' => '484', 'code' => 'VECRMXMM', 'name' => 'VECTOR CASA DE BOLSA, SA DE CV', 'city' => 'MONTERREY']);
     Bank::create(['country_id' => '484', 'code' => 'VWAGMXMM', 'name' => 'VOLKSWAGEN DE MEXICO S.A. DE C.V.', 'city' => 'MEXICO']);
     /* Nicaragua */
     Bank::create(['country_id' => '558', 'code' => 'BCNINIMA', 'name' => 'BANCO CENTRAL DE NICARAGUA', 'city' => 'MANAGUA']);
     Bank::create(['country_id' => '558', 'code' => 'BUNONIMA', 'name' => 'BANCO CITIBANK DE NICARAGUA, S.A.', 'city' => 'MANAGUA']);
     Bank::create(['country_id' => '558', 'code' => 'BAMCNIMA', 'name' => 'BANCO DE AMERICA CENTRAL', 'city' => 'MANAGUA']);
     Bank::create(['country_id' => '558', 'code' => 'BBDFNIMA', 'name' => 'BANCO DE FINANZAS, S.A.(BDF)', 'city' => 'MANAGUA']);
     Bank::create(['country_id' => '558', 'code' => 'BAPRNIMA', 'name' => 'BANCO DE LA PRODUCCION S.A.', 'city' => 'MANAGUA']);
     Bank::create(['country_id' => '558', 'code' => 'BCCENIMA', 'name' => 'BANCO LAFISE BANCENTRO, S.A.', 'city' => 'MANAGUA']);
     Bank::create(['country_id' => '558', 'code' => 'PRCBNIMA', 'name' => 'BANCO PROCREDIT NICARAGUA', 'city' => 'MANAGUA']);
     /* Paraguay */
     Bank::create(['country_id' => '600', 'code' => 'AMAMPYPA', 'name' => 'BANCO AMAMBAY S.A.', 'city' => 'ASUNCION']);
     Bank::create(['country_id' => '600', 'code' => 'BNITPYPA', 'name' => 'BANCO ATLAS S.A.', 'city' => 'ASUNCION']);
     Bank::create(['country_id' => '600', 'code' => 'BBVAPYPA', 'name' => 'BANCO BILBAO VIZCAYA ARGENTARIA PARAGUAY S.A.', 'city' => 'ASUNCION']);
     Bank::create(['country_id' => '600', 'code' => 'BCPAPYPB', 'name' => 'BANCO CENTRAL DEL PARAGUAY', 'city' => 'ASUNCION']);
     Bank::create(['country_id' => '600', 'code' => 'BCPAPYPXGON', 'name' => 'BANCO CENTRAL DEL PARAGUAY', 'city' => 'ASUNCION']);
     Bank::create(['country_id' => '600', 'code' => 'BCPAPYPD', 'name' => 'BANCO CENTRAL DEL PARAGUAY', 'city' => 'ASUNCION']);
     Bank::create(['country_id' => '600', 'code' => 'BCPAPYPR', 'name' => 'BANCO CENTRAL DEL PARAGUAY', 'city' => 'ASUNCION']);
     Bank::create(['country_id' => '600', 'code' => 'BCPAPYPX', 'name' => 'BANCO CENTRAL DEL PARAGUAY', 'city' => 'ASUNCION']);
     Bank::create(['country_id' => '600', 'code' => 'BCNAPYPA', 'name' => 'BANCO CONTINENTAL SAECA', 'city' => 'ASUNCION']);
     Bank::create(['country_id' => '600', 'code' => 'NACNPYPA', 'name' => 'BANCO DE LA NACION ARGENTINA', 'city' => 'ASUNCION']);
     Bank::create(['country_id' => '600', 'code' => 'NACNPYPA0PC', 'name' => 'BANCO DE LA NACION ARGENTINA', 'city' => 'CONCEPCION']);
     Bank::create(['country_id' => '600', 'code' => 'NACNPYPA0PE', 'name' => 'BANCO DE LA NACION ARGENTINA', 'city' => 'ENCARNACION']);
     Bank::create(['country_id' => '600', 'code' => 'NACNPYPA0P3', 'name' => 'BANCO DE LA NACION ARGENTINA', 'city' => 'VILLARRICA']);
     Bank::create(['country_id' => '600', 'code' => 'BRASPYPX', 'name' => 'BANCO DO BRASIL S.A.', 'city' => 'ASUNCION']);
     Bank::create(['country_id' => '600', 'code' => 'FAMIPYPA', 'name' => 'BANCO FAMILIAR S.A.E.C.A.', 'city' => 'ASUNCION']);
     Bank::create(['country_id' => '600', 'code' => 'BGNBPYPX', 'name' => 'BANCO GNB PARAGUAY S.A.', 'city' => 'ASUNCION']);
     Bank::create(['country_id' => '600', 'code' => 'BISAPYPE', 'name' => 'BANCO ITAPUA SAECA', 'city' => 'ENCARNACION']);
     Bank::create(['country_id' => '600', 'code' => 'UBBRPYPX', 'name' => 'BANCO ITAU PARAGUAY S.A.', 'city' => 'ASUNCION']);
     Bank::create(['country_id' => '600', 'code' => 'BNFAPYPA', 'name' => 'BANCO NACIONAL DE FOMENTO', 'city' => 'ASUNCION']);
     Bank::create(['country_id' => '600', 'code' => 'BCOPPYPA', 'name' => 'BANCO PARA LA COMERCIALIZACION Y LA PRODUCCION SOCIEDAD ANONIMA (BANCOP S.A.)', 'city' => 'ASUNCION']);
     Bank::create(['country_id' => '600', 'code' => 'RGSAPYPE', 'name' => 'BANCO REGIONAL S.A.E.C.A.', 'city' => 'ENCARNACION']);
     Bank::create(['country_id' => '600', 'code' => 'CIEFPYPE', 'name' => 'CRISOL Y ENCARNACIN FINANCIERA S.A.', 'city' => 'ENCARNACION']);
     Bank::create(['country_id' => '600', 'code' => 'FPJSPYPA', 'name' => 'FINANCIERA PARAGUAYO JAPONESA SAECA', 'city' => 'ASUNCION']);
     Bank::create(['country_id' => '600', 'code' => 'FOPLPYPA', 'name' => 'FONPLATA - FONDO FINANCIERO PARA EL DESAROLLO DE LA CUENCA DEL PLATA', 'city' => 'ASUNCION']);
     Bank::create(['country_id' => '600', 'code' => 'BSUDPYPX', 'name' => 'SUDAMERIS BANK S.A.E.C.A.', 'city' => 'ASUNCION']);
     Bank::create(['country_id' => '600', 'code' => 'VISCPYPA', 'name' => 'VISION BANCO S.A.E.C.A.', 'city' => 'ASUNCION']);
     /* Panama */
     Bank::create(['country_id' => '591', 'code' => 'ALLKPAPA', 'name' => 'ALLBANK CORP.', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'BACAPAPA', 'name' => 'ANDBANC (PANAMA), S.A.', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'AUBAPAPA', 'name' => 'AUSTROBANK (OVERSEAS) PANAMA S.A.', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'ACPMPAPA', 'name' => 'AUTORIDAD DEL CANAL DE PANAMA', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'BCINPAPA', 'name' => 'BAC INTERNATIONAL BANK, INC.', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'BTACPAPA', 'name' => 'BALBOA BANK AND TRUST CORP', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'BPANPAPA', 'name' => 'BANCA PRIVADA D\'ANDORRA (PANAMA) SA', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'BAALPAPA', 'name' => 'BANCO ALIADO, S.A.', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'AZTKPAPA', 'name' => 'BANCO AZTECA (PANAMA), S.A.', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'BACUPAPANOS', 'name' => 'BANCO CITIBANK (PANAMA), S.A.', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'BACUPAPA', 'name' => 'BANCO CITIBANK (PANAMA), S.A.', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'COLPPAPA', 'name' => 'BANCO COLPATRIA PANAMA', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'CAFEPAPAZLC', 'name' => 'BANCO DAVIVIENDA (PANAMA), S.A.', 'city' => 'COLON']);
     Bank::create(['country_id' => '591', 'code' => 'CAFEPAPA', 'name' => 'BANCO DAVIVIENDA (PANAMA), S.A.', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'BBOGPAPA', 'name' => 'BANCO DE BOGOTA (PANAMA), S.A.', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'BBOGPAPB', 'name' => 'BANCO DE BOGOTA S.A', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'NACNPAPA', 'name' => 'BANCO DE LA NACION ARGENTINA', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'OCCIPAPA', 'name' => 'BANCO DE OCCIDENTE (PANAMA), S.A.', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'PACIPAPX', 'name' => 'BANCO DEL PACIFICO (PANAMA) S.A.', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'BDSAPAPA', 'name' => 'BANCO DELTA, S.A.', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'FCOHPAPA', 'name' => 'BANCO FICOHSA (PANAMA), S.A.', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'BAGEPAPA', 'name' => 'BANCO GENERAL S A', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'COSRPAPA', 'name' => 'BANCO INTERNACIONAL DE COSTA RICA S.A.', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'BCCEPAPA', 'name' => 'BANCO LAFISE PANAMA', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'BLAEPAPA', 'name' => 'BANCO LATINOAMERICANO DE COMERCIO EXTERIOR, S.A. (BLADEX)', 'city' => 'PANAMA CITY']);
     Bank::create(['country_id' => '591', 'code' => 'NAPAPAPA', 'name' => 'BANCO NACIONAL DE PANAMA', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'BPTYPAPA', 'name' => 'BANCO PANAMA S.A.', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'BPVVPAPA', 'name' => 'BANCO PANAMENO DE LA VIVIENDA', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'PICHPAPA', 'name' => 'BANCO PICHINCHA PANAMA', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'BUNVPAPA', 'name' => 'BANCO UNIVERSAL S.A.', 'city' => 'DAVID']);
     Bank::create(['country_id' => '591', 'code' => 'COLOPAPA', 'name' => 'BANCOLOMBIA PANAMA S.A.', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'COLOPAPS', 'name' => 'BANCOLOMBIA SUCURSAL PANAMA', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'BANSPAPA', 'name' => 'BANESCO S.A.', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'GUAYPAPA', 'name' => 'BANISI, S.A.', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'MIDLPAPACLN', 'name' => 'BANISTMO S.A', 'city' => 'COLON']);
     Bank::create(['country_id' => '591', 'code' => 'MIDLPAPA', 'name' => 'BANISTMO S.A', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'MIDLPAPA001', 'name' => 'BANISTMO S.A', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'LUMIPAPA', 'name' => 'BANK LEUMI LE ISRAEL B.M.', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'BKCHPAPA', 'name' => 'BANK OF CHINA, PANAMA BRANCH', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'NOSCPAPA', 'name' => 'BANK OF NOVA SCOTIA, THE', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'BBOLPAPA', 'name' => 'BBP BANK, S.A.', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'BCTBPAPA', 'name' => 'BCT BANK INTERNATIONAL, S.A.', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'BHINPAPA', 'name' => 'BHD INTERNATIONAL BANK (PANAMA), S.A.', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'BSILPAPA', 'name' => 'BSI BANK (PANAMA)', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'CAHRPAPA', 'name' => 'CAJA DE AHORROS', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'CAPBPAPA', 'name' => 'CAPITAL BANK INC.', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'LPTYPAPA', 'name' => 'CENTRAL LATINOAMERICANA DE VALORES', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'CITIPAPASFE', 'name' => 'CITIBANK N.A. SUCURSAL PANAMA', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'CITIPAPA', 'name' => 'CITIBANK N.A. SUCURSAL PANAMA', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'CRLDPAPA', 'name' => 'CREDICORP BANK S.A', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'CRDAPAPA', 'name' => 'CREDIT ANDORRA PANAMA', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'FCINPAPA', 'name' => 'FIRST CENTRAL INTERNATIONAL BANK INC.', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'FPBIPAPA', 'name' => 'FPB BANK INC.', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'GLBLPAPA', 'name' => 'GLOBAL BANK CORPORATION', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'GNBKPAPA', 'name' => 'GNB SUDAMERIS BANK S.A.', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'BCTOPAPA', 'name' => 'HELM BANK (PANAMA) S.A.', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'IBNKPAPA', 'name' => 'INTELIGO BANK LTD', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'IUBKPAPA', 'name' => 'INTERNATIONAL UNION BANK S.A.', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'KEHPPAPA', 'name' => 'KEEN HOLDING S.A, (BANCO PRIVAL S.A.)', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'KOEXPAPA', 'name' => 'KOREA EXCHANGE BANK', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'ICBCPAPAZLC', 'name' => 'MEGA INTERNATIONAL COMMERCIAL BANK CO., LTD.', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'ICBCPAPA', 'name' => 'MEGA INTERNATIONAL COMMERCIAL BANK CO., LTD.', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'MPANPAPA', 'name' => 'MERCANTIL BANK (PANAMA) S.A.', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'METOPAPA', 'name' => 'METROBANK S.A.', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'MMGBPAPA', 'name' => 'MMG BANK CORPORATION', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'MCTBPAPA', 'name' => 'MULTIBANK INC.', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'BPDOPAPA', 'name' => 'POPULAR BANK LTD. INC.', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'PRODPAPA', 'name' => 'PRODUBANK PANAMA S.A.', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'STGBPAPA', 'name' => 'ST. GEORGES BANK', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'TOWEPAPA', 'name' => 'TOWERBANK INTERNATIONAL, INC.', 'city' => 'PANAMA']);
     Bank::create(['country_id' => '591', 'code' => 'UNIBPAPA', 'name' => 'UNIBANK, S.A.', 'city' => 'PANAMA']);
     /* Perú */
     Bank::create(['country_id' => '604', 'code' => 'AZTKPEPL', 'name' => 'BANCO AZTECA DEL PERU, S.A.', 'city' => 'LIMA']);
     Bank::create(['country_id' => '604', 'code' => 'CRPEPEPL', 'name' => 'BANCO CENTRAL DE RESERVA DEL PERU', 'city' => 'LIMA']);
     Bank::create(['country_id' => '604', 'code' => 'BCONPEPL', 'name' => 'BANCO CONTINENTAL', 'city' => 'LIMA']);
     Bank::create(['country_id' => '604', 'code' => 'BDCMPEPL', 'name' => 'BANCO DE COMERCIO', 'city' => 'LIMA']);
     Bank::create(['country_id' => '604', 'code' => 'BCPLPEPL', 'name' => 'BANCO DE CREDITO DEL PERU', 'city' => 'LIMA']);
     Bank::create(['country_id' => '604', 'code' => 'BANCPEPL', 'name' => 'BANCO DE LA NACION', 'city' => 'LIMA']);
     Bank::create(['country_id' => '604', 'code' => 'FINAPEPL', 'name' => 'BANCO FINANCIERO DEL PERU', 'city' => 'LIMA']);
     Bank::create(['country_id' => '604', 'code' => 'HBPEPEPL', 'name' => 'BANCO GNB PERU SA', 'city' => 'LIMA']);
     Bank::create(['country_id' => '604', 'code' => 'BIFSPEPL', 'name' => 'BANCO INTERAMERICANO DE FINANZAS', 'city' => 'LIMA']);
     Bank::create(['country_id' => '604', 'code' => 'BINPPEPL', 'name' => 'BANCO INTERNACIONAL DEL PERU (INTERBANK)', 'city' => 'LIMA']);
     Bank::create(['country_id' => '604', 'code' => 'BSAPPEPL', 'name' => 'BANCO SANTANDER PERU S.A.', 'city' => 'LIMA']);
     Bank::create(['country_id' => '604', 'code' => 'CVLIPEPL', 'name' => 'CAVALI S.A. I.C.L.V.', 'city' => 'LIMA']);
     Bank::create(['country_id' => '604', 'code' => 'BELPPEPL', 'name' => 'CETCO S.A.', 'city' => 'LIMA']);
     Bank::create(['country_id' => '604', 'code' => 'CITIPEPL', 'name' => 'CITIBANK DEL PERU S.A.', 'city' => 'LIMA']);
     Bank::create(['country_id' => '604', 'code' => 'COFDPEPL', 'name' => 'CORPORACION FINANCIERA DE DESARROLLO S.A. - COFIDE', 'city' => 'LIMA']);
     Bank::create(['country_id' => '604', 'code' => 'DEUTPEPL', 'name' => 'DEUTSCHE BANK (PERU) S.A.', 'city' => 'LIMA']);
     Bank::create(['country_id' => '604', 'code' => 'ICBKPEPL', 'name' => 'ICBC PERU BANK', 'city' => 'LIMA']);
     Bank::create(['country_id' => '604', 'code' => 'MIBAPEPL', 'name' => 'MIBANCO, BANCO DE LA MICRO EMPRESA S.A.', 'city' => 'LIMA']);
     Bank::create(['country_id' => '604', 'code' => 'BSUDPEPL', 'name' => 'SCOTIABANK PERU S.A.A.', 'city' => 'LIMA']);
     /* Puerto Rico */
     Bank::create(['country_id' => '630', 'code' => 'ACTTPRSJ', 'name' => 'ACTIVO INTERNATIONAL BANK', 'city' => 'SAN JUAN']);
     Bank::create(['country_id' => '630', 'code' => 'ACBIPR22', 'name' => 'ANDCAPITAL BANK INTERNATIONAL CORP', 'city' => 'HATO REY']);
     Bank::create(['country_id' => '630', 'code' => 'ARNRPRSJ', 'name' => 'ARCA INTERNATIONAL BANK, INC.', 'city' => 'SAN JUAN']);
     Bank::create(['country_id' => '630', 'code' => 'BPPRPRSB', 'name' => 'BANCO POPULAR DE PUERTO RICO', 'city' => 'SAN JUAN']);
     Bank::create(['country_id' => '630', 'code' => 'BPPRPRSX', 'name' => 'BANCO POPULAR DE PUERTO RICO', 'city' => 'SAN JUAN']);
     Bank::create(['country_id' => '630', 'code' => 'BSJIPRSJ', 'name' => 'BANCO SAN JUAN INTERNACIONAL INC', 'city' => 'SAN JUAN']);
     Bank::create(['country_id' => '630', 'code' => 'BSCHPRSX', 'name' => 'BANCO SANTANDER PUERTO RICO', 'city' => 'SAN JUAN']);
     Bank::create(['country_id' => '630', 'code' => 'BSCHPRSXSOV', 'name' => 'BANCO SANTANDER PUERTO RICO', 'city' => 'SAN JUAN']);
     Bank::create(['country_id' => '630', 'code' => 'CFSUPRSJ', 'name' => 'BANCOLOMBIA PUERTO RICO INTERNACIONAL INC.', 'city' => 'SAN JUAN']);
     Bank::create(['country_id' => '630', 'code' => 'BIBCPRSJ', 'name' => 'BANCREDITO INTERNATIONAL BANK CORP', 'city' => 'SAN JUAN']);
     Bank::create(['country_id' => '630', 'code' => 'BBOIPRSJ', 'name' => 'BBO INTERNATIONAL PRIVATE BANK INC', 'city' => 'SAN JUAN']);
     Bank::create(['country_id' => '630', 'code' => 'TOTAPR22', 'name' => 'BST INTERNATIONAL BANK, INC', 'city' => 'HATO REY']);
     Bank::create(['country_id' => '630', 'code' => 'CIBPPRSJ', 'name' => 'CARACAS INTERNATIONAL BANKING CORP.', 'city' => 'SAN JUAN']);
     Bank::create(['country_id' => '630', 'code' => 'CITIPRSJ', 'name' => 'CITIBANK, NA PUERTO RICO', 'city' => 'SAN JUAN']);
     Bank::create(['country_id' => '630', 'code' => 'FILCPR22', 'name' => 'FACEBANK INTERNATIONAL CORPORATION', 'city' => 'GUAYNABO']);
     Bank::create(['country_id' => '630', 'code' => 'FBPRPRSJ', 'name' => 'FIRSTBANK PUERTO RICO', 'city' => 'SANTURCE']);
     Bank::create(['country_id' => '630', 'code' => 'IBIIPRSJ', 'name' => 'ITALBANK INTERNATIONAL, INC', 'city' => 'SAN JUAN']);
     Bank::create(['country_id' => '630', 'code' => 'NDBKPRSJ', 'name' => 'NODUS INTERNATIONAL BANK', 'city' => 'SAN JUAN']);
     Bank::create(['country_id' => '630', 'code' => 'OBPRPRSJ', 'name' => 'ORIENTAL BANK', 'city' => 'HATO REY']);
     Bank::create(['country_id' => '630', 'code' => 'NOSCPR22', 'name' => 'SCOTIABANK DE PUERTO RICO', 'city' => 'HATO REY']);
     Bank::create(['country_id' => '630', 'code' => 'NOSCPR22MIA', 'name' => 'SCOTIABANK DE PUERTO RICO', 'city' => 'SAN JUAN']);
     /* República Dominicana */
     Bank::create(['country_id' => '214', 'code' => 'APOPDOSX', 'name' => 'ASOCIACION POPULAR DE AHORROS Y PRESTAMOS (APAP)', 'city' => 'SANTO DOMINGO']);
     Bank::create(['country_id' => '214', 'code' => 'BBDIDOSD', 'name' => 'BANCO BDI, S.A.', 'city' => 'SANTO DOMINGO']);
     Bank::create(['country_id' => '214', 'code' => 'BCRDDOSX', 'name' => 'BANCO CENTRAL DE LA REPUBLICA DOMINICANA', 'city' => 'SANTO DOMINGO']);
     Bank::create(['country_id' => '214', 'code' => 'BCRDDOSXOMA', 'name' => 'BANCO CENTRAL DE LA REPUBLICA DOMINICANA', 'city' => 'SANTO DOMINGO']);
     Bank::create(['country_id' => '214', 'code' => 'BCRDDOSXSBC', 'name' => 'BANCO CENTRAL DE LA REPUBLICA DOMINICANA', 'city' => 'SANTO DOMINGO']);
     Bank::create(['country_id' => '214', 'code' => 'ACIIDOSD', 'name' => 'BANCO DE AHORRO Y CREDITO INMOBILIARIO, S. A. (BANACI)', 'city' => 'SANTO DOMINGO']);
     Bank::create(['country_id' => '214', 'code' => 'UNONDOSD', 'name' => 'BANCO DE AHORRO Y CREDITO UNION S.A.', 'city' => 'SANTO DOMINGO']);
     Bank::create(['country_id' => '214', 'code' => 'BRRDDOSD', 'name' => 'BANCO DE RESERVAS DE LA REPUBLICA DOMINICANA', 'city' => 'SANTO DOMINGO']);
     Bank::create(['country_id' => '214', 'code' => 'BDPRDOSD', 'name' => 'BANCO DOMINICANO DEL PROGRESO S.A.', 'city' => 'SANTO DOMINGO']);
     Bank::create(['country_id' => '214', 'code' => 'BLDHDOSD', 'name' => 'BANCO LOPEZ DE HARO', 'city' => 'SANTO DOMINGO']);
     Bank::create(['country_id' => '214', 'code' => 'AHCMDOSD', 'name' => 'BANCO MULTIPLE ADEMI. S.A.', 'city' => 'SANTO DOMINGO']);
     Bank::create(['country_id' => '214', 'code' => 'BELNDOSD', 'name' => 'BANCO MULTIPLE BELLBANK', 'city' => 'SANTO DOMINGO']);
     Bank::create(['country_id' => '214', 'code' => 'BCBHDOSD', 'name' => 'BANCO MULTIPLE BHD LEON S.A.', 'city' => 'SANTO DOMINGO']);
     Bank::create(['country_id' => '214', 'code' => 'NCREDOSD', 'name' => 'BANCO MULTIPLE BHD LEON, S.A. (FORMERLY BANCO MULTIPLE LEON, S.A.)', 'city' => 'SANTO DOMINGO']);
     Bank::create(['country_id' => '214', 'code' => 'STGODOSD', 'name' => 'BANCO MULTIPLE CARIBE', 'city' => 'SANTO DOMINGO']);
     Bank::create(['country_id' => '214', 'code' => 'AHCSDOSD', 'name' => 'BANCO MULTIPLE DE LAS AMERICAS, S.A', 'city' => 'SANTO DOMINGO']);
     Bank::create(['country_id' => '214', 'code' => 'BCCEDOSD', 'name' => 'BANCO MULTIPLE LAFISE S.A.', 'city' => 'SANTO DOMINGO']);
     Bank::create(['country_id' => '214', 'code' => 'PRHRDOSD', 'name' => 'BANCO MULTIPLE PROMERICA DE LA REPUBLICA DOMINICANA', 'city' => 'SANTO DOMINGO']);
     Bank::create(['country_id' => '214', 'code' => 'PEACDOSD', 'name' => 'BANCO PERAVIA DE AHORROS Y CREDITO', 'city' => 'BANI']);
     Bank::create(['country_id' => '214', 'code' => 'BPDODOSXREM', 'name' => 'BANCO POPULAR DOMINICANO, C. POR A.', 'city' => 'SANTO DOMINGO']);
     Bank::create(['country_id' => '214', 'code' => 'BPDODOSX', 'name' => 'BANCO POPULAR DOMINICANO, C. POR A.', 'city' => 'SANTO DOMINGO']);
     Bank::create(['country_id' => '214', 'code' => 'PVDLDOSD', 'name' => 'BANCO PROVIDENCIAL, S.A.', 'city' => 'SANTO DOMINGO']);
     Bank::create(['country_id' => '214', 'code' => 'SCRZDOSD', 'name' => 'BANCO SANTA CRUZ', 'city' => 'SANTO DOMINGO']);
     Bank::create(['country_id' => '214', 'code' => 'VIMEDOSD', 'name' => 'BANCO VIMENCA', 'city' => 'SANTO DOMINGO']);
     Bank::create(['country_id' => '214', 'code' => 'BANSDOSD', 'name' => 'BANESCO BANCO MULTIPLE, S. A.', 'city' => 'SANTO DOMINGO']);
     Bank::create(['country_id' => '214', 'code' => 'NOSCDOSD', 'name' => 'BANK OF NOVA SCOTIA, THE', 'city' => 'SANTO DOMINGO']);
     Bank::create(['country_id' => '214', 'code' => 'BHDVDOSD', 'name' => 'BHD LEON PUESTO DE BOLSA, S.A.', 'city' => 'SANTO DOMINGO']);
     Bank::create(['country_id' => '214', 'code' => 'CVDPDOSD', 'name' => 'CEVALDOM DEPOSITO CENTRALIZADO DE VALORES, S.A.', 'city' => 'SANTO DOMINGO']);
     Bank::create(['country_id' => '214', 'code' => 'CITIDOSD022', 'name' => 'CITIBANK, N.A.', 'city' => 'SANTIAGO DE LOS CABALLEROS']);
     Bank::create(['country_id' => '214', 'code' => 'CITIDOSDCTV', 'name' => 'CITIBANK, N.A.', 'city' => 'SANTO DOMINGO']);
     Bank::create(['country_id' => '214', 'code' => 'CITIDOSD', 'name' => 'CITIBANK, N.A.', 'city' => 'SANTO DOMINGO']);
     /* Surinam */
     Bank::create(['country_id' => '740', 'code' => 'CBVSSRPA', 'name' => 'CENTRALE BANK VAN SURINAME', 'city' => 'PARAMARIBO']);
     Bank::create(['country_id' => '740', 'code' => 'CBVSSRPASUR', 'name' => 'CENTRALE BANK VAN SURINAME', 'city' => 'PARAMARIBO']);
     Bank::create(['country_id' => '740', 'code' => 'GODOSRPA', 'name' => 'COOPERATIEVE SPAAR-EN KREDIETBANK GODO G.A.', 'city' => 'PARAMARIBO']);
     Bank::create(['country_id' => '740', 'code' => 'SURBSRPA', 'name' => 'DSB BANK ALSO KNOWN AS DE SURINAAMSCHE BANK N.V. PARAMARIBO SR', 'city' => 'PARAMARIBO']);
     Bank::create(['country_id' => '740', 'code' => 'FBNASRPA', 'name' => 'FINABANK N.V.', 'city' => 'PARAMARIBO']);
     Bank::create(['country_id' => '740', 'code' => 'ICTBSRPA', 'name' => 'FINATRUST, DE TRUSTBANK N.V.', 'city' => 'PARAMARIBO']);
     Bank::create(['country_id' => '740', 'code' => 'HAKRSRPA', 'name' => 'HAKRINBANK N.V.', 'city' => 'PARAMARIBO']);
     Bank::create(['country_id' => '740', 'code' => 'LBNKSRPA', 'name' => 'LANDBOUWBANK N.V.', 'city' => 'PARAMARIBO']);
     Bank::create(['country_id' => '740', 'code' => 'RBTTSRPA', 'name' => 'RBC ROYAL BANK (SURINAME) N.V. (FORMERLY RBTT BANKSURINAME) N.V.', 'city' => 'PARAMARIBO']);
     Bank::create(['country_id' => '740', 'code' => 'SURCSRPA', 'name' => 'SURICHANGE BANK N.V.', 'city' => 'PARAMARIBO']);
     Bank::create(['country_id' => '740', 'code' => 'SDPOSRPA', 'name' => 'SURINAAMSE POSTSPAARBANK', 'city' => 'PARAMARIBO']);
     Bank::create(['country_id' => '740', 'code' => 'VCBSSRPA', 'name' => 'SURINAAMSE VOLKSCREDIETBANK', 'city' => 'PARAMARIBO']);
     /* Uruguay */
     Bank::create(['country_id' => '858', 'code' => 'LMARUYMT', 'name' => 'ALMAR S.A.', 'city' => 'MONTEVIDEO']);
     Bank::create(['country_id' => '858', 'code' => 'AVESUYMM', 'name' => 'AVENIDA S.A EMPRESA DE SERVICIOS FINANCIEROS', 'city' => 'MONTEVIDEO']);
     Bank::create(['country_id' => '858', 'code' => 'BBVAUYMM', 'name' => 'BANCO BILBAO VIZCAYA ARGENTARIA URUGUAY S.A.', 'city' => 'MONTEVIDEO']);
     Bank::create(['country_id' => '858', 'code' => 'CBCUUYMD', 'name' => 'BANCO CENTRAL DEL URUGUAY', 'city' => 'MONTEVIDEO']);
     Bank::create(['country_id' => '858', 'code' => 'CBCUUYMF', 'name' => 'BANCO CENTRAL DEL URUGUAY', 'city' => 'MONTEVIDEO']);
     Bank::create(['country_id' => '858', 'code' => 'CBCUUYMM', 'name' => 'BANCO CENTRAL DEL URUGUAY', 'city' => 'MONTEVIDEO']);
     Bank::create(['country_id' => '858', 'code' => 'CBCUUYMMFGD', 'name' => 'BANCO CENTRAL DEL URUGUAY', 'city' => 'MONTEVIDEO']);
     Bank::create(['country_id' => '858', 'code' => 'NACNUYMM', 'name' => 'BANCO DE LA NACION ARGENTINA', 'city' => 'MONTEVIDEO']);
     Bank::create(['country_id' => '858', 'code' => 'BROUUYMM', 'name' => 'BANCO DE LA REPUBLICA ORIENTAL DEL URUGUAY', 'city' => 'MONTEVIDEO']);
     Bank::create(['country_id' => '858', 'code' => 'GABAUYMM', 'name' => 'BANCO GALICIA URUGUAY S.A.', 'city' => 'MONTEVIDEO']);
     Bank::create(['country_id' => '858', 'code' => 'ITAUUYMM', 'name' => 'BANCO ITAU', 'city' => 'MONTEVIDEO']);
     Bank::create(['country_id' => '858', 'code' => 'BPATUYMM', 'name' => 'BANCO PATAGONIA (URUGUAY) S.A.I.F.E.', 'city' => 'PUNTA DEL ESTE']);
     Bank::create(['country_id' => '858', 'code' => 'BSCHUYMM', 'name' => 'BANCO SANTANDER', 'city' => 'MONTEVIDEO']);
     Bank::create(['country_id' => '858', 'code' => 'CFACUYMM', 'name' => 'BANDES URUGUAY S.A.', 'city' => 'MONTEVIDEO']);
     Bank::create(['country_id' => '858', 'code' => 'SURIUYMM', 'name' => 'BANQUE HERITAGE (URUGUAY) S.A. (FORMERLY BANCO SURINVEST S.A.)', 'city' => 'MONTEVIDEO']);
     Bank::create(['country_id' => '858', 'code' => 'PRBAUYMM', 'name' => 'BAPRO URUGUAY', 'city' => 'MONTEVIDEO']);
     Bank::create(['country_id' => '858', 'code' => 'CSDRUYMM', 'name' => 'CENTRO SUDAMERICANO S.A. (DELTA SERVICIOS FINANCIEROS)', 'city' => 'MONTEVIDEO']);
     Bank::create(['country_id' => '858', 'code' => 'CITIUYMMCOL', 'name' => 'CITIBANK N.A. URUGUAY', 'city' => 'COLONIA']);
     Bank::create(['country_id' => '858', 'code' => 'CITIUYMM', 'name' => 'CITIBANK N.A. URUGUAY', 'city' => 'MONTEVIDEO']);
     Bank::create(['country_id' => '858', 'code' => 'CITIUYMMPDE', 'name' => 'CITIBANK N.A. URUGUAY', 'city' => 'PUNTA DEL ESTE']);
     Bank::create(['country_id' => '858', 'code' => 'COLUUYMM', 'name' => 'COLUMBUSNET S.A.', 'city' => 'MONTEVIDEO']);
     Bank::create(['country_id' => '858', 'code' => 'DBLAUYMM', 'name' => 'DISCOUNT BANK (LATIN AMERICA)', 'city' => 'MONTEVIDEO']);
     Bank::create(['country_id' => '858', 'code' => 'CBEUUYMM', 'name' => 'EUROCAM SA', 'city' => 'MONTEVIDEO']);
     Bank::create(['country_id' => '858', 'code' => 'ECBUUYMM', 'name' => 'EXPRINTER (URUGUAY) S.A.', 'city' => 'MONTEVIDEO']);
     Bank::create(['country_id' => '858', 'code' => 'GSEFUYMM', 'name' => 'GALES SERVICIOS FINANCIEROS S.A.', 'city' => 'MONTEVIDEO']);
     Bank::create(['country_id' => '858', 'code' => 'POALUYMM', 'name' => 'HAPOALIM LATIN AMERICA S.A.', 'city' => 'MONTEVIDEO']);
     Bank::create(['country_id' => '858', 'code' => 'POALUYMM001', 'name' => 'HAPOALIM LATIN AMERICA S.A.', 'city' => 'MONTEVIDEO']);
     Bank::create(['country_id' => '858', 'code' => 'POALUYMM002', 'name' => 'HAPOALIM LATIN AMERICA S.A.', 'city' => 'PUNTA DEL ESTE']);
     Bank::create(['country_id' => '858', 'code' => 'BLICUYMM', 'name' => 'HSBC BANK (URUGUAY) S.A. (FORMERLY REPUBLIC NATIONAL BANK OF NEW YORK (URUGUAY) S.A.)', 'city' => 'MONTEVIDEO']);
     Bank::create(['country_id' => '858', 'code' => 'LUMIUYMM', 'name' => 'LEUMI (LATIN AMERICA) S.A.', 'city' => 'MONTEVIDEO']);
     Bank::create(['country_id' => '858', 'code' => 'LUNDUYMT', 'name' => 'LUNDIN SA - MONEX EMPRESA DE SERVICIOS FINANCIEROS', 'city' => 'MONTEVIDEO']);
     Bank::create(['country_id' => '858', 'code' => 'MSURUYMM', 'name' => 'MONEY SUR S.A.', 'city' => 'MONTEVIDEO']);
     Bank::create(['country_id' => '858', 'code' => 'NIXSUYMM', 'name' => 'NIXUS S.A.', 'city' => 'MONTEVIDEO']);
     Bank::create(['country_id' => '858', 'code' => 'COMEUYMM', 'name' => 'SCOTIABANK URUGUAY S.A.', 'city' => 'MONTEVIDEO']);
     Bank::create(['country_id' => '858', 'code' => 'COMEUYMMALL', 'name' => 'SCOTIABANK URUGUAY S.A.', 'city' => 'MONTEVIDEO']);
     /* Venezuela */
     Bank::create(['country_id' => '862', 'code' => 'BMIGVECA', 'name' => 'BANCAMIGA BANCO MICROFINANCIERO', 'city' => 'CARACAS']);
     Bank::create(['country_id' => '862', 'code' => 'ACTIVECA', 'name' => 'BANCO ACTIVO, C.A. BANCO UNIVERSAL', 'city' => 'CARACAS']);
     Bank::create(['country_id' => '862', 'code' => 'BAVEVECA', 'name' => 'BANCO AGRICOLA DE VENEZUELA, C.A. BANCO UNIVERSAL', 'city' => 'CARACAS']);
     Bank::create(['country_id' => '862', 'code' => 'CONDVECP', 'name' => 'BANCO BICENTENARIO BANCO UNIVERSAL, C.A.', 'city' => 'CARACAS']);
     Bank::create(['country_id' => '862', 'code' => 'CAROVECA', 'name' => 'BANCO CARONI, C.A. BANCO UNIVERSAL', 'city' => 'CARACAS']);
     Bank::create(['country_id' => '862', 'code' => 'CAROVECA022', 'name' => 'BANCO CARONI, C.A. BANCO UNIVERSAL', 'city' => 'PUERTO ORDAZ']);
     Bank::create(['country_id' => '862', 'code' => 'BCVEVECA', 'name' => 'BANCO CENTRAL DE VENEZUELA', 'city' => 'CARACAS']);
     Bank::create(['country_id' => '862', 'code' => 'BCEVVECA', 'name' => 'BANCO DE COMERCIO EXTERIOR', 'city' => 'CARACAS']);
     Bank::create(['country_id' => '862', 'code' => 'FIVVVECA', 'name' => 'BANCO DE DESARROLLO ECONOMICO Y SOCIAL DE VENEZUELA', 'city' => 'CARACAS']);
     Bank::create(['country_id' => '862', 'code' => 'BECUVECA', 'name' => 'BANCO DE EXPORTACION Y COMERCIO C.A.', 'city' => 'CARACAS']);
     Bank::create(['country_id' => '862', 'code' => 'BFANVECA', 'name' => 'BANCO DE LA FUERZA ARMADA NACIONAL BOLIVARIANA, BANCO UNIVERSAL, C.A. (BANFANB)', 'city' => 'CARACAS']);
     Bank::create(['country_id' => '862', 'code' => 'VZLAVECA', 'name' => 'BANCO DE VENEZUELA, S.A. BANCO UNIVERSAL', 'city' => 'CARACAS']);
     Bank::create(['country_id' => '862', 'code' => 'LLBAVECA', 'name' => 'BANCO DEL ALBA', 'city' => 'CARACAS']);
     Bank::create(['country_id' => '862', 'code' => 'CARBVECA', 'name' => 'BANCO DEL CARIBE S.A.C.A.', 'city' => 'CARACAS']);
     Bank::create(['country_id' => '862', 'code' => 'PBLOVECA', 'name' => 'BANCO DEL PUEBLO SOBERANO, C.A.', 'city' => 'CARACAS']);
     Bank::create(['country_id' => '862', 'code' => 'BDTEVECA', 'name' => 'BANCO DEL TESORO, C.A. BANCO UNIVERSAL', 'city' => 'CARACAS']);
     Bank::create(['country_id' => '862', 'code' => 'BESCVECA', 'name' => 'BANCO ESPIRITO SANTO S.A. SUCURSAL VENEZUELA, BANCO UNIVERSAL', 'city' => 'CARACAS']);
     Bank::create(['country_id' => '862', 'code' => 'BEXTVECA', 'name' => 'BANCO EXTERIOR, C.A. BANCO UNIVERSAL', 'city' => 'CARACAS']);
     Bank::create(['country_id' => '862', 'code' => 'INDSVECA', 'name' => 'BANCO INDUSTRIAL DE VENEZUELA, C.A.', 'city' => 'CARACAS']);
     Bank::create(['country_id' => '862', 'code' => 'BNAPVECA', 'name' => 'BANCO NACIONAL DE AHORRO Y PRESTAMO', 'city' => 'CARACAS']);
     Bank::create(['country_id' => '862', 'code' => 'NCRTVECA001', 'name' => 'BANCO NACIONAL DE CREDITO, C.A.', 'city' => 'CARACAS']);
     Bank::create(['country_id' => '862', 'code' => 'NCRTVECA', 'name' => 'BANCO NACIONAL DE CREDITO, C.A.', 'city' => 'CARACAS']);
     Bank::create(['country_id' => '862', 'code' => 'CONSVECA', 'name' => 'BANCO OCCIDENTAL DE DESCUENTO (FORMERLY CORP BANCA C.A. VENEZUELA)', 'city' => 'CARACAS']);
     Bank::create(['country_id' => '862', 'code' => 'CONSVECABON', 'name' => 'BANCO OCCIDENTAL DE DESCUENTO (FORMERLY CORP BANCA C.A. VENEZUELA)', 'city' => 'CARACAS']);
     Bank::create(['country_id' => '862', 'code' => 'BODEVE2MCCS', 'name' => 'BANCO OCCIDENTAL DE DESCUENTO BU C.A.', 'city' => 'CARACAS']);
     Bank::create(['country_id' => '862', 'code' => 'BODEVE2M', 'name' => 'BANCO OCCIDENTAL DE DESCUENTO BU C.A.', 'city' => 'MARACAIBO']);
     Bank::create(['country_id' => '862', 'code' => 'PLZAVECA', 'name' => 'BANCO PLAZA', 'city' => 'CARACAS']);
     Bank::create(['country_id' => '862', 'code' => 'BPROVECASUC', 'name' => 'BANCO PROVINCIAL S.A.', 'city' => 'CARACAS']);
     Bank::create(['country_id' => '862', 'code' => 'BPROVECA', 'name' => 'BANCO PROVINCIAL S.A. BANCO UNIVERSAL', 'city' => 'CARACAS']);
     Bank::create(['country_id' => '862', 'code' => 'BPROVECAMAR', 'name' => 'BANCO PROVINCIAL S.A. BANCO UNIVERSAL', 'city' => 'MARACAIBO']);
     Bank::create(['country_id' => '862', 'code' => 'BPROVECAPZO', 'name' => 'BANCO PROVINCIAL S.A. BANCO UNIVERSAL', 'city' => 'PUERTO ORDAZ']);
     Bank::create(['country_id' => '862', 'code' => 'SFTAVE22', 'name' => 'BANCO SOFITASA', 'city' => 'SAN CRISTOBAL']);
     Bank::create(['country_id' => '862', 'code' => 'CCERVECA', 'name' => 'BANCRECER S.A. BANCO DE DESARROLLO', 'city' => 'CARACAS']);
     Bank::create(['country_id' => '862', 'code' => 'UNIOVECA', 'name' => 'BANESCO BANCO UNIVERSAL', 'city' => 'CARACAS']);
     Bank::create(['country_id' => '862', 'code' => 'BEHRVECA', 'name' => 'BANPLUS BANCO UNIVERSAL, C.A.', 'city' => 'CARACAS']);
     Bank::create(['country_id' => '862', 'code' => 'REPBVECA', 'name' => 'BFC BANCO FONDO COMUN, C.A. BANCO UNIVERSAL', 'city' => 'CARACAS']);
     Bank::create(['country_id' => '862', 'code' => 'CITIVECA', 'name' => 'CITIBANK N.A. SUCURSAL VENEZUELA', 'city' => 'CARACAS']);
     Bank::create(['country_id' => '862', 'code' => 'CAFCVECA', 'name' => 'CORPORACION ANDINA DE FOMENTO', 'city' => 'CARACAS']);
     Bank::create(['country_id' => '862', 'code' => 'DSURVECP', 'name' => 'DEL SUR BANCO UNIVERSAL, C.A.', 'city' => 'PUERTO ORDAZ']);
     Bank::create(['country_id' => '862', 'code' => 'ITALVECA', 'name' => 'ITALCAMBIO, C.A.', 'city' => 'CARACAS']);
     Bank::create(['country_id' => '862', 'code' => 'BAMRVECA', 'name' => 'MERCANTIL C.A. BANCO UNIVERSAL', 'city' => 'CARACAS']);
     Bank::create(['country_id' => '862', 'code' => 'MMCBVECA', 'name' => 'MERCANTIL MERINVEST CASA DE BOLSA', 'city' => 'CARACAS']);
     Bank::create(['country_id' => '862', 'code' => 'VZCRVECA', 'name' => 'VENEZOLANO DE CREDITO, S.A. BANCO UNIVERSAL', 'city' => 'CARACAS']);
 }
Ejemplo n.º 26
0
 /**
  * Save a new Bank
  *
  * @param BankRequest $request
  * @return mixed
  */
 private function createBank(BankRequest $request)
 {
     $bank = Bank::create($request->all());
     $this->syncHouses($bank, $request->input('house_list'));
     return $bank;
 }
Ejemplo n.º 27
0
 /**
  * Show the form for editing the specified resource.
  *
  * @param  int $id
  * @return Response
  */
 public function edit($id)
 {
     $house = House::findOrFail($id);
     $banks = Bank::lists('bank_name', 'id');
     return view('house.edit', compact('house', 'banks'));
 }
Ejemplo n.º 28
0
 /**
  * Remove the specified resource from storage.
  *
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function destroy($id)
 {
     Bank::destroy($id);
     return redirect()->route('admin.bancos.index')->with('message', '<div class="alert alert-success" style="margin-top:15px">Banco eliminado con Éxito</div>');
 }