BNK_RCN_PYMR1_S (SQL View)	Index Back
Deposit Control Sum for Recon This view sums up all revalued PAYMENTs per deposit control line into the default currency of the bank account. This is necessary as CONTROL_CURRENCY could be blank in the deposit control record (must to be blank for multi-currencied payments per Deposit). This view is used in BNK_RCN_DEPR view text and the fields CURRENCY_CD and BANK_ACCT_RVL_AMTare used from this view.

BNK_RCN_PYMR1_S

(SQL View)

Deposit Control Sum for Recon

This view sums up all revalued PAYMENTs per deposit control line into the default currency of the bank account. This is necessary as CONTROL_CURRENCY could be blank in the deposit control record (must to be blank for multi-currencied payments per Deposit). This view is used in BNK_RCN_DEPR view text and the fields CURRENCY_CD and BANK_ACCT_RVL_AMTare used from this view.

SELECT DEPOSIT_BU ,DEPOSIT_ID ,CURRENCY_CD ,BNK_ID_NBR ,BANK_ACCOUNT_NUM ,SUM(BANK_ACCT_RVL_AMT) FROM PS_BNK_RCN_PAYMR1 GROUP BY DEPOSIT_BU ,DEPOSIT_ID ,CURRENCY_CD ,BNK_ID_NBR ,BANK_ACCOUNT_NUM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DEPOSIT_BU Character(5) VARCHAR2(5) NOT NULL Identifies the business unit to which a deposit is posted.

2 DEPOSIT_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated.

3 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

4 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.

5 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.

6 BANK_ACCT_RVL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Field used to store the amount on a transaction revalued in the base currency of the transactions bank account.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DEPOSIT_BU	Character(5)	VARCHAR2(5) NOT NULL	Identifies the business unit to which a deposit is posted.
2	DEPOSIT_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated.
3	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
4	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
5	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
6	BANK_ACCT_RVL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Field used to store the amount on a transaction revalued in the base currency of the transactions bank account.