EFT_LAYOUT_CDPROCESS_INSTANCEEFT_BANK_TMP_VW(SQL View) |
Index Back |
|---|---|
EFT Bank Advice Letter |
| SELECT DISTINCT A.EFT_LAYOUT_CD , A.PROCESS_INSTANCE , A.BANK_NAME , A.PAY_CYCLE , A.RUN_CNTL_ID , B.REMIT_VENDOR , B.VENDOR_NAME , B.PYMNT_ID_REF , B.PYMNT_DT FROM PS_EFT_BANK_TMP A , PS_EFT_ADVICE_TMP B WHERE A.EFT_LAYOUT_CD = B.EFT_LAYOUT_CD AND A.PROCESS_INSTANCE = B.PROCESS_INSTANCE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EFT_LAYOUT_CD |
Character(10) | VARCHAR2(10) NOT NULL | EFT Layout Code |
| 2 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 3 | BANK_NAME | Character(30) | VARCHAR2(30) NOT NULL | Bank Name |
| 4 | PAY_CYCLE | Character(6) | VARCHAR2(6) NOT NULL | Pay Cycle |
| 5 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 6 | REMIT_VENDOR | Character(10) | VARCHAR2(10) NOT NULL | Remit Vendor |
| 7 | VENDOR_NAME | Character(30) | VARCHAR2(30) NOT NULL | Supplier Name |
| 8 | PYMNT_ID_REF | Character(20) | VARCHAR2(20) NOT NULL | Payment Reference |
| 9 | PYMNT_DT | Date(10) | DATE | Payment Date |