EFT_LAYOUT_CDPROCESS_INSTANCEEFT_FILE_RPT_VW(SQL View) |
Index Back |
|---|---|
Prompt View for EFT files |
| select A.EFT_LAYOUT_CD, A.PROCESS_INSTANCE, A.FILE_NAME_SHORT, A.FILE_CREATE_DT, A.PYMNT_AMT_TTL from PS_EFT_FILE_RPT A |
| # | 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 | FILE_NAME_SHORT | Character(30) | VARCHAR2(30) NOT NULL | File Name |
| 4 | FILE_CREATE_DT | Date(10) | DATE | File Creation Date |
| 5 | PYMNT_AMT_TTL | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Cumulative Payment Amount |