| Table p_data_label |
|
Description: This table is used to define data labels for individual use in each office. |
| PRIMARY KEY | ||
|
p_key_i
integer NOT NULL | A sequence key for data labels. | |
|
p_text_c
varchar (100) | Label Text | |
|
p_group_c
varchar (100) | Data Label Group | |
|
p_description_c
varchar (400) | Description (Help Text) for the label that the user will see | |
|
p_data_type_c
varchar (40) NOT NULL | Data Type (char | integer | float | currency | boolean | date | time | partnerkey | lookup) | |
|
p_char_length_i
integer | Maximum length of data string if data type is set to character. | |
|
p_num_decimal_places_i
integer | Number of decimal places if data type is set to numeric. | |
|
p_currency_code_c
varchar (16) | This defines which currency is being used (if data type is currency) | a_currency |
|
p_lookup_category_code_c
varchar (60) | If a lookup category is selected then the values can be chosen from a drop down box | p_data_label_lookup_category |
|
p_entry_mandatory_l
boolean default: '0' | If TRUE then a value for this label has to be set | |
|
p_displayed_l
boolean default: '1' | If TRUE then this data label will be displayed. Gives a chance to hide but keep labels for historical reasons. | |
|
p_not_displayed_from_d
date | Data label will not be displayed any longer from this date on. | |
|
p_editable_l
boolean default: '1' | if FALSE then the values will be displayed but are not editable. | |
|
p_not_editable_from_d
date | Data label values will not be editable any longer from this date on. | |
|
p_restricted_l
boolean default: '0' | Indicates whether or not the data label has restricted access. If it does then the access will be controlled by s_group_data_label | |
|
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_data_label_fk1: p_currency_code_c => a_currency p_data_label_fk2: p_lookup_category_code_c => p_data_label_lookup_category p_data_label_fkcr: s_created_by_c => s_user p_data_label_fkmd: s_modified_by_c => s_user | ||
REFERENCED BY p_data_label_use, p_data_label_value_partner, p_data_label_value_application, s_group_data_label | ||