RO_HLD_DEN_LVW(SQL View) |
Index Back |
|---|---|
Reason CodesView to obtain the language hold denial and cancellation codes for order capture |
| SELECT A.SETID , A.HOLD_DENIAL_CD , B.LANGUAGE_CD , B.DESCR , A.RO_REASON_TYPE FROM PS_RO_DEFN_HLD_DEN A , PS_RO_DEFN_HDENLNG B WHERE A.SETID = B.SETID AND A.HOLD_DENIAL_CD = B.HOLD_DENIAL_CD |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | 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 |