COUNTRYPrompt Table: GP_COUNTRYSS_VW
SEQ_NUM5CT=Customer
OR=Oracle
OR=Oracle
Default Value: OR
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
Default Value: SEPA_CT
Prompt Table: GP_PMT_FMT_DEFN
GP_SQL_HDR(SQL Table) |
Index Back |
|---|---|
Header table for FGSets up Country defined SQL to insert into GP_PAYMENT_FG from GP_PAYMENT. SEPA/Financial Gateway |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: GP_COUNTRYSS_VW |
| 2 | SEQ_NUM5 |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 3 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 4 | GP_OWNER | Character(2) | VARCHAR2(2) NOT NULL |
Stores the Owner value, P or C
(SEPA/Financial Gateway)
CT=Customer OR=Oracle OR=Oracle Default Value: OR |
| 5 | GP_SQL_GENERATED | Character(1) | VARCHAR2(1) NOT NULL |
Used to indicate of the SQL has been generated already in the Banking Prep Definition.
Y/N Table Edit Default Value: N |
| 6 | GP_SQL_MODIFIED | Character(1) | VARCHAR2(1) NOT NULL |
Used to indicate if the generated SQL in Banking Prep Defn has been manually modified by the user.
Y/N Table Edit Default Value: N |
| 7 | FORMAT_ID | Character(10) | VARCHAR2(10) NOT NULL |
Format payment name. (SEPA/Financial Gateway)
Default Value: SEPA_CT Prompt Table: GP_PMT_FMT_DEFN |
| 8 | GP_SQL_SEPA_STMT | Long Character | CLOB | SEPA/Financial Gateway |