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 | 6/17/2020 07:02:51 |
| Last Modified | 6/17/2020 07:02:51 |
Columns
| Key | Name | Description |
|---|---|---|
| id_scrap_memo_dtl | ||
| id_memo_scrap_hdr | ||
| part_no | ||
| qty | ||
| unit | ||
| weight | ||
| no_ex_bc | ||
| tgl_ex_bc | ||
| no_urut | ||
| issue_no | ||
| vgi_date | ||
| vgi_qty | ||
| part_name | ||
| part_name_customs |
SQL Script
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE VIEW dbo.v_scrap_memo_dtl
AS
SELECT dbo.tbl_scrap_memo_dtl.id_scrap_memo_dtl, dbo.tbl_scrap_memo_dtl.id_memo_scrap_hdr, dbo.tbl_scrap_memo_dtl.part_no, dbo.tbl_scrap_memo_dtl.qty, dbo.tbl_scrap_memo_dtl.unit,
dbo.tbl_scrap_memo_dtl.weight, dbo.tbl_scrap_memo_dtl.no_ex_bc, dbo.tbl_scrap_memo_dtl.tgl_ex_bc, dbo.tbl_scrap_memo_dtl.no_urut, dbo.tbl_scrap_memo_dtl.issue_no, dbo.tbl_scrap_memo_dtl.vgi_date,
dbo.tbl_scrap_memo_dtl.vgi_qty, dbo.tbl_data_part_hs.part_name, dbo.tbl_data_part_hs.part_name_customs
FROM dbo.tbl_scrap_memo_dtl LEFT OUTER JOIN
dbo.tbl_data_part_hs ON REPLACE(dbo.tbl_scrap_memo_dtl.part_no, ' ', '') = dbo.tbl_data_part_hs.part_no2
GO
GO
CREATE VIEW dbo.v_scrap_memo_dtl
AS
SELECT dbo.tbl_scrap_memo_dtl.id_scrap_memo_dtl, dbo.tbl_scrap_memo_dtl.id_memo_scrap_hdr, dbo.tbl_scrap_memo_dtl.part_no, dbo.tbl_scrap_memo_dtl.qty, dbo.tbl_scrap_memo_dtl.unit,
dbo.tbl_scrap_memo_dtl.weight, dbo.tbl_scrap_memo_dtl.no_ex_bc, dbo.tbl_scrap_memo_dtl.tgl_ex_bc, dbo.tbl_scrap_memo_dtl.no_urut, dbo.tbl_scrap_memo_dtl.issue_no, dbo.tbl_scrap_memo_dtl.vgi_date,
dbo.tbl_scrap_memo_dtl.vgi_qty, dbo.tbl_data_part_hs.part_name, dbo.tbl_data_part_hs.part_name_customs
FROM dbo.tbl_scrap_memo_dtl LEFT OUTER JOIN
dbo.tbl_data_part_hs ON REPLACE(dbo.tbl_scrap_memo_dtl.part_no, ' ', '') = dbo.tbl_data_part_hs.part_no2
GO
Depends On
2Used By
No items found