CC_BANK_TMP

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code

Prompt Table: BANK_CD_INT_VW

4 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank
5 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

6 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
7 PYMNT_HANDLING_CD Character(2) VARCHAR2(2) NOT NULL Payment Handling

Prompt Table: %EDITTABLE4

8 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type

Prompt Table: CUR_RT_TYPE_TBL

9 DFI_ID_NUM Character(12) VARCHAR2(12) NOT NULL A banking industry convention identifier utilized to drive electronic settlements processing for a given bank/coun
10 DFI_ID_QUAL Character(2) VARCHAR2(2) NOT NULL A banking industry convention identifier utilized to drive data validation for a given bank/counterparty.
01=Transit Number
02=Swift ID/BIC
03=CHIPS Participant ID
04=Canadian Bank Branch/Institute
05=CHIPS Universal ID
ZZ=Mutually Defined
11 BRANCH_ID Character(10) VARCHAR2(10) NOT NULL The local branch office identifier associated with a given bank/counterparty.
12 CHECK_DIGIT Character(2) VARCHAR2(2) NOT NULL Check Digit