CLOSE_DEFN_TBL

#	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	VERSION_NUM	Number(3,0)	SMALLINT NOT NULL	Version Number Default Value: 0
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
5	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
6	CLOSING_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Closing Type I=Interim Y=Year End
7	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
8	LEDGER_TEMPLATE	Character(10)	VARCHAR2(10) NOT NULL	Ledger Template Default Value: STANDARD Prompt Table: LED_TMPLT_D_VW
9	FIELDNAME_ACCOUNT	Character(18)	VARCHAR2(18) NOT NULL	Account Default Value: ACCOUNT
10	CLOSING_SCOPE	Character(1)	VARCHAR2(1) NOT NULL	Closing Scope C=Incremental Current Period I=Incremental Year to Date Y=Incremental Year to Curr Per Default Value: I
11	MULTIPLE_RET_EARN	Character(1)	VARCHAR2(1) NOT NULL	Close To Multiple Ret Earnings Y/N Table Edit Default Value: N
12	JOURNAL_ID_MASK	Character(6)	VARCHAR2(6) NOT NULL	Journal ID Mask Default Value: NEXT
13	DESCR1	Character(30)	VARCHAR2(30) NOT NULL	Descr
14	SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Identifies the origin of a journal entry and defines journal entry error handling options. The journal source provides a means of selectively tracking, reporting, and inquiring on journal entries. It can be almost anything within the enterprise - a subsystem that generates transactions, a department, or even an individual. Prompt Table: SOURCE_TBL
15	CREATE_JRNL_ENTRY	Character(1)	VARCHAR2(1) NOT NULL	Create Journal Entries Y/N Table Edit Default Value: Y
16	JRNL_EDIT_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Edit Journal(s) Y/N Table Edit Default Value: N
17	JRNL_BGTCHK_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Journal Budget Check option. Used in Journal Edit request or other GL processes (e.g. Allocations, Closing, Revaluation, ...) to flag if journals will be budget checked after they are edited valid. Y/N Table Edit Default Value: N
18	JRNL_POST_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Post Journal(s) Y/N Table Edit Default Value: N
19	STORE_PL_REVERSAL	Character(1)	VARCHAR2(1) NOT NULL	Store P/L Reversal Entries Y/N Table Edit Default Value: Y
20	CLOSE_OPEN_PERIODS	Character(1)	VARCHAR2(1) NOT NULL	Close the G/L Open Periods Y/N Table Edit Default Value: N
21	CLOSE_ADJ_PERIODS	Character(1)	VARCHAR2(1) NOT NULL	Close Adjustment Periods Y/N Table Edit Default Value: N
22	DONT_FWD_ZERO_BAL	Character(1)	VARCHAR2(1) NOT NULL	Do Not Roll Forward Zero Bal Y/N Table Edit Default Value: Y
23	INIT_DRCR_AT_NET	Character(1)	VARCHAR2(1) NOT NULL	Initialize DR/CR with Net Bal Y/N Table Edit Default Value: N
24	CLS_DRCR_AT_NET	Character(1)	VARCHAR2(1) NOT NULL	Close DR/CR with Net Balance Y/N Table Edit Default Value: N
25	ROLL_FWD_PL_OPTION	Character(1)	VARCHAR2(1) NOT NULL	P/L to Roll Forward to Next Yr 0=Roll Forward All 1 Year 1=Partial RollForward 1 Year A=Roll Forward All Cumulative N=Do Not Roll Forward P=Partial RollForward Cumulative Default Value: N
26	ROLL_FWD_ENC_AMT	Character(1)	VARCHAR2(1) NOT NULL	Roll Forward Encumbrance Amt Y/N Table Edit Default Value: N
27	ROLL_FWD_PRENC_AMT	Character(1)	VARCHAR2(1) NOT NULL	Roll Forward Pre-Encumbr Amt Y/N Table Edit Default Value: N
28	RETAIN_ALL_SW	Character(1)	VARCHAR2(1) NOT NULL	Closing Offset Options 0=Retain All CF Value for Offset 1=Autofill Offset from first row 2=Fill Individual Offset Default Value: 2
29	DOC_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code. Prompt Table: DOC_TYPE_TBL
30	DOC_TYPE_OPEN_BAL	Character(8)	VARCHAR2(8) NOT NULL	Document type for openning balance journals created by year end close. Refer to DOC_TYPE for general use of Document type. Prompt Table: DOC_TYPE_TBL
31	CLOSE_TO_CURR_SW	Character(1)	VARCHAR2(1) NOT NULL	Yes/No flag : close to a target currency or to whatever the transaction currency was. Y/N Table Edit
32	CLOSE_CURR_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Target Currency options for closing process. B=Business Unit Base Currency N=Retain currency P=Base currency of Prim Ledger S=Specify Target Currency Default Value: B
33	TARGET_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Target Currency Prompt Table: CLO_TGTCUR_VW
34	CLO_JRNL_DT_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Closing Journal Date Option P=Use Process Date R=Retain Transaction Date Default Value: R
35	DEFAULT_RE_OPTN	Character(1)	VARCHAR2(1) NOT NULL	When = 'Y', all the income statement accounts left over (not included in the Net Income/Retained Earnings page) will be closed to a default Retained Earnings account Y/N Table Edit Default Value: Y
36	JRNL_BY_GRP_OPTN	Character(1)	VARCHAR2(1) NOT NULL	When on, create journal by close groups. Y/N Table Edit Default Value: N
37	PROCESS_BY	Character(1)	VARCHAR2(1) NOT NULL	Process by ACCOUNT when '1', process by ALTACCT when '2'. 1=ACCOUNT 2=ALTACCT Default Value: 1
38	DEPLOYED	Character(1)	VARCHAR2(1) NOT NULL	Identify whether an element has been deployed or not. N=No Y=Yes Y/N Table Edit Default Value: N