
/* 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

