Description
Properties
| Name | Value |
|---|---|
| Collation | |
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Schema Bound | False |
| Created | 11/6/2020 19:04:54 |
| Last Modified | 11/6/2020 19:04:54 |
Columns
| Key | Name | Description |
|---|---|---|
| ms_part_list_out_id | ||
| quantity | ||
| quantity_new_part | ||
| quantity_recycle | ||
| quantity_used | ||
| ms_item_out_detail_id | ||
| ms_part_list_process_detail_id |
SQL Script
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE view dbo.vw_ms_out_part_list_detail_supply
---XencX---with encryption
as
SELECT
dt_ms_part_list_out.ms_part_list_out_id
, dt_ms_part_list_out.quantity
, dt_ms_part_list_out.quantity_new_part
, dt_ms_part_list_out.quantity_recycle
, dt_ms_part_list_out.quantity_used
, dt_ms_part_list_out.ms_item_out_detail_id
, dt_ms_part_list_out.ms_part_list_process_detail_id
FROM dt_ms_part_list_out
INNER JOIN vw_ms_production_in_detail ON dt_ms_part_list_out.ms_item_out_detail_id = vw_ms_production_in_detail.ms_production_in_detail_id
GO
GO
CREATE view dbo.vw_ms_out_part_list_detail_supply
---XencX---with encryption
as
SELECT
dt_ms_part_list_out.ms_part_list_out_id
, dt_ms_part_list_out.quantity
, dt_ms_part_list_out.quantity_new_part
, dt_ms_part_list_out.quantity_recycle
, dt_ms_part_list_out.quantity_used
, dt_ms_part_list_out.ms_item_out_detail_id
, dt_ms_part_list_out.ms_part_list_process_detail_id
FROM dt_ms_part_list_out
INNER JOIN vw_ms_production_in_detail ON dt_ms_part_list_out.ms_item_out_detail_id = vw_ms_production_in_detail.ms_production_in_detail_id
GO