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 |