dim_bancos_financieros

133 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id varchar 10 null
dim_cuentas_bancarias.banco_id Implied Constraint R
dim_cuentas_bancarias.sucbo_id Implied Constraint R
fact_asientos_contables.aficom_id Implied Constraint R
fact_asientos_contables.letra_id Implied Constraint R
fact_compras.aficom_id Implied Constraint R
fact_compras.letra_id Implied Constraint R
fact_compras_hacienda.aficom_id Implied Constraint R
fact_compras_hacienda.letra_id Implied Constraint R
fact_devoluciones_de_cliente.aficom_id Implied Constraint R
fact_devoluciones_de_cliente.letra_id Implied Constraint R
fact_estimado_de_compras.aficom_id Implied Constraint R
fact_estimado_de_compras.letra_id Implied Constraint R
fact_estimado_de_producciones.aficom_id Implied Constraint R
fact_estimado_de_producciones.letra_id Implied Constraint R
fact_estimado_de_ventas.aficom_id Implied Constraint R
fact_estimado_de_ventas.letra_id Implied Constraint R
fact_movimientos_de_stock.aficom_id Implied Constraint R
fact_movimientos_de_stock.letra_id Implied Constraint R
fact_ordenes_de_compra.aficom_id Implied Constraint R
fact_ordenes_de_compra.letra_id Implied Constraint R
fact_partes_de_produccion.aficom_id Implied Constraint R
fact_partes_de_produccion.letra_id Implied Constraint R
fact_pedidos.aficom_id Implied Constraint R
fact_pedidos.letra_id Implied Constraint R
fact_pendientes_de_cobranza.codloca_id Implied Constraint R
fact_pendientes_de_cobranza.codpais_id Implied Constraint R
fact_pendientes_de_cobranza.codprov_id Implied Constraint R
fact_pendientes_de_pago.codloca_id Implied Constraint R
fact_pendientes_de_pago.codpais_id Implied Constraint R
fact_pendientes_de_pago.codprov_id Implied Constraint R
fact_pendientes_financiero.codloca_id Implied Constraint R
fact_pendientes_financiero.codpais_id Implied Constraint R
fact_pendientes_financiero.codprov_id Implied Constraint R
fact_rdi.aficom_id Implied Constraint R
fact_rdi.letra_id Implied Constraint R
fact_rdi_provisorios.aficom_id Implied Constraint R
fact_rdi_provisorios.letra_id Implied Constraint R
fact_recepciones.aficom_id Implied Constraint R
fact_recepciones.letra_id Implied Constraint R
fact_remitos.aficom_id Implied Constraint R
fact_remitos.letra_id Implied Constraint R
fact_remitos_hacienda.aficom_id Implied Constraint R
fact_remitos_hacienda.letra_id Implied Constraint R
fact_requerimientos.aficom_id Implied Constraint R
fact_requerimientos.letra_id Implied Constraint R
fact_ventas.aficom_id Implied Constraint R
fact_ventas.letra_id Implied Constraint R
fact_ventas_hacienda.aficom_id Implied Constraint R
fact_ventas_hacienda.letra_id Implied Constraint R

id del registro

nombre varchar 99 null

descripcion del banco

idmodif numeric 0 null

identificador de la modificacion

Indexes

Constraint Name Type Sort Column(s)
dim_bancos_financieros_pkey Primary key Asc id
dim_bancos_financieros_idx_idmodif Performance Asc/Asc idmodif + id

Relationships