CAL_RUN_IDSRC_BANK_IDGPTH_EFT_SRC_VW(SQL View) |
Index Back |
|---|---|
View for source bankTo capture additional field for some Thailand Banks |
| SELECT DISTINCT A.CAL_RUN_ID , A.SRC_BANK_ID , B.EFT_NAME_DOMESTIC , B.DESCR FROM PS_GP_PAYMENT A , PS_SRC_BANK B WHERE (A.PMT_STATUS = 'F' OR A.PMT_STATUS = 'T') AND B.SRC_BANK_ID = A.SRC_BANK_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 2 | SRC_BANK_ID |
Character(8) | VARCHAR2(8) NOT NULL | Source Bank ID |
| 3 | EFT_NAME_DOMESTIC | Character(10) | VARCHAR2(10) NOT NULL | EFT Format Domestic |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |