BANK_RCN_SFLT_V (SQL View)	Index Back
Statement Filter View

BANK_RCN_SFLT_V

(SQL View)

Statement Filter View

SELECT RECON_SOURCE , RULE_ID_RECON , RECNAME , SEQ_NUM , RCN_RECORD_TYPE , RCN_FIELD_ALIAS , DESCR254 , FIELD_VALUE_NBR , FIELD_VALUE_DATE , DATE_INCREMENT , RELATIVE_DATE , COMP_OPERATOR_RCN , OPEN_BRCKT , CLOSE_BRCKT , AND_OR_TXT , NODE_SQL FROM PS_BANK_RECON_FLTR WHERE RCN_RECORD_TYPE = '0'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RECON_SOURCE Character(2) VARCHAR2(2) NOT NULL Represents the source system table(s) for reconciling items.
00=Bank Statement
01=Receivables Deposits
02=Payables
03=Treasury
04=Receivables Drafts
05=External Transactions
06=Receivables Payments
07=Direct Debits

2 RULE_ID_RECON Character(20) VARCHAR2(20) NOT NULL Reconciliation Rules Id

3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
Prompt Table: RCN_STMT_REC_V

4 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

5 RCN_RECORD_TYPE Character(1) VARCHAR2(1) NOT NULL For reconciliation, this is either a transaction or a statement line
0=Statement
1=Transaction
2=Event Record
3=App Engine Temporary Record
4=Event Record
5=AE Temporary Table

6 RCN_FIELD_ALIAS Character(30) VARCHAR2(30) NOT NULL Reconciliation field/record alias name -- user or system defined
Prompt Table: RCN_FLD_ALIAS_V

7 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254

8 FIELD_VALUE_NBR Signed Number(28,3) DECIMAL(26,3) NOT NULL An accounting template field designated to support the substitution of desired monetary amounts during a

9 FIELD_VALUE_DATE Date(10) DATE An accounting template field designated to support the substitution of desired dates during accounting b

10 DATE_INCREMENT Signed Number(5,0) DECIMAL(4) NOT NULL An internal work field utilized for storing the number of adjustment days to be applied to a given node date during

11 RELATIVE_DATE Character(1) VARCHAR2(1) NOT NULL "Represents the number of days
Y/N Table Edit
Default Value: N

12 COMP_OPERATOR_RCN Character(2) VARCHAR2(2) NOT NULL Represents filter field comparison syntax for creating Bank Recon Rules - Fliter Criteria.
<=<
<==LTE
<>=Not Equal
==Equals
>=Greater
>==GTE
B=Begins With
C=Contains
E=Ends With
IN=In
NB=Not Begins
NC=Not Contain
NE=Not Ends
NI=Not In
NL=Is Null
NN=Is Not Null

13 OPEN_BRCKT Character(2) VARCHAR2(2) NOT NULL Represents SQL parentheses syntax for purposes of precedence when the user is creating node specific data
01=(
02=((
03=(((
04=((((

14 CLOSE_BRCKT Character(2) VARCHAR2(2) NOT NULL Represents SQL parentheses syntax for purposes of precedence when the user is creating node specific dat
01=)
02=))
03=)))
04=))))

15 AND_OR_TXT Character(3) VARCHAR2(3) NOT NULL Represents 'AND' or 'OR' SQL operator syntax when the user is creating node specific data selection criteria wi
AND=AND
OR=OR

16 NODE_SQL Character(254) VARCHAR2(254) NOT NULL Represents the field in which a user can enter specific SQL criteria in order to select and display position data.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RECON_SOURCE	Character(2)	VARCHAR2(2) NOT NULL	Represents the source system table(s) for reconciling items. 00=Bank Statement 01=Receivables Deposits 02=Payables 03=Treasury 04=Receivables Drafts 05=External Transactions 06=Receivables Payments 07=Direct Debits
2	RULE_ID_RECON	Character(20)	VARCHAR2(20) NOT NULL	Reconciliation Rules Id
3	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN). Prompt Table: RCN_STMT_REC_V
4	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
5	RCN_RECORD_TYPE	Character(1)	VARCHAR2(1) NOT NULL	For reconciliation, this is either a transaction or a statement line 0=Statement 1=Transaction 2=Event Record 3=App Engine Temporary Record 4=Event Record 5=AE Temporary Table
6	RCN_FIELD_ALIAS	Character(30)	VARCHAR2(30) NOT NULL	Reconciliation field/record alias name -- user or system defined Prompt Table: RCN_FLD_ALIAS_V
7	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
8	FIELD_VALUE_NBR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	An accounting template field designated to support the substitution of desired monetary amounts during a
9	FIELD_VALUE_DATE	Date(10)	DATE	An accounting template field designated to support the substitution of desired dates during accounting b
10	DATE_INCREMENT	Signed Number(5,0)	DECIMAL(4) NOT NULL	An internal work field utilized for storing the number of adjustment days to be applied to a given node date during
11	RELATIVE_DATE	Character(1)	VARCHAR2(1) NOT NULL	"Represents the number of days Y/N Table Edit Default Value: N
12	COMP_OPERATOR_RCN	Character(2)	VARCHAR2(2) NOT NULL	Represents filter field comparison syntax for creating Bank Recon Rules - Fliter Criteria. <=< <==LTE <>=Not Equal ==Equals >=Greater >==GTE B=Begins With C=Contains E=Ends With IN=In NB=Not Begins NC=Not Contain NE=Not Ends NI=Not In NL=Is Null NN=Is Not Null
13	OPEN_BRCKT	Character(2)	VARCHAR2(2) NOT NULL	Represents SQL parentheses syntax for purposes of precedence when the user is creating node specific data 01=( 02=(( 03=((( 04=((((
14	CLOSE_BRCKT	Character(2)	VARCHAR2(2) NOT NULL	Represents SQL parentheses syntax for purposes of precedence when the user is creating node specific dat 01=) 02=)) 03=))) 04=))))
15	AND_OR_TXT	Character(3)	VARCHAR2(3) NOT NULL	Represents 'AND' or 'OR' SQL operator syntax when the user is creating node specific data selection criteria wi AND=AND OR=OR
16	NODE_SQL	Character(254)	VARCHAR2(254) NOT NULL	Represents the field in which a user can enter specific SQL criteria in order to select and display position data.