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

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

ERP 2.50:Developers Guide/Database Model/org.openbravo.model.project/C Phase ERP 2.50:Developers Guide/Database Model/org.openbravo.model.project/C Project ERP 2.50:Developers Guide/Database Model/org.openbravo.model.project/C ProjectIssue ERP 2.50:Developers Guide/Database Model/org.openbravo.model.project/C ProjectLine ERP 2.50:Developers Guide/Database Model/org.openbravo.model.project/C ProjectPhase ERP 2.50:Developers Guide/Database Model/org.openbravo.model.project/C ProjectProposal ERP 2.50:Developers Guide/Database Model/org.openbravo.model.project/C ProjectProposalLine ERP 2.50:Developers Guide/Database Model/org.openbravo.model.project/C ProjectProposalTask ERP 2.50:Developers Guide/Database Model/org.openbravo.model.project/C ProjectTask ERP 2.50:Developers Guide/Database Model/org.openbravo.model.project/C ProjectType ERP 2.50:Developers Guide/Database Model/org.openbravo.model.project/C Project Acct ERP 2.50:Developers Guide/Database Model/org.openbravo.model.project/C Project Details V ERP 2.50:Developers Guide/Database Model/org.openbravo.model.project/C Project Header V ERP 2.50:Developers Guide/Database Model/org.openbravo.model.project/C Project Vendor ERP 2.50:Developers Guide/Database Model/org.openbravo.model.project/C Projectproposal V ERP 2.50:Developers Guide/Database Model/org.openbravo.model.project/C Task

Index

Contents 1 C_Project 1.1 Other Info 1.1.1 Check constraints 1.1.2 Indexes 1.1.2.1 Unique 1.2 Columns 1.2.1 Project 1.2.2 Client 1.2.3 Organization 1.2.3.1 Callout: SL_Project_Type 1.2.4 Active 1.2.5 Created 1.2.6 Created By 1.2.7 Updated 1.2.8 Updated By 1.2.9 Search Key 1.2.10 Name 1.2.11 Description 1.2.12 Comments 1.2.13 Summary Level 1.2.14 User/Contact 1.2.15 Business Partner 1.2.15.1 Callout: SE_Project_BPartner 1.2.16 Partner Address 1.2.17 Order Reference 1.2.18 Payment Terms 1.2.19 Currency 1.2.20 Create Temporary Price List 1.2.21 Price List Version 1.2.22 Sales Campaign 1.2.23 Legally Binding Contract 1.2.24 Planned Amount 1.2.25 Planned Quantity 1.2.26 Planned Margin 1.2.27 Contract Amount 1.2.28 Contract Date 1.2.29 Ending Date 1.2.30 Generate To 1.2.31 Processed 1.2.32 Sales Representative 1.2.33 Copy from 1.2.34 Project Type 1.2.35 Contract Quantity 1.2.36 Invoice Amount 1.2.37 Invoice Quantity 1.2.38 Project Balance 1.2.39 Standard Phase 1.2.40 Current Phase 1.2.41 Price Ceiling 1.2.42 Warehouse 1.2.43 Project Category 1.2.43.1 List values: C_ProjectType Category 1.2.44 Process Now 1.2.45 Initiative Type 1.2.45.1 List values: PublicPrivate 1.2.46 Project Status 1.2.46.1 List values: ProjectStatus 1.2.47 Work Type 1.2.47.1 List values: Projectkind 1.2.48 Invoice Address 1.2.49 Phase 1.2.49.1 List values: Projectphase 1.2.50 Generate Order 1.2.51 Change Project Status 1.2.52 Location / Address 1.2.53 Price List 1.2.53.1 Callout: SL_Project_PriceList 1.2.54 Form of Payment 1.2.54.1 List values: All_Payment Rule 1.2.55 Invoice to Project 1.2.56 Planned po Amount 1.2.57 Last planned proposal date 1.2.58 Number of Copies 1.2.59 Account Number 1.2.60 Planned Expenses 1.2.60.1 Callout: SL_Project_Margin 1.2.61 Expenses Margin % 1.2.61.1 Callout: SL_Project_Margin 1.2.62 Reinvoiced Expenses 1.2.62.1 Callout: SL_Project_Margin 1.2.63 Person in Charge 1.2.64 Total Service Cost 1.2.64.1 Callout: SL_Project_Margin 1.2.65 Service Margin % 1.2.65.1 Callout: SL_Project_Margin 1.2.66 Service Revenue 1.2.66.1 Callout: SL_Project_Margin 1.2.67 Set Project Type 1.2.68 Starting Date 1.2.69 Services Provided Cost 1.2.69.1 Callout: SL_Project_Service 1.2.70 Outsourced Cost 1.2.70.1 Callout: SL_Project_Service 1.2.71 Payment Method 1.3 Related tables

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, …

