CLO_ABG_TMP001 (SQL Table)	Index Back
Temp table to use in closing Account Balance Group temp table - non-shared.

CLO_ABG_TMP001

(SQL Table)

Temp table to use in closing

Account Balance Group temp table - non-shared.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 CF_GROUP_NBR Number(3,0) SMALLINT NOT NULL ChartField Value Group Number

3 BOOK_CODE Character(4) VARCHAR2(4) NOT NULL Book Code

4 BAL_SHEET_IND Character(2) VARCHAR2(2) NOT NULL Balance Sheet Indicator
BS=Balance Sheet
OB=Off Balance Sheet

5 BOOK_CODE_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Allow specifying of the Book Code value that is different from the default value as defined in the GL Account table.

6 BK_CODE Character(4) VARCHAR2(4) NOT NULL Book Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	CF_GROUP_NBR	Number(3,0)	SMALLINT NOT NULL	ChartField Value Group Number
3	BOOK_CODE	Character(4)	VARCHAR2(4) NOT NULL	Book Code
4	BAL_SHEET_IND	Character(2)	VARCHAR2(2) NOT NULL	Balance Sheet Indicator BS=Balance Sheet OB=Off Balance Sheet
5	BOOK_CODE_OVERRIDE	Character(1)	VARCHAR2(1) NOT NULL	Allow specifying of the Book Code value that is different from the default value as defined in the GL Account table.
6	BK_CODE	Character(4)	VARCHAR2(4) NOT NULL	Book Code