KK_CLOSE_DEFN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	CLOSING_SET	Character(20)	VARCHAR2(20) NOT NULL	Closing Rule
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group Prompt Table: SP_LGRPKK_NONVW Set Control Field: SETID
7	LEDGER_TEMPLATE	Character(10)	VARCHAR2(10) NOT NULL	Ledger Template
8	KK_BAL_FWD_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Balance Forward Option 0=Close Out Only 2=Close Out and Bal Roll Forward Default Value: 2
9	DONT_FWD_IF_EXPIRE	Character(1)	VARCHAR2(1) NOT NULL	Don't Roll Forward If Expired Y/N Table Edit Default Value: Y
10	FWD_BUDGET_OVER_SW	Character(1)	VARCHAR2(1) NOT NULL	During Budget Closing, this option allows user to specify whether to roll forward the remaining budget if the budget is over expensed. If the option is 'Yes', the rolling forward will in effect reduce the budget of the new budget period. Y/N Table Edit Default Value: N
11	JOURNAL_ID_MASK	Character(6)	VARCHAR2(6) NOT NULL	Journal ID Mask Default Value: NEXT
12	ENTRY_EVENT	Character(10)	VARCHAR2(10) NOT NULL	Entry Event Prompt Table: EE_BUD_CODES_VW
13	ALL_VALUES	Character(1)	VARCHAR2(1) NOT NULL	Tree Level All Values flag N=No Y=Yes Y/N Table Edit Default Value: N
14	GENERATE_OFFSET_SW	Character(1)	VARCHAR2(1) NOT NULL	Generate Offset Entries Y/N Table Edit Default Value: Y
15	USE_DEF_OFFST_S_SW	Character(1)	VARCHAR2(1) NOT NULL	Use Budget Type Offset Account Y/N Table Edit Default Value: Y
16	USE_DEF_OFFST_T_SW	Character(1)	VARCHAR2(1) NOT NULL	Use Budget Type Offset Account Y/N Table Edit Default Value: Y
17	CHECK_DUPLICATES	Character(1)	VARCHAR2(1) NOT NULL	Check Duplicates
18	DESCRLONG	Long Character	CLOB	Long Description