c_project

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
c_project_id numeric 10 null
a_asset.c_project_id cproject_aasset R
a_asset_addition.c_project_id cproject_aassetaddition R
c_acctschema_element.c_project_id cproject_caschemaelement R
c_cash.c_project_id cproject_ccash R
c_cashplan.c_project_id cproject_ccashplan R
c_cashplanline.c_project_id cproject_ccashplanline R
c_dunning_line_v.c_project_id Implied Constraint R
c_dunning_line_vt.c_project_id Implied Constraint R
c_invoice.c_project_id cproject_cinvoice R
c_invoice_header_v.c_project_id Implied Constraint R
c_invoice_header_vt.c_project_id Implied Constraint R
c_invoice_v.c_project_id Implied Constraint R
c_invoice_v1.c_project_id Implied Constraint R
c_invoicebatchline.c_project_id cproject_cinvoicebatchline R
c_invoiceline.c_project_id cproject_cinvoiceline R
c_invoiceline_v.c_project_id Implied Constraint R
c_order.c_project_id cproject_corder R
c_order_header_v.c_project_id Implied Constraint R
c_order_header_vt.c_project_id Implied Constraint R
c_orderline.c_project_id cproject_corderline R
c_payment.c_project_id cproject_cpayment R
c_payment_v.c_project_id Implied Constraint R
c_paymenttransaction.c_project_id cproject_cpaymenttransaction R
c_payselection_check_v.c_project_id Implied Constraint R
c_payselection_check_vt.c_project_id Implied Constraint R
c_payselection_remittance_v.c_project_id Implied Constraint R
c_payselection_remittance_vt.c_project_id Implied Constraint R
c_project_acct.c_project_id c_project_projectacct C
c_project_details_v.c_project_id Implied Constraint R
c_project_details_vt.c_project_id Implied Constraint R
c_project_header_v.c_project_id Implied Constraint R
c_project_header_vt.c_project_id Implied Constraint R
c_projectissue.c_project_id cproject_cprojectissue R
c_projectline.c_project_id cproject_cprojectline C
c_projectphase.c_project_id cproject_cprojectphase R
c_recurring.c_project_id cproject_crecurring R
c_recurring_run.c_project_id cproject_crecurringrun R
c_validcombination.c_project_id cproject_vc R
cof_c_acct_ignoreelement.c_project_id cproject_cofcacctignoreelement R
cof_configrateiolinha.c_project_id cproject_cofconfigrateiolinha R
cof_contract.c_project_id cproject_cofcontract R
cof_orcamentoconfig.c_project_id cproject_coforcamentoconfig R
cof_ordemservico.c_project_id cproject_cofordemservico R
cof_preferenciaxml.c_project_id cproject_cofpreferenciaxml R
cof_rv_detalhesordemservico.c_project_id Implied Constraint R
cof_rv_detalhesordemservicoapontamento.c_project_id Implied Constraint R
cof_rv_detalhesproducao.c_project_id Implied Constraint R
cof_rv_itenspago.c_project_id Implied Constraint R
cof_rv_mapa_pedido.c_project_id Implied Constraint R
cof_rv_ordemservico.c_project_id Implied Constraint R
cof_rv_requestpartner.c_project_id Implied Constraint R
dd_order.c_project_id cproject_ddorder R
dd_order_header_v.c_project_id Implied Constraint R
dd_order_header_vt.c_project_id Implied Constraint R
dd_orderline.c_project_id cproject_ddorderline R
fact_acct.c_project_id c_project_fact_acct R
fact_acct_balance.c_project_id Implied Constraint R
fact_acct_summary.c_project_id cproject_factacctsummary R
gl_distribution.c_project_id cproject_gldist R
gl_distributionline.c_project_id cproject_gldistline R
gl_journalline.c_project_id cproject_gljournalline R
gl_journalline_acct_v.c_project_id Implied Constraint R
hr_contract.c_project_id cproject_hrcontract R
hr_movement.c_project_id cproject_hrmovement R
i_fajournal.c_project_id cproject_ifajournal R
i_gljournal.c_project_id cproject_igljournal N
i_invoice.c_project_id cproject_iinvoice N
i_movement.c_project_id cproject_imovement R
i_order.c_project_id cproject_iorder N
m_inout.c_project_id cproject_minout R
m_inout_header_v.c_project_id Implied Constraint R
m_inout_header_vt.c_project_id Implied Constraint R
m_inout_line_v.c_project_id Implied Constraint R
m_inout_line_vt.c_project_id Implied Constraint R
m_inoutline.c_project_id cproject_minoutline R
m_inventory.c_project_id cproject_minventory R
m_movement.c_project_id cproject_mmovement R
m_production.c_project_id cproject_mproduction R
m_productionline.c_project_id cproject_mproductionline R
m_transaction_v.c_project_id Implied Constraint R
pa_documentstatus.c_project_id cproject_padocumentstatus R
pa_reportcolumn.c_project_id cproject_pareportcolumn R
pa_reportsource.c_project_id cproject_pareportsource R
pp_cost_collector.c_project_id cproject_ppcostcollector R
pp_order.c_project_id cproject_pporder R
pp_order_bom_header_v.c_project_id Implied Constraint R
pp_order_bom_header_vt.c_project_id Implied Constraint R
pp_order_header_v.c_project_id Implied Constraint R
pp_order_header_vt.c_project_id Implied Constraint R
pp_order_workflow_header_v.c_project_id Implied Constraint R
pp_order_workflow_header_vt.c_project_id Implied Constraint R
r_issueproject.c_project_id cproject_rissueproject R
r_request.c_project_id cproject_rrequest R
r_request_v.c_project_id Implied Constraint R
r_requestaction.c_project_id cproject_rrequestaction R
rv_bpartneropen.c_project_id Implied Constraint R
rv_c_invoice.c_project_id Implied Constraint R
rv_c_invoiceline.c_project_id Implied Constraint R
rv_cof_detalhesestoquefisico.c_project_id Implied Constraint R
rv_commissionrundetail.c_invoice_c_project_id Implied Constraint R
rv_commissionrundetail.c_invoiceline_c_project_id Implied Constraint R
rv_commissionrundetail.c_order_c_project_id Implied Constraint R
rv_commissionrundetail.c_orderline_c_project_id Implied Constraint R
rv_dd_orderdetail.c_project_id Implied Constraint R
rv_fact_acct.c_project_id Implied Constraint R
rv_fact_acct_day.c_project_id Implied Constraint R
rv_fact_acct_period.c_project_id Implied Constraint R
rv_fact_simple.c_project_id Implied Constraint R
rv_inoutdetails.c_project_id Implied Constraint R
rv_inoutdetails.m_inoutline_c_project_id Implied Constraint R
rv_invoicepayschedule.c_project_id Implied Constraint R
rv_openitem.c_project_id Implied Constraint R
rv_openitemtodate.c_project_id Implied Constraint R
rv_orderdetail.c_order_c_project_id Implied Constraint R
rv_orderdetail.c_project_id Implied Constraint R
rv_payment.c_project_id Implied Constraint R
rv_pp_order.c_project_id Implied Constraint R
rv_projectlineissue.c_project_id Implied Constraint R
rv_transaction.c_project_id Implied Constraint R
rv_transaction.m_inoutline_c_project_id Implied Constraint R
s_timeexpenseline.c_project_id cproject_stimeexpenseline R
t_aging.c_project_id cproject_taging C
t_cashflow.c_project_id Implied Constraint R
t_invoicegl_v.c_project_id Implied Constraint R
t_rv_reconciliation.c_project_id Implied Constraint R
t_transaction.c_project_id Implied Constraint R
t_trialbalance.c_project_id Implied Constraint R
ad_client_id numeric 10 null
ad_client.ad_client_id adclient_cproject R
ad_org_id numeric 10 null
ad_org.ad_org_id adorg_cproject R
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
value varchar 40 null
name varchar 60 null
description varchar 255 √ null
note varchar 2000 √ null
issummary bpchar 1 'N'::bpchar
ad_user_id numeric 10 √ null
ad_user.ad_user_id aduser_cproject N
c_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id cbpartner_cproject R
c_bpartner_location_id numeric 10 √ null
c_bpartner_location.c_bpartner_location_id cbplocation_cproject R
poreference varchar 20 √ null
c_paymentterm_id numeric 10 √ null
c_paymentterm.c_paymentterm_id cpaymentterm_cproject R
c_currency_id numeric 10 null
c_currency.c_currency_id ccurrency_cproject R
m_pricelist_version_id numeric 10 √ null
m_pricelist_version.m_pricelist_version_id mpricelistversion_cproject R
c_campaign_id numeric 10 √ null
c_campaign.c_campaign_id ccampaign_cproject R
iscommitment bpchar 1 'Y'::bpchar
plannedamt numeric 0 0
plannedqty numeric 0 0
plannedmarginamt numeric 0 0
committedamt numeric 0 0
datecontract timestamp 29,6 √ null
datefinish timestamp 29,6 √ null
generateto bpchar 1 √ null
processed bpchar 1 'N'::bpchar
salesrep_id numeric 10 √ null
ad_user.ad_user_id aduser_sr_cproject R
copyfrom bpchar 1 √ null
c_projecttype_id numeric 10 √ null
c_projecttype.c_projecttype_id cprojecttype_cproject R
committedqty numeric 0 0
invoicedamt numeric 0 0
invoicedqty numeric 0 0
projectbalanceamt numeric 0 0
c_phase_id numeric 10 √ null
c_phase.c_phase_id cphase_cproject R
iscommitceiling bpchar 1 'N'::bpchar
m_warehouse_id numeric 10 √ null
m_warehouse.m_warehouse_id mwarehouse_cproject R
projectcategory bpchar 1 √ 'N'::bpchar
processing bpchar 1 √ null
c_bpartnersr_id numeric 10 √ null
c_bpartner.c_bpartner_id cbpartnersr_cproject R
projinvoicerule bpchar 1 '-'::bpchar
projectlinelevel bpchar 1 'P'::bpchar
c_project_uu varchar 36 √ NULL::character varying
ad_orgtrx_id numeric 10 √ NULL::numeric
ad_org.ad_org_id adorgtrx_cproject R
c_activity_id numeric 10 √ NULL::numeric
c_activity.c_activity_id cactivity_cproject R

Indexes

Constraint Name Type Sort Column(s)
c_project_pkey Primary key Asc c_project_id
c_project_uu_idx Must be unique Asc c_project_uu
c_project_value Must be unique Asc/Asc ad_client_id + value

Check Constraints

Constraint Name Constraint
c_project_generateto_check ((generateto = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_project_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_project_processed_check ((processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_project_iscommitment_check ((iscommitment = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation