Description
Properties
| Name | Value |
|---|---|
| Collation | |
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Schema Bound | False |
| Created | 9/11/2017 10:08:40 |
| Last Modified | 9/11/2017 10:08:40 |
Columns
| Key | Name | Description |
|---|---|---|
| supplier_customer_id | ||
| invoice_total | ||
| invoice_ready |
SQL Script
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
create view dbo.vw_ms_molts_invoce_group_supplier
---XencX---with encryption
as
SELECT mapping_supplier_customer_id AS supplier_customer_id
, COUNT(*) AS invoice_total,
sum(case when r_s=0 then 1 else 0 end) as invoice_ready
FROM vw_ms_molts_invoce
where (NOT (mapping_supplier_customer_id = - 1 OR
mapping_supplier_customer_id IS NULL) ) and used =0
GROUP BY mapping_supplier_customer_id
GO
GO
create view dbo.vw_ms_molts_invoce_group_supplier
---XencX---with encryption
as
SELECT mapping_supplier_customer_id AS supplier_customer_id
, COUNT(*) AS invoice_total,
sum(case when r_s=0 then 1 else 0 end) as invoice_ready
FROM vw_ms_molts_invoce
where (NOT (mapping_supplier_customer_id = - 1 OR
mapping_supplier_customer_id IS NULL) ) and used =0
GROUP BY mapping_supplier_customer_id
GO