invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

TIM_INP: AccountView Time registration lines per week

read only per partition

  • Catalogus: AccountView
  • Label: Time registration lines per week

Kan alleen gegevens ophalen.

Tabelkolommen

De kolommen van de tabel TIM_INP worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

Name Datatype Label Required Marks Documentation
CST_AMT int64 Costs
CST_BLK char Posting costs blocked
CST_ID varchar2(10) Unique code costs
EMP_NR varchar2(10) Employee code
HDR_ID varchar2(10) Unieke code van het koprecord
INP_ID varchar2(10) Unique code hours entry
ORG_01 int64 Original rate Sunday
ORG_02 int64 Original rate Monday
ORG_03 int64 Original rate Tuesday
ORG_04 int64 Original rate Wednesday
ORG_05 int64 Original rate Thursday
ORG_06 int64 Original rate Friday
ORG_07 int64 Original rate Saturday
partition_code varchar2 Partition code
partition_name varchar2 Partition name
PROJ_CODE varchar2(10) Projectcode
PX_01 int64 External rate Sunday
PX_02 int64 External rate Monday
PX_03 int64 External rate Tuesday
PX_04 int64 External rate Wednesday
PX_05 int64 External rate Thursday
PX_06 int64 External rate Friday
PX_07 int64 External rate Saturday
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_P01 char Posting blocked Sunday
QTY_P02 char Posting blocked Monday
QTY_P03 char Posting blocked Tuesday
QTY_P04 char Posting blocked Wednesday
QTY_P05 char Posting blocked Thursday
QTY_P06 char Posting blocked Friday
QTY_P07 char Posting blocked Saturday
QTY_TOT decimal Total number of hours
RAPP_YEAR varchar2(10) Reporting year
REC_ID varchar2(10) Unieke code
REC_ID01 varchar2(10) Unique code Sunday
REC_ID02 varchar2(10) Unique code Monday
REC_ID03 varchar2(10) Unique code Tuesday
REC_ID04 varchar2(10) Unique code Wednesday
REC_ID05 varchar2(10) Unique code Thursday
REC_ID06 varchar2(10) Unique code Friday
REC_ID07 varchar2(10) Unique code Saturday
REC_ORD int32 Regelvolgorde
TG_TYPE int32 Hour type group type
TIM_CODE varchar2(10) Hour type code
TIM_DATE datetime Date
TIM_DESC varchar2(4) Hour type description
WEEK_NR decimal Week number
WEEK_YEAR decimal Week and year
WRK_CODE varchar2(10) Work type