CON_EQTY_ALT (SQL Table)	Index Back
Consolidation Equity Amounts

CON_EQTY_ALT

(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 ALTSUM Character(10) VARCHAR2(10) NOT NULL Alternate Account Summary

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

5 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	ALTSUM	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account Summary
4	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
5	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.