View source | Discuss this page | Page history | Printable version   

ERP 2.50:Developers Guide/Database Model/org.openbravo.model.project/C Project

ERP 2.50:Developers Guide/Database Model/org.openbravo.model.project

Index

Contents

C_Project

Contains the Value, Name and Description for each project. It also defines and tracks the amounts assigned to, committed to and used for this project. This tab is used in order to introduce information regarding a project: Address, status, …

This table contains the following columns:

Name Nullable Data Type Description
C_Project_ID NVARCHAR2(32)Identifier of a project defined within the Project & Service Management module.
AD_Client_ID NVARCHAR2(32)Client for this installation.
AD_Org_ID NVARCHAR2(32)Organizational entity within client
IsActive NCHAR(1)A flag indicating whether this record is available for use or de-activated.
Created NDATERecord create date
CreatedBy NVARCHAR2(32)User who created this records
Updated NDATEx not implemented
UpdatedBy NVARCHAR2(32)User who updated this records
Value NNVARCHAR2(40)A fast method for finding a particular record.
Name NNVARCHAR2(60)A non-unique identifier for a record/document often used as a search tool.
Description YNVARCHAR2(255)A space to write additional related information.
Note YNVARCHAR2(2000)A space to write additional related information.
IsSummary NCHAR(1)A means of grouping fields in order to view or hide additional information.
AD_User_ID YVARCHAR2(32)An acquaintance to reach for information related to the business partner.
C_BPartner_ID YVARCHAR2(32)Anyone who takes part in daily business operations by acting as a customer, employee, etc.
C_BPartner_Location_ID YVARCHAR2(32)The location of the selected business partner.
POReference YNVARCHAR2(20)A reference or document order number as listed in business partner application.
C_PaymentTerm_ID YVARCHAR2(32)The setup and timing defined to complete a specified payment.
C_Currency_ID NVARCHAR2(32)An accepted medium of monetary exchange that may vary across countries.
Createtemppricelist NCHAR(1)This option permits to indicate if a temporary price list will be created.
M_PriceList_Version_ID YVARCHAR2(32)A price list with a specified validity range.
C_Campaign_ID YVARCHAR2(32)An advertising effort aimed at increasing sales.
IsCommitment NCHAR(1)Is this document a (legal) commitment?
PlannedAmt NNUMBERThe monetary sum expected to be involved for a transaction line.
PlannedQty NNUMBERThe expected or provisional quantity to be involved for a transaction line.
PlannedMarginAmt NNUMBERThe expected or provisional margin to be earned due to this transaction.
CommittedAmt NNUMBERThe maximum legal monetary price a project may be billed for.
DateContract YDATEThe planned end data is when a contract is registered into the application.
DateFinish YDATEThe date that a task, process, or action is to be completed or delivered by.
GenerateTo YCHAR(1)Generate To
Processed NCHAR(1)A confirmation that the associated documents or requests are processed.
SalesRep_ID YVARCHAR2(32)The person in charge of a document.
CopyFrom YCHAR(1)An addition of statements from pre-existing documents.
C_ProjectType_ID YVARCHAR2(32)Project Type is a template of a common project.
CommittedQty NNUMBERThe maximum legal quantity for a project.
InvoicedAmt NNUMBERThe monetary sum that is invoiced for a specified item or service.
InvoicedQty NNUMBERThe total number of a product included in an invoice to a business partner.
ProjectBalanceAmt NNUMBERTotal Project Balance
C_Phase_ID YVARCHAR2(32)One section or part of a project which is potentially made up of one or many tasks.
C_ProjectPhase_ID YVARCHAR2(32)One section or part of a project which is potentially made up of one or many tasks.
IsCommitCeiling NCHAR(1)An indication that the highest possible contract amount and quantity are being charged (may depend on government regulations.
M_Warehouse_ID YVARCHAR2(32)The location where products arrive to or are sent from.
ProjectCategory YVARCHAR2(60)Project Category
Processing YCHAR(1)A request to process the respective document or task.
Publicprivate YVARCHAR2(60)null
Projectstatus YVARCHAR2(60)Indicates the current status of the project.
Projectkind YVARCHAR2(60)A distinct work characteristic used for processes.
BillTo_ID YVARCHAR2(32)The location where the invoice payment request will be sent.
Projectphase YVARCHAR2(60)null
GenerateOrder YCHAR(1)Generate Order
ChangeProjectStatus YVARCHAR2(60)null
C_Location_ID YVARCHAR2(32)A specific place or residence.
M_PriceList_ID YVARCHAR2(32)A catalog of selected items with prices defined generally or for a specific partner.
PaymentRule YVARCHAR2(60)The method used for payment of this transaction.
Invoice_ToProject YCHAR(1)null
PlannedPOAmt YNUMBERnull
LastPlannedProposalDate YDATEnull
Document_Copies YNUMBERThe number of copies of each document that will be printed.
AccountNo YNVARCHAR2(20)Account Number
Expexpenses YNUMBERnull
Expmargin YNUMBERnull
Expreinvoicing YNUMBERnull
Responsible_ID YVARCHAR2(32)An employee that is responsible for the project.
Servcost YNUMBERnull
Servmargin YNUMBERnull
Servrevenue YNUMBERnull
Setprojecttype YCHAR(1)Set Project Type and for Service Projects copy Phases and Tasks of Project Type into Project
Startdate YDATEA parameter stating when a specified request will begin.
Servsercost YNUMBERnull
Servoutcost YNUMBERnull
FIN_Paymentmethod_ID YVARCHAR2(32)It is the method by which payment is expected to be made or received.

Other Info

Check constraints

These are the check constraints for this table:

top

Indexes

These are the indexes for this table (for each index there is a list of all the columns included within it):

Unique

top

Columns

Project

Identifier of a project defined within the Project & Service Management module.

top

Client

Foreign key column to AD_Client table, (column: AD_Client_ID)

top

Organization

Foreign key column to AD_Org table, (column: AD_Org_ID)


Validation Rule AD_Org Trx Security validation: null. With the following code:

 
AD_Org.AD_Org_ID<> '0' AND AD_Org.IsReady='Y'

Callout: SL_Project_Type

This element is linked to a callout.

It is implemented by org.openbravo.erpCommon.ad_callouts.SL_Project_Type Java class.

top

Active

There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reporting. There are two reasons for de-activating and not deleting records:
(1) The system requires the record for auditing purposes.
(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are existing invoices for it. By de-activating the Business Partner you prevent it from being used in future transactions.

top

Created

Date when project was added to Project List

top

Created By

Foreign key column to AD_User table, (column: AD_User_ID)

top

Updated

The Updated field indicates the date that this record was updated.

top

Updated By

Foreign key column to AD_User table, (column: AD_User_ID)

top

Search Key

A search key allows for a fast method of finding a particular record. If you leave the search key empty, the system automatically creates a numeric number originating from a document sequence defined in the "Document Sequence" window. The sequence naming convention follows a rule "DocumentNo_TableName", where TableName is the actual name of the database table (e.g. C_Order).

Usually, company's internal identifiers for various records (products, customers, etc) are stored here.

top

Name

A more descriptive identifier (that does need to be unique) of a record/document that is used as a default search option along with the search key (that is unique and mostly shorter). It is up to 60 characters in length.

top

Description

A description is limited to 255 characters.

top

Comments

The Note field allows for optional entry of user defined information regarding this record

top

Summary Level

A summary entity represents a branch in a tree rather than an end-node. Summary entities are used for reporting and do not have own values.

top

User/Contact

Foreign key column to AD_User table, (column: AD_User_ID)


Validation Rule AD_User C_BPartner User/Contacts: null. With the following code:

 
AD_User.C_BPartner_ID=@C_BPartner_ID@

top

Business Partner

Foreign key column to C_BPartner table, (column: C_BPartner_ID)

Callout: SE_Project_BPartner

This element is linked to a callout.

It is implemented by org.openbravo.erpCommon.ad_callouts.SE_Project_BPartner Java class.

top

Partner Address

Foreign key column to C_BPartner_Location table, (column: C_BPartner_Location_ID)


Validation Rule C_BPartner Location - Ship To: null. With the following code:

 
C_BPartner_Location.C_BPartner_ID=@C_BPartner_ID@ AND C_BPartner_Location.IsShipTo='Y' AND C_BPartner_Location.IsActive='Y'

top

Order Reference

This can be used to input a reference for this specific transaction. For example, a Purchase Order number can be input on a Sales Order for easier reference.

top

Payment Terms

Foreign key column to C_PaymentTerm table, (column: C_PaymentTerm_ID)

top

Currency

Foreign key column to C_Currency table, (column: C_Currency_ID)

top

Create Temporary Price List

This option permits to indicate if a temporary price list will be created for the current project when changing its status to 'Order'.

top

Price List Version

Foreign key column to M_PriceList_Version table, (column: M_PriceList_Version_ID)

top

Sales Campaign

Foreign key column to C_Campaign table, (column: C_Campaign_ID)

top

Legally Binding Contract

Commitment indicates if the document is legally binding.

top

Planned Amount

The Planned Amount indicates the anticipated amount for this project or project line.

top

Planned Quantity

The Planned Quantity indicates the anticipated quantity for this project or project line

top

Planned Margin

The Planned Margin Amount indicates the anticipated margin amount for this project or project line.

top

Contract Amount

The commitment amount is independent from the planned amount. You would use the planned amount for your realistic estimation, which might be higher or lower than the commitment amount.

top

Contract Date

The planned end date is used to determine when the document becomes effective. This is usually the contract date. The planned end date is used in reports and report parameters.

top

Ending Date

The real end date is used to indicate when the project is expected to be completed or has been completed.

top

Generate To

A button that creates documents

top

Processed

The Processed checkbox indicates that a document has been processed.

top

Sales Representative

Foreign key column to AD_User table, (column: AD_User_ID)


Reference Table AD_User SalesRep With the following where clause:

 
EXISTS (SELECT * FROM C_BPartner bp WHERE AD_User.C_BPartner_ID=bp.C_BPartner_ID AND bp.IsSalesRep='Y')


top

Copy from

Copy lines (products) from another document of the same type.

top

Project Type

Foreign key column to C_ProjectType table, (column: C_ProjectType_ID)

top

Contract Quantity

The commitment amount is independent from the planned amount. You would use the planned amount for your realistic estimation, which might be higher or lower than the commitment amount.

top

Invoice Amount

The amount invoiced

top

Invoice Quantity

The Quantity Invoiced

top

Project Balance

The project balance is the sum of all invoices and payments

top

Standard Phase

Foreign key column to C_Phase table, (column: C_Phase_ID)


Validation Rule C_Phase of Project Type: null. With the following code:

 
C_Phase.C_ProjectType_ID=@C_ProjectType_ID@

top

Current Phase

Phase of the project with standard performance information with standard work

Foreign key column to C_ProjectPhase table, (column: C_ProjectPhase_ID)


Validation Rule C_ProjectPhase of Project: null. With the following code:

 
C_ProjectPhase.C_Project_ID=@C_Project_ID@

top

Price Ceiling

The commitment amount and quantity is the maximum amount and quantity to be charged. Ignored, if the amount or quantity is zero.

top

Warehouse

The Warehouse identifies a unique Warehouse where products are stored or Services are provided.

Foreign key column to M_Warehouse table, (column: M_Warehouse_ID)

top

Project Category

The Project Category determines the behavior of the project:General - no special accounting, e.g. for Presales or general trackingService - no special accounting, e.g. for Service/Charge projectsWork Order - creates Project/Job WIP transactions - abili

List values: C_ProjectType Category

The allowed values for this list are:

top

Process Now

When this field is set as 'Y' a process is being performed on this record.

top

Initiative Type

A public or private enterprise. This are the most typical initiatives

List values: PublicPrivate

The allowed values for this list are:

top

Project Status

Indicates the current status of the project. There are normally three:
Open: The budget is sent. The project has not been won yet.
Order: The project has been won by a partner we have sent a budget.
Order closed: All the products agreed have been delivered.

List values: ProjectStatus

The allowed values for this list are:

top

Work Type

Indicates the kind of work

List values: Projectkind

The allowed values for this list are:

top

Invoice Address

Foreign key column to C_BPartner_Location table, (column: C_BPartner_Location_ID)


Reference Table C_BPartner Location


Validation Rule C_BPartner Location - Bill To: null. With the following code:

 
C_BPartner_Location.C_BPartner_ID=@C_BPartner_ID@ AND C_BPartner_Location.IsBillTo='Y' AND C_BPartner_Location.IsActive='Y'

top

Phase

Different phases for a project

List values: Projectphase

The allowed values for this list are:

top

Generate Order

This process lets you to generate a purchase order to this project.

top

Change Project Status

This process changes the status of this projecto.

top

Location / Address

Foreign key column to C_Location table, (column: C_Location_ID)

top

Price List

Foreign key column to M_PriceList table, (column: M_PriceList_ID)

Callout: SL_Project_PriceList

This element is linked to a callout.

It is implemented by org.openbravo.erpCommon.ad_callouts.SL_Project_PriceList Java class.

top

Form of Payment

Form of Payment indicates the method of payment used for this transaction (eg. cash, wire transfer, etc.)

List values: All_Payment Rule

The allowed values for this list are:

top

Invoice to Project

This option indicates if the invoices has been sent to the winner are "Origen invoices"

top

Planned po Amount

Planned amount for the purchase order

top

Last planned proposal date

Last day of following up the budget for the project

top

Number of Copies

Number of copies

top

Account Number

The Account Number indicates the Number assigned to this account

top

Planned Expenses

Callout: SL_Project_Margin

This element is linked to a callout.

It is implemented by org.openbravo.erpCommon.ad_callouts.SL_Project_Margin Java class.

top

Expenses Margin %

Expected margin for expenses.

Callout: SL_Project_Margin

This element is linked to a callout.

It is implemented by org.openbravo.erpCommon.ad_callouts.SL_Project_Margin Java class.

top

Reinvoiced Expenses

Amount of expenses we plan to invoice back to the client. Real number will originate from sales invoices for this particular client and project that include products of type "expense" (such as telephone, electricity, etc)

Callout: SL_Project_Margin

This element is linked to a callout.

It is implemented by org.openbravo.erpCommon.ad_callouts.SL_Project_Margin Java class.

top

Person in Charge

Foreign key column to C_BPartner table, (column: C_BPartner_ID)


Reference Table Responsible employee With the following where clause:

 
C_BPartner.IsEmployee = 'Y'


top

Total Service Cost

Expected total cost of services provided. The real number will originate from all expense sheets (lines marked as Time Sheet) related to this project.

Callout: SL_Project_Margin

This element is linked to a callout.

It is implemented by org.openbravo.erpCommon.ad_callouts.SL_Project_Margin Java class.

top

Service Margin %

Expected service margin. Real number will be calculated from actual service revenue and costs.

Callout: SL_Project_Margin

This element is linked to a callout.

It is implemented by org.openbravo.erpCommon.ad_callouts.SL_Project_Margin Java class.

top

Service Revenue

Expected revenue of services provided to the client. Real numbers will originate from invoices of services (products of type "service") sent out to the client.

Callout: SL_Project_Margin

This element is linked to a callout.

It is implemented by org.openbravo.erpCommon.ad_callouts.SL_Project_Margin Java class.

top

Set Project Type

Set Project Type and for Service Projects copy Phases and Tasks of Project Type into Project

top

Starting Date

A parameter stating when a specified request will begin.

top

Services Provided Cost

Expected cost of services provided. The real number will originate from all expense sheets (lines marked as Time Sheet) related to this project.

Callout: SL_Project_Service

This element is linked to a callout.

It is implemented by org.openbravo.erpCommon.ad_callouts.SL_Project_Service Java class.

top

Outsourced Cost

Expected cost of services outsourced. The real number will originate from all expense sheets (lines marked as Time Sheet) related to this project.

Callout: SL_Project_Service

This element is linked to a callout.

It is implemented by org.openbravo.erpCommon.ad_callouts.SL_Project_Service Java class.

top

Payment Method

Foreign key column to FIN_Paymentmethod table, (column: Fin_Paymentmethod_ID)


Validation Rule FIN_PaymentMethodsWithAccount: Filters only the payment methods that belong to a financial account. With the following code:

 
EXISTS (SELECT 1 FROM FIN_FinAcc_PaymentMethod fapm WHERE FIN_PaymentMethod.FIN_PaymentMethod_ID=fapm.FIN_PaymentMethod_ID)

top

Related tables

Tables that link this table:

top

Retrieved from "http://wiki.openbravo.com/wiki/ERP_2.50:Developers_Guide/Database_Model/org.openbravo.model.project/C_Project"

This page has been accessed 6,597 times. This page was last modified on 14 June 2011, at 11:04. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.