c_projectphase

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
c_project_id numeric 10 null
c_project.c_project_id cproject_cprojectphase R
ad_client_id numeric 10 null
ad_org_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
description varchar 255 √ null
startdate timestamp 29,6 √ null
enddate timestamp 29,6 √ null
iscomplete bpchar 1 'N'::bpchar
m_product_id numeric 10 √ null
m_product.m_product_id mproduct_cprojectphase R
priceactual numeric 0 √ 0
generateorder bpchar 1 √ null
c_order_id numeric 10 √ null
c_order.c_order_id corder_cprojectphase R
c_phase_id numeric 10 √ null
c_phase.c_phase_id cphase_cprojectphase R
c_projectphase_id numeric 10 null
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
help varchar 2000 √ null
name varchar 60 null
qty numeric 0 √ 0
seqno numeric 10 null
committedamt numeric 0 0
iscommitceiling bpchar 1 'N'::bpchar
projinvoicerule bpchar 1 √ null
plannedamt numeric 0 0
c_projectphase_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
c_projectphase_pkey Primary key Asc c_projectphase_id
c_projectphase_c_order_id_idx Performance Asc c_order_id
c_projectphase_uu_idx Must be unique Asc c_projectphase_uu

Relationships

Close relationships within degrees of separation