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
|
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 |