View idempiere9.adempiere.rv_projectcycle
Project Cycle

 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
ad_client_id numeric 10  √  null Client/Tenant for this installation.
ad_org_id numeric 10  √  null Organizational entity within client
isactive bpchar 1  √  null The record is active in the system
created timestamp 29,6  √  null Date this record was created
createdby numeric 10  √  null User who created this records
updated timestamp 29,6  √  null Date this record was updated
updatedby numeric 10  √  null User who updated this records
c_cycle_id numeric 10  √  null Identifier for this Project Reporting Cycle
cyclename varchar 60  √  null Name of the Project Cycle
c_currency_id numeric 10  √  null The Currency for this record
c_cyclestep_id numeric 10  √  null The step for this Cycle
cyclestepname varchar 60  √  null Name of the Project Cycle Step
seqno numeric 10  √  null Method of ordering records; lowest number comes first
relativeweight numeric 0  √  null Relative weight of this step (0 = ignored)
c_phase_id numeric 10  √  null Standard Phase of the Project Type
projectphasename varchar 60  √  null Name of the Project Phase
c_projecttype_id numeric 10  √  null Type of the project
projecttypename varchar 60  √  null Name of the Project Type
projectvalue varchar 40  √  null Key of the Project
projectname varchar 60  √  null Name of the Project
description varchar 255  √  null Optional short description of the record
note varchar 2000  √  null Optional additional user defined information
c_bpartner_id numeric 10  √  null Identifies a Business Partner
c_bpartner_location_id numeric 10  √  null Identifies the (ship to) address for this Business Partner
ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
salesrep_id numeric 10  √  null Sales Representative or Company Agent
m_warehouse_id numeric 10  √  null Storage Warehouse and Service Point
projectcategory bpchar 1  √  null Project Category
datecontract timestamp 29,6  √  null The (planned) effective date of this document.
datefinish timestamp 29,6  √  null Finish or (planned) completion date
iscommitment bpchar 1  √  null Is this document a (legal) commitment?
iscommitceiling bpchar 1  √  null The commitment amount/quantity is the chargeable ceiling
committedqty numeric 0  √  null The (legal) commitment Quantity
committedamt numeric 0  √  null The (legal) commitment amount
plannedqty numeric 0  √  null Planned quantity for this project
plannedamt numeric 0  √  null Planned amount for this project
plannedmarginamt numeric 0  √  null Project's planned margin amount
invoicedamt numeric 0  √  null The amount invoiced
invoicedqty numeric 0  √  null The quantity invoiced
projectbalanceamt numeric 0  √  null Total Project Balance

Analyzed at 2021-12-25 14:43 +0100