# TIM_INP: Time registration lines per week - Name: `TIM_INP` - Catalog: `AccountView` - Label: Time registration lines per week - Partition-specific: true - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `TIM_INP` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `CST_AMT` | `int64` | Costs | ☐ | | | `CST_BLK` | `boolean` | Posting costs blocked | ☐ | | | `CST_ID` | `string(10)` | Unique code costs | ☐ | | | `EMP_NR` | `string(10)` | Employee code | ☐ | | | `HDR_ID` | `string(10)` | Unique code of header record | ☐ | | | `INP_ID` | `string(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` | `string` | Partition code | ☑ | | | `partition_name` | `string` | Partition name | ☑ | | | `PROJ_CODE` | `string(10)` | Project code | ☐ | | | `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` | `boolean` | Posting blocked Sunday | ☐ | | | `QTY_P02` | `boolean` | Posting blocked Monday | ☐ | | | `QTY_P03` | `boolean` | Posting blocked Tuesday | ☐ | | | `QTY_P04` | `boolean` | Posting blocked Wednesday | ☐ | | | `QTY_P05` | `boolean` | Posting blocked Thursday | ☐ | | | `QTY_P06` | `boolean` | Posting blocked Friday | ☐ | | | `QTY_P07` | `boolean` | Posting blocked Saturday | ☐ | | | `QTY_TOT` | `decimal` | Total number of hours | ☐ | | | `RAPP_YEAR` | `string(10)` | Reporting year | ☐ | | | `REC_ID` | `string(10)` | Unique code | ☐ | | | `REC_ID01` | `string(10)` | Unique code Sunday | ☐ | | | `REC_ID02` | `string(10)` | Unique code Monday | ☐ | | | `REC_ID03` | `string(10)` | Unique code Tuesday | ☐ | | | `REC_ID04` | `string(10)` | Unique code Wednesday | ☐ | | | `REC_ID05` | `string(10)` | Unique code Thursday | ☐ | | | `REC_ID06` | `string(10)` | Unique code Friday | ☐ | | | `REC_ID07` | `string(10)` | Unique code Saturday | ☐ | | | `REC_ORD` | `int32` | Line sequence | ☐ | | | `TG_TYPE` | `int32` | Hour type group type | ☐ | | | `TIM_CODE` | `string(10)` | Hour type code | ☐ | | | `TIM_DATE` | `datetime` | Date | ☐ | | | `TIM_DESC` | `string(4)` | Hour type description | ☐ | | | `WEEK_NR` | `decimal` | Week number | ☐ | | | `WEEK_YEAR` | `decimal` | Week and year | ☐ | | | `WRK_CODE` | `string(10)` | Work type | ☐ | |