|
Name |
Type |
Discontinued? |
|
1 |
OR_CASE_ID |
VARCHAR |
No |
|
|
|
The unique ID of the case record. |
|
|
2 |
LINE |
INTEGER |
No |
|
|
|
The number of the line of the In Basket history for the case. |
|
|
3 |
IB_HIST_ACTION_C_NAME |
VARCHAR |
No |
|
|
|
The category value which indicates the type of action the message serves to notify. |
May contain organization-specific values: Yes |
Category Entries: |
Approved |
Denied |
Request More Info |
Moved |
Removed |
Canceled |
Scheduled |
|
|
4 |
IB_HIST_SENDER_ID |
VARCHAR |
No |
|
|
|
The unique ID of the user who sent the message. |
|
|
5 |
IB_HIST_SENDER_ID_NAME |
VARCHAR |
No |
|
|
|
The name of the user record. This name may be hidden. |
|
|
6 |
IB_HIST_RECP_ID |
VARCHAR |
No |
|
|
|
The unique ID of the user who is the first recipient of the message. |
|
|
7 |
IB_HIST_RECP_ID_NAME |
VARCHAR |
No |
|
|
|
The name of the user record. This name may be hidden. |
|
|
8 |
IB_HIST_DATE |
DATETIME (Local) |
No |
|
|
|
The date and time the message was sent. |
|
|
9 |
IB_HIST_SUBJECT |
VARCHAR |
No |
|
|
|
The subject line of the message. |
|
|
10 |
IB_HIST_BODY_LINE |
INTEGER |
No |
|
|
|
The line number where the message body begins in the case record. |
|
|
11 |
IB_HIST_BODY_LEN |
INTEGER |
No |
|
|
|
The length of the message body in the case record. |
|
|
12 |
IB_HIST_RECIP_INI |
VARCHAR |
No |
|
|
|
The database initials of the recipient registry in the message. |
|
|
13 |
IB_HIST_MESSAGE_ID |
VARCHAR |
No |
|
|
|
The message ID of the message. |
|
|