RO_DEFN_HLD_DEN

(SQL Table)
 Index Back

Reason Codes

Define the hold denial and cancellation codes for order capture

  • Related Language Record: RO_DEFN_HDENLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Prompt Table: SP_SETID_NONVW

    2 HOLD_DENIAL_CD Character(6) VARCHAR2(6) NOT NULL Define the hold denial codes that can be used by order capture an enterprise user want to deny an order that was placed by a partner user and went on hold.
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 RO_REASON_TYPE Character(4) VARCHAR2(4) NOT NULL Reason code type for hold denials and cancellation reason codes.
    ACT=Activate Reason
    CHG=Change Reason
    CHR=Charge Reason
    CNCL=Cancellation Reason
    CPH=Change Phone Reason
    DISC=Disconnect Reason
    HOLD=Hold Denial
    NORD=New Order
    OVRD=Hold Override
    PAC=PAC Request Reason
    RENW=Renew Reasons
    RESM=Resume Reason
    SNC=Suspend and Change
    SNR=Suspend and Resume
    SUS=Suspend Reason

    Default Value: HOLD

    5 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    6 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    7 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    8 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    9 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    10 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time
    11 DESCRLONG Long Character CLOB Long Description