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 | 9/11/2017 10:53:51 |
| Last Modified | 9/11/2017 10:53:51 |
Columns
| Key | Name | Description |
|---|---|---|
| ms_production_retur_detail_id | ||
| doc_no | ||
| doc_date | ||
| part_no | ||
| part_name | ||
| uom | ||
| qty_source_in | ||
| qty_source_sisa | ||
| qty_retur | ||
| retur_info | ||
| ms_type_prosses_name | ||
| ms_car_line_no | ||
| ms_car_line_name | ||
| is_adjusment_avg | ||
| price_usd | ||
| price | ||
| status_id | ||
| status_name | ||
| ms_type_prosses_id | ||
| ms_car_line_out_header_id | ||
| cancel_ms_cost_final_avg_id_in | ||
| approve_ms_cost_final_avg_id_id | ||
| cancel_ms_cost_final_avg_id | ||
| approve_ms_cost_final_avg_id | ||
| ms_item_id | ||
| ms_type_id | ||
| ms_production_retur_id | ||
| ms_production_in_detail_id | ||
| ori_ms_in_item_detail_id |
SQL Script
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
create view dbo.vw_ms_production_retur_detail
---XencX---with encryption
as
SELECT dt_ms_production_retur_detail.ms_production_retur_detail_id
, vw_ms_production_in_detail.doc_no
, vw_ms_production_in_detail.doc_date
, vw_ms_production_in_detail.part_no
, vw_ms_production_in_detail.part_name
, vw_ms_production_in_detail.uom
, vw_ms_production_in_detail.quantity AS qty_source_in
, vw_ms_production_in_detail.quantity_sisa AS qty_source_sisa
, dt_ms_production_retur_detail.quantity AS qty_retur
, dt_ms_production_retur_detail.retur_info
, vw_ms_production_in_detail.ms_type_prosses_name
, vw_ms_production_in_detail.ms_car_line_no
, vw_ms_production_in_detail.ms_car_line_name
, case when not(isnull(dt_ms_production_retur.approve_ms_cost_final_avg_id,-1)=isnull(vw_ms_production_in_detail.approve_ms_cost_final_avg_id,-1)) then 1 else 0 end as is_adjusment_avg
, vw_ms_production_in_detail.price_usd
, vw_ms_production_in_detail.price
, vw_ms_production_in_detail.status_id
, vw_ms_production_in_detail.status_name
, vw_ms_production_in_detail.ms_type_prosses_id
, vw_ms_production_in_detail.ms_car_line_out_header_id
, vw_ms_production_in_detail.cancel_ms_cost_final_avg_id as cancel_ms_cost_final_avg_id_in
, vw_ms_production_in_detail.approve_ms_cost_final_avg_id as approve_ms_cost_final_avg_id_id
, isnull(dt_ms_production_retur.cancel_ms_cost_final_avg_id,-1) as cancel_ms_cost_final_avg_id
, isnull(dt_ms_production_retur.approve_ms_cost_final_avg_id,-1) as approve_ms_cost_final_avg_id
, vw_ms_production_in_detail.ms_item_id
, vw_ms_production_in_detail.ms_type_id
, dt_ms_production_retur_detail.ms_production_retur_id
, vw_ms_production_in_detail.ms_production_in_detail_id
, vw_ms_production_in_detail.ori_ms_in_item_detail_id
FROM dt_ms_production_retur_detail INNER JOIN
vw_ms_production_in_detail ON dt_ms_production_retur_detail.ms_item_out_detail_id = vw_ms_production_in_detail.ms_production_in_detail_id INNER JOIN
dt_ms_production_retur ON dt_ms_production_retur_detail.ms_production_retur_id = dt_ms_production_retur.ms_production_retur_id
GO
GO
create view dbo.vw_ms_production_retur_detail
---XencX---with encryption
as
SELECT dt_ms_production_retur_detail.ms_production_retur_detail_id
, vw_ms_production_in_detail.doc_no
, vw_ms_production_in_detail.doc_date
, vw_ms_production_in_detail.part_no
, vw_ms_production_in_detail.part_name
, vw_ms_production_in_detail.uom
, vw_ms_production_in_detail.quantity AS qty_source_in
, vw_ms_production_in_detail.quantity_sisa AS qty_source_sisa
, dt_ms_production_retur_detail.quantity AS qty_retur
, dt_ms_production_retur_detail.retur_info
, vw_ms_production_in_detail.ms_type_prosses_name
, vw_ms_production_in_detail.ms_car_line_no
, vw_ms_production_in_detail.ms_car_line_name
, case when not(isnull(dt_ms_production_retur.approve_ms_cost_final_avg_id,-1)=isnull(vw_ms_production_in_detail.approve_ms_cost_final_avg_id,-1)) then 1 else 0 end as is_adjusment_avg
, vw_ms_production_in_detail.price_usd
, vw_ms_production_in_detail.price
, vw_ms_production_in_detail.status_id
, vw_ms_production_in_detail.status_name
, vw_ms_production_in_detail.ms_type_prosses_id
, vw_ms_production_in_detail.ms_car_line_out_header_id
, vw_ms_production_in_detail.cancel_ms_cost_final_avg_id as cancel_ms_cost_final_avg_id_in
, vw_ms_production_in_detail.approve_ms_cost_final_avg_id as approve_ms_cost_final_avg_id_id
, isnull(dt_ms_production_retur.cancel_ms_cost_final_avg_id,-1) as cancel_ms_cost_final_avg_id
, isnull(dt_ms_production_retur.approve_ms_cost_final_avg_id,-1) as approve_ms_cost_final_avg_id
, vw_ms_production_in_detail.ms_item_id
, vw_ms_production_in_detail.ms_type_id
, dt_ms_production_retur_detail.ms_production_retur_id
, vw_ms_production_in_detail.ms_production_in_detail_id
, vw_ms_production_in_detail.ori_ms_in_item_detail_id
FROM dt_ms_production_retur_detail INNER JOIN
vw_ms_production_in_detail ON dt_ms_production_retur_detail.ms_item_out_detail_id = vw_ms_production_in_detail.ms_production_in_detail_id INNER JOIN
dt_ms_production_retur ON dt_ms_production_retur_detail.ms_production_retur_id = dt_ms_production_retur.ms_production_retur_id
GO