Table idempiere11.adempiere.c_projectphase
Phase of a 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
c_project.c_project_id cproject_cprojectphase R
Financial Project
ad_client_id numeric 10 Tenant for this installation.
ad_org_id numeric 10 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
description varchar 255  √  null Optional short description of the record
startdate timestamp 29,6  √  null First effective day (inclusive)
enddate timestamp 29,6  √  null Last effective date (inclusive)
iscomplete bpchar 1 'N'::bpchar It is complete
m_product_id numeric 10  √  null
m_product.m_product_id mproduct_cprojectphase R
Product, Service, Item
priceactual numeric 0  √  0 Actual Price
generateorder bpchar 1  √  null Generate Order
c_order_id numeric 10  √  null
c_order.c_order_id corder_cprojectphase R
Order
c_phase_id numeric 10  √  null
c_phase.c_phase_id cphase_cprojectphase R
Standard Phase of the Project Type
c_projectphase_id numeric 10
c_cashplanline.c_projectphase_id cprojectphase_ccashplanline R
c_invoiceline.c_projectphase_id cprojectphase_cinvoiceline N
c_orderline.c_projectphase_id cprojectphase_corderline N
c_projectline.c_projectphase_id cprojectphase_cprojectline N
c_projecttask.c_projectphase_id cprojectphase_cprojecttask C
fact_acct.c_projectphase_id cprojectphase_factacct N
fact_acct_summary.c_projectphase_id cprojectphase_factacctsummary R
hr_movement.c_projectphase_id cprojectphase_hrmovement R
m_inoutline.c_projectphase_id c_projectphase_minoutline R
m_production.c_projectphase_id cprojectphase_mproduction R
s_timeexpenseline.c_projectphase_id cprojectphase_stimeexpenseline R
Phase of a Project
help varchar 2000  √  null Comment or Hint
name varchar 60 Alphanumeric identifier of the entity
qty numeric 0  √  0 Quantity
seqno numeric 10 Method of ordering records; lowest number comes first
committedamt numeric 0 0 The (legal) commitment amount
iscommitceiling bpchar 1 'N'::bpchar The commitment amount/quantity is the chargeable ceiling
projinvoicerule bpchar 1  √  null Invoice Rule for the project
plannedamt numeric 0 0 Planned amount for this project
c_projectphase_uu varchar 36  √  NULL::character varying C_ProjectPhase_UU

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

Indexes:
Column(s) Type Sort Constraint Name
c_projectphase_id Primary key Asc c_projectphase_pkey
c_projectphase_uu Must be unique Asc c_projectphase_uu_idx


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.