Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
Esquema: DWADW
Base de datos origen: ADW COEXITO
Total de tablas: 86
Total de vistas simples: 3
Total de vistas materializadas: 6
Tablas
- DIM_BULKPLAN_OTM
- DIM_CEDI_OTM
- DIM_CODECOMBINATION_GL
- DIM_COMMODITY_OTM
- DIM_CONTACT_OTM
- DIM_CUSTOMERACCOUNT_AR
- DIM_CUSTOMER_AR
- DIM_DRIVER_OTM
- DIM_FLEET_ASSIGNMENT_OTM
- DIM_ITEMS_PIM
- DIM_ITEM_OTM
- DIM_ITINERARY_OTM
- DIM_JOURNALSOURCE_GL
- DIM_LACSCUSTOMER_AR
- DIM_LICENSETYPE_OTM
- DIM_LOADINGPATTERN_OTM
- DIM_LOCATION_ADDRESS_OTM
- DIM_LOCATION_OTM
- DIM_ORDERRELEASESTATUS_OTM
- DIM_ORDERRELEASETYPE_OTM
- DIM_ORDERRELEASE_REFNUM_OTM
- DIM_ORGANIZATIONS_ERP
- DIM_REF_NUM_OTM
- DIM_ROUTE_OTM
- DIM_SEQUIPMENT_OTM
- DIM_SHIPMENTREFNUM_OTM
- DIM_SHIPMENTSTATUS_OTM
- DIM_SHIPMENT_S_EQUIPMENT_JOIN_OTM
- DIM_SHIPUNIT_OTM
- DIM_SITEUSECUSTOMER_AR
- DIM_STATUSTYPE_OR_OTM
- DIM_STATUSTYPE_SHIP_OTM
- DIM_STATUSVALUE_OR_OTM
- DIM_STATUSVALUE_SHIP_OTM
- DIM_STOPTYPE_OTM
- DIM_SUPPLIER_AP
- DIM_TIME_OTM
- DIM_VIABILITY_CODE_OTM
- DW_AP_TRXHEADER
- DW_ARLINES
- DW_CASHRECEIPT
- DW_CLIENTES
- DW_CUENTAS_CLIENTES
- DW_FLEX_GL
- DW_GLCCOMBINATION
- DW_ITEMS
- DW_JOURNALELINE_TEMP
- DW_JOURNALENTRYDIST
- DW_JOURNALLINEGL_TEMP
- DW_JOURNALSOURCE
- DW_LACS_CLIENTES
- DW_ORGANIZATIONS
- DW_PAYTMENT
- DW_PO_TRXHEADER
- DW_RECEIPTACCOINTING
- DW_SUPPLIER
- DW_TRXCONTABILIDAD
- DW_TRXCONTABILIDAD_17072025
- DW_TRXCONTABILIDAD_BACKUP
- DW_TRXCONTABILIDAD_CB
- DW_TRXCONTABILIDAD_TEMP
- FACT_CASHRECEIPT_GL
- FACT_FLEX_GL
- FACT_JOURNALELINE_GL
- FACT_JOURNALELINE_GL_20260610_COPIA
- FACT_JOURNALENTRYDISTRI_GL
- FACT_JOURNALENTRYDIST_GL5
- FACT_JOURNALENTRYDIST_GLBORRRA
- FACT_JOURNALENTRYDIST_GL_20260610_COPIA
- FACT_JOURNALLINEGL_GL
- FACT_JOURNALLINEGL_GL_20260610_COPIA
- FACT_LINES_AR
- FACT_ORDERMOVEMENT_OTM
- FACT_ORDERRELEASELINES_OTM
- FACT_ORDERRELEASE_OTM
- FACT_PACKAGEDITEM_OTM
- FACT_PAYMENT_AP
- FACT_RECEIPTACCOUNTING_GL
- FACT_SEQUIPMENTSSHIPUNITJOIN_OTM
- FACT_SHIPMENTSTOP_OTM
- FACT_SHIPMENT_OTM
- FACT_SHIP_ITEM_BOV_OTM
- FACT_SSHIPMENTUNITLINE_OTM
- FACT_TRXHEADER_AP
- FACT_TRXHEADER_PO
- PANTALLAGL
Vistas simples
Vistas materializadas
- DW_MV_TRXCONTABILIDAD_GL
- DW_MV_TRXCONTABILIDAD_GL2
- DW_MV_TRXCONTABILIDAD_GL5
- DW_MV_TRXCONTABILIDAD_GL6
- DW_MV_TRXCONTABILIDAD_GL7
- VIEW_TRX_CONTABILIDAD