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 | 8/12/2017 13:23:31 |
| Last Modified | 8/12/2017 13:23:31 |
Columns
| Key | Name | Description |
|---|---|---|
| kode_barang | ||
| part_name_customs | ||
| part_no | ||
| qty_in | ||
| doc_in_no | ||
| doc_in_date | ||
| CAR | ||
| BC23No | ||
| BC23Tg | ||
| typedok | ||
| PasokNama | ||
| PasokAlmt | ||
| id_data_in_dtl | ||
| id_data_in_hdr | ||
| id_bc_in_hdr | ||
| status | ||
| doc_in_from_id | ||
| part_no2 |
SQL Script
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE VIEW dbo.v_data_bp_in AS
SELECT
dbo.tbl_data_bahan_penolong.kode_barang,
dbo.tbl_data_bahan_penolong.part_name_customs,
dbo.tbl_data_bahan_penolong.part_no,
dbo.v_data_in_dtl.qty_in,
dbo.tbl_data_in_hdr.doc_in_no,
CONVERT(date, dbo.tbl_data_in_hdr.doc_in_date,126) AS doc_in_date,
dbo.tbl_bc_in_hdr.CAR,
dbo.tbl_bc_in_hdr.BC23No,
CONVERT(date,dbo.tbl_bc_in_hdr.BC23Tg, 126) AS BC23Tg,
dbo.tbl_bc_in_hdr.typedok,
dbo.tbl_bc_in_hdr.PasokNama,
dbo.tbl_bc_in_hdr.PasokAlmt,
dbo.v_data_in_dtl.id_data_in_dtl,
dbo.tbl_data_in_hdr.id_data_in_hdr,
dbo.tbl_bc_in_hdr.id_bc_in_hdr,
dbo.tbl_data_in_hdr.status,
dbo.tbl_data_in_hdr.doc_in_from_id,
dbo.v_data_in_dtl.part_no2
FROM
dbo.tbl_data_bahan_penolong
INNER JOIN dbo.v_data_in_dtl ON dbo.v_data_in_dtl.part_no2 = dbo.tbl_data_bahan_penolong.part_no2
INNER JOIN dbo.tbl_data_in_hdr ON dbo.tbl_data_in_hdr.id_data_in_hdr = dbo.v_data_in_dtl.id_data_in_hdr
INNER JOIN dbo.tbl_bc_in_hdr ON dbo.tbl_data_in_hdr.id_terkait = dbo.tbl_bc_in_hdr.id_bc_in_hdr
GO
GO
CREATE VIEW dbo.v_data_bp_in AS
SELECT
dbo.tbl_data_bahan_penolong.kode_barang,
dbo.tbl_data_bahan_penolong.part_name_customs,
dbo.tbl_data_bahan_penolong.part_no,
dbo.v_data_in_dtl.qty_in,
dbo.tbl_data_in_hdr.doc_in_no,
CONVERT(date, dbo.tbl_data_in_hdr.doc_in_date,126) AS doc_in_date,
dbo.tbl_bc_in_hdr.CAR,
dbo.tbl_bc_in_hdr.BC23No,
CONVERT(date,dbo.tbl_bc_in_hdr.BC23Tg, 126) AS BC23Tg,
dbo.tbl_bc_in_hdr.typedok,
dbo.tbl_bc_in_hdr.PasokNama,
dbo.tbl_bc_in_hdr.PasokAlmt,
dbo.v_data_in_dtl.id_data_in_dtl,
dbo.tbl_data_in_hdr.id_data_in_hdr,
dbo.tbl_bc_in_hdr.id_bc_in_hdr,
dbo.tbl_data_in_hdr.status,
dbo.tbl_data_in_hdr.doc_in_from_id,
dbo.v_data_in_dtl.part_no2
FROM
dbo.tbl_data_bahan_penolong
INNER JOIN dbo.v_data_in_dtl ON dbo.v_data_in_dtl.part_no2 = dbo.tbl_data_bahan_penolong.part_no2
INNER JOIN dbo.tbl_data_in_hdr ON dbo.tbl_data_in_hdr.id_data_in_hdr = dbo.v_data_in_dtl.id_data_in_hdr
INNER JOIN dbo.tbl_bc_in_hdr ON dbo.tbl_data_in_hdr.id_terkait = dbo.tbl_bc_in_hdr.id_bc_in_hdr
GO