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 |