invantive documentation
Forum di supporto InvantiveAccedi / Registrati

TIM_HDR: AccountView Time registration weeks

read only per partition

  • Catalogo: AccountView
  • Label: Time registration weeks

È possibile solo recuperare i dati.

Colonne della tabella

Di seguito sono riportate le colonne della tabella TIM_HDR. 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
BOOK_DATE datetime Change date
CNG_DATE datetime Date modified
CNG_NR int32 Change number
CNG_USR varchar2(20) Employee last modified
CON_COM_01 char Full contract time Sunday
CON_COM_02 char Full contract time Monday
CON_COM_03 char Full contract time Tuesday
CON_COM_04 char Full contract time Wednesday
CON_COM_05 char Full contract time Thursday
CON_COM_06 char Full contract time Friday
CON_COM_07 char Full contract time Saturday
CON_COM_TO char Fully entered
EMP_NR varchar2(10) Employee code
HDR_DESC varchar2(40) Week description
INP_DATE datetime Entry date
INP_USR varchar2(20) Entered by employee
IS_APPROV char Is approved
LINE_HIST varchar2(4) Line history
PAGE_NR varchar2(10) Page number
partition_code varchar2 Partition code
partition_name varchar2 Partition name
QTY_01 decimal Number of hours Sunday
QTY_02 decimal Number of hours Monday
QTY_03 decimal Number of hours Tuesday
QTY_04 decimal Number of hours Wednesday
QTY_05 decimal Number of hours Thursday
QTY_06 decimal Number of hours Friday
QTY_07 decimal Number of hours Saturday
QTY_HRS decimal Total number of hours
REC_BLK char Blocked
REC_ID varchar2(10) Unique code
SYS_GEN char Page generated by system
SYS_VAL char System validations
WEEK_NR decimal Week number
WEEK_STAT int32 Progress
WEEK_YEAR decimal Week and year