ORDENT_MSG_VW

(SQL View)
 Index Back

Message Table

This table holds the message codes which can be associated to customers and products. Messages may have actions such as "hold" or "reject", and these actions will be considered during transactions and appropriate processing will take place. This view is used by order entry. No peoplecode, no defaults, no prompts. Date Init. Issue # Description 051304 dms F-KNANN-V59N4 Replace pass to fields

SELECT setid , message_cd , effdt , eff_status , descr , descr254 , message_action , hold_cd , PASS_HOLD_TO_BI , PASS_HOLD_TO_ID , PASS_HOLD_TO_IP , PASS_HOLD_TO_IR , PASS_HOLD_TO_IS , PASS_HOLD_TO_IU , PASS_TO_PURCH , INCL_IN_PLAN FROM PS_MESSAGE_TBL

  • Related Language Record: MESSAGE_TBL_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 MESSAGE_CD Character(6) VARCHAR2(6) NOT NULL Message Code
    3 EFFDT Date(10) DATE Effective Date
    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    7 MESSAGE_ACTION Character(2) VARCHAR2(2) NOT NULL Action
    H=Hold
    N=None
    R=Reject
    8 HOLD_CD Character(6) VARCHAR2(6) NOT NULL Hold Code
    9 PASS_HOLD_TO_BI Character(1) VARCHAR2(1) NOT NULL Pass to Billing
    10 PASS_HOLD_TO_ID Character(1) VARCHAR2(1) NOT NULL Pass to Released
    11 PASS_HOLD_TO_IP Character(1) VARCHAR2(1) NOT NULL Pass to Picked/Confirmed
    12 PASS_HOLD_TO_IR Character(1) VARCHAR2(1) NOT NULL Pass to Releasable
    13 PASS_HOLD_TO_IS Character(1) VARCHAR2(1) NOT NULL Pass to Shipped
    14 PASS_HOLD_TO_IU Character(1) VARCHAR2(1) NOT NULL Pass to Unfulfilled
    15 PASS_TO_PURCH Character(1) VARCHAR2(1) NOT NULL Pass to Purchasing
    16 INCL_IN_PLAN Character(1) VARCHAR2(1) NOT NULL Include in Planning