SP_DSSHPB_NONVW

(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.DESCR FROM PS_DS_NETDET_TBL A , PS_BUS_UNIT_TBL_FS B WHERE A.BUSINESS_UNIT_IN = B.BUSINESS_UNIT

  • Related Language Record: SP_DSSHPBLNONVW

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description