XLA_EVENTS_INT_GT
This interface table is used to create accounting events in bulk. It is a temporary table. The information in this table is deleted upon COMMIT.
Details
-
Schema: FUSION
-
Object owner: XLA
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ENTITY_ID | NUMBER | 18 | Internal identifier of the entity. | ||
| APPLICATION_ID | NUMBER | 18 | Yes | Functional area within a software suite of products. For example, Financials or Payroll. | |
| LEDGER_ID | NUMBER | 18 | Yes | Self-contained accounting information set for single or multiple legal or management entities. | |
| LEGAL_ENTITY_ID | NUMBER | 18 | Internal identifier of the legal entity. | ||
| ENTITY_CODE | VARCHAR2 | 30 | Yes | Unique abbreviated name assigned to an entity and used for reporting or in reference to an option. | |
| TRANSACTION_NUMBER | VARCHAR2 | 240 | Numeric identifier on a transaction that is used as a primary identifier of the transaction | ||
| SOURCE_ID_INT_1 | NUMBER | 18 | System transaction internal identifier (Integer). | ||
| SOURCE_ID_INT_2 | NUMBER | 18 | System transaction internal identifier (Integer). | ||
| SOURCE_ID_INT_3 | NUMBER | 18 | System transaction internal identifier (Integer). | ||
| SOURCE_ID_INT_4 | NUMBER | 18 | System transaction internal identifier (Integer). | ||
| SOURCE_ID_CHAR_1 | VARCHAR2 | 30 | System transaction internal identifier (Character). | ||
| SOURCE_ID_CHAR_2 | VARCHAR2 | 30 | System transaction internal identifier (Character). | ||
| SOURCE_ID_CHAR_3 | VARCHAR2 | 30 | System transaction internal identifier (Character). | ||
| SOURCE_ID_CHAR_4 | VARCHAR2 | 30 | System transaction internal identifier (Character). | ||
| EVENT_ID | NUMBER | 18 | Accounting event internal identifier. | ||
| EVENT_CLASS_CODE | VARCHAR2 | 30 | Unique abbreviated name assigned to an event class and used for reporting or in reference to an option. | ||
| EVENT_TYPE_CODE | VARCHAR2 | 30 | Unique abbreviated name assigned to an event type and used for reporting or in reference to an option. | ||
| EVENT_NUMBER | NUMBER | 18 | Identifying number of an accounting event. | ||
| EVENT_DATE | DATE | Date when an accounting event is created. | |||
| EVENT_STATUS_CODE | VARCHAR2 | 1 | Short name of the status associated with the accounting entries generated for this event. | ||
| PROCESS_STATUS_CODE | VARCHAR2 | 1 | Abbreviated code that tracks the status of generated accounting entries. | ||
| REFERENCE_NUM_1 | NUMBER | Additional reference (Number). | |||
| REFERENCE_NUM_2 | NUMBER | Additional reference (Number). | |||
| REFERENCE_NUM_3 | NUMBER | Additional reference (Number). | |||
| REFERENCE_NUM_4 | NUMBER | Additional reference (Number). | |||
| REFERENCE_CHAR_1 | VARCHAR2 | 240 | Additional reference (Character). | ||
| REFERENCE_CHAR_2 | VARCHAR2 | 240 | Additional reference (Character). | ||
| REFERENCE_CHAR_3 | VARCHAR2 | 240 | Additional reference (Character). | ||
| REFERENCE_CHAR_4 | VARCHAR2 | 240 | Additional reference (Character). | ||
| REFERENCE_DATE_1 | DATE | Additional reference (Date). | |||
| REFERENCE_DATE_2 | DATE | Additional reference (Date). | |||
| REFERENCE_DATE_3 | DATE | Additional reference (Date). | |||
| REFERENCE_DATE_4 | DATE | Additional reference (Date). | |||
| VALUATION_METHOD | VARCHAR2 | 30 | Valuation of an underlying accounting event that can be valued with a different monetary value and accounted differently. | ||
| SECURITY_ID_INT_1 | NUMBER | 18 | Flexible security identifier (Integer). | ||
| SECURITY_ID_INT_2 | NUMBER | 18 | Flexible security identifier (Integer). | ||
| SECURITY_ID_INT_3 | NUMBER | 18 | Flexible security identifier (Integer). | ||
| SECURITY_ID_CHAR_1 | VARCHAR2 | 30 | Flexible security identifier (Character). | ||
| SECURITY_ID_CHAR_2 | VARCHAR2 | 30 | Flexible security identifier (Character). | ||
| SECURITY_ID_CHAR_3 | VARCHAR2 | 30 | Flexible security identifier (Character). | ||
| ON_HOLD_FLAG | VARCHAR2 | 1 | Indicates whether the event is on hold or not. The possible values are Y for Yes, and N for No. | ||
| TRANSACTION_DATE | DATE | Transaction date for matching other charges to the invoice. | |||
| BUDGETARY_CONTROL_FLAG | VARCHAR2 | 1 | Indicates if it is a budgetary control event. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| XLA_EVENTS_INT_GT_N1 | Non Unique | NVL("SOURCE_ID_INT_1",(-99)), NVL("SOURCE_ID_INT_2",(-99)), NVL("SOURCE_ID_INT_3",(-99)), NVL("SOURCE_ID_INT_4",(-99)), NVL("SOURCE_ID_CHAR_1",' '), NVL("SOURCE_ID_CHAR_2",' '), NVL("SOURCE_ID_CHAR_3",' '), NVL("SOURCE_ID_CHAR_4",' '), NVL("VALUATION_METHOD",' ') |
| XLA_EVENTS_INT_GT_N2 | Non Unique | EVENT_ID, EVENT_STATUS_CODE |