# |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
1 |
PMT_MSG_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Identification for the instance of a PAYMENT_REQUEST message
(SEPA/Financial Gateway)
|
2 |
PMT_SOURCE |
Character(10) |
VARCHAR2(10) NOT NULL |
Source system this transaction is originating from
(SEPA/Financial Gateway)
|
3 |
TOTAL_PMT_COUNT |
Number(7,0) |
INTEGER NOT NULL |
Total count of payments in PMT_DETAIL_STG
|
4 |
TOTAL_PMT_SUM |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Sum of all payments in PMT_DETAIL_STG
|