/* se crea una tabla temporal llamada sigesp_plan_unico_caif con sus respectivas instrucciones inserts*/ -- ---------------------------- -- Table structure for "public"."sigesp_plan_unico_caif" -- ---------------------------- CREATE TABLE "public"."sigesp_plan_unico_caif"( "codigo_caif" char(25) NOT NULL , "sig_cuenta" char(25) ) WITHOUT OIDS; -- ---------------------------- -- Records -- ---------------------------- INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11123200000 ', '303020100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11124900000 ', '303990100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21101101000 ', '401010100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21101201000 ', '402050400 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21201102000 ', '404090200 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22109102000 ', '405050202 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12109102000 ', '311010201 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12109103000 ', '311010202 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22109112000 ', '405050201 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11123100000 ', '301090100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11123200000 ', '301090200 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11123900000 ', '301099900 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11125101020 ', '301100501 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11125102010 ', '301100300 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11125102020 ', '301100503 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11125201000 ', '301100601 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11125202000 ', '301100801 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11125204000 ', '301100802 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11127200000 ', '30111 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11127300000 ', '301990100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11301101000 ', '306010200 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11301102000 ', '306010100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11303101000 ', '308010000 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11303102010 ', '308020100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11303102020 ', '308020200 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11303102030 ', '308020300 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11303102040 ', '308020400 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11303102050 ', '308020500 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11303102060 ', '308020600 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11303103010 ', '308030100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11303103090 ', '308039900 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11303201000 ', '309010100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11303202010 ', '309020100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11303202020 ', '309020200 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11303202030 ', '309020300 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11303202040 ', '309020400 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11303202050 ', '309020500 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11303202060 ', '309020600 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11303202070 ', '309020700 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11303202080 ', '309020800 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11303202090 ', '309020900 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11303203010 ', '309030100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11303203020 ', '309030200 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11303203030 ', '309030300 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11303301000 ', '310010100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11303302010 ', '310020100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11303302020 ', '310020200 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11303302030 ', '310020300 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11303302040 ', '310020400 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11303302050 ', '310020500 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11303302060 ', '310020600 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11303302070 ', '310020700 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11303302080 ', '310020800 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11303302090 ', '310020900 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11303303010 ', '310030100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11303303020 ', '310030200 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('11303303030 ', '310030300 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12104101000 ', '307010100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12104102000 ', '307010200 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12104103000 ', '307010300 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12104201000 ', '307020100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12104202000 ', '307020200 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12109101000 ', '311010100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12109102000 ', '311010200 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12109103000 ', '311010300 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12109201000 ', '311020100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12109202000 ', '311020200 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12109301000 ', '311030100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12109302000 ', '311039900 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12109401000 ', '311040100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12109402000 ', '311040200 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12109403000 ', '311049900 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12109501000 ', '311050100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12109502000 ', '311059900 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12109603000 ', '311060300 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12109604000 ', '311060400 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12109605000 ', '311060500 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12109606000 ', '311060600 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12109607000 ', '311070000 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12109608000 ', '311080000 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12109700000 ', '311200000 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12109800000 ', '311990100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12109900000 ', '311990200 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12201101000 ', '312010100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12201102000 ', '312020000 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12201103000 ', '312030100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12201104000 ', '312030200 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12201105000 ', '312040100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12201106000 ', '312040200 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12201107010 ', '312050100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12201107020 ', '312050200 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12201201000 ', '312030300 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12201202000 ', '312030400 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12201203000 ', '312040300 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12201204000 ', '312040400 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12201301000 ', '312060100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12201302000 ', '312060200 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12201303000 ', '312060300 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12202100000 ', '312100100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12202200000 ', '312100200 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12203100000 ', '312070100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12203201000 ', '312070201 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12203202000 ', '312070202 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12203203000 ', '312070203 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12203301010 ', '312080101 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12203301020 ', '312080102 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12203301030 ', '312080103 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12203301040 ', '312080104 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12203301090 ', '312080199 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12203302000 ', '312080200 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12203401000 ', '312090100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12203402000 ', '312099900 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12203800000 ', '312990100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12203900000 ', '312990200 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12401100000 ', '313010100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12401200000 ', '313010200 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12402100000 ', '313020100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12403100000 ', '313030100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12404100000 ', '313040100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('12404200000 ', '313040200 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21101701000 ', '408070100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21101702000 ', '408070200 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21101703000 ', '408070300 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21101502000 ', '408060100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21103101030 ', '408020100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21103101040 ', '408020200 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21103101050 ', '408020300 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21103200000 ', '403010300 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21103300000 ', '403030000 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21106300000 ', '408060200 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21106400000 ', '408060300 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21106500000 ', '408060500 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21106601000 ', '408050100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21106602000 ', '408050200 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21106603000 ', '408050300 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21106802000 ', '408080102 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21105000000 ', '407010000 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21105101000 ', '407010100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21105101011 ', '407010101 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21105101012 ', '407010102 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21105101050 ', '407010199 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21201107050 ', '403010300 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21203101000 ', '405010100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21203102000 ', '405010200 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21203102010 ', '405010201 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21203102020 ', '405010202 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21203102030 ', '405010203 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21203102040 ', '405010204 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21203102050 ', '405010205 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21203102060 ', '405010206 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21203102070 ', '405010207 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21203103000 ', '405010300 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21203103010 ', '405010301 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21203103020 ', '405010399 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21203201000 ', '405030100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21203202000 ', '405030200 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21203202010 ', '405030201 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21203202020 ', '405030202 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21203202030 ', '405030203 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21203202040 ', '405030204 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21203202050 ', '405030205 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21203202060 ', '405030206 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21203202070 ', '405030207 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21203202080 ', '405030208 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21203202090 ', '405030209 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21203203000 ', '405030300 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21203203010 ', '405030301 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21203203020 ', '405030302 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21203203030 ', '405030303 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21203301000 ', '405040100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21203302000 ', '405040200 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21203302010 ', '405040201 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21203302020 ', '405040202 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21203302030 ', '405040203 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21203302040 ', '405040204 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21203302050 ', '405040205 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21203302060 ', '405040206 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21203302070 ', '405040207 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21203302080 ', '405040208 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21203302090 ', '405040209 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21203303000 ', '405040300 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21203303010 ', '405040301 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21203303020 ', '405040302 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21203303030 ', '405040303 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22104100000 ', '405020100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22104101000 ', '405020101 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21204102000 ', '405020102 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('21204103000 ', '405020103 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22104200000 ', '405020200 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22104201000 ', '405020201 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22104202000 ', '405020202 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22104203000 ', '405020203 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22109101000 ', '405050100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22109102000 ', '405050200 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22109103000 ', '405050300 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22109201000 ', '405060100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22109202000 ', '405060200 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22109203000 ', '405060300 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22109203010 ', '405060301 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22109203020 ', '405060302 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22109204000 ', '405069900 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22109301000 ', '405070100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22109302000 ', '405079900 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22109401000 ', '405080100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22109402000 ', '405080200 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22109403000 ', '405089900 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22109501000 ', '405090100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22109502000 ', '405099900 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22109603000 ', '405100300 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22109604000 ', '405100400 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22109605000 ', '405100500 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22109606000 ', '405100600 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22109800000 ', '405210000 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22200000000 ', '411000000 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22201000000 ', '411030000 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22201000000 ', '411040000 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22201101000 ', '411010100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22201102000 ', '411020000 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22201103000 ', '411030100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22201104000 ', '411030200 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22201105000 ', '411040100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22201106000 ', '411040200 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22201107000 ', '411050000 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22201107010 ', '411050100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22201107020 ', '411050200 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22201201000 ', '411030300 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22201202000 ', '411030400 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22201203000 ', '411040300 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22201204000 ', '411040400 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22201300000 ', '411060000 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22201301000 ', '411060100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22201302000 ', '411060200 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22201303000 ', '411060300 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22202000000 ', '411100000 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22202100000 ', '411100100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22202200000 ', '411100200 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22203100000 ', '411070100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22203200000 ', '411070200 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22203300000 ', '411070201 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22203301000 ', '411070202 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22203302000 ', '411070203 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22203400000 ', '411080000 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22203401000 ', '411080100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22203401010 ', '411080101 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22203401020 ', '411080102 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22203401030 ', '411080103 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22203401040 ', '411080104 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22203401090 ', '411080199 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22203402000 ', '411080200 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22203500000 ', '411090000 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22203501000 ', '411090100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22203502000 ', '411099900 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22203600000 ', '411980100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22203700000 ', '411990100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22400000000 ', '412000000 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22401000000 ', '412010000 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22401100000 ', '412010100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22401200000 ', '412010200 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22402000000 ', '412020000 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22402100000 ', '412020100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22403000000 ', '412030000 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22403100000 ', '412030100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22404000000 ', '412040000 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22404100000 ', '412040100 '); INSERT INTO "public"."sigesp_plan_unico_caif" VALUES ('22404200000 ', '412040200 '); /*se crea el campo de codigo caif en la tabla sigesp_plan_unico_re.*/ alter table sigesp_plan_unico_re add codcaif varchar(25); /*se copian los datos desde la tabla temporal al campo codcaif de la tabla sigesp_plan_unico_re*/ update sigesp_plan_unico_re set codcaif=sigesp_plan_unico_caif.codigo_caif from sigesp_plan_unico_caif where sigesp_plan_unico_re.sig_cuenta=sigesp_plan_unico_caif.sig_cuenta; /* se elimina la tabla temporal */ drop table sigesp_plan_unico_caif