| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
SYSTEM_ID |
Number(18,0) |
DECIMAL(18) NOT NULL |
Peoplesoft System ID
|
| 3 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 4 |
JOURNAL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.
|
| 5 |
JOURNAL_DATE |
Date(10) |
DATE |
Specifies the date the journal was created.
|
| 6 |
UNPOST_SEQ |
Number(2,0) |
SMALLINT NOT NULL |
Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1".
|
| 7 |
JOURNAL_LINE |
Number(9,0) |
DECIMAL(9) NOT NULL |
Uniquely identifies a journal line with a sequence number. Within a single journal entry, the line sequence begins with 1 and automatically increments by 1 for each succeeding journal line. There can be any number of lines associated with a journal header.
|
| 8 |
LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger
|
| 9 |
SEQ_NO |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 10 |
TRANSFER_ID |
Number(18,0) |
DECIMAL(18) NOT NULL |
Transfer ID
|
| 11 |
REFERENCE21 |
Character(240) |
VARCHAR2(240) NOT NULL |
Reference21
|
| 12 |
ACCOUNTING_DATE |
Date(10) |
DATE |
ACCOUNTING_DATE
|
| 13 |
REFERENCE22 |
Character(240) |
VARCHAR2(240) NOT NULL |
Reference22
|
| 14 |
REFERENCE23 |
Character(240) |
VARCHAR2(240) NOT NULL |
Reference23
|
| 15 |
REFERENCE24 |
Character(240) |
VARCHAR2(240) NOT NULL |
Reference24
|
| 16 |
REFERENCE25 |
Character(240) |
VARCHAR2(240) NOT NULL |
Reference25
|
| 17 |
REFERENCE26 |
Character(240) |
VARCHAR2(240) NOT NULL |
Reference26
|
| 18 |
SEGMENT1 |
Character(25) |
VARCHAR2(25) NOT NULL |
SEGMENT1
|
| 19 |
SEGMENT2 |
Character(25) |
VARCHAR2(25) NOT NULL |
SEGMENT2
|
| 20 |
SEGMENT3 |
Character(25) |
VARCHAR2(25) NOT NULL |
SEGMENT3
|
| 21 |
SEGMENT4 |
Character(25) |
VARCHAR2(25) NOT NULL |
SEGMENT4
|
| 22 |
SEGMENT5 |
Character(25) |
VARCHAR2(25) NOT NULL |
SEGMENT5
|
| 23 |
SEGMENT6 |
Character(25) |
VARCHAR2(25) NOT NULL |
SEGMENT6
|
| 24 |
SEGMENT7 |
Character(25) |
VARCHAR2(25) NOT NULL |
SEGMENT7
|
| 25 |
SEGMENT8 |
Character(25) |
VARCHAR2(25) NOT NULL |
SEGMENT8
|
| 26 |
SEGMENT9 |
Character(25) |
VARCHAR2(25) NOT NULL |
SEGMENT9
|
| 27 |
SEGMENT10 |
Character(25) |
VARCHAR2(25) NOT NULL |
SEGMENT10
|
| 28 |
SEGMENT11 |
Character(25) |
VARCHAR2(25) NOT NULL |
SEGMENT11
|
| 29 |
SEGMENT12 |
Character(25) |
VARCHAR2(25) NOT NULL |
SEGMENT12
|
| 30 |
SEGMENT13 |
Character(25) |
VARCHAR2(25) NOT NULL |
SEGMENT13
|
| 31 |
SEGMENT14 |
Character(25) |
VARCHAR2(25) NOT NULL |
SEGMENT14
|
| 32 |
SEGMENT15 |
Character(25) |
VARCHAR2(25) NOT NULL |
SEGMENT15
|
| 33 |
SEGMENT16 |
Character(25) |
VARCHAR2(25) NOT NULL |
SEGMENT16
|
| 34 |
SEGMENT17 |
Character(25) |
VARCHAR2(25) NOT NULL |
SEGMENT17
|
| 35 |
SEGMENT18 |
Character(25) |
VARCHAR2(25) NOT NULL |
SEGMENT18
|
| 36 |
SEGMENT19 |
Character(25) |
VARCHAR2(25) NOT NULL |
SEGMENT19
|
| 37 |
SEGMENT20 |
Character(25) |
VARCHAR2(25) NOT NULL |
SEGMENT20
|
| 38 |
SEGMENT21 |
Character(25) |
VARCHAR2(25) NOT NULL |
SEGMENT21
|
| 39 |
SEGMENT22 |
Character(25) |
VARCHAR2(25) NOT NULL |
SEGMENT22
|
| 40 |
SEGMENT23 |
Character(25) |
VARCHAR2(25) NOT NULL |
SEGMENT23
|
| 41 |
SEGMENT24 |
Character(25) |
VARCHAR2(25) NOT NULL |
SEGMENT24
|
| 42 |
SEGMENT25 |
Character(25) |
VARCHAR2(25) NOT NULL |
SEGMENT25
|
| 43 |
SEGMENT26 |
Character(25) |
VARCHAR2(25) NOT NULL |
SEGMENT26
|
| 44 |
SEGMENT27 |
Character(25) |
VARCHAR2(25) NOT NULL |
SEGMENT27
|
| 45 |
SEGMENT28 |
Character(25) |
VARCHAR2(25) NOT NULL |
SEGMENT28
|
| 46 |
SEGMENT29 |
Character(25) |
VARCHAR2(25) NOT NULL |
SEGMENT29
|
| 47 |
SEGMENT30 |
Character(25) |
VARCHAR2(25) NOT NULL |
SEGMENT30
|
| 48 |
CURRENCY_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
CURRENCY_CODE
|
| 49 |
DTTM_STAMP_SEC |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|