View source | Discuss this page | Page history | Printable version   

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.
Back button.png   Back to ERP/3.0/Developers_Guide/Reference/Entity_Model#TimeAndExpenseSheet


TimeAndExpenseSheet

Contains the time and expenses for the Employee or Contractor (Business Partner)

To the database table (S_TimeExpense) of this entity.

Properties

Note:

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);
     }
 }

Retrieved from "http://wiki.openbravo.com/wiki/ERP/3.0/Developers_Guide/Reference/Entity_Model/TimeAndExpenseSheet"

This page has been accessed 1,939 times. This page was last modified on 30 November 2020, at 01:56. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.