Bewerken: WorkOrder

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `WoId` | nvarchar(9) | Nee | — | — |
| `WoDescr` | nvarchar(200) | Ja | — | — |
| `WoContext` | bigint | Nee | ((1)) | — |
| `WoRecStatus` | int | Nee | ((0)) | — |
| `WoActiveDate` | datetimeoffset(7) | Ja | — | — |
| `WoActiveEmpId` | nvarchar(9) | Ja | — | — |
| `WoActiveTime` | int | Nee | ((0)) | — |
| `WoApprvDate` | datetimeoffset(7) | Ja | — | — |
| `WoApprvEmpId` | nvarchar(9) | Ja | — | — |
| `WoArtId` | nvarchar(9) | Ja | — | — |
| `WoAutoClose` | smallint | Nee | ((0)) | — |
| `WoBldId` | nvarchar(11) | Ja | — | — |
| `WoBudgetMutation` | decimal(21,5) | Nee | ((0)) | — |
| `WoBudgetOrg` | decimal(21,5) | Nee | ((0)) | — |
| `WoCcrId` | nvarchar(9) | Ja | — | — |
| `WoCloseDate` | datetimeoffset(7) | Ja | — | — |
| `WoCloseEmpId` | nvarchar(9) | Ja | — | — |
| `WoCompId` | nvarchar(6) | Nee | — | — |
| `WoComplDate` | datetimeoffset(7) | Ja | — | — |
| `WoComplEmpId` | nvarchar(9) | Ja | — | — |
| `WoComplTime` | int | Nee | ((0)) | — |
| `WoCurId` | nvarchar(5) | Nee | — | — |
| `WoDataProvider` | nvarchar(50) | Ja | — | — |
| `WoDepId` | nvarchar(11) | Ja | — | — |
| `WoDuration` | decimal(21,2) | Nee | ((0)) | — |
| `WoDurationCalc` | decimal(21,2) | Nee | ((0)) | — |
| `WoEmpId` | nvarchar(9) | Ja | — | — |
| `WoEndDate` | datetimeoffset(7) | Ja | — | — |
| `WoEndEmpId` | nvarchar(9) | Ja | — | — |
| `WoEqmId` | nvarchar(24) | Ja | — | — |
| `WoEqmInv` | decimal(21,5) | Nee | ((0)) | — |
| `WoExported` | smallint | Nee | ((0)) | — |
| `WoExtCalc` | decimal(21,5) | Nee | ((0)) | — |
| `WoExtCost` | decimal(21,5) | Nee | ((0)) | — |
| `WoExternalId` | nvarchar(50) | Ja | — | — |
| `WoExternalStatus` | nvarchar(50) | Ja | — | — |
| `WoExtInv` | decimal(21,5) | Nee | ((0)) | — |
| `WoExtra1` | smallint | Nee | ((0)) | — |
| `WoExtra10` | nvarchar(5) | Ja | — | — |
| `WoExtra11` | nvarchar(5) | Ja | — | — |
| `WoExtra12` | decimal(21,0) | Nee | ((0)) | — |
| `WoExtra2` | int | Nee | ((0)) | — |
| `WoExtra3` | nvarchar(5) | Ja | — | — |
| `WoExtra4` | nvarchar(5) | Ja | — | — |
| `WoExtra5` | int | Nee | ((0)) | — |
| `WoExtra6` | int | Nee | ((0)) | — |
| `WoExtra7` | int | Nee | ((0)) | — |
| `WoExtra8` | nvarchar(5) | Ja | — | — |
| `WoExtra9` | nvarchar(5) | Ja | — | — |
| `WoFalId` | nvarchar(9) | Ja | — | — |
| `WoHours` | decimal(21,2) | Nee | ((0)) | — |
| `WoHoursCalc` | decimal(21,2) | Nee | ((0)) | — |
| `WoHoursInv` | decimal(21,2) | Nee | ((0)) | — |
| `WoHoursToPlan` | decimal(21,2) | Nee | ((0)) | — |
| `WoImpId` | nvarchar(11) | Ja | — | — |
| `WoIOFixedPriceCost` | decimal(21,5) | Nee | ((0)) | — |
| `WoIoTermCost` | decimal(21,5) | Nee | ((0)) | — |
| `WoIoTermInv` | decimal(21,5) | Nee | ((0)) | — |
| `WoLabCost` | decimal(21,5) | Nee | ((0)) | — |
| `WoLabInv` | decimal(21,5) | Nee | ((0)) | — |
| `WoMatCalc` | decimal(21,5) | Nee | ((0)) | — |
| `WoMatCost` | decimal(21,5) | Nee | ((0)) | — |
| `WoMatInv` | decimal(21,5) | Nee | ((0)) | — |
| `WoMemorandumCost` | decimal(21,5) | Nee | ((0)) | — |
| `WoPercComplete` | decimal(21,2) | Nee | ((0)) | — |
| `WoPmId` | nvarchar(5) | Ja | — | — |
| `WoPmWeek` | int | Nee | ((0)) | — |
| `WoPostpDate` | datetimeoffset(7) | Ja | — | — |
| `WoPostpEmpId` | nvarchar(9) | Ja | — | — |
| `WoPostpTime` | int | Nee | ((0)) | — |
| `WoPrfId` | nvarchar(50) | Ja | — | — |
| `WoPriId` | nvarchar(4) | Ja | — | — |
| `WoPrjId` | nvarchar(6) | Ja | — | — |
| `WoPrjMngrEmpId` | nvarchar(9) | Ja | — | — |
| `WoProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `WoPurchaseRequestCalc` | decimal(21,5) | Nee | ((0)) | — |
| `WoPurchCalc` | decimal(21,5) | Nee | ((0)) | — |
| `WoPurchCommit` | decimal(21,5) | Nee | ((0)) | — |
| `WoPurchCost` | decimal(21,5) | Nee | ((0)) | — |
| `WoPurchInv` | decimal(21,5) | Nee | ((0)) | — |
| `WoRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `WoReportDate` | datetimeoffset(7) | Ja | — | — |
| `WoReportDepId` | nvarchar(11) | Ja | — | — |
| `WoReportEmpId` | nvarchar(41) | Ja | — | — |
| `WoReportFkEmpId` | nvarchar(9) | Ja | — | — |
| `WoReportState` | decimal(21,0) | Nee | ((0)) | — |
| `WoResCalc` | decimal(21,5) | Nee | ((0)) | — |
| `WoSchStartDate` | datetimeoffset(7) | Ja | — | — |
| `WoSitId` | nvarchar(8) | Ja | — | — |
| `WoSkcId` | nvarchar(9) | Ja | — | — |
| `WoSortOrder` | int | Nee | ((0)) | — |
| `WoTargetDate` | datetimeoffset(7) | Ja | — | — |
| `WoText` | nvarchar(max) | Ja | — | — |
| `WoTlsCalc` | decimal(21,5) | Nee | ((0)) | — |
| `WoTlsCost` | decimal(21,5) | Nee | ((0)) | — |
| `WoTlsInv` | decimal(21,5) | Nee | ((0)) | — |
| `WoToSpendFcDate` | date | Ja | — | — |
| `WoToSpendForeCast` | decimal(21,5) | Nee | ((0)) | — |
| `WoTotalHoursPlanned` | decimal(21,2) | Nee | ((0)) | — |
| `WoTransferNextTime` | smallint | Nee | ((0)) | — |
| `WoUrgId` | nvarchar(11) | Ja | — | — |
| `WoVdrId` | nvarchar(6) | Ja | — | — |
| `WoWotId` | nvarchar(6) | Ja | — | — |
| `WoYrpslmmLineId` | nvarchar(8) | Ja | — | — |
| `WoYrpslmmYrpId` | nvarchar(9) | Ja | — | — |
| `WoYrpslmmYrpsLineId` | nvarchar(2) | Ja | — | — |
| `WoYrpslmmYrpslLineId` | nvarchar(9) | Ja | — | — |
| `WoBudgetTotal` | decimal(21,5) | Nee | — | — |
| `WoCalcTotal` | decimal(21,5) | Nee | — | — |
| `WoCostTotal` | decimal(21,5) | Nee | — | — |
| `WoInvTotal` | decimal(21,5) | Nee | — | — |
| `WoFileExtension` | nvarchar(5) | Nee | — | — |
| `WoText_FT` | varbinary(max) | Ja | — | — |