GL_PRD_COPY_AET

(SQL Table)
Index Back

Copy Period-End Cutoff

Copy Period-End Cutoff Schedule for Journal Source Security

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: BU_GL_UPDATE_VW

3 SETID Character(5) VARCHAR2(5) NOT NULL SetID
4 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group

Prompt Table: SP_LGNOKK_NONVW

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

Prompt Table: LED_GRP_LED_TBL

6 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year

Prompt Table: GL_FISCAL_YR_VW

7 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID
8 BUSINESS_UNIT2 Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: BU_GL_UPDATE_VW

9 BUS_UNIT_GL_FROM Character(5) VARCHAR2(5) NOT NULL From Business Unit GL

Prompt Table: BU_GL_UPDATE_VW

10 BUS_UNIT_GL_TO Character(5) VARCHAR2(5) NOT NULL To Business Unit GL

Prompt Table: BU_GL_UPDATE_VW

11 LEDGER_GROUP_2 Character(10) VARCHAR2(10) NOT NULL Ledger Group

Prompt Table: SP_LGNOKK_NONVW

12 FISCAL_YEAR2 Number(4,0) SMALLINT NOT NULL Fiscal Year

Prompt Table: GL_FISCAL_YR_VW

13 LEDGER_2 Character(10) VARCHAR2(10) NOT NULL Ledger

Prompt Table: LED_GRP_LED_TBL

14 GL_PRD_END_COPY Character(1) VARCHAR2(1) NOT NULL Copy Period End Cutoff
C=All
R=By Business Unit Range
15 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
16 GL_MASS_COPY Character(1) VARCHAR2(1) NOT NULL Period End Cutoff Mass Copy
17 GLSEC_SRC_HOLIDAY Character(1) VARCHAR2(1) NOT NULL Period End Cutoff Holiday Option
N=Next Work Day
P=Prev. Work Day
S=Same Day
18 GLSEC_SRC_HOL_CAL Character(1) VARCHAR2(1) NOT NULL Period End Cutoff Holiday Calendar
19 LEDGER_IN_SYNC_CHK Character(1) VARCHAR2(1) NOT NULL Ledger In Sync Check
20 PROCESS_ORIG Character(1) VARCHAR2(1) NOT NULL Process Origin
N=Other Source
P=Process Scheduler
21 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
22 GL_MASS_PND_CUTOFF Signed Number(4,0) DECIMAL(3) NOT NULL Period End Cutoff Mass Update
23 GL_CAL_PERIOD Character(2) VARCHAR2(2) NOT NULL Calendar Period for Journal Source Security
1=Period 1
24 GL_MASS_UPD_PERIOD Character(1) VARCHAR2(1) NOT NULL Mass Update Periods in Period End Cutoff
25 END_DATE Date(10) DATE End Date