******************************************************************************************************* APERTURA DEL EJERCICIO CONTABLE ******************************************************************************************************* SELECT scg_cuentas.sc_cuenta, coalesce(saldo.T_Debe,0) as total_debe, coalesce(saldo.T_Haber,0) as total_haber FROM scg_cuentas LEFT OUTER JOIN (SELECT codemp,sc_cuenta, coalesce(sum(debe_mes),0)as T_Debe, coalesce(sum(haber_mes),0) as T_Haber FROM scg_saldos WHERE codemp='0001' AND fecsal<='2019-12-31' GROUP BY codemp,sc_cuenta) saldo ON scg_cuentas.codemp=saldo.codemp AND scg_cuentas.sc_cuenta=saldo.sc_cuenta WHERE scg_cuentas.codemp='0001' AND (scg_cuentas.sc_cuenta like '1%' OR scg_cuentas.sc_cuenta like '2%' OR scg_cuentas.sc_cuenta like '3%' OR scg_cuentas.sc_cuenta like '3%' OR scg_cuentas.sc_cuenta like '410%' OR scg_cuentas.sc_cuenta like '420%') AND scg_cuentas.status='C' ORDER BY trim(scg_cuentas.sc_cuenta) INSERT INTO sigesp_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,descripcion,tipo_comp,tipo_destino,cod_pro,ced_bene,total) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","APERTURA DE SALDOS","2","-","----------","----------",0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","111010201001","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",12650447,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","111010201002","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",1.46,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","111010201003","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",3204.35,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","111010201004","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",40149570.19,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","111010201005","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",3000572.06,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","111010201006","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",2174.22,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","111010201008","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",504767128.72,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","111010201009","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",1.9,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","111010201012","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",225161331.13,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","111010201016","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",152552322.08,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","111010201018","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",6567591658.56,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","111010201019","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",4948684601.67,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","111010201020","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",435414412.49,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","111010201021","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",18790477.53,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","111010202001","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",0.12,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","111010202002","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",0.76,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","111010202003","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",5.26,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","111010203003","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",1818203923.97,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","112030101025","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",139074850,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","112030101026","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",9255.28,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","112030101029","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",41194609.77,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","112030101030","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",15000000,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","112030300000","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",14854173.84,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","112039900000","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",759302997.8,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","112100100000","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",760.82,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","114990100100","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",1058514854.3,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","119990100000","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",8135.1,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","119999001000","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",160116037.83,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","123010101001","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",24729.27,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","123010201001","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",1.07,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","123010201002","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",8850.68,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","123010201004","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",125305.37,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","123010201006","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",184000,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","123010301001","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",5.92,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","123010301002","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",14.89,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","123010301003","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",4.31,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","123010301004","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",7.38,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","123010401001","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",1.56,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","123010401002","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",38853884.73,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","123010501001","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",64589738.4,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","123010601001","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",79350000.98,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","123010601003","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",54.21,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","123010801001","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",139854.65,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","123010801002","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",9.66,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","123010901002","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",35137000,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","123019901001","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",5430128.07,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","123019901002","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",1.37,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","123019902003","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",293200000,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","123050100000","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",2328061.86,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","124040101001","SCGAPR","0000000APERTURA","D","APERTURA DE SALDOS",1081,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","211010401001","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",70980367.87,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","211010600000","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",8254543.78,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","211019901001","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",24192.87,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","211020701001","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",3679591.84,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","211030701001","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",0.1,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","211030801001","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",2061996.84,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","211040101001","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",44291450.42,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","211040102001","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",15072355.96,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","211040102002","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",39946139.99,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","211040102003","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",14780230.68,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","211040102004","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",8192353.92,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","211040102005","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",48107697.11,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","211040102014","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",46575.72,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","211040102015","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",1556943.58,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","211040201001","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",24448.6,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","211049901001","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",1200382,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","213010101003","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",360.57,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","213010101005","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",68.24,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","213010101006","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",157200.12,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","214990101001","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",38000,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","214990101002","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",344430609.76,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","214990101003","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",441876,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","214990101005","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",135021.28,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","214990101006","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",2739374.76,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","214990102004","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",1609777,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","214990102007","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",41481.48,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","214990102011","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",4800,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","214990102014","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",175389886.2,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","214990102015","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",542312087.26,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","214990103001","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",7919832.38,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","214990104001","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",28.53,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","214990104002","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",240.04,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","214990199002","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",234657292.92,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","225010201001","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",6964.23,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","225010301001","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",9.56,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","225010401001","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",1875.15,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","225010601001","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",8.22,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","225010801001","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",11463.41,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","225019901001","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",11249.99,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","225019901002","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",0.09,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","225020401001","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",179.46,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","311010101001","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",264264.62,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","315010101001","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",15866027020.95,0); INSERT INTO scg_dt_cmp (codemp ,procede ,comprobante,fecha,codban,ctaban,sc_cuenta,procede_doc,documento,debhab,descripcion,monto,orden) VALUES ("0001","SCGAPR","0000000APERTURA","2019-12-31","---","-------------------------","315020101002","SCGAPR","0000000APERTURA","H","APERTURA DE SALDOS",0.09,0); ******************************************************************************************************* * La Apertura de Contabilidad se Creo con Exito *******************************************************************************************************