c_doctype

133 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_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_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_dunning_line_v.c_doctype_id Implied Constraint R
c_dunning_line_vt.c_doctype_id Implied Constraint R
c_invoice.c_doctype_id cdoctype_cinvoice R
c_invoice.c_doctypetarget_id cdoctypetarget_cinvoice R
c_invoice_candidate_v.c_doctype_id Implied Constraint R
c_invoice_header_v.c_doctype_id Implied Constraint R
c_invoice_header_vt.c_doctype_id Implied Constraint R
c_invoice_v.c_doctype_id Implied Constraint R
c_invoice_v1.c_doctype_id Implied Constraint 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_order_header_v.c_doctype_id Implied Constraint R
c_order_header_vt.c_doctype_id Implied Constraint R
c_payment.c_doctype_id cdoctype_cpayment R
c_payment_v.c_doctype_id Implied Constraint R
c_paymenttransaction.c_doctype_id Implied Constraint R
c_payselection_check_v.c_doctype_id Implied Constraint R
c_payselection_check_vt.c_doctype_id Implied Constraint R
c_payselection_remittance_v.c_doctype_id Implied Constraint R
c_payselection_remittance_vt.c_doctype_id Implied Constraint R
c_pos.c_doctype_id cdoctype_cpos R
cof_ajusteestoqueprevisto.c_doctypetarget_id cdoctypetarget_cofajusteestoqu R
cof_c_doctype_return.c_doctype_id Implied Constraint R
cof_c_invoice_candidate_v.c_doctype_id Implied Constraint R
cof_c_markup.c_doctype_id cdoctype_cofcmarkup 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_inoutline_candidate_v.c_doctype_id Implied Constraint R
cof_m_inout_candidate_v.c_doctype_id Implied Constraint R
cof_ordemservico.c_doctypetarget_id cdoctypetarget_cofordemservico R
cof_pp_planomestreprod.c_doctype_id cdoctype_cofppplanomestreprod 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
cof_rv_confimpostos.c_doctype_id Implied Constraint R
cof_rv_contract.c_doctype_id Implied Constraint R
cof_rv_detalheplanomestre.c_doctype_id Implied Constraint R
cof_rv_detalhesproducao.c_doctype_id Implied Constraint R
cof_rv_docfiscal.c_doctype_id Implied Constraint R
cof_rv_itenspago.c_doctype_id Implied Constraint R
cof_rv_openiteminterest.c_doctype_id Implied Constraint R
cof_transacoesfiscais.c_doctype_id Implied Constraint R
dd_order.c_doctype_id cdoctype_ddorder R
dd_order_header_v.c_doctype_id Implied Constraint R
dd_order_header_vt.c_doctype_id Implied Constraint 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_inout.c_doctype_id Implied Constraint R
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
lbr_cfopline.c_doctype_id Implied Constraint R
lbr_docfiscal.c_doctype_id Implied Constraint R
lbr_taxdefinition.c_doctype_id Implied Constraint R
m_inout.c_doctype_id cdoctype_minout R
m_inout_candidate_v.c_doctype_id Implied Constraint R
m_inout_header_v.c_doctype_id Implied Constraint R
m_inout_header_vt.c_doctype_id Implied Constraint R
m_inoutconfirm_v.c_doctype_id Implied Constraint R
m_inoutconfirm_vt.c_doctype_id Implied Constraint R
m_inventory.c_doctype_id cdoctype_minventory R
m_movement.c_doctype_id cdoctype_mmovement R
m_movement_candidate_v.c_doctype_id Implied Constraint 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
pp_order_bom_header_v.c_doctype_id Implied Constraint R
pp_order_bom_header_vt.c_doctype_id Implied Constraint R
pp_order_header_v.c_doctype_id Implied Constraint R
pp_order_header_vt.c_doctype_id Implied Constraint R
pp_order_workflow_header_v.c_doctype_id Implied Constraint R
pp_order_workflow_header_vt.c_doctype_id Implied Constraint R
rv_bpartneropen.c_doctype_id Implied Constraint R
rv_c_invoice.c_doctype_id Implied Constraint R
rv_c_invoice_customervendqtr.c_doctype_id Implied Constraint R
rv_c_invoice_day.c_doctype_id Implied Constraint R
rv_c_invoice_month.c_doctype_id Implied Constraint R
rv_c_invoice_productmonth.c_doctype_id Implied Constraint R
rv_c_invoice_prodweek.c_doctype_id Implied Constraint R
rv_c_invoice_week.c_doctype_id Implied Constraint R
rv_c_invoiceline.c_doctype_id Implied Constraint R
rv_c_invoicetax.c_doctype_id Implied Constraint R
rv_cof_detailassetmaintain.c_doctype_id Implied Constraint R
rv_cof_detalhesestoquefisico.c_doctype_id Implied Constraint R
rv_commissionrundetail.c_doctype_id Implied Constraint R
rv_dd_orderdetail.c_doctype_id Implied Constraint R
rv_inoutdetails.c_doctype_id Implied Constraint R
rv_openitem.c_doctype_id Implied Constraint R
rv_openitemtodate.c_doctype_id Implied Constraint R
rv_orderdetail.c_doctype_id Implied Constraint R
rv_payment.c_doctype_id Implied Constraint R
rv_pp_order.c_doctype_id Implied Constraint R
t_aging.c_doctype_id Implied Constraint R
t_cof_fluxoplanofinanceiro.c_doctype_id cdoctype_tcoffluxoplanofinance R
t_invoicegl.c_doctypereval_id cdoctype_tinvoicegl C
t_invoicegl_v.c_doctype_id Implied Constraint R
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_isautomaticshipment bpchar 1 'N'::bpchar
lbr_isautomaticinvoice bpchar 1 'N'::bpchar
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

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_hasopenitems_check ((lbr_hasopenitems = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_baixarativo_check ((cof_baixarativo = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_defaultreturncnab_check ((cof_defaultreturncnab = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_validatetax_check ((cof_validatetax = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_hascharges_check ((hascharges = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_lbr_isautomaticshipment_check ((lbr_isautomaticshipment = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_lbr_hasfiscaldocument_check ((lbr_hasfiscaldocument = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_isoverwritedateoncomplete_check ((isoverwritedateoncomplete = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_isoverwriteseqoncomplete_check ((isoverwriteseqoncomplete = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_isdocnocontrolled_check ((isdocnocontrolled = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_isgeneratenfmovement_check ((cof_isgeneratenfmovement = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_isimprimirnotadocumento_check ((cof_isimprimirnotadocumento = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_isnopricelistcheck_check ((isnopricelistcheck = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_ispreparesplitdocument_check ((ispreparesplitdocument = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_twosided_check ((cof_twosided = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_isgeneratenftransp_check ((cof_isgeneratenftransp = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_liberadosweb_check ((cof_liberadosweb = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_completeinvoice_check ((cof_completeinvoice = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_isremessaindustrializacaoprestador_check ((cof_isremessaindustrializacaoprestador = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_isindustrialization_check ((cof_isindustrialization = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_entregafutura_check ((cof_entregafutura = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_ismpindustrializacaoprestador_check ((cof_ismpindustrializacaoprestador = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_lbr_isowndocument_check ((lbr_isowndocument = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_exibiremrelatorios_check ((cof_exibiremrelatorios = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_ispaymentincheck_check ((cof_ispaymentincheck = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_ischargeorproductmandatory_check ((ischargeorproductmandatory = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_preprinteddanfe_check ((cof_preprinteddanfe = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_administraretirada_check ((cof_administraretirada = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_isimprimeorcamento_check ((cof_isimprimeorcamento = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_iswriteoffpayment_check ((cof_iswriteoffpayment = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_hasproforma_check ((hasproforma = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_ispagamentoantecipado_check ((cof_ispagamentoantecipado = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_doctypebanktransfer_check ((cof_doctypebanktransfer = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_lbr_isautomaticinvoice_check ((lbr_isautomaticinvoice = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_issotrx_check ((issotrx = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_isgeneratexml_check ((cof_isgeneratexml = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_completeshipment_check ((cof_completeshipment = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_doctype_cof_isvalidatecfop_check ((cof_isvalidatecfop = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation