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:09:29 |
| Last Modified | 9/11/2017 10:09:29 |
Columns
| Key | Name | Description |
|---|---|---|
| ms_molts_invoice_detail_id | ||
| order_no | ||
| part_no | ||
| part_name | ||
| ms_item_custom_no | ||
| uom | ||
| item_code | ||
| item_type_1 | ||
| item_type_2 | ||
| description_1 | ||
| description_2 | ||
| quantity | ||
| unit | ||
| price_unit | ||
| price_total | ||
| weight_unit | ||
| weight_total | ||
| country_of_origin | ||
| hs_code | ||
| tier_1_supplier | ||
| mapped | ||
| mapping_ms_item_id | ||
| mapping_date | ||
| mapping_by | ||
| create_date | ||
| create_by | ||
| ms_molts_invoice_id |
SQL Script
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
create view dbo.vw_ms_molts_invoce_item_list
---XencX---with encryption
as
SELECT
dt_ms_molts_invoice_detail.ms_molts_invoice_detail_id
, dt_ms_molts_invoice_detail.order_no
, dt_ms_item.part_no
, dt_ms_item.part_name
, dt_ms_item.ms_item_custom_no
, dt_ms_item.uom
, dt_ms_molts_invoice_detail.item_code
, dt_ms_molts_invoice_detail.item_type_1
, dt_ms_molts_invoice_detail.item_type_2
, dt_ms_molts_invoice_detail.description_1
, dt_ms_molts_invoice_detail.description_2
, dt_ms_molts_invoice_detail.quantity
, dt_ms_molts_invoice_detail.unit
, dt_ms_molts_invoice_detail.price_unit
, dt_ms_molts_invoice_detail.price_total
, dt_ms_molts_invoice_detail.weight_unit
, dt_ms_molts_invoice_detail.weight_total
, dt_ms_molts_invoice_detail.country_of_origin
, dt_ms_molts_invoice_detail.hs_code
, dt_ms_molts_invoice_detail.tier_1_supplier
, isnull(dt_ms_item.ms_item_id,0) as mapped
, dt_ms_molts_invoice_detail.mapping_ms_item_id
, dt_ms_molts_invoice_detail.mapping_date
, users_mapping.username as mapping_by
, dt_ms_molts_invoice_detail.create_date
, users_create.username AS create_by
, dt_ms_molts_invoice_detail.ms_molts_invoice_id
FROM dt_ms_item RIGHT OUTER JOIN
users AS users_mapping RIGHT OUTER JOIN
users AS users_create RIGHT OUTER JOIN
dt_ms_molts_invoice_detail ON users_create.id = dt_ms_molts_invoice_detail.create_by ON users_mapping.id = dt_ms_molts_invoice_detail.mapping_by ON
dt_ms_item.ms_item_id = dt_ms_molts_invoice_detail.mapping_ms_item_id
GO
GO
create view dbo.vw_ms_molts_invoce_item_list
---XencX---with encryption
as
SELECT
dt_ms_molts_invoice_detail.ms_molts_invoice_detail_id
, dt_ms_molts_invoice_detail.order_no
, dt_ms_item.part_no
, dt_ms_item.part_name
, dt_ms_item.ms_item_custom_no
, dt_ms_item.uom
, dt_ms_molts_invoice_detail.item_code
, dt_ms_molts_invoice_detail.item_type_1
, dt_ms_molts_invoice_detail.item_type_2
, dt_ms_molts_invoice_detail.description_1
, dt_ms_molts_invoice_detail.description_2
, dt_ms_molts_invoice_detail.quantity
, dt_ms_molts_invoice_detail.unit
, dt_ms_molts_invoice_detail.price_unit
, dt_ms_molts_invoice_detail.price_total
, dt_ms_molts_invoice_detail.weight_unit
, dt_ms_molts_invoice_detail.weight_total
, dt_ms_molts_invoice_detail.country_of_origin
, dt_ms_molts_invoice_detail.hs_code
, dt_ms_molts_invoice_detail.tier_1_supplier
, isnull(dt_ms_item.ms_item_id,0) as mapped
, dt_ms_molts_invoice_detail.mapping_ms_item_id
, dt_ms_molts_invoice_detail.mapping_date
, users_mapping.username as mapping_by
, dt_ms_molts_invoice_detail.create_date
, users_create.username AS create_by
, dt_ms_molts_invoice_detail.ms_molts_invoice_id
FROM dt_ms_item RIGHT OUTER JOIN
users AS users_mapping RIGHT OUTER JOIN
users AS users_create RIGHT OUTER JOIN
dt_ms_molts_invoice_detail ON users_create.id = dt_ms_molts_invoice_detail.create_by ON users_mapping.id = dt_ms_molts_invoice_detail.mapping_by ON
dt_ms_item.ms_item_id = dt_ms_molts_invoice_detail.mapping_ms_item_id
GO