Bewerken: EmpLabourLine

Sectie: Kolommen

Reden:

## Kolommen

| 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)) | — |