42 lines
1.1 KiB
SQL
42 lines
1.1 KiB
SQL
-- View: public.vw_bi_sale_follow_up
|
|
|
|
-- DROP VIEW public.vw_bi_sale_follow_up;
|
|
|
|
CREATE OR REPLACE VIEW public.vw_bi_sale_follow_up AS
|
|
SELECT dsc."Contract Nb",
|
|
dsc."Customer",
|
|
dsc."Contract Ref",
|
|
dsc."Contract Date",
|
|
dsc."Contract Status",
|
|
dsc."Payment Terms",
|
|
dsc."Currency",
|
|
dsc."Weight Basis",
|
|
dsc."Broker",
|
|
dsc."Certification",
|
|
dsc."Association",
|
|
dsc."Crop",
|
|
dsc."Tolerance Min %",
|
|
dsc."Tolerance Max %",
|
|
dsc."Inco Terms",
|
|
dsc."Loading Place",
|
|
dsc."Destination Place",
|
|
dsc."Product",
|
|
dsc."Delivery Period",
|
|
dsc."Delivery Date From",
|
|
dsc."Delivery Date To",
|
|
dsc."Delivery Status",
|
|
fsc."Quantity",
|
|
dsc."Quantity UOM",
|
|
fsc."Price",
|
|
fsc."Unit Price",
|
|
fsc."Theoretical Quantity",
|
|
fsc."Line Amount",
|
|
fsc."Theoretical Weight(Kg)",
|
|
fsc."Physical Weight(Kg)",
|
|
fsc."Open Weight(Kg)"
|
|
FROM vw_bi_fct_sale_physical_contract fsc
|
|
JOIN vw_bi_dim_sale_physical_contract dsc ON fsc."intSaleLineId" = dsc."intSaleLineId";
|
|
|
|
ALTER TABLE public.vw_bi_sale_follow_up
|
|
OWNER TO postgres;
|