# |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
1 |
KK_TRAN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Commitment Control Foreign Key for Transaction Identification.
|
2 |
KK_TRAN_DT |
Date(10) |
DATE NOT NULL |
Commitment Control Transaction Original processing date. Primary key with KK_TRAN_ID.
|
3 |
KK_TRAN_LN |
Number(9,0) |
DECIMAL(9) NOT NULL |
Commitment Control Transaction Line number.
|
4 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
|
5 |
EXCPTN_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Exception Type
|
6 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
7 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
8 |
MESSAGE_PARM1 |
Character(30) |
VARCHAR2(30) NOT NULL |
Message Parameter 1
|
9 |
MESSAGE_PARM2 |
Character(30) |
VARCHAR2(30) NOT NULL |
Message Parameter 2
|
10 |
MESSAGE_PARM3 |
Character(30) |
VARCHAR2(30) NOT NULL |
Message Parameter 3
|
11 |
MESSAGE_PARM4 |
Character(30) |
VARCHAR2(30) NOT NULL |
Message Parameter 4
|
12 |
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.
|