Bewerken: Project

Sectie: Computed columns

Reden:

## Computed columns

- `PrjBudgetTotal` — `(CONVERT([decimal](21,5),[PrjBudgetOrg]+[PrjBudgetMutation]))`
- `PrjCalcTotal` — `(CONVERT([decimal](21,5),(((([PrjMatCalc]+[PrjExtCalc])+[PrjTlsCalc])+[PrjResCalc])+[PrjPurchaseRequestCalc])+[PrjPurchCalc]))`
- `PrjCostTotal` — `(CONVERT([decimal](21,5),(((([PrjMatCost]+[PrjExtCost])+[PrjTlsCost])+[PrjLabCost])+[PrjPurchCost])+[PrjMemorandumCost]))`
- `PrjInvTotal` — `(CONVERT([decimal](21,5),((((([PrjEqmInv]+[PrjMatInv])+[PrjExtInv])+[PrjTlsInv])+[PrjLabInv])+[PrjPurchInv])+[PrjIoTermInv]))`
- `PrjFileExtension` — `(N'.html')`
- `PRJCOMMENTTEXT_FT` — `(case when [PRJCOMMENTTEXT] IS NULL then NULL else 0xFFFE+CONVERT([varbinary](max),case when left([PRJCOMMENTTEXT],(5))=N'<html' then [PRJCOMMENTTEXT] else N'<html lang="nl">'+[PRJCOMMENTTEXT] end) end)`
- `PRJDEFINITIONTEXT_FT` — `(case when [PRJDEFINITIONTEXT] IS NULL then NULL else 0xFFFE+CONVERT([varbinary](max),case when left([PRJDEFINITIONTEXT],(5))=N'<html' then [PRJDEFINITIONTEXT] else N'<html lang="nl">'+[PRJDEFINITIONTEXT] end) end)`