BANK_FRMTBSR_VW

(SQL View)
Index Back

Integration Format properties


SELECT SETID ,BANK_CD ,FORMAT_DOC_TYPE ,FORMAT_ID ,OUTPUT_TYPE ,BANKNODE ,PROGRAM_ID ,SYNC_ASYNC_SW FROM PS_BANK_FORMAT WHERE FORMAT_DOC_TYPE='BSR'

# 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_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
4 FORMAT_ID Character(10) VARCHAR2(10) NOT NULL Format ID

Prompt Table: PMT_FRMTDOC_VW
Set Control Field: FORMAT_DOC_TYPE

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 SYNC_ASYNC_SW Character(1) VARCHAR2(1) NOT NULL Switch to identify synchronous from asynchronous

Y/N Table Edit