Description
Properties
| Name | Value |
|---|---|
| Collation | SQL_Latin1_General_CP1_CI_AS |
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Schema Bound | False |
| Created | 2/27/2018 19:26:39 |
| Last Modified | 2/27/2018 19:26:39 |
Columns
| Key | Name | Description |
|---|---|---|
| ms_memo_detail_supply_id | ||
| detail_in_id | ||
| mode_source_gab | ||
| mode_source_name_2 | ||
| doc_no | ||
| doc_date | ||
| quantity | ||
| uom | ||
| receive_no | ||
| receive_date | ||
| info | ||
| quantity_sisa | ||
| qty_out | ||
| qty_plan | ||
| ms_item_custom_no | ||
| ms_item_base_no | ||
| part_no | ||
| part_name | ||
| mode_source | ||
| mode_source_name | ||
| ms_item_id | ||
| id_source_header | ||
| ori_detail_in_id | ||
| ms_type_id | ||
| gab_mode_source | ||
| mode_source_2 | ||
| status_id | ||
| ms_memo_detail_id | ||
| supply_id_source | ||
| gab_id |
SQL Script
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
create view dbo.vw_ms_memo_detail_suplly
---XencX---with encryption
as
SELECT
dt_ms_memo_detail_supply.ms_memo_detail_supply_id
, vw_ms_memo_detail_suplly_source_stock.detail_in_id
, vw_ms_memo_detail_suplly_source_stock.mode_source_gab
, vw_ms_memo_detail_suplly_source_stock.mode_source_name_2
, vw_ms_memo_detail_suplly_source_stock.doc_no
, vw_ms_memo_detail_suplly_source_stock.doc_date
, dt_ms_memo_detail_supply.quantity
, vw_ms_memo_detail_suplly_source_stock.uom
, vw_ms_memo_detail_suplly_source_stock.receive_no
, vw_ms_memo_detail_suplly_source_stock.receive_date
, vw_ms_memo_detail_suplly_source_stock.info
, vw_ms_memo_detail_suplly_source_stock.quantity_sisa
, vw_ms_memo_detail_suplly_source_stock.qty_out
, vw_ms_memo_detail_suplly_source_stock.qty_plan
, vw_ms_memo_detail_suplly_source_stock.ms_item_custom_no
, vw_ms_memo_detail_suplly_source_stock.ms_item_base_no
, vw_ms_memo_detail_suplly_source_stock.part_no
, vw_ms_memo_detail_suplly_source_stock.part_name
, vw_ms_memo_detail_suplly_source_stock.mode_source
, vw_ms_memo_detail_suplly_source_stock.mode_source_name
, vw_ms_memo_detail_suplly_source_stock.ms_item_id
, vw_ms_memo_detail_suplly_source_stock.id_source_header
, vw_ms_memo_detail_suplly_source_stock.ori_detail_in_id
, vw_ms_memo_detail_suplly_source_stock.ms_type_id
, vw_ms_memo_detail_suplly_source_stock.gab_mode_source
, vw_ms_memo_detail_suplly_source_stock.mode_source_2
, vw_ms_memo_detail_suplly_source_stock.status_id
, dt_ms_memo_detail_supply.ms_memo_detail_id
, dt_ms_memo_detail_supply.supply_id_source
, vw_ms_memo_detail_suplly_source_stock.gab_id
FROM vw_ms_memo_detail_suplly_source_stock INNER JOIN
dt_ms_memo_detail_supply ON vw_ms_memo_detail_suplly_source_stock.detail_in_id = dt_ms_memo_detail_supply.supply_id_source
WHERE (dt_ms_memo_detail_supply.supply_mode_source = 0)
union all
SELECT
dt_ms_memo_detail_supply.ms_memo_detail_supply_id
, vw_ms_memo_detail_suplly_source_production.detail_in_id
, vw_ms_memo_detail_suplly_source_production.mode_source_gab
, vw_ms_memo_detail_suplly_source_production.mode_source_name_2
, vw_ms_memo_detail_suplly_source_production.doc_no
, vw_ms_memo_detail_suplly_source_production.doc_date
, dt_ms_memo_detail_supply.quantity
, vw_ms_memo_detail_suplly_source_production.uom
, vw_ms_memo_detail_suplly_source_production.receive_no
, vw_ms_memo_detail_suplly_source_production.receive_date
, vw_ms_memo_detail_suplly_source_production.info
, vw_ms_memo_detail_suplly_source_production.quantity_sisa
, vw_ms_memo_detail_suplly_source_production.qty_out
, vw_ms_memo_detail_suplly_source_production.qty_plan
, vw_ms_memo_detail_suplly_source_production.ms_item_custom_no
, vw_ms_memo_detail_suplly_source_production.ms_item_base_no
, vw_ms_memo_detail_suplly_source_production.part_no
, vw_ms_memo_detail_suplly_source_production.part_name
, vw_ms_memo_detail_suplly_source_production.mode_source
, vw_ms_memo_detail_suplly_source_production.mode_source_name
, vw_ms_memo_detail_suplly_source_production.ms_item_id
, vw_ms_memo_detail_suplly_source_production.id_source_header
, vw_ms_memo_detail_suplly_source_production.ori_detail_in_id
, vw_ms_memo_detail_suplly_source_production.ms_type_id
, vw_ms_memo_detail_suplly_source_production.gab_mode_source
, vw_ms_memo_detail_suplly_source_production.mode_source_2
, vw_ms_memo_detail_suplly_source_production.status_id
, dt_ms_memo_detail_supply.ms_memo_detail_id
, dt_ms_memo_detail_supply.supply_id_source
, vw_ms_memo_detail_suplly_source_production.gab_id
FROM vw_ms_memo_detail_suplly_source_production INNER JOIN
dt_ms_memo_detail_supply ON vw_ms_memo_detail_suplly_source_production.detail_in_id = dt_ms_memo_detail_supply.supply_id_source
WHERE (dt_ms_memo_detail_supply.supply_mode_source =1)
GO
GO
create view dbo.vw_ms_memo_detail_suplly
---XencX---with encryption
as
SELECT
dt_ms_memo_detail_supply.ms_memo_detail_supply_id
, vw_ms_memo_detail_suplly_source_stock.detail_in_id
, vw_ms_memo_detail_suplly_source_stock.mode_source_gab
, vw_ms_memo_detail_suplly_source_stock.mode_source_name_2
, vw_ms_memo_detail_suplly_source_stock.doc_no
, vw_ms_memo_detail_suplly_source_stock.doc_date
, dt_ms_memo_detail_supply.quantity
, vw_ms_memo_detail_suplly_source_stock.uom
, vw_ms_memo_detail_suplly_source_stock.receive_no
, vw_ms_memo_detail_suplly_source_stock.receive_date
, vw_ms_memo_detail_suplly_source_stock.info
, vw_ms_memo_detail_suplly_source_stock.quantity_sisa
, vw_ms_memo_detail_suplly_source_stock.qty_out
, vw_ms_memo_detail_suplly_source_stock.qty_plan
, vw_ms_memo_detail_suplly_source_stock.ms_item_custom_no
, vw_ms_memo_detail_suplly_source_stock.ms_item_base_no
, vw_ms_memo_detail_suplly_source_stock.part_no
, vw_ms_memo_detail_suplly_source_stock.part_name
, vw_ms_memo_detail_suplly_source_stock.mode_source
, vw_ms_memo_detail_suplly_source_stock.mode_source_name
, vw_ms_memo_detail_suplly_source_stock.ms_item_id
, vw_ms_memo_detail_suplly_source_stock.id_source_header
, vw_ms_memo_detail_suplly_source_stock.ori_detail_in_id
, vw_ms_memo_detail_suplly_source_stock.ms_type_id
, vw_ms_memo_detail_suplly_source_stock.gab_mode_source
, vw_ms_memo_detail_suplly_source_stock.mode_source_2
, vw_ms_memo_detail_suplly_source_stock.status_id
, dt_ms_memo_detail_supply.ms_memo_detail_id
, dt_ms_memo_detail_supply.supply_id_source
, vw_ms_memo_detail_suplly_source_stock.gab_id
FROM vw_ms_memo_detail_suplly_source_stock INNER JOIN
dt_ms_memo_detail_supply ON vw_ms_memo_detail_suplly_source_stock.detail_in_id = dt_ms_memo_detail_supply.supply_id_source
WHERE (dt_ms_memo_detail_supply.supply_mode_source = 0)
union all
SELECT
dt_ms_memo_detail_supply.ms_memo_detail_supply_id
, vw_ms_memo_detail_suplly_source_production.detail_in_id
, vw_ms_memo_detail_suplly_source_production.mode_source_gab
, vw_ms_memo_detail_suplly_source_production.mode_source_name_2
, vw_ms_memo_detail_suplly_source_production.doc_no
, vw_ms_memo_detail_suplly_source_production.doc_date
, dt_ms_memo_detail_supply.quantity
, vw_ms_memo_detail_suplly_source_production.uom
, vw_ms_memo_detail_suplly_source_production.receive_no
, vw_ms_memo_detail_suplly_source_production.receive_date
, vw_ms_memo_detail_suplly_source_production.info
, vw_ms_memo_detail_suplly_source_production.quantity_sisa
, vw_ms_memo_detail_suplly_source_production.qty_out
, vw_ms_memo_detail_suplly_source_production.qty_plan
, vw_ms_memo_detail_suplly_source_production.ms_item_custom_no
, vw_ms_memo_detail_suplly_source_production.ms_item_base_no
, vw_ms_memo_detail_suplly_source_production.part_no
, vw_ms_memo_detail_suplly_source_production.part_name
, vw_ms_memo_detail_suplly_source_production.mode_source
, vw_ms_memo_detail_suplly_source_production.mode_source_name
, vw_ms_memo_detail_suplly_source_production.ms_item_id
, vw_ms_memo_detail_suplly_source_production.id_source_header
, vw_ms_memo_detail_suplly_source_production.ori_detail_in_id
, vw_ms_memo_detail_suplly_source_production.ms_type_id
, vw_ms_memo_detail_suplly_source_production.gab_mode_source
, vw_ms_memo_detail_suplly_source_production.mode_source_2
, vw_ms_memo_detail_suplly_source_production.status_id
, dt_ms_memo_detail_supply.ms_memo_detail_id
, dt_ms_memo_detail_supply.supply_id_source
, vw_ms_memo_detail_suplly_source_production.gab_id
FROM vw_ms_memo_detail_suplly_source_production INNER JOIN
dt_ms_memo_detail_supply ON vw_ms_memo_detail_suplly_source_production.detail_in_id = dt_ms_memo_detail_supply.supply_id_source
WHERE (dt_ms_memo_detail_supply.supply_mode_source =1)
GO