invantive documentation
Invantive Support ForumsLog In / Sign Up

PEOPLE: AccountView Contacts

read only per partition

  • Catalog: AccountView
  • Label: Contacts

Can only retrieve data.

Table Columns

The columns of the table PEOPLE are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
AD_NAME varchar2(40) Addressee
CNG_DATE datetime Date modified
CNG_NR int32 Change number
CNG_USR varchar2(20) Employee last modified
DEAR varchar2(40) Salutation
DSP_NAME varchar2(30) Full name
FAX_BUS varchar2(20) Business fax
FAX_PRIV varchar2(20) Private fax
FST_NAME varchar2(20) First Name
IMG_FILE varchar2(4) Image
INITIALS varchar2(10) Initials
INP_DATE datetime Entry date
INP_USR varchar2(20) Entered by employee
LST_NAME varchar2(30) Last Name
MAIL_BUS varchar2(50) Business email
MAIL_OPT_B int32 Mailing (business email)
MAIL_OPT_P int32 Mailing (private email)
MAIL_PRIV varchar2(50) Private email
MSG_MAIL char Email notification
partition_code varchar2 Partition code
partition_name varchar2 Partition name
PE_CRIT_01 varchar2(10) Contact list field 1
PE_CRIT_02 varchar2(10) Contact list field 2
PE_CRIT_03 varchar2(10) Contact list field 3
PE_CRIT_04 varchar2(10) Contact list field 4
PE_CRIT_05 varchar2(10) Contact list field 5
PE_YN_01 char Contact checkbox field 1
PE_YN_02 char Contact checkbox field 2
PE_YN_03 char Contact checkbox field 3
PE_YN_04 char Contact checkbox field 4
PE_YN_05 char Contact checkbox field 5
PP_CODE varchar2(10) Contact Person
PP_NOTE1 varchar2(4) Remark
PW_HASH varchar2(16) Password hash
REC_BLK char Blocked
SEX decimal Gender
TEL_BUS varchar2(20) Business telephone
TEL_MOB varchar2(20) Mobile telephone
TEL_PRIV varchar2(20) Private telephone
TITLE1 varchar2(20) Contact title 1
TITLE2 varchar2(10) Contact title 2