SP_DSSHPBLNONVW

(SQL View)
 Index Back

Sec Vw - PS/OM DstNwk ShipFrom

Date Initials Issue Description 081803 dms IR629385001 Turn on search keys

SELECT A.SETID ,A.DS_NETWORK_CODE ,A.BUSINESS_UNIT_IN ,B.LANGUAGE_CD ,B.DESCR FROM PS_DS_NETDET_TBL A , PS_BUS_UNIT_LANG B WHERE A.BUSINESS_UNIT_IN = B.BUSINESS_UNIT

  • Related Language Record for SP_DSSHPB_NONVW

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

    Prompt Table: SP_SETID_NONVW

    2 DS_NETWORK_CODE Character(6) VARCHAR2(6) NOT NULL Distribution Network Code
    3 SHIP_FROM_BU Character(5) VARCHAR2(5) NOT NULL Ship from INV BU
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description