jump to navigation

Overview of the Compiere Application Dictionary and its Components August 31, 2010

Posted by rsentana in : computer, corporate, linux, open source , trackback
  • Next we refer the Column tab, and create a new column in the table(see the field naming conventions below). The new column must be as a System Element defined and hence we need to create a System Element prior to using it as a Column in the Table:

    • compiere-implementation-07-24

  • Once the System Element has been defined, we set up the Column as follows:

    • compiere-implementation-07-25

  • Create a new Reference key as follows:

    • compiere-implementation-07-25

    Because this is a custom list, we choose a validation type of List Validation, and a value format of L, indicating that any letters are allowed. For a full list of these conventions, refer to the help documentation in the system by pressing F1.

  • We then define the Reference key’s list validation options as follows:

    • compiere-implementation-07-26

  • The finalized column (and thus the ultimate window field) set-up is thus shown as follows:

    • compiere-implementation-07-27

    We finalize the set-up of the field by indicating:

    1. Field naming conventions: Compiere recommends that customer-specific table and database column names be prefixed by EXT_, XX_, or CUST_, or the four letter entity registered with Compiere, such as SAAC_. This would also apply to indexes and constraints. The reason for this is that these entities are ignored in the migration process.
    2. Length of field: Because we know that for this particular field there is going to be only one character we define a length of 1.
    3. Default logic: We assume U, based on our list being Unknown.
    4. Mandatory UI: Indicates that this field will be mandatory in the window, but not at database level.
    5. Updatable: Indicates that the field is editable.
    6. Always Updatable: Indicates that the field is always updatable, regardless of document status.

    Pages: 1 2 3 4 5 6 7 8

    Tags:, , ,

    Comments»

    no comments yet - be the first?



    « How to Configure Linux for Children Updates »
    Get Adobe Flash playerPlugin by wpburn.com wordpress themes