VRM_CUSTOMER_CONTRACT

Details

Schema: FUSION
Object owner: VRM
Object type: TABLE
Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
VRM_CUST_CONTRACT_AUDIT_PK	CUSTOMER_CONTRACT_AUDIT_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
CUSTOMER_CONTRACT_AUDIT_ID	NUMBER		18	Yes	Customer contract audit unique identifier.
CUSTOMER_CONTRACT_HEADER_ID	NUMBER		18	Yes	Customer contract header unique identifier.
PERF_OBLIGATION_ID	NUMBER		18		Performance obligation unique identifier.
PERF_OBLIGATION_LINE_ID	NUMBER		18		Performance obligation line unique identifier.
AUDIT_LEVEL_CODE	VARCHAR2	30		Yes	Level at which audit information is recorded. Lookup type ORA_AUDIT_LEVEL.
AUDIT_LINE_ID	NUMBER		18	Yes	Audit line identifier.
ACTION_TYPE	VARCHAR2	30		Yes	Type of audited action. Lookup ORA_ACTION_TYPE.
ACTION_DATE	TIMESTAMP			Yes	Action date with time.
MODIFIED_ATTRIBUTE_TYPE	VARCHAR2	30		Yes	Audited attribute data type. Lookup Type ORA_MODIFIED_ATTRIBUTE_TYPE.
MODIFIED_ATTRIBUTE_NAME	VARCHAR2	30		Yes	Audited attribute name. Lookup Type ORA_MODIFIED_ATTRIBUTE.
OLD_VALUE_CHAR	VARCHAR2	250			This is the value of the alphanumeric attribute before the update.
NEW_VALUE_CHAR	VARCHAR2	250			This is the value of the alphanumeric attribute after the update.
OLD_VALUE_DATE	DATE				This is the value of the date attribute before the update.
NEW_VALUE_DATE	DATE				This is the value of the date attribute after the update.
OLD_VALUE_NUMBER	NUMBER				This is the value of the numeric attribute before the update.
NEW_VALUE_NUMBER	NUMBER				This is the value of the numeric attribute after the update.
LOOKUP_TYPE	VARCHAR2	30			Lookup type of the lookup attribute that was modified.
OLD_VALUE_LOOKUP_CODE	VARCHAR2	30			This is the value of the lookup code attribute before update.
NEW_VALUE_LOOKUP_CODE	VARCHAR2	30			This is the value of the lookup code attribute after update.
OLD_VALUE_CCID	NUMBER		18		This is the value of the code combination attribute before update.
NEW_VALUE_CCID	NUMBER		18		This is the value of the code combination attribute after update.
COMMENTS	VARCHAR2	1000			User entered comments.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
CREATED_FROM	VARCHAR2	30		Yes	The process or user interface from which this row is created..
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
NEW_SIN	NUMBER		18		When customer contract is updated, this attribute contains value of the structure instance number after update.
OLD_SIN	NUMBER		18		When customer contract is updated, this attribute contains value of the structure instance number before update.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
DOCUMENT_LINE_ID	NUMBER		18		Internal unique identifier of a source document line.

Foreign Keys

Table	Foreign Table	Foreign Key Column
VRM_CUSTOMER_CONTRACT_AUDIT	vrm_customer_contract_headers	CUSTOMER_CONTRACT_HEADER_ID
VRM_CUSTOMER_CONTRACT_AUDIT	vrm_perf_obligations	PERF_OBLIGATION_ID
VRM_CUSTOMER_CONTRACT_AUDIT	vrm_perf_obligation_lines	PERF_OBLIGATION_LINE_ID

Indexes

Index	Uniqueness	Tablespace	Columns
VRM_CUST_CONTRACT_AUDIT_N1	Non Unique	Default	AUDIT_LINE_ID, AUDIT_LEVEL_CODE
VRM_CUST_CONTRACT_AUDIT_U1	Unique	Default	CUSTOMER_CONTRACT_AUDIT_ID