EXT_SYSTEM_IDPrompt Table: SP_SETID_NONVW
Prompt Table:
JRNLGEN_APPL_ID
Set Control Field: SETID_APPL_ID
Y/N Table Edit
Y/N Table Edit
Y/N Table Edit
Default Value: 1
Prompt Table: PSURLDEFN
N=No
Y=Yes
Default Value: N
FAI_EXTSYS_TBL(SQL Table) |
Index Back |
|---|---|
External System Definition |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EXT_SYSTEM_ID |
Character(10) | VARCHAR2(10) NOT NULL | External System ID |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | SETID_APPL_ID | Character(5) | VARCHAR2(5) NOT NULL |
Journal Template SETID
Prompt Table: SP_SETID_NONVW |
| 4 | APPL_JRNL_ID | Character(10) | VARCHAR2(10) NOT NULL |
Journal Template
Prompt Table:
JRNLGEN_APPL_ID
|
| 5 | COMBO_EDIT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Edit Combinations
Y/N Table Edit |
| 6 | CF_MCHG_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Enable Chartfield Mass Change
Y/N Table Edit |
| 7 | PROCESS_IU_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Create Inter/IntraUnit Entries
Y/N Table Edit |
| 8 | LAST_SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL |
Last Sequence number in list
Default Value: 1 |
| 9 | URL_ID | Character(30) | VARCHAR2(30) NOT NULL |
URL Identifier (see PSURLDEFN).
Prompt Table: PSURLDEFN |
| 10 | USERID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 11 | PASSWORD | Character(254) | VARCHAR2(254) NOT NULL | Password |
| 12 | UCM_URL | Character(254) | VARCHAR2(254) NOT NULL | UCM URL |
| 13 | FAI_ENABLE_EXT_SRC | Character(1) | VARCHAR2(1) NOT NULL |
Enable Journal Source
N=No Y=Yes Default Value: N |