SHIP_CNT_PS_VW

(SQL View)
 Index Back

Ship Container Header

Container view for packing session delivery processing.

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 , H.PRO_NUMBER , H.FREIGHT_AMT , H.FREIGHT_CURRNCY_CD , H.FRT_CHRG_AUDIT , H.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 , H.FRT_REF_NO , H.EXT_PKG_ID , H.OVERSIZED , H.ADD_HANDLING , H.OUTER_MOST_CNTR_ID , H.DESCRLONG FROM PS_SHIP_CNTR_HDR H

  • Related Language Record: SHIP_CNTR_LNG

    • # 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