PMT_ACKFLREF_VW(SQL View) |
Index Back |
|---|---|
Payment ack all in file view |
| SELECT C.PMT_ACK_FILE_ID ,C.HEADER_ID ,C.FILE_ACK_STATUS ,A.PMT_ID ,A.PMT_SOURCE ,A.PMT_STATUS ,A.EVENT_TRACKING_ID , 0 , 0 , ' ' , A.PMT_MSG_ID , %subrec(PMT_REFKEYS_SBR,B) FROM PS_PMT_FILE_ACK C ,PS_PMT_DETAIL_TBL A , PS_PMT_REF_TBL B WHERE C.HEADER_ID = A.PMT_FILE_ID AND B.PMT_ID = A.PMT_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PMT_ACK_FILE_ID |
Character(12) | VARCHAR2(12) NOT NULL | Payment file id |
| 2 | HEADER_ID | Character(8) | VARCHAR2(8) NOT NULL | Header_id |
| 3 | FILE_ACK_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Ack status
A=Payments Accepted E=File in Error R=File Received by Bank W=File Accepted With Error |
| 4 | PMT_ID | Character(15) | VARCHAR2(15) NOT NULL | Payment id |
| 5 | PMT_SOURCE | Character(10) | VARCHAR2(10) NOT NULL | Source System Name |
| 6 | PMT_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Payment status
C=Canceled CM=Cancelled with Message E=Error H=Flagged for Hold L=Awaiting Dispatch N=Not Processed P=Paid PC=Pending Cancellation PR=Pending Reversal R=Received by Bank RM=Reversed with Message S=Dispatched to Bank SC=In Process |
| 7 | EVENT_TRACKING_ID | Number(10,0) | DECIMAL(10) NOT NULL | The event tracking ID is used in order to correlate objects with an event. Each object (i.e. Payment) will store the tracking ID with a given payment. That way the system can obtain all the events for a given payment via the tracking ID. |
| 8 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 9 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 10 | ERROR_MESSAGE | Character(254) | VARCHAR2(254) NOT NULL | For Standard Journal (SJE) |
| 11 | PMT_MSG_ID | Character(15) | VARCHAR2(15) NOT NULL | Payment Message ID |
| 12 | KEY_CHAR_40_01 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/01 |
| 13 | KEY_CHAR_40_02 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/02 |
| 14 | KEY_CHAR_40_03 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/03 |
| 15 | KEY_CHAR_40_04 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/04 |
| 16 | KEY_CHAR_40_05 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/05 |
| 17 | KEY_CHAR_40_06 | Character(40) | VARCHAR2(40) NOT NULL | Key_Char 40/06 |
| 18 | KEY_CHAR_40_07 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/07 |
| 19 | KEY_CHAR_40_08 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/08 |
| 20 | KEY_CHAR_40_09 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/09 |
| 21 | KEY_CHAR_40_10 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/10 |
| 22 | KEY_CHAR_40_11 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/11 |
| 23 | KEY_CHAR_40_12 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/12 |
| 24 | KEY_CHAR_40_13 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/13 |
| 25 | KEY_CHAR_40_14 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/14 |
| 26 | KEY_CHAR_40_15 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/15 |
| 27 | KEY_DATE_01 | Date(10) | DATE | Key Date 01 |
| 28 | KEY_DATE_02 | Date(10) | DATE | Key Date 02 |
| 29 | KEY_DATE_03 | Date(10) | DATE | Key Date 03 |
| 30 | KEY_DATE_04 | Date(10) | DATE | Key Date 04 |
| 31 | KEY_DATE_05 | Date(10) | DATE | Key Date 05 |
| 32 | KEY_DTTM_01 | DateTime(26) | TIMESTAMP | Key Date Time 01 |
| 33 | KEY_DTTM_02 | DateTime(26) | TIMESTAMP | Key Date Time 02 |
| 34 | KEY_DTTM_03 | DateTime(26) | TIMESTAMP | Key Date Time 03 |
| 35 | KEY_DTTM_04 | DateTime(26) | TIMESTAMP | Key Date Time 04 |
| 36 | KEY_DTTM_05 | DateTime(26) | TIMESTAMP | Key Date Time 05 |
| 37 | KEY_SIGN_01 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Key Signed Number 01 |
| 38 | KEY_SIGN_02 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Key Signed Number 02 |
| 39 | KEY_SIGN_03 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Key Signed Number 03 |
| 40 | KEY_SIGN_04 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Key Signed Number 04 |
| 41 | KEY_SIGN_05 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Key Signed Number 05 |