c_invoice

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
c_invoice_id numeric 10 null
a_asset_addition.c_invoice_id cinvoice_aassetaddition R
a_asset_change.c_invoice_id cinvoice_aassetchange R
a_asset_disposed.c_invoice_id cinvoice_aassetdisposed R
c_allocationline.c_invoice_id cinvoice_callocationline R
c_bankstatementline.c_invoice_id cinvoice_cbankstatementline R
c_cashline.c_invoice_id cinvoice_ccashline R
c_commissionrun.c_invoice_id cinvoice_ccommissionrun R
c_commissionrun.cof_invoice_id cofinvoice_ccommissionrun R
c_dunning_line_v.c_invoice_id Implied Constraint R
c_dunning_line_v.c_payment_c_invoice_id Implied Constraint R
c_dunning_line_vt.c_invoice_id Implied Constraint R
c_dunning_line_vt.c_payment_c_invoice_id Implied Constraint R
c_dunningrunline.c_invoice_id cinvoice_cdunningrunline N
c_invoice.cof_invoice_id cofinvoice_cinvoice R
c_invoice.cof_sourceinvoice_id cofsourceinvoice_cinvoice R
c_invoice.ref_invoice_id cinvoice_ref R
c_invoice.relatedinvoice_id relatedinvoice_cinvoice R
c_invoice.reversal_id reversal_cinvoice R
c_invoice_header_v.c_invoice_id Implied Constraint R
c_invoice_header_vt.c_invoice_id Implied Constraint R
c_invoice_linetax_v.c_invoice_id Implied Constraint R
c_invoice_linetax_vt.c_invoice_id Implied Constraint R
c_invoice_v.c_invoice_id Implied Constraint R
c_invoice_v1.c_invoice_id Implied Constraint R
c_invoicebatchline.c_invoice_id cinvoice_cinvoicebatchline R
c_invoiceline.c_invoice_id cinvoice_cinvoiceline C
c_invoiceline_v.c_invoice_id Implied Constraint R
c_invoicepayschedule.c_invoice_id cinvoice_cinvoicepaysched C
c_invoicetax.c_invoice_id cinvoice_cinvoicetax C
c_payment.c_invoice_id cinvoice_cpayment R
c_payment_v.c_invoice_id Implied Constraint R
c_paymentallocate.c_invoice_id cinvoice_cpaymentallocate R
c_paymenttransaction.c_invoice_id cinvoice_cpaymenttransaction R
c_payselection_check_v.c_payment_c_invoice_id Implied Constraint R
c_payselection_check_vt.c_payment_c_invoice_id Implied Constraint R
c_payselection_remittance_v.c_invoice_id Implied Constraint R
c_payselection_remittance_vt.c_invoice_id Implied Constraint R
c_payselectionline.c_invoice_id cinvoice_cpayselectline R
c_recurring.c_invoice_id cinvoice_crecurring R
c_recurring_run.c_invoice_id cinvoice_crecurringrun R
c_taxdeclarationline.c_invoice_id cinvoice_ctaxdeclline R
cof_c_checkallocate.c_invoice_id cinvoice_cofccheckallocate R
cof_c_controlcheck.cof_faturareapresentacao_id coffaturareapresentacao_cofcco R
cof_c_di.c_invoice_id cinvoice_cofcdi R
cof_controleremessasind.c_invoice_id cinvoice_cofcontroleremessasin R
cof_dash_vendascategoria.c_invoice_id Implied Constraint R
cof_itemsubstituto.c_invoice_id cinvoice_cofitemsubstituto N
cof_rps.c_invoice_id cinvoice_cofrps R
cof_rv_checkallocate.c_invoice_id Implied Constraint R
cof_rv_docfiscal.c_invoice_id Implied Constraint R
cof_rv_faturamentoprodutomargem.c_invoice_id Implied Constraint R
cof_rv_itenspago.c_invoice_id Implied Constraint R
cof_rv_requestpartner.c_invoice_id Implied Constraint R
cof_rv_titulos.c_invoice_id Implied Constraint R
cof_titulo.c_invoice_id cinvoice_coftitulo R
dd_order.c_invoice_id cinvoice_ddorder R
i_bankstatement.c_invoice_id cinvoice_ibankstatement N
i_invoice.c_invoice_id cinvoice_iinvoice N
i_payment.c_invoice_id cinvoice_ipayment N
lbr_docfiscal.c_invoice_id Implied Constraint R
m_inout.c_invoice_id cinvoice_minout R
m_inout_header_v.c_invoice_id Implied Constraint R
m_inout_header_vt.c_invoice_id Implied Constraint R
m_inoutconfirm.c_invoice_id cinvoice_minoutconfirm R
m_shippingtransaction.c_invoice_id cinvoice_mshippingtransaction R
r_request.c_invoice_id rinvoice_rrequest R
r_request.c_invoicerequest_id cinvoicerequest_rrequest R
r_request_v.c_invoice_id Implied Constraint R
r_requestaction.c_invoice_id cinvoice_rrequestaction R
rv_allocation.c_invoice_id Implied Constraint R
rv_bpartneropen.c_invoice_id Implied Constraint R
rv_c_invoice.c_invoice_id Implied Constraint R
rv_c_invoiceline.c_invoice_id Implied Constraint R
rv_c_invoicetax.c_invoice_id Implied Constraint R
rv_cash_detail.c_invoice_id Implied Constraint R
rv_commissionrundetail.c_invoice_c_invoice_id Implied Constraint R
rv_commissionrundetail.c_invoice_id Implied Constraint R
rv_inoutdetails.m_inout_c_invoice_id Implied Constraint R
rv_invoicepayschedule.c_invoice_id Implied Constraint R
rv_openitem.c_invoice_id Implied Constraint R
rv_openitemtodate.c_invoice_id Implied Constraint R
rv_payment.c_invoice_id Implied Constraint R
t_cashflow.c_invoice_id Implied Constraint R
t_invoicegl.c_invoice_id cinvoice_tinvoicegl C
t_invoicegl_v.c_invoice_id Implied Constraint R
t_invoicegl_v.t_invoicegl_c_invoice_id Implied Constraint R
ad_client_id numeric 10 null
ad_org_id numeric 10 null
ad_org.ad_org_id adorg_cinvoice R
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
issotrx bpchar 1 'Y'::bpchar
documentno varchar 30 null
docstatus bpchar 2 null
docaction bpchar 2 null
processing bpchar 1 √ null
processed bpchar 1 'N'::bpchar
posted bpchar 1 'N'::bpchar
c_doctype_id numeric 10 null
c_doctype.c_doctype_id cdoctype_cinvoice R
c_doctypetarget_id numeric 10 null
c_doctype.c_doctype_id cdoctypetarget_cinvoice R
c_order_id numeric 10 √ null
c_order.c_order_id corder_cinvoice R
description varchar 500 √ null
isapproved bpchar 1 'N'::bpchar
istransferred bpchar 1 'N'::bpchar
isprinted bpchar 1 'N'::bpchar
salesrep_id numeric 10 √ null
ad_user.ad_user_id aduser_sr_cinvoice R
dateinvoiced timestamp 29,6 null
dateprinted timestamp 29,6 √ null
dateacct timestamp 29,6 null
c_bpartner_id numeric 10 null
c_bpartner.c_bpartner_id cbpartner_cinvoice R
c_bpartner_location_id numeric 10 null
c_bpartner_location.c_bpartner_location_id c_bplocation_cinvoice R
poreference varchar 20 √ null
isdiscountprinted bpchar 1 'Y'::bpchar
dateordered timestamp 29,6 √ null
c_currency_id numeric 10 null
c_currency.c_currency_id ccurrency_cinvoice R
paymentrule bpchar 1 null
c_paymentterm_id numeric 10 null
c_paymentterm.c_paymentterm_id cpaymentterm_cinvoice R
c_charge_id numeric 10 √ null
c_charge.c_charge_id ccharge_cinvoice R
chargeamt numeric 0 √ 0
totallines numeric 0 0
grandtotal numeric 0 0
m_pricelist_id numeric 10 null
m_pricelist.m_pricelist_id mpricelist_cinvoice R
istaxincluded bpchar 1 'N'::bpchar
c_campaign_id numeric 10 √ null
c_campaign.c_campaign_id ccampaign_cinvoice R
c_project_id numeric 10 √ null
c_project.c_project_id cproject_cinvoice R
c_activity_id numeric 10 √ null
c_activity.c_activity_id cactivity_cinvoice R
ispaid bpchar 1 'N'::bpchar
c_payment_id numeric 10 √ null
c_payment.c_payment_id cpayment_cinvoice R
c_cashline_id numeric 10 √ null
c_cashline.c_cashline_id ccashline_cinvoice R
createfrom bpchar 1 √ null
generateto bpchar 1 √ null
sendemail bpchar 1 'N'::bpchar
ad_user_id numeric 10 √ null
ad_user.ad_user_id aduser_cinvoice R
copyfrom bpchar 1 √ null
isselfservice bpchar 1 'N'::bpchar
ad_orgtrx_id numeric 10 √ null
ad_org.ad_org_id adorgtrx_cinvoice R
user1_id numeric 10 √ null
c_elementvalue.c_elementvalue_id celementvalueuser1_cinvoice R
user2_id numeric 10 √ null
c_elementvalue.c_elementvalue_id celementvalueuser2_cinvoice R
c_conversiontype_id numeric 10 √ null
c_conversiontype.c_conversiontype_id cconversiontype_cinvoice R
ispayschedulevalid bpchar 1 'N'::bpchar
ref_invoice_id numeric 10 √ null
c_invoice.c_invoice_id cinvoice_ref R
isindispute bpchar 1 'N'::bpchar
invoicecollectiontype bpchar 1 √ null
m_rma_id numeric 10 √ null
m_rma.m_rma_id mrma_cinvoice R
dunninggrace timestamp 29,6 √ null
c_dunninglevel_id numeric 10 √ null
c_dunninglevel.c_dunninglevel_id cdunninglevel_cinvoice R
reversal_id numeric 10 √ null
c_invoice.c_invoice_id reversal_cinvoice R
processedon numeric 0 √ null
c_cashplanline_id numeric 10 √ NULL::numeric
c_cashplanline.c_cashplanline_id ccashplanline_cinvoice R
c_invoice_uu varchar 36 √ NULL::character varying
isfixedassetinvoice bpchar 1 √ null
lbr_transactiontype varchar 3 null
lbr_notafiscal_id numeric 10 √ null
lbr_nfentrada varchar 25 √ null
lbr_nftype varchar 3 √ null
lbr_nfmodel varchar 2 √ NULL::character varying
lbr_docfiscal_id numeric 10 √ null
lbr_docfiscal.lbr_docfiscal_id lbrdocfiscal_cinvoice N
cof_serienfentrada numeric 10 √ NULL::numeric
infnfe_id varchar 44 √ null
cof_deleteinvoice bpchar 22 √ NULL::bpchar
cof_freightamt numeric 0 √ (0)::numeric
cof_otheramt numeric 0 √ (0)::numeric
cof_insuranceamt numeric 0 √ (0)::numeric
cof_modfrete bpchar 1 '1'::bpchar
cof_sourceinvoice_id numeric 10 √ null
c_invoice.c_invoice_id cofsourceinvoice_cinvoice R
cof_c_custody_id numeric 10 √ NULL::numeric
cof_c_custody.cof_c_custody_id cofccustody_cinvoice R
cof_payfrom_location_id numeric 10 √ NULL::numeric
c_bpartner_location.c_bpartner_location_id cofpayfromlocation_cinvoice R
cof_composescashflow bpchar 1 √ 'Y'::bpchar
cof_tipoexportacao bpchar 1 √ NULL::bpchar
cof_ufsaidapais varchar 2 √ NULL::character varying
cof_xlocexporta varchar 60 √ NULL::character varying
cof_xlocdespacho varchar 60 √ NULL::character varying
cof_customercpf varchar 14 √ NULL::character varying
cof_processing2 bpchar 1 √ NULL::bpchar
cof_procprintinvoice bpchar 1 √ NULL::bpchar
cof_orgst_id numeric 10 √ NULL::numeric
cof_orgst.cof_orgst_id coforgst_cinvoice R
cof_isindustrialization bpchar 1 √ 'N'::bpchar
cof_datescheduled timestamp 29,6 √ null
cof_c_planofinanceiro_id numeric 10 √ NULL::numeric
cof_c_planofinanceiro.cof_c_planofinanceiro_id cofcplanofinanceiro_cinvoice R
cof_exibiremrelatorios bpchar 1 √ 'Y'::bpchar
lbr_isowndocument bpchar 1 √ 'Y'::bpchar
lbr_hasfiscaldocument bpchar 1 √ 'Y'::bpchar
cof_criadopeloimportadorxml bpchar 1 √ 'N'::bpchar
cof_despesaantecipada bpchar 1 'N'::bpchar
cof_qtdamortizacao numeric 10 √ '1'::numeric
cof_datainicialamortizacao timestamp 29,6 √ null
c_elementvalue_id numeric 10 √ null
c_validcombination.c_validcombination_id celementvalue_cinvoice R
pag_vtroco numeric 0 √ '0'::numeric
cof_situacaocomercial varchar 4 √ NULL::character varying
cof_invoice_id numeric 10 √ NULL::numeric
c_invoice.c_invoice_id cofinvoice_cinvoice R
cof_fatorfinanceiro numeric 0 √ '0'::numeric
cof_docautomatico bpchar 1 √ 'N'::bpchar
cof_ref_order_id numeric 10 √ NULL::numeric
c_order.c_order_id cofreforder_cinvoice R
cof_contract_id numeric 10 √ NULL::numeric
cof_contract.cof_contract_id cofcontract_cinvoice R
cof_digitador_id numeric 10 √ NULL::numeric
ad_user.ad_user_id cofdigitador_cinvoice R
cof_bpespecialista_id numeric 10 √ NULL::numeric
c_bpartner.c_bpartner_id cofbpespecialista_cinvoice R
cof_faturacf_id numeric 10 √ NULL::numeric
cof_sequenciadocumento numeric 0 √ '0'::numeric
cof_processing bpchar 1 √ null
cof_processing3 bpchar 1 √ NULL::bpchar
trxname varchar 60 √ NULL::character varying
relatedinvoice_id numeric 10 √ NULL::numeric
c_invoice.c_invoice_id relatedinvoice_cinvoice R
cof_nomeconsumidor varchar 255 √ NULL::character varying
cof_isreversal bpchar 1 √ NULL::bpchar
isoverridecurrencyrate bpchar 1 'N'::bpchar
currencyrate numeric 0 √ null
createlinesfrom bpchar 1 √ NULL::bpchar
cof_isremessaindustrializacaoprestador bpchar 1 √ 'N'::bpchar
cof_isentradampprestador bpchar 1 √ 'N'::bpchar

