RSF_ACC_FLAT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	TERRITORY_PARENT	Character(20)	VARCHAR2(20) NOT NULL	Territory Parent
4	TERRITORY_ID	Character(20)	VARCHAR2(20) NOT NULL	Territory ID
5	PERSON_ID_MANAGER	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts
6	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
7	NAME_PARENT	Character(50)	VARCHAR2(50) NOT NULL	Name
8	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
9	TREE_NODE_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Internal beginning node range number
10	TREE_LEVEL_NUM	Number(3,0)	SMALLINT NOT NULL	Parent tree level if this is a part of the PSTREEBRANCH record
11	PARENT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Parent Flag
12	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
13	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
14	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time