• Name:Project
• Classname:Project

This table contains the following columns:

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

• C_PROJECT_GENERATETO_CHECK: GENERATETO IN ('Y', 'N')
• C_PROJECT_ISACTIVE_CHECK: ISACTIVE IN ('Y', 'N')
• C_PROJECT_ISCOMMITMENT_CHECK: ISCOMMITMENT IN ('Y', 'N')
• C_PROJECT_PROCESSED_CHECK: PROCESSED IN ('Y', 'N')
• C_PROJECT_TEMPPRICELIST_CHECK: CREATETEMPPRICELIST IN ('Y', 'N')

top

Indexes

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

Unique

• C_PROJECT_KEY
  • C_Project_ID
• C_PROJECT_VALUE
  • AD_Client_ID
  • Value

top

Columns

Project

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

• Physical column name: C_Project_ID
• Property Name: id
• Reference: ID

top

Client

• Physical column name: AD_Client_ID
• Property Name: client
• Reference: TableDir
• Default value: @AD_CLIENT_ID@

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

top

Organization

• Physical column name: AD_Org_ID
• Property Name: organization
• Reference: TableDir
• Default value: @AD_Org_ID@

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.

• Physical column name: IsActive
• Property Name: active
• Reference: YesNo
• Default value: Y

top

Created

Date when project was added to Project List

• Physical column name: Created
• Property Name: creationDate
• Reference: DateTime

top

Created By

• Physical column name: CreatedBy
• Property Name: createdBy
• Reference: Search

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

top

Updated

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

• Physical column name: Updated
• Property Name: updated
• Reference: DateTime

top

Updated By

• Physical column name: UpdatedBy
• Property Name: updatedBy
• Reference: Search

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.

• Physical column name: Value
• Property Name: searchKey
• Reference: String
• This column is part of the table's identifier

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.

• Physical column name: Name
• Property Name: name
• Reference: String
• This column is part of the table's identifier

top

Description

A description is limited to 255 characters.

• Physical column name: Description
• Property Name: description
• Reference: Text

top

Comments

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

• Physical column name: Note
• Property Name: comments
• Reference: Text

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.

• Physical column name: IsSummary
• Property Name: summaryLevel
• Reference: YesNo

top

User/Contact

• Physical column name: AD_User_ID
• Property Name: userContact
• Reference: TableDir
• Default value: -1

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

• Physical column name: C_BPartner_ID
• Property Name: businessPartner
• Reference: Search

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

• Physical column name: C_BPartner_Location_ID
• Property Name: partnerAddress
• Reference: TableDir

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.

• Physical column name: POReference
• Property Name: orderReference
• Reference: String

top

Payment Terms

• Physical column name: C_PaymentTerm_ID
• Property Name: paymentTerms
• Reference: TableDir

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

top

Currency

• Physical column name: C_Currency_ID
• Property Name: currency
• Reference: TableDir
• Default value: @C_Currency_ID@

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'.

• Physical column name: Createtemppricelist
• Property Name: createTemporaryPriceList
• Reference: YesNo
• Default value: Y

top

Price List Version

• Physical column name: M_PriceList_Version_ID
• Property Name: priceListVersion
• Reference: TableDir

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

top

Sales Campaign

• Physical column name: C_Campaign_ID
• Property Name: salesCampaign
• Reference: TableDir

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

top

Legally Binding Contract

Commitment indicates if the document is legally binding.

• Physical column name: IsCommitment
• Property Name: legallyBindingContract
• Reference: YesNo

top

Planned Amount

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

• Physical column name: PlannedAmt
• Property Name: plannedAmount
• Reference: Amount

