14 lines
578 B
SQL
14 lines
578 B
SQL
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;;
|