Generated code for code tables

When you define code tables, additional associated code is generated in support of the defined code tables.

The implementation of the code table is generated in the module project. Every code table is generated with the following standard fields:

• lang_tp_cd: The language type code, a type code from the CDLANGTP code table.
• description: the description of the type code.
• expiry_dt: The expiry date for the type code.
• last_update_dt: The last update date of the type code.
• last_update_user: The userid associated with the last update.

When a type code attribute is defined for an entity, two fields corresponding to the type code are generated on the Business Object. For example, if you have defined a type code with the name Priority, then the Business Object will have fields with the names PriorityType and PriorityValue. PriorityType is the numeric type code and PriorityValue is the name of that type code. Only the numeric type code is stored in the database table.

The generated code validates requests to ensure that the type codes in the request are valid. A sample SQL script is generated in the resources folder to allow you to easily add some values to the new code table so that you are able to construct valid requests.