| 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 default: CURRENT_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 | ||