GL_JSRC_PND_CUT

(SQL Table)
Index Back

Period-End Cutoff Schedule

Period-End Cutoff Schedule for Journal Source Security

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: BU_GL_UPDATE_VW

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

Prompt Table: SP_LGNOKK_NONVW

3 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger

Prompt Table: SP_LEDG_S_NONVW

4 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
5 SETID Character(5) VARCHAR2(5) NOT NULL SetID
6 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID
7 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.
8 GLSEC_CUTOFF Signed Number(4,0) DECIMAL(3) NOT NULL Period End Cutoff Days

Default Value: 0

9 END_DATE_01 Date(10) DATE End Date
10 END_DATE_02 Date(10) DATE End Date
11 END_DATE_03 Date(10) DATE End Date
12 END_DATE_04 Date(10) DATE End Date
13 END_DATE_05 Date(10) DATE End Date
14 END_DATE_06 Date(10) DATE End Date
15 END_DATE_07 Date(10) DATE End Date
16 END_DATE_08 Date(10) DATE End Date
17 END_DATE_09 Date(10) DATE End Date
18 END_DATE_10 Date(10) DATE End Date
19 END_DATE_11 Date(10) DATE End Date
20 END_DATE_12 Date(10) DATE End Date
21 END_DATE_13 Date(10) DATE End Date
22 GL_JSRC_END_DATE1 Date(10) DATE End Date
23 GL_JSRC_END_DATE2 Date(10) DATE End Date
24 GL_JSRC_END_DATE3 Date(10) DATE End Date
25 GL_JSRC_END_DATE4 Date(10) DATE End Date
26 GL_JSRC_END_DATE5 Date(10) DATE End Date
27 GL_JSRC_END_DATE6 Date(10) DATE End Date
28 GL_JSRC_END_DATE7 Date(10) DATE End Date
29 GL_JSRC_END_DATE8 Date(10) DATE End Date
30 GL_JSRC_END_DATE9 Date(10) DATE End Date
31 GL_JSRC_END_DATE10 Date(10) DATE End Date
32 GL_JSRC_END_DATE11 Date(10) DATE End Date
33 GL_JSRC_END_DATE12 Date(10) DATE End Date
34 GL_JSRC_END_DATE13 Date(10) DATE End Date