FA_GROUP_REP_T
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 | Not-null | Comments |
|---|---|---|---|---|---|
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| 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. | ||
| ORGANIZATION_NAME | VARCHAR2 | 80 | Oracle internal use only. | ||
| CURRENCY_CODE | VARCHAR2 | 30 | Oracle internal use only. | ||
| LEDGER_ID | NUMBER | 18 | Oracle internal use only. | ||
| BOOK_TYPE_CODE | VARCHAR2 | 30 | Oracle internal use only. | ||
| DEPRN_CALENDAR_TYPE | VARCHAR2 | 15 | Oracle internal use only. | ||
| FISCAL_YEAR | NUMBER | 18 | Oracle internal use only. | ||
| GRP_ASSET_ID | VARCHAR2 | 15 | Oracle internal use only. | ||
| GRP_ASSET_NUMBER | VARCHAR2 | 30 | Oracle internal use only. | ||
| GRP_CATEGORY_ID | NUMBER | 18 | Oracle internal use only. | ||
| GRP_DESCRIPTION | VARCHAR2 | 80 | Oracle internal use only. | ||
| GRP_ASSET_TYPE | VARCHAR2 | 30 | Oracle internal use only. | ||
| GRP_DATE_PLACED_IN_SERVICE | DATE | Oracle internal use only. | |||
| GRP_DEPRN_METHOD_ID | NUMBER | 18 | Oracle internal use only. | ||
| GRP_FLAT_RATE_ID | NUMBER | 18 | Oracle internal use only. | ||
| GRP_RULE_NAME | VARCHAR2 | 80 | Oracle internal use only. | ||
| GRP_TRACKING_METHOD | VARCHAR2 | 30 | Oracle internal use only. | ||
| GRP_COST | NUMBER | Oracle internal use only. | |||
| GRP_SALVAGE_VALUE | NUMBER | Oracle internal use only. | |||
| GRP_ADJ_RECOVERABLE_COST | NUMBER | Oracle internal use only. | |||
| GRP_BEGINNING_NBV | NUMBER | Oracle internal use only. | |||
| GRP_FIRST_HALF_ADDITION | NUMBER | Oracle internal use only. | |||
| GRP_SECOND_HALF_ADDITION | NUMBER | Oracle internal use only. | |||
| GRP_ADDITION_AMOUNT | NUMBER | Oracle internal use only. | |||
| GRP_ADJUSTMENT_AMOUNT | NUMBER | Oracle internal use only. | |||
| GRP_FIRST_HALF_ADJUSTMENT | NUMBER | Oracle internal use only. | |||
| GRP_SECOND_HALF_ADJUSTMENT | NUMBER | Oracle internal use only. | |||
| GRP_NET_PROCEEDS | NUMBER | Oracle internal use only. | |||
| GRP_PROCEEDS_OF_SALE | NUMBER | Oracle internal use only. | |||
| GRP_COST_OF_REMOVAL | NUMBER | Oracle internal use only. | |||
| GRP_COST_RETIRED | NUMBER | Oracle internal use only. | |||
| GRP_RESERVE_RETIRED | NUMBER | Oracle internal use only. | |||
| GRP_RECAPTURE_AMOUNT | NUMBER | Oracle internal use only. | |||
| GRP_TERM_GAIN_LOSS_AMOUNT | NUMBER | Oracle internal use only. | |||
| GRP_NBV_BEFORE_DEPRN | NUMBER | Oracle internal use only. | |||
| GRP_DEPRN_BASIS_ADJUSTMENT | NUMBER | Oracle internal use only. | |||
| GRP_REDUCED_NBV | NUMBER | Oracle internal use only. | |||
| GRP_REGULAR_DEPRN_AMOUNT | NUMBER | Oracle internal use only. | |||
| GRP_REDUCED_DEPRN_AMOUNT | NUMBER | Oracle internal use only. | |||
| GRP_ANNUAL_DEPRN_AMOUNT | NUMBER | Oracle internal use only. | |||
| GRP_DEPRN_RESERVE | NUMBER | Oracle internal use only. | |||
| GRP_ENDING_NBV | NUMBER | Oracle internal use only. | |||
| MEM_ASSET_ID | NUMBER | 18 | Oracle internal use only. | ||
| MEM_ASSET_NUMBER | VARCHAR2 | 30 | Oracle internal use only. | ||
| MEM_CATEGORY_ID | NUMBER | 18 | Oracle internal use only. | ||
| MEM_DESCRIPTION | VARCHAR2 | 80 | Oracle internal use only. | ||
| MEM_ASSET_TYPE | VARCHAR2 | 30 | Oracle internal use only. | ||
| MEM_DATE_PLACED_IN_SERVICE | DATE | Oracle internal use only. | |||
| MEM_DEPRN_METHOD_ID | NUMBER | 18 | Oracle internal use only. | ||
| MEM_FLAT_RATE_ID | NUMBER | 18 | Oracle internal use only. | ||
| MEM_RULE_NAME | VARCHAR2 | 80 | Oracle internal use only. | ||
| MEM_COST | NUMBER | Oracle internal use only. | |||
| MEM_SALVAGE_VALUE | NUMBER | Oracle internal use only. | |||
| MEM_ADJ_RECOVERABLE_COST | NUMBER | Oracle internal use only. | |||
| MEM_BEGINNING_NBV | NUMBER | Oracle internal use only. | |||
| MEM_FIRST_HALF_ADDITION | NUMBER | Oracle internal use only. | |||
| MEM_SECOND_HALF_ADDITION | NUMBER | Oracle internal use only. | |||
| MEM_ADDITION_AMOUNT | NUMBER | Oracle internal use only. | |||
| MEM_ADJUSTMENT_AMOUNT | NUMBER | Oracle internal use only. | |||
| MEM_FIRST_HALF_ADJUSTMENT | NUMBER | Oracle internal use only. | |||
| MEM_SECOND_HALF_ADJUSTMENT | NUMBER | Oracle internal use only. | |||
| MEM_NET_PROCEEDS | NUMBER | Oracle internal use only. | |||
| MEM_PROCEEDS_OF_SALE | NUMBER | Oracle internal use only. | |||
| MEM_COST_OF_REMOVAL | NUMBER | Oracle internal use only. | |||
| MEM_COST_RETIRED | NUMBER | Oracle internal use only. | |||
| MEM_RESERVE_RETIRED | NUMBER | Oracle internal use only. | |||
| MEM_NBV_BEFORE_DEPRN | NUMBER | Oracle internal use only. | |||
| MEM_DEPRN_BASIS_ADJUSTMENT | NUMBER | Oracle internal use only. | |||
| MEM_REDUCED_NBV | NUMBER | Oracle internal use only. | |||
| MEM_ANNUAL_DEPRN_AMOUNT | NUMBER | Oracle internal use only. | |||
| MEM_DEPRN_RESERVE | NUMBER | Oracle internal use only. | |||
| MEM_ENDING_NBV | NUMBER | Oracle internal use only. | |||
| MEM_STATUS | VARCHAR2 | 30 | Oracle internal use only. | ||
| MEM_RECAPTURE_AMOUNT | NUMBER | Oracle internal use only. | |||
| MEM_TERM_GAIN_LOSS_AMOUNT | NUMBER | Oracle internal use only. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FA_GROUP_REP_T_N1 | Non Unique | Default | REQUEST_ID |