Bewerken: Project

Sectie: Kolommen

Reden:

## Kolommen

| Kolom | Type | Nullable | Default | Identity |
|-------|------|----------|---------|----------|
| `PrjId` | nvarchar(6) | Nee | — | — |
| `PrjDescr` | nvarchar(200) | Ja | — | — |
| `PrjContext` | bigint | Nee | ((1)) | — |
| `PrjRecStatus` | int | Nee | ((0)) | — |
| `PrjActDuration` | decimal(21,2) | Nee | ((0)) | — |
| `PrjActFinishDate` | datetimeoffset(7) | Ja | — | — |
| `PrjActiveDate` | datetimeoffset(7) | Ja | — | — |
| `PrjActiveEmpId` | nvarchar(9) | Ja | — | — |
| `PrjActStartDate` | datetimeoffset(7) | Ja | — | — |
| `PrjApprvDate` | datetimeoffset(7) | Ja | — | — |
| `PrjApprvEmpId` | nvarchar(9) | Ja | — | — |
| `PrjBudgetMutation` | decimal(21,5) | Nee | ((0)) | — |
| `PrjBudgetOrg` | decimal(21,5) | Nee | ((0)) | — |
| `PrjCcrId` | nvarchar(9) | Ja | — | — |
| `PrjChgId` | nvarchar(6) | Ja | — | — |
| `PrjCloseDate` | datetimeoffset(7) | Ja | — | — |
| `PrjCloseEmpId` | nvarchar(9) | Ja | — | — |
| `PrjCommentText` | nvarchar(max) | Ja | — | — |
| `PrjCompId` | nvarchar(6) | Nee | — | — |
| `PrjDataProvider` | nvarchar(50) | Ja | — | — |
| `PrjDefinitionText` | nvarchar(max) | Ja | — | — |
| `PrjEqmId` | nvarchar(24) | Ja | — | — |
| `PrjEqmInv` | decimal(21,5) | Nee | ((0)) | — |
| `PrjExported` | smallint | Nee | ((0)) | — |
| `PrjExtCalc` | decimal(21,5) | Nee | ((0)) | — |
| `PrjExtCost` | decimal(21,5) | Nee | ((0)) | — |
| `PrjExternalId` | nvarchar(50) | Ja | — | — |
| `PrjExternalStatus` | nvarchar(50) | Ja | — | — |
| `PrjExtInv` | decimal(21,5) | Nee | ((0)) | — |
| `PrjFinishDate` | datetimeoffset(7) | Ja | — | — |
| `PrjFinishEmpId` | nvarchar(9) | Ja | — | — |
| `PrjHours` | decimal(21,2) | Nee | ((0)) | — |
| `PrjHoursCalc` | decimal(21,2) | Nee | ((0)) | — |
| `PrjHoursInv` | decimal(21,2) | Nee | ((0)) | — |
| `PrjHoursToPlan` | decimal(21,2) | Nee | ((0)) | — |
| `PrjIOFixedPriceCost` | decimal(21,5) | Nee | ((0)) | — |
| `PrjIoTermCost` | decimal(21,5) | Nee | ((0)) | — |
| `PrjIoTermInv` | decimal(21,5) | Nee | ((0)) | — |
| `PrjLabCost` | decimal(21,5) | Nee | ((0)) | — |
| `PrjLabInv` | decimal(21,5) | Nee | ((0)) | — |
| `PrjMatCalc` | decimal(21,5) | Nee | ((0)) | — |
| `PrjMatCost` | decimal(21,5) | Nee | ((0)) | — |
| `PrjMatInv` | decimal(21,5) | Nee | ((0)) | — |
| `PrjMemorandumCost` | decimal(21,5) | Nee | ((0)) | — |
| `PrjMngrEmpId` | nvarchar(9) | Ja | — | — |
| `PrjPercComplete` | decimal(21,2) | Nee | ((0)) | — |
| `PrjPercCompleteCalcMethod` | smallint | Nee | ((0)) | — |
| `PrjPostpDate` | datetimeoffset(7) | Ja | — | — |
| `PrjPostpEmpId` | nvarchar(9) | Ja | — | — |
| `PrjPriId` | nvarchar(4) | Ja | — | — |
| `PrjProviderMutDate` | datetimeoffset(7) | Ja | — | — |
| `PrjPurchaseRequestCalc` | decimal(21,5) | Nee | ((0)) | — |
| `PrjPurchCalc` | decimal(21,5) | Nee | ((0)) | — |
| `PrjPurchCommit` | decimal(21,5) | Nee | ((0)) | — |
| `PrjPurchCost` | decimal(21,5) | Nee | ((0)) | — |
| `PrjPurchInv` | decimal(21,5) | Nee | ((0)) | — |
| `PrjRecCreateDate` | datetimeoffset(7) | Ja | (sysdatetimeoffset()) | — |
| `PrjRequestDate` | datetimeoffset(7) | Ja | — | — |
| `PrjRequestEmpId` | nvarchar(9) | Ja | — | — |
| `PrjResCalc` | decimal(21,5) | Nee | ((0)) | — |
| `PrjSchDuration` | decimal(21,2) | Nee | ((0)) | — |
| `PrjSchFinishDate` | datetimeoffset(7) | Ja | — | — |
| `PrjSchStartDate` | datetimeoffset(7) | Ja | — | — |
| `PrjSearchForPrfId` | nvarchar(50) | Ja | — | — |
| `PrjSearchForSkcId` | nvarchar(9) | Ja | — | — |
| `PrjSearchForVdrId` | nvarchar(6) | Ja | — | — |
| `PrjSearchForWotId` | nvarchar(6) | Ja | — | — |
| `PrjSearchFromDate` | date | Ja | — | — |
| `PrjSearchPOJobs` | smallint | Nee | ((2)) | — |
| `PrjSearchTillDate` | date | Ja | — | — |
| `PrjTextValidations` | nvarchar(max) | Ja | — | — |
| `PrjTlsCalc` | decimal(21,5) | Nee | ((0)) | — |
| `PrjTlsCost` | decimal(21,5) | Nee | ((0)) | — |
| `PrjTlsInv` | decimal(21,5) | Nee | ((0)) | — |
| `PrjToSpendForeCast` | decimal(21,5) | Nee | ((0)) | — |
| `PrjTotalHoursPlanned` | decimal(21,2) | Nee | ((0)) | — |
| `PrjTransferNextTime` | smallint | Nee | ((0)) | — |
| `PrjBudgetTotal` | decimal(21,5) | Nee | — | — |
| `PrjCalcTotal` | decimal(21,5) | Nee | — | — |
| `PrjCostTotal` | decimal(21,5) | Nee | — | — |
| `PrjInvTotal` | decimal(21,5) | Nee | — | — |
| `PrjFileExtension` | nvarchar(5) | Nee | — | — |
| `PRJCOMMENTTEXT_FT` | varbinary(max) | Ja | — | — |
| `PRJDEFINITIONTEXT_FT` | varbinary(max) | Ja | — | — |