VRM_ACCOUNTING_EVENTS
This table contains the accounting events of customer contract.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
VRM_ACCOUNTING_EVENTS_PK |
ACCOUNTING_EVENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ACCOUNTING_EVENT_ID | NUMBER | 18 | Yes | Revenue management accounting event unique identifier. | |
| DOCUMENT_LINE_ID | NUMBER | 18 | Source document line unique identifier. | ||
| ACCOUNTING_EVENT_TYPE_CODE | VARCHAR2 | 30 | Yes | Accounting event type. Values are from the lookup VRM_ACCOUNTING_EVENT_TYPE. | |
| REFERENCE_EVENT_ID | NUMBER | 18 | Yes | Reference to the identifier of the event that triggered the accounting event. | |
| ACCOUNTING_DATE | DATE | Yes | Accounting date of the accounting event. | ||
| AMOUNT | NUMBER | Accounting event amount in the performance obligation currency. | |||
| ACCTD_AMOUNT | NUMBER | Yes | Accounting event amount in the revenue contract currency. | ||
| CONTRACT_ACTIVITY_GROUP_ID | NUMBER | 18 | Customer contract activity group identifier. | ||
| CUSTOMER_CONTRACT_HEADER_ID | NUMBER | 18 | Customer contract header unique identifier. | ||
| PERF_OBLIGATION_ID | NUMBER | 18 | Yes | Performance obligation unique identifier. | |
| PERF_OBLIGATION_LINE_ID | NUMBER | 18 | Performance obligation line unique identifier. | ||
| DEVOLVED_PERF_OBLIG_DTL_ID | NUMBER | 18 | Devolved performance obligation details table unique record identifier. The value in this column refers to the devolved performance obligation record for which the initial performance event type accounting event is generated. This column is a foreign key reference to column DEVOLVED_PERF_OBLIG_DTL_ID in the VRM_DEVOLVED_PERF_OBLIG_DTLS table. | ||
| REVERSED_FLAG | VARCHAR2 | 1 | Indicates whether this accounting event is reversed. Blank indicates reversed. N indicates not reversed. | ||
| REVERSED_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or marked this row as reversed. | ||
| LEDGER_ID | NUMBER | 18 | Ledger identifier of customer contract. | ||
| PROCESS_STATUS_CODE | VARCHAR2 | 30 | Accounting event processing status. Values are from the lookup ORA_ACCOUNTING_EVENT_STATUS. | ||
| PROCESSED_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that processed this row. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| POB_FIRST_BE_FLAG | VARCHAR2 | 1 | Indicates whether the current event being processed is the first billing event after sorting based on the accounting date under the performance obligation. | ||
| POB_LAST_SE_FLAG | VARCHAR2 | 1 | Indicates whether the current event being processed is the last satisfaction event after sorting based on the accounting date under the performance obligation line. | ||
| ACCOUNTING_EVENT_SEQ_NUMBER | NUMBER | 18 | Sequence number of the accounting event record. | ||
| CREATED_FROM | VARCHAR2 | 30 | Yes | The process or user interface from which this row was created. | |
| 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. | |
| 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_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| CONVERSION_RATE_AVAILABLE_FLAG | VARCHAR2 | 1 | Indicates that the conversion rate is available for the conversion rate date. Possible values are Null or N. Null indicates conversion rate is available. | ||
| CONVERSION_RATE_TYPE | VARCHAR2 | 30 | Conversion rate type used to convert amounts from the entered currency to the ledger currency. | ||
| CONVERSION_RATE_DATE | DATE | Conversion rate date used to convert amounts from the entered currency to the ledger currency. | |||
| CONVERSION_RATE | NUMBER | Conversion rate used to convert amounts from the entered currency to the ledger currency. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| VRM_ACCOUNTING_EVENTS | vrm_perf_obligation_lines | PERF_OBLIGATION_LINE_ID |
| VRM_ACCOUNTING_EVENTS | vrm_perf_obligations | PERF_OBLIGATION_ID |
| VRM_ACCOUNTING_EVENTS | vrm_source_doc_lines | DOCUMENT_LINE_ID |
| vrm_perf_obligation_lin_dists | vrm_accounting_events | ACCOUNTING_EVENT_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| VRM_ACCOUNTING_EVENTS_N1 | Non Unique | FUSION_TS_TX_DATA | CUSTOMER_CONTRACT_HEADER_ID, PROCESS_STATUS_CODE |
| VRM_ACCOUNTING_EVENTS_N2 | Non Unique | FUSION_TS_TX_DATA | ACCOUNTING_EVENT_TYPE_CODE, REFERENCE_EVENT_ID, ACCOUNTING_DATE |
| VRM_ACCOUNTING_EVENTS_N3 | Non Unique | FUSION_TS_TX_DATA | PROCESS_STATUS_CODE, ACCOUNTING_EVENT_TYPE_CODE, ACCOUNTING_DATE, LEDGER_ID, CUSTOMER_CONTRACT_HEADER_ID |
| VRM_ACCOUNTING_EVENTS_N4 | Non Unique | FUSION_TS_TX_DATA | PERF_OBLIGATION_LINE_ID, REVERSED_FLAG |
| VRM_ACCOUNTING_EVENTS_N5 | Non Unique | FUSION_TS_TX_DATA | PERF_OBLIGATION_ID, ACCOUNTING_DATE, REVERSED_FLAG |
| VRM_ACCOUNTING_EVENTS_N6 | Non Unique | FUSION_TS_TX_DATA | CONVERSION_RATE_AVAILABLE_FLAG |
| VRM_ACCOUNTING_EVENTS_U1 | Unique | FUSION_TS_TX_DATA | ACCOUNTING_EVENT_ID |