BNK_RCN_VW (SQL View)	Index Back
Bank Recon

BNK_RCN_VW

(SQL View)

Bank Recon

SELECT DISTINCT C.BNK_ID_NBR ,A.BANK_ACCOUNT_NUM , B.TRANSACTION_TBL ,A.PRE_RECONCILE , A.ENABLE_WF_SW , B.RECON_TRANS_CODE , A.RECON_TYPE_FLG , B.BNK_ACTIVE_LIMIT , B.BNK_LIMIT_HIGH_AMT , B.BNK_LIMIT_HIGH_DAY , B.BNK_LIMIT_HIGH_PCT , B.BNK_LIMIT_LOW_AMT , B.BNK_LIMIT_LOW_DAY , B.BNK_LIMIT_LOW_PCT , A.BUSINESS_UNIT_GL FROM PS_BANK_ACCT_DEFN A , PS_BANK_ACCT_RECON B , PS_BANK_CD_TBL C WHERE A.SETID = B.SETID AND A.BANK_CD = B.BANK_CD AND A.BANK_CD_CPTY = B.BANK_CD_CPTY AND A.BANK_ACCT_KEY = B.BANK_ACCT_KEY AND B.SETID = C.SETID AND B.BANK_CD = C.BANK_CD AND A.RECON_TYPE_FLG = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 TRANSACTION_TBL Character(18) VARCHAR2(18) NOT NULL Represents the database table(s) that contain system source transaction data for reconciliation pu

4 PRE_RECONCILE Character(1) VARCHAR2(1) NOT NULL Allows the user to indicate whether the automated reconciliation process should apply a n

5 ENABLE_WF_SW Character(1) VARCHAR2(1) NOT NULL Allows a user to enable workflow worklist processing for automated reconciliation purposes. Th
F=Nofitication Framework
N=No Workflow
Y=Workflow

6 RECON_TRANS_CODE Character(3) VARCHAR2(3) NOT NULL The PeopleSoft-specific bank transaction code
ACH=Automated Clearing House
B=Direct Debit
BA=Bank Adjustments
BOE=Bill of Exchange - Disburse
BOO=Bill of Order - Disburse
C=Trade Receipt
CHK=Check
D=Deposits
DD=Direct Debit - Disburse
EFT=Electronic Funds Transfer
F=Fee Expense
G=General Transaction
I=Interest Expense
M=Miscellaneous Transaction
MAN=Manual Check
P=Payment
R=Drafts
S=Stop Pay
TRW=Treasury Wire
U=Funding Receipt
V=Voided Payment
WIR=Wire - Disbursement
WRI=Wire - Incoming

7 RECON_TYPE_FLG Character(1) VARCHAR2(1) NOT NULL Indicates which method has been utilized to reconcile a given source system transaction.
A=Automatic
M=Manual
N=None
S=Semi Manual

8 BNK_ACTIVE_LIMIT Character(1) VARCHAR2(1) NOT NULL This field determines the type of tolerance on a transaction's amount
A=Amount
D=Date
N=None
P=Percent

9 BNK_LIMIT_HIGH_AMT Number(16,2) DECIMAL(15,2) NOT NULL This field contains the upper amount when added to a transaction amount that will still reconcile.

10 BNK_LIMIT_HIGH_DAY Number(3,0) SMALLINT NOT NULL Upper Day Limit

11 BNK_LIMIT_HIGH_PCT Number(8,2) DECIMAL(7,2) NOT NULL This field contains the high percent limit that when multiplied by the transaction amount and then added to the transaction amount will still allow the transaction to reconcile.

12 BNK_LIMIT_LOW_AMT Number(16,2) DECIMAL(15,2) NOT NULL This field contains the lower amount when subtracted from a transaction amount that will still reconcile.

13 BNK_LIMIT_LOW_DAY Number(3,0) SMALLINT NOT NULL Lower Day Limit

14 BNK_LIMIT_LOW_PCT Number(8,2) DECIMAL(7,2) NOT NULL This field contains the low percent limit that when multiplied by the transaction amount and then subtracted to the transaction amount will still allow the transaction to reconcile.

15 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
2	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
3	TRANSACTION_TBL	Character(18)	VARCHAR2(18) NOT NULL	Represents the database table(s) that contain system source transaction data for reconciliation pu
4	PRE_RECONCILE	Character(1)	VARCHAR2(1) NOT NULL	Allows the user to indicate whether the automated reconciliation process should apply a n
5	ENABLE_WF_SW	Character(1)	VARCHAR2(1) NOT NULL	Allows a user to enable workflow worklist processing for automated reconciliation purposes. Th F=Nofitication Framework N=No Workflow Y=Workflow
6	RECON_TRANS_CODE	Character(3)	VARCHAR2(3) NOT NULL	The PeopleSoft-specific bank transaction code ACH=Automated Clearing House B=Direct Debit BA=Bank Adjustments BOE=Bill of Exchange - Disburse BOO=Bill of Order - Disburse C=Trade Receipt CHK=Check D=Deposits DD=Direct Debit - Disburse EFT=Electronic Funds Transfer F=Fee Expense G=General Transaction I=Interest Expense M=Miscellaneous Transaction MAN=Manual Check P=Payment R=Drafts S=Stop Pay TRW=Treasury Wire U=Funding Receipt V=Voided Payment WIR=Wire - Disbursement WRI=Wire - Incoming
7	RECON_TYPE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Indicates which method has been utilized to reconcile a given source system transaction. A=Automatic M=Manual N=None S=Semi Manual
8	BNK_ACTIVE_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	This field determines the type of tolerance on a transaction's amount A=Amount D=Date N=None P=Percent
9	BNK_LIMIT_HIGH_AMT	Number(16,2)	DECIMAL(15,2) NOT NULL	This field contains the upper amount when added to a transaction amount that will still reconcile.
10	BNK_LIMIT_HIGH_DAY	Number(3,0)	SMALLINT NOT NULL	Upper Day Limit
11	BNK_LIMIT_HIGH_PCT	Number(8,2)	DECIMAL(7,2) NOT NULL	This field contains the high percent limit that when multiplied by the transaction amount and then added to the transaction amount will still allow the transaction to reconcile.
12	BNK_LIMIT_LOW_AMT	Number(16,2)	DECIMAL(15,2) NOT NULL	This field contains the lower amount when subtracted from a transaction amount that will still reconcile.
13	BNK_LIMIT_LOW_DAY	Number(3,0)	SMALLINT NOT NULL	Lower Day Limit
14	BNK_LIMIT_LOW_PCT	Number(8,2)	DECIMAL(7,2) NOT NULL	This field contains the low percent limit that when multiplied by the transaction amount and then subtracted to the transaction amount will still allow the transaction to reconcile.
15	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit