c_doctype

134 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
c_doctype_id numeric 10 null
a_asset_addition.c_doctype_id cdoctype_aassetaddition R
a_asset_change.c_invoice_c_doctypetarget_id cinvoicecdoctypetarget_aassetc R
a_asset_disposed.c_doctype_id cdoctype_aassetdisposed R
a_asset_reval_entry.c_doctype_id cdoctype_aassetrevalentry R
a_depreciation_entry.c_doctype_id cdoctype_adepreciationentry R
ad_document_action_access.c_doctype_id cdoctype_addocumentactionacces R
ad_replicationdocument.c_doctype_id cdoctype_adreplicationdocument R
c_allocationhdr.c_doctype_id cdoctype_callocationhdr R
c_bankstatement.c_doctype_id cdoctype_cbankstatement R
c_bpartner.cof_doctypepurchase_id cofdoctypepurchase_cbpartner R
c_bpartner.cof_doctypesale_id cofdoctypesale_cbpartner R
c_chargetype_doctype.c_doctype_id cdoctype_cchargetypedoctype R
c_depositbatch.c_doctype_id cdoctype_cdepositbatch R
c_doctype.c_doctypedifference_id cdoctypedifference_cdoctype R
c_doctype.c_doctypeinvoice_id cdoctype_invoice R
c_doctype.c_doctypeproforma_id cdoctype_proforma R
c_doctype.c_doctypeshipment_id cdoctype_shipment R
c_doctype.cte_doctype_id ctedoctype_cdoctype R
c_doctype_trl.c_doctype_id cdoctype_cdoctypetrl C
c_doctypecounter.c_doctype_id cdoctype_cdoctypecounter R
c_doctypecounter.counter_c_doctype_id cdoctypecount_cdoctypecount R
c_invoice.c_doctype_id cdoctype_cinvoice R
c_invoice.c_doctypetarget_id cdoctypetarget_cinvoice R
c_invoicebatchline.c_doctype_id cdoctype_cinvoicebatchline R
c_order.c_doctype_id c_doctype_corder R
c_order.c_doctypetarget_id cdoctypetarget_corder R
c_payment.c_doctype_id cdoctype_cpayment R
c_pos.c_doctype_id cdoctype_cpos R
cof_ajusteestoqueprevisto.c_doctypetarget_id cdoctypetarget_cofajusteestoqu R
cof_c_bankintegration.c_doctype_id cdoctype_cofcbankintegration R
cof_c_markup.c_doctype_id cdoctype_cofcmarkup R
cof_calcnivelminmax.c_doctype_id cdoctype_cofcalcnivelminmax R
cof_calcnivelminmax.c_doctypetarget_id cdoctypetarget_cofcalcnivelminmax R
cof_conciliacaocartao.c_doctype_id cdoctype_cofconciliacaocartao R
cof_configovs.c_doctypetarget_id cdoctypetarget_cofconfigovs R
cof_contract.c_doctype_id cdoctype_cofcontract R
cof_controleremessasind.c_doctypetarget_id cdoctypetarget_cofcontrolereme R
cof_mdfe.c_doctype_id cdoctype_cofmdfe R
cof_mdfe.c_doctypetarget_id cdoctypetarget_cofmdfe R
cof_ordemservico.c_doctypetarget_id cdoctypetarget_cofordemservico R
cof_pp_planomestreprod.c_doctype_id cdoctype_cofppplanomestreprod R
cof_reposicaoestoquefilial.c_doctype_id cdoctype_cofreposicaoestoquefilial R
cof_reposicaoestoquefilial.c_doctypetarget_id cdoctypetarget_cofreposicaoestoquefilial R
cof_retentionconfig.c_doctype_id cdoctype_cofretentionconfig R
cof_rps.c_doctype_id cdoctype_cofrps R
cof_rps.c_doctypetarget_id cdoctypetarget_cofrps R
cte_cte.c_doctype_id cdoctype_ctecte R
cte_cte.c_doctypetarget_id cdoctypetarget_ctecte R
dd_order.c_doctype_id cdoctype_ddorder R
gl_distribution.c_doctype_id cdoctype_gldistribution R
gl_journal.c_doctype_id cdoctype_gljournal R
gl_journalbatch.c_doctype_id cdoctype_gljournalbatch R
gl_journalgenerator.c_doctype_id cdoctype_qssjournalgenerator R
hr_process.c_doctype_id cdoctype_hrprocess R
hr_process.c_doctypetarget_id cdoctypetarget_hrprocess R
i_fajournal.c_doctype_id cdoctype_ifajournal R
i_gljournal.c_doctype_id cdoctype_igljournal N
i_inventory.c_doctype_id cdoctype_iinventory R
i_invoice.c_doctype_id cdoctype_iinvoice N
i_movement.c_doctype_id cdoctype_imovement R
i_order.c_doctype_id cdoctype_iorder N
i_payment.c_doctype_id cdoctype_ipayment N
k_index.c_doctype_id cdoctype_kindex C
k_indexstop.c_doctype_id cdoctype_kindexstop R
m_inout.c_doctype_id cdoctype_minout R
m_inventory.c_doctype_id cdoctype_minventory R
m_movement.c_doctype_id cdoctype_mmovement R
m_production.c_doctype_id cdoctype_mproduction R
m_requisition.c_doctype_id cdoctype_mrequisition R
m_rma.c_doctype_id cdoctype_mrma R
m_storagereservationlog.c_doctype_id cdoctype_mstoragereservationlo R
mp_maintain.c_doctype_id cdoctype_mpmaintain R
mp_ot.c_doctype_id cdoctype_mpot R
mp_ot_request.c_doctype_id cdoctype_mpotrequest R
pp_cost_collector.c_doctype_id cdoctype_ppcostcollector R
pp_cost_collector.c_doctypetarget_id cdoctypetarget_ppcostcollector R
pp_order.c_doctype_id cdoctype_pporder R
pp_order.c_doctypetarget_id cdoctypetarget_pporder R
t_aging.c_doctypetarget_id cdoctypetarget_taging R
t_cof_fluxoplanofinanceiro.c_doctype_id cdoctype_tcoffluxoplanofinance R
t_invoicegl.c_doctypereval_id cdoctype_tinvoicegl C
t_replenish.c_doctype_id cdoctype_treplenish C
ad_client_id numeric 10 null
ad_org_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
name varchar 60 null
printname varchar 60 null
description varchar 255 √ null
docbasetype bpchar 3 null
issotrx bpchar 1 'Y'::bpchar
docsubtypeso bpchar 2 √ null
hasproforma bpchar 1 √ 'N'::bpchar
c_doctypeproforma_id numeric 10 √ null
c_doctype.c_doctype_id cdoctype_proforma R
c_doctypeshipment_id numeric 10 √ null
c_doctype.c_doctype_id cdoctype_shipment R
c_doctypeinvoice_id numeric 10 √ null
c_doctype.c_doctype_id cdoctype_invoice R
isdocnocontrolled bpchar 1 'N'::bpchar
docnosequence_id numeric 10 √ null
ad_sequence.ad_sequence_id ad_sequence_doctypedoc R
gl_category_id numeric 10 null
gl_category.gl_category_id glcategory_cdoctype R
hascharges bpchar 1 'N'::bpchar
documentnote varchar 2000 √ null
isdefault bpchar 1 'N'::bpchar
documentcopies numeric 10 null
ad_printformat_id numeric 10 √ null
ad_printformat.ad_printformat_id adprintformat_cdoctype R
isdefaultcounterdoc bpchar 1 'N'::bpchar
isshipconfirm bpchar 1 'N'::bpchar
ispickqaconfirm bpchar 1 'N'::bpchar
isintransit bpchar 1 'N'::bpchar
issplitwhendifference bpchar 1 'N'::bpchar
c_doctypedifference_id numeric 10 √ null
c_doctype.c_doctype_id cdoctypedifference_cdoctype R
iscreatecounter bpchar 1 'Y'::bpchar
isindexed bpchar 1 'Y'::bpchar
isoverwriteseqoncomplete bpchar 1 √ 'N'::bpchar
definitesequence_id numeric 10 √ null
ad_sequence.ad_sequence_id definitesequence_cdoctype R
isoverwritedateoncomplete bpchar 1 √ 'N'::bpchar
ispreparesplitdocument bpchar 1 'Y'::bpchar
c_doctype_uu varchar 36 √ NULL::character varying
ischargeorproductmandatory bpchar 1 √ 'N'::bpchar
docsubtypeinv varchar 2 √ NULL::character varying
lbr_hasopenitems bpchar 1 'Y'::bpchar
lbr_hasfiscaldocument bpchar 1 'Y'::bpchar
lbr_isowndocument bpchar 1 'Y'::bpchar
lbr_doctypenf_id numeric 10 √ null
lbr_nfmodel varchar 5 √ null
lbr_nfserie varchar 3 √ null
lbr_danfeformat bpchar 1 √ null
cof_pricelist_id numeric 10 √ NULL::numeric
cof_tax_id numeric 10 √ NULL::numeric
cof_maxlineqty numeric 10 √ (0)::numeric
cof_defaultreturncnab bpchar 1 √ 'N'::bpchar
cof_doctypebanktransfer bpchar 1 √ 'N'::bpchar
cof_processing bpchar 1 √ NULL::bpchar
cof_validatetax bpchar 1 √ 'N'::bpchar
cof_iswriteoffpayment bpchar 1 √ NULL::bpchar
cof_danfeprintpaper varchar 2 'A4'::character varying
cof_isgeneratexml bpchar 1 √ 'N'::bpchar
cof_finnfe bpchar 1 √ '1'::bpchar
cof_indpres bpchar 1 √ '1'::bpchar
cof_isgeneratenftransp bpchar 1 √ 'N'::bpchar
cof_completeinvoice bpchar 1 √ 'Y'::bpchar
cof_completeshipment bpchar 1 √ 'Y'::bpchar
cof_preprinteddanfe bpchar 1 √ 'N'::bpchar
cof_isvalidatecfop bpchar 1 √ 'Y'::bpchar
cof_isgeneratenfmovement bpchar 1 √ 'N'::bpchar
m_warehouse_id numeric 10 √ NULL::numeric
m_warehouse.m_warehouse_id mwarehouse_cdoctype R
user1_id numeric 10 √ NULL::numeric
c_elementvalue.c_elementvalue_id user1_cdoctype R
c_activity_id numeric 10 √ NULL::numeric
c_activity.c_activity_id cactivity_cdoctype R
user2_id numeric 10 √ NULL::numeric
c_elementvalue.c_elementvalue_id user2_cdoctype R
deliveryrule bpchar 1 √ null
invoicerule bpchar 1 √ NULL::bpchar
cof_modfrete bpchar 1 √ NULL::bpchar
cof_isindustrialization bpchar 1 √ 'N'::bpchar
cof_twosided bpchar 1 √ 'N'::bpchar
cof_charge_id numeric 10 √ NULL::numeric
c_charge.c_charge_id cofcharge_cdoctype R
cof_ispaymentincheck bpchar 1 'N'::bpchar
cof_exibiremrelatorios bpchar 1 √ 'Y'::bpchar
cof_administraretirada bpchar 1 √ 'N'::bpchar
cof_liberadosweb bpchar 1 √ 'N'::bpchar
cof_baixarativo bpchar 1 √ 'Y'::bpchar
deliveryviarule varchar 10 √ 'P'::character varying
cof_entregafutura bpchar 1 'N'::bpchar
cof_ispagamentoantecipado bpchar 1 'N'::bpchar
isnopricelistcheck bpchar 1 √ 'N'::bpchar
cof_ismpindustrializacaoprestador bpchar 1 √ 'N'::bpchar
cof_isremessaindustrializacaoprestador bpchar 1 √ 'N'::bpchar
cof_isimprimirnotadocumento bpchar 1 'N'::bpchar
cof_isimprimeorcamento bpchar 1 'N'::bpchar
lbr_isadicionardadosobra varchar 10 'N'::character varying
cof_isdesconsideraremmetas bpchar 1 'N'::bpchar
cof_ispropostavalidade bpchar 1 √ 'N'::bpchar
cof_validadeproposta numeric 10 √ NULL::numeric
cof_cabecalhov_id numeric 10 √ NULL::numeric
ad_image.ad_image_id cofcabecalhov_cdoctype R
cof_istransmitirdocumentofiscal bpchar 1 'N'::bpchar
cof_dataprometida numeric 10 √ '0'::numeric
cof_iscompletarnftransporte bpchar 1 'N'::bpchar
cof_istransmitirnftransporte bpchar 1 'N'::bpchar
cof_pontoremessa_id numeric 10 √ NULL::numeric
cof_pontoremessa.cof_pontoremessa_id cofpontoremessa_cdoctype R
cof_creditoalocautomatica bpchar 1 'N'::bpchar
cof_composescashflow bpchar 1 'Y'::bpchar
cof_isvalidaimpostotransporte bpchar 1 'N'::bpchar
cof_indicadorintermediador bpchar 1 '0'::bpchar
cof_issuprimirvalores bpchar 1 'N'::bpchar
cof_isforcarregratributaria bpchar 1 'N'::bpchar
cof_isconfirmacaofornecedor bpchar 1 'N'::bpchar
cof_isconfirmacaoembarque bpchar 1 'N'::bpchar
cof_isconfirmacaocliente bpchar 1 'N'::bpchar
cof_isimportaxml bpchar 1 'Y'::bpchar
isautogenerateinout bpchar 1 'N'::bpchar
isautogenerateinvoice bpchar 1 'N'::bpchar
iscanbereactivated bpchar 1 'N'::bpchar
cte_isgeracte bpchar 1 'N'::bpchar
cte_doctype_id numeric 10 √ NULL::numeric
c_doctype.c_doctype_id ctedoctype_cdoctype R
cof_isnaorecebequantidademaiorpedidodecompra bpchar 1 'N'::bpchar
cof_tipomovimentobaixa varchar 2 √ NULL::character varying
ide_tpnfdebito varchar 2 √ null
ide_tpnfcredito varchar 2 √ NULL::character varying
cof_isemitentecomodestinatario bpchar 1 'N'::bpchar
cte_ibscbs_inddoacao bpchar 1 'N'::bpchar

Indexes

Constraint Name Type Sort Column(s)
c_doctype_pkey Primary key Asc c_doctype_id
c_doctype_name Must be unique Asc/Asc ad_client_id + name
c_doctype_uu_idx Must be unique Asc c_doctype_uu

Check Constraints

Constraint Name Constraint
c_doctype_lbr_isowndocument_check ((lbr_isowndocument = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_isemitentecomodestinatario_check ((cof_isemitentecomodestinatario = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_entregafutura_check ((cof_entregafutura = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_iscompletarnftransporte_check ((cof_iscompletarnftransporte = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_doctypebanktransfer_check ((cof_doctypebanktransfer = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_ispropostavalidade_check ((cof_ispropostavalidade = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_ischargeorproductmandatory_check ((ischargeorproductmandatory = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_isvalidaimpostotransporte_check ((cof_isvalidaimpostotransporte = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_hascharges_check ((hascharges = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_isimportaxml_check ((cof_isimportaxml = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_validatetax_check ((cof_validatetax = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_issuprimirvalores_check ((cof_issuprimirvalores = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_isautogenerateinout_check ((isautogenerateinout = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_isdocnocontrolled_check ((isdocnocontrolled = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_completeshipment_check ((cof_completeshipment = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_ispreparesplitdocument_check ((ispreparesplitdocument = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_isgeneratenfmovement_check ((cof_isgeneratenfmovement = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_iswriteoffpayment_check ((cof_iswriteoffpayment = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_composescashflow_check ((cof_composescashflow = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_istransmitirnftransporte_check ((cof_istransmitirnftransporte = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_liberadosweb_check ((cof_liberadosweb = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_lbr_hasfiscaldocument_check ((lbr_hasfiscaldocument = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cte_ibscbs_inddoacao_check ((cte_ibscbs_inddoacao = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_isdesconsideraremmetas_check ((cof_isdesconsideraremmetas = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_ispaymentincheck_check ((cof_ispaymentincheck = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_hasproforma_check ((hasproforma = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_exibiremrelatorios_check ((cof_exibiremrelatorios = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_baixarativo_check ((cof_baixarativo = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_issotrx_check ((issotrx = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_isremessaindustrializacaoprestador_check ((cof_isremessaindustrializacaoprestador = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_isconfirmacaoembarque_check ((cof_isconfirmacaoembarque = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_preprinteddanfe_check ((cof_preprinteddanfe = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_creditoalocautomatica_check ((cof_creditoalocautomatica = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_isindustrialization_check ((cof_isindustrialization = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_ismpindustrializacaoprestador_check ((cof_ismpindustrializacaoprestador = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_isgeneratenftransp_check ((cof_isgeneratenftransp = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_isimprimirnotadocumento_check ((cof_isimprimirnotadocumento = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_lbr_hasopenitems_check ((lbr_hasopenitems = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_istransmitirdocumentofiscal_check ((cof_istransmitirdocumentofiscal = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_administraretirada_check ((cof_administraretirada = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_ispagamentoantecipado_check ((cof_ispagamentoantecipado = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_isoverwritedateoncomplete_check ((isoverwritedateoncomplete = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_isnaorecebequantidademaiorpedidodecompra_check ((cof_isnaorecebequantidademaiorpedidodecompra = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_twosided_check ((cof_twosided = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cte_isgeracte_check ((cte_isgeracte = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_isvalidatecfop_check ((cof_isvalidatecfop = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_lbr_isadicionardadosobra_check (((lbr_isadicionardadosobra)::text = ANY (ARRAY[('Y'::character varying)::text, ('N'::character varying)::text])))
c_doctype_isautogenerateinvoice_check ((isautogenerateinvoice = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_isconfirmacaofornecedor_check ((cof_isconfirmacaofornecedor = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_isconfirmacaocliente_check ((cof_isconfirmacaocliente = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_isnopricelistcheck_check ((isnopricelistcheck = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_defaultreturncnab_check ((cof_defaultreturncnab = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_isgeneratexml_check ((cof_isgeneratexml = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_iscanbereactivated_check ((iscanbereactivated = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_isoverwriteseqoncomplete_check ((isoverwriteseqoncomplete = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_completeinvoice_check ((cof_completeinvoice = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_isimprimeorcamento_check ((cof_isimprimeorcamento = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation