dbo.vw_ms_item_final

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/14/2017 21:46:06
Last Modified	7/29/2020 11:38:07

Columns

Key	Name	Description
	ms_item_h_price_id
	ms_cost_final_avg_id
	start_date
	end_date
	info
	ms_item_id
	end_qty
	end_price
	end_price_usd
	carline_avg_qty
	carline_max_qty
	carline_min_qty
	carline_safty
	create_date
	create_by
	modify_date
	modify_by

SQL Script

SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO

CREATE view dbo.vw_ms_item_final_cost
---XencX---with encryption
as
SELECT        dt_ms_item_list_price.ms_item_h_price_id
, dt_ms_cost_final_avg.ms_cost_final_avg_id
, dt_ms_cost_final_avg.start_date
, dt_ms_cost_final_avg.end_date
, dt_ms_cost_final_avg.info
, dt_ms_item_list_price.ms_item_id
, dt_ms_item_list_price.end_qty
, dt_ms_item_list_price.end_price
, dt_ms_item_list_price.end_price_usd
, dt_ms_item_list_price.carline_avg_qty
, dt_ms_item_list_price.carline_max_qty
, dt_ms_item_list_price.carline_min_qty
, dt_ms_item_list_price.carline_safty
, dt_ms_cost_final_avg.create_date
, users_create.username AS create_by
, dt_ms_cost_final_avg.modify_date
, users_modify.username AS modify_by
FROM            dt_ms_cost_final_avg INNER JOIN
                         dt_ms_item_list_price ON dt_ms_cost_final_avg.ms_cost_final_avg_id = dt_ms_item_list_price.ms_cost_final_avg_id INNER JOIN
                         users AS users_create ON dt_ms_cost_final_avg.create_by = users_create.id INNER JOIN
                         users AS users_modify ON dt_ms_cost_final_avg.modify_by = users_modify.id

GO

Depends On

Used By

dbo.vw_ms_item_final_cost_last