ERP 2.50:Developers Guide/Database Model/org.openbravo.model.project/C ProjectLine
C_ProjectLine
Contains the lines (products and/or services) associated with the Project
- Name:ProjectLine
- Classname:ProjectLine
This table contains the following columns:
Name | Nullable | Data Type | Description |
C_ProjectLine_ID | N | VARCHAR2(32) | Task or step in a project |
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 |
C_Project_ID | N | VARCHAR2(32) | Identifier of a project defined within the Project & Service Management module. |
Line | N | NUMBER(10, 0) | A line stating the position of this request in the document. |
Description | Y | NVARCHAR2(255) | A space to write additional related information. |
PlannedQty | N | NUMBER | The expected or provisional quantity to be involved for a transaction line. |
PlannedPrice | N | NUMBER | Planned price for this project line |
PlannedAmt | N | NUMBER | The monetary sum expected to be involved for a transaction line. |
PlannedMarginAmt | N | NUMBER | The expected or provisional margin to be earned due to this transaction. |
CommittedAmt | Y | NUMBER | The maximum legal monetary price a project may be billed for. |
M_Product_ID | Y | VARCHAR2(32) | An item produced by a process. |
M_Product_Category_ID | Y | VARCHAR2(32) | A classification of items based on similar characteristics or attributes. |
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. |
CommittedQty | Y | NUMBER | The maximum legal quantity for a project. |
C_ProjectIssue_ID | Y | VARCHAR2(32) | x not implemented |
C_Order_ID | Y | VARCHAR2(32) | A unique and often automatically generated identifier for a sales order. |
C_OrderPO_ID | Y | VARCHAR2(32) | An often automatically generated unique identifier for a purchase order. |
IsPrinted | N | CHAR(1) | A reference stating whether or not the document has been printed at any time in the past. |
Processed | N | CHAR(1) | A confirmation that the associated documents or requests are processed. |
DoPricing | Y | CHAR(1) | null |
Plannedpoprice | Y | NUMBER | null |
C_Tax_ID | Y | VARCHAR2(32) | The percentage of money requested by the government for this specified product or transaction. |
Product_Description | Y | NVARCHAR2(2000) | A space to write additional related information. |
Product_Name | Y | NVARCHAR2(60) | A identifier for a document which can be used as a search tool. |
Product_Value | Y | NVARCHAR2(40) | A value specified in many forms. |
Other Info
Check constraints
These are the check constraints for this table:
- C_PROJECTLINE_ISACTIVE_CHECK: ISACTIVE IN ('Y', 'N')
Indexes
These are the indexes for this table (for each index there is a list of all the columns included within it):
Unique
- C_PROJECTLINE_KEY
Columns
Project Line
The Project Line indicates a unique project line.
- Physical column name: C_ProjectLine_ID
- Property Name: id
- Reference: ID
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)
Validation Rule AD_Org Trx Security validation: null. With the following code:
AD_Org.AD_Org_ID<> '0' AND AD_Org.IsReady='Y'
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)
Project
- Physical column name: C_Project_ID
- Property Name: project
- Reference: TableDir
- This column is a child for a buisiness object (is Parent)
Foreign key column to C_Project table, (column: C_Project_ID)
Line No.
Indicates the unique line for a document. It will also control the display order of the lines within a document.
- Physical column name: Line
- Property Name: lineNo
- Reference: Integer
- Default value: @SQL=SELECT COALESCE(MAX(Line),0)+10 AS DefaultValue FROM C_ProjectLine WHERE C_Project_ID=@C_Project_ID@
- This column is part of the table's identifier
Description
A description is limited to 255 characters.
- Physical column name: Description
- Property Name: description
- Reference: Text
Planned Quantity
The Planned Quantity indicates the anticipated quantity for this project or project line
- Physical column name: PlannedQty
- Property Name: plannedQuantity
- Reference: Quantity
- Default value: 1
Callout: SL_Project_Planned
This element is linked to a callout.
It is implemented by org.openbravo.erpCommon.ad_callouts.SL_Project_Planned Java class.
Planned Price
The Planned Price indicates the anticipated price for this project line.
- Physical column name: PlannedPrice
- Property Name: plannedPrice
- Reference: Price
Callout: SL_Project_Planned
This element is linked to a callout.
It is implemented by org.openbravo.erpCommon.ad_callouts.SL_Project_Planned Java class.
Planned Amount
The Planned Amount indicates the anticipated amount for this project or project line.
- Physical column name: PlannedAmt
- Property Name: plannedAmount
- Reference: Amount
- Default value: 0
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
- Default value: 0
Callout: SL_Project_Planned
This element is linked to a callout.
It is implemented by org.openbravo.erpCommon.ad_callouts.SL_Project_Planned Java class.
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
- Default value: 0
Product
- Physical column name: M_Product_ID
- Property Name: product
- Reference: Search
Foreign key column to M_Product table, (column: M_Product_ID)
Callout: SE_ProjectLine_Value
This element is linked to a callout.
It is implemented by org.openbravo.erpCommon.ad_callouts.SE_ProjectLine_Value Java class.
Product Category
- Physical column name: M_Product_Category_ID
- Property Name: productCategory
- Reference: TableDir
Foreign key column to M_Product_Category table, (column: M_Product_Category_ID)
Invoice Amount
The amount invoiced
- Physical column name: InvoicedAmt
- Property Name: invoiceAmount
- Reference: Amount
- Default value: 0
Invoice Quantity
The Quantity Invoiced
- Physical column name: InvoicedQty
- Property Name: invoiceQuantity
- Reference: Quantity
- Default value: 0
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
- Default value: 0
Project Issue
- Physical column name: C_ProjectIssue_ID
- Property Name: projectIssue
- Reference: TableDir
Foreign key column to C_ProjectIssue table, (column: C_ProjectIssue_ID)
Sales Order
- Physical column name: C_Order_ID
- Property Name: salesOrder
- Reference: Search
Foreign key column to C_Order table, (column: C_Order_ID)
Purchase Order
- Physical column name: C_OrderPO_ID
- Property Name: purchaseOrder
- Reference: Search
Foreign key column to C_OrderPO table, (column: null)
The Printed checkbox indicates if this document or line will included when printing.
- Physical column name: IsPrinted
- Property Name: print
- Reference: YesNo
- Default value: Y
Processed
The Processed checkbox indicates that a document has been processed.
- Physical column name: Processed
- Property Name: processed
- Reference: YesNo
- Default value: N
Pricing
- Physical column name: DoPricing
- Property Name: pricing
- Reference: Button
Planned Purchase Price
Indicates the planned price for the purchase order
- Physical column name: Plannedpoprice
- Property Name: plannedPurchasePrice
- Reference: Number
Callout: SL_Project_Planned
This element is linked to a callout.
It is implemented by org.openbravo.erpCommon.ad_callouts.SL_Project_Planned Java class.
Tax
- Physical column name: C_Tax_ID
- Property Name: tax
- Reference: Table
Foreign key column to C_Tax table, (column: C_Tax_ID)
Reference Table C_Tax Parent is NULL With the following where clause:
C_Tax.Parent_Tax_ID IS NULL
Product Description
Description for the product
- Physical column name: Product_Description
- Property Name: productDescription
- Reference: Text
Product Name
Name of the product
- Physical column name: Product_Name
- Property Name: name
- Reference: String
Product Identifier
A value specified in many forms.
- Physical column name: Product_Value
- Property Name: identifier
- Reference: String
Related tables
Tables that link this table: