ERP 2.50:Developers Guide/Reference/Entity Model/ADReferencedTable
ADReferencedTable
The Table Validation Tab defines tables to validate data
To the database table (AD_Ref_Table) 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* | AD_Reference_ID | Mandatory Max Length: 22 | java.lang.String | The Reference indicates the type of reference field |
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. |
table | AD_Table_ID | Mandatory | ADTable | The Table indicates the table in which a field or fields reside. |
keyColumn | AD_Key | Mandatory | ADColumn | The Key Column indicates that this the unique identifier of a record on this table. |
displayedColumn | AD_Display | Mandatory | ADColumn | The Display Column indicates the column that will display. |
displayedValue | IsValueDisplayed | Mandatory | java.lang.Boolean | The Display Value checkbox indicates if the value column will display with the display column. |
sQLWhereClause | WhereClause | Max Length: 2000 | java.lang.String | The Where Clause indicates the SQL WHERE clause to use for record selection. The WHERE clause is added to the query. Fully qualified means "tablename.columnname". |
sQLOrderByClause | OrderByClause | Max Length: 2000 | java.lang.String | The ORDER BY Clause indicates the SQL ORDER BY clause to use for record selection |
hqlwhereclause | Hqlwhereclause | Max Length: 2000 | java.lang.String | |
hqlorderbyclause | Hqlorderbyclause | Max Length: 2000 | java.lang.String | |
reference# | AD_Reference_ID | Mandatory | ADReference | The Reference indicates the type of reference field |
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.ad.domain; 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.datamodel.Column; import org.openbravo.model.ad.datamodel.Table; import org.openbravo.model.ad.system.Client; import org.openbravo.model.common.enterprise.Organization; import java.lang.Boolean; import java.lang.String; import java.util.Date; /** * Entity class for entity ADReferencedTable (stored in table AD_Ref_Table). * * NOTE: This class should not be instantiated directly. To instantiate this * class the {@link org.openbravo.base.provider.OBProvider} should be used. */ public class ReferencedTable extends BaseOBObject implements Traceable, ClientEnabled, OrganizationEnabled, ActiveEnabled { private static final long serialVersionUID = 1L; public static final String TABLE_NAME = "AD_Ref_Table"; public static final String ADReferencedTable = "ADReferencedTable"; 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_TABLE = "table"; public static final String PROPERTY_KEYCOLUMN = "keyColumn"; public static final String PROPERTY_DISPLAYEDCOLUMN = "displayedColumn"; public static final String PROPERTY_DISPLAYEDVALUE = "displayedValue"; public static final String PROPERTY_SQLWHERECLAUSE = "sQLWhereClause"; public static final String PROPERTY_SQLORDERBYCLAUSE = "sQLOrderByClause"; public static final String PROPERTY_HQLWHERECLAUSE = "hqlwhereclause"; public static final String PROPERTY_HQLORDERBYCLAUSE = "hqlorderbyclause"; public static final String PROPERTY_REFERENCE = "reference"; public ReferencedTable() { setDefaultValue(PROPERTY_ACTIVE, true); setDefaultValue(PROPERTY_DISPLAYEDVALUE, false); } @Override public String getEntityName() { return ADReferencedTable; } 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 Table getTable() { return (Table) get(PROPERTY_TABLE); } public void setTable(Table table) { set(PROPERTY_TABLE, table); } public Column getKeyColumn() { return (Column) get(PROPERTY_KEYCOLUMN); } public void setKeyColumn(Column keyColumn) { set(PROPERTY_KEYCOLUMN, keyColumn); } public Column getDisplayedColumn() { return (Column) get(PROPERTY_DISPLAYEDCOLUMN); } public void setDisplayedColumn(Column displayedColumn) { set(PROPERTY_DISPLAYEDCOLUMN, displayedColumn); } public Boolean isDisplayedValue() { return (Boolean) get(PROPERTY_DISPLAYEDVALUE); } public void setDisplayedValue(Boolean displayedValue) { set(PROPERTY_DISPLAYEDVALUE, displayedValue); } public String getSQLWhereClause() { return (String) get(PROPERTY_SQLWHERECLAUSE); } public void setSQLWhereClause(String sQLWhereClause) { set(PROPERTY_SQLWHERECLAUSE, sQLWhereClause); } public String getSQLOrderByClause() { return (String) get(PROPERTY_SQLORDERBYCLAUSE); } public void setSQLOrderByClause(String sQLOrderByClause) { set(PROPERTY_SQLORDERBYCLAUSE, sQLOrderByClause); } public String getHqlwhereclause() { return (String) get(PROPERTY_HQLWHERECLAUSE); } public void setHqlwhereclause(String hqlwhereclause) { set(PROPERTY_HQLWHERECLAUSE, hqlwhereclause); } public String getHqlorderbyclause() { return (String) get(PROPERTY_HQLORDERBYCLAUSE); } public void setHqlorderbyclause(String hqlorderbyclause) { set(PROPERTY_HQLORDERBYCLAUSE, hqlorderbyclause); } public Reference getReference() { return (Reference) get(PROPERTY_REFERENCE); } public void setReference(Reference reference) { set(PROPERTY_REFERENCE, reference); } }