File: Paraguay-gifi.sql

package info (click to toggle)
sql-ledger 3.2.6-1
  • links: PTS, VCS
  • area: main
  • in suites: bookworm, bullseye, buster, forky, sid, trixie
  • size: 33,080 kB
  • sloc: perl: 73,172; sql: 36,530; sh: 34; makefile: 21
file content (108 lines) | stat: -rw-r--r-- 8,690 bytes parent folder | download | duplicates (7)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
-- Paraguay GIFI
-- Plan de Cuentas Fiscal para Paraguay
--
INSERT INTO gifi (accno,description) VALUES ('1','ACTIVOS');
INSERT INTO gifi (accno,description) VALUES ('1-01','ACTIVO CORRIENTE');
INSERT INTO gifi (accno,description) VALUES ('1-01-01','DISPONIBILIDADES');
INSERT INTO gifi (accno,description) VALUES ('1-01-01-01','Caja');
INSERT INTO gifi (accno,description) VALUES ('1-01-01-02','Recaudaciones a Depositar');
INSERT INTO gifi (accno,description) VALUES ('1-01-01-03','Bancos');
INSERT INTO gifi (accno,description) VALUES ('1-01-01-04','Otros valores');
INSERT INTO gifi (accno,description) VALUES ('1-01-02','INVERSIONES TEMPORARIAS');
INSERT INTO gifi (accno,description) VALUES ('1-01-02-01','Valores');
INSERT INTO gifi (accno,description) VALUES ('1-01-03','CRDITOS');
INSERT INTO gifi (accno,description) VALUES ('1-01-03-01','Clientes');
INSERT INTO gifi (accno,description) VALUES ('1-01-03-10','Menos: Previsin para incobrables');
INSERT INTO gifi (accno,description) VALUES ('1-01-03-11','Deudores varios');
INSERT INTO gifi (accno,description) VALUES ('1-01-03-12','Documentos / Cuentas a cobrar a Directores y Funcionarios');
INSERT INTO gifi (accno,description) VALUES ('1-01-03-13','Intereses a vencer');
INSERT INTO gifi (accno,description) VALUES ('1-01-03-14','Tarjetas de Crditos');
INSERT INTO gifi (accno,description) VALUES ('1-01-03-20','Menos: Previsin para Incobrables');
INSERT INTO gifi (accno,description) VALUES ('1-01-10','INVENTARIOS');
INSERT INTO gifi (accno,description) VALUES ('1-01-10-01','Mercaderas - Productos Terminados');
INSERT INTO gifi (accno,description) VALUES ('1-01-10-02','Productos en proceso');
INSERT INTO gifi (accno,description) VALUES ('1-01-10-03','Materias primas - Materiales');
INSERT INTO gifi (accno,description) VALUES ('1-01-10-04','Menos: Previsin por Obsolencia');
INSERT INTO gifi (accno,description) VALUES ('1-01-15','ANTICIPOS');
INSERT INTO gifi (accno,description) VALUES ('1-01-15-01','Importaciones en curso');
INSERT INTO gifi (accno,description) VALUES ('1-01-15-02','Proveedores');
INSERT INTO gifi (accno,description) VALUES ('1-01-20','OTROS ACTIVOS');
INSERT INTO gifi (accno,description) VALUES ('1-01-20-01','Gastos no devengados');
INSERT INTO gifi (accno,description) VALUES ('1-02','ACTIVO NO CORRIENTE');
INSERT INTO gifi (accno,description) VALUES ('1-02-01','CRDITOS');
INSERT INTO gifi (accno,description) VALUES ('1-02-01-01','Fondos con destino especial');
INSERT INTO gifi (accno,description) VALUES ('1-02-01-02','Documentos / Cuentas a cobrar a Directores y Funcionarios');
INSERT INTO gifi (accno,description) VALUES ('1-02-01-03','Documentos por cobrar');
INSERT INTO gifi (accno,description) VALUES ('1-02-01-04','Deudores varios');
INSERT INTO gifi (accno,description) VALUES ('1-02-01-05','Crditos en Gestin de Cobro');
INSERT INTO gifi (accno,description) VALUES ('1-02-01-06','Menos: Previsiones para incobrables');
INSERT INTO gifi (accno,description) VALUES ('1-02-10','PROPIEDAD, PLANTA Y EQUIPO');
INSERT INTO gifi (accno,description) VALUES ('1-02-10-01','Bienes en operacin');
INSERT INTO gifi (accno,description) VALUES ('1-02-10-02','Depreciacin acumulada');
INSERT INTO gifi (accno,description) VALUES ('1-02-10-03','Bienes fuera de operacin');
INSERT INTO gifi (accno,description) VALUES ('1-02-20','ACTIVOS INTANGIBLES');
INSERT INTO gifi (accno,description) VALUES ('1-02-20-01','Licencia de manufactura');
INSERT INTO gifi (accno,description) VALUES ('1-02-20-02','Marcas');
INSERT INTO gifi (accno,description) VALUES ('1-02-20-03','Gastos de desarrollo');
INSERT INTO gifi (accno,description) VALUES ('1-02-20-04','Amortizacin Acumulada');
INSERT INTO gifi (accno,description) VALUES ('2','PASIVOS Y PATRIMONIO NETO');
INSERT INTO gifi (accno,description) VALUES ('2-01','PASIVO CORRIENTE');
INSERT INTO gifi (accno,description) VALUES ('2-01-01','CUENTAS A PAGAR');
INSERT INTO gifi (accno,description) VALUES ('2-01-01-01','Proveedores Locales');
INSERT INTO gifi (accno,description) VALUES ('2-01-01-02','Proveedores del Exterior');
INSERT INTO gifi (accno,description) VALUES ('2-01-01-03','Intereses a Vencer');
INSERT INTO gifi (accno,description) VALUES ('2-01-01-04','Acreedores varios');
INSERT INTO gifi (accno,description) VALUES ('2-01-05','PRSTAMOS FINANCIEROS');
INSERT INTO gifi (accno,description) VALUES ('2-01-05-01','Sobregiros en cuenta corriente');
INSERT INTO gifi (accno,description) VALUES ('2-01-05-02','Documentos a pagar');
INSERT INTO gifi (accno,description) VALUES ('2-01-05-03','Porcin circulante de prstamos a largo plazo');
INSERT INTO gifi (accno,description) VALUES ('2-01-05-04','Intereses a devengar');
INSERT INTO gifi (accno,description) VALUES ('2-01-10','PROVISIONES');
INSERT INTO gifi (accno,description) VALUES ('2-01-10-01','Impuesto a la Renta a pagar');
INSERT INTO gifi (accno,description) VALUES ('2-01-10-02','IVA a pagar');
INSERT INTO gifi (accno,description) VALUES ('2-01-10-03','Retenciones de Impuestos');
INSERT INTO gifi (accno,description) VALUES ('2-01-10-04','Para pago de planes de beneficios para empleados');
INSERT INTO gifi (accno,description) VALUES ('2-01-10-05','Aportes y Retenciones a Pagar');
INSERT INTO gifi (accno,description) VALUES ('2-01-10-06','Gastos Acumulados a Pagar');
INSERT INTO gifi (accno,description) VALUES ('2-01-20','OTROS PASIVOS');
INSERT INTO gifi (accno,description) VALUES ('2-01-20-01','Prstamos de Terceros');
INSERT INTO gifi (accno,description) VALUES ('2-01-20-02','Anticipo de Clientes');
INSERT INTO gifi (accno,description) VALUES ('2-01-40','GANANCIAS DIFERIDAS');
INSERT INTO gifi (accno,description) VALUES ('2-01-40-01','Ingresos no realizados');
INSERT INTO gifi (accno,description) VALUES ('2-01-40-02','Costos y gastos aplicables a los ingresos no realizables');
INSERT INTO gifi (accno,description) VALUES ('2-02','PASIVOS NO CORRIENTES');
INSERT INTO gifi (accno,description) VALUES ('2-02-01','PRSTAMOS FINANCIEROS');
INSERT INTO gifi (accno,description) VALUES ('2-02-01-01','Prstamos en Bancos');
INSERT INTO gifi (accno,description) VALUES ('2-02-05','PREVISIONES');
INSERT INTO gifi (accno,description) VALUES ('2-02-05-01','Previsin para indemnizacin');
INSERT INTO gifi (accno,description) VALUES ('2-02-05-02','Otras Contingencias');
INSERT INTO gifi (accno,description) VALUES ('2-03','PATRIMONIO NETO');
INSERT INTO gifi (accno,description) VALUES ('2-03-01','CAPITAL');
INSERT INTO gifi (accno,description) VALUES ('2-03-01-01','Capital suscripto');
INSERT INTO gifi (accno,description) VALUES ('2-03-01-02','Capital a integrar');
INSERT INTO gifi (accno,description) VALUES ('2-03-01-03','Capital realizado');
INSERT INTO gifi (accno,description) VALUES ('2-03-02','RESERVAS');
INSERT INTO gifi (accno,description) VALUES ('2-03-02-01','Reserva Legal');
INSERT INTO gifi (accno,description) VALUES ('2-03-02-02','Reservas facultativas');
INSERT INTO gifi (accno,description) VALUES ('2-03-02-03','Reserva de revalo');
INSERT INTO gifi (accno,description) VALUES ('2-03-03','RESULTADOS');
INSERT INTO gifi (accno,description) VALUES ('2-03-03-01','Resultados Acumulados');
INSERT INTO gifi (accno,description) VALUES ('2-03-03-02','Resultado del Ejercicio');
INSERT INTO gifi (accno,description) VALUES ('3-01','Ventas Netas. Sector Pblico');
INSERT INTO gifi (accno,description) VALUES ('3-02','Ventas Netas. Sector Privado');
INSERT INTO gifi (accno,description) VALUES ('3-10','Ms otros ingresos');
INSERT INTO gifi (accno,description) VALUES ('3-10-01','Intereses ganados');
INSERT INTO gifi (accno,description) VALUES ('3-10-02','Otros (indicar naturaleza)');
INSERT INTO gifi (accno,description) VALUES ('3-20','Menos:');
INSERT INTO gifi (accno,description) VALUES ('3-20-01','Gastos financieros');
INSERT INTO gifi (accno,description) VALUES ('3-30-01','Ganancias');
INSERT INTO gifi (accno,description) VALUES ('4-01','Costo de Mercaderas (productos o servicios vendidos');
INSERT INTO gifi (accno,description) VALUES ('4-10','Menos:');
INSERT INTO gifi (accno,description) VALUES ('4-11','Gastos operacionales');
INSERT INTO gifi (accno,description) VALUES ('4-12','Gastos de ventas');
INSERT INTO gifi (accno,description) VALUES ('4-13','Gastos de administracin');
INSERT INTO gifi (accno,description) VALUES ('4-20','Otros (indicar naturaleza)');
INSERT INTO gifi (accno,description) VALUES ('4-30','Prdidas');
INSERT INTO gifi (accno,description) VALUES ('5-10','Ms: (o menos) efectos de los precios cambiantes');
INSERT INTO gifi (accno,description) VALUES ('5-20','Ms: (o menos) ajuste de ejercicios anteriores');
INSERT INTO gifi (accno,description) VALUES ('5-50','Impuesto a la Renta');