CARRIER_LNG_VW

(SQL View)
 Index Back

Carrier defn table

List of all carriers

SELECT SETID ,CARRIER ,LANGUAGE_CD ,DESCR100 FROM %Table(CARRIER_TBL_LNG)

  • Related Language Record for CARRIER_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 CARRIER Character(10) VARCHAR2(10) NOT NULL Carrier or preferred carrier. Also used for Shipping Method.
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description