OSP NEGOTIATION ACTIVITIES Table
View exposing negotiation activity records including actions taken, responsible parties, timestamps, activity types, and activity descriptions used to track negotiation process progress and maintain activity logs.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACTIVITY_DATE |
Date associated with activity. |
DATE |
|
ACTIVITY_NUMBER |
Activity number associated with the record. |
NUMBER |
22 |
CREATE_DATE |
Date associated with create. |
DATE |
|
DESCRIPTION |
Description associated with the record. |
VARCHAR2 |
2000 |
DOC_FILE_ADDRESS |
Doc file address associated with the record. |
VARCHAR2 |
255 |
FOLLOWUP_DATE |
Date associated with followup. |
DATE |
|
NEGOTIATION_ACT_TYPE_CODE |
Code identifying negotiation act type. |
NUMBER |
22 |
NEGOTIATION_NUMBER |
Negotiation number associated with the record. |
VARCHAR2 |
25 |
RESTRICTED_VIEW |
Restricted view associated with the record. |
VARCHAR2 |
1 |
UPDATE_TIMESTAMP |
Timestamp associated with update. |
DATE |
|
UPDATE_USER |
Update user associated with the record. |
VARCHAR2 |
60 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |