SCHEDULE: AccountView Alerts
read only
- Catalogo:
AccountView - Label: Alerts
È possibile solo recuperare i dati.
Colonne della tabella
Di seguito sono riportate le colonne della tabella SCHEDULE. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.
| Name | Tipo di dati | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
ACT_ |
varchar2 |
User activity | |||
ADM_ |
varchar2 |
Administration | |||
CNG_ |
datetime |
Date modified | |||
CNG_NR |
int32 |
Change number | |||
CNG_ |
varchar2 |
Employee last modified | |||
D_ |
int32 |
Interval (daily) | |||
DEL_ |
char |
Delete alert after completion | |||
DF_END |
int32 |
End time (daily interval) | |||
DF_ |
int32 |
Daily interval | |||
DF_ |
int32 |
Start time (daily interval) | |||
DF_ |
int32 |
Alert time (daily) | |||
DF_ |
int32 |
Daily frequency type | |||
END_ |
datetime |
Data di fine | |||
EXP_ |
varchar2 |
Active administration | |||
EXP_ |
varchar2 |
Active administration description | |||
EXP_ |
varchar2 |
Licence name | |||
EXP_ |
datetime |
Actual alert time | |||
INP_ |
datetime |
Entry date | |||
INP_ |
varchar2 |
Entered by employee | |||
LST_ |
datetime |
Last executed date | |||
M_DAY |
int32 |
Day number (monthly) | |||
M_ |
int32 |
Interval (monthly) | |||
M_TYPE |
int32 |
Monthly frequency type | |||
M_ |
int32 |
Weekday (monthly) | |||
M_ |
int32 |
Week number (monthly) | |||
MAIL_ |
varchar2 |
Email text | |||
MAIL_ |
varchar2 |
Email text if there is no data | |||
MAIL_ |
char |
Send email if there is no data | |||
MAIL_ |
varchar2 |
Email subject | |||
REC_ |
char |
Blocked | |||
REC_ID |
varchar2 |
Unique code | |||
RPT_ |
varchar2 |
File format | |||
RUN_ |
datetime |
Planned alert time | |||
RUN_ |
datetime |
Planned alert date | |||
SCH_ |
char |
Alert completed | |||
SCHED_ |
varchar2 |
Alert code | |||
SCHED_ |
varchar2 |
Alert description | |||
SCHED_ |
int32 |
Alert status | |||
SCHED_ |
char |
System alert | |||
SCHED_ |
int32 |
Frequency | |||
START_ |
datetime |
Data di inizio | |||
TGT_ |
varchar2 |
Target folder | |||
TGT_ |
varchar2 |
File name | |||
TGT_ |
varchar2 |
Target link | |||
TGT_ |
varchar2 |
Indirizzo email | |||
TGT_ |
varchar2 |
Email address bcc | |||
TGT_ |
varchar2 |
Email address cc | |||
TGT_ |
int32 |
Destination | |||
TGT_ |
char |
Keep XML response | |||
W_DAYS |
varchar2 |
Days (weekly) | |||
W_ |
int32 |
Interval (weekly) |