SHIP_METHOD_VW

(SQL View)
 Index Back

Shipping Method View

This record stores the shipping methods or carriers any shipment.

select setid, ship_type_id, descr, descrshort, max_weight, max_volume, unit_measure_wt, unit_measure_vol, ist_transport_mode from PS_SHIP_METHOD

  • Related Language Record: SHIP_METHD_VWLN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 MAX_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Max Weight Capacity
    6 MAX_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Ship Maximum Volume
    7 UNIT_MEASURE_WT Character(3) VARCHAR2(3) NOT NULL Weight UOM

    Prompt Table: UNITS_WT_VW

    8 UNIT_MEASURE_VOL Character(3) VARCHAR2(3) NOT NULL Volume UOM

    Prompt Table: UNITS_VOL_VW

    9 IST_TRANSPORT_MODE Character(1) VARCHAR2(1) NOT NULL Mode of Transport for Intrastat Reporting
    1=Transport by Sea
    2=Transport by Rail
    3=Transport by Road
    4=Transport by Air
    5=Consignments by Post
    7=Fixed Transport Installations
    8=Transport by Inland Waterway
    9=Own Propulsion