SCC_EPAY_INTG_IDPrompt Table: SCC_EP_HPAY_ADP
SEQNUMC=Canceled Return URL
D=Declined Return URL
E=Error Return URL
S=Successful Return URL
SCC_HPAY_ADW_VW(SQL View) |
Index Back |
|---|---|
Hosted Payment Parm ViewJoin of the Hosted Payment Adapter table and its child Hosted Payment Weblib function. |
| SELECT A.SCC_EPAY_INTG_ID , A.SEQNUM , B.RECNAME , B.FIELDNAME , A.SCC_EPAY_URL_TYPE , A.SCC_WEBLIB_FUNC FROM PS_SCC_HPAY_WEBLIB A , PS_SCC_HPAY_ADAPTR B WHERE A.SCC_EPAY_INTG_ID = B.SCC_EPAY_INTG_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCC_EPAY_INTG_ID |
Character(20) | VARCHAR2(20) NOT NULL |
Payment Integration ID (points to a payment adapter/application class)
Prompt Table: SCC_EP_HPAY_ADP |
| 2 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 3 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 4 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 5 | SCC_EPAY_URL_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Return URL Type
C=Canceled Return URL D=Declined Return URL E=Error Return URL S=Successful Return URL |
| 6 | SCC_WEBLIB_FUNC | Character(70) | VARCHAR2(70) NOT NULL | Function |