GP_PMT_FG_AET(SQL Table) |
Index Back |
|---|---|
Payment File Generation CachePayment File Generation Cache Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | 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 |
| 5 | DEBIT_DT | Date(10) | DATE | Debit Date |
| 6 | 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 |
| 7 | 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 |
| 8 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 9 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL |
Pay Entity
Prompt Table: GP_PYENT1_VW |
| 10 | SRC_BANK_ID | Character(8) | VARCHAR2(8) NOT NULL |
Source Bank ID
Prompt Table: SRC_BANK |
| 11 | GP_PMT_GEN_ID | Character(20) | VARCHAR2(20) NOT NULL |
Payment Generation ID
Prompt Table: GP_FG_RUN_DTLS |
| 12 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL |
Calendar Run Id
Prompt Table: GP_CAL_RUN |
| 13 | RECIPIENT_ID | Character(8) | VARCHAR2(8) NOT NULL |
Payment recipient ID
Prompt Table: RECIPIENT |
| 14 | FILE_ID | Character(30) | VARCHAR2(30) NOT NULL |
File Identifier
Prompt Table: GP_PAYMENT_FG |
| 15 | TMPLDEFN_ID | Character(30) | VARCHAR2(30) NOT NULL |
Template ID (see PSXPTMPLDEFN).
Prompt Table: PSXPRPTTMPL_VW |
| 16 | REPORT_DEFN_ID | Character(12) | VARCHAR2(12) NOT NULL |
Report Name (see PSXPRPTDEFN).
Prompt Table: PSXPRPTDEFN |
| 17 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 18 | SELECTED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Selected Flag
Y/N Table Edit |
| 19 | PMT_MSG_ID | Character(15) | VARCHAR2(15) NOT NULL | Identification for the instance of a PAYMENT_REQUEST message (SEPA/Financial Gateway) |
| 20 | SQL_STMT_254 | Character(254) | VARCHAR2(254) NOT NULL | An internal work field that contains SQL text that is to be utilized in treasury application p |
| 21 | GP_PMT_COUNT | Number(5,0) | INTEGER NOT NULL | Number of rows sent to FG per chunk during SEPA |
| 22 | AE_TEST_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Test Flag |
| 23 | GP_CHILD_SEQ | Number(2,0) | SMALLINT NOT NULL | Sequence number for each child row. Used in Payment Generation process for SEPA/Financial Gateway. |
| 24 | PMT_SEQ_NUM | Number(7,0) | INTEGER NOT NULL | Sequence number which must be unique for the PMT_MSG_ID (SEPA/Financial Gateway) |