invantive documentation
Forum di supporto InvantiveAccedi / Registrati

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_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 Data di fine
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 Data di inizio
TGT_DIR varchar2(240) Target folder
TGT_FILE varchar2(160) File name
TGT_LINK varchar2(240) Target link
TGT_MAIL varchar2(4) Indirizzo email
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)