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:51:09 |
| Last Modified | 9/11/2017 10:51:09 |
Columns
| Key | Name | Description |
|---|---|---|
| ms_item_out_detail_id | ||
| quantity | ||
| id_source_header_in | ||
| id_source_header_out | ||
| ms_in_item_detail_id | ||
| ms_car_line_out_detail_id | ||
| mode_source | ||
| mode_source_name | ||
| mode_source_2 | ||
| mode_source_name_2 | ||
| car | ||
| bc_no | ||
| bc_date | ||
| receive_no | ||
| receive_date | ||
| status_id | ||
| quantity_pakai | ||
| quantity_sisa | ||
| qty_out | ||
| qty_plan | ||
| car_line_out | ||
| memo_out | ||
| car_line_plan | ||
| memo_plan | ||
| ms_type_id | ||
| ms_item_custom_no | ||
| ms_item_base_no | ||
| part_no | ||
| part_name | ||
| uom | ||
| ori_ms_in_item_detail_id | ||
| id_source_header | ||
| ms_item_id | ||
| status_name |
SQL Script
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
create view dbo.vw_ms_out_car_line_detail_suplly
---XencX---with encryption
as
SELECT
dt_ms_item_out_detail.ms_item_out_detail_id
, dt_ms_item_out_detail.quantity
, vw_ms_item_in_detail.id_source_header as id_source_header_in
, dt_ms_item_out_detail.id_source_header as id_source_header_out
, dt_ms_item_out_detail.ms_in_item_detail_id
, dt_ms_item_out_detail.id_source as ms_car_line_out_detail_id
,vw_ms_item_in_detail.mode_source
, vw_ms_item_in_detail.mode_source_name
, vw_ms_item_in_detail.mode_source_2
, vw_ms_item_in_detail.mode_source_name_2
, vw_ms_item_in_detail.car
, vw_ms_item_in_detail.bc_no
, vw_ms_item_in_detail.bc_date
, vw_ms_item_in_detail.receive_no
, vw_ms_item_in_detail.receive_date
, vw_ms_item_in_detail.status_id
, vw_ms_item_in_detail.quantity_pakai
, vw_ms_item_in_detail.quantity_sisa
, vw_ms_item_in_detail.qty_out
, vw_ms_item_in_detail.qty_plan
, vw_ms_item_in_detail.car_line_out
, vw_ms_item_in_detail.memo_out
, vw_ms_item_in_detail.car_line_plan
, vw_ms_item_in_detail.memo_plan
, vw_ms_item_in_detail.ms_type_id
, vw_ms_item_in_detail.ms_item_custom_no
, vw_ms_item_in_detail.ms_item_base_no
, vw_ms_item_in_detail.part_no
, vw_ms_item_in_detail.part_name
, vw_ms_item_in_detail.uom
, 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.status_name
FROM dt_ms_item_out_detail INNER JOIN
vw_ms_item_in_detail ON dt_ms_item_out_detail.ms_in_item_detail_id = vw_ms_item_in_detail.ms_in_item_detail_id
WHERE (dt_ms_item_out_detail.mode_source = 0)
GO
GO
create view dbo.vw_ms_out_car_line_detail_suplly
---XencX---with encryption
as
SELECT
dt_ms_item_out_detail.ms_item_out_detail_id
, dt_ms_item_out_detail.quantity
, vw_ms_item_in_detail.id_source_header as id_source_header_in
, dt_ms_item_out_detail.id_source_header as id_source_header_out
, dt_ms_item_out_detail.ms_in_item_detail_id
, dt_ms_item_out_detail.id_source as ms_car_line_out_detail_id
,vw_ms_item_in_detail.mode_source
, vw_ms_item_in_detail.mode_source_name
, vw_ms_item_in_detail.mode_source_2
, vw_ms_item_in_detail.mode_source_name_2
, vw_ms_item_in_detail.car
, vw_ms_item_in_detail.bc_no
, vw_ms_item_in_detail.bc_date
, vw_ms_item_in_detail.receive_no
, vw_ms_item_in_detail.receive_date
, vw_ms_item_in_detail.status_id
, vw_ms_item_in_detail.quantity_pakai
, vw_ms_item_in_detail.quantity_sisa
, vw_ms_item_in_detail.qty_out
, vw_ms_item_in_detail.qty_plan
, vw_ms_item_in_detail.car_line_out
, vw_ms_item_in_detail.memo_out
, vw_ms_item_in_detail.car_line_plan
, vw_ms_item_in_detail.memo_plan
, vw_ms_item_in_detail.ms_type_id
, vw_ms_item_in_detail.ms_item_custom_no
, vw_ms_item_in_detail.ms_item_base_no
, vw_ms_item_in_detail.part_no
, vw_ms_item_in_detail.part_name
, vw_ms_item_in_detail.uom
, 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.status_name
FROM dt_ms_item_out_detail INNER JOIN
vw_ms_item_in_detail ON dt_ms_item_out_detail.ms_in_item_detail_id = vw_ms_item_in_detail.ms_in_item_detail_id
WHERE (dt_ms_item_out_detail.mode_source = 0)
GO