SRC_BANK_IDPrompt Table: GP_BNK_SRC_VW1
BANK_CDPrompt Table: GP_BNK_CD_VW1
ACCOUNT_EC_IDPrompt Table: GP_BNK_ECID_VW1
Prompt Table: GP_BNK_CUR_VW
BNK_FILE_IDBNK_FILE_ID_WRKGP_BNK_FLADD_VW(SQL View) |
Index Back |
|---|---|
Search Rcd Bank File EntryUsed as Search Record Add Mode Bank File Entry Component |
| SELECT A.SRC_BANK_ID , A.BANK_CD , A.ACCOUNT_EC_ID , A.CURRENCY_CD , B.BNK_FILE_ID , 'NEXT' , A.DESCR FROM PS_SRC_BANK A , PS_GP_BNK_FILE_HDR B WHERE A.BANK_CD = B.BANK_CD AND B.ACCOUNT_EC_ID = B.ACCOUNT_EC_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SRC_BANK_ID |
Character(8) | VARCHAR2(8) NOT NULL |
Source Bank ID
Prompt Table: GP_BNK_SRC_VW1 |
| 2 | BANK_CD |
Character(11) | VARCHAR2(11) NOT NULL |
Bank ID
Prompt Table: GP_BNK_CD_VW1 |
| 3 | ACCOUNT_EC_ID |
Character(35) | VARCHAR2(35) NOT NULL |
Account Number used in banking.
Prompt Table: GP_BNK_ECID_VW1 |
| 4 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: GP_BNK_CUR_VW |
| 5 | BNK_FILE_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Auto generated number when Bank File is loaded |
| 6 | BNK_FILE_ID_WRK |
Character(10) | VARCHAR2(10) NOT NULL | Bank FIle ID work field |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |