PMT_ACKREF_VW(SQL View) |
Index Back |
|---|---|
Payment ack file view |
| SELECT C.PMT_ACK_FILE_ID ,A.PMT_ID ,A.PMT_SOURCE , A.PMT_STATUS , 0 , 0 , ' ' , A.PMT_MSG_ID , A.PMT_SEQ_NUM , C.BANK_REF_ID ,C.FED_WIRE_ID , %subrec(PMT_REFKEYS_SBR,B) FROM PS_PMT_ACK C ,PS_PMT_DETAIL_TBL A , PS_PMT_REF_TBL B WHERE C.PYMNT_REF_ID = B.PMT_ID AND C.PYMNT_REF_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 | PMT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Payment id |
| 3 | PMT_SOURCE | Character(10) | VARCHAR2(10) NOT NULL | Source System Name |
| 4 | 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 |
| 5 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 6 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 7 | ERROR_MESSAGE | Character(254) | VARCHAR2(254) NOT NULL | For Standard Journal (SJE) |
| 8 | PMT_MSG_ID | Character(15) | VARCHAR2(15) NOT NULL | Payment Message ID |
| 9 | PMT_SEQ_NUM | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 10 | BANK_REF_ID | Character(16) | VARCHAR2(16) NOT NULL | A reference identifier associated with a given bank/counterparty transaction. |
| 11 | FED_WIRE_ID | Character(22) | VARCHAR2(22) NOT NULL | This field will hold the Federal Wire ID # that is given upon confirmation of a successful wire transfer. |
| 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 |