Indexes

Constraint Name Type Sort Column(s)
c_invoice_pkey Primary key Asc c_invoice_id
c_invoice_documentno Must be unique Asc/Asc/Asc documentno + c_doctype_id + c_bpartner_id
c_invoice_documentno_target Must be unique Asc/Asc/Asc c_bpartner_id + documentno + c_doctypetarget_id
c_invoice_order Performance Asc c_order_id
c_invoice_paid Performance Asc/Asc ispaid + ad_client_id
c_invoice_uu_idx Must be unique Asc c_invoice_uu
idxc_invoice_proc_on Performance Asc/Asc/Asc/Asc posted + processed + processedon + ad_client_id

Check Constraints

Constraint Name Constraint
c_invoice_cof_docautomatico_check ((cof_docautomatico = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_invoice_isdiscountprinted_check ((isdiscountprinted = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_invoice_generateto_check ((generateto = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_invoice_processed_check ((processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_invoice_lbr_hasfiscaldocument_check ((lbr_hasfiscaldocument = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_invoice_cof_isentradampprestador_check ((cof_isentradampprestador = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_invoice_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_invoice_createfrom_check ((createfrom = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_invoice_isprinted_check ((isprinted = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_invoice_cof_isindustrialization_check ((cof_isindustrialization = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_invoice_ispaid_check ((ispaid = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_invoice_istaxincluded_check ((istaxincluded = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_invoice_cof_isreversal_check ((cof_isreversal = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_invoice_isoverridecurrencyrate_check ((isoverridecurrencyrate = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_invoice_isfixedassetinvoice_check ((isfixedassetinvoice = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_invoice_cof_exibiremrelatorios_check ((cof_exibiremrelatorios = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_invoice_isapproved_check ((isapproved = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_invoice_cof_composescashflow_check ((cof_composescashflow = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_invoice_cof_criadopeloimportadorxml_check ((cof_criadopeloimportadorxml = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_invoice_cof_despesaantecipada_check ((cof_despesaantecipada = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_invoice_issotrx_check ((issotrx = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_invoice_lbr_isowndocument_check ((lbr_isowndocument = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_invoice_cof_isremessaindustrializacaoprestador_check ((cof_isremessaindustrializacaoprestador = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_invoice_istransferred_check ((istransferred = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation