fc_items_

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
fcItem_id INT 10 √ null
fcItem_factura_id INT 10 null
fcItem_caso_id INT 10 null
fcItem_clientePagador_id INT 10 null
fcItem_usuario_id INT 10 null
fcItem_estado_id INT 10 null
fcItem_accruedLote_id INT 10 √ null
fcItem_ordenPago_id INT 10 √ null
fcItem_fechaIngresoSistema DATETIME 19 CURRENT_TIMESTAMP
fcItem_monedaOrigen_id INT 10 null
fcItem_importeMedicoOrigen DECIMAL 11,2 null
fcItem_importeFeeOrigen DECIMAL 11,2 √ null
fcItem_descuento DECIMAL 11,2 null
fcItem_tipoCambio DECIMAL 6,2 null
fcItem_importeUSD DECIMAL 11,2 null
fcItem_importeAprobadoUSD DECIMAL 11,2 √ null
fcItem_importeAprobadoOrigen DECIMAL 11,2 √ null
fcItem_observaciones TINYTEXT 255 √ null
fcItem_clientePagadorNuevo_id INT 10 √ null
fcItem_facturaNuevo_id INT 10 √ null
prueba INT 10 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc fcItem_id
fcItem_caso_id Performance Asc fcItem_caso_id
fcItem_factura_id Performance Asc fcItem_factura_id

Diagram producer might be missing

No diagrams were produced please see application output for any errors