DWADW.VIEW_TRX_CONTABILIDAD

Base de datos origen: ADW COEXITO
Tipo de objeto: MATERIALIZED VIEW
SQL

  CREATE MATERIALIZED VIEW "DWADW"."VIEW_TRX_CONTABILIDAD" ("MES", "ANIO", "LIBRO", "ENTIDAD", "CUENTA", "UNIDAD", "BENEFICIARIO", "UBICACION", "LINEA", "PROYECTO", "CECO_GESTIONADOR", "FUTURO1", "FUTURO2", "DEBITOS", "CREDITOS")
  DEFAULT COLLATION "USING_NLS_COMP"  SEGMENT CREATION IMMEDIATE
  ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 10 MAXTRANS 255 
 COLUMN STORE COMPRESS FOR QUERY HIGH ROW LEVEL LOCKING LOGGING
  BUILD DEFERRED
  USING INDEX 
  REFRESH FORCE ON DEMAND
  USING DEFAULT LOCAL ROLLBACK SEGMENT
  USING ENFORCED CONSTRAINTS DISABLE ON QUERY COMPUTATION DISABLE QUERY REWRITE DISABLE CONCURRENT REFRESH
  AS SELECT 
    EXTRACT(MONTH FROM trx.gl_date) AS mes,
    EXTRACT(YEAR  FROM trx.gl_date) AS anio,
    'COE_CO_IFRS' AS libro,
    'CO01' AS entidad,
    trx.segment2  AS cuenta,
    trx.segment3  AS unidad,
    trx.segment4  AS beneficiario,
    trx.segment5  AS ubicacion,
    trx.segment6  AS linea,
    trx.segment7  AS proyecto,
    trx.segment8  AS ceco_gestionador,
    trx.segment9  AS futuro1,
    trx.segment10 AS futuro2,
    NVL(SUM(trx.accounted_dr), 0) AS debitos,
    NVL(SUM(trx.accounted_cr), 0) AS creditos
FROM DWADW.DW_MV_TRXCONTABILIDAD_GL trx
WHERE trx.is_modified IS NULL
GROUP BY
    EXTRACT(MONTH FROM trx.gl_date),
    EXTRACT(YEAR  FROM trx.gl_date),
    trx.segment2,
    trx.segment3,
    trx.segment4,
    trx.segment5,
    trx.segment6,
    trx.segment7,
    trx.segment8,
    trx.segment9,
    trx.segment10;
← Volver al esquema DWADW
🏠 Volver al menú principal