Skip to content

Raizcorp Technical Documentation

Query: Qry Sum Total Replaced To Be Billed by Prin Project Pillar

Query: Qry Sum Total Replaced To Be Billed by Prin Project Pillar

Type: Select
Has Parameters: Yes
Has Joins: No
Has Subquery: No

Tables Referenced

SubQry
vwPurpleWeaveSumTotalReplacementAllocatedbyPPP
SubQry Sum Total Replaced To Be Billed by Prin Project Pillar

Columns Selected

[SubQry Sum Total Replaced To Be Billed by Prin Project Pillar].[Principal Proje
[Tot To Be Billed]-IIf(IsNull([Replacement Allocated]),0,[Replacement Allocated]

SQL

SELECT [SubQry Sum Total Replaced To Be Billed by Prin Project Pillar].[Principal Proje, [Tot To Be Billed]-IIf(IsNull([Replacement Allocated]),0,[Replacement Allocated] FROM [SubQry Sum Total Replaced To Be Billed by Prin Project Pillar], [vwPurpleWeaveSumTotalReplacementAllocatedbyPPP]