ERP/2.50/Developers Guide/Reference/Entity Model/TimeAndExpenseSheetLine
TimeAndExpenseSheetLine
Contains all the expense items and billable or non-billable hours
To the database table (S_TimeExpenseLine) 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* | S_TimeExpenseLine_ID | Mandatory Max Length: 32 | java.lang.String | The ID identifies a unique record |
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. |
expenseSheet | S_TimeExpense_ID | Mandatory | TimeAndExpenseSheet | The ID identifies a unique record for the expense report |
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. |
timeSheet | IsTimeReport | Mandatory | java.lang.Boolean | The line contains only time information |
expenseDate | DateExpense | java.util.Date | Date of expense | |
product | M_Product_ID | Product | Identifies an item which is either purchased or sold in this organization. | |
quantity | Qty | java.math.BigDecimal | The Quantity indicates the number of a specific product or item for this document. | |
expenseAmount | ExpenseAmt | java.math.BigDecimal | Expense amount in currency | |
currency | C_Currency_ID | Currency | Indicates the currency to be used when processing this document. | |
convertedAmount | ConvertedAmt | java.math.BigDecimal | The Converted Amount is the result of multiplying the Source Amount by the Conversion Rate for this target currency. | |
resourceAssignment | S_ResourceAssignment_ID | ResourceAssignment | The ID identifies a unique record | |
description | Description | Max Length: 255 | java.lang.String | A description is limited to 255 characters. |
comments | Note | Max Length: 255 | java.lang.String | The Note field allows for optional entry of user defined information regarding this record |
reinvoice | IsInvoiced | Mandatory | java.lang.Boolean | Indicator if invoiced |
businessPartner | C_BPartner_ID | BusinessPartner | A Business Partner is anyone with whom you transact. This can include a customer, vendor, employee or any combination of these. | |
project | C_Project_ID | Project | Identifier of a project defined within the Project & Service Management module. | |
activity | C_Activity_ID | MaterialMgmtABCActivity | Activities indicate tasks that are performed and used to utilize Activity based Costing | |
salesCampaign | C_Campaign_ID | MarketingCampaign | The Campaign defines a unique marketing program. Projects can be associated with a pre defined Marketing Campaign. You can then report based on a specific Campaign. | |
invoiceLine | C_InvoiceLine_ID | InvoiceLine | The Invoice Line uniquely identifies a single line of an Invoice. | |
invoicePrice | InvoicePrice | java.math.BigDecimal | Unit Price in the currency of the business partner! If it is 0, the standard price of the sales price list of the business partner (customer) is used. | |
uOM | C_UOM_ID | UOM | The UOM defines a unique non monetary unit of measure | |
salesOrderLine | C_OrderLine_ID | OrderLine | A unique identifier and a reference to a sales order line (product). | |
projectPhase | C_ProjectPhase_ID | ProjectPhase | Identifies a phase for a particular project. | |
projectTask | C_ProjectTask_ID | ProjectTask | A Project Task in a Project Phase represents the actual work. | |
timeType | S_TimeType_ID | TimeType | Differentiate time types for reporting purposes (In parallel to Activities) |
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.timeandexpense; 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.businesspartner.BusinessPartner; import org.openbravo.model.common.currency.Currency; import org.openbravo.model.common.enterprise.Organization; import org.openbravo.model.common.invoice.InvoiceLine; import org.openbravo.model.common.order.OrderLine; import org.openbravo.model.common.plm.Product; import org.openbravo.model.marketing.Campaign; import org.openbravo.model.materialmgmt.cost.ABCActivity; import org.openbravo.model.project.Project; import org.openbravo.model.project.ProjectPhase; import org.openbravo.model.project.ProjectTask; import java.lang.Boolean; import java.lang.Long; import java.lang.String; import java.math.BigDecimal; import java.util.Date; /** * Entity class for entity TimeAndExpenseSheetLine (stored in table S_TimeExpenseLine). * * NOTE: This class should not be instantiated directly. To instantiate this * class the {@link org.openbravo.base.provider.OBProvider} should be used. */ public class SheetLine extends BaseOBObject implements Traceable, ClientEnabled, OrganizationEnabled, ActiveEnabled { private static final long serialVersionUID = 1L; public static final String TABLE_NAME = "S_TimeExpenseLine"; public static final String TimeAndExpenseSheetLine = "TimeAndExpenseSheetLine"; 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_EXPENSESHEET = "expenseSheet"; public static final String PROPERTY_LINENO = "lineNo"; public static final String PROPERTY_TIMESHEET = "timeSheet"; public static final String PROPERTY_EXPENSEDATE = "expenseDate"; public static final String PROPERTY_PRODUCT = "product"; public static final String PROPERTY_QUANTITY = "quantity"; public static final String PROPERTY_EXPENSEAMOUNT = "expenseAmount"; public static final String PROPERTY_CURRENCY = "currency"; public static final String PROPERTY_CONVERTEDAMOUNT = "convertedAmount"; public static final String PROPERTY_RESOURCEASSIGNMENT = "resourceAssignment"; public static final String PROPERTY_DESCRIPTION = "description"; public static final String PROPERTY_COMMENTS = "comments"; public static final String PROPERTY_REINVOICE = "reinvoice"; public static final String PROPERTY_BUSINESSPARTNER = "businessPartner"; public static final String PROPERTY_PROJECT = "project"; public static final String PROPERTY_ACTIVITY = "activity"; public static final String PROPERTY_SALESCAMPAIGN = "salesCampaign"; public static final String PROPERTY_INVOICELINE = "invoiceLine"; public static final String PROPERTY_INVOICEPRICE = "invoicePrice"; public static final String PROPERTY_UOM = "uOM"; public static final String PROPERTY_SALESORDERLINE = "salesOrderLine"; public static final String PROPERTY_PROJECTPHASE = "projectPhase"; public static final String PROPERTY_PROJECTTASK = "projectTask"; public static final String PROPERTY_TIMETYPE = "timeType"; public SheetLine() { setDefaultValue(PROPERTY_ACTIVE, true); setDefaultValue(PROPERTY_TIMESHEET, false); setDefaultValue(PROPERTY_QUANTITY, new BigDecimal(1)); setDefaultValue(PROPERTY_REINVOICE, false); } @Override public String getEntityName() { return TimeAndExpenseSheetLine; } 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 Sheet getExpenseSheet() { return (Sheet) get(PROPERTY_EXPENSESHEET); } public void setExpenseSheet(Sheet expenseSheet) { set(PROPERTY_EXPENSESHEET, expenseSheet); } public Long getLineNo() { return (Long) get(PROPERTY_LINENO); } public void setLineNo(Long lineNo) { set(PROPERTY_LINENO, lineNo); } public Boolean isTimeSheet() { return (Boolean) get(PROPERTY_TIMESHEET); } public void setTimeSheet(Boolean timeSheet) { set(PROPERTY_TIMESHEET, timeSheet); } public Date getExpenseDate() { return (Date) get(PROPERTY_EXPENSEDATE); } public void setExpenseDate(Date expenseDate) { set(PROPERTY_EXPENSEDATE, expenseDate); } public Product getProduct() { return (Product) get(PROPERTY_PRODUCT); } public void setProduct(Product product) { set(PROPERTY_PRODUCT, product); } public BigDecimal getQuantity() { return (BigDecimal) get(PROPERTY_QUANTITY); } public void setQuantity(BigDecimal quantity) { set(PROPERTY_QUANTITY, quantity); } public BigDecimal getExpenseAmount() { return (BigDecimal) get(PROPERTY_EXPENSEAMOUNT); } public void setExpenseAmount(BigDecimal expenseAmount) { set(PROPERTY_EXPENSEAMOUNT, expenseAmount); } public Currency getCurrency() { return (Currency) get(PROPERTY_CURRENCY); } public void setCurrency(Currency currency) { set(PROPERTY_CURRENCY, currency); } public BigDecimal getConvertedAmount() { return (BigDecimal) get(PROPERTY_CONVERTEDAMOUNT); } public void setConvertedAmount(BigDecimal convertedAmount) { set(PROPERTY_CONVERTEDAMOUNT, convertedAmount); } public ResourceAssignment getResourceAssignment() { return (ResourceAssignment) get(PROPERTY_RESOURCEASSIGNMENT); } public void setResourceAssignment(ResourceAssignment resourceAssignment) { set(PROPERTY_RESOURCEASSIGNMENT, resourceAssignment); } public String getDescription() { return (String) get(PROPERTY_DESCRIPTION); } public void setDescription(String description) { set(PROPERTY_DESCRIPTION, description); } public String getComments() { return (String) get(PROPERTY_COMMENTS); } public void setComments(String comments) { set(PROPERTY_COMMENTS, comments); } public Boolean isReinvoice() { return (Boolean) get(PROPERTY_REINVOICE); } public void setReinvoice(Boolean reinvoice) { set(PROPERTY_REINVOICE, reinvoice); } public BusinessPartner getBusinessPartner() { return (BusinessPartner) get(PROPERTY_BUSINESSPARTNER); } public void setBusinessPartner(BusinessPartner businessPartner) { set(PROPERTY_BUSINESSPARTNER, businessPartner); } public Project getProject() { return (Project) get(PROPERTY_PROJECT); } public void setProject(Project project) { set(PROPERTY_PROJECT, project); } public ABCActivity getActivity() { return (ABCActivity) get(PROPERTY_ACTIVITY); } public void setActivity(ABCActivity activity) { set(PROPERTY_ACTIVITY, activity); } public Campaign getSalesCampaign() { return (Campaign) get(PROPERTY_SALESCAMPAIGN); } public void setSalesCampaign(Campaign salesCampaign) { set(PROPERTY_SALESCAMPAIGN, salesCampaign); } public InvoiceLine getInvoiceLine() { return (InvoiceLine) get(PROPERTY_INVOICELINE); } public void setInvoiceLine(InvoiceLine invoiceLine) { set(PROPERTY_INVOICELINE, invoiceLine); } public BigDecimal getInvoicePrice() { return (BigDecimal) get(PROPERTY_INVOICEPRICE); } public void setInvoicePrice(BigDecimal invoicePrice) { set(PROPERTY_INVOICEPRICE, invoicePrice); } public org.openbravo.model.common.uom.UOM getUOM() { return (org.openbravo.model.common.uom.UOM) get(PROPERTY_UOM); } public void setUOM(org.openbravo.model.common.uom.UOM uOM) { set(PROPERTY_UOM, uOM); } public OrderLine getSalesOrderLine() { return (OrderLine) get(PROPERTY_SALESORDERLINE); } public void setSalesOrderLine(OrderLine salesOrderLine) { set(PROPERTY_SALESORDERLINE, salesOrderLine); } public ProjectPhase getProjectPhase() { return (ProjectPhase) get(PROPERTY_PROJECTPHASE); } public void setProjectPhase(ProjectPhase projectPhase) { set(PROPERTY_PROJECTPHASE, projectPhase); } public ProjectTask getProjectTask() { return (ProjectTask) get(PROPERTY_PROJECTTASK); } public void setProjectTask(ProjectTask projectTask) { set(PROPERTY_PROJECTTASK, projectTask); } public TimeType getTimeType() { return (TimeType) get(PROPERTY_TIMETYPE); } public void setTimeType(TimeType timeType) { set(PROPERTY_TIMETYPE, timeType); } }