cof_cte

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
cof_cte_id numeric 10 null
cof_cte_cobr_dup.cof_cte_id Implied Constraint R
cof_cte_compl_obscont.cof_cte_id Implied Constraint R
cof_cte_compl_obsfisco.cof_cte_id Implied Constraint R
cof_cte_contq.cof_cte_id Implied Constraint R
cof_cte_emitdocant.cof_cte_id Implied Constraint R
cof_cte_fluxo_pass.cof_cte_id Implied Constraint R
cof_cte_infcarga_infq.cof_cte_id Implied Constraint R
cof_cte_infctecomp.cof_cte_id Implied Constraint R
cof_cte_peri.cof_cte_id Implied Constraint R
cof_cte_rem_infnf.cof_cte_id Implied Constraint R
cof_cte_rem_infnfe.cof_cte_id Implied Constraint R
cof_cte_rem_infoutros.cof_cte_id Implied Constraint R
cof_cte_seg.cof_cte_id Implied Constraint R
cof_cte_veicnovos.cof_cte_id Implied Constraint R
cof_cte_vprest_comp.cof_cte_id Implied Constraint R
ad_client_id numeric 10 null
ad_org_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 null
createdby numeric 10 null
updated timestamp 29,6 null
updatedby numeric 10 null
ide_cct numeric 0 √ null
ide_cfop numeric 0 √ null
ide_forpag bpchar 1 √ NULL::bpchar
ide_nct numeric 10 √ NULL::numeric
ide_dhemi timestamp 29,6 √ null
ide_refcte varchar 44 √ NULL::character varying
ide_cmunenv numeric 0 √ null
ide_xmunenv varchar 60 √ NULL::character varying
ide_ufenv varchar 2 √ NULL::character varying
ide_modal varchar 2 √ NULL::character varying
ide_tpserv bpchar 1 √ NULL::bpchar
ide_xmunini varchar 60 √ NULL::character varying
ide_ufini varchar 2 √ NULL::character varying
ide_cmunfim numeric 0 √ null
ide_xmunfim varchar 60 √ NULL::character varying
ide_uffim varchar 2 √ NULL::character varying
ide_retira bpchar 1 √ NULL::bpchar
ide_xdetretira varchar 160 √ NULL::character varying
ide_toma3_toma bpchar 1 √ NULL::bpchar
ide_toma4_toma bpchar 1 √ NULL::bpchar
ide_toma4_cnpj numeric 0 √ null
ide_toma4_cpf numeric 0 √ null
ide_toma4_ie varchar 14 √ NULL::character varying
ide_toma4_xnome varchar 60 √ NULL::character varying
ide_toma4_xfant varchar 60 √ NULL::character varying
ide_toma4_endertoma_xlgr varchar 255 √ NULL::character varying
ide_toma4_endertoma_nro varchar 60 √ NULL::character varying
ide_toma4_endertoma_xcpl varchar 60 √ NULL::character varying
ide_toma4_endertoma_xbairro varchar 60 √ NULL::character varying
ide_toma4_endertoma_cmun numeric 0 √ null
ide_toma4_endertoma_xmun varchar 60 √ NULL::character varying
ide_toma4_endertoma_cep numeric 0 √ null
ide_toma4_endertoma_uf varchar 2 √ NULL::character varying
ide_toma4_endertoma_cpais numeric 0 √ null
ide_toma4_endertoma_xpais varchar 60 √ NULL::character varying
ide_toma4_endertoma_email varchar 60 √ NULL::character varying
ide_toma4_endertoma_dhcont varchar 19 √ NULL::character varying
ide_toma4_email varchar 60 √ NULL::character varying
ide_toma4_bpartner_id numeric 10 √ NULL::numeric
ide_toma4_bpartner_location_id numeric 10 √ NULL::numeric
ide_toma4_region_id numeric 10 √ NULL::numeric
ide_toma4_city_id numeric 10 √ NULL::numeric
compl_xcaracad varchar 15 √ NULL::character varying
compl_xcaracser varchar 30 √ NULL::character varying
compl_xemi varchar 20 √ NULL::character varying
compl_fluxo_xorig varchar 15 √ NULL::character varying
compl_fluxo_xdest varchar 15 √ NULL::character varying
compl_fluxo_xrota varchar 10 √ NULL::character varying
compl_entrega_semdata_tpper bpchar 1 √ NULL::bpchar
compl_entrega_comdata_dprog timestamp 29,6 √ null
compl_entrega_noperiodo_dini timestamp 29,6 √ null
compl_entrega_noperiodo_dfim timestamp 29,6 √ null
compl_entrega_semhora_tphor bpchar 1 √ NULL::bpchar
compl_entrega_comhora_tphor bpchar 1 √ NULL::bpchar
compl_entrega_comhora_hprog timestamp 29,6 √ null
compl_entrega_nointer_tphor bpchar 1 √ NULL::bpchar
compl_entrega_nointer_hini timestamp 29,6 √ null
compl_entrega_nointer_hfim timestamp 29,6 √ null
compl_origcalc varchar 40 √ NULL::character varying
compl_destcalc varchar 40 √ NULL::character varying
rem_cnpj varchar 18 √ NULL::character varying
rem_cpf varchar 14 √ NULL::character varying
rem_ie varchar 14 √ NULL::character varying
rem_xnome varchar 60 √ NULL::character varying
rem_xfant varchar 60 √ NULL::character varying
rem_enderreme_xlgr varchar 255 √ NULL::character varying
rem_enderreme_nro varchar 60 √ NULL::character varying
rem_enderreme_xcpl varchar 60 √ NULL::character varying
rem_enderreme_xbairro varchar 60 √ NULL::character varying
rem_enderreme_cmun numeric 0 √ null
rem_enderreme_xmun varchar 60 √ NULL::character varying
rem_enderreme_cep varchar 9 √ null
rem_enderreme_uf varchar 2 √ NULL::character varying
rem_enderreme_cpais numeric 0 √ null
rem_enderreme_xpais varchar 60 √ NULL::character varying
rem_email varchar 60 √ NULL::character varying
rem_bpartner_id numeric 10 √ NULL::numeric
rem_bpartner_location_id numeric 10 √ NULL::numeric
rem_city_id numeric 10 √ NULL::numeric
rem_regiao_id numeric 10 √ NULL::numeric
exped_bpartner_id numeric 10 √ NULL::numeric
exped_bpartner_location_id numeric 10 √ NULL::numeric
exped_cpf varchar 14 √ NULL::character varying
exped_email varchar 60 √ NULL::character varying
exped_enderexped_cep varchar 9 √ NULL::character varying
exped_enderexped_cmun numeric 0 √ null
exped_enderexped_cpais numeric 0 √ null
exped_enderexped_nro varchar 60 √ NULL::character varying
exped_enderexped_uf varchar 2 √ NULL::character varying
exped_enderexped_xbairro varchar 60 √ NULL::character varying
exped_enderexped_xcpl varchar 60 √ NULL::character varying
exped_enderexped_xlgr varchar 255 √ NULL::character varying
exped_enderexped_xmun varchar 60 √ NULL::character varying
exped_enderexped_xpais varchar 60 √ NULL::character varying
exped_ie varchar 14 √ NULL::character varying
exped_regiao_id numeric 10 √ NULL::numeric
exped_xnome varchar 60 √ NULL::character varying
exped_fone varchar 12 √ NULL::character varying
exped_city_id numeric 10 √ NULL::numeric
receb_xnome varchar 60 √ NULL::character varying
receb_regiao_id numeric 10 √ NULL::numeric
receb_ie varchar 14 √ NULL::character varying
receb_fone varchar 12 √ NULL::character varying
receb_enderreceb_xpais varchar 60 √ NULL::character varying
receb_enderreceb_xmun varchar 60 √ NULL::character varying
receb_enderreceb_xlgr varchar 255 √ NULL::character varying
receb_enderreceb_xcpl varchar 60 √ NULL::character varying
receb_enderreceb_xbairro varchar 60 √ NULL::character varying
receb_enderreceb_uf varchar 2 √ NULL::character varying
receb_enderreceb_nro varchar 60 √ NULL::character varying
receb_enderreceb_cpais numeric 0 √ null
receb_enderreceb_cmun numeric 0 √ null
receb_enderreceb_cep varchar 9 √ NULL::character varying
receb_email varchar 60 √ NULL::character varying
receb_cpf varchar 14 √ NULL::character varying
receb_cnpj varchar 18 √ NULL::character varying
receb_city_id numeric 10 √ NULL::numeric
receb_bpartner_location_id numeric 10 √ NULL::numeric
receb_bpartner_id numeric 10 √ NULL::numeric
dest_fone varchar 12 √ NULL::character varying
locent_cnpj varchar 18 √ NULL::character varying
locent_cpf varchar 14 √ NULL::character varying
locent_xnome varchar 60 √ NULL::character varying
locent_xlgr varchar 60 √ NULL::character varying
locent_nro varchar 60 √ NULL::character varying
locent_xcpl varchar 60 √ NULL::character varying
locent_xbairro varchar 60 √ NULL::character varying
locent_cmun numeric 0 √ null
locent_xmun varchar 60 √ NULL::character varying
locent_uf varchar 2 √ NULL::character varying
imp_icms_icms00_cst varchar 2 √ '10'::character varying
imp_icms_icms00_vbc numeric 0 √ (0)::numeric
imp_icms_icms00_picms numeric 0 √ (0)::numeric
imp_icms_icms00_vicms numeric 0 √ (0)::numeric
imp_icms_icms20_cst varchar 2 √ '20'::character varying
imp_icms_icms20_predbc numeric 0 √ (0)::numeric
imp_icms_icms20_vbc numeric 0 √ (0)::numeric
imp_icms_icms20_picms numeric 0 √ (0)::numeric
imp_icms_icms20_vicms numeric 0 √ (0)::numeric
imp_icms_icms45_cst varchar 2 √ '40'::character varying
imp_icms_icms60_cst varchar 2 √ '60'::character varying
imp_icms_icms60_vbcstret numeric 0 √ (0)::numeric
imp_icms_icms60_vicmsstret numeric 0 √ (0)::numeric
imp_icms_icms60_picmsstret numeric 0 √ (0)::numeric
imp_icms_icms60_vcred numeric 0 √ (0)::numeric
imp_icms_icms90_cst varchar 2 √ '90'::character varying
imp_icms_icms90_predbc numeric 0 √ (0)::numeric
ide_cuf numeric 0 √ null
ide_natop varchar 60 √ NULL::character varying
ide_mod numeric 0 √ null
ide_tpimp bpchar 1 √ NULL::bpchar
ide_tpemis bpchar 1 √ NULL::bpchar
ide_cdv numeric 0 √ null
ide_tpamb bpchar 1 √ NULL::bpchar
ide_procemi bpchar 1 √ NULL::bpchar
ide_verproc varchar 20 √ NULL::character varying
compl_xobs varchar 2000 √ NULL::character varying
emit_bpartner_id numeric 10 √ NULL::numeric
emit_bpartner_location_id numeric 10 √ NULL::numeric
emit_city_id numeric 10 √ NULL::numeric
emit_cnpj varchar 18 √ NULL::character varying
emit_ie varchar 14 √ NULL::character varying
emit_xnome varchar 60 √ NULL::character varying
emit_xfant varchar 60 √ NULL::character varying
emit_country_id numeric 10 √ (139)::numeric
emit_enderemit_xlgr varchar 60 √ NULL::character varying
emit_enderemit_nro varchar 60 √ NULL::character varying
emit_enderemit_xcpl varchar 60 √ NULL::character varying
emit_enderemit_xbairro varchar 60 √ NULL::character varying
emit_enderemit_cmun numeric 0 √ null
emit_enderemit_xmun varchar 60 √ NULL::character varying
emit_enderemit_cep varchar 9 √ NULL::character varying
emit_enderemit_uf varchar 2 √ NULL::character varying
emit_enderemit_fone varchar 14 √ NULL::character varying
rem_country_id numeric 10 √ (139)::numeric
exped_country_id numeric 10 √ (139)::numeric
receb_country_id numeric 10 √ (139)::numeric
dest_cnpj varchar 18 √ NULL::character varying
dest_cpf varchar 14 √ NULL::character varying
dest_ie varchar 14 √ NULL::character varying
dest_xnome varchar 60 √ NULL::character varying
dest_isuf varchar 9 √ NULL::character varying
dest_enderdest_xlgr varchar 255 √ NULL::character varying
dest_enderdest_nro varchar 60 √ NULL::character varying
dest_enderdest_xcpl varchar 60 √ NULL::character varying
dest_enderdest_xbairro varchar 60 √ NULL::character varying
dest_enderdest_cmun numeric 0 √ null
dest_enderdest_xmun varchar 60 √ NULL::character varying
dest_enderdest_cep varchar 9 √ NULL::character varying
dest_enderdest_uf varchar 2 √ NULL::character varying
dest_enderdest_cpais numeric 0 √ null
dest_enderdest_xpais varchar 60 √ NULL::character varying
dest_email varchar 60 √ NULL::character varying
dest_bpartner_id numeric 10 √ NULL::numeric
dest_bpartner_location_id numeric 10 √ NULL::numeric
dest_city_id numeric 10 √ NULL::numeric
dest_country_id numeric 10 √ (139)::numeric
dest_region_id numeric 10 √ NULL::numeric
vprest_vtprest numeric 0 √ (0)::numeric
vprest_vrec numeric 0 √ (0)::numeric
imp_icms_icms90_vbc numeric 0 √ (0)::numeric
imp_icms_icms90_picms numeric 0 √ (0)::numeric
imp_icms_icms90_vicms numeric 0 √ (0)::numeric
imp_icms_icms90_vcred numeric 0 √ (0)::numeric
imp_icms_icmsoutrauf_cst varchar 2 √ '90'::character varying
imp_icms_icmsoutrauf_predbc numeric 0 √ (0)::numeric
imp_icms_icmsoutrauf_vbc numeric 0 √ (0)::numeric
imp_icms_icmsoutrauf_picms numeric 0 √ (0)::numeric
imp_icms_icmsoutrauf_vicms numeric 0 √ (0)::numeric
imp_icms_icmssn_indsn bpchar 1 √ 'N'::bpchar
imp_infadfisco varchar 2000 √ NULL::character varying
infctenorm_infcarga_vcarga numeric 0 √ (0)::numeric
infctenorm_infcarga_propred varchar 60 √ NULL::character varying
infctenorm_infcarga_xoutcat varchar 30 √ NULL::character varying
infctenorm_versaomodal numeric 0 √ null
infctenorm_cobr_fat_nfat varchar 60 √ NULL::character varying
infctenorm_cobr_fat_vorig numeric 0 √ (0)::numeric
infctenorm_cobr_fat_vdesc numeric 0 √ (0)::numeric
infctenorm_cobr_fat_vliq numeric 0 √ (0)::numeric
infctesub_chcte numeric 0 √ null
infctesub_tomaicms_refnfe numeric 0 √ null
infctesub_tomaicms_refnf_cnpj varchar 18 √ NULL::character varying
infctesub_tomaicms_refnf_mod varchar 2 √ NULL::character varying
infctesub_tomaicms_refnf_serie numeric 0 √ null
infctesub_tomaicms_refnf_subse numeric 0 √ null
infctesub_tomaicms_refnf_nro numeric 0 √ null
infctesub_tomaicms_refnf_valor numeric 0 √ (0)::numeric
infctesub_tomaicms_refnf_demi timestamp 29,6 √ null
infctesub_tomaicms_refnf_refct numeric 0 √ null
infctesub_tomanaoicms_refctean numeric 0 √ null
infcteanu_chcte numeric 0 √ null
infcteanu_demi timestamp 29,6 √ null
cof_cte_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
cof_cte_key Primary key Asc cof_cte_id
cof_cte_uu_idx Must be unique Asc cof_cte_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation