FA_TRACK_MEMBERS_GT
This is a temporary table which is used internally by Oracle.
Details
-
Schema: FUSION
-
Object owner: FA
-
Object type: TABLE
-
Tablespace: SUMMARY
Columns
Name | Datatype | Length | Precision | Comments |
---|---|---|---|---|
TRACK_MEMBER_ID | NUMBER | 18 | Oracle internal use only. | |
GROUP_ASSET_ID | NUMBER | 18 | Oracle internal use only. | |
MEMBER_ASSET_ID | NUMBER | 18 | Oracle internal use only. | |
PERIOD_COUNTER | NUMBER | 18 | Oracle internal use only. | |
FISCAL_YEAR | NUMBER | 18 | Oracle internal use only. | |
SET_OF_BOOKS_ID | NUMBER | Oracle internal use only. | ||
ALLOCATION_BASIS | NUMBER | Oracle internal use only. | ||
TOTAL_ALLOCATION_BASIS | NUMBER | Oracle internal use only. | ||
ALLOCATED_DEPRN_AMOUNT | NUMBER | Oracle internal use only. | ||
ALLOCATED_BONUS_AMOUNT | NUMBER | Oracle internal use only. | ||
SYSTEM_DEPRN_AMOUNT | NUMBER | Oracle internal use only. | ||
SYSTEM_BONUS_AMOUNT | NUMBER | Oracle internal use only. | ||
FULLY_RESERVED_FLAG | VARCHAR2 | 1 | Oracle internal use only. | |
FULLY_RETIRED_FLAG | VARCHAR2 | 1 | Oracle internal use only. | |
OVERRIDE_FLAG | VARCHAR2 | 1 | Oracle internal use only. | |
COST | NUMBER | Oracle internal use only. | ||
ADJUSTED_COST | NUMBER | Oracle internal use only. | ||
EOFY_ADJ_COST | NUMBER | Oracle internal use only. | ||
RECOVERABLE_COST | NUMBER | Oracle internal use only. | ||
SALVAGE_VALUE | NUMBER | Oracle internal use only. | ||
ADJUSTED_RECOVERABLE_COST | NUMBER | Oracle internal use only. | ||
PRIOR_YEAR_RESERVE | NUMBER | Oracle internal use only. | ||
EOFY_AMOUNT | NUMBER | Oracle internal use only. | ||
DEPRN_RESERVE | NUMBER | Oracle internal use only. | ||
YTD_DEPRN | NUMBER | Oracle internal use only. | ||
BONUS_DEPRN_RESERVE | NUMBER | Oracle internal use only. | ||
BONUS_YTD_DEPRN | NUMBER | Oracle internal use only. | ||
EOFY_RECOVERABLE_COST | NUMBER | Oracle internal use only. | ||
EOP_RECOVERABLE_COST | NUMBER | Oracle internal use only. | ||
EOFY_SALVAGE_VALUE | NUMBER | Oracle internal use only. | ||
EOP_SALVAGE_VALUE | NUMBER | Oracle internal use only. | ||
DEPRN_OVERRIDE_FLAG | NUMBER | Oracle internal use only. |
Indexes
Index | Uniqueness | Columns |
---|---|---|
FA_TRACK_MEMBERS_GT_N1 | Non Unique | MEMBER_ASSET_ID, GROUP_ASSET_ID, PERIOD_COUNTER |