| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
PMTRUNINSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process ID
|
| 3 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 4 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
|
| 5 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
|
| 6 |
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
|
| 7 |
BUSINESS_DATE |
Date(10) |
DATE |
Represents a date upon which business is conducted within a given company in a given country.
|
| 8 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 9 |
PMT_FILE_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Payment File ID
|
| 10 |
FORMAT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Format ID
|
| 11 |
PMT_CRYPTO_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Payment encrypted ID
|
| 12 |
PROGRAM_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Program ID
|
| 13 |
OUTPUT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Output type
E=EBICS
F=File
M=Integration Broker
|
| 14 |
BANKNODE |
Character(30) |
VARCHAR2(30) NOT NULL |
Bank Node
|
| 15 |
ACK_ENABLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Supports Acknowledgements
|
| 16 |
PUBID |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Publication Identifier
|
| 17 |
IBPUBTRANSACTID |
Character(36) |
VARCHAR2(36) NOT NULL |
Orig Transaction ID
|
| 18 |
TRANSFORM_MSG |
Character(30) |
VARCHAR2(30) NOT NULL |
Result Message Name
|
| 19 |
TRANSFORM_PROGRAM |
Character(30) |
VARCHAR2(30) NOT NULL |
Transformation Program Name
|
| 20 |
TRANS_PROGRAM_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Transformation Program Type
01=AE Transform
02=Application Class
03=BI Publisher
04=SQL Transform
05=Data Mapper
|
| 21 |
PACKAGEROOT |
Character(30) |
VARCHAR2(30) NOT NULL |
Root Package ID
|
| 22 |
QUALIFYPATH |
Character(127) |
VARCHAR2(127) NOT NULL |
Qualified Package/Class Path
|
| 23 |
APPCLASSID |
Character(30) |
VARCHAR2(30) NOT NULL |
Application Class ID
|
| 24 |
PMT_FILE_PATH |
Character(254) |
VARCHAR2(254) NOT NULL |
Payment file path
|
| 25 |
FILENAME |
Character(80) |
VARCHAR2(80) NOT NULL |
File Name
|
| 26 |
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.
|
| 27 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 28 |
AE_APPSTATUS |
Number(1,0) |
SMALLINT NOT NULL |
AE Application Warning Status
|
| 29 |
SELECTED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Selected Flag
N=Not Selected
Y=Seleted
|
| 30 |
TEMP_FLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Temporary Field for App Engine
|
| 31 |
PMT_SOURCE |
Character(10) |
VARCHAR2(10) NOT NULL |
Source System Name
|
| 32 |
EVENT_CODE |
Character(15) |
VARCHAR2(15) NOT NULL |
Event code that corresponds to a specific type of event. Can be used for finer filtering of events.
|
| 33 |
FILE_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
File Status
C=Complete
CE=Complete with Errors
E=Error
P=In Process
R=Received by Bank
S=Sent to Bank
X=Canceled
|
| 34 |
TOTAL_PMT_COUNT |
Number(7,0) |
INTEGER NOT NULL |
Total Payment count
|
| 35 |
LAST_SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Last Sequence number in list
|
| 36 |
FROM_SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
From Line
|
| 37 |
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
|
| 38 |
REPORT_DEFN_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Report Name (see PSXPRPTDEFN).
|
| 39 |
TEMPLATE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Project Template
|
| 40 |
PRENOTE_PMT_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Payment status for prenotes.
C=Canceled
E=Error
H=Flagged for Hold
L=Awaiting Dispatch
P=Paid
R=Received by Bank
S=Dispatched to Bank
SC=In Process
|