PMT_FMT_DEFN_VW (SQL View)	Index Back
Add View Format Definitions Add Search Format Definitions

PMT_FMT_DEFN_VW

(SQL View)

Add View Format Definitions

Add Search Format Definitions

SELECT FORMAT_ID , FORMAT_DOC_TYPE , FORMAT_NAME FROM PS_PMT_FORMAT_DEFN

# 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

#	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