14 lines
463 B
SQL
14 lines
463 B
SQL
CREATE OR REPLACE VIEW public.vw_bi_dim_shipment AS
|
|
SELECT "intShipmentId",
|
|
"strShipmentNb" AS "Shipment Nb",
|
|
"strBillOfLading" AS "BL Number",
|
|
"dtmBillOfLadingDate" AS "BL Date",
|
|
"strState" AS "State",
|
|
"strFromLocation" AS "From Location",
|
|
"strToLocation" AS "To Location",
|
|
"strVessel" AS "Vessel",
|
|
"strCarrier" AS "Carrier",
|
|
"strSupplier" AS "Supplier",
|
|
"strCargoMode" AS "Cargo Mode"
|
|
FROM vw_utility_shipment_in s;;
|