Table p_form
Description:
The form description for user definable forms such as receipts
PRIMARY KEY
p_form_code_c
varchar (20) NOT NULL
The code which defines the type of form described in the table
p_form_name_c
varchar (20) NOT NULL
The name of the form being created for the form code.
p_form_language_c
varchar (20) NOT NULL
The language that this form is written in. Use 99 if the form can be used for unspecified languages. p_language

p_form_description_c
varchar (100)
Description of the form
p_form_type_code_c
varchar (24) NOT NULL
If there are several types of form then it can be specified here. Eg an annual receipt and an individual receipt.
p_address_layout_code_c
varchar (16)
The address layout code that defines the address block content. p_address_layout_code
p_formality_level_i
integer default: 1 NOT NULL
The formality level to use if the template contains greetings or salutations. 1=Informal, 6=Very formal
p_template_available_l
boolean default: '0' NOT NULL
Is the template available in the database.
p_template_document_c
text
The binary template file encoded as Base64 text
p_template_file_extension_c
varchar (16)
The file type associated with the template.
p_template_upload_date_d
date
Date the template was uploaded to the database
p_template_upload_time_i
integer
Time the template was uploaded to the database
p_template_uploaded_by_user_id_c
varchar (16)
s_user
p_minimum_amount_n
numeric (24, 10) default: 0 NOT NULL
The minimum amount that is acceptable on a receipt
p_options_c
varchar (64)
Allows the exclusion of certain records from a report
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
This identifies the current version of the record.


FOREIGN KEY
p_form_fk1: p_form_language_c => p_language
p_form_fk2: p_address_layout_code_c => p_address_layout_code
p_form_fk3: p_template_uploaded_by_user_id_c => s_user
p_form_fkcr: s_created_by_c => s_user
p_form_fkmd: s_modified_by_c => s_user