text: /* Formatted on 12-20-2018 1:38:29 PM (QP5 v5.126.903.23003) */
  /*
  "C:\Program Files (x86)\pgAdmin 4\v3\runtime\pg_dump" --host localhost --port 5432 --username postgres --verbose --table=SCM.SCM_CSTMR_SUPLR_SITES --data-only --column-inserts psdc_live > SCM.SCM_CSTMR_SUPLR_SITES.sql
  */
  set define off;
  TRUNCATE TABLE SCM.SCM_CSTMR_SUPLR_SITES CASCADE;
  
  
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (75, 'Bank of Ghana', '', '', 116, '2016-07-12 11:36:17', 116, '2016-07-12 11:36:17', 'Accra', 'Accra', '', '', '', -1, -1, 81, '', '', '', '', '', '', '', '', '', '1', '', -1);
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (76, 'Zenith Bank Gh Ltd.', '', '', 116, '2016-07-12 12:49:21', 116, '2016-07-12 12:49:21', 'Accra', 'Accra', '', '', '', -1, -1, 82, '', '', '', '', '', '', '', '', '', '1', '', -1);
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (77, 'Access Bank (Ghana) Limited', '', '', 116, '2016-07-12 12:55:00', 116, '2016-07-12 12:55:00', 'Accra', 'Accra', '', '', '', -1, -1, 83, '', '', '', '', '', '', '', '', '', '1', '', -1);
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (78, 'ADB Bank Limited', '', '', 116, '2016-07-12 13:00:08', 116, '2016-07-12 13:00:08', 'Accra', 'Accra', '', '', '', -1, -1, 84, '', '', '', '', '', '', '', '', '', '1', '', -1);
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (76, 'Zenith Bank Gh Ltd.', '', '', 116, '2016-07-12 13:09:01', 116, '2016-07-12 13:09:01', 'A', 'A', '', '', '', -1, -1, 85, '', '', '', '', '', '', '', '', '', '1', '', -1);
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (79, 'ARB Apex Bank Ltd', '', '', 116, '2016-07-12 13:09:02', 116, '2016-07-12 13:09:02', 'Accra', 'Accra', '', '', '', -1, -1, 86, '', '', '', '', '', '', '', '', '', '1', '', -1);
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (80, 'UT Bank Limited', '', '', 116, '2016-07-12 13:15:17', 116, '2016-07-12 13:15:17', 'Accra', 'Accra', '', '', '', -1, -1, 87, '', '', '', '', '', '', '', '', '', '1', '', -1);
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (81, 'Bank of Baroda (Ghana) Limited', '', '', 116, '2016-07-12 13:15:49', 116, '2016-07-12 13:15:49', 'Accra', 'Accra', '', '', '', -1, -1, 88, '', '', '', '', '', '', '', '', '', '1', '', -1);
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (82, 'Barclays Bank of Ghana Ltd', '', '', 116, '2016-07-12 13:17:05', 116, '2016-07-12 13:17:05', 'Accra', 'Accra', '', '', '', -1, -1, 89, '', '', '', '', '', '', '', '', '', '1', '', -1);
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (83, 'uniBank Ghana Ltd', '', '', 116, '2016-07-12 13:18:41', 116, '2016-07-12 13:18:41', 'Accra', 'Accra', '', '', '', -1, -1, 90, '', '', '', '', '', '', '', '', '', '1', '', -1);
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (84, 'United Bank for Africa (Ghana) Ltd', '', '', 116, '2016-07-12 13:24:05', 116, '2016-07-12 13:24:05', 'Accra', 'Accra', '', '', '', -1, -1, 91, '', '', '', '', '', '', '', '', '', '1', '', -1);
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (85, 'Universal Merchant Bank (Ghana) Ltd', '', '', 116, '2016-07-12 13:25:46', 116, '2016-07-12 13:25:46', 'Accra', 'Accra', '', '', '', -1, -1, 92, '', '', '', '', '', '', '', '', '', '1', '', -1);
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (86, 'BSIC Ghana Limited (Bank)', '', '', 116, '2016-07-12 13:27:11', 116, '2016-07-12 13:27:11', 'Accra', 'Accra', '', '', '', -1, -1, 93, '', '', '', '', '', '', '', '', '', '1', '', -1);
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (87, 'Bank of Africa Ghana Ltd', '', '', 116, '2016-07-12 13:33:22', 116, '2016-07-12 13:33:22', 'Accra', 'Accra', '', '', '', -1, -1, 94, '', '', '', '', '', '', '', '', '', '1', '', -1);
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (88, 'The Royal Bank Limited', '', '', 116, '2016-07-12 13:38:06', 116, '2016-07-12 13:38:06', 'Accra', 'Accra', '', '', '', -1, -1, 95, '', '', '', '', '', '', '', '', '', '1', '', -1);
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (89, 'CAL Bank Limited', '', '', 116, '2016-07-12 14:29:37', 116, '2016-07-12 14:29:37', 'Accra', 'Accra', '', '', '', -1, -1, 96, '', '', '', '', '', '', '', '', '', '1', '', -1);
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (90, 'Stanbic Bank Ghana Ltd', '', '', 116, '2016-07-12 14:34:28', 116, '2016-07-12 14:34:28', 'Accra', 'Accra', '', '', '', -1, -1, 97, '', '', '', '', '', '', '', '', '', '1', '', -1);
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (91, 'Capital Bank Limited', '', '', 116, '2016-07-12 14:36:30', 116, '2016-07-12 14:36:30', 'Accra', 'Accra', '', '', '', -1, -1, 98, '', '', '', '', '', '', '', '', '', '1', '', -1);
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (92, 'Societe General Ghana Limited (Bank)', '', '', 116, '2016-07-12 14:42:37', 116, '2016-07-12 14:42:37', 'Accra', 'Accra', '', '', '', -1, -1, 99, '', '', '', '', '', '', '', '', '', '1', '', -1);
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (93, 'Ecobank Ghana Limited', '', '', 116, '2016-07-12 14:44:27', 116, '2016-07-12 14:44:27', 'Accra', 'Accra', '', '', '', -1, -1, 100, '', '', '', '', '', '', '', '', '', '1', '', -1);
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (94, 'Energy Bank (Ghana) Ltd', '', '', 116, '2016-07-12 14:47:47', 116, '2016-07-12 14:47:47', 'Accra', 'Accra', '', '', '', -1, -1, 101, '', '', '', '', '', '', '', '', '', '1', '', -1);
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (95, 'Standard Chartered Bank (Ghana) Limited', '', '', 116, '2016-07-12 14:49:20', 116, '2016-07-12 14:49:20', 'Accra', 'Accra', '', '', '', -1, -1, 102, '', '', '', '', '', '', '', '', '', '1', '', -1);
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (96, 'First Atlantic Bank Ltd', '', '', 116, '2016-07-12 14:50:33', 116, '2016-07-12 14:50:33', 'Accra', 'Accra', '', '', '', -1, -1, 103, '', '', '', '', '', '', '', '', '', '1', '', -1);
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (97, 'Prudential Bank Limited', '', '', 116, '2016-07-12 14:52:38', 116, '2016-07-12 14:52:38', 'Accra', 'Accra', '', '', '', -1, -1, 104, '', '', '', '', '', '', '', '', '', '1', '', -1);
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (98, 'FBN Bank Ghana Ltd', '', '', 116, '2016-07-12 14:56:06', 116, '2016-07-12 14:56:06', 'Accra', 'Accra', '', '', '', -1, -1, 105, '', '', '', '', '', '', '', '', '', '1', '', -1);
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (99, 'National Investment Bank Ltd', '', '', 116, '2016-07-12 15:01:15', 116, '2016-07-12 15:01:15', 'Accra', 'Accra', '', '', '', -1, -1, 106, '', '', '', '', '', '', '', '', '', '1', '', -1);
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (100, 'Fidelity Bank Limited', '', '', 116, '2016-07-12 15:01:34', 116, '2016-07-12 15:01:34', 'Accra', 'Accra', '', '', '', -1, -1, 107, '', '', '', '', '', '', '', '', '', '1', '', -1);
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (101, 'First National Bank Ghana Ltd', '', '', 116, '2016-07-12 16:35:39', 116, '2016-07-12 16:35:39', 'Accra', 'Accra', '', '', '', -1, -1, 108, '', '', '', '', '', '', '', '', '', '1', '', -1);
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (102, 'HFC Bank Ghana Ltd', '', '', 116, '2016-07-12 16:37:16', 116, '2016-07-12 16:37:16', 'Accra', 'Accra', '', '', '', -1, -1, 109, '', '', '', '', '', '', '', '', '', '1', '', -1);
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (103, 'GCB Bank Limited', '', '', 116, '2016-07-12 16:40:11', 116, '2016-07-12 16:40:11', 'Accra', 'Accra', '', '', '', -1, -1, 110, '', '', '', '', '', '', '', '', '', '1', '', -1);
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (104, 'GN Bank Limited', '', '', 116, '2016-07-12 16:42:56', 116, '2016-07-12 16:42:56', 'Accra', 'Accra', '', '', '', -1, -1, 111, '', '', '', '', '', '', '', '', '', '1', '', -1);
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (105, 'Guaranty Trust Bank (Ghana) Limited', '', '', 116, '2016-07-12 16:45:02', 116, '2016-07-12 16:45:02', 'Accra', 'Accra', '', '', '', -1, -1, 112, '', '', '', '', '', '', '', '', '', '1', '', -1);
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (106, 'Millicom Ghana Limited (Tigo)', '', '', 116, '2016-07-12 18:30:58', 116, '2016-07-12 18:30:58', 'Accra', 'Accra', '', '', '', -1, -1, 113, '', '', '', '', '', '', '', '', '', '1', '', -1);
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (107, 'Vodafone Ghana Limited', '', '', 116, '2016-07-12 18:33:32', 116, '2016-07-12 18:33:32', 'Accra', 'Accra', '', '', '', -1, -1, 114, '', '', '', '', '', '', '', '', '', '1', '', -1);
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (108, 'MTN Ghana Limited', '', '', 116, '2016-07-12 18:36:01', 116, '2016-07-12 18:36:01', 'Accra', 'Accra', '', '', '', -1, -1, 115, '', '', '', '', '', '', '', '', '', '1', '', -1);
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (109, 'Airtel Ghana Limited', '', '', 116, '2016-07-12 18:38:13', 116, '2016-07-12 18:38:13', 'Accra', 'Accra', '', '', '', -1, -1, 116, '', '', '', '', '', '', '', '', '', '1', '', -1);
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (110, 'Zeepay Ghana Limited', '', '', 116, '2016-07-12 18:39:41', 116, '2016-07-12 18:39:41', 'Accra', 'Accra', '', '', '', -1, -1, 117, '', '', '', '', '', '', '', '', '', '1', '', -1);
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (111, 'eTranzact Ghana Limited', '', '', 116, '2016-07-12 18:41:30', 116, '2016-07-12 18:41:30', 'Accra', 'Accra', '', '', '', -1, -1, 118, '', '', '', '', '', '', '', '', '', '1', '', -1);
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (108, 'MTN Ghana Limited', '', '', 215, '2016-07-20 10:07:11', 215, '2016-07-20 10:07:11', 'Finance/ Treasury', 'Finance/ Treasury', '', '', '', -1, -1, 119, '', '', '', '', '', '', '', '', '', '1', '', -1);
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (106, 'Millicom Ghana Limited (Tigo)', '', '', 211, '2016-07-27 16:07:41', 211, '2016-07-27 16:07:41', 'Barnes Road', 'Barnes Road', '', '', '', -1, -1, 120, '', '', '', '', '', '', '', '', '', '1', '', -1);
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (112, 'Sovereign Bank Ghana Limited', '', '', 116, '2016-07-29 08:52:16', 116, '2016-07-29 08:52:16', 'Accra', 'Accra', '', '', '', -1, -1, 121, '', '', '', '', '', '', '', '', '', '1', '', -1);
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (113, 'Premium Bank', '', '', 285, '2016-12-23 16:13:51', 285, '2016-12-23 16:13:51', 'Accra', 'Accra', '', '', '', -1, -1, 122, '', '', '', '', '', '', '', '', '', '1', '', -1);
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (114, 'OmniBank Ghana', '', '', 285, '2017-02-06 08:34:35', 285, '2017-02-06 08:34:35', 'Accra', 'Accra', '', '', '', -1, -1, 123, '', '', '', '', '', '', '', '', '', '1', '', -1);
  INSERT INTO scm.scm_cstmr_suplr_sites (cust_supplier_id, contact_person_name, contact_nos, email, created_by, creation_date, last_update_by, last_update_date, site_name, site_desc, bank_name, bank_branch, bank_accnt_number, wth_tax_code_id, discount_code_id, cust_sup_site_id, billing_address, ship_to_address, swift_code, nationality, national_id_typ, id_number, date_issued, expiry_date, other_info, is_enabled, iban_number, accnt_cur_id) VALUES (115, 'Heritage Bank Limited', '', '', 285, '2017-08-15 11:05:17', 285, '2017-08-15 11:05:17', 'Accra', 'Accra', '', '', '', -1, -1, 124, '', '', '', '', '', '', '', '', '', '1', '', -1);
  
  
  
  
  COMMIT;
  EXEC SYS.SEQUENCE_NEWVALUE( 'SCM', 'SCM_CUSTMR_SUPLIER_SITE_ID_SEQ', 130 );
  COMMIT;
  