Oracle Assets User Guide Release 12.1 Part Number E13586-04 | Contents | Previous | Next |
This extract displays data required for assets tax reporting. The Asset Tax Accounting Card is a front-end to the Asset Tax Accounting Card extract program. It uses a subset of the parameters supported by the program. In conjunction with the Asset Tax Accounting Card report template, it allows users to select all information about the Asset for the depreciation book and the category according to Tax Code of Russian Federation. The Asset Tax Accounting Card report is submitted via standard request submission (SRS) and is available only from Assets responsibilities.
Parameter Name | Description | Displayed | Required | Default Value | List of Values |
---|---|---|---|---|---|
Asset Book | Asset Book Name | Y | Y | N | Y |
Category Flex Structure | Category Flex Structure | N | N | Y | Y |
Category | Category to be reported | Y | N | N | Y |
Asset Number | Asset Number | Y | N | N | Y |
The Asset Tax Accounting Card extract generates the following groups:
MAIN_COMMON_INFO
COMMON_INFO
ASSIGN_LOC
COST_SOURCE
HIST_COST_CHANGES
ADJ_COEFF_USAGE_DETAILS
SUSPEND_DEPRN_DETAILS
The following table describes data obtained by <Q_COMMON_INFORMATION>.
XML Tag | Description |
---|---|
| Asset Main Category |
| Asset Identifier |
| Company Name |
| Currency |
The following table describes data obtained by <Q_COMMON_INFORMATION>:
XML Tag | Description |
---|---|
| Asset Description |
| Asset Number |
| Date Placed in Service |
| State Registration Filing Date |
| Prorate Date |
| Useful Life, Months |
| Asset Category |
| Depreciation Method |
| Recoverable Cost |
| Depreciation Amount in Last Depreciated Period |
| Accumulated Depreciation |
| Last Depreciation Period |
The following table describes data obtained by <Q_ASSIGNED_LOCATIONS>:
XML Tag | Description |
---|---|
| Location of the Asset |
| Employee Name |
| Depreciation Expense Account |
| Asset Units |
The following table describes data obtained by < Q_COST_SOURCE >
XML Tag | Description |
---|---|
| Invoice Number |
| Line Number |
| Invoice Description |
| Asset Cost from Invoice Line |
| Tax Book Cost |
The following table describes data obtained by < Q_HISTORY_COST_CHANGES >
XML Tag | Description |
---|---|
| Reference Number for Cost Transaction Changes |
Transaction Type for Cost Changes | |
| Effective Date for Cost Changes |
| Reference |
| Asset Cost |
The following table describes data obtained by < Q_ADJ_COEFF_USAGE_DETAILS >
XML Tag | Description |
---|---|
| Transaction Identifier |
| Event Type for adjusting coefficient usage details. This is a derived value based on data from Descriptive Flexfield Adjusting Coefficient in FA_FLAT_RATES table. Possible values are N/A, Started, Stopped, and Changed. Each value depends on the result of comparing the adjusting coefficient value for the period in which the reports are run with the adjusting coefficient for the period -1. |
| Data entered manually for adjusting coefficient usage details |
| Effective date for depreciation method changes |
| Data entered manually |
| Data entered manually |
| Depreciation method assigned to each asset |
| Base Rate % |
| Adjusting Coefficient is the value used to calculate Event Type. |
The following table describes data obtained by < Q_SUSPEND_DEPRN_DETAILS >
XML Tag | Description |
---|---|
| In Suspend Depreciation Details section, report shows different values if depreciation was stopped or reinitiated (for depreciation flag for each asset). For example, Suspending or Resuming |
| Date Started/Stopped |
| Effective Date for transaction |
| Reference |
| Suspend Reason |
| Transaction Identifier |
This extract is used to find out the depreciation expense charged by Oracle Assets to a depreciation expense account for any accounting period. It is a modification of the standard Journal Entry Reserve Ledger extract. The only difference is a new column - Net Book Value. This column is a difference between Cost and Depreciation Reserve amounts and is calculated at the Template level.
Parameter Name | Description | Displayed | Required | Default Value | List of Values |
---|---|---|---|---|---|
P_BOOK | Book | Y | Y | N | Y |
P_CURRENCY | Set of books currency | Y | Y | N | Y |
P_PERIOD | Period | Y | Y | N | Y |
The Reserve Ledger extract generates the following groups.
G_SETUP
G_DO_INSERT
G_COMPANY
G_ACCOUNT
G_COSTCTR
G_REPORT
The following table describes data obtained by < Q_SETUP >.
XML Tag | Description |
---|---|
| Company Name |
| Category Flex Structure |
| Location Flex Structure |
| Asset Key Flex Structure |
| Asset Book |
| Flex Structure |
| Currency Code |
| Period |
| Partial Retirement |
| Full Retirement |
| Transfer Out |
| Non Depreciate |
| Category Reclass |
| Bonus |
The following table describes data obtained by < Q_DO_INSERT >
XML Tab | Description |
---|---|
| Source |
The following table describes data obtained by < Q_REPORT >.
XML Tab | Description |
---|---|
| Company Code |
| Sum of Report Cost |
| Currency format for CO_COST |
| Sum of Report Deprecation Amount |
| Currency format for CO_DEPRN |
| Sum of Report Year–To–Date Depreciation |
| Currency Format for Year–To–Date Depreciation |
| Sum of Report Depreciation Reserve |
| Currency Format for Depreciation Reserve |
The following table describes data obtained by < Q_Report >.
XML Tab | Description |
---|---|
| General Ledger Account |
| Reserve Account |
| Sum of Report Cost |
| Currency Format for ACCT_COST |
| Sum of Report Deprecation Amount |
| Currency Format for D_ACCT_DEPRN |
| Sum of Report Year – To – Date Depreciation |
| Currency Format for Year – To – Date Depreciation |
| Sum of Report Depreciation Reserve |
| Currency Format for Depreciation Reserve |
The following table describes data obtained by < Q_Report >.
XML Tab | Description |
---|---|
| Cost Center |
| Sum of Report Cost |
| Currency Format for ACCT_COST |
| Sum of Report Deprecation Amount |
| Currency Format for D_ACCT_DEPRN |
| Sum of Report Year – To – Date Depreciation |
| Currency Format for Year – To – Date Depreciation |
| Sum of Report Depreciation Reserve |
| Currency Format for Depreciation Reserve |
The following table describes data obtained by < Q_Report >
XML Tab | Description |
---|---|
| Asset Number |
| Start Date |
| Method |
| Adjustment Rate |
| Bonus Rate |
| Capacity |
| Life |
| Currency format for Life |
| Cost |
| Deprecation Amount |
| Year – To – Date Depreciation |
| Depreciation Reserve |
| Percent |
| Transaction Type |
| Currency format for cost |
| Currency format for Depreciation |
| Currency format for Year – To – Date Depreciation |
| Currency format for Depreciation Reserve |
This extract provides a list of Fixed Asset Transactions within a specific Period. Some of the amounts reported in this register are subject to complex calculations.
Parameter Name | Description | Displayed | Required | Default Value | List of Values |
---|---|---|---|---|---|
P_BOOK_NAME | Asset Book | Y | Y | N | Y |
P_FROM_PERIOD | Starting Period | Y | Y | N | Y |
P_TO_PERIOD | Ending Period
Note: From Period and To Period has to be within a fiscal year. | Y | Y | N | Y |
The Assets CIP Statistics extract generates the following groups.
G_SETUP
G_SOURCE
G_COMPANY
G_ASSET_TYPE
G_ACCOUNT
G_COST_CENTER
G_ASSET G_DETAIL
The following table describes data obtained by < Q_SETUP >.
XML Tag | Description |
---|---|
| Company Name |
| Asset Book |
| Account Flex Structure |
| Distribution Source Book |
| Precision |
| Currency Code |
| From Period |
| To Period |
The following table describes data obtained by <Q_ASSET>.
XML Tag | Description |
---|---|
| Source |
The following table describes data obtained by < Q_ASSET >.
XML Tag | Description |
---|---|
| Company Code |
The following table describes data obtained by < Q_ASSET >.
XML Tag | Description |
---|---|
| Asset Type Description |
| Asset Type |
The following table describes data obtained by < Q_ASSET >.
XML Tag | Description |
---|---|
| Account |
The following table describes data obtained by < Q_ASSET >.
XML Tag | Description |
---|---|
| Cost Center |
The following table describes data obtained by < Q_ASSET >.
XML Tag | Description |
---|---|
| Asset Number |
| Asset |
The following table describes data obtained by < Q_ASSET >.
XML Tag | Description |
---|---|
| Order By |
| Vendor Number |
| Vendor Name |
| Invoice Number |
| Line Number |
| Description |
| Original Cost |
| Cost |
| Invoice |
| Cost Flag |
| Transaction Date |
| Addition Type |
| Industry Code |
| Statistical Code |
| Tariff Number |
| Item Number |
| Reserve |
This extract shows information related to asset retirements, grouping data by gain or loss or identifying free retirements as part of legal requirements of various countries.
Parameter Name | Description | Displayed | Required | Default Value | List of Values |
---|---|---|---|---|---|
P_BOOK_NAME | Asset Book | Y | Y | N | Y |
P_FROM_PERIOD | Starting Period | Y | Y | N | Y |
P_TO_PERIOD | Ending Period
Note: From Period and To Period has to be within a fiscal year. | Y | Y | N | Y |
The Asset Retirement Tax Register extract generates the following groups.
GAIN
LOSS
FREE_OF_CHARGE
The following table describes data obtained by <Q_GAIN>.
XML Tag | Description |
---|---|
| Asset Name |
| Asset Identifier |
| Life in months |
| Life in months |
| Life in months |
| Asset Number |
| Date Placed in service |
| Retirement Date |
| Actual Life |
| Proceeds of sale |
| Cost Of Removal |
| Net Book Value |
| Gain Amount |
| Loss Amount |
| Write Off Time |
| Write Off Amount |
The following table describes data obtained by <Q_LOSS>.
XML Tag | Description |
---|---|
| Asset Identifier |
| Asset Name |
| Asset Number |
| Date Placed in service |
| Retirement Date |
| Actual Life |
| Proceeds of sale |
| Cost Of Removal |
| Net Book Value |
| Gain Amount |
| Loss Amount |
| Write Off Time |
| Write Off Amount |
The following table describes data obtained by <Q_FREE_OF_CHARGE>.
XML Tag | Description |
---|---|
| Asset Description |
| Asset ID |
| Asset Number |
| Date Placed in Service |
| Retirement Date |
| Actual Life |
| Proceeds of sale |
| Cost Of Removal |
| Net Book Value |
| Gain Amount |
| Loss Amount |
| Write Off Time |
| Write Off Amount |
This extract satisfies the income tax reporting requirements for each period. It displays financial and descriptive information from each asset.
Parameter Name | Description | Displayed | Required | Default Value | List of Values |
---|---|---|---|---|---|
P_BOOK_NAME | Asset Book | Y | Y | N | Y |
P_LEDGER_ID | Ledger ID | Y | Y | N | Y |
P_LEGAL_ENTITY | Legal Entity ID | Y | Y | N | Y |
P_BEGIN_PERIOD | Starting Period | Y | Y | N | Y |
P_END_PERIOD | Ending Period
Note: From Period and To Period has to be within a fiscal year. | Y | Y | N | Y |
The Tofes Yud Alef-1342-Report (Israel) extract generates the following groups.
G_ASSET_TOT
G_RETIRE_TOT
G_RETIRE_TOT_SUB
G_SELFCOMPANY
The following table describes data obtained by < Q_ASSET >.
XML Tag | Description |
---|---|
| Asset Number |
| Asset Description |
| Major Category |
| Minor Category |
| Purchase Date |
| Date Placed in Service |
| Asset Cost |
| Transaction Amount |
| Depreciation Date |
| Depreciation Claim Rate |
| Year-to-date Depreciation Amount |
| Depreciation up to previous period that was selected to run report |
The following table describes data obtained by < Q_RETIRE >.
XML Tag | Description |
---|---|
| Asset Number |
| Asset Description |
| Major Category |
| Minor Category |
| Purchase Date |
| Date Placed In Service |
| Asset Cost |
| Transaction Amount |
| Depreciation Date |
| Depreciation Claim Rate |
| Year-to-Date Depreciation Amount |
| Depreciation up to previous period that was selected to run report |
The following table describes data obtained by < Q_RETIRE >.
XML Tag | Description |
---|---|
| Asset Cost |
| Transaction Amount |
| Depreciation Date |
| Depreciation Claim Rate |
| Year to date depreciation Amount |
| Depreciation up to previous period than selected to run report |
The following table describes data obtained by < Q_RETIRE >.
XML Tag | Description |
---|---|
| Company Name |
| Currency Code |
| Enterprise Name |
| Tax Payer Identifier |
| Tax Office Number |
| Book Type Code |
| Boom Type Name |
| Tax Year |
This extract lets you print a hard copy of the tax register. It displays all recoverable cost and depreciation amount of corresponding depreciation group, during the period assigned to the depreciation book.
Depreciation Summary Tax Extract contains 2 mandatory parameters - Asset Book and Period. Report will run based on the values passed for Asset Book and Period.
Parameter Name | Description | Displayed | Required | Default Value | List of Values |
---|---|---|---|---|---|
Asset Book | Asset Book Name | Y | Y | N | Y |
Period | Period from Book | Y | Y | N | Y |
The Depreciation Summary Tax extract generates the following groups.
DEPRN_AMOUNT
The following table describes data obtained by < Q_DEPRN_AMOUNT >:
XML Tag | Description |
---|---|
| Depreciation Group |
| Recoverable Cost/Tangible Assets |
| Recoverable Cost/Tangible Assets |
| Depreciation Amount/Tangible Assets/During the Period |
| Depreciation Amount/Tangible Assets/During the Year |
| Depreciation Amount/Intangible Assets/During the Period |
| Depreciation Amount/Intangible Assets/During the Year |
Copyright © 1988, 2010, Oracle and/or its affiliates. All rights reserved.