21 lines
758 B
SQL
21 lines
758 B
SQL
-- View: public.vw_bi_fct_sale_physical_contract
|
|
|
|
-- DROP VIEW public.vw_bi_fct_sale_physical_contract;
|
|
|
|
CREATE OR REPLACE VIEW public.vw_bi_fct_sale_physical_contract AS
|
|
SELECT "intSaleLineId",
|
|
"dtmDeliveryDateFrom" AS "Delivery Date From",
|
|
"dtmDeliveryDateTo" AS "Delivery DateTo",
|
|
"dblQuantity" AS "Quantity",
|
|
"dblPrice" AS "Price",
|
|
"dblUnitPrice" AS "Unit Price",
|
|
"dblTheoreticalQuantity" AS "Theoretical Quantity",
|
|
"dblLineAmount" AS "Line Amount",
|
|
"dblTheoreticalWeightKg" AS "Theoretical Weight(Kg)",
|
|
"dblPhysicalWeightKg" AS "Physical Weight(Kg)",
|
|
"dblOpenWeightKg" AS "Open Weight(Kg)"
|
|
FROM vw_utility_sale_physical_contract pc;
|
|
|
|
ALTER TABLE public.vw_bi_fct_sale_physical_contract
|
|
OWNER TO postgres;
|