invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

SCHEDULE: AccountView Alerts

read only

  • Catálogo: AccountView
  • Label: Alerts

Solo puede recuperar datos.

Columnas de la Tabla

A continuación se muestran las columnas de la tabla SCHEDULE. 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
ACT_CODE varchar2(10) User activity
ADM_CODE varchar2(10) Administration
CNG_DATE datetime Date modified
CNG_NR int32 Change number
CNG_USR varchar2(20) Employee last modified
D_INTERVAL int32 Interval (daily)
DEL_FINISH char Delete alert after completion
DF_END int32 End time (daily interval)
DF_HOUR int32 Daily interval
DF_START int32 Start time (daily interval)
DF_TIME int32 Alert time (daily)
DF_TYPE int32 Daily frequency type
END_DATE datetime Fecha Final
EXP_ADMC varchar2(10) Active administration
EXP_ADMD varchar2(100) Active administration description
EXP_LIC varchar2(100) Licence name
EXP_TIME datetime Actual alert time
INP_DATE datetime Entry date
INP_USR varchar2(20) Entered by employee
LST_RUN datetime Last executed date
M_DAY int32 Day number (monthly)
M_INTERVAL int32 Interval (monthly)
M_TYPE int32 Monthly frequency type
M_WEEKDAY int32 Weekday (monthly)
M_WEEKNR int32 Week number (monthly)
MAIL_BODY varchar2(4) Email text
MAIL_NDTXT varchar2(4) Email text if there is no data
MAIL_NODAT char Send email if there is no data
MAIL_SUBJ varchar2(160) Email subject
REC_BLK char Blocked
REC_ID varchar2(10) Unique code
RPT_EXPTYP varchar2(10) File format
RUN_DATE datetime Planned alert time
RUN_DATEV datetime Planned alert date
SCH_ENDED char Alert completed
SCHED_CODE varchar2(10) Alert code
SCHED_DESC varchar2(40) Alert description
SCHED_STAT int32 Alert status
SCHED_SYS char System alert
SCHED_TYPE int32 Frequency
START_DATE datetime Fecha inicial
TGT_DIR varchar2(240) Target folder
TGT_FILE varchar2(160) File name
TGT_LINK varchar2(240) Target link
TGT_MAIL varchar2(4) Dirección de correo electrónico
TGT_MAILBC varchar2(4) Email address bcc
TGT_MAILCC varchar2(4) Email address cc
TGT_TYPE int32 Destination
TGT_XMLRP char Keep XML response
W_DAYS varchar2(7) Days (weekly)
W_INTERVAL int32 Interval (weekly)