rv_projectcycle

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10 √ null
ad_org_id numeric 10 √ null
isactive bpchar 1 √ null
created timestamp 29,6 √ null
createdby numeric 10 √ null
updated timestamp 29,6 √ null
updatedby numeric 10 √ null
c_cycle_id numeric 10 √ null
c_cycle.c_cycle_id Implied Constraint R
cyclename varchar 60 √ null
c_currency_id numeric 10 √ null
c_currency.c_currency_id Implied Constraint R
c_cyclestep_id numeric 10 √ null
c_cyclestep.c_cyclestep_id Implied Constraint R
cyclestepname varchar 60 √ null
seqno numeric 10 √ null
relativeweight numeric 0 √ null
c_phase_id numeric 10 √ null
c_phase.c_phase_id Implied Constraint R
projectphasename varchar 60 √ null
c_projecttype_id numeric 10 √ null
c_projecttype.c_projecttype_id Implied Constraint R
projecttypename varchar 60 √ null
projectvalue varchar 40 √ null
projectname varchar 60 √ null
description varchar 255 √ null
note varchar 2000 √ null
c_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id Implied Constraint R
c_bpartner_location_id numeric 10 √ null
c_bpartner_location.c_bpartner_location_id Implied Constraint R
ad_user_id numeric 10 √ null
poreference varchar 20 √ null
salesrep_id numeric 10 √ null
m_warehouse_id numeric 10 √ null
m_warehouse.m_warehouse_id Implied Constraint R
projectcategory bpchar 1 √ null
datecontract timestamp 29,6 √ null
datefinish timestamp 29,6 √ null
iscommitment bpchar 1 √ null
iscommitceiling bpchar 1 √ null
committedqty numeric 0 √ null
committedamt numeric 0 √ null
plannedqty numeric 0 √ null
plannedamt numeric 0 √ null
plannedmarginamt numeric 0 √ null
invoicedamt numeric 0 √ null
invoicedqty numeric 0 √ null
projectbalanceamt numeric 0 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views