OPRIDRUN_CNTL_IDCAL_RUN_IDPrompt Table: GPNL_BNK_CALVW
PAY_ENTITYPrompt Table: GPNL_PYENT_DTL
1=Bank and Postbank Accounts
2=Bank Accounts
3=Postbank Accounts
1=Original
2=Duplicate
Default Value: %Date
1=XML Publisher
2=Winword
Default Value: 1
GPNL_RC_EFT(SQL Table) |
Index Back |
|---|---|
Banking Run ControlContains fields that are used as input parameters for banking report and EFT generation. Input data is retrieved from this record when a report is requested from the Process Scheduler. |
| # | 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 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Calendar Run Id
Prompt Table: GPNL_BNK_CALVW |
| 4 | PAY_ENTITY |
Character(10) | VARCHAR2(10) NOT NULL |
Pay Entity
Prompt Table: GPNL_PYENT_DTL |
| 5 | GPNL_BANK_RECIP | Character(1) | VARCHAR2(1) NOT NULL |
Banking Recipient
1=Bank and Postbank Accounts 2=Bank Accounts 3=Postbank Accounts |
| 6 | GPNL_FIXED_DESCR | Character(32) | VARCHAR2(32) NOT NULL | Fixed Describtion Info |
| 7 | GPNL_BATCH_REF | Character(6) | VARCHAR2(6) NOT NULL | Batch Reference |
| 8 | GPNL_PAYMENT_DT | Date(10) | DATE | Process Data from EFT Netherdalns |
| 9 | GPNL_DELIVERY_TYP | Character(1) | VARCHAR2(1) NOT NULL |
Delivery type
1=Original 2=Duplicate |
| 10 | GPNL_CLIEOP_NBR | Character(2) | VARCHAR2(2) NOT NULL | Banking Report ClieOp03 |
| 11 | GPNL_TODAY_DT | Date(10) | DATE | Today Date |
| 12 | GPNL_EXECUTION_DT | Date(10) | DATE |
Execution Date
Default Value: %Date |
| 13 | GPNL_EXEC_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Define the method of delivering the payment instruction letter for the Netherlands, either using Winword Merge or XML Publisher.
1=XML Publisher 2=Winword Default Value: 1 |