INSTALLATION_GL(SQL Table) |
Index Back |
---|---|
GL Installation OptionsGeneral 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 |