FA_BALANCES_EXTRACT
This table contains data for asset balances subject area.
Details
-
Schema: FUSION
-
Object owner: FA
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
FA_BALANCES_EXTRACT_PK |
BALANCES_EXTRACT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BALANCES_EXTRACT_ID | NUMBER | 18 | Yes | Row number in the balances extract table. | |
| BOOK_TYPE_CODE | VARCHAR2 | 30 | Name of the asset book for which data is extracted. | ||
| PERIOD_COUNTER | NUMBER | 18 | Depreciation period identification number. | ||
| PERIOD_NAME | VARCHAR2 | 15 | Name of the period for which data is extracted. | ||
| SOURCE_TABLE | VARCHAR2 | 30 | Table from which each row is extracted. | ||
| SOURCE_DISTRIBUTION_TYPE | VARCHAR2 | 30 | Identifies the source of the row extracted. | ||
| LEDGER_ID | NUMBER | 18 | Ledger to which asset book is associated. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Currency of the extracted line. | ||
| ASSET_ID | NUMBER | 18 | Unique asset identification number. | ||
| ASSET_TYPE | VARCHAR2 | 30 | Asset with specific characteristics. The asset types allowed are Capitalized, Construction-in-Process, Expensed, and Group. | ||
| GROUP_ASSET_ID | NUMBER | 18 | Group asset identification number. | ||
| CATEGORY_ID | NUMBER | 18 | Number that identifies the asset category. | ||
| CATEGORY_BOOK_DEFAULT_ID | NUMBER | 18 | Default depreciation rules for the category in the book. | ||
| UNITS_ASSIGNED | NUMBER | Number of units assigned to the distribution. | |||
| TOTAL_UNITS | NUMBER | Total number of units assigned to the asset. | |||
| UNIT_RATIO | NUMBER | Ratio of the units to total units. | |||
| DISTRIBUTION_ID | NUMBER | 18 | Unique asset distribution identifier. | ||
| DIST_CCID | NUMBER | 18 | Depreciation expense account identifier. | ||
| LOCATION_ID | NUMBER | 18 | Location flexfield identification number. | ||
| EMPLOYEE_ID | NUMBER | 18 | Employee identification number used to assign an asset to an employee. | ||
| TRANSACTION_HEADER_ID | NUMBER | 18 | Unique asset transaction identifier. | ||
| TRANSACTION_TYPE_CODE | VARCHAR2 | 30 | Code used to identify the type of asset transaction performed. | ||
| TRANSACTION_KEY | VARCHAR2 | 30 | General class of transaction. Possible values are R for retirements, UA for unplanned depreciation amortized from current period, and UE for unplanned depreciation expensed. | ||
| ADJUSTMENT_LINE_ID | NUMBER | 18 | Asset accounting line identifier. | ||
| SOURCE_LINE_ID | NUMBER | 18 | Unique asset source line identifier. | ||
| SOURCE_TYPE_CODE | VARCHAR2 | 30 | Code used to identify the transaction type of the accounting line. | ||
| SOURCE_DEST_CODE | VARCHAR2 | 30 | Code that indicates whether the line is on the source or destination side of a transaction. | ||
| DEPRN_RUN_ID | NUMBER | 18 | Depreciation submission identifier. | ||
| DEPRN_RUN_DATE | DATE | System date when depreciation was run. | |||
| DEPRN_SOURCE_CODE | VARCHAR2 | 1 | Source from which the depreciation record was created. Possible values are B(BOOKS), D(DEPRN), and T(TRACK). | ||
| ACCOUNT_TYPE | VARCHAR2 | 30 | Type of account this row affects. | ||
| ACCOUNT_CCID | NUMBER | 18 | Balance account identifier based on account type. | ||
| AMOUNT | NUMBER | Amount broken down by the account type and asset distribution. | |||
| BEGINNING_BALANCE | NUMBER | Total amount of the account type at the start of the period. | |||
| AE_HEADER_ID | NUMBER | 18 | Transaction accounting entry identifier. | ||
| AE_LINE_NUM | NUMBER | 18 | Number that is associated with each subledger journal entry line. | ||
| EVENT_ID | NUMBER | 18 | Categorization of accounting events that is unique within an application and event class. | ||
| EVENT_TYPE_CODE | VARCHAR2 | 30 | Unique abbreviated name assigned to an event type and used for reporting or in reference to an option. | ||
| ACCOUNTING_CLASS_CODE | VARCHAR2 | 30 | Short name of a lookup type that is shared across applications used to classify journal entry lines. | ||
| MASS_TRANSACTION_ID | NUMBER | 18 | Unique mass transaction identifier. | ||
| GL_SL_LINK_ID | NUMBER | 18 | Audit trail from the subledger application to the general ledger. | ||
| GL_SL_LINK_TABLE | VARCHAR2 | 30 | Subledger link table name. This column is used to link general ledger journal lines with subledger journal entry lines. | ||
| ACCOUNTING_ENTRY_STATUS_CODE | VARCHAR2 | 30 | Status code of the accounting entry. | ||
| GL_TRANSFER_STATUS_CODE | VARCHAR2 | 30 | General Ledger transfer status code. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created 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. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FA_BALANCES_EXTRACT_N1 | Non Unique | FUSION_TS_TX_DATA | BOOK_TYPE_CODE, ASSET_ID |
| FA_BALANCES_EXTRACT_N2 | Non Unique | FUSION_TS_TX_DATA | BOOK_TYPE_CODE, PERIOD_NAME, SOURCE_TYPE_CODE |
| FA_BALANCES_EXTRACT_U1 | Unique | FUSION_TS_TX_DATA | BALANCES_EXTRACT_ID |