RUN_GL_BAL2

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Prompt Table: OPRID_VW
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger Prompt Table: SP_BULEDD_NONVW
5	LEDGER_CODE	Character(10)	VARCHAR2(10) NOT NULL	Ledger Code Prompt Table: LEDGER_CODE_TBL
6	BAL_SHEET_IND	Character(2)	VARCHAR2(2) NOT NULL	Balance Sheet Indicator BS=Balance Sheet OB=Off Balance Sheet
7	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
8	PERIOD_FROM	Number(3,0)	SMALLINT NOT NULL	From Period
9	PERIOD_TO	Number(3,0)	SMALLINT NOT NULL	To Period
10	CURRENCY_OPTION2	Character(1)	VARCHAR2(1) NOT NULL	Currency Option B=Base F=All Frgn S=Selected Frgn Default Value: B
11	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
12	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD). Prompt Table: STAT_RPT_LBL_VW
13	ACCT_FR	Character(10)	VARCHAR2(10) NOT NULL	From Prompt Table: %EDITTABLE
14	ACCT_TO	Character(10)	VARCHAR2(10) NOT NULL	To Prompt Table: %EDITTABLE
15	DISPLAY_26_DIGITS	Character(1)	VARCHAR2(1) NOT NULL	Display Full Numeric Field N=No Y=Yes Default Value: N
16	TEXT_LABEL	Character(1)	VARCHAR2(1) NOT NULL	Text Label
17	ADJ_PER_FROM	Number(3,0)	SMALLINT NOT NULL	Adjustment Period From
18	ADJ_PER_TO	Number(3,0)	SMALLINT NOT NULL	Adjustment Period To
19	SUB_TOTAL_OPT1	Number(1,0)	SMALLINT NOT NULL	Subtotalling Option 1
20	SUB_TOTAL_OPT2	Number(1,0)	SMALLINT NOT NULL	Subtotalling Option 2
21	SHOW_NET_INCOME	Character(1)	VARCHAR2(1) NOT NULL	Show Net Income Y/N Table Edit Default Value: N