# |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
1 |
IBTRANSACTIONID |
Character(36) |
VARCHAR2(36) NOT NULL |
Transaction ID
|
2 |
IB_MSGNUMBER |
Number(20,0) |
DECIMAL(20) NOT NULL |
Message Number
|
3 |
SEGMENTNO |
Number(3,0) |
SMALLINT NOT NULL |
Segment Number
|
4 |
SUBSEGMENTNO |
Number(3,0) |
SMALLINT NOT NULL |
Integration Broker Run-time Sub Segment
|
5 |
DATASEQNO |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Data Sequence Number
|
6 |
UNCOMPMIMEDATALEN |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Uncompressed MIME Data Length
|
7 |
COMPMIMEDATALEN |
Signed Number(11,0) |
DECIMAL(10) NOT NULL |
Compressed MIME Data Length
|
8 |
MIMEDATALONG |
Image / Attachment |
CLOB |
MIME Data Long
|