ERP/3.0/Developers Guide/Reference/Entity Model/TimeAndExpenseSheet
This article is protected against manual editing because it is automatically generated from Openbravo meta-data. Learn more about writing and translating such documents.
TimeAndExpenseSheet
Contains the time and expenses for the Employee or Contractor (Business Partner)
To the database table (S_TimeExpense) 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_TimeExpense_ID | Mandatory Max Length: 32 | java.lang.String | The ID identifies a unique record for the expense report |
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. |
documentNo# | DocumentNo | Mandatory Max Length: 30 | java.lang.String | The document number is usually automatically generated by the system and determined by the document type of the document. If the document is not saved, the preliminary number is displayed in "<>". If the document type of your document has no automatic document sequence defined, the field will be empty when creating a new document. This is for documents which usually have an external number (like vendor invoice). If you leave the field empty, the system will generate a document number for you. The document sequence used for this fallback number is defined in the "Document Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table inside the database (e.g. C_Order). |
businessPartner# | C_BPartner_ID | Mandatory | BusinessPartner | A Business Partner is anyone with whom you transact. This can include a customer, vendor, employee or any combination of these. |
reportDate# | DateReport | Mandatory | java.util.Date | Date of Expense/Time Report |
description | Description | Max Length: 255 | java.lang.String | A description is limited to 255 characters. |
processNow | Processing | java.lang.Boolean | When this field is set as 'Y' a process is being performed on this record. | |
processed | Processed | Mandatory Max Length: 60 | java.lang.String | The Processed checkbox indicates that a document has been processed. |
priceList | M_Pricelist_ID | PricingPriceList |
Price Lists are used to determine the pricing, margin and cost of items purchased or sold. | |
warehouse | M_Warehouse_ID | Warehouse | The Warehouse identifies a unique Warehouse where products are stored or Services are provided. | |
posted | Posted | Mandatory Max Length: 60 | java.lang.String | An accounting status button that indicates if the transaction has already been posted to the general ledger or not. When doing the accounting manually this button can be used to post or unpost the transaction from the general ledger by hand. |
stDimension | User1_ID | UserDimension1 | The user defined element displays the optional elements that have been defined for this account combination. | |
ndDimension | User2_ID | UserDimension2 | The user defined element displays the optional elements that have been defined for this account combination. | |
costCenter | C_Costcenter_ID | Costcenter | Division that adds to the cost of an organization. Internal structure for cost allocation. | |
asset | A_Asset_ID | FinancialMgmtAsset | Any item of economic value owned by the corporation, especially that which could be converted to cash. | |
project | C_Project_ID | Project | Identifier of a project defined within the Project & Service Management module. | |
processedLogic | processed_logic | java.lang.Boolean | The Processed checkbox indicates that a document has been processed. | |
timeAndExpenseSheetLineList | TimeAndExpenseSheetLine |
|
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-2020 Openbravo SLU * All Rights Reserved. * Contributor(s): ______________________________________. ************************************************************************ */ package org.openbravo.model.timeandexpense; import java.util.ArrayList; import java.util.Date; import java.util.List; 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.enterprise.Organization; import org.openbravo.model.common.enterprise.Warehouse; import org.openbravo.model.financialmgmt.accounting.Costcenter; import org.openbravo.model.financialmgmt.accounting.UserDimension1; import org.openbravo.model.financialmgmt.accounting.UserDimension2; import org.openbravo.model.financialmgmt.assetmgmt.Asset; import org.openbravo.model.pricing.pricelist.PriceList; import org.openbravo.model.project.Project; /** * Entity class for entity TimeAndExpenseSheet (stored in table S_TimeExpense). * <br> * Help: {@literal Contains the time and expenses for the Employee or Contractor (Business Partner)} * <br> * NOTE: This class should not be instantiated directly. To instantiate this * class the {@link org.openbravo.base.provider.OBProvider} should be used. */ public class Sheet extends BaseOBObject implements Traceable, ClientEnabled, OrganizationEnabled, ActiveEnabled { private static final long serialVersionUID = 1L; public static final String TABLE_NAME = "S_TimeExpense"; public static final String ENTITY_NAME = "TimeAndExpenseSheet"; /** * Property id stored in column S_TimeExpense_ID in table S_TimeExpense<br> * Help: {@literal The ID identifies a unique record for the expense report} * */ public static final String PROPERTY_ID = "id"; /** * Property client stored in column AD_Client_ID in table S_TimeExpense * @see ClientEnabled * */ public static final String PROPERTY_CLIENT = "client"; /** * Property organization stored in column AD_Org_ID in table S_TimeExpense * @see OrganizationEnabled * */ public static final String PROPERTY_ORGANIZATION = "organization"; /** * Property active stored in column IsActive in table S_TimeExpense * @see ActiveEnabled * */ public static final String PROPERTY_ACTIVE = "active"; /** * Property creationDate stored in column Created in table S_TimeExpense * @see Traceable * */ public static final String PROPERTY_CREATIONDATE = "creationDate"; /** * Property createdBy stored in column CreatedBy in table S_TimeExpense * @see Traceable * */ public static final String PROPERTY_CREATEDBY = "createdBy"; /** * Property updated stored in column Updated in table S_TimeExpense * @see Traceable * */ public static final String PROPERTY_UPDATED = "updated"; /** * Property updatedBy stored in column UpdatedBy in table S_TimeExpense * @see Traceable * */ public static final String PROPERTY_UPDATEDBY = "updatedBy"; /** * Property documentNo stored in column DocumentNo in table S_TimeExpense * */ public static final String PROPERTY_DOCUMENTNO = "documentNo"; /** * Property businessPartner stored in column C_BPartner_ID in table S_TimeExpense<br> * Help: {@literal A Business Partner is anyone with whom you transact. This can include a customer, vendor, * employee or any combination of these.} * */ public static final String PROPERTY_BUSINESSPARTNER = "businessPartner"; /** * Property reportDate stored in column DateReport in table S_TimeExpense * */ public static final String PROPERTY_REPORTDATE = "reportDate"; /** * Property description stored in column Description in table S_TimeExpense<br> * Help: {@literal A description is limited to 255 characters.} * */ public static final String PROPERTY_DESCRIPTION = "description"; /** * Property processNow stored in column Processing in table S_TimeExpense<br> * Help: {@literal When this field is set as 'Y' a process is being performed on this record.} * */ public static final String PROPERTY_PROCESSNOW = "processNow"; /** * Property processed stored in column Processed in table S_TimeExpense<br> * Help: {@literal The Processed checkbox indicates that a document has been processed.} * */ public static final String PROPERTY_PROCESSED = "processed"; /** * Property priceList stored in column M_Pricelist_ID in table S_TimeExpense<br> * Help: {@literal * Price Lists are used to determine the pricing, margin and cost of items purchased or * sold.} * */ public static final String PROPERTY_PRICELIST = "priceList"; /** * Property warehouse stored in column M_Warehouse_ID in table S_TimeExpense<br> * Help: {@literal The Warehouse identifies a unique Warehouse where products are stored or Services are * provided.} * */ public static final String PROPERTY_WAREHOUSE = "warehouse"; /** * Property posted stored in column Posted in table S_TimeExpense<br> * Help: {@literal An accounting status button that indicates if the transaction has already been posted to * the general ledger or not. When doing the accounting manually this button can be used to post or * unpost the transaction from the general ledger by hand.} * */ public static final String PROPERTY_POSTED = "posted"; /** * Property stDimension stored in column User1_ID in table S_TimeExpense<br> * Help: {@literal The user defined element displays the optional elements that have been defined for this * account combination.} * */ public static final String PROPERTY_STDIMENSION = "stDimension"; /** * Property ndDimension stored in column User2_ID in table S_TimeExpense<br> * Help: {@literal The user defined element displays the optional elements that have been defined for this * account combination.} * */ public static final String PROPERTY_NDDIMENSION = "ndDimension"; /** * Property costCenter stored in column C_Costcenter_ID in table S_TimeExpense<br> * Help: {@literal Division that adds to the cost of an organization. Internal structure for cost * allocation.} * */ public static final String PROPERTY_COSTCENTER = "costCenter"; /** * Property asset stored in column A_Asset_ID in table S_TimeExpense<br> * Help: {@literal Any item of economic value owned by the corporation, especially that which could be * converted to cash.} * */ public static final String PROPERTY_ASSET = "asset"; /** * Property project stored in column C_Project_ID in table S_TimeExpense<br> * Help: {@literal Identifier of a project defined within the Project & Service Management module.} * */ public static final String PROPERTY_PROJECT = "project"; /** * Property _computedColumns stored in column _computedColumns in table S_TimeExpense * */ public static final String PROPERTY__COMPUTEDCOLUMNS = "_computedColumns"; /** * Property timeAndExpenseSheetLineList stored in table S_TimeExpense * */ public static final String PROPERTY_TIMEANDEXPENSESHEETLINELIST = "timeAndExpenseSheetLineList"; /** * Computed columns properties, these properties cannot be directly accessed, they need * to be read through _computedColumns proxy. They cannot be directly used in HQL, OBQuery * nor OBCriteria. */ /** * Computed column for property processedLogic<br> * * Help: {@literal The Processed checkbox indicates that a document has been processed.}<br> * Computed from: <br> * {@code select processed from S_TimeExpense TE where TE.S_TimeExpense_id=S_TimeExpense_id} */ public static final String COMPUTED_COLUMN_PROCESSEDLOGIC = "processedLogic"; public Sheet() { setDefaultValue(PROPERTY_ACTIVE, true); setDefaultValue(PROPERTY_PROCESSNOW, false); setDefaultValue(PROPERTY_POSTED, "N"); setDefaultValue(PROPERTY_TIMEANDEXPENSESHEETLINELIST, new ArrayList<Object>()); } @Override public String getEntityName() { return ENTITY_NAME; } /** * @see Sheet#PROPERTY_ID * */ public String getId() { return (String) get(PROPERTY_ID); } /** * @see Sheet#PROPERTY_ID * */ public void setId(String id) { set(PROPERTY_ID, id); } /** * @see Sheet#PROPERTY_CLIENT * */ public Client getClient() { return (Client) get(PROPERTY_CLIENT); } /** * @see Sheet#PROPERTY_CLIENT * */ public void setClient(Client client) { set(PROPERTY_CLIENT, client); } /** * @see Sheet#PROPERTY_ORGANIZATION * */ public Organization getOrganization() { return (Organization) get(PROPERTY_ORGANIZATION); } /** * @see Sheet#PROPERTY_ORGANIZATION * */ public void setOrganization(Organization organization) { set(PROPERTY_ORGANIZATION, organization); } /** * @see Sheet#PROPERTY_ACTIVE * */ public Boolean isActive() { return (Boolean) get(PROPERTY_ACTIVE); } /** * @see Sheet#PROPERTY_ACTIVE * */ public void setActive(Boolean active) { set(PROPERTY_ACTIVE, active); } /** * @see Sheet#PROPERTY_CREATIONDATE * */ public Date getCreationDate() { return (Date) get(PROPERTY_CREATIONDATE); } /** * @see Sheet#PROPERTY_CREATIONDATE * */ public void setCreationDate(Date creationDate) { set(PROPERTY_CREATIONDATE, creationDate); } /** * @see Sheet#PROPERTY_CREATEDBY * */ public User getCreatedBy() { return (User) get(PROPERTY_CREATEDBY); } /** * @see Sheet#PROPERTY_CREATEDBY * */ public void setCreatedBy(User createdBy) { set(PROPERTY_CREATEDBY, createdBy); } /** * @see Sheet#PROPERTY_UPDATED * */ public Date getUpdated() { return (Date) get(PROPERTY_UPDATED); } /** * @see Sheet#PROPERTY_UPDATED * */ public void setUpdated(Date updated) { set(PROPERTY_UPDATED, updated); } /** * @see Sheet#PROPERTY_UPDATEDBY * */ public User getUpdatedBy() { return (User) get(PROPERTY_UPDATEDBY); } /** * @see Sheet#PROPERTY_UPDATEDBY * */ public void setUpdatedBy(User updatedBy) { set(PROPERTY_UPDATEDBY, updatedBy); } /** * @see Sheet#PROPERTY_DOCUMENTNO * */ public String getDocumentNo() { return (String) get(PROPERTY_DOCUMENTNO); } /** * @see Sheet#PROPERTY_DOCUMENTNO * */ public void setDocumentNo(String documentNo) { set(PROPERTY_DOCUMENTNO, documentNo); } /** * @see Sheet#PROPERTY_BUSINESSPARTNER * */ public BusinessPartner getBusinessPartner() { return (BusinessPartner) get(PROPERTY_BUSINESSPARTNER); } /** * @see Sheet#PROPERTY_BUSINESSPARTNER * */ public void setBusinessPartner(BusinessPartner businessPartner) { set(PROPERTY_BUSINESSPARTNER, businessPartner); } /** * @see Sheet#PROPERTY_REPORTDATE * */ public Date getReportDate() { return (Date) get(PROPERTY_REPORTDATE); } /** * @see Sheet#PROPERTY_REPORTDATE * */ public void setReportDate(Date reportDate) { set(PROPERTY_REPORTDATE, reportDate); } /** * @see Sheet#PROPERTY_DESCRIPTION * */ public String getDescription() { return (String) get(PROPERTY_DESCRIPTION); } /** * @see Sheet#PROPERTY_DESCRIPTION * */ public void setDescription(String description) { set(PROPERTY_DESCRIPTION, description); } /** * @see Sheet#PROPERTY_PROCESSNOW * */ public Boolean isProcessNow() { return (Boolean) get(PROPERTY_PROCESSNOW); } /** * @see Sheet#PROPERTY_PROCESSNOW * */ public void setProcessNow(Boolean processNow) { set(PROPERTY_PROCESSNOW, processNow); } /** * @see Sheet#PROPERTY_PROCESSED * */ public String getProcessed() { return (String) get(PROPERTY_PROCESSED); } /** * @see Sheet#PROPERTY_PROCESSED * */ public void setProcessed(String processed) { set(PROPERTY_PROCESSED, processed); } /** * @see Sheet#PROPERTY_PRICELIST * */ public PriceList getPriceList() { return (PriceList) get(PROPERTY_PRICELIST); } /** * @see Sheet#PROPERTY_PRICELIST * */ public void setPriceList(PriceList priceList) { set(PROPERTY_PRICELIST, priceList); } /** * @see Sheet#PROPERTY_WAREHOUSE * */ public Warehouse getWarehouse() { return (Warehouse) get(PROPERTY_WAREHOUSE); } /** * @see Sheet#PROPERTY_WAREHOUSE * */ public void setWarehouse(Warehouse warehouse) { set(PROPERTY_WAREHOUSE, warehouse); } /** * @see Sheet#PROPERTY_POSTED * */ public String getPosted() { return (String) get(PROPERTY_POSTED); } /** * @see Sheet#PROPERTY_POSTED * */ public void setPosted(String posted) { set(PROPERTY_POSTED, posted); } /** * @see Sheet#PROPERTY_STDIMENSION * */ public UserDimension1 getStDimension() { return (UserDimension1) get(PROPERTY_STDIMENSION); } /** * @see Sheet#PROPERTY_STDIMENSION * */ public void setStDimension(UserDimension1 stDimension) { set(PROPERTY_STDIMENSION, stDimension); } /** * @see Sheet#PROPERTY_NDDIMENSION * */ public UserDimension2 getNdDimension() { return (UserDimension2) get(PROPERTY_NDDIMENSION); } /** * @see Sheet#PROPERTY_NDDIMENSION * */ public void setNdDimension(UserDimension2 ndDimension) { set(PROPERTY_NDDIMENSION, ndDimension); } /** * @see Sheet#PROPERTY_COSTCENTER * */ public Costcenter getCostCenter() { return (Costcenter) get(PROPERTY_COSTCENTER); } /** * @see Sheet#PROPERTY_COSTCENTER * */ public void setCostCenter(Costcenter costCenter) { set(PROPERTY_COSTCENTER, costCenter); } /** * @see Sheet#PROPERTY_ASSET * */ public Asset getAsset() { return (Asset) get(PROPERTY_ASSET); } /** * @see Sheet#PROPERTY_ASSET * */ public void setAsset(Asset asset) { set(PROPERTY_ASSET, asset); } /** * @see Sheet#PROPERTY_PROJECT * */ public Project getProject() { return (Project) get(PROPERTY_PROJECT); } /** * @see Sheet#PROPERTY_PROJECT * */ public void setProject(Project project) { set(PROPERTY_PROJECT, project); } /** * @see Sheet#COMPUTED_COLUMN_PROCESSEDLOGIC * */ public Boolean isProcessedLogic() { return (Boolean) get(COMPUTED_COLUMN_PROCESSEDLOGIC); } /** * @see Sheet#COMPUTED_COLUMN_PROCESSEDLOGIC * */ public void setProcessedLogic(Boolean processedLogic) { set(COMPUTED_COLUMN_PROCESSEDLOGIC, processedLogic); } /** * @see Sheet#PROPERTY__COMPUTEDCOLUMNS * */ public Sheet_ComputedColumns get_computedColumns() { return (Sheet_ComputedColumns) get(PROPERTY__COMPUTEDCOLUMNS); } /** * @see Sheet#PROPERTY__COMPUTEDCOLUMNS * */ public void set_computedColumns(Sheet_ComputedColumns _computedColumns) { set(PROPERTY__COMPUTEDCOLUMNS, _computedColumns); } /** * Help: {@literal Contains all the expense items and billable or non-billable hours}<br> * @see SheetLine * */ @SuppressWarnings("unchecked") public List<SheetLine> getTimeAndExpenseSheetLineList() { return (List<SheetLine>) get(PROPERTY_TIMEANDEXPENSESHEETLINELIST); } /** * Help: {@literal Contains all the expense items and billable or non-billable hours}<br> * @see SheetLine * */ public void setTimeAndExpenseSheetLineList(List<SheetLine> timeAndExpenseSheetLineList) { set(PROPERTY_TIMEANDEXPENSESHEETLINELIST, timeAndExpenseSheetLineList); } @Override public Object get(String propName) { if (COMPUTED_COLUMN_PROCESSEDLOGIC.equals(propName)) { if (get_computedColumns() == null) { return null; } return get_computedColumns().isProcessedLogic(); } return super.get(propName); } }