CON_EQTY_ACTDEP (SQL Table)	Index Back
Consolidation Equity Amounts

CON_EQTY_ACTDEP

(SQL Table)

Consolidation Equity Amounts

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 SUB_ENTITY Character(30) VARCHAR2(30) NOT NULL Subsidiary Entity

3 ACCT Character(20) VARCHAR2(20) NOT NULL Account Node

4 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

6 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	SUB_ENTITY	Character(30)	VARCHAR2(30) NOT NULL	Subsidiary Entity
3	ACCT	Character(20)	VARCHAR2(20) NOT NULL	Account Node
4	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
5	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
6	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.