1. Tables and Views for Financials
  2. FLA_ACCOUNTING_HEADERS_ALL

FLA_ACCOUNTING_HEADERS_ALL

FLA_ACCOUNTING_HEADERS_ALL contains accounting transactions generated within Lease Accounting for booking, revision, termination, accurals, reclassification, expiry, right of use adjustment and payment approval.

Details

  • Schema: FUSION

  • Object owner: FUN

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

FLA_ACCOUNTING_HEADERS_ALL_PK

TRANSACTION_ID

Columns

Name Datatype Length Precision Not-null Comments
TRANSACTION_ID NUMBER 18 Yes Accounting transaction identifier. It is the primary key of the table.
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.
ORG_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to the row.
LEASE_ID NUMBER 18 Yes Lease identifier. It references the primary key of the FLA_LEASES_ALL table.
VERSION_NUM NUMBER 18 Yes Version number of the lease as captured in FLA_LEASE_DETAILS.
LEASE_DETAIL_ID NUMBER 18 Yes Lease detail identifier. It is referenced from FLA_LEASE_DETAILS table.
TRANSACTION_NUMBER VARCHAR2 30 Yes Accounting transaction reference number.
TRANSACTION_TYPE_CODE VARCHAR2 30 Yes Accounting transaction type like BOOKING, ACCRUAL, PAYMENT, REVISION, TERMINATION and so forth.
TRANSACTION_DATE DATE Yes Source reference date. This is Payment items due date or Schedule header transaction date or Accrual schedule date.
TRANSACTION_STATUS_CODE VARCHAR2 30 Yes Accounting transaction status code like PENDING, PROCESSED, ERRORED and so forth.
DESCRIPTION VARCHAR2 1000 Description of the transaction header.
EVENT_ID NUMBER 18 Identifier of the categorization of accounting events that is unique within an application and event class. This is referenced from XLA_EVENTS table.
LEDGER_ID NUMBER 18 Yes Ledger identifier as defined in general ledger.
REGIME_CODE VARCHAR2 30 Yes Regime code. This drives the accounting model and reporting for the lease.
PROCESSING_SEQ_NUM NUMBER 18 Yes Transaction processing sequence number for the accounting transactions.
PERIOD_NAME VARCHAR2 15 Period based on Schedule date or payment item due date.
LINKED_TRANSACTION_ID NUMBER 18 Linked transaction ID column. This will be used to maintain link between two transactions.
ACCOUNTING_DATE DATE Yes Accounting date which will be sent to Subledger Accounting.
REVERSED_FLAG VARCHAR2 1 Indicates if this transaction is reversed.
PARENT_TRANSACTION_ID NUMBER 18 Source Transaction Identifier in case this transaction is for a reversal.
SWEEP_PROCESS_FLAG VARCHAR2 1 Indicates if the transaction is marked for accounting period sweep.
SOURCE_REFERENCE_ID1 NUMBER 18 Source reference ID identifier 1. For future use.
SOURCE_REFERENCE_ID2 NUMBER 18 Source reference ID identifier 2. For future use.
SOURCE_REFERENCE_ID3 NUMBER 18 Source reference ID identifier 3. For future use.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
BALANCE_SYNC_REQUEST_ID NUMBER 18 Oracle Enterprise Scheduler: request identifier of the job that created or last updated the row. This is used for request created for the purpose of lease balances.
ACCOUNTED_IN_GL_FLAG VARCHAR2 1 Indicates if the accounting was done into general ledger.
ACCOUNTING_TIEBACK_DATE DATE Date the accounted amounts are derived and tied back.
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.

Indexes

Index Uniqueness Tablespace Columns
FLA_ACCOUNTING_HEADERS_ALL_N1 Non Unique Default BALANCE_SYNC_REQUEST_ID
FLA_ACCOUNTING_HEADERS_ALL_U1 Unique FUSION_TS_TX_IDX TRANSACTION_ID
FLA_ACCOUNTING_HEADERS_ALL_U2 Unique FUSION_TS_TX_IDX LEASE_ID, VERSION_NUM, REGIME_CODE, TRANSACTION_TYPE_CODE, TRANSACTION_DATE, PROCESSING_SEQ_NUM