PMT_HEADER_MAP(SQL Table) |
Index Back |
|---|---|
Payment EIP Message HeaderPayment EIP Message Header |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  HEADER_ID |
Character(8) | VARCHAR2(8) NOT NULL | Header_id |
| 2 | PYMNT_METHOD | Character(3) | VARCHAR2(3) NOT NULL |
Payment Method
ACH=Automated Clearing House BEF=Draft - Customer EFT BOO=Draft - Customer Initiated CHK=System Check D=Deposit DD=Direct Debit DFT=Draft - Supplier Initiated DRA=Draft EFT=Electronic Funds Transfer GE=Giro - EFT GM=Giro - Manual LC=Letter of Credit MAN=Manual Check TRW=Treasury Wire WIR=Wire Transfer |
| 3 | CREATEDTTM | DateTime(26) | TIMESTAMP | DateTime of Query Creation |
| 4 | GUID | Character(36) | VARCHAR2(36) NOT NULL | Unique Identifier |
| 5 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 6 | RUNCNTLID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 7 | ISODTTM | Character(30) | VARCHAR2(30) NOT NULL | DateTime of Query Creation |
| 8 | TOTAL_TRANS_COUNT | Number(7,0) | INTEGER NOT NULL | Total Transactions |
| 9 | TOTAL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Amount |