top

Planned Quantity

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

• Physical column name: PlannedQty
• Property Name: plannedQuantity
• Reference: Quantity

top

Planned Margin

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

• Physical column name: PlannedMarginAmt
• Property Name: plannedMargin
• Reference: Amount

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.

• Physical column name: CommittedAmt
• Property Name: contractAmount
• Reference: 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.

• Physical column name: DateContract
• Property Name: contractDate
• Reference: Date

top

Ending Date

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

• Physical column name: DateFinish
• Property Name: endingDate
• Reference: Date

top

Generate To

A button that creates documents

• Physical column name: GenerateTo
• Property Name: generateTo
• Reference: Button

top

Processed

The Processed checkbox indicates that a document has been processed.

• Physical column name: Processed
• Property Name: processed
• Reference: YesNo

top

Sales Representative

• Physical column name: SalesRep_ID
• Property Name: salesRepresentative
• Reference: Table

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.

• Physical column name: CopyFrom
• Property Name: copyFrom
• Reference: Button

top

Project Type

• Physical column name: C_ProjectType_ID
• Property Name: projectType
• Reference: TableDir

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.

• Physical column name: CommittedQty
• Property Name: contractQuantity
• Reference: Quantity

top

Invoice Amount

The amount invoiced

• Physical column name: InvoicedAmt
• Property Name: invoiceAmount
• Reference: Amount

top

Invoice Quantity

The Quantity Invoiced

• Physical column name: InvoicedQty
• Property Name: invoiceQuantity
• Reference: Quantity

top

Project Balance

The project balance is the sum of all invoices and payments

• Physical column name: ProjectBalanceAmt
• Property Name: projectBalance
• Reference: Amount

top

Standard Phase

• Physical column name: C_Phase_ID
• Property Name: standardPhase
• Reference: TableDir

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

• Physical column name: C_ProjectPhase_ID
• Property Name: projectPhase
• Reference: TableDir

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.

• Physical column name: IsCommitCeiling
• Property Name: priceCeiling
• Reference: YesNo

top

Warehouse

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

• Physical column name: M_Warehouse_ID
• Property Name: warehouse
• Reference: TableDir

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

• Physical column name: ProjectCategory
• Property Name: projectCategory
• Reference: List
• Default value: @PREPROJECTCATEGORY@

List values: C_ProjectType Category

The allowed values for this list are:

• A (Asset Project)
• N (General)
• S (Multiphase Project)
• W (Work Order (Job))

top

Process Now

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

• Physical column name: Processing
• Property Name: processNow
• Reference: Button

top

Initiative Type

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

• Physical column name: Publicprivate
• Property Name: initiativeType
• Reference: List

List values: PublicPrivate

The allowed values for this list are:

• PR (Private)
• PU (Public)

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.

• Physical column name: Projectstatus
• Property Name: projectStatus
• Reference: List
• Default value: OP

List values: ProjectStatus

The allowed values for this list are:

• NF (No following up)
• OC (Order closed): Order closed
• OP (Open)
• OR (Order)
• OU (Out (Lost))

top

Work Type

Indicates the kind of work

• Physical column name: Projectkind
• Property Name: workType
• Reference: List

List values: Projectkind

The allowed values for this list are:

• RE (Reinforcement)
• RO (Road)
• WA (Wall)

top

Invoice Address

• Physical column name: BillTo_ID
• Property Name: invoiceAddress
• Reference: Table

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

• Physical column name: Projectphase
• Property Name: phase
• Reference: List

List values: Projectphase

The allowed values for this list are:

• AC (Awarded a contract to)
• PR (Project)
• TE (Tender)

top

Generate Order

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

• Physical column name: GenerateOrder
• Property Name: generateOrder
• Reference: Button

top

Change Project Status

This process changes the status of this projecto.

• Physical column name: ChangeProjectStatus
• Property Name: changeProjectStatus
• Reference: Button

top

Location / Address

• Physical column name: C_Location_ID
• Property Name: locationAddress
• Reference: Search

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

top

Price List

• Physical column name: M_PriceList_ID
• Property Name: priceList
• Reference: TableDir

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.)

• Physical column name: PaymentRule
• Property Name: formOfPayment
• Reference: List

List values: All_Payment Rule

The allowed values for this list are:

• 1 (Wire Transfer): Wire Transfer
• 2 (Check): Check
• 3 (Promissory Note): Promissory Note
• 4 (Money Order)
• 5 (Bank Deposit)
• B (Cash): Cash payments that generate an automatic accounting line.
• C (Cash on Delivery): Cash on Delivery
• K (Credit Card)
• P (On Credit): Cash payments that do not generate an automatic accounting line. Its is not an automatic cash entry.
• R (Bank Remittance)
• T (Transfer (ACH))
• W (Withholding)

top

Invoice to Project

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

• Physical column name: Invoice_ToProject
• Property Name: invoiceToProject
• Reference: YesNo

top

Planned po Amount

Planned amount for the purchase order

• Physical column name: PlannedPOAmt
• Property Name: plannedPoAmount
• Reference: Amount

top

Last planned proposal date

Last day of following up the budget for the project

• Physical column name: LastPlannedProposalDate
• Property Name: lastPlannedProposalDate
• Reference: Date

top

Number of Copies

Number of copies

• Physical column name: Document_Copies
• Property Name: numberOfCopies
• Reference: Integer
• Default value: 1

top

Account Number

The Account Number indicates the Number assigned to this account

• Physical column name: AccountNo
• Property Name: accountNo
• Reference: String

top

Planned Expenses

• Physical column name: Expexpenses
• Property Name: plannedExpenses
• Reference: Number

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.

• Physical column name: Expmargin
• Property Name: expensesMargin
• Reference: Number

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)

• Physical column name: Expreinvoicing
• Property Name: reinvoicedExpenses
• Reference: Number

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

• Physical column name: Responsible_ID
• Property Name: personInCharge
• Reference: Table

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.

• Physical column name: Servcost
• Property Name: serviceCost
• Reference: Number

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.

• Physical column name: Servmargin
• Property Name: serviceMargin
• Reference: Number

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.

• Physical column name: Servrevenue
• Property Name: serviceRevenue
• Reference: Number

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

• Physical column name: Setprojecttype
• Property Name: setProjectType
• Reference: Button

top

Starting Date

A parameter stating when a specified request will begin.

• Physical column name: Startdate
• Property Name: startingDate
• Reference: Date

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.

• Physical column name: Servsercost
• Property Name: servicesProvidedCost
• Reference: Number

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.

• Physical column name: Servoutcost
• Property Name: outsourcedCost
• Reference: Number

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

• Physical column name: FIN_Paymentmethod_ID
• Property Name: paymentMethod
• Reference: TableDir

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:

• ActiveProposalV.Project
• DataImportBudgetLine.Project
• DataImportGLJournal.Project
• DataImportInvoice.Project
• DataImportOrder.Project
• FIN_Finacc_Transaction.Project
• FIN_Payment.Project
• FinancialMgmtAccountingCombination.Project
• FinancialMgmtAccountingFact.Project
• FinancialMgmtAcctSchemaElement.Project
• FinancialMgmtAmortization.Project
• FinancialMgmtBudgetLine.Project
• FinancialMgmtCashJournal.Project
• FinancialMgmtDPManagement.Project
• FinancialMgmtDebtPayment.Project
• FinancialMgmtDebtPaymentGenerateV.Project
• FinancialMgmtGLJournal.Project
• FinancialMgmtSettlement.Project
• Invoice.Project
• InvoiceHeaderV.Project
• InvoiceLineAccountingDimension.Project
• InvoiceV2.Project
• MaterialMgmtInternalMovement.Project
• MaterialMgmtInventoryCount.Project
• MaterialMgmtProductionTransaction.Project
• MaterialMgmtShipmentInOut.Project
• Order.Project
• OrderHeaderV.Project
• ProjectAccounts.Project
• ProjectDetailsV.Project
• ProjectHeaderV.Project
• ProjectIssue.Project
• ProjectLine.Project
• ProjectPhase.Project
• ProjectProposal.Project
• ProjectVendor.Project
• Request.Project
• RequestionAction.Project
• TimeAndExpenseSheetLine.Project
• TimeAndExpenseSheetLineV.Project

top