FA_SCHEDULE16_REP_T
FA_SCHEDULE16_REP_T stores information required by Japanese Corporate Tax Schedule 16 Reports.
Details
-
Schema: FUSION
-
Object owner: FA
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
FA_SCHEDULE16_REP_T_PK |
SCHEDULE16_REP_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SCHEDULE16_REP_ID | NUMBER | 18 | Yes | Schedule 16 report record unique identifier. | |
| 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_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| COMPANY_NAME | VARCHAR2 | 240 | The name of the legal entity that owns the assets in an asset book. | ||
| BOOK_TYPE_CODE | VARCHAR2 | 30 | Unique asset book identification name. | ||
| START_DATE | DATE | The date from which the asset information is reported. | |||
| END_DATE | DATE | The date up to which the asset information is reported. | |||
| REPORT_CODE | VARCHAR2 | 2 | Yes | The name of the report process that populated the data. | |
| ASSET_ID | NUMBER | 18 | Unique asset identification number. | ||
| CATEGORY | VARCHAR2 | 30 | Category flexfield major category segment value and identification number. | ||
| STRUCTURE | VARCHAR2 | 150 | User entered asset structure name of the asset. | ||
| SPECIFICATION | VARCHAR2 | 150 | User entered specification of the asset. | ||
| ONE_TIME_DEPRN_FLAG | VARCHAR2 | 1 | Indicates whether the asset is a temporary depreciation asset. | ||
| DATE_PLACED_IN_SERVICE | DATE | The date placed in service of the asset in the tax book. | |||
| LIFE_YEAR | NUMBER | The useful life of the assets in years. | |||
| COST | NUMBER | Total recorded cost of the asset. | |||
| PROVISION_COMPRESS_AMOUNT | NUMBER | The compressed depreciation reserve amount for the asset. | |||
| COMPRESS_AMOUNT | NUMBER | The compressed depreciation deduction amount for the asset. | |||
| SALVAGE_VALUE | NUMBER | Salvage value amount for the asset. | |||
| DEPRN_LIMIT_SALVAGE_VALUE | NUMBER | The depreciation limit or the salvage value of the asset in the specified asset book. | |||
| NET_BOOK_VALUE | NUMBER | The net book value of the asset. | |||
| BASIC_RATE | NUMBER | Basic depreciation rate of the flat rate depreciation method. | |||
| ADDITIONAL_DEPRN_SUBJECT_CODE | VARCHAR2 | 30 | Japan tax legislation article that allows additional depreciation. | ||
| ADDITIONAL_DEPRN_AMOUNT | NUMBER | Additional depreciation amount of the asset. | |||
| ADDITIONAL_DEPRN_RATE | NUMBER | Depreciation rate used to calculate the additional depreciation. | |||
| SPECIAL_DEPRN_SUBJECT_CODE | VARCHAR2 | 30 | Japan tax legislation article that allows special depreciation. | ||
| SPECIAL_DEPRN_AMOUNT | NUMBER | Special depreciation amount of the asset. | |||
| SPECIAL_DEPRN_RATE | NUMBER | Depreciation rate used to calculate the special depreciation. | |||
| INCREASED_DEPRN_AMOUNT | NUMBER | Increased depreciation amount of the asset. | |||
| INCREASED_DEPRN_RATE | NUMBER | Depreciation rate used to calculate the increased depreciation. | |||
| DEPRN_RESERVE | NUMBER | Depreciation reserve balance at the end of the period. | |||
| ALLOWED_DEPRN_LIMIT | NUMBER | Depreciation limit as a percentage of cost for the asset. | |||
| DATE_FULLY_RESERVED | DATE | The date on which the asset was fully reserved in the specified book. | |||
| DATE_FULLY_RETIRED | DATE | The date on which the asset was fully retired in the specified book. | |||
| DEPRN_COUNT | NUMBER | 4 | The number of periods that the asset has depreciated. | ||
| NUMBER_PER_FISCAL_YEAR | NUMBER | 4 | The number of periods in a fiscal year. | ||
| BEGINNING_CORP_NBV | NUMBER | Net book value of the asset in the corporate book at the start date. | |||
| ENDING_CORP_NBV | NUMBER | Net book value of the asset in the corporate book at the end date. | |||
| BEGINNING_TAX_NBV | NUMBER | Net book value of the asset in the tax book at the start date. | |||
| ENDING_TAX_NBV | NUMBER | Net book value of the asset in the tax book at the end date. | |||
| BEGINNING_CORP_DEPRN_RESERVE | NUMBER | Accumulated depreciation of the asset in the corporate book at the start date. | |||
| BEGINNING_TAX_DEPRN_RESERVE | NUMBER | Accumulated depreciation of the asset in the tax book at the start date. | |||
| CORP_YTD_DEPRN | NUMBER | Year-to-date depreciation amount of the asset in the corporate book. | |||
| YTD_DEPRN_LIMIT | NUMBER | Year-to-date depreciation limit amount of the asset. | |||
| BALANCE_CARRIED_FORWARD | NUMBER | The balance carried forward from the prior year. | |||
| AMOUNT_CARRIED_FORWARD | NUMBER | The amount carried forward to the next year. | |||
| EXTENDED_DEPRN_FLAG | VARCHAR2 | 1 | Indicates whether the asset depreciation is extended. | ||
| DEPRN_ADJ_AMT_BEFORE_ALLOC | NUMBER | Deprecation adjustment amount before the allocation. | |||
| GUARANTEE_RATE | NUMBER | Depreciation rate that assures a minimum depreciation amount for the asset. | |||
| GUARANTEE_DEPRN_AMOUNT | NUMBER | Depreciation amount calculated for the asset using the guaranteed depreciation rate. | |||
| ADJUSTED_COST | NUMBER | The adjusted cost of the asset in the specified book. | |||
| REVISED_RATE | NUMBER | Revised depreciation rate of the asset. | |||
| DEPRECIATION_PERIOD_IN_MONTH | NUMBER | 4 | The number of period the asset has depreciated in the current fiscal year. | ||
| REVERSED_COMPRESSED_AMOUNT | NUMBER | User entered compressed depreciation reversed amount for the asset in the current fiscal year. | |||
| PRIOR_CARRIED_DEFICIT_AMOUNT | NUMBER | User entered special depreciation deficit carried forward from the prior year for the asset. | |||
| CURRENT_DEFICIT_AMOUNT | NUMBER | User entered special depreciation deficit amount for the asset. | |||
| CARRIED_FORWARD_DEFICIT_AMOUNT | NUMBER | User entered special depreciation deficit carried over to the next year for the asset. | |||
| PRIOR_NBV_DEFICIT_AMOUNT | NUMBER | User entered special depreciation deficit net book value carried forward from the prior year for the asset. | |||
| DEFICIT_CARRY_OVER_PERIOD | VARCHAR2 | 150 | User entered special depreciation deficit net book value carried forward from the prior year for the asset. | ||
| EXPENSED_REVERSAL_COMP_RSRV | NUMBER | User entered compressed depreciation reversal reserve for the asset. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FA_SCHEDULE16_REP_T_U1 | Unique | Default | SCHEDULE16_REP_ID |