COUNTRYSEQ_NUM5SEQNOCHR=Character
DAT=Date
FLD=GP_PAYMENT Record
NUM=Number
OTH=Other Record.Field
AVG=AVG
CNT=COUNT
MAX=MAX
MIN=MIN
SUM=SUM
Prompt Table: GP_PMNT_VW
N=No
Y=Yes
Y/N Table Edit
Default Value: N
GP_SQL_DTLS(SQL Table) |
Index Back |
|---|---|
Details table for FGDetails table for FG SEPA/Financial Gateway |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL | Country |
| 2 | SEQ_NUM5 |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 3 | SEQNO |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 4 | GP_OUTPUT_FLD | Character(18) | VARCHAR2(18) NOT NULL | Store the Input field from GP_PAYMENT_FG record (SEPA/Financial Gateway) |
| 5 | FIELDTYPE | Number(2,0) | SMALLINT NOT NULL | Field Type (from PSST0101 Ref.) |
| 6 | GP_SRC_INPUT_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Source Input Type on banking preparation definition page
(SEPA/Financial Gateway)
CHR=Character DAT=Date FLD=GP_PAYMENT Record NUM=Number OTH=Other Record.Field |
| 7 | GP_AGGREGATE_FUNC | Character(3) | VARCHAR2(3) NOT NULL |
Aggregate function used on the banking preparation definition page. (SEPA/Financial Gateway)
AVG=AVG CNT=COUNT MAX=MAX MIN=MIN SUM=SUM |
| 8 | GP_INPUT_FLD | Character(18) | VARCHAR2(18) NOT NULL |
Store the Input field from record GP_PAYMENT. (SEPA/Financial Gateway)
Prompt Table: GP_PMNT_VW |
| 9 | GP_OTHER_REC | Character(25) | VARCHAR2(25) NOT NULL | Stores the Generated SQL (SEPA/Financial Gateway) |
| 10 | GP_CHAR_VAL | Character(50) | VARCHAR2(50) NOT NULL | Used to store character values on the banking preparation definition page. (SEPA/Financial Gateway) |
| 11 | GP_DATE_VAL | Date(10) | DATE | Used to store Date value used on the banking preparation definition page. (SEPA/Financial Gateway) |
| 12 | GP_NUM_VAL | Number(20,6) | DECIMAL(19,6) NOT NULL | Used to store Number value used on the banking preparation definition page |
| 13 | GP_GRP_BY_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Group By Flag used to group payments on the banking preparation definition page. (SEPA/Financial Gateway)
N=No Y=Yes Y/N Table Edit Default Value: N |