ERP/3.0/Developers Guide/Database Model/org.openbravo.model.project/C Project Header V
C_Project_Header_V
- Name:ProjectHeaderV
- Classname:ProjectHeaderV
This table contains the following columns:
Name | Nullable | Data Type | Description |
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 | The date that this record is completed. |
CreatedBy | N | VARCHAR2(32) | User who created this records |
Updated | N | DATE | x not implemented |
UpdatedBy | N | VARCHAR2(32) | User who updated this records |
AD_Language | Y | CHAR(5) | A method of communication being used. |
C_Project_ID | N | VARCHAR2(32) | Identifier of a project defined within the Project & Service Management module. |
Value | N | NVARCHAR2(40) | A fast method for finding a particular record. |
ProjectName | N | NVARCHAR2(60) | Name of the Project |
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. |
ProjectCategory | Y | VARCHAR2(60) | Project Category |
Org_Location_ID | Y | VARCHAR2(32) | Organization Location/Address |
TaxID | N | VARCHAR2(20) | The government defined unique number for assigning and paying taxes. |
C_ProjectType_ID | Y | VARCHAR2(32) | Project Type is a template of a common project. |
ProjectTypeName | Y | NVARCHAR2(60) | Name of the Project Type |
C_Phase_ID | Y | VARCHAR2(32) | One section or part of a project which is potentially made up of one or many tasks. |
ProjectPhaseName | Y | NVARCHAR2(60) | Name of the Project Phase |
SalesRep_ID | Y | VARCHAR2(32) | The person in charge of a document. |
SalesRep_Name | Y | NVARCHAR2(60) | null |
C_BPartner_ID | Y | VARCHAR2(32) | Anyone who takes part in daily business operations by acting as a customer, employee, etc. |
BPValue | Y | NVARCHAR2(40) | Business Partner Key Value |
BPGreeting | Y | NVARCHAR2(60) | Greeting for Business Partner |
Name | Y | NVARCHAR2(60) | A non-unique identifier for a record/document often used as a search tool. |
Name2 | Y | NVARCHAR2(60) | Additional space to write the name of a business partner. |
BPContactGreeting | Y | NVARCHAR2(60) | Greeting for Business Partner Contact |
Title | Y | NVARCHAR2(40) | A defined job, title, or ranking within a company. |
ContactName | Y | NVARCHAR2(60) | The name of the person to get in touch with. |
C_Location_ID | Y | VARCHAR2(32) | A specific place or residence. |
ReferenceNo | Y | NVARCHAR2(40) | The number for a specific reference. |
PaymentTerm | Y | NVARCHAR2(60) | Payment Term |
PaymentTermNote | Y | NVARCHAR2(2000) | Note of a Payment Term |
POReference | Y | NVARCHAR2(20) | A reference or document order number as listed in business partner application. |
C_Currency_ID | N | VARCHAR2(32) | An accepted medium of monetary exchange that may vary across countries. |
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. |
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. |
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 |
IsCommitment | N | CHAR(1) | Is this document a (legal) commitment? |
CommittedAmt | N | NUMBER | The maximum legal monetary price a project may be billed for. |
CommittedQty | N | NUMBER | The maximum legal quantity for a project. |
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. |
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. |
Columns
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)
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)
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
Creation Date
The Created field indicates the date that this record was created.
- Physical column name: Created
- Property Name: creationDate
- Reference: DateTime
Created By
- Physical column name: CreatedBy
- Property Name: createdBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Updated
The Updated field indicates the date that this record was updated.
- Physical column name: Updated
- Property Name: updated
- Reference: DateTime
Updated By
- Physical column name: UpdatedBy
- Property Name: updatedBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Language
- Physical column name: AD_Language
- Property Name: language
- Reference: Table
Foreign key column to AD_Language table, (column: AD_Language_ID)
Reference Table AD_Language
Project
- Physical column name: C_Project_ID
- Property Name: project
- Reference: TableDir
- This column is part of the table's identifier
Foreign key column to C_Project table, (column: C_Project_ID)
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
Project Name
Name of the Project
- Physical column name: ProjectName
- Property Name: projectName
- Reference: String
Description
A description is limited to 255 characters.
- Physical column name: Description
- Property Name: description
- Reference: String
Comments
The Note field allows for optional entry of user defined information regarding this record
- Physical column name: Note
- Property Name: comments
- Reference: String
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
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
List values: C_ProjectType Category
The allowed values for this list are:
- A (Asset Project)
- N (General)
- S (Multiphase Project)
- W (Work Order (Job))
Org Location
- Physical column name: Org_Location_ID
- Property Name: orgLocation
- Reference: Table
Foreign key column to C_Location table, (column: C_Location_ID)
Reference Table C_Location
Tax ID
The Tax ID field identifies the legal Identification number of this Entity.
- Physical column name: TaxID
- Property Name: taxID
- Reference: String
Project Type
- Physical column name: C_ProjectType_ID
- Property Name: projectType
- Reference: TableDir
Foreign key column to C_ProjectType table, (column: C_ProjectType_ID)
Project Type Name
Name of the Project Type
- Physical column name: ProjectTypeName
- Property Name: projectTypeName
- Reference: String
Standard Phase
- Physical column name: C_Phase_ID
- Property Name: standardPhase
- Reference: TableDir
Foreign key column to C_Phase table, (column: C_Phase_ID)
Project Phase
Name of the Project Phase
- Physical column name: ProjectPhaseName
- Property Name: projectPhase
- Reference: String
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
Sales Representative Name
- Physical column name: SalesRep_Name
- Property Name: salesRepresentativeName
- Reference: String
Business Partner
- Physical column name: C_BPartner_ID
- Property Name: businessPartner
- Reference: Search
Foreign key column to C_BPartner table, (column: C_BPartner_ID)
BP Search Key
Search Key of Business Partner
- Physical column name: BPValue
- Property Name: bPSearchKey
- Reference: String
BP Greeting
Greeting for Business Partner
- Physical column name: BPGreeting
- Property Name: bPGreeting
- Reference: String
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
Name 2
Additional Name
- Physical column name: Name2
- Property Name: name2
- Reference: String
BP Contact Greeting
Greeting for Business Partner Contact
- Physical column name: BPContactGreeting
- Property Name: bPContactGreeting
- Reference: String
Position
The Title indicates the name that an entity is referred to as.
- Physical column name: Title
- Property Name: position
- Reference: String
Contact Name
Business Partner Contact Name
- Physical column name: ContactName
- Property Name: contactName
- Reference: String
Location / Address
- Physical column name: C_Location_ID
- Property Name: locationAddress
- Reference: Search
Foreign key column to C_Location table, (column: C_Location_ID)
Reference No.
The reference number can be printed on orders and invoices to allow your business partner to faster identify your records.
- Physical column name: ReferenceNo
- Property Name: referenceNo
- Reference: String
Payment Term
Payment Term
- Physical column name: PaymentTerm
- Property Name: paymentTerm
- Reference: String
Payment Term Note
Note of a Payment Term
- Physical column name: PaymentTermNote
- Property Name: paymentTermNote
- Reference: String
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
Currency
- Physical column name: C_Currency_ID
- Property Name: currency
- Reference: TableDir
Foreign key column to C_Currency table, (column: C_Currency_ID)
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)
Sales Campaign
- Physical column name: C_Campaign_ID
- Property Name: salesCampaign
- Reference: TableDir
Foreign key column to C_Campaign table, (column: C_Campaign_ID)
Planned Amount
The Planned Amount indicates the anticipated amount for this project or project line.
- Physical column name: PlannedAmt
- Property Name: plannedAmount
- Reference: Amount
Planned Quantity
The Planned Quantity indicates the anticipated quantity for this project or project line
- Physical column name: PlannedQty
- Property Name: plannedQuantity
- Reference: Quantity
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
Invoice Amount
The amount invoiced
- Physical column name: InvoicedAmt
- Property Name: invoiceAmount
- Reference: Amount
Invoice Quantity
The Quantity Invoiced
- Physical column name: InvoicedQty
- Property Name: invoiceQuantity
- Reference: Quantity
Project Balance
The project balance is the sum of all invoices and payments
- Physical column name: ProjectBalanceAmt
- Property Name: projectBalance
- Reference: Amount
Legally Binding Contract
Commitment indicates if the document is legally binding.
- Physical column name: IsCommitment
- Property Name: legallyBindingContract
- Reference: YesNo
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
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
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
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
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
Warehouse
- Physical column name: M_Warehouse_ID
- Property Name: warehouse
- Reference: TableDir
Foreign key column to M_Warehouse table, (column: M_Warehouse_ID)