Table idempiere9.adempiere.c_project
Financial Project

Generated by
Quality Systems & Solutions
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
c_projectphase.c_project_id cproject_cprojectphase R
c_validcombination.c_project_id cproject_vc 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
m_inout.c_project_id cproject_minout 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
Financial Project
ad_client_id numeric 10
ad_client.ad_client_id adclient_cproject R
Client/Tenant for this installation.
ad_org_id numeric 10
ad_org.ad_org_id adorg_cproject R
Organizational entity within client
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 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 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 The terms of Payment (timing, discount)
c_currency_id numeric 10 The Currency for this record
m_pricelist_version_id numeric 10  √  null 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 Sales Representative or Company Agent
copyfrom bpchar 1  √  null Copy From Record
c_projecttype_id numeric 10  √  null 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 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 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 2021-12-25 14:44 +0100

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

Close relationships  within of separation: