36 lines
1010 B
SQL
36 lines
1010 B
SQL
CREATE OR REPLACE VIEW public.vw_bi_purchase_follow_up AS
|
|
SELECT dpc."Contract Nb",
|
|
dpc."Supplier",
|
|
dpc."Contract Ref",
|
|
dpc."Contract Date",
|
|
dpc."Contract Status",
|
|
dpc."Payment Terms",
|
|
dpc."Currency",
|
|
dpc."Weight Basis",
|
|
dpc."Broker",
|
|
dpc."Certification",
|
|
dpc."Association",
|
|
dpc."Crop",
|
|
dpc."Tolerance Min %",
|
|
dpc."Tolerance Max %",
|
|
dpc."Inco Terms",
|
|
dpc."Loading Place",
|
|
dpc."Destination Place",
|
|
dpc."Product",
|
|
dpc."Delivery Period",
|
|
fpc."Delivery Date From",
|
|
fpc."Delivery DateTo",
|
|
fpc."Quantity",
|
|
fpc."In Transit Quantity",
|
|
fpc."Dropship Quantity",
|
|
fpc."Received Quantity",
|
|
fpc."Price",
|
|
fpc."Unit Price",
|
|
fpc."Theoretical Quantity",
|
|
fpc."Line Amount",
|
|
fpc."Physical Quantity",
|
|
fpc."Open Quantity",
|
|
fpc."Instructed Quantity"
|
|
FROM (vw_bi_fct_purchase_physical_contract fpc
|
|
JOIN vw_bi_dim_purchase_physical_contract dpc ON ((fpc."PurchaseLineId" = dpc."intPurchaseLineId")));;
|