RCN_FLD_MTCH2_V (SQL View)	Index Back
Recon alias prompt This record is used in Reconciliation to define the type of columns that will be used in the reconciliation.

RCN_FLD_MTCH2_V

(SQL View)

Recon alias prompt

This record is used in Reconciliation to define the type of columns that will be used in the reconciliation.

SELECT RECNAME , RCN_FIELD_ALIAS , FIELDNAME FROM PS_RCN_FIELD_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RECNAME_RECON2 Character(15) VARCHAR2(15) NOT NULL Source 2 Record
Prompt Table: RCN_REC_ALIAS_V

2 RCN_FIELD_ALIAS Character(30) VARCHAR2(30) NOT NULL Reconciliation field/record alias name -- user or system defined

3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RECNAME_RECON2	Character(15)	VARCHAR2(15) NOT NULL	Source 2 Record Prompt Table: RCN_REC_ALIAS_V
2	RCN_FIELD_ALIAS	Character(30)	VARCHAR2(30) NOT NULL	Reconciliation field/record alias name -- user or system defined
3	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).