Table idempiere11.adempiere.c_project
Financial 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_validcombination.c_project_id cproject_vc 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
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
c_bpartner_location.c_bpartner_location_id cbplocation_cproject R
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
c_paymentterm.c_paymentterm_id cpaymentterm_cproject R
The terms of Payment (timing, discount)
c_currency_id numeric 10
c_currency.c_currency_id ccurrency_cproject R
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
m_warehouse.m_warehouse_id mwarehouse_cproject R
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 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 2024-01-03 13:47 +0100

Indexes:
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: