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

ERP/3.0/Developers Guide/Database Model/org.openbravo.model.project/C Project Header V

Contents

C_Project_Header_V

This table contains the following columns:

Name Nullable Data Type Description
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 NDATEThe date that this record is completed.
CreatedBy NVARCHAR2(32)User who created this records
Updated NDATEx not implemented
UpdatedBy NVARCHAR2(32)User who updated this records
AD_Language YCHAR(5)A method of communication being used.
C_Project_ID NVARCHAR2(32)Identifier of a project defined within the Project & Service Management module.
Value NNVARCHAR2(40)A fast method for finding a particular record.
ProjectName NNVARCHAR2(60)Name of the Project
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.
ProjectCategory YVARCHAR2(60)Project Category
Org_Location_ID YVARCHAR2(32)Organization Location/Address
TaxID NVARCHAR2(20)The government defined unique number for assigning and paying taxes.
C_ProjectType_ID YVARCHAR2(32)Project Type is a template of a common project.
ProjectTypeName YNVARCHAR2(60)Name of the Project Type
C_Phase_ID YVARCHAR2(32)One section or part of a project which is potentially made up of one or many tasks.
ProjectPhaseName YNVARCHAR2(60)Name of the Project Phase
SalesRep_ID YVARCHAR2(32)The person in charge of a document.
SalesRep_Name YNVARCHAR2(60)null
C_BPartner_ID YVARCHAR2(32)Anyone who takes part in daily business operations by acting as a customer, employee, etc.
BPValue YNVARCHAR2(40)Business Partner Key Value
BPGreeting YNVARCHAR2(60)Greeting for Business Partner
Name YNVARCHAR2(60)A non-unique identifier for a record/document often used as a search tool.
Name2 YNVARCHAR2(60)Additional space to write the name of a business partner.
BPContactGreeting YNVARCHAR2(60)Greeting for Business Partner Contact
Title YNVARCHAR2(40)A defined job, title, or ranking within a company.
ContactName YNVARCHAR2(60)The name of the person to get in touch with.
C_Location_ID YVARCHAR2(32)A specific place or residence.
ReferenceNo YNVARCHAR2(40)The number for a specific reference.
PaymentTerm YNVARCHAR2(60)Payment Term
PaymentTermNote YNVARCHAR2(2000)Note of a Payment Term
POReference YNVARCHAR2(20)A reference or document order number as listed in business partner application.
C_Currency_ID NVARCHAR2(32)An accepted medium of monetary exchange that may vary across countries.
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.
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.
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
IsCommitment NCHAR(1)Is this document a (legal) commitment?
CommittedAmt NNUMBERThe maximum legal monetary price a project may be billed for.
CommittedQty NNUMBERThe maximum legal quantity for a project.
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.
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.

Columns

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)

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

Creation Date

The Created field indicates the date that this record was created.

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

Language

Foreign key column to AD_Language table, (column: AD_Language_ID)


Reference Table AD_Language

top

Project

Foreign key column to C_Project table, (column: C_Project_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

Project Name

Name of the Project

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

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

Org Location

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


Reference Table C_Location

top

Tax ID

The Tax ID field identifies the legal Identification number of this Entity.

top

Project Type

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

top

Project Type Name

Name of the Project Type

top

Standard Phase

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

top

Project Phase

Name of the Project Phase

top

Sales Representative

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


Reference Table AD_User

top

Sales Representative Name

top

Business Partner

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

top

BP Search Key

Search Key of Business Partner

top

BP Greeting

Greeting for Business Partner

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

Name 2

Additional Name

top

BP Contact Greeting

Greeting for Business Partner Contact

top

Position

The Title indicates the name that an entity is referred to as.

top

Contact Name

Business Partner Contact Name

top

Location / Address

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

top

Reference No.

The reference number can be printed on orders and invoices to allow your business partner to faster identify your records.

top

Payment Term

Payment Term

top

Payment Term Note

Note of a Payment Term

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

Currency

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

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

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

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

Legally Binding Contract

Commitment indicates if the document is legally binding.

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

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

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

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

top

Retrieved from "http://wiki.openbravo.com/wiki/ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.project/C_Project_Header_V"

This page has been accessed 3,099 times. This page was last modified on 15 April 2011, at 21:59. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.