title: "EmpLabourLine (table)" category: reference tags: [table, emplabourline, datamodel] source: database-schema.json date: 2026-04-17 status: published
dba.EmpLabourLine
Schema: dba
Aantal kolommen: 30
Kolommenbewerken
| Kolom | Type | Nullable | Default | Identity |
|---|---|---|---|---|
EmpllEmpId |
nvarchar(9) | Nee | — | — |
EmpllWeek |
int | Nee | — | — |
EmpllLineId |
nvarchar(9) | Nee | — | — |
EmpllContext |
bigint | Nee | ((0)) | — |
EmpllRecStatus |
int | Nee | ((0)) | — |
EmpllCompId |
nvarchar(6) | Nee | — | — |
EmpllCreatedByEmpLabourPer |
smallint | Nee | ((0)) | — |
EmpllCrmId |
nvarchar(6) | Ja | — | — |
EmpllDataProvider |
nvarchar(50) | Ja | — | — |
EmpllExported |
smallint | Nee | ((0)) | — |
EmpllExternalId |
nvarchar(50) | Ja | — | — |
EmpllExternalStatus |
nvarchar(50) | Ja | — | — |
EmpllExtra1 |
smallint | Nee | ((0)) | — |
EmpllExtra2 |
int | Nee | ((0)) | — |
EmpllExtra3 |
nvarchar(5) | Ja | — | — |
EmpllHourId |
nvarchar(5) | Ja | — | — |
EmpllHours |
decimal(21,2) | Nee | ((0)) | — |
EmpllHoursFr |
decimal(21,2) | Nee | ((0)) | — |
EmpllHoursMo |
decimal(21,2) | Nee | ((0)) | — |
EmpllHoursSa |
decimal(21,2) | Nee | ((0)) | — |
EmpllHoursSu |
decimal(21,2) | Nee | ((0)) | — |
EmpllHoursTh |
decimal(21,2) | Nee | ((0)) | — |
EmpllHoursTu |
decimal(21,2) | Nee | ((0)) | — |
EmpllHoursWe |
decimal(21,2) | Nee | ((0)) | — |
EmpllHtcId |
nvarchar(5) | Ja | — | — |
EmpllJobId |
nvarchar(12) | Ja | — | — |
EmpllProviderMutDate |
datetimeoffset(7) | Ja | — | — |
EmpllRecCreateDate |
datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
EmpllRegistrationType |
smallint | Nee | ((0)) | — |
EmpllTransferNextTime |
smallint | Nee | ((0)) | — |
Brondatabewerken
- DB-schema —
lookup_table_schema("EmpLabourLine")Alle kolommen met types, triggers, computed. Bron:database-schema.json.