Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
Esquema: DWADW
Base de datos origen: ADW COEXITO
Total de tablas: 114
Total de vistas simples: 3
Total de vistas materializadas: 7
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_ENTRADAS_SALIDAS_DMS
- DIM_FACTURACION_DMS
- DIM_FLEET_ASSIGNMENT_OTM
- DIM_FULFILLLINESTATUS_OM
- DIM_HEADER_OM
- DIM_INVORGPARAMETERS_OM
- DIM_ITEMCATEGORY_OM
- DIM_ITEMREF_OM
- DIM_ITEMS_OM
- DIM_ITEM_ATTRIBUTE_OM
- 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_ORGANIZATIONCUSTOMER_AR
- DIM_ORGANIZATIONS_ERP
- DIM_REF_NUM_OTM
- DIM_ROUTE_OTM
- DIM_SALESCREDIT_OM
- DIM_SALESREP_OM
- DIM_SEQUIPMENT_OTM
- DIM_SHIPMENTREFNUM_OTM
- DIM_SHIPMENTSTATUS_OTM
- DIM_SHIPMENT_S_EQUIPMENT_JOIN_OTM
- DIM_SHIPUNIT_OTM
- DIM_SITECUSTOMER_AR
- 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_TRANSACTIONHEADER_OM
- DIM_TYPESTRX_OM
- DIM_VIABILITY_CODE_OTM
- DIM_XCC_BUDGET_ACCOUNTS_BGC_GL
- DIM_XCC_BUDGET_DIST_HEADERS_BGC_GL
- 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_CB_BKP
- DW_TRXCONTABILIDAD_TEMP
- FACT_CASHRECEIPT_GL
- FACT_FLEX_GL
- FACT_FULFILLLINEDETAIL_OM
- FACT_FULFILLLINE_OM
- FACT_HEADEREXTRACT_OM
- 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_LINEEXTRACT_OM
- FACT_LINES_AR
- FACT_MARGINDETAILSEXTRACT_OM
- FACT_ORDERMOVEMENT_OTM
- FACT_ORDERRELEASELINES_OTM
- FACT_ORDERRELEASE_OTM
- FACT_PACKAGEDITEM_OTM
- FACT_PAYMENT_AP
- FACT_RECEIPTACCOUNTING_GL
- FACT_SALESINVOICECUSTOMERTRXLINE_OM
- FACT_SEQUIPMENTSSHIPUNITJOIN_OTM
- FACT_SHIPMENTSTOP_OTM
- FACT_SHIPMENT_OTM
- FACT_SHIP_ITEM_BOV_OTM
- FACT_SSHIPMENTUNITLINE_OTM
- FACT_TRXHEADER_AP
- FACT_TRXHEADER_PO
- FACT_XCC_BALANCES_BGC_GL
- FACT_XCC_BUDGET_DIST_ACCTS_BGC_GL
- LISTA_CUENTAS
- MLOG$_FACT_FULFILLLINE_OM
- PANTALLAGL
- ST_JOURNALELINE_GL_TEMP
Vistas simples
Vistas materializadas
- DW_MV_PPTO_BGC_GL
- DW_MV_TRXCONTABILIDAD_GL_GL
- DW_MV_TRXCONTABILIDAD_XLA_GL
- MV_FULLFILLINE_OM_BORRAR
- MV_TRACKING_OM
- MV_TRACKING_OM_TEST
- VIEW_TRX_CONTABILIDAD