invantive documentation
Invantive SupportforenAnmelden / Eintragen

TIM_HDR: AccountView Time registration weeks

read only per partition

  • Katalog: AccountView
  • Label: Time registration weeks

Es können nur Daten abgerufen werden.

Tabellenspalten

Die Spalten der Tabelle TIM_HDR sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

Name Datentyp 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