Class Table

    • Field Detail

      • PROPERTY_ID

        public static final String PROPERTY_ID
        Property id stored in column AD_Table_ID in table AD_Table
        Help: The Table indicates the table in which a field or fields reside.
        See Also:
        Constant Field Values
      • PROPERTY_CREATIONDATE

        public static final String PROPERTY_CREATIONDATE
        Property creationDate stored in column Created in table AD_Table
        See Also:
        Traceable, Constant Field Values
      • PROPERTY_NAME

        public static final String PROPERTY_NAME
        Property name stored in column Name in table AD_Table
        Help: A more descriptive identifier (that does need to be unique) of a record/document that is used as a default search option along with the search key (that is unique and mostly shorter). It is up to 60 characters in length.
        See Also:
        Constant Field Values
      • PROPERTY_DESCRIPTION

        public static final String PROPERTY_DESCRIPTION
        Property description stored in column Description in table AD_Table
        Help: A description is limited to 255 characters.
        See Also:
        Constant Field Values
      • PROPERTY_HELPCOMMENT

        public static final String PROPERTY_HELPCOMMENT
        Property helpComment stored in column Help in table AD_Table
        Help: The Help field contains a hint, comment or help about the use of this item.
        See Also:
        Constant Field Values
      • PROPERTY_DBTABLENAME

        public static final String PROPERTY_DBTABLENAME
        Property dBTableName stored in column TableName in table AD_Table
        See Also:
        Constant Field Values
      • PROPERTY_JAVACLASSNAME

        public static final String PROPERTY_JAVACLASSNAME
        Property javaClassName stored in column Classname in table AD_Table
        Help: The classname is used when generating a representation of the table in java (the entity or business object). The classname is the simplename of the class (so without the package name). Often the AD_Table.name can be used here. The combination of classname and package needs to be unique.
        See Also:
        Constant Field Values
      • PROPERTY_VIEW

        public static final String PROPERTY_VIEW
        Property view stored in column IsView in table AD_Table
        Help: This is a view rather than a table. A view is always treated as read only in the system.
        See Also:
        Constant Field Values
      • PROPERTY_DATAACCESSLEVEL

        public static final String PROPERTY_DATAACCESSLEVEL
        Property dataAccessLevel stored in column AccessLevel in table AD_Table
        Help: Indicates what type of data (in terms of AD_CLIENT and AD_ORG data columns) can be entered or viewed. We can classify data in 4 major categories: - System (AD_CLIENT_ID=0, AD_ORG_ID=0) - system data (such as metadata for window, tab and field definition) - Organization (AD_CLIENT<>0, AD_ORG_ID<>0) - data particular to an organization (such as sales orders) - Client/Organization (AD_CLIENT<>0, AD_ORG_ID=anything) - data particular to an organization or shared among all organizations within one client - Client (AD_CLIENT<>0, AD_ORG_ID=0) - data that is specific to a client but can be used by all organizations within that client or All (AD_CLIENT=anything, AD_ORG_ID=anything)
        See Also:
        Constant Field Values
      • PROPERTY_WINDOW

        public static final String PROPERTY_WINDOW
        Property window stored in column AD_Window_ID in table AD_Table
        Help: The Window field identifies a unique Window in the system.
        See Also:
        Constant Field Values
      • PROPERTY_SECURITYENABLED

        public static final String PROPERTY_SECURITYENABLED
        Property securityEnabled stored in column IsSecurityEnabled in table AD_Table
        Help: The Security Enabled checkbox indicates that user access to the data in this table can be restricted using Roles.
        See Also:
        Constant Field Values
      • PROPERTY_DELETABLERECORDS

        public static final String PROPERTY_DELETABLERECORDS
        Property deletableRecords stored in column IsDeleteable in table AD_Table
        Help: The Deleteable Records checkbox indicates if a record can be deleted from the database. If records cannot be deleted, you can only deselect the Active flag
        See Also:
        Constant Field Values
      • PROPERTY_HIGHVOLUME

        public static final String PROPERTY_HIGHVOLUME
        Property highVolume stored in column IsHighVolume in table AD_Table
        Help: If a table is defined as High Volume, it means that it has or may have a large number of rows.
        See Also:
        Constant Field Values
      • PROPERTY_IMPORTTABLE

        public static final String PROPERTY_IMPORTTABLE
        Property importTable stored in column ImportTable in table AD_Table
        Help: Import Table Columns from Database, this process will create in the application dictionary those columns defined in the table (in DB) but non-existing in the column table (of the application dictionary).
        See Also:
        Constant Field Values
      • PROPERTY_MAINTAINCHANGELOG

        public static final String PROPERTY_MAINTAINCHANGELOG
        Property maintainChangeLog stored in column IsChangeLog in table AD_Table
        Help: If selected, a log of all changes is maintained.
        See Also:
        Constant Field Values
      • PROPERTY_POWINDOW

        public static final String PROPERTY_POWINDOW
        Property pOWindow stored in column PO_Window_ID in table AD_Table
        Help: Window for Purchase Order (AP) Zooms
        See Also:
        Constant Field Values
      • PROPERTY_DEFAULTACCOUNT

        public static final String PROPERTY_DEFAULTACCOUNT
        Property defaultAccount stored in column IsDefaultAcct in table AD_Table
        Help: Is default account
        See Also:
        Constant Field Values
      • PROPERTY_SQLRECORDIDENTIFIER

        public static final String PROPERTY_SQLRECORDIDENTIFIER
        Property sQLRecordIdentifier stored in column SQL_Record_Identifier in table AD_Table
        Help: SQL_Record_Identifier
        See Also:
        Constant Field Values
      • PROPERTY_DEVELOPMENTSTATUS

        public static final String PROPERTY_DEVELOPMENTSTATUS
        Property developmentStatus stored in column Developmentstatus in table AD_Table
        Help: Development Status defines the status of a table or a column. Ready means that this object is in use, Not Implemented Yet indicates that currently it is not in use but it is planned to be implemented and Deprecated are the objects that are going to be removed from the application in future versions.
        See Also:
        Constant Field Values
      • PROPERTY_DATAPACKAGE

        public static final String PROPERTY_DATAPACKAGE
        Property dataPackage stored in column AD_Package_ID in table AD_Table
        Help: An AD_Table record has a mandatory relation to a package (the AD_Package). Choose a sensible package fitting to the functional area to which the table applies (so not the Core package). If no such package exist then create a new one. The relation to the module is maintained through the AD_Package, so an AD_Table has an AD_Package which belongs to a module. When developing for a module then first a package needs to be defined in AD_Package, linked to the module. Then the records in AD_Table (for that module) can be linked to that package.
        See Also:
        Constant Field Values
      • PROPERTY_TREETYPE

        public static final String PROPERTY_TREETYPE
        Property treeType stored in column Treetype in table AD_Table
        Help: The Tree Type / Area field determines the type of tree this is. For example, you may define one tree for your Products and another tree for your Business Partners.
        See Also:
        Constant Field Values
      • PROPERTY_ACCTDATECOLUMN

        public static final String PROPERTY_ACCTDATECOLUMN
        Property acctdateColumn stored in column Acctdate_Column_ID in table AD_Table
        Help: Date reference column where is stored the accounting date
        See Also:
        Constant Field Values
      • PROPERTY_ACCTCLASSNAME

        public static final String PROPERTY_ACCTCLASSNAME
        Property acctclassname stored in column Acctclassname in table AD_Table
        Help: Java class name where the posting of table is developed
        See Also:
        Constant Field Values
      • PROPERTY_ISFULLYAUDITED

        public static final String PROPERTY_ISFULLYAUDITED
        Property isFullyAudited stored in column IsFullyAudited in table AD_Table
        Help: If audit trail is maintained for a table, each modification performed to any record in this table will be tracked. Do not forget to generate Audit infrastructure after selecting or deselecting a table to be audited.
        See Also:
        Constant Field Values
      • PROPERTY_ISAUDITINSERTS

        public static final String PROPERTY_ISAUDITINSERTS
        Property isAuditInserts stored in column IsAuditInserts in table AD_Table
        Help: If this flag is checked, if when a record is inserted in an audited table the initial value of all its columns will be saved in the audit table. Usually there is no need to save all columns, because the original column values of the record can be recreated based on their current value and on their modification history.
        See Also:
        Constant Field Values
      • PROPERTY_DATAORIGINTYPE

        public static final String PROPERTY_DATAORIGINTYPE
        Property dataOriginType stored in column DataOriginType in table AD_Table
        Help: Field to specify the type of data origin: physical table/view or datasource
        See Also:
        Constant Field Values
      • PROPERTY_OBSERDSDATASOURCE

        public static final String PROPERTY_OBSERDSDATASOURCE
        Property obserdsDatasource stored in column Obserds_Datasource_ID in table AD_Table
        Help: Datasource used to feed the table
        See Also:
        Constant Field Values
      • PROPERTY_ISTREE

        public static final String PROPERTY_ISTREE
        Property istree stored in column Istree in table AD_Table
        Help: If a table is defined as a tree, then the Table Tree Category tab is shown in this window. In that tab, tree categories can be assigned to this table. Once a tree table has defined a table tree category, it can be used in tree referenced and the tree view will be available when the table is displayed in a tab.
        See Also:
        Constant Field Values
      • PROPERTY_HQLQUERY

        public static final String PROPERTY_HQLQUERY
        Property hqlQuery stored in column HqlQuery in table AD_Table
        Help: HQL query used to populate the table
        See Also:
        Constant Field Values
      • PROPERTY_ENTITYALIAS

        public static final String PROPERTY_ENTITYALIAS
        Property entityAlias stored in column Entity_Alias in table AD_Table
        Help: In case that the the selector's table has an alias in the HQL it is mandatory to set it on this field. This alias is used to add some mandatory filters on the Where clause replacing the @additional_filters@ string. Some examples of added filters are: client, organization and active flag.
        See Also:
        Constant Field Values
      • PROPERTY_ADCOLUMNLIST

        public static final String PROPERTY_ADCOLUMNLIST
        Property aDColumnList stored in table AD_Table
        See Also:
        Constant Field Values
      • PROPERTY_ADTABLIST

        public static final String PROPERTY_ADTABLIST
        Property aDTabList stored in table AD_Table
        See Also:
        Constant Field Values
      • PROPERTY_ADTABLEACCESSLIST

        public static final String PROPERTY_ADTABLEACCESSLIST
        Property aDTableAccessList stored in table AD_Table
        See Also:
        Constant Field Values
      • PROPERTY_ADTABLETREELIST

        public static final String PROPERTY_ADTABLETREELIST
        Property aDTableTreeList stored in table AD_Table
        See Also:
        Constant Field Values
      • PROPERTY_ADTREELIST

        public static final String PROPERTY_ADTREELIST
        Property aDTreeList stored in table AD_Table
        See Also:
        Constant Field Values
    • Constructor Detail

      • Table

        public Table()