MESSAGE_TBL

(SQL Table)
 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. Date Init. Issue # Description 051304 dms F-KNANN-V59N4 Replace old pass thru fields

  • 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

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 MESSAGE_CD Character(6) VARCHAR2(6) NOT NULL Message Code
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

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

    Default Value: A

    5 MESSAGE_CD_TYPE Character(4) VARCHAR2(4) NOT NULL Message Type
    01=Credit Related Message
    02=Product Related Message
    03=Promotion Related Message
    04=Internal Warning Message
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    8 MESSAGE_ACTION Character(2) VARCHAR2(2) NOT NULL Action
    H=Hold
    N=None
    R=Reject

    Default Value: N

    9 HOLD_CD Character(6) VARCHAR2(6) NOT NULL Hold Code

    Prompt Table: HOLD_OPR_SECVW1

    10 PASS_HOLD_TO_BI Character(1) VARCHAR2(1) NOT NULL Pass to Billing

    Y/N Table Edit

    Default Value: N

    11 PASS_HOLD_TO_ID Character(1) VARCHAR2(1) NOT NULL Pass to Released

    Y/N Table Edit

    Default Value: N

    12 PASS_HOLD_TO_IP Character(1) VARCHAR2(1) NOT NULL Pass to Picked/Confirmed

    Y/N Table Edit

    Default Value: N

    13 PASS_HOLD_TO_IR Character(1) VARCHAR2(1) NOT NULL Pass to Releasable

    Y/N Table Edit

    Default Value: N

    14 PASS_HOLD_TO_IS Character(1) VARCHAR2(1) NOT NULL Pass to Shipped

    Y/N Table Edit

    Default Value: N

    15 PASS_HOLD_TO_IU Character(1) VARCHAR2(1) NOT NULL Pass to Unfulfilled

    Y/N Table Edit

    Default Value: N

    16 PASS_TO_PURCH Character(1) VARCHAR2(1) NOT NULL Pass to Purchasing

    Y/N Table Edit

    Default Value: N

    17 INCL_IN_PLAN Character(1) VARCHAR2(1) NOT NULL Include in Planning

    Y/N Table Edit

    Default Value: N

    18 SANCTION_MATCH_FLG Character(1) VARCHAR2(1) NOT NULL 02/14/06 EGS: Created

    Y/N Table Edit

    Default Value: N

    19 CWB_DISPLAY_OPT Character(1) VARCHAR2(1) NOT NULL Options for Collections Workbench

    Y/N Table Edit

    Default Value: Y