INSTALLATION_GL

(SQL Table)
Index Back

GL Installation Options

General Ledger Installation Options

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 APPROVAL_METHOD Character(1) VARCHAR2(1) NOT NULL Approval Method
A=Approval Framework
V=Virtual Approver

Default Value: V

2 APPR_IU_OPT Character(1) VARCHAR2(1) NOT NULL Approve IU Journal Option

Y/N Table Edit

Default Value: N

3 JRNL_DEL_METHOD Character(1) VARCHAR2(1) NOT NULL Journal Delete Method
L=Logical Delete
P=Physical Delete

Default Value: P

4 SERVERNAME Character(8) VARCHAR2(8) NOT NULL Server Name

Prompt Table: PYCYCL_SERVERS

5 SLEEPTIME Number(4,0) SMALLINT NOT NULL Sleep Time

Default Value: 10

6 JRNL_SOURCE Character(1) VARCHAR2(1) NOT NULL Validate Journal Source
7 GEN_IU_OPT Character(1) VARCHAR2(1) NOT NULL Generate IU Lines Option

Y/N Table Edit

Default Value: N

8 SKIP_IU_OPT Character(1) VARCHAR2(1) NOT NULL Bypass IU Option

Y/N Table Edit

Default Value: N

9 SYSTEM_ID Number(18,0) DECIMAL(18) NOT NULL Peoplesoft System ID

Default Value: 0

10 TRANSFER_ID Number(18,0) DECIMAL(18) NOT NULL Transfer ID

Default Value: 1

11 YTP_BALANCE Character(1) VARCHAR2(1) NOT NULL YTP Balance

Default Value: N

12 RUN_ONLINE_MODE Character(1) VARCHAR2(1) NOT NULL Process run in online mode or not

Y/N Table Edit

Default Value: N

13 BO_REQ_ID_ASSIGN Number(10,0) DECIMAL(10) NOT NULL Financial Structure Request ID - Auto Assigned
14 GL_AUTO_POST Character(1) VARCHAR2(1) NOT NULL Auto Post for Fluid Approval

Y/N Table Edit

Default Value: N

15 GL_JRNL_DEL_AUTH Character(1) VARCHAR2(1) NOT NULL Authorize Delete Journals

Y/N Table Edit

Default Value: N