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 |