Table idempiere11.adempiere.c_project
Financial Project

 Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
c_project_id numeric 10
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 R
c_validcombination.c_project_id cproject_vc 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
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
Financial Project
ad_client_id numeric 10
ad_client.ad_client_id adclient_cproject R
Tenant for this installation.
ad_org_id numeric 10
ad_org.ad_org_id adorg_cproject R
Organizational entity within tenant
isactive bpchar 1 'Y'::bpchar The record is active in the system
created timestamp 29,6 now() Date this record was created
createdby numeric 10 User who created this records
updated timestamp 29,6 now() Date this record was updated
updatedby numeric 10 User who updated this records
value varchar 40 Search key for the record in the format required - must be unique
name varchar 60 Alphanumeric identifier of the entity
description varchar 255  √  null Optional short description of the record
note varchar 2000  √  null Optional additional user defined information
issummary bpchar 1 'N'::bpchar This is a summary entity
ad_user_id numeric 10  √  null
ad_user.ad_user_id aduser_cproject N
User within the system - Internal or Business Partner Contact
c_bpartner_id numeric 10  √  null
c_bpartner.c_bpartner_id cbpartner_cproject R
Identifies a Business Partner
c_bpartner_location_id numeric 10  √  null
c_bpartner_location.c_bpartner_location_id cbplocation_cproject R
Identifies the (ship to) address for this Business Partner
poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_paymentterm_id numeric 10  √  null
c_paymentterm.c_paymentterm_id cpaymentterm_cproject R
The terms of Payment (timing, discount)
c_currency_id numeric 10
c_currency.c_currency_id ccurrency_cproject R
The Currency for this record
m_pricelist_version_id numeric 10  √  null
m_pricelist_version.m_pricelist_version_id mpricelistversion_cproject R
Identifies a unique instance of a Price List
c_campaign_id numeric 10  √  null
c_campaign.c_campaign_id ccampaign_cproject R
Marketing Campaign
iscommitment bpchar 1 'Y'::bpchar Is this document a (legal) commitment?
plannedamt numeric 0 0 Planned amount for this project
plannedqty numeric 0 0 Planned quantity for this project
plannedmarginamt numeric 0 0 Project's planned margin amount
committedamt numeric 0 0 The (legal) commitment amount
datecontract timestamp 29,6  √  null The (planned) effective date of this document.
datefinish timestamp 29,6  √  null Finish or (planned) completion date
generateto bpchar 1  √  null Generate To
processed bpchar 1 'N'::bpchar The document has been processed
salesrep_id numeric 10  √  null
ad_user.ad_user_id aduser_sr_cproject R
Sales Representative or Company Agent
copyfrom bpchar 1  √  null Copy From Record
c_projecttype_id numeric 10  √  null
c_projecttype.c_projecttype_id cprojecttype_cproject R
Type of the project
committedqty numeric 0 0 The (legal) commitment Quantity
invoicedamt numeric 0 0 The amount invoiced
invoicedqty numeric 0 0 The quantity invoiced
projectbalanceamt numeric 0 0 Total Project Balance
c_phase_id numeric 10  √  null
c_phase.c_phase_id cphase_cproject R
Standard Phase of the Project Type
iscommitceiling bpchar 1 'N'::bpchar The commitment amount/quantity is the chargeable ceiling
m_warehouse_id numeric 10  √  null
m_warehouse.m_warehouse_id mwarehouse_cproject R
Storage Warehouse and Service Point
projectcategory bpchar 1  √  'N'::bpchar Project Category
processing bpchar 1  √  null Process Now
c_bpartnersr_id numeric 10  √  null
c_bpartner.c_bpartner_id cbpartnersr_cproject R
Business Partner (Agent or Sales Rep)
projinvoicerule bpchar 1 '-'::bpchar Invoice Rule for the project
projectlinelevel bpchar 1 'P'::bpchar Project Line Level
c_project_uu varchar 36  √  NULL::character varying C_Project_UU
ad_orgtrx_id numeric 10  √  NULL::numeric
ad_org.ad_org_id adorgtrx_cproject R
Performing or initiating organization
c_activity_id numeric 10  √  NULL::numeric
c_activity.c_activity_id cactivity_cproject R
Business Activity

Table contained 2 rows at 2024-01-03 13:44 +0100

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


SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.