GP_FG_RUNCTL(SQL Table) |
Index Back |
|---|---|
Run Control DetailsPayment File Generation Run control details SEPA/Financial Gateway |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 4 | GP_PMT_GEN_ID |
Character(20) | VARCHAR2(20) NOT NULL |
Paymentt Generation Id
Prompt Table: GP_FG_RUN_VW |
| 5 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL |
Calendar Run Id
Prompt Table: GP_CAL_ID_VW |
| 6 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL |
Pay Entity
Prompt Table: GP_PAY_ENTY_VW |
| 7 | SRC_BANK_ID | Character(8) | VARCHAR2(8) NOT NULL |
Source Bank ID
Prompt Table: GP_SRC_BANK_VW |
| 8 | FILE_ID | Character(30) | VARCHAR2(30) NOT NULL |
File Identifier
Prompt Table: GP_FILE_ID_VW |
| 9 | RECIPIENT_ID | Character(8) | VARCHAR2(8) NOT NULL |
Payment recipient ID
Prompt Table: GP_RECPNT_ID_VW |
| 10 | GP_GEN_FILE | Character(1) | VARCHAR2(1) NOT NULL |
Used to Prepare Bank Advice. (SEPA/Financial Gateway)
N=No Y=Yes Y/N Table Edit Default Value: N |
| 11 | GP_FG_VAL_PB | Character(1) | VARCHAR2(1) NOT NULL | Push button to validate Calendar IDs |
| 12 | GP_SEND_TO_FG | Character(1) | VARCHAR2(1) NOT NULL |
Used to Send Prepared Bank Advice to financial Gateway.
N=No Y=Yes Y/N Table Edit Default Value: N |
| 13 | GP_FG_DESCR | Long Character | CLOB | Description field to display Calendar IDs |
| 14 | GP_GEN_RPT | Character(1) | VARCHAR2(1) NOT NULL |
Used to Generate report based on the data provided on the Payment Generation File Run control Page. (SEPA/Financial Gateway)
Y/N Table Edit Default Value: N |