| Table p_type |
|
Description: List of all possible special types for a partner. |
| PRIMARY KEY | ||
|
p_type_code_c
varchar (20) NOT NULL | This code identifies the type | |
|
p_type_description_c
varchar (120) NOT NULL | This describes the method of aquisition. | |
|
p_category_code_c
varchar (40) | This is a category, by which partner types can be grouped. | p_type_category |
|
p_valid_type_l
boolean default: '1' | Defines if the type code is still for use | |
|
p_system_type_l
boolean default: '0' | This type can only be assigned by the system | |
|
p_type_deletable_l
boolean default: '1' | This defines if the type code can be deleted. This can only be updated by the system manager. | |
|
p_type_motivation_group_c
varchar (16) | This Mot Group will be selected by default when entering gifts for Partners with this Special Type | |
|
p_type_motivation_detail_c
varchar (16) | This Mot Detail will be selected by default when entering gifts for Partners with this Special 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 p_type_fk1: p_category_code_c => p_type_category p_type_fkcr: s_created_by_c => s_user p_type_fkmd: s_modified_by_c => s_user | ||
REFERENCED BY a_ar_discount, p_partner_type | ||