CONS_CAL_ACCTS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	REQUEST_NBR	Number(4,0)	SMALLINT NOT NULL	Request Number
3	SEQUENCE_NBR_6	Number(6,0)	INTEGER NOT NULL	Sequence
4	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
5	CONSOLIDATION_SET	Character(10)	VARCHAR2(10) NOT NULL	Consolidation Set
6	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
7	TREE_NODE	Character(20)	VARCHAR2(20) NOT NULL	Node name
8	CONSOL_ENTITY	Character(30)	VARCHAR2(30) NOT NULL	Consolidation Entity
9	SET_IDENTIFIER	Character(10)	VARCHAR2(10) NOT NULL	Set Name Identifier
10	AS_OF_DATE	Date(10)	DATE	As of Date
11	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
12	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
13	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
14	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
15	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
16	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
17	ACCOUNTING_PERIOD	Number(3,0)	SMALLINT NOT NULL	Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
18	LOG_ENTRY_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Type of Log Entry A=Majority Parent Adjustment E=Elimination I=Minority Parent Adjustment M=Majority Parent Elimination
19	POSTED_TOTAL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the net balance of debit and credit amounts that have been posted to a particular ChartField combination.