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 11:00:31 |
| Last Modified | 9/11/2017 11:00:31 |
Columns
| Key | Name | Description |
|---|---|---|
| ms_in_item_detail_id | ||
| part_no | ||
| part_name | ||
| mode_source_2 | ||
| mode_source_name_2 | ||
| bc_no | ||
| bc_date | ||
| uom | ||
| quantity_pakai | ||
| source_qty | ||
| source_sisa | ||
| receive_no | ||
| receive_date | ||
| car | ||
| ms_item_custom_no | ||
| ms_item_base_no | ||
| status_id | ||
| status_name | ||
| SERI_BARANG | ||
| ori_ms_in_item_detail_id | ||
| id_source_header | ||
| ms_item_id | ||
| ms_type_id | ||
| source_ms_in_item_detail_id | ||
| adjustment_header_id | ||
| info |
SQL Script
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
create view dbo.vw_ms_adjustment_detail
---XencX---with encryption
as
SELECT
dt_ms_item_in_detail.ms_in_item_detail_id
, vw_ms_item_in_detail.part_no
, vw_ms_item_in_detail.part_name
, vw_ms_item_in_detail.mode_source_2
, vw_ms_item_in_detail.mode_source_name_2
, vw_ms_item_in_detail.bc_no
, vw_ms_item_in_detail.bc_date
, vw_ms_item_in_detail.uom
, dt_ms_item_in_detail.quantity_pakai
, vw_ms_item_in_detail.quantity_pakai AS source_qty
, vw_ms_item_in_detail.quantity_sisa AS source_sisa
, vw_ms_item_in_detail.receive_no
, vw_ms_item_in_detail.receive_date
, vw_ms_item_in_detail.car
, vw_ms_item_in_detail.ms_item_custom_no
, vw_ms_item_in_detail.ms_item_base_no
, vw_ms_item_in_detail.status_id
, vw_ms_item_in_detail.status_name
, vw_ms_item_in_detail.SERI_BARANG
, vw_ms_item_in_detail.ori_ms_in_item_detail_id
, vw_ms_item_in_detail.id_source_header
, vw_ms_item_in_detail.ms_item_id
, vw_ms_item_in_detail.ms_type_id
,dt_ms_item_in_detail.id_source as source_ms_in_item_detail_id
,dt_ms_item_in_detail.id_source_header as adjustment_header_id
,dt_ms_item_in_detail.info
FROM dt_ms_item_in_detail INNER JOIN
vw_ms_item_in_detail ON dt_ms_item_in_detail.id_source = vw_ms_item_in_detail.ms_in_item_detail_id
WHERE (dt_ms_item_in_detail.mode_source = 3)
GO
GO
create view dbo.vw_ms_adjustment_detail
---XencX---with encryption
as
SELECT
dt_ms_item_in_detail.ms_in_item_detail_id
, vw_ms_item_in_detail.part_no
, vw_ms_item_in_detail.part_name
, vw_ms_item_in_detail.mode_source_2
, vw_ms_item_in_detail.mode_source_name_2
, vw_ms_item_in_detail.bc_no
, vw_ms_item_in_detail.bc_date
, vw_ms_item_in_detail.uom
, dt_ms_item_in_detail.quantity_pakai
, vw_ms_item_in_detail.quantity_pakai AS source_qty
, vw_ms_item_in_detail.quantity_sisa AS source_sisa
, vw_ms_item_in_detail.receive_no
, vw_ms_item_in_detail.receive_date
, vw_ms_item_in_detail.car
, vw_ms_item_in_detail.ms_item_custom_no
, vw_ms_item_in_detail.ms_item_base_no
, vw_ms_item_in_detail.status_id
, vw_ms_item_in_detail.status_name
, vw_ms_item_in_detail.SERI_BARANG
, vw_ms_item_in_detail.ori_ms_in_item_detail_id
, vw_ms_item_in_detail.id_source_header
, vw_ms_item_in_detail.ms_item_id
, vw_ms_item_in_detail.ms_type_id
,dt_ms_item_in_detail.id_source as source_ms_in_item_detail_id
,dt_ms_item_in_detail.id_source_header as adjustment_header_id
,dt_ms_item_in_detail.info
FROM dt_ms_item_in_detail INNER JOIN
vw_ms_item_in_detail ON dt_ms_item_in_detail.id_source = vw_ms_item_in_detail.ms_in_item_detail_id
WHERE (dt_ms_item_in_detail.mode_source = 3)
GO