Bewerken: Location

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `LocId` | nvarchar(14) | Nee | — | — |
| `LocDescr` | nvarchar(200) | Ja | — | — |
| `LocContext` | bigint | Nee | ((1)) | — |
| `LocRecStatus` | int | Nee | ((0)) | — |
| `LocCompId` | nvarchar(6) | Nee | — | — |
| `LocExported` | smallint | Nee | ((0)) | — |
| `LocExtra1` | smallint | Nee | ((0)) | — |
| `LocExtra2` | decimal(21,2) | Nee | ((0)) | — |
| `LocExtra3` | decimal(21,2) | Nee | ((0)) | — |
| `LocExtra4` | decimal(21,0) | Nee | ((0)) | — |
| `LocExtra5` | decimal(21,0) | Nee | ((0)) | — |
| `LocExtra6` | nvarchar(5) | Ja | — | — |
| `LocExtra7` | nvarchar(5) | Ja | — | — |
| `LocExtra8` | nvarchar(5) | Ja | — | — |
| `LocExtra9` | nvarchar(5) | Ja | — | — |
| `LocPartOfLocId` | nvarchar(14) | Ja | — | — |
| `LocRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `LocWhsId` | nvarchar(10) | Ja | — | — |
| `LocDataProvider` | nvarchar(50) | Ja | — | — |
| `LocProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `LocTransferNextTime` | smallint | Nee | ((0)) | — |
| `LocExternalId` | nvarchar(50) | Ja | — | — |
| `LocExternalStatus` | nvarchar(50) | Ja | — | — |