CARRIER_IBU_VW

(SQL View)
 Index Back

Carrier IBU View

This record stores the shipping methods or carriers any shipment.

SELECT c.setid , c.carrier_id , c.effdt , c.descr , c.eff_status FROM PS_CARRIER_ID c WHERE %EffdtCheck(carrier_id, c, %CurrentDateIn) AND c.eff_status = 'A'

  • Related Language Record: CARRIER_IBU_LNG

    • # 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 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A