CLOSE_RVSCF_TBL (SQL Table)	Index Back
Closing - Reversal Entry CFs Year End Close Reversal entries (Period 999) aggregation Chartfields.

CLOSE_RVSCF_TBL

(SQL Table)

Closing - Reversal Entry CFs

Year End Close Reversal entries (Period 999) aggregation Chartfields.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 CLOSING_SET Character(20) VARCHAR2(20) NOT NULL Closing Rule

3 VERSION_NUM Number(3,0) SMALLINT NOT NULL Version Number

4 EFFDT Date(10) DATE NOT NULL Effective Date

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

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

7 RETAIN_FIELD_VALUE Character(1) VARCHAR2(1) NOT NULL Retain field value flag - used in Closing Rule definition to tell the closing process to retain detail values of the field.
Y/N Table Edit
Default Value: Y

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	CLOSING_SET	Character(20)	VARCHAR2(20) NOT NULL	Closing Rule
3	VERSION_NUM	Number(3,0)	SMALLINT NOT NULL	Version Number
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date
5	FIELD_SEQUENCE	Number(3,0)	SMALLINT NOT NULL	Field Sequence Number
6	CHARTFIELD	Character(18)	VARCHAR2(18) NOT NULL	ChartField
7	RETAIN_FIELD_VALUE	Character(1)	VARCHAR2(1) NOT NULL	Retain field value flag - used in Closing Rule definition to tell the closing process to retain detail values of the field. Y/N Table Edit Default Value: Y