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

SDN_FMT_DEFN_VW

(SQL View)

Format Definitions

Add Search Format Definitions

SELECT FORMAT_ID , FORMAT_DOC_TYPE , FORMAT_NAME , TRANSFORM_PROGRAM ,TRANSFORM_MSG FROM PS_PMT_FORMAT_DEFN WHERE FORMAT_DOC_TYPE = 'SDN'

# 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 TRANSFORM_PROGRAM Character(30) VARCHAR2(30) NOT NULL Transformation Program Name
Prompt Table: PSRELTRNSFRMVW

5 TRANSFORM_MSG Character(30) VARCHAR2(30) NOT NULL Result Message Name
Prompt Table: PSMSGDEFNVW1

#	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	TRANSFORM_PROGRAM	Character(30)	VARCHAR2(30) NOT NULL	Transformation Program Name Prompt Table: PSRELTRNSFRMVW
5	TRANSFORM_MSG	Character(30)	VARCHAR2(30) NOT NULL	Result Message Name Prompt Table: PSMSGDEFNVW1