PEOPLE: AccountView Contacts
read only per partition
- Catálogo:
AccountView - Label: Contacts
Solo puede recuperar datos.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla PEOPLE. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.
| Name | Tipo de Datos | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
AD_ |
varchar2 |
Addressee | |||
CNG_ |
datetime |
Date modified | |||
CNG_NR |
int32 |
Change number | |||
CNG_ |
varchar2 |
Employee last modified | |||
DEAR |
varchar2 |
Salutation | |||
DSP_ |
varchar2 |
Full name | |||
FAX_ |
varchar2 |
Business fax | |||
FAX_ |
varchar2 |
Private fax | |||
FST_ |
varchar2 |
Primer Nombre | |||
IMG_ |
varchar2 |
Image | |||
INITIALS |
varchar2 |
Initials | |||
INP_ |
datetime |
Entry date | |||
INP_ |
varchar2 |
Entered by employee | |||
LST_ |
varchar2 |
Apellido | |||
MAIL_ |
varchar2 |
Business email | |||
MAIL_ |
int32 |
Mailing (business email) | |||
MAIL_ |
int32 |
Mailing (private email) | |||
MAIL_ |
varchar2 |
Private email | |||
MSG_ |
char |
Email notification | |||
partition_ |
varchar2 |
Partition code | |||
partition_ |
varchar2 |
Partition name | |||
PE_ |
varchar2 |
Contact list field 1 | |||
PE_ |
varchar2 |
Contact list field 2 | |||
PE_ |
varchar2 |
Contact list field 3 | |||
PE_ |
varchar2 |
Contact list field 4 | |||
PE_ |
varchar2 |
Contact list field 5 | |||
PE_ |
char |
Contact checkbox field 1 | |||
PE_ |
char |
Contact checkbox field 2 | |||
PE_ |
char |
Contact checkbox field 3 | |||
PE_ |
char |
Contact checkbox field 4 | |||
PE_ |
char |
Contact checkbox field 5 | |||
PP_ |
varchar2 |
Persona de Contacto | |||
PP_ |
varchar2 |
Remark | |||
PW_ |
varchar2 |
Password hash | |||
REC_ |
char |
Blocked | |||
SEX |
decimal |
Gender | |||
TEL_ |
varchar2 |
Business telephone | |||
TEL_ |
varchar2 |
Mobile telephone | |||
TEL_ |
varchar2 |
Private telephone | |||
TITLE1 |
varchar2 |
Contact title 1 | |||
TITLE2 |
varchar2 |
Contact title 2 |