RECFLD_SLED_VW (SQL View)	Index Back
PSRECFIELD for Summary Ledgers This view shows the fields from the summary ledger record.

RECFLD_SLED_VW

(SQL View)

PSRECFIELD for Summary Ledgers

This view shows the fields from the summary ledger record.

select recname ,fieldnum ,fieldname from PSRECFIELD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RECNAME_PS Character(15) VARCHAR2(15) NOT NULL PS Record Name

2 FIELD_SEQUENCE Number(3,0) SMALLINT NOT NULL Field Sequence Number

3 CHARTFIELD Character(18) VARCHAR2(18) NOT NULL ChartField

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RECNAME_PS	Character(15)	VARCHAR2(15) NOT NULL	PS Record Name
2	FIELD_SEQUENCE	Number(3,0)	SMALLINT NOT NULL	Field Sequence Number
3	CHARTFIELD	Character(18)	VARCHAR2(18) NOT NULL	ChartField