GP_FG_RUN_DTLS

(SQL Table)
Index Back

Auto Populate Pmt Gen ID

Table used to auto populate Payment Generation ID

# 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
4 GP_PMT_GEN_ID Character(20) VARCHAR2(20) NOT NULL Payment Generation ID
5 TIME_STAMP DateTime(26) TIMESTAMP Time Stamp
6 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
7 GP_CHAR_VAL Character(50) VARCHAR2(50) NOT NULL Used to store character values on the banking preparation definition page. (SEPA/Financial Gateway)
8 GP_PARENT_SEQ Number(2,0) SMALLINT NOT NULL Sequence number for each parent row used while storing the Run data of Payment File Generation (SEPA/Financial Gateway)
9 GP_CHILD_SEQ Number(2,0) SMALLINT NOT NULL Sequence number for each child row. Used in Payment Generation process for SEPA/Financial Gateway.