Class Column

    • Field Detail

      • PROPERTY_ID

        public static final String PROPERTY_ID
        Property id stored in column AD_Column_ID in table AD_Column
        Help: Link to the database column of the table
        See Also:
        Constant Field Values
      • PROPERTY_CREATIONDATE

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

        public static final String PROPERTY_NAME
        Property name stored in column Name in table AD_Column
        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_Column
        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_Column
        Help: The Help field contains a hint, comment or help about the use of this item.
        See Also:
        Constant Field Values
      • PROPERTY_DBCOLUMNNAME

        public static final String PROPERTY_DBCOLUMNNAME
        Property dBColumnName stored in column ColumnName in table AD_Column
        See Also:
        Constant Field Values
      • PROPERTY_TABLE

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

        public static final String PROPERTY_REFERENCE
        Property reference stored in column AD_Reference_ID in table AD_Column
        Help: The Reference indicates the type of reference field
        See Also:
        Constant Field Values
      • PROPERTY_REFERENCESEARCHKEY

        public static final String PROPERTY_REFERENCESEARCHKEY
        Property referenceSearchKey stored in column AD_Reference_Value_ID in table AD_Column
        Help: The Reference Value indicates where the reference values are stored. It must be specified if the data type is Table or List.
        See Also:
        Constant Field Values
      • PROPERTY_VALIDATION

        public static final String PROPERTY_VALIDATION
        Property validation stored in column AD_Val_Rule_ID in table AD_Column
        Help: The Validation Rule indicates a unique validation rule. These rules define how an entry is determined to valid or invalid.
        See Also:
        Constant Field Values
      • PROPERTY_LENGTH

        public static final String PROPERTY_LENGTH
        Property length stored in column FieldLength in table AD_Column
        Help: The Length indicates the length of a column as defined in the database.
        See Also:
        Constant Field Values
      • PROPERTY_DEFAULTVALUE

        public static final String PROPERTY_DEFAULTVALUE
        Property defaultValue stored in column DefaultValue in table AD_Column
        Help: The defaults are evaluated in the order of definition, the first not null value becomes the default value of the column. The values are separated by comma or semicolon. a) Literals:. 'Text' or 123 b) Variables - in format @Variable@ - Login e.g. #Date, #AD_Org_ID, #AD_Client_ID - Accounting Schema: e.g. $C_AcctSchema_ID, $C_Calendar_ID - Global defaults: e.g. DateFormat - Window values (all Picks, CheckBoxes, RadioButtons, and DateDoc/DateAcct) c) SQL code with the tag: @SQL=SELECT something AS DefaultValue FROM ... The SQL statement can contain variables. There can be no other value other than the SQL statement. The default is only evaluated, if no user preference is defined. Default definitions are ignored for record columns as Key, Parent, Client as well as Buttons.
        See Also:
        Constant Field Values
      • PROPERTY_KEYCOLUMN

        public static final String PROPERTY_KEYCOLUMN
        Property keyColumn stored in column IsKey in table AD_Column
        Help: The key column must also be display sequence 0 in the field definition and may be hidden.
        See Also:
        Constant Field Values
      • PROPERTY_LINKTOPARENTCOLUMN

        public static final String PROPERTY_LINKTOPARENTCOLUMN
        Property linkToParentColumn stored in column IsParent in table AD_Column
        Help: The Parent checkbox indicates if this column is a link to the parent table.
        See Also:
        Constant Field Values
      • PROPERTY_MANDATORY

        public static final String PROPERTY_MANDATORY
        Property mandatory stored in column IsMandatory in table AD_Column
        Help: The Mandatory checkbox indicates if the field is required for a record to be save to the database.
        See Also:
        Constant Field Values
      • PROPERTY_UPDATABLE

        public static final String PROPERTY_UPDATABLE
        Property updatable stored in column IsUpdateable in table AD_Column
        Help: The Updateable checkbox indicates if a field can be updated by the user.
        See Also:
        Constant Field Values
      • PROPERTY_READONLYLOGIC

        public static final String PROPERTY_READONLYLOGIC
        Property readOnlyLogic stored in column ReadOnlyLogic in table AD_Column
        Help: Logic to determine if field is read only (applies only when field is read-write)
        See Also:
        Constant Field Values
      • PROPERTY_IDENTIFIER

        public static final String PROPERTY_IDENTIFIER
        Property identifier stored in column IsIdentifier in table AD_Column
        Help: The Identifier checkbox indicates that this column is part of the identifier or key for this table
        See Also:
        Constant Field Values
      • PROPERTY_SEQUENCENUMBER

        public static final String PROPERTY_SEQUENCENUMBER
        Property sequenceNumber stored in column SeqNo in table AD_Column
        Help: The Sequence indicates the order of records
        See Also:
        Constant Field Values
      • PROPERTY_TRANSLATION

        public static final String PROPERTY_TRANSLATION
        Property translation stored in column IsTranslated in table AD_Column
        Help: The Translated checkbox indicates if this column is translated.
        See Also:
        Constant Field Values
      • PROPERTY_DISPLAYENCRIPTION

        public static final String PROPERTY_DISPLAYENCRIPTION
        Property displayEncription stored in column IsEncrypted in table AD_Column
        Help: This option is deprecated. One of the new references "Password (decryptable)" or "Password (not-decryptable)" should be used instead.
        See Also:
        Constant Field Values
      • PROPERTY_CALLOUTFUNCTION

        public static final String PROPERTY_CALLOUTFUNCTION
        Property calloutFunction stored in column Callout in table AD_Column
        Help: Function Calls separated by semicolons; SE_/SL_/UE_/UL_ - 1st: System/User; 2nd: Enter/Leave; 3rd: _ Underscore, - then Function Name
        See Also:
        Constant Field Values
      • PROPERTY_VALUEFORMAT

        public static final String PROPERTY_VALUEFORMAT
        Property valueFormat stored in column VFormat in table AD_Column
        Help: Value Format is the format the value will be displayed with.
        See Also:
        Constant Field Values
      • PROPERTY_MINVALUE

        public static final String PROPERTY_MINVALUE
        Property minValue stored in column ValueMin in table AD_Column
        Help: The Minimum Value indicates the lowest allowable value for a field.
        See Also:
        Constant Field Values
      • PROPERTY_MAXVALUE

        public static final String PROPERTY_MAXVALUE
        Property maxValue stored in column ValueMax in table AD_Column
        Help: The Maximum Value indicates the highest allowable value for a field
        See Also:
        Constant Field Values
      • PROPERTY_FILTERCOLUMN

        public static final String PROPERTY_FILTERCOLUMN
        Property filterColumn stored in column IsSelectionColumn in table AD_Column
        Help: If selected, this column will be used in the Search Window as an available filter criteria.
        See Also:
        Constant Field Values
      • PROPERTY_APPLICATIONELEMENT

        public static final String PROPERTY_APPLICATIONELEMENT
        Property applicationElement stored in column AD_Element_ID in table AD_Column
        Help: The System Element allows for the central maintenance of help, descriptions and terminology for a database column.
        See Also:
        Constant Field Values
      • PROPERTY_PROCESS

        public static final String PROPERTY_PROCESS
        Property process stored in column AD_Process_ID in table AD_Column
        Help: The Process field identifies a unique Process or Report in the system.
        See Also:
        Constant Field Values
      • PROPERTY_STOREDINSESSION

        public static final String PROPERTY_STOREDINSESSION
        Property storedInSession stored in column IsSessionAttr in table AD_Column
        Help: Checking this field the data for this column will be stored as session attribute so its content will be accessible from other tab.
        See Also:
        Constant Field Values
      • PROPERTY_SECONDARYKEY

        public static final String PROPERTY_SECONDARYKEY
        Property secondaryKey stored in column IsSecondaryKey in table AD_Column
        Help: Is secondary key
        See Also:
        Constant Field Values
      • PROPERTY_DEENCRYPTABLE

        public static final String PROPERTY_DEENCRYPTABLE
        Property deencryptable stored in column IsDesencryptable in table AD_Column
        Help: This option is deprecated. Instead one of the new references "Password (decryptable)" or "Password (not-decryptable)" should be used instead.
        See Also:
        Constant Field Values
      • PROPERTY_CALLOUT

        public static final String PROPERTY_CALLOUT
        Property callout stored in column AD_Callout_ID in table AD_Column
        Help: The callout that will be fired when the content of a is modified.
        See Also:
        Constant Field Values
      • PROPERTY_DEVELOPMENTSTATUS

        public static final String PROPERTY_DEVELOPMENTSTATUS
        Property developmentStatus stored in column Developmentstatus in table AD_Column
        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_MODULE

        public static final String PROPERTY_MODULE
        Property module stored in column AD_Module_ID in table AD_Column
        Help: Indicates the module the element forms part of.
        See Also:
        Constant Field Values
      • PROPERTY_POSITION

        public static final String PROPERTY_POSITION
        Property position stored in column Position in table AD_Column
        Help: Determines the physical column position in database. It is a mandatory field which value is unique for all the columns within the same table.
        See Also:
        Constant Field Values
      • PROPERTY_TRANSIENT

        public static final String PROPERTY_TRANSIENT
        Property transient stored in column IsTransient in table AD_Column
        Help: Mark if a column is transient and will be ignored when comparing data
        See Also:
        Constant Field Values
      • PROPERTY_TRANSIENTCONDITION

        public static final String PROPERTY_TRANSIENTCONDITION
        Property transientCondition stored in column isTransientCondition in table AD_Column
        Help: Java expression that will be evaluated and if the result is false, the column will be marked as transient
        See Also:
        Constant Field Values
      • PROPERTY_ISAUTOSAVE

        public static final String PROPERTY_ISAUTOSAVE
        Property isautosave stored in column Isautosave in table AD_Column
        Help: If the value is 'Y' the autosave flag will be put in the form and the Autosave process will be triggered
        See Also:
        Constant Field Values
      • PROPERTY_VALIDATEONNEW

        public static final String PROPERTY_VALIDATEONNEW
        Property validateOnNew stored in column ValidateOnNew in table AD_Column
        Help: Indicates whether validations and callouts are executed when a new record is created. In general is should be set to Y. It makes sense to disable only in case there are callouts or validations associated to this column and it is known that when a new record is created they do not change any value; in this case this check allows to bypass their execution improving performance.
        See Also:
        Constant Field Values
      • PROPERTY_EXCLUDEAUDIT

        public static final String PROPERTY_EXCLUDEAUDIT
        Property excludeAudit stored in column IsExcludeAudit in table AD_Column
        Help: If the value is 'Y' ,then this column is excluded from audit.
        See Also:
        Constant Field Values
      • PROPERTY_IMAGESIZEVALUESACTION

        public static final String PROPERTY_IMAGESIZEVALUESACTION
        Property imageSizeValuesAction stored in column Imagesizevaluesaction in table AD_Column
        Help: Action or restriction that will be performed in the uploaded image size using "Image Width" and "Image Height" values. It does not apply to scalable vector graphics (svg).
        See Also:
        Constant Field Values
      • PROPERTY_IMAGEWIDTH

        public static final String PROPERTY_IMAGEWIDTH
        Property imageWidth stored in column Imagewidth in table AD_Column
        Help: Width used in the "Image Size Values Action" field. If it is empty, it will not be taked into account.
        See Also:
        Constant Field Values
      • PROPERTY_IMAGEHEIGHT

        public static final String PROPERTY_IMAGEHEIGHT
        Property imageHeight stored in column Imageheight in table AD_Column
        Help: Height used in the "Image Size Values Action" field. If it is empty, it will not be taked into account.
        See Also:
        Constant Field Values
      • PROPERTY_USEAUTOMATICSEQUENCE

        public static final String PROPERTY_USEAUTOMATICSEQUENCE
        Property useAutomaticSequence stored in column IsUsedSequence in table AD_Column
        Help: Column which DB column name is "Value", can use automatic sequence numbers, to do so this check needs to be marked. When a "Value" column uses automatic sequence works in a similar way document number columns work: when user creates a new record the default value is based in the next available sequence number (based on the sequence for the table).
        See Also:
        Constant Field Values
      • PROPERTY_SQLLOGIC

        public static final String PROPERTY_SQLLOGIC
        Property sqllogic stored in column Sqllogic in table AD_Column
        Help: This field is used to define a computed column. A computed column is a column of a table which is computed using a sql expression and which does not exist explicitly in the database schema. More information can be found at http://wiki.openbravo.com/wiki/How_to_create_a_Computed_Column
        See Also:
        Constant Field Values
      • PROPERTY_ENTITYALIAS

        public static final String PROPERTY_ENTITYALIAS
        Property entityAlias stored in column Entity_Alias in table AD_Column
        Help: The left part definition of a column in an HQL query.
        See Also:
        Constant Field Values
      • PROPERTY_ALLOWSORTING

        public static final String PROPERTY_ALLOWSORTING
        Property allowSorting stored in column AllowSorting in table AD_Column
        Help: If checked, the column will be sortable. By default every column is sortable. If it is unchecked, the column will not be sortable.
        See Also:
        Constant Field Values
      • PROPERTY_OBUIAPPPROCESS

        public static final String PROPERTY_OBUIAPPPROCESS
        Property oBUIAPPProcess stored in column EM_OBUIAPP_Process_ID in table AD_Column
        Help: Process to be executed by the button. There are 2 kinds of processes: *"Process": Implements the 2.50 style processes with a Servlet. *"Process Definition": Implements 3.0 processes with a pure SmartClient UI.
        See Also:
        Constant Field Values
      • PROPERTY_ALLOWFILTERING

        public static final String PROPERTY_ALLOWFILTERING
        Property allowFiltering stored in column AllowFiltering in table AD_Column
        Help: If checked, the column will be filterable. By default every column is filterable. If it is unchecked, the column will not be filterable.
        See Also:
        Constant Field Values
      • PROPERTY_ALLOWEDCROSSORGANIZATIONREFERENCE

        public static final String PROPERTY_ALLOWEDCROSSORGANIZATIONREFERENCE
        Property allowedCrossOrganizationReference stored in column Allowed_Cross_Org_Link in table AD_Column
        Help: By default references to other objects are only allowed in case the referenced object's Organization is in the referencing object's Organization's natural tree than the object. When this flag is enabled, this default behavior can be overridden allowing to reference objects outside current's natural tree. Note this does not change the objects that can be referred from GUI, this constraint can only be programatically bypassed.
        See Also:
        Constant Field Values
      • PROPERTY_CHILDPROPERTYINPARENTENTITY

        public static final String PROPERTY_CHILDPROPERTYINPARENTENTITY
        Property childPropertyInParentEntity stored in column Is_Child_Property_In_Parent in table AD_Column
        Help: In case of one to many references (foreing keys) this flag indicates whether a property will be created in the parent (target) entity. For example in OrderLine.order property, if this field is flagged, an Order.orderLineList property would be created.
        See Also:
        Constant Field Values
      • PROPERTY_ADFIELDLIST

        public static final String PROPERTY_ADFIELDLIST
        Property aDFieldList stored in table AD_Column
        See Also:
        Constant Field Values
    • Constructor Detail

      • Column

        public Column()