OM_SHIP_CNT_VW

(SQL View)
 Index Back

OM Shipping Container view

OM-specific version of SHIP_CNT_DEL_VW

SELECT H.BUSINESS_UNIT , H.SHIP_CNTR_ID , H.CONTAINER_TYPE , H.UCC_EAN_CD , H.DESCR , H.STOCK_TYPE , H.SHIP_HEIGHT , H.SHIP_LENGTH , H.SHIP_WIDTH , %Round(%DecMult(H.SHIP_HEIGHT, %DecMult(H.SHIP_LENGTH, H.SHIP_WIDTH)), 4) , H.MAX_WEIGHT , H.EMPTY_WEIGHT , H.UNIT_MEASURE_DIM , H.UNIT_MEASURE_WT , H.UNIT_MEASURE_VOL , H.OWNER , H.SHIP_ID , F.PRO_NUMBER , F.FREIGHT_AMT , F.FREIGHT_CURRNCY_CD , F.FRT_CHRG_AUDIT , F.FRT_CHRG_OVERRIDE , H.NET_WEIGHT , H.GROSS_WEIGHT , H.CARRIER_ID , H.SHIP_TYPE_ID , H.LOCATION , H.SHIP_TO_CUST_ID , H.ADDRESS_SEQ_NUM , H.PARENT_SHIP_CNTR , H.OVERRIDE , H.GROSS_WEIGHT_USER , H.UNIT_MEASR_WT_USER , H.ARRIVAL_DATE , F.FRT_REF_NO , F.EXT_PKG_ID , H.OVERSIZED , H.ADD_HANDLING , H.OUTER_MOST_CNTR_ID , H.DESCRLONG , I.DEMAND_SOURCE , I.SOURCE_BUS_UNIT , I.ORDER_NO , I.ORDER_INT_LINE_NO , I.SCHED_LINE_NBR , I.INV_ITEM_ID , I.DEMAND_LINE_NO , D.PARENT_PROD_ID , D.KIT_LINE_NBR , D.DELIVERY_ID , ' ' , ' ' , CASE WHEN V.DELIVERY_STATUS IS NOT NULL THEN V.DELIVERY_STATUS ELSE '99' END , 0 , 0 , ' ' , ' ' , H.FREIGHT_AMT FROM PS_SHIP_CNTR_HDR H JOIN PS_SHIP_CNTR_INV I ON %Join(COMMON_KEYS, SHIP_CNTR_HDR H, SHIP_CNTR_INV I) JOIN PS_IN_DEMAND D ON %Join(COMMON_KEYS, IN_DEMAND D, SHIP_CNTR_INV I) LEFT OUTER JOIN PS_IN_DELIVERY V ON V.BUSINESS_UNIT = D.BUSINESS_UNIT AND V.DELIVERY_ID = D.DELIVERY_ID LEFT OUTER JOIN PS_IN_SHP_CNTR_FRT F ON %Join(COMMON_KEYS, IN_SHP_CNTR_FRT F, SHIP_CNTR_HDR H) AND F.FREIGHT_APP = 'OM'

  • Related Language Record: OM_SHIP_CNT_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BUIN_NONVW

    2 SHIP_CNTR_ID Character(20) VARCHAR2(20) NOT NULL Shipping Container ID

    Prompt Table: SHIP_CNTR_HDR

    3 CONTAINER_TYPE Character(4) VARCHAR2(4) NOT NULL Container Type

    Prompt Table: CNTR_TYPE_INV

    4 UCC_EAN_CD Character(1) VARCHAR2(1) NOT NULL UCC/EAN Packaging Type
    0=Case/Carton
    1=Pallet
    2=Truckload
    3=Undefined
    4=Intra-Company
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 STOCK_TYPE Character(1) VARCHAR2(1) NOT NULL Stock Type
    F=Finished
    R=Raw Mtrl
    W=WIP
    7 SHIP_HEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Ship Height
    8 SHIP_LENGTH Signed Number(17,4) DECIMAL(15,4) NOT NULL Ship Length
    9 SHIP_WIDTH Signed Number(17,4) DECIMAL(15,4) NOT NULL Ship Width
    10 CNTR_GROSS_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Packing Volume
    11 MAX_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Max Weight Capacity
    12 EMPTY_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Empty Weight
    13 UNIT_MEASURE_DIM Character(3) VARCHAR2(3) NOT NULL Dimension UOM
    14 CNTR_UOM_WT Character(3) VARCHAR2(3) NOT NULL Weight UOM
    15 CNTR_UOM_VOL Character(3) VARCHAR2(3) NOT NULL Container volume unit of measure
    16 OWNER Character(20) VARCHAR2(20) NOT NULL Asset Owner
    17 CNTR_SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID
    18 CNTR_PRO_NUMBER Character(30) VARCHAR2(30) NOT NULL Pro Number
    19 FREIGHT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount
    20 FREIGHT_CURRNCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    21 FRT_CHRG_AUDIT Signed Number(17,4) DECIMAL(15,4) NOT NULL Freight Charge
    22 FRT_CHRG_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Freight Charge Override

    Y/N Table Edit

    Default Value: N

    23 NET_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Net Weight
    24 GROSS_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Shipping Weight
    25 CNTR_CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
    26 CNTR_SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
    27 CNTR_LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    28 CNTR_SHIP_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
    29 CNTR_ADDR_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
    30 PARENT_SHIP_CNTR Character(20) VARCHAR2(20) NOT NULL Parent Shipping Container ID
    31 OVERRIDE Character(1) VARCHAR2(1) NOT NULL Copy Method
    A=Append
    O=Override

    Y/N Table Edit

    32 GROSS_WEIGHT_USER Signed Number(17,4) DECIMAL(15,4) NOT NULL Shipping Weight
    33 UNIT_MEASR_WT_USER Character(3) VARCHAR2(3) NOT NULL Weight UOM

    Prompt Table: UNITS_TBL

    34 ARRIVAL_DATE Date(10) DATE Arrival Date
    35 FRT_REF_NO Character(30) VARCHAR2(30) NOT NULL Freight Reference Number
    36 EXT_PKG_ID Character(30) VARCHAR2(30) NOT NULL External Packaging ID
    37 OVERSIZED Character(1) VARCHAR2(1) NOT NULL Oversized Item

    Y/N Table Edit

    38 ADD_HANDLING Character(1) VARCHAR2(1) NOT NULL Additional Handling

    Y/N Table Edit

    39 OUTER_MOST_CNTR_ID Character(20) VARCHAR2(20) NOT NULL Shipping Container ID
    40 DESCRLONG Long Character CLOB Long Description
    41 DEMAND_SOURCE Character(2) VARCHAR2(2) NOT NULL Demand Source
    IN=Material Request
    OM=Sales Order
    PL=Planning Requisition
    PO=Purchase Order
    PR=Purchasing Requisition
    RT=Material Return
    SF=Production Request
    WM=Work Order
    42 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
    43 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
    44 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
    45 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
    46 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    47 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
    48 PARENT_PROD_ID Character(18) VARCHAR2(18) NOT NULL Parent Product Id
    49 KIT_LINE_NBR Number(3,0) SMALLINT NOT NULL Kit Line Number
    50 DELIVERY_ID Character(10) VARCHAR2(10) NOT NULL Delivery ID
    51 DELIVERY_KEY Character(40) VARCHAR2(40) NOT NULL Delivery Key
    52 DELIVERY_KEY1 Character(40) VARCHAR2(40) NOT NULL Delivery Key
    53 DELIVERY_STATUS Character(2) VARCHAR2(2) NOT NULL Delivery Status
    00=Pending for Demand
    10=Pending for Quote
    20=Open
    60=Closed for Shipment
    70=Delivery Completed
    90=Canceled
    99=Unassigned
    54 SHIPPING_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Shipping Weight
    55 SHIPPING_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Shipping Volume
    56 UNIT_MEASURE_WT Character(3) VARCHAR2(3) NOT NULL Weight UOM
    57 UNIT_MEASURE_VOL Character(3) VARCHAR2(3) NOT NULL Volume UOM
    58 FREIGHT_CHARGE Signed Number(17,4) DECIMAL(15,4) NOT NULL Freight Charge