| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETID_NONVW
|
| 2 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table:
BANK_CD_TBL
|
| 3 |
FORMAT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Format ID
Prompt Table:
PMT_FRMTDOC_VW
Set Control Field: FORMAT_DOC_TYPE
|
| 4 |
FORMAT_DOC_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Document Type
ACK=Payment Acknowledge
BS=Bank Statement
BSR=Bank Statement Request
CAN=Payment Cancellation
IMP=Import Payment
PMT=Payment
REV=Payment Reversal
SDN=Sanctions List
SEC=Security Market Values
SED=Security Definition
STK=Import Stock Quotes
TRP=Investment Pools Import
Default Value: PMT
|
| 5 |
OUTPUT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Output type
E=EBICS
F=File
M=Integration Broker
Default Value: M
|
| 6 |
BANKNODE |
Character(30) |
VARCHAR2(30) NOT NULL |
Bank Node
Prompt Table:
PSMSGNODEDEFN
|
| 7 |
PROGRAM_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Program ID
Prompt Table:
PMT_EXT_COMM
|
| 8 |
PMT_CRYPTO_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Payment encrypted ID
Prompt Table:
PMT_CRYPTPRFLVW
|
| 9 |
ACK_ENABLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Supports Acknowledgements
Default Value: N
|
| 10 |
SYNC_ASYNC_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Switch to identify synchronous from asynchronous
Y/N Table Edit
|
| 11 |
MAX_PMT_COUNT |
Number(9,0) |
DECIMAL(9) NOT NULL |
Maximum Payments per File
|
| 12 |
FORMAT_OPTION |
Character(15) |
VARCHAR2(15) NOT NULL |
Format Option
|
| 13 |
PRENOTE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Supports Prenotes
Y/N Table Edit
Default Value: N
|