DWADW.VW_TRXCONTABILIDAD_GL

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

  CREATE OR REPLACE FORCE EDITIONABLE VIEW "DWADW"."VW_TRXCONTABILIDAD_GL" ("TRXCONTABILIDADID", "PERIOD_YEAR", "PERIOD_NUMBER", "GL_DATE", "TRANSACTION_DATE", "TRANSACTION_NUMBER", "ACCOUNTED_DR", "ACCOUNTED_CR", "ENTERED_CURRENCY", "JE_SOURCE_NAME", "JE_CATEGORY_NAME", "SEGMENT2", "SEGMENT3", "SEGMENT4", "SEGMENT5", "SEGMENT6", "SEGMENT7", "SEGMENT8", "SEGMENT9", "SEGMENT10", "CREATED_BY", "LINE_DESCRIPTION", "EVENT_CLASS_CODE", "XLAHEADERID", "XLALINENUM", "GLAEHEADERID", "GLAELINENUM", "POSTING_STATUS_CODE", "TERCERO", "FISCAL_CODE_TERCERO", "PKHEADERID", "PKLINENUM", "PKORIGEN", "PO_HEADER_COMMENTS", "PO_NUMBER", "IS_MODIFIED") DEFAULT COLLATION "USING_NLS_COMP"  AS 
  SELECT "TRXCONTABILIDADID","PERIOD_YEAR","PERIOD_NUMBER","GL_DATE","TRANSACTION_DATE","TRANSACTION_NUMBER","ACCOUNTED_DR","ACCOUNTED_CR","ENTERED_CURRENCY","JE_SOURCE_NAME","JE_CATEGORY_NAME","SEGMENT2","SEGMENT3","SEGMENT4","SEGMENT5","SEGMENT6","SEGMENT7","SEGMENT8","SEGMENT9","SEGMENT10","CREATED_BY","LINE_DESCRIPTION","EVENT_CLASS_CODE","XLAHEADERID","XLALINENUM","GLAEHEADERID","GLAELINENUM","POSTING_STATUS_CODE","TERCERO","FISCAL_CODE_TERCERO","PKHEADERID","PKLINENUM","PKORIGEN","PO_HEADER_COMMENTS","PO_NUMBER","IS_MODIFIED"
FROM DWADW.DW_MV_TRXCONTABILIDAD_GL_GL
UNION ALL
SELECT "TRXCONTABILIDADID","PERIOD_YEAR","PERIOD_NUMBER","GL_DATE","TRANSACTION_DATE","TRANSACTION_NUMBER","ACCOUNTED_DR","ACCOUNTED_CR","ENTERED_CURRENCY","JE_SOURCE_NAME","JE_CATEGORY_NAME","SEGMENT2","SEGMENT3","SEGMENT4","SEGMENT5","SEGMENT6","SEGMENT7","SEGMENT8","SEGMENT9","SEGMENT10","CREATED_BY","LINE_DESCRIPTION","EVENT_CLASS_CODE","XLAHEADERID","XLALINENUM","GLAEHEADERID","GLAELINENUM","POSTING_STATUS_CODE","TERCERO","FISCAL_CODE_TERCERO","PKHEADERID","PKLINENUM","PKORIGEN","PO_HEADER_COMMENTS","PO_NUMBER","IS_MODIFIED"
FROM DWADW.DW_MV_TRXCONTABILIDAD_XLA_GL;
← Volver al esquema DWADW
🏠 Volver al menú principal