IU_PROC_002_AET (SQL Table)	Index Back
Inter Unit State Record Holds variables for processing Inter Unit

IU_PROC_002_AET

(SQL Table)

Inter Unit State Record

Holds variables for processing Inter Unit

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 SQL_TXN_GROUPING Character(254) VARCHAR2(254) NOT NULL Used by InterUnit Processor to hold transaction grouping fields, for dynamic SQL.

3 SQL_DOC_GROUPING Character(254) VARCHAR2(254) NOT NULL Used by InterUnit Processor to hold document grouping fields, for dynamic SQL.

4 IU_LINE_TYPE Character(1) VARCHAR2(1) NOT NULL 1 - original transactions 2 - original transactions aggregated 3 - InterUnit Anchor w/o base (primary ledger lines) 4 - secondary non-translation ledger lines 5 - secondary translation ledger lines 6 - used as holding area for iu line type '3' when processing multicurrency 7 - already allocated secondary ledger lines 8 - InterUnit Anchor w/ base, already allocated primary ledger lines 9 - InterUnit Non-anchor A - IntraUnit Anchor B - IntraUnit non-anchor N - New lines U - Unbalanced x,y,z - lowercase letters to ignore for addl processing, marked as deleted

5 IU_METHOD Character(1) VARCHAR2(1) NOT NULL InterUnit Method
D=Direct
I=Indirect
P=Pairs

6 DATETIME_STAMP DateTime(26) TIMESTAMP DateTime Stamp

7 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group

8 LEDGERS_SYNC Character(1) VARCHAR2(1) NOT NULL Keep Ledgers in Sync

9 SETID_LEDGER Character(5) VARCHAR2(5) NOT NULL Ledger Table Setid

10 DUMMY_FIELD Character(1) VARCHAR2(1) NOT NULL Dummy Field for Hiding Groups

11 IU_LEGAL_ENT_FLG Character(1) VARCHAR2(1) NOT NULL Use Legal Entity for InterUnit

12 WHERE_BU Character(254) VARCHAR2(254) NOT NULL WHERE CLAUSE

13 SQLROWS Number(5,0) INTEGER NOT NULL SQL Rows

14 SQLROWS_1 Number(9,0) DECIMAL(9) NOT NULL Used in AE

15 CF_STRING Character(254) VARCHAR2(254) NOT NULL CF String

16 IU_STATUS Character(2) VARCHAR2(2) NOT NULL Processing Status
0=Successful
1=Complete with errors
2=Not Complete

17 LINE_WRK_REC Character(15) VARCHAR2(15) NOT NULL Line Work Record

18 LINE_WRK2_REC Character(15) VARCHAR2(15) NOT NULL Line Work Record 2

19 IU_SUMMARIZATION Character(1) VARCHAR2(1) NOT NULL Controls whether or not a final summarization is performed on the balancing lines created by the InterUnit Processor.
D=Default to Installation Option
N=No Summarization
S=Summarize

20 INSERT_FLAG Character(1) VARCHAR2(1) NOT NULL insert flag

21 INSERT_FLAG2 Character(1) VARCHAR2(1) NOT NULL insert flag

22 SECOND_LEDGERS Character(1) VARCHAR2(1) NOT NULL Secondary Ledgers Exist

23 IU_LEGAL_ENT_BU Character(5) VARCHAR2(5) NOT NULL The business unit that represents the legal entity to which the GL Unit belongs. May have the same value as the GL Unit if it is its own legal entity.

24 IU_WHERE_SQL Long Character CLOB Where SQL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	SQL_TXN_GROUPING	Character(254)	VARCHAR2(254) NOT NULL	Used by InterUnit Processor to hold transaction grouping fields, for dynamic SQL.
3	SQL_DOC_GROUPING	Character(254)	VARCHAR2(254) NOT NULL	Used by InterUnit Processor to hold document grouping fields, for dynamic SQL.
4	IU_LINE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	1 - original transactions 2 - original transactions aggregated 3 - InterUnit Anchor w/o base (primary ledger lines) 4 - secondary non-translation ledger lines 5 - secondary translation ledger lines 6 - used as holding area for iu line type '3' when processing multicurrency 7 - already allocated secondary ledger lines 8 - InterUnit Anchor w/ base, already allocated primary ledger lines 9 - InterUnit Non-anchor A - IntraUnit Anchor B - IntraUnit non-anchor N - New lines U - Unbalanced x,y,z - lowercase letters to ignore for addl processing, marked as deleted
5	IU_METHOD	Character(1)	VARCHAR2(1) NOT NULL	InterUnit Method D=Direct I=Indirect P=Pairs
6	DATETIME_STAMP	DateTime(26)	TIMESTAMP	DateTime Stamp
7	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
8	LEDGERS_SYNC	Character(1)	VARCHAR2(1) NOT NULL	Keep Ledgers in Sync
9	SETID_LEDGER	Character(5)	VARCHAR2(5) NOT NULL	Ledger Table Setid
10	DUMMY_FIELD	Character(1)	VARCHAR2(1) NOT NULL	Dummy Field for Hiding Groups
11	IU_LEGAL_ENT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Use Legal Entity for InterUnit
12	WHERE_BU	Character(254)	VARCHAR2(254) NOT NULL	WHERE CLAUSE
13	SQLROWS	Number(5,0)	INTEGER NOT NULL	SQL Rows
14	SQLROWS_1	Number(9,0)	DECIMAL(9) NOT NULL	Used in AE
15	CF_STRING	Character(254)	VARCHAR2(254) NOT NULL	CF String
16	IU_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Processing Status 0=Successful 1=Complete with errors 2=Not Complete
17	LINE_WRK_REC	Character(15)	VARCHAR2(15) NOT NULL	Line Work Record
18	LINE_WRK2_REC	Character(15)	VARCHAR2(15) NOT NULL	Line Work Record 2
19	IU_SUMMARIZATION	Character(1)	VARCHAR2(1) NOT NULL	Controls whether or not a final summarization is performed on the balancing lines created by the InterUnit Processor. D=Default to Installation Option N=No Summarization S=Summarize
20	INSERT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	insert flag
21	INSERT_FLAG2	Character(1)	VARCHAR2(1) NOT NULL	insert flag
22	SECOND_LEDGERS	Character(1)	VARCHAR2(1) NOT NULL	Secondary Ledgers Exist
23	IU_LEGAL_ENT_BU	Character(5)	VARCHAR2(5) NOT NULL	The business unit that represents the legal entity to which the GL Unit belongs. May have the same value as the GL Unit if it is its own legal entity.
24	IU_WHERE_SQL	Long Character	CLOB	Where SQL