CONS_CAL_ACTDIV

(SQL Table)
Index Back

Consolidations Calc Log

# 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_SUM Character(20) VARCHAR2(20) NOT NULL Summary Account Node
14 DEPTID_SUM Character(20) VARCHAR2(20) NOT NULL Summary Department Node
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.