ERP 2.50:Developers Guide/Reference/Entity Model/ProjectLine
ProjectLine
Contains the lines (products and/or services) associated with the Project
To the database table (C_ProjectLine) of this entity.
Properties
Note:
- Properties marked with a * are part of the Id of the Entity.
- Properties marked with a # are part of the Identifier of the Entity.
Property | Column | Constraints | Type | Description |
id* | C_ProjectLine_ID | Mandatory Max Length: 32 | java.lang.String | The Project Line indicates a unique project line. |
client | AD_Client_ID | Mandatory | ADClient | A Client is a company or a legal entity. You cannot share data between Clients. |
organization | AD_Org_ID | Mandatory | Organization | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. |
active | IsActive | Mandatory | java.lang.Boolean | 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. |
creationDate | Created | Mandatory | java.util.Date | The Created field indicates the date that this record was created. |
createdBy | CreatedBy | Mandatory | ADUser | The Created By field indicates the user who created this record. |
updated | Updated | Mandatory | java.util.Date | The Updated field indicates the date that this record was updated. |
updatedBy | UpdatedBy | Mandatory | ADUser | The Updated By field indicates the user who updated this record. |
project | C_Project_ID | Mandatory | Project | Identifier of a project defined within the Project & Service Management module. |
lineNo# | Line | Mandatory | java.lang.Long | Indicates the unique line for a document. It will also control the display order of the lines within a document. |
description | Description | Max Length: 255 | java.lang.String | A description is limited to 255 characters. |
plannedQuantity | PlannedQty | Mandatory | java.math.BigDecimal | The Planned Quantity indicates the anticipated quantity for this project or project line |
plannedPrice | PlannedPrice | Mandatory | java.math.BigDecimal | The Planned Price indicates the anticipated price for this project line. |
plannedAmount | PlannedAmt | Mandatory | java.math.BigDecimal | The Planned Amount indicates the anticipated amount for this project or project line. |
plannedMargin | PlannedMarginAmt | Mandatory | java.math.BigDecimal | The Planned Margin Amount indicates the anticipated margin amount for this project or project line. |
contractAmount | CommittedAmt | java.math.BigDecimal | 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. | |
product | M_Product_ID | Product | Identifies an item which is either purchased or sold in this organization. | |
productCategory | M_Product_Category_ID | ProductCategory | Identifies the category which this product belongs to. Product categories are used for pricing. | |
invoiceAmount | InvoicedAmt | Mandatory | java.math.BigDecimal | The amount invoiced |
invoiceQuantity | InvoicedQty | Mandatory | java.math.BigDecimal | The Quantity Invoiced |
contractQuantity | CommittedQty | java.math.BigDecimal | 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. | |
projectIssue | C_ProjectIssue_ID | ProjectIssue | Issues to the project initiated by the "Issue to Project" process. You can issue Receipts, Time and Expenses, or Stock. | |
salesOrder | C_Order_ID | Order | Unique identifier and a reference to a Sales Order originating from the document sequence defined for this document type. | |
purchaseOrder | C_OrderPO_ID | Order | Purchase order | |
IsPrinted | Mandatory | java.lang.Boolean | The Printed checkbox indicates if this document or line will included when printing. | |
processed | Processed | Mandatory | java.lang.Boolean | The Processed checkbox indicates that a document has been processed. |
pricing | DoPricing | java.lang.Boolean | ||
plannedPurchasePrice | Plannedpoprice | java.math.BigDecimal | Indicates the planned price for the purchase order | |
tax | C_Tax_ID | FinancialMgmtTaxRate | The Tax indicates the type of tax for this document line. | |
productDescription | Product_Description | Max Length: 2000 | java.lang.String | Description for the product |
name | Product_Name | Max Length: 60 | java.lang.String | Name of the product |
identifier | Product_Value | Max Length: 40 | java.lang.String | A value specified in many forms. |
Java Entity Class
/* ************************************************************************* * The contents of this file are subject to the Openbravo Public License * Version 1.1 (the "License"), being the Mozilla Public License * Version 1.1 with a permitted attribution clause; you may not use this * file except in compliance with the License. You may obtain a copy of * the License at http://www.openbravo.com/legal/license.html * Software distributed under the License is distributed on an "AS IS" * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the * License for the specific language governing rights and limitations * under the License. * The Original Code is Openbravo ERP. * The Initial Developer of the Original Code is Openbravo SLU * All portions are Copyright (C) 2008-2010 Openbravo SLU * All Rights Reserved. * Contributor(s): ______________________________________. ************************************************************************ */ package org.openbravo.model.project; import org.openbravo.base.structure.ActiveEnabled; import org.openbravo.base.structure.BaseOBObject; import org.openbravo.base.structure.ClientEnabled; import org.openbravo.base.structure.OrganizationEnabled; import org.openbravo.base.structure.Traceable; import org.openbravo.model.ad.access.User; import org.openbravo.model.ad.system.Client; import org.openbravo.model.common.enterprise.Organization; import org.openbravo.model.common.order.Order; import org.openbravo.model.common.plm.Product; import org.openbravo.model.common.plm.ProductCategory; import org.openbravo.model.financialmgmt.tax.TaxRate; import java.lang.Boolean; import java.lang.Long; import java.lang.String; import java.math.BigDecimal; import java.util.Date; /** * Entity class for entity ProjectLine (stored in table C_ProjectLine). * * NOTE: This class should not be instantiated directly. To instantiate this * class the {@link org.openbravo.base.provider.OBProvider} should be used. */ public class ProjectLine extends BaseOBObject implements Traceable, ClientEnabled, OrganizationEnabled, ActiveEnabled { private static final long serialVersionUID = 1L; public static final String TABLE_NAME = "C_ProjectLine"; public static final String ProjectLine = "ProjectLine"; public static final String PROPERTY_ID = "id"; public static final String PROPERTY_CLIENT = "client"; public static final String PROPERTY_ORGANIZATION = "organization"; public static final String PROPERTY_ACTIVE = "active"; public static final String PROPERTY_CREATIONDATE = "creationDate"; public static final String PROPERTY_CREATEDBY = "createdBy"; public static final String PROPERTY_UPDATED = "updated"; public static final String PROPERTY_UPDATEDBY = "updatedBy"; public static final String PROPERTY_PROJECT = "project"; public static final String PROPERTY_LINENO = "lineNo"; public static final String PROPERTY_DESCRIPTION = "description"; public static final String PROPERTY_PLANNEDQUANTITY = "plannedQuantity"; public static final String PROPERTY_PLANNEDPRICE = "plannedPrice"; public static final String PROPERTY_PLANNEDAMOUNT = "plannedAmount"; public static final String PROPERTY_PLANNEDMARGIN = "plannedMargin"; public static final String PROPERTY_CONTRACTAMOUNT = "contractAmount"; public static final String PROPERTY_PRODUCT = "product"; public static final String PROPERTY_PRODUCTCATEGORY = "productCategory"; public static final String PROPERTY_INVOICEAMOUNT = "invoiceAmount"; public static final String PROPERTY_INVOICEQUANTITY = "invoiceQuantity"; public static final String PROPERTY_CONTRACTQUANTITY = "contractQuantity"; public static final String PROPERTY_PROJECTISSUE = "projectIssue"; public static final String PROPERTY_SALESORDER = "salesOrder"; public static final String PROPERTY_PURCHASEORDER = "purchaseOrder"; public static final String PROPERTY_PRINT = "print"; public static final String PROPERTY_PROCESSED = "processed"; public static final String PROPERTY_PRICING = "pricing"; public static final String PROPERTY_PLANNEDPURCHASEPRICE = "plannedPurchasePrice"; public static final String PROPERTY_TAX = "tax"; public static final String PROPERTY_PRODUCTDESCRIPTION = "productDescription"; public static final String PROPERTY_NAME = "name"; public static final String PROPERTY_IDENTIFIER = "identifier"; public ProjectLine() { setDefaultValue(PROPERTY_ACTIVE, true); setDefaultValue(PROPERTY_PLANNEDQUANTITY, new BigDecimal(1)); setDefaultValue(PROPERTY_PLANNEDAMOUNT, new BigDecimal(0)); setDefaultValue(PROPERTY_PLANNEDMARGIN, new BigDecimal(0)); setDefaultValue(PROPERTY_CONTRACTAMOUNT, new BigDecimal(0)); setDefaultValue(PROPERTY_INVOICEAMOUNT, new BigDecimal(0)); setDefaultValue(PROPERTY_INVOICEQUANTITY, new BigDecimal(0)); setDefaultValue(PROPERTY_CONTRACTQUANTITY, new BigDecimal(0)); setDefaultValue(PROPERTY_PRINT, true); setDefaultValue(PROPERTY_PROCESSED, false); setDefaultValue(PROPERTY_PRICING, false); } @Override public String getEntityName() { return ProjectLine; } public String getId() { return (String) get(PROPERTY_ID); } public void setId(String id) { set(PROPERTY_ID, id); } public Client getClient() { return (Client) get(PROPERTY_CLIENT); } public void setClient(Client client) { set(PROPERTY_CLIENT, client); } public Organization getOrganization() { return (Organization) get(PROPERTY_ORGANIZATION); } public void setOrganization(Organization organization) { set(PROPERTY_ORGANIZATION, organization); } public Boolean isActive() { return (Boolean) get(PROPERTY_ACTIVE); } public void setActive(Boolean active) { set(PROPERTY_ACTIVE, active); } public Date getCreationDate() { return (Date) get(PROPERTY_CREATIONDATE); } public void setCreationDate(Date creationDate) { set(PROPERTY_CREATIONDATE, creationDate); } public User getCreatedBy() { return (User) get(PROPERTY_CREATEDBY); } public void setCreatedBy(User createdBy) { set(PROPERTY_CREATEDBY, createdBy); } public Date getUpdated() { return (Date) get(PROPERTY_UPDATED); } public void setUpdated(Date updated) { set(PROPERTY_UPDATED, updated); } public User getUpdatedBy() { return (User) get(PROPERTY_UPDATEDBY); } public void setUpdatedBy(User updatedBy) { set(PROPERTY_UPDATEDBY, updatedBy); } public Project getProject() { return (Project) get(PROPERTY_PROJECT); } public void setProject(Project project) { set(PROPERTY_PROJECT, project); } public Long getLineNo() { return (Long) get(PROPERTY_LINENO); } public void setLineNo(Long lineNo) { set(PROPERTY_LINENO, lineNo); } public String getDescription() { return (String) get(PROPERTY_DESCRIPTION); } public void setDescription(String description) { set(PROPERTY_DESCRIPTION, description); } public BigDecimal getPlannedQuantity() { return (BigDecimal) get(PROPERTY_PLANNEDQUANTITY); } public void setPlannedQuantity(BigDecimal plannedQuantity) { set(PROPERTY_PLANNEDQUANTITY, plannedQuantity); } public BigDecimal getPlannedPrice() { return (BigDecimal) get(PROPERTY_PLANNEDPRICE); } public void setPlannedPrice(BigDecimal plannedPrice) { set(PROPERTY_PLANNEDPRICE, plannedPrice); } public BigDecimal getPlannedAmount() { return (BigDecimal) get(PROPERTY_PLANNEDAMOUNT); } public void setPlannedAmount(BigDecimal plannedAmount) { set(PROPERTY_PLANNEDAMOUNT, plannedAmount); } public BigDecimal getPlannedMargin() { return (BigDecimal) get(PROPERTY_PLANNEDMARGIN); } public void setPlannedMargin(BigDecimal plannedMargin) { set(PROPERTY_PLANNEDMARGIN, plannedMargin); } public BigDecimal getContractAmount() { return (BigDecimal) get(PROPERTY_CONTRACTAMOUNT); } public void setContractAmount(BigDecimal contractAmount) { set(PROPERTY_CONTRACTAMOUNT, contractAmount); } public Product getProduct() { return (Product) get(PROPERTY_PRODUCT); } public void setProduct(Product product) { set(PROPERTY_PRODUCT, product); } public ProductCategory getProductCategory() { return (ProductCategory) get(PROPERTY_PRODUCTCATEGORY); } public void setProductCategory(ProductCategory productCategory) { set(PROPERTY_PRODUCTCATEGORY, productCategory); } public BigDecimal getInvoiceAmount() { return (BigDecimal) get(PROPERTY_INVOICEAMOUNT); } public void setInvoiceAmount(BigDecimal invoiceAmount) { set(PROPERTY_INVOICEAMOUNT, invoiceAmount); } public BigDecimal getInvoiceQuantity() { return (BigDecimal) get(PROPERTY_INVOICEQUANTITY); } public void setInvoiceQuantity(BigDecimal invoiceQuantity) { set(PROPERTY_INVOICEQUANTITY, invoiceQuantity); } public BigDecimal getContractQuantity() { return (BigDecimal) get(PROPERTY_CONTRACTQUANTITY); } public void setContractQuantity(BigDecimal contractQuantity) { set(PROPERTY_CONTRACTQUANTITY, contractQuantity); } public ProjectIssue getProjectIssue() { return (ProjectIssue) get(PROPERTY_PROJECTISSUE); } public void setProjectIssue(ProjectIssue projectIssue) { set(PROPERTY_PROJECTISSUE, projectIssue); } public Order getSalesOrder() { return (Order) get(PROPERTY_SALESORDER); } public void setSalesOrder(Order salesOrder) { set(PROPERTY_SALESORDER, salesOrder); } public Order getPurchaseOrder() { return (Order) get(PROPERTY_PURCHASEORDER); } public void setPurchaseOrder(Order purchaseOrder) { set(PROPERTY_PURCHASEORDER, purchaseOrder); } public Boolean isPrint() { return (Boolean) get(PROPERTY_PRINT); } public void setPrint(Boolean print) { set(PROPERTY_PRINT, print); } public Boolean isProcessed() { return (Boolean) get(PROPERTY_PROCESSED); } public void setProcessed(Boolean processed) { set(PROPERTY_PROCESSED, processed); } public Boolean isPricing() { return (Boolean) get(PROPERTY_PRICING); } public void setPricing(Boolean pricing) { set(PROPERTY_PRICING, pricing); } public BigDecimal getPlannedPurchasePrice() { return (BigDecimal) get(PROPERTY_PLANNEDPURCHASEPRICE); } public void setPlannedPurchasePrice(BigDecimal plannedPurchasePrice) { set(PROPERTY_PLANNEDPURCHASEPRICE, plannedPurchasePrice); } public TaxRate getTax() { return (TaxRate) get(PROPERTY_TAX); } public void setTax(TaxRate tax) { set(PROPERTY_TAX, tax); } public String getProductDescription() { return (String) get(PROPERTY_PRODUCTDESCRIPTION); } public void setProductDescription(String productDescription) { set(PROPERTY_PRODUCTDESCRIPTION, productDescription); } public String getName() { return (String) get(PROPERTY_NAME); } public void setName(String name) { set(PROPERTY_NAME, name); } public String getIdentifier() { return (String) get(PROPERTY_IDENTIFIER); } public void setIdentifier(String identifier) { set(PROPERTY_IDENTIFIER, identifier); } }