OPRIDDefault Value: OPRID
Prompt Table: OPRID_VW
RUN_CNTL_IDPrompt Table: GP_BNK_SRC_VW
Prompt Table: GP_BNK_FL_ID_VW
GP_BNK_RCN_RC(SQL Table) |
Index Back |
|---|---|
Payment Recon Run ControlPayment Reconciliation Run Control |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPRID Prompt Table: OPRID_VW |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | SRC_BANK_ID | Character(8) | VARCHAR2(8) NOT NULL |
Source Bank ID
Prompt Table: GP_BNK_SRC_VW |
| 4 | BANK_CD | Character(11) | VARCHAR2(11) NOT NULL | Bank ID |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | ACCOUNT_EC_ID | Character(35) | VARCHAR2(35) NOT NULL | Account Number used in banking. |
| 7 | ACCOUNT_NAME | Character(50) | VARCHAR2(50) NOT NULL | Account Name |
| 8 | BNK_FILE_ID | Number(10,0) | DECIMAL(10) NOT NULL |
Auto generated number when Bank File is loaded
Prompt Table: GP_BNK_FL_ID_VW |