RECFLD_ACCT_VW (SQL View)	Index Back
View of Flds for OpenItem Rec

RECFLD_ACCT_VW

(SQL View)

View of Flds for OpenItem Rec

select recname, fieldname from PSRECFIELD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPEN_ITEM_EDIT_REC Character(15) VARCHAR2(15) NOT NULL Specifies the name of the prompt table you want to use to validate the OpenItem search key, and applies only to OpenItem accounts in the general ledger.

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPEN_ITEM_EDIT_REC	Character(15)	VARCHAR2(15) NOT NULL	Specifies the name of the prompt table you want to use to validate the OpenItem search key, and applies only to OpenItem accounts in the general ledger.
2	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).