CREATE OR REPLACE VIEW public.vw_bi_fct_fee_allocation AS
 SELECT "intShipmentId",
    "intLotId",
    "intFeeId",
    "strFeeSource" AS "Fee Source",
    "strFeeType" AS "Fee Type",
    "intPurchaseLineId",
    "intSaleLineId",
    "intProductId",
    "strFee" AS "Fee",
    "intSupplierId",
    "strSupplier" AS "Supplier",
    "strPackaging" AS "Packaging",
    "strPayOrRec" AS "Pay or Receive",
    "strState" AS "State",
    "dblQuantity" AS "Quantity",
    "dblPrice" AS "Price",
    "strCurrency" AS "Currency",
    "strUnit" AS "Unit",
    "dblAmount" AS "Amount",
    "strCostGroup" AS "Cost Group",
    "intSignMultiplier" AS "Sign Multiplier"
   FROM vw_utility_shipment_fee_allocation fee;;
