Description
Properties
| Name | Value |
|---|---|
| Collation | SQL_Latin1_General_CP1_CI_AS |
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Schema Bound | True |
| Created | 7/28/2017 09:59:44 |
| Last Modified | 7/28/2017 09:59:44 |
Columns
| Key | Name | Description |
|---|---|---|
| id_data_in_dtl | ||
| id_data_in_hdr | ||
| doc_in_from_id | ||
| id_part_number | ||
| part_name | ||
| part_name_customs | ||
| part_number | ||
| part_no | ||
| qty_in | ||
| qty_out | ||
| unit_in | ||
| unit_konversi | ||
| pengali | ||
| box | ||
| pack | ||
| harga | ||
| kdval | ||
| type_brg | ||
| part_no2 |
SQL Script
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE VIEW dbo.v_data_in_dtl
WITH SCHEMABINDING AS
SELECT
dbo.tbl_data_in_dtl.id_data_in_dtl,
dbo.tbl_data_in_dtl.id_data_in_hdr,
dbo.tbl_data_in_dtl.doc_in_from_id,
dbo.tbl_data_in_dtl.id_part_number,
dbo.tbl_data_in_dtl.part_name,
dbo.tbl_data_in_dtl.part_name_customs,
dbo.tbl_data_in_dtl.part_number,
dbo.tbl_data_in_dtl.part_no,
dbo.tbl_data_in_dtl.qty_in,
dbo.tbl_data_in_dtl.qty_out,
dbo.tbl_data_in_dtl.unit_in,
dbo.tbl_data_in_dtl.unit_konversi,
dbo.tbl_data_in_dtl.pengali,
dbo.tbl_data_in_dtl.box,
dbo.tbl_data_in_dtl.pack,
dbo.tbl_data_in_dtl.harga,
dbo.tbl_data_in_dtl.kdval,
dbo.tbl_data_in_dtl.type_brg,
replace(
dbo.tbl_data_in_dtl.part_no,
' ',
''
) AS part_no2
FROM
dbo.tbl_data_in_dtl
GO
GO
CREATE VIEW dbo.v_data_in_dtl
WITH SCHEMABINDING AS
SELECT
dbo.tbl_data_in_dtl.id_data_in_dtl,
dbo.tbl_data_in_dtl.id_data_in_hdr,
dbo.tbl_data_in_dtl.doc_in_from_id,
dbo.tbl_data_in_dtl.id_part_number,
dbo.tbl_data_in_dtl.part_name,
dbo.tbl_data_in_dtl.part_name_customs,
dbo.tbl_data_in_dtl.part_number,
dbo.tbl_data_in_dtl.part_no,
dbo.tbl_data_in_dtl.qty_in,
dbo.tbl_data_in_dtl.qty_out,
dbo.tbl_data_in_dtl.unit_in,
dbo.tbl_data_in_dtl.unit_konversi,
dbo.tbl_data_in_dtl.pengali,
dbo.tbl_data_in_dtl.box,
dbo.tbl_data_in_dtl.pack,
dbo.tbl_data_in_dtl.harga,
dbo.tbl_data_in_dtl.kdval,
dbo.tbl_data_in_dtl.type_brg,
replace(
dbo.tbl_data_in_dtl.part_no,
' ',
''
) AS part_no2
FROM
dbo.tbl_data_in_dtl
GO