cte_cte

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
cte_cte_id numeric 10 null
cof_c_taxdetermination_line.cte_cte_id ctecte_cofctaxdeterminationline C
cof_cte_emitdocant.cte_cte_id ctecte_cofcteemitdocant C
cof_packinglist.cte_cte_id ctecte_cofpackinglist C
cof_packinglist_line.cte_cte_id ctecte_cofpackinglistline C
cte_autxml.cte_cte_id ctecte_cteautxml C
cte_cobr_dup.cte_cte_id ctecte_ctecobrdup C
cte_eventocte.cte_cte_id ctecte_cteeventocte R
cte_infcarga_infq.cte_cte_id ctecte_cteinfcargainfq C
cte_infctecomp.cte_cte_id ctecte_cteinfctecomp C
cte_infdoc_infnf.cte_cte_id ctecte_cteinfdocinfnf C
cte_infdoc_infnfe.cte_cte_id ctecte_cteinfdocinfnfe C
cte_infdoc_infoutros.cte_cte_id ctecte_cteinfdocinfoutros C
cte_rodo_occ.cte_cte_id ctecte_cterodoocc C
cte_vprest_comp.cte_cte_id ctecte_ctevprestcomp C
cte_cte_uu varchar 36 √ NULL::character varying
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
cte_versao varchar 55 √ NULL::character varying
cte_identificador varchar 47 √ null
cte_ide_cuf varchar 2 √ NULL::character varying
cte_ide_cct varchar 8 √ null
cte_ide_mod varchar 2 √ null
cte_ide_natop varchar 60 √ NULL::character varying
cte_ide_serie varchar 3 √ null
cte_ide_nct varchar 9 √ null
cte_ide_dhemi timestamp 29,6 √ null
cte_ide_tpimp bpchar 1 √ null
cte_ide_tpemis bpchar 1 √ null
cte_ide_cdv varchar 1 √ null
cte_ide_tpamb bpchar 1 √ null
cte_ide_tpcte bpchar 1 √ null
cte_ide_procemi bpchar 1 √ null
cte_ide_verproc varchar 20 √ NULL::character varying
cte_ide_cmunenv varchar 7 √ null
cte_ide_xmunenv varchar 60 √ NULL::character varying
cte_ide_ufenv varchar 2 √ NULL::character varying
cte_ide_modal varchar 2 √ null
cte_ide_tpserv bpchar 1 √ null
cte_ide_cmunini varchar 7 √ null
cte_ide_xmunini varchar 60 √ NULL::character varying
cte_ide_ufini varchar 2 √ NULL::character varying
cte_ide_cmunfim varchar 7 √ null
cte_ide_xmunfim varchar 60 √ NULL::character varying
cte_ide_uffim varchar 2 √ NULL::character varying
cte_ide_retira bpchar 1 √ 'N'::bpchar
cte_ide_xdetretira varchar 160 √ NULL::character varying
cte_ide_indietoma bpchar 1 √ NULL::bpchar
cte_toma bpchar 1 √ null
cte_toma_cnpj varchar 14 √ null
cte_toma_cpf varchar 11 √ null
cte_toma_ie varchar 14 √ NULL::character varying
cte_toma_xnome varchar 60 √ NULL::character varying
cte_toma_xfant varchar 60 √ NULL::character varying
cte_toma_fone varchar 14 √ null
cte_endertoma_xlgr varchar 255 √ NULL::character varying
cte_endertoma_nro varchar 60 √ NULL::character varying
cte_endertoma_xcpl varchar 60 √ NULL::character varying
cte_endertoma_xbairro varchar 60 √ NULL::character varying
cte_endertoma_cmun varchar 7 √ null
cte_endertoma_xmun varchar 60 √ NULL::character varying
cte_endertoma_cep varchar 8 √ null
cte_endertoma_uf varchar 2 √ NULL::character varying
cte_endertoma_cpais varchar 4 √ null
cte_endertoma_xpais varchar 60 √ NULL::character varying
cte_toma_email varchar 60 √ NULL::character varying
cte_ide_dhcont timestamp 29,6 √ null
cte_ide_xjust varchar 256 √ NULL::character varying
cte_compl_xcaracad varchar 15 √ NULL::character varying
cte_compl_xcaracser varchar 30 √ NULL::character varying
cte_ide_indglobalizado varchar 1 √ null
cte_compl_xemi varchar 20 √ NULL::character varying
cte_ide_cfop varchar 4 √ null
cte_entrega_tpper bpchar 1 √ NULL::bpchar
cte_entrega_dprog timestamp 29,6 √ null
cte_entrega_dini timestamp 29,6 √ null
cte_entrega_dfim timestamp 29,6 √ null
cte_entrega_tphor bpchar 1 √ NULL::bpchar
cte_entrega_hprog timestamp 29,6 √ null
cte_entrega_hini timestamp 29,6 √ null
cte_compl_origcalc varchar 40 √ NULL::character varying
cte_compl_destcalc varchar 40 √ NULL::character varying
cte_compl_xobs varchar 2000 √ null
cte_emit_cnpj varchar 14 √ null
cte_emit_ie varchar 14 √ null
cte_emit_iest varchar 14 √ null
cte_emit_xnome varchar 60 √ NULL::character varying
cte_emit_xfant varchar 60 √ NULL::character varying
cte_enderemit_xlgr varchar 60 √ NULL::character varying
cte_enderemit_nro varchar 60 √ NULL::character varying
cte_enderemit_xcpl varchar 60 √ NULL::character varying
cte_enderemit_xbairro varchar 60 √ NULL::character varying
cte_enderemit_cmun varchar 7 √ null
cte_enderemit_xmun varchar 60 √ NULL::character varying
cte_enderemi_cep varchar 8 √ null
cte_enderemit_uf varchar 2 √ NULL::character varying
cte_enderemit_fone varchar 14 √ null
cte_rem_cnpj varchar 14 √ null
cte_rem_cpf varchar 11 √ null
cte_rem_ie varchar 14 √ NULL::character varying
cte_rem_xnome varchar 60 √ NULL::character varying
cte_rem_xfant varchar 60 √ NULL::character varying
cte_rem_fone varchar 14 √ null
cte_enderreme_xlgr varchar 255 √ NULL::character varying
cte_enderreme_nro varchar 60 √ NULL::character varying
cte_enderreme_xcpl varchar 60 √ NULL::character varying
cte_enderreme_xbairro varchar 60 √ NULL::character varying
cte_enderreme_cmun varchar 7 √ null
cte_enderreme_xmun varchar 60 √ NULL::character varying
cte_enderreme_cep varchar 8 √ null
cte_enderreme_uf varchar 2 √ NULL::character varying
cte_enderreme_cpais varchar 4 √ null
cte_enderreme_xpais varchar 60 √ NULL::character varying
cte_rem_email varchar 60 √ NULL::character varying
cte_exped_cnpj varchar 14 √ null
cte_exped_cpf varchar 11 √ null
cte_exped_ie varchar 60 √ NULL::character varying
cte_exped_xnome varchar 60 √ NULL::character varying
cte_exped_fone varchar 14 √ null
cte_enderexped_xlgr varchar 255 √ NULL::character varying
cte_enderexped_nro varchar 60 √ NULL::character varying
cte_enderexped_xcpl varchar 60 √ NULL::character varying
cte_enderexped_xbairro varchar 60 √ NULL::character varying
cte_enderexped_cmun varchar 7 √ null
cte_enderexped_xmun varchar 60 √ NULL::character varying
cte_enderexped_cep varchar 8 √ null
cte_enderexped_uf varchar 2 √ NULL::character varying
cte_enderexped_cpais varchar 4 √ null
cte_enderexped_xpais varchar 60 √ NULL::character varying
cte_exped_email varchar 60 √ NULL::character varying
cte_receb_cnpj varchar 14 √ null
cte_receb_cpf varchar 11 √ null
cte_receb_ie varchar 14 √ NULL::character varying
cte_receb_xnome varchar 60 √ NULL::character varying
cte_receb_fone varchar 14 √ null
cte_enderreceb_xlgr varchar 255 √ NULL::character varying
cte_enderreceb_nro varchar 60 √ NULL::character varying
cte_enderreceb_xcpl varchar 60 √ NULL::character varying
cte_enderreceb_xbairro varchar 60 √ NULL::character varying
cte_enderreceb_cmun varchar 7 √ null
cte_enderreceb_xmun varchar 60 √ NULL::character varying
cte_enderreceb_cep varchar 8 √ null
cte_enderreceb_uf varchar 2 √ NULL::character varying
cte_enderreceb_cpais varchar 4 √ null
cte_enderreceb_xpais varchar 60 √ NULL::character varying
cte_receb_email varchar 60 √ NULL::character varying
cte_dest_cnpj varchar 14 √ null
cte_dest_cpf varchar 11 √ null
cte_dest_ie varchar 14 √ NULL::character varying
cte_dest_xnome varchar 60 √ NULL::character varying
cte_dest_fone varchar 14 √ null
cte_dest_isuf varchar 9 √ null
cte_enderdest_xlgr varchar 255 √ NULL::character varying
cte_enderdest_nro varchar 60 √ NULL::character varying
cte_enderdest_xcpl varchar 60 √ NULL::character varying
cte_enderdest_xbairro varchar 60 √ NULL::character varying
cte_enderdest_cmun varchar 7 √ null
cte_enderdest_xmun varchar 60 √ NULL::character varying
cte_enderdest_cep varchar 8 √ null
cte_enderdest_uf varchar 2 √ NULL::character varying
cte_enderdest_cpais varchar 4 √ null
cte_enderdest_xpais varchar 60 √ NULL::character varying
cte_dest_email varchar 60 √ NULL::character varying
cte_vprest_vtprest numeric 0 √ null
cte_vprest_vrec numeric 0 √ null
cte_icms_predbcoutrauf numeric 0 √ null
cte_icms_vbcoutrauf numeric 0 √ null
cte_icms_picmsoutrauf numeric 0 √ null
cte_icms_vicmsoutrauf numeric 0 √ '0'::numeric
cte_icms_icmssn_indsn bpchar 1 √ 'N'::bpchar
cte_icms_infadfisico varchar 2000 √ NULL::character varying
cte_icms_vbcuffim numeric 0 √ '0'::numeric
cte_icms_pfcpuffim numeric 0 √ null
cte_icms_picmsinter numeric 0 √ null
cte_icms_vfcpuffim numeric 0 √ null
cte_icms_vicmsuffim numeric 0 √ null
cte_icms_vicmsufini numeric 0 √ null
cte_infcarga_vcarga numeric 0 √ null
cte_infcarga_propred varchar 60 √ NULL::character varying
cte_infcarga_xoutcat varchar 30 √ NULL::character varying
cte_infmodal_versaomodal varchar 4 √ null
cte_fat_nfat varchar 60 √ NULL::character varying
cte_fat_vorig numeric 0 √ null
cte_fat_vdesc numeric 0 √ null
cte_fat_vliq numeric 0 √ null
cte_infctesub_chcte varchar 44 √ null
cte_infctesub_refcteanu varchar 44 √ null
cte_tomaicms_refnfe varchar 44 √ null
cte_refnf_cnpj varchar 14 √ null
cte_refnf_cpf varchar 11 √ null
cte_refnf_mod varchar 2 √ null
cte_refnf_serie varchar 3 √ null
cte_refnf_subserie varchar 3 √ null
cte_refnf_nro varchar 6 √ null
cte_refnf_valor numeric 0 √ null
cte_refnf_demi timestamp 29,6 √ null
cte_tomaicms_refcte varchar 44 √ null
cte_infctesub_indalteratoma varchar 1 √ null
cte_infglobalizado_xobs varchar 256 √ NULL::character varying
cte_infctecomp_chcte varchar 44 √ null
cte_infcteanu_chcte varchar 44 √ null
cte_infcteanu_demi timestamp 29,6 √ null
cte_infresptec_cnpj varchar 14 √ null
cte_infresptec_xcontato varchar 60 √ NULL::character varying
cte_infresptec_email varchar 60 √ NULL::character varying
cte_infresptec_fone varchar 12 √ null
cte_infresptec_idcsrt varchar 3 √ null
cte_infresptec_hashcsrt varchar 28 √ NULL::character varying
cte_infctesupl_qrcodcte varchar 1000 √ NULL::character varying
cte_icms_vtottrib numeric 0 √ null
cte_lote_id numeric 10 √ NULL::numeric
cte_lote.cte_lote_id ctelote_ctecte R
cte_rodo_rntrc varchar 8 √ NULL::character varying
cte_entrega_hfim timestamp 29,6 √ null
documentno varchar 30 NULL::character varying
cte_status varchar 4 √ null
cte_icms_picmsuffim numeric 0 √ null
description text 2147483647 √ null
processed bpchar 1 'N'::bpchar
c_order_id numeric 10 √ NULL::numeric
c_order.c_order_id corder_ctecte R
c_invoice_id numeric 10 √ NULL::numeric
c_invoice.c_invoice_id cinvoice_ctecte R
cte_nprot varchar 255 √ NULL::character varying
cte_digestvalue varchar 255 √ NULL::character varying
cte_veraplic varchar 255 √ NULL::character varying
docstatus varchar 2 'DR'::character varying
docaction bpchar 2 'CO'::bpchar
cte_cst varchar 2 √ NULL::character varying
cte_icms_vbc numeric 0 √ '0'::numeric
cte_icms_vicms numeric 0 √ '0'::numeric
cte_icms_picms numeric 0 √ '0'::numeric
cte_icms_predbc numeric 0 √ '0'::numeric
cte_icms_vbcstret numeric 0 √ '0'::numeric
cte_icms_vicmsstret numeric 0 √ '0'::numeric
cte_icms_picmsstret numeric 0 √ '0'::numeric
cte_icms_vcred numeric 0 √ '0'::numeric
dateacct timestamp 29,6 null
datedoc timestamp 29,6 null
c_doctype_id numeric 10 √ NULL::numeric
c_doctype.c_doctype_id cdoctype_ctecte R
c_doctypetarget_id numeric 10 √ NULL::numeric
c_doctype.c_doctype_id cdoctypetarget_ctecte R
cte_bptomador_id numeric 10 √ null
c_bpartner.c_bpartner_id ctebptomador_ctecte R
cte_bpdestinatario_id numeric 10 √ null
c_bpartner.c_bpartner_id ctebpdestinatario_ctecte R
cte_bpremetente_id numeric 10 √ null
c_bpartner.c_bpartner_id ctebpremetente_ctecte R
cte_bpdestinatarioloc_id numeric 10 √ null
c_bpartner_location.c_bpartner_location_id ctebpdestinatarioloc_ctecte R
cte_bpremetenteloc_id numeric 10 √ NULL::numeric
c_bpartner_location.c_bpartner_location_id ctebpremetenteloc_ctecte R
cte_bptomadorloc_id numeric 10 √ NULL::numeric
c_bpartner_location.c_bpartner_location_id ctebptomadorloc_ctecte R
cte_cfop_id numeric 10 √ NULL::numeric
lbr_cfop.lbr_cfop_id ctecfop_ctecte R
cte_dest_city_id numeric 10 √ NULL::numeric
c_city.c_city_id ctedestcity_ctecte R
cte_dest_country_id numeric 10 √ NULL::numeric
c_country.c_country_id ctedestcountry_ctecte R
cte_dest_region_id numeric 10 √ NULL::numeric
c_region.c_region_id ctedestregion_ctecte R
cte_emit_city_id numeric 10 √ NULL::numeric
c_city.c_city_id cteemitcity_ctecte R
cte_emit_country_id numeric 10 √ NULL::numeric
c_country.c_country_id cteemitcountry_ctecte R
cte_emit_region_id numeric 10 √ NULL::numeric
c_region.c_region_id cteemitregion_ctecte R
cte_rem_city_id numeric 10 √ NULL::numeric
c_city.c_city_id cteremcity_ctecte R
cte_rem_country_id numeric 10 √ NULL::numeric
c_country.c_country_id cteremcountry_ctecte R
cte_rem_region_id numeric 10 √ NULL::numeric
c_region.c_region_id cteremregion_ctecte R
cte_toma_city_id numeric 10 √ NULL::numeric
c_city.c_city_id ctetomacity_ctecte R
cte_toma_country_id numeric 10 √ NULL::numeric
c_country.c_country_id ctetomacountry_ctecte R
cte_toma_region_id numeric 10 √ NULL::numeric
c_region.c_region_id ctetomaregion_ctecte R
c_currency_id numeric 10 NULL::numeric
c_currency.c_currency_id ccurrency_ctecte R
isapproved bpchar 1 'Y'::bpchar
cof_processing bpchar 1 √ NULL::bpchar
m_pricelist_id numeric 10 √ NULL::numeric
m_pricelist.m_pricelist_id mpricelist_ctecte R
datetrx timestamp 29,6 √ null
iscancelled bpchar 1 'N'::bpchar
cte_statusemail bpchar 1 √ NULL::bpchar
cte_infcarga_vcargaavrb numeric 0 √ null
cte_bprecebedor_id numeric 10 √ NULL::numeric
c_bpartner.c_bpartner_id ctebprecebedor_ctecte R
cte_bpexpedidor_id numeric 10 √ NULL::numeric
c_bpartner.c_bpartner_id ctebpexpedidor_ctecte R
cte_bpexpedidorloc_id numeric 10 √ NULL::numeric
c_bpartner_location.c_bpartner_location_id ctebpexpedidorloc_ctecte R
cte_bprecebedorloc_id numeric 10 √ NULL::numeric
c_bpartner_location.c_bpartner_location_id ctebprecebedorloc_ctecte R
cte_exped_city_id numeric 10 √ null
c_city.c_city_id cteexpedcity_ctecte R
cte_receb_city_id numeric 10 √ NULL::numeric
c_city.c_city_id cterecebcity_ctecte R
cte_exped_region_id numeric 10 √ NULL::numeric
c_region.c_region_id cteexpedregion_ctecte R
cte_receb_region_id numeric 10 √ NULL::numeric
c_region.c_region_id cterecebregion_ctecte R
cte_receb_country_id numeric 10 √ NULL::numeric
c_country.c_country_id cterecebcountry_ctecte R
cte_exped_country_id numeric 10 √ NULL::numeric
c_country.c_country_id cteexpedcountry_ctecte R
cte_motivocancelamento text 2147483647 √ null
processing bpchar 1 'N'::bpchar
cof_ufinicio_id numeric 10 √ NULL::numeric
c_region.c_region_id cofufinicio_ctecte R
cof_uftermino_id numeric 10 √ NULL::numeric
c_region.c_region_id cofuftermino_ctecte R
cof_municipioinicio_id numeric 10 √ NULL::numeric
c_city.c_city_id cofmunicipioinicio_ctecte R
cof_municipiotermino_id numeric 10 √ NULL::numeric
c_city.c_city_id cofmunicipiotermino_ctecte R
imposto_pis_cst varchar 2 √ NULL::character varying
imposto_pis_vbc numeric 0 √ '0'::numeric
imposto_pis_ppis numeric 0 √ '0'::numeric
imposto_pis_vpis numeric 0 √ '0'::numeric
imposto_cofins_cst varchar 2 √ NULL::character varying
imposto_cofins_vbc numeric 0 √ '0'::numeric
imposto_cofins_pcofins numeric 0 √ '0'::numeric
imposto_cofins_vcofins numeric 0 √ '0'::numeric
issotrx bpchar 1 'Y'::bpchar
cte_emit_bpartner_id numeric 10 √ NULL::numeric
c_bpartner.c_bpartner_id cteemitbpartner_ctecte R
cte_emit_location_id numeric 10 √ NULL::numeric
c_bpartner_location.c_bpartner_location_id cteemitlocation_ctecte R
cte_ibscbs_cst varchar 3 √ NULL::character varying
cte_ibscbs_cclasstrib varchar 6 √ NULL::character varying
cte_ibscbs_inddoacao bpchar 1 'N'::bpchar
cte_ibscbs_vbc numeric 0 √ '0'::numeric
cte_ibsuf_pibsuf numeric 0 √ '0'::numeric
cte_ibsuf_pdif numeric 0 √ '0'::numeric
cte_ibsuf_vdif numeric 0 √ '0'::numeric
cte_ibsuf_vdevtrib numeric 0 √ '0'::numeric
cte_ibsuf_predaliq numeric 0 √ '0'::numeric
cte_ibsuf_paliqefet numeric 0 √ '0'::numeric
cte_ibsuf_vibsuf numeric 0 √ '0'::numeric
cte_ibsmun_pibsmun numeric 0 √ '0'::numeric
cte_ibsmun_pdif numeric 0 √ '0'::numeric
cte_ibsmun_vdif numeric 0 √ '0'::numeric
cte_ibsmun_vdevtrib numeric 0 √ '0'::numeric
cte_ibsmun_predaliq numeric 0 √ '0'::numeric
cte_ibscbs_vibs numeric 0 √ '0'::numeric
cte_cbs_pcbs numeric 0 √ '0'::numeric
cte_cbs_pdif numeric 0 √ '0'::numeric
cte_cbs_vdif numeric 0 √ '0'::numeric
cte_cbs_vdevtrib numeric 0 √ '0'::numeric
cte_cbs_predaliq numeric 0 √ '0'::numeric
cte_cbs_paliqefet numeric 0 √ '0'::numeric
cte_cbs_vcbs numeric 0 √ '0'::numeric
cte_tribregular_cstreg varchar 3 √ NULL::character varying
cte_tribregular_cclasstribreg varchar 6 √ NULL::character varying
cte_tribregular_paliqefetregibsuf numeric 0 √ '0'::numeric
cte_tribregular_vtribregibsuf numeric 0 √ '0'::numeric
cte_tribregular_paliqefetregibsmun numeric 0 √ '0'::numeric
cte_tribregular_vtribregibsmun numeric 0 √ '0'::numeric
cte_tribregular_paliqefetregcbs numeric 0 √ '0'::numeric
cte_tribregular_vtribregcbs numeric 0 √ '0'::numeric
cte_tribcompragov_paliqibsuf numeric 0 √ '0'::numeric
cte_tribcompragov_vtribibsuf numeric 0 √ '0'::numeric
cte_tribcompragov_paliqibsmun numeric 0 √ '0'::numeric
cte_tribcompragov_vtribibsmun numeric 0 √ '0'::numeric
cte_tribcompragov_paliqcbs numeric 0 √ '0'::numeric
cte_tribcompragov_vtribcbs numeric 0 √ '0'::numeric
cte_estornocred_vibsestcred numeric 0 √ '0'::numeric
cte_estornocred_vcbsestcred numeric 0 √ '0'::numeric
cte_imp_vtotdfe numeric 0 √ '0'::numeric
cte_compragov_predutor numeric 0 √ '0'::numeric
cte_compragov_tpentegov bpchar 1 √ null
cte_ind_estornocred bpchar 1 'N'::bpchar
cte_ind_tribregular bpchar 1 'N'::bpchar
cte_ibsmun_paliqefet numeric 0 √ '0'::numeric
cte_ibsmun_vibsmun numeric 0 √ '0'::numeric

Indexes

Constraint Name Type Sort Column(s)
cte_cte_key Primary key Asc cte_cte_id
cte_cte_c_invoice_id_idx Performance Asc c_invoice_id
cte_cte_c_order_id_idx Performance Asc c_order_id
cte_cte_uu_idx Must be unique Asc cte_cte_uu

Check Constraints

Constraint Name Constraint
cte_cte_processed_check ((processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cte_cte_iscancelled_check ((iscancelled = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cte_cte_cte_ind_tribregular_check ((cte_ind_tribregular = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cte_cte_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cte_cte_issotrx_check ((issotrx = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cte_cte_cte_ind_estornocred_check ((cte_ind_estornocred = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cte_cte_cte_compragov_tpentegov_check ((cte_compragov_tpentegov = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cte_cte_isapproved_check ((isapproved = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cte_cte_cte_ibscbs_inddoacao_check ((cte_ibscbs_inddoacao = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation