-- 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;