# |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
1 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
2 |
STATE_RECORD |
Character(15) |
VARCHAR2(15) NOT NULL |
State Record
|
3 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
4 |
RECNAME_CURR_LOG |
Character(15) |
VARCHAR2(15) NOT NULL |
MultiCurrency Log
|
5 |
RECNAME_CURR_WRK |
Character(15) |
VARCHAR2(15) NOT NULL |
MultiCurrency Tmp
|
6 |
RECNAME_CUR_WRK1 |
Character(15) |
VARCHAR2(15) NOT NULL |
MultiCurrency Tmp1
|
7 |
RECNAME_JRNL_HDR |
Character(15) |
VARCHAR2(15) NOT NULL |
Journal Header
|
8 |
RECNAME_JRNL_LN |
Character(15) |
VARCHAR2(15) NOT NULL |
Journal Line
|
9 |
RECNAME_LGLED_TMP |
Character(15) |
VARCHAR2(15) NOT NULL |
Temp table holding Ledger Group/Ledger values
|
10 |
RECNAME_RATE_TMP |
Character(15) |
VARCHAR2(15) NOT NULL |
Temp table holding Ledger Group/Ledger values
|
11 |
RECNAME_SUBTYP_TMP |
Character(15) |
VARCHAR2(15) NOT NULL |
Temp table holding KK SubType values
|
12 |
RECNAME_TREESEL |
Character(15) |
VARCHAR2(15) NOT NULL |
Tree Selector Record Name
|
13 |
RECNAME_TMP |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name
|
14 |
RECNAME_INSTALL |
Character(15) |
VARCHAR2(15) NOT NULL |
Installation Table name
|
15 |
RECNAME_ACCOUNT |
Character(15) |
VARCHAR2(15) NOT NULL |
Account ChartField
|