Table a_form_element

Description:
Each element that can be displayed on a form is defined on this table.

PRIMARY KEY
a_form_code_c varchar (20) NOT NULL	The code which defines the type of form described in the table	a_form, a_form_element_type
a_form_name_c varchar (20) NOT NULL	The name of the form being created for the form code.	a_form
a_form_sequence_i integer default: 0 NOT NULL	Unique identifier of each form element within a form

a_form_element_type_code_c varchar (40) NOT NULL	The code of an element type that can be possitioned for use on a form.	a_form_element_type
a_column_i integer default: 1 NOT NULL	The column that the element is to be displayed at on the form.
a_row_i integer default: 1 NOT NULL	The row on the page that the element is to be displayed at.
a_length_i integer default: 1 NOT NULL	The display length for the element. e.g. it may be necessary to truncate fields.
a_skip_i integer default: 0	This stores the number of characters to skip prior to printing. It can be used to spread a description over two lines.
a_when_print_c varchar (40) NOT NULL	Indicates when the element is printed. This would indicate detail lines, first, last page etc.
a_literal_text_c varchar (2000)	Text to be displayed if the element is defined as a literal.
s_date_created_d date default: CURRENT_DATE	The date the record was created.
s_created_by_c varchar (20)	User ID of who created this record.	s_user
s_date_modified_d date	The date the record was modified.
s_modified_by_c varchar (20)	User ID of who last modified this record.	s_user
s_modification_id_t timestamp default: CURRENT_TIMESTAMP	This identifies the current version of the record.
FOREIGN KEY a_form_element_fk1: a_form_code_c;a_form_name_c => a_form a_form_element_fk2: a_form_code_c;a_form_element_type_code_c => a_form_element_type a_form_element_fkcr: s_created_by_c => s_user a_form_element_fkmd: s_modified_by_c => s_user