| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 FORMAT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Format ID
|
| 2 |
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
|
| 3 |
FORMAT_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Layout Name
|
| 4 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 5 |
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
Default Value: 02
|
| 6 |
TRANSFORM_PROGRAM |
Character(30) |
VARCHAR2(30) NOT NULL |
Transformation Program Name
Prompt Table:
PSRELTRNSFRMVW
|
| 7 |
PACKAGEROOT |
Character(30) |
VARCHAR2(30) NOT NULL |
Root Package ID
Prompt Table:
APPPACKAGE_VW
|
| 8 |
QUALIFYPATH |
Character(127) |
VARCHAR2(127) NOT NULL |
Qualified Package/Class Path
Prompt Table:
APPPCKGEPATH_VW
|
| 9 |
APPCLASSID |
Character(30) |
VARCHAR2(30) NOT NULL |
Application Class ID
Prompt Table:
APPCLASS_VW
|
| 10 |
REPORT_DEFN_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Report Name (see PSXPRPTDEFN).
Prompt Table:
PSXPRPTDEFN
|
| 11 |
TEMPLATE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Project Template
|
| 12 |
SOURCE_DOC |
Character(30) |
VARCHAR2(30) NOT NULL |
Source Document Name
Prompt Table:
PMT_SRC_DOC_VW
|
| 13 |
TRANSFORM_MSG |
Character(30) |
VARCHAR2(30) NOT NULL |
Result Message Name
Prompt Table:
PSMSGDEFNVW1
|
| 14 |
CHUNK_CD |
Character(15) |
VARCHAR2(15) NOT NULL |
Grouping Rule
Prompt Table:
PMT_CHUNK_DEFN
|
| 15 |
MAX_PMT_COUNT |
Number(9,0) |
DECIMAL(9) NOT NULL |
Maximum Payments per File
|