| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PMT_SOURCE |
Character(10) |
VARCHAR2(10) NOT NULL |
Source System Name
|
| 2 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 3 |
INBOUND_INT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Inbound Integration Type
A=Application Class
C=Component Interface
F=Flat File
I=Integration Broker
S=SQL
Default Value: A
|
| 4 |
OUTBOUND_INT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Outbound Integration Type
A=Application Class
F=Flat File
M=Integration Broker
N=None
Default Value: A
|
| 5 |
NODE_NAME |
Character(40) |
VARCHAR2(40) NOT NULL |
Node Name
Prompt Table:
PSMSGNODEDEFN
|
| 6 |
PACKAGEROOT |
Character(30) |
VARCHAR2(30) NOT NULL |
Root Package ID
Prompt Table:
APPPACKAGE_VW
|
| 7 |
QUALIFYPATH |
Character(127) |
VARCHAR2(127) NOT NULL |
Qualified Package/Class Path
Prompt Table:
APPPCKGEPATH_VW
|
| 8 |
APPCLASSID |
Character(30) |
VARCHAR2(30) NOT NULL |
Application Class ID
Prompt Table:
APPCLASS_VW
|
| 9 |
FILE_PATH_NAME |
Character(254) |
VARCHAR2(254) NOT NULL |
File Path
|
| 10 |
PMT_DRILL_TO_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Drill to Source Transaction
C=Component
D=DoModal Component
E=External URL
N=None
Default Value: N
|
| 11 |
PMT_DRILL_NEWWIN |
Character(1) |
VARCHAR2(1) NOT NULL |
Open In New Window
Y/N Table Edit
Default Value: N
|
| 12 |
PNLGRPNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Component Name
Prompt Table:
MENU_PNLGRP_VW
|
| 13 |
MENUNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Menu Name (see PSMENUDEFN).
Prompt Table:
PSMENUDEFN
|
| 14 |
URL_ADDRESS |
Character(254) |
VARCHAR2(254) NOT NULL |
URL_ADDRESS
|
| 15 |
PMT_ID_MASK |
Character(5) |
VARCHAR2(5) NOT NULL |
Financial Gateway - Payment Id Mask
|
| 16 |
LAST_PAYMENT_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Payment Number Numeric
|
| 17 |
EXTERNAL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
External Source
Y/N Table Edit
Default Value: N
|
| 18 |
PAYEE_VALIDATE_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Signifies whether payees require validation or not.
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 19 |
PMT_SRC_SOAP_WRAP |
Character(1) |
VARCHAR2(1) NOT NULL |
Determines whether response messages for web services should be wrapped using a SOAP envelope.
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 20 |
IMPORT_VIA_IB_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Determines whether to load a statement via Integration Broker or not.
Y/N Table Edit
Default Value: N
|
| 21 |
BANKNODE |
Character(30) |
VARCHAR2(30) NOT NULL |
Bank Node
Prompt Table:
PSMSGNODEDEFN
|
| 22 |
REMIT_ADVISE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to be used for sending remittance advise through FG
Y/N Table Edit
Default Value: N
|
| 23 |
REPORT_DEFN_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Report Name (see PSXPRPTDEFN).
|
| 24 |
REMIT_EMAILID |
Character(70) |
VARCHAR2(70) NOT NULL |
Remittance Email ID
|
| 25 |
ERRORS_ONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Errors Only
Y/N Table Edit
Default Value: N
|
| 26 |
DISPATCH_ON_LOAD |
Character(1) |
VARCHAR2(1) NOT NULL |
Dispatch on Load
Y/N Table Edit
Default Value: N
|