| Table p_addressee_title_override |
|
Description: This is used to override titles that might be different in the address than that in the letter. Eg German Herr Herrn ""Sehr geehrter Herr Starling"" in the letter and ""Herrn Starling"" in the address. |
| PRIMARY KEY | ||
|
p_language_code_c
varchar (20) default: '99' NOT NULL | This is the code used to identify a language. | p_language |
|
p_title_c
varchar (64) NOT NULL | The partner's title | |
|
p_title_override_c
varchar (64) NOT NULL | The title to override the partner | |
|
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_addressee_title_override_fk1: p_language_code_c => p_language p_addressee_title_override_fkcr: s_created_by_c => s_user p_addressee_title_override_fkmd: s_modified_by_c => s_user | ||