c_project

-1 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_invoice.c_project_id cproject_cinvoice R
c_invoicebatchline.c_project_id cproject_cinvoicebatchline R
c_invoiceline.c_project_id cproject_cinvoiceline R
c_order.c_project_id cproject_corder R
c_orderline.c_project_id cproject_corderline R
c_payment.c_project_id cproject_cpayment R
c_paymenttransaction.c_project_id cproject_cpaymenttransaction R
c_project_acct.c_project_id c_project_projectacct C
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 C
c_validcombination.c_project_id cproject_vc R
cof_c_acct_ignoreelement.c_project_id cproject_cofcacctignoreelement R
cof_conciliacaocartao.c_project_id cproject_cofconciliacaocartao 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
dd_order.c_project_id cproject_ddorder R
dd_orderline.c_project_id cproject_ddorderline R
fact_acct.c_project_id c_project_fact_acct 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
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_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
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
r_issueproject.c_project_id cproject_rissueproject R
r_request.c_project_id cproject_rrequest R
r_requestaction.c_project_id cproject_rrequestaction R
s_timeexpenseline.c_project_id cproject_stimeexpenseline R
t_aging.c_project_id cproject_taging C
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_processed_check ((processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_project_generateto_check ((generateto = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_project_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_project_iscommitment_check ((iscommitment = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation