HWB_HOLD_CD_LVW

(SQL View)
 Index Back

Hold Code Table

This table stores Hold code information. Hold codes are used on messages, quotes and orders, and in automatic processing for credit and other violations.

SELECT DISTINCT H.SETID ,H.HOLD_CD ,L.LANGUAGE_CD ,L.DESCRSHORT ,L.DESCR ,L.DESCR FROM PS_HOLD_CD H , PS_HOLD_CD_LNG L WHERE %Join(COMMON_KEYS, HOLD_CD H, HOLD_CD_LNG L)

  • Related Language Record for HWB_HOLD_CD_VW

    • # 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 HOLD_CD Character(6) VARCHAR2(6) NOT NULL Hold Code
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 OM_CHAR Character(254) VARCHAR2(254) NOT NULL Long field