Bewerken: PurchaseLine

Sectie: Computed columns

Reden:

## Computed columns

- `PchlCalcArtPrepQuantity` — `(CONVERT([decimal](21,2),case when [PchlStockArt]=(1) AND ([PchlRecStatus]=(128) OR [PchlRecStatus]=(2)) then [pchlqtypurchunt]*[pchlpurchqty] else (0) end))`
- `PchlCalcArtPurchQuantity` — `(CONVERT([decimal](21,2),case when [PchlStockArt]=(1) AND [PchlRepair]=(0) AND ([PchlRecStatus]=(64) OR [PchlRecStatus]=(4)) then [pchlqtypurchunt]*[pchltorcvqty] else (0) end))`
- `PchlCalcArtRepQuantity` — `(CONVERT([decimal](21,2),case when [PchlStockArt]=(1) AND [PchlRepair]=(1) AND ([PchlRecStatus]=(64) OR [PchlRecStatus]=(4)) then [pchlqtypurchunt]*[pchltorcvqty] else (0) end))`
- `PchlRemainingCommitExclVat` — `(CONVERT([decimal](21,5),case when [PchlRecStatus]=(256) OR [PchlRecStatus]=(64) OR [PchlRecStatus]=(4) then (([PchlPurchQty]-[PchlInvQty])*[PchlStdTotPrice])/case when [PchlPurchQty]=(0) then (1) else [PchlPurchQty] end else (0) end))`
- `PchlRemainingCommitInclVat` — `(CONVERT([decimal](21,5),case when [PchlRecStatus]=(256) OR [PchlRecStatus]=(64) OR [PchlRecStatus]=(4) then (([PchlPurchQty]-[PchlInvQty])*([PchlStdTotPrice]+([PchlStdTotPrice]/(100.0))*[PchlVatPercentage]))/case when [PchlPurchQty]=(0) then (1) else [PchlPurchQty] end else (0) end))`