| Table a_analysis_type |
|
Description: Types of analysis attributes. |
| PRIMARY KEY | ||
|
a_ledger_number_i
integer default: 0 NOT NULL | The number of the ledger in which the analysis type is used. | a_ledger |
|
a_analysis_type_code_c
varchar (16) NOT NULL | ||
|
a_analysis_type_description_c
varchar (64) NOT NULL | This is a short description which is 32 charcters long | |
|
a_analysis_mode_l
boolean default: '1' NOT NULL | Shows what type of analysis attribute it is | |
|
a_analysis_store_c
varchar (64) | ||
|
a_analysis_element_c
varchar (64) | The name of the field within a table which will be used as the analysis attribute | |
|
a_system_analysis_type_l
boolean default: '0' | To indicate whether the user or system has set up the analysis type. | |
|
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_analysis_type_fk1: a_ledger_number_i => a_ledger a_analysis_type_fkcr: s_created_by_c => s_user a_analysis_type_fkmd: s_modified_by_c => s_user | ||
REFERENCED BY a_freeform_analysis, a_analysis_attribute | ||