cof_controleabastecimento

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10 null
ad_client.ad_client_id adclient_cofcontroleabastecime R
ad_org_id numeric 10 null
ad_org.ad_org_id adorg_cofcontroleabastecimento R
cof_controleabastecimento_id numeric 10 null
cof_controleabastecimento_uu varchar 36 √ NULL::character varying
created timestamp 29,6 null
createdby numeric 10 null
ad_user.ad_user_id createdby_cofcontroleabastecim R
isactive bpchar 1 'Y'::bpchar
updated timestamp 29,6 null
updatedby numeric 10 null
ad_user.ad_user_id updatedby_cofcontroleabastecim R
value varchar 40 NULL::character varying
c_bpartner_id numeric 10 √ NULL::numeric
c_bpartner.c_bpartner_id cbpartner_cofcontroleabastecim R
c_invoice_id numeric 10 √ NULL::numeric
c_invoice.c_invoice_id cinvoice_cofcontroleabastecime R
cof_dataabastecimento timestamp 29,6 null
cof_equipments_id numeric 10 √ NULL::numeric
cof_equipments.cof_equipments_id cofequipments_cofcontroleabast R
cof_placa varchar 10 null
cof_quilometragem numeric 10 √ NULL::numeric
cof_driver_id numeric 10 √ NULL::numeric
cof_driver.cof_driver_id cofdriver_cofcontroleabastecim R
cof_qtdabastecimento numeric 0 √ null
cof_precounitario numeric 0 √ null
cof_valortotal numeric 0 null
cof_combustivel_id numeric 10 NULL::numeric
cof_combustivel.cof_combustivel_id cofcombustivel_cofcontroleabas R
cof_tipoabastecimento bpchar 1 √ NULL::bpchar
m_inventory_id numeric 10 √ NULL::numeric
m_inventory.m_inventory_id minventory_cofcontroleabastecimento R
cof_consumokm numeric 0 √ null
cof_customedioporkm numeric 0 √ null

Indexes

Constraint Name Type Sort Column(s)
cof_controleabastecimento_key Primary key Asc cof_controleabastecimento_id
cof_controleabastecimento_c_invoice_id_idx Performance Asc c_invoice_id
cof_controleabastecimentouuidx Must be unique Asc cof_controleabastecimento_uu

Check Constraints

Constraint Name Constraint
cof_controleabastecimento_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation