cof_controleciap

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
a_asset_id numeric 10 null
a_asset.a_asset_id aasset_cofcontroleciap R
ad_client_id numeric 10 null
ad_client.ad_client_id adclient_cofcontroleciap R
ad_org_id numeric 10 null
ad_org.ad_org_id adorg_cofcontroleciap R
c_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id cbpartner_cofcontroleciap R
cof_ativopai_id numeric 10 √ NULL::numeric
a_asset.a_asset_id cofativopai_cofcontroleciap R
cof_classificacaocusto bpchar 1 √ NULL::bpchar
cof_controleciap_id numeric 10 null
cof_calculociaplinha.cof_controleciap_id cofcontroleciap_cofcalculociaplinha R
cof_controleciap_entrada.cof_controleciap_id cofcontroleciap_cofcontroleciapentrada C
cof_controleciap_entrada.cof_controleciap_imobilizacao_id cofcontroleciapimobilizacao_cofcontroleciapentrada R
cof_controleciap_saida.cof_controleciap_id cofcontroleciap_cofcontroleciapsaida C
cof_controleciapoutroscred.cof_controleciap_id cofcontroleciap_cofcontroleciapoutroscred C
cof_controleciap_uu varchar 36 √ NULL::character varying
cof_dataencerramento timestamp 29,6 √ null
cof_icmsaapropriar numeric 0 √ 0
cof_permiteapropriacao bpchar 1 'Y'::bpchar
cof_proximaparcela numeric 10 1
cof_quantidadeparcelas numeric 10 √ NULL::numeric
cof_saldoapropriar numeric 0 √ 0
cof_saldoicmsapropriado numeric 0 √ 0
cof_tipomercadoria bpchar 1 '1'::bpchar
cof_tipomovimento varchar 2 'IM'::character varying
cof_tipomovimentobaixa varchar 2 √ null
cof_vicmsfretecte numeric 0 √ '0'::numeric
cof_valorparcela numeric 0 √ 0
created timestamp 29,6 null
createdby numeric 10 null
ad_user.ad_user_id createdby_cofcontroleciap R
c_uom_id numeric 10 √ NULL::numeric
c_uom.c_uom_id cuom_cofcontroleciap R
det_nitem numeric 10 √ NULL::numeric
ide_nnf numeric 10 √ NULL::numeric
imposto_icms_vicms numeric 0 √ '0'::numeric
imposto_icmsufdest_vicmsufdest numeric 0 √ '0'::numeric
imposto_icms_vicmsst numeric 0 √ '0'::numeric
infnfe_id varchar 44 √ null
isactive bpchar 1 'Y'::bpchar
lbr_docfiscal_id numeric 10 √ null
lbr_docfiscal.lbr_docfiscal_id lbrdocfiscal_cofcontroleciap C
movementdate timestamp 29,6 null
m_product_id numeric 10 √ NULL::numeric
m_product.m_product_id mproduct_cofcontroleciap R
qty numeric 0 √ null
updated timestamp 29,6 null
updatedby numeric 10 null
ad_user.ad_user_id updatedby_cofcontroleciap R
value varchar 40 √ NULL::character varying
lbr_docfiscal_line_id numeric 10 √ null
lbr_docfiscal_line.lbr_docfiscal_line_id lbrdocfiscalline_cofcontroleciap R
user1_id numeric 10 √ null
c_elementvalue.c_elementvalue_id user1_cofcontroleciap R

Indexes

Constraint Name Type Sort Column(s)
cof_controleciap_key Primary key Asc cof_controleciap_id
a_asset_id_idx Must be unique Asc a_asset_id
cof_controleciap_uu_idx Must be unique Asc cof_controleciap_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation