Oracle Assets Report Extracts
Oracle Assets Tax Accounting Card Extract
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.
Parameters
| 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 |
Data Output
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
< MAIN_COMMON_INFO >
The following table describes data obtained by <Q_COMMON_INFORMATION>.
| XML Tag | Description |
|---|---|
<MAIN_ASSET_CATEGORY>Vehicle-Owned Luxury-TA-1\-2 years</MAIN_ASSET_CATEGORY> |
Asset Main Category |
<MAIN_ASSET_ID>108644</MAIN_ASSET_ID> |
Asset Identifier |
<COMPANY_NAME>VISION ENTERPRISES</COMPANY_NAME> |
Company Name |
<CURRENCY>RUR</CURRENCY> |
Currency |
< COMMON_INFO >
The following table describes data obtained by <Q_COMMON_INFORMATION>:
| XML Tag | Description |
|---|---|
<ASSET_NAME>test report</ASSET_NAME> |
Asset Description |
<ASSET_NUMBER>MATEST2</ASSET_NUMBER> |
Asset Number |
<DATE_PLACED_IN_SERVICE>2003-06-30T00:00:00.000-07:00</DATE_PLACED_IN_SERVICE> |
Date Placed in Service |
<STATE_REGSTRATION_FILING_DATE>12-DEC-2005</STATE_REGISTRATION_FILING_DATE> |
State Registration Filing Date |
<PRORATE_DATE>2003-07-01T00:00:00.000-07:00</PRORATE_DATE> |
Prorate Date |
<USEFUL_LIFE_MONTHS>13</USEFUL_LIFE_MONTHS> |
Useful Life, Months |
<ASSET_CATEGORY>Vehicle-Owned Luxury-TA-1\-2 years</ASSET_CATEGORY> |
Asset Category |
<DEPRECIATION_METHOD>NON_LIN_RU</DEPRECIATION_METHOD> |
Depreciation Method |
<RECOVERABLE_COST>0</RECOVERABLE_COST> |
Recoverable Cost |
<MONTHLY_AMOUNT_OF_DEPRECIATION>2922.85</MONTHLY_AMOUNT_OF_DEPRECIATION> |
Depreciation Amount in Last Depreciated Period |
<ACCUMULATED_DEPRECIATION>23382.85</ACCUMULATED_DEPRECIATION> |
Accumulated Depreciation |
<LAST_DEPRECIATION_PERIOD>08-03</LAST_DEPRECIATION_PERIOD> |
Last Depreciation Period |
< ASSIGN_LOC >
The following table describes data obtained by <Q_ASSIGNED_LOCATIONS>:
| XML Tag | Description |
|---|---|
<LOCATION>Germany-NONE-Berlin-Manufacturing</LOCATION> |
Location of the Asset |
<HOLDER_NAME>Aafjes, Mr. Bert B</HOLDER_NAME> |
Employee Name |
<EXPENSE_ACCOUNT>0110.000.910200.0000.00000.00000.0110</EXPENSE_ACCOUNT> |
Depreciation Expense Account |
<UNITS>1</UNITS> |
Asset Units |
<COST_SOURCE>
The following table describes data obtained by < Q_COST_SOURCE >
| XML Tag | Description |
|---|---|
<INVOICE_NUMBER>INV140</INVOICE_NUMBER> |
Invoice Number |
<LINE_NUMBER>1000</LINE_NUMBER> |
Line Number |
<INVOICE_DESCRIPTION>Invoice Description</INVOICE_DESCRIPTION> |
Invoice Description |
<ASSET_COST>0</ASSET_COST> |
Asset Cost from Invoice Line |
<TAX_BOOK_COST>0</TAX_BOOK_COST> |
Tax Book Cost |
< HIST_COST_CHANGES >
The following table describes data obtained by < Q_HISTORY_COST_CHANGES >
| XML Tag | Description |
|---|---|
<REFERENCE_NUMBER>128792</REFERENCE_NUMBER> |
Reference Number for Cost Transaction Changes |
|
|
Transaction Type for Cost Changes |
<PERIOD>06-03</PERIOD> |
Effective Date for Cost Changes |
<REFERENCE>1</REFERENCE> |
Reference |
<COST>0</COST> |
Asset Cost |
< ADJ_COEFF_USAGE_DETAILS >
The following table describes data obtained by < Q_ADJ_COEFF_USAGE_DETAILS >
| XML Tag | Description |
|---|---|
<TRANSACTION_ID>128792</TRANSACTION_ID> |
Transaction Identifier |
<EVENT>Started</EVENT> |
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. |
<EVENT_DATE>12-DEC-2005</EVENT_DATE> |
Data entered manually for adjusting coefficient usage details |
<ACCOUNTING_PERIOD_ACS>06-03</ACCOUNTING_PERIOD_ACS> |
Effective date for depreciation method changes |
<REFERENCE_ACS>test</REFERENCE_ACS> |
Data entered manually |
<APPLICATION_OF_ADJ_COEFF_ACS>ttt</APPLICATION_OF_ADJ_COEFF_ACS> |
Data entered manually |
<METHOD>NON_LIN_RU</METHOD> |
Depreciation method assigned to each asset |
<BASE_RATE_ACS>1.5555000000</BASE_RATE_ACS> |
Base Rate % |
<ADJUSTING_COEFF_ACS>0.3</ADJUSTING_COEFF_ACS> |
Adjusting Coefficient is the value used to calculate Event Type. |
< SUSPEND_DEPRN_DETAILS >
The following table describes data obtained by < Q_SUSPEND_DEPRN_DETAILS >
| XML Tag | Description |
|---|---|
<TYPE_OF_EVENT>Resuming</TYPE_OF_EVENT> |
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>12-DEC-2005</DATE_STARTED_STOPPED> |
Date Started/Stopped |
<FIRST_PERIOD>06-03</FIRST_PERIOD> |
Effective Date for transaction |
<REFERENCE_SD>test</REFERENCE_SD> |
Reference |
<SUSPEND_REASON>iii</SUSPEND_REASON> |
Suspend Reason |
<TRANSACTION_ID>128794</TRANSACTION_ID> |
Transaction Identifier |
Oracle Assets Reserve Ledger Extract
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.
Parameters
| 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 |
Data Output
The Reserve Ledger extract generates the following groups.
-
G_SETUP
-
G_DO_INSERT
-
G_COMPANY
-
G_ACCOUNT
-
G_COSTCTR
-
G_REPORT
< G_SETUP >
The following table describes data obtained by < Q_SETUP >.
| XML Tag | Description |
|---|---|
<COMPANY_NAME>VISION ENTERPRISE</COMPANY_NAME> |
Company Name |
<CATEGORY_FLEX_STRUCTURE>101</CATEGORY_FLEX_STRUCTURE> |
Category Flex Structure |
<LOCATION_FLEX_STRUCTURE>101</LOCATION_FLEX_STRUCTURE> |
Location Flex Structure |
<ASSET_KEY_FLEX_STRUCTURE>101</ASSET_KEY_FLEX_STRUCTURE> |
Asset Key Flex Structure |
<BOOK>OPS CORP</BOOK> |
Asset Book |
<ACCOUNTING_FLEX_STRUCTURE>101</ACCOUNTING_FLEX_STRUCTURE> |
Flex Structure |
<CURRENCY_CODE>USD</CURRENCY_CODE> |
Currency Code |
<PERIOD1>Jan-06</PERIOD1> |
Period |
<A_PARTIAL_RETIREMENT>P</A_PARTIAL_RETIREMENT> |
Partial Retirement |
<A_FULL_RETIREMENT>F</A_PARTIAL_RETIREMENT> |
Full Retirement |
<A_TRANSFER_OUT>T</A_TRANSFER_OUT> |
Transfer Out |
<A_NON_DEPRECIATE>N</A_NON_DEPRECIATE> |
Non Depreciate |
<A_RECLASS>R</A_RECLASS> |
Category Reclass |
<A_BONUS>B</A_BONUS> |
Bonus |
< G_DO_INSERT >
The following table describes data obtained by < Q_DO_INSERT >
| XML Tab | Description |
|---|---|
<C_DO_INSERT></C_DO_INSERT> |
Source |
< G_COMPANY >
The following table describes data obtained by < Q_REPORT >.
| XML Tab | Description |
|---|---|
<COMP_CODE>01</COMP_CODE> |
Company Code |
<CO_COST>133890353.66</CO_COST> |
Sum of Report Cost |
<D_CO_COST>1.3389035366000001E8</D_CO_COST> |
Currency format for CO_COST |
<CO_DEPRN>554607.52</CO_DEPRN> |
Sum of Report Deprecation Amount |
<D_CO_DEPRN>554607.5200000004</D_CO_DEPRN> |
Currency format for CO_DEPRN |
<CO_YTD_DEPRN>554607.52</CO_YTD_DEPRN> |
Sum of Report Year–To–Date Depreciation |
<D_CO_YTD_DEPRN>554607.5200000004</D_CO_YTD_DEPRN> |
Currency Format for Year–To–Date Depreciation |
<CO_DEPRN_RESERVE>47098823.79</CO_DEPRN_RESERVE> |
Sum of Report Depreciation Reserve |
<D_CO_DEPRN_RESERVE>4.709882378999992E7</CO_DEPRN_RESERVE> |
Currency Format for Depreciation Reserve |
< G_ACCOUNT >
The following table describes data obtained by < Q_Report >.
| XML Tab | Description |
|---|---|
<GL_ACCOUNT>7320</GL_ACCOUNT> |
General Ledger Account |
<RSV_ACCOUNT>1620</RSV_ACCOUNT> |
Reserve Account |
<ACCT_COST>8500000</ACCT_COST> |
Sum of Report Cost |
<D_ACCT_COST>8500000.0</D_ACCT_COST> |
Currency Format for ACCT_COST |
<ACCT_DEPRN>0</ACCT_DEPRN> |
Sum of Report Deprecation Amount |
<D_ACCT_DEPRN>0.0</D_ACCT_DEPRN> |
Currency Format for D_ACCT_DEPRN |
<ACCT_YTD_DEPRN>0</ACCT_YTD_DEPRN> |
Sum of Report Year – To – Date Depreciation |
<D_ACCT_YTD_DEPRN>0.0</D_ACCT_YTD_DEPRN> |
Currency Format for Year – To – Date Depreciation |
<ACCT_DEPRN_RESERVE>1188888.84</ACCT_DEPRN_RESERVE> |
Sum of Report Depreciation Reserve |
<D_ACCT_DEPRN_RESERVE>1188888.84</D_ACCT_DEPRN_RESERVE> |
Currency Format for Depreciation Reserve |
< G_COSTCTR >
The following table describes data obtained by < Q_Report >.
| XML Tab | Description |
|---|---|
<COST_CENTER>110</COST_CENTER> |
Cost Center |
< CC_COST>325000</CC_COST> |
Sum of Report Cost |
<D_CC_COST>325000.0</D_CC_COST> |
Currency Format for ACCT_COST |
<CC_DEPRN>2275</CC_DEPRN> |
Sum of Report Deprecation Amount |
<D_CC_DEPRN>2275.0</D_CC_DEPRN> |
Currency Format for D_ACCT_DEPRN |
<C_YTD_DEPRN 2275</CC_YTD_DEPRN> |
Sum of Report Year – To – Date Depreciation |
<D_CC_YTD_DEPRN>2275.0</D_CC_YTD_DEPRN> |
Currency Format for Year – To – Date Depreciation |
<CC_DEPRN_RESERVE>234424.99</CC_DEPRN_RESERVE> |
Sum of Report Depreciation Reserve |
<D_CC_DEPRN_RESERVE>234424.99</D_CC_DEPRN_RESERVE> |
Currency Format for Depreciation Reserve |
< G_REPORT >
The following table describes data obtained by < Q_Report >
| XML Tab | Description |
|---|---|
<ASSET_NUMBER>100625-CAPITALIZABLE SERVICES - CAPITALIZABLE NON-TAXABLE SERVICES</ASSET_NUMBER> |
Asset Number |
<START_DATE>1998-09-30T00:00:00.000-07:00</START_DATE> |
Start Date |
<METHOD>STL</METHOD > |
Method |
<ADJ_RATE>10</ADJ_RATE> |
Adjustment Rate |
<BONUS_RATE>0< /BONUS_RATE> |
Bonus Rate |
<PROD>1000</PROD> |
Capacity |
<LIFE>120</LIFE> |
Life |
<D_LIFE>10.00</D_LIFE> |
Currency format for Life |
<COST>3450</COST> |
Cost |
<DEPRN_AMOUNT>166.67</DEPRN_AMOUNT> |
Deprecation Amount |
<YTD_DEPRN>166.67</YTD_DEPRN> |
Year – To – Date Depreciation |
< DEPRN_RESERVE>11833.33</DEPRN_RESERVE> |
Depreciation Reserve |
<PERCENT>100</PERCENT> |
Percent |
<T_TYPE>T</T_TYPE> |
Transaction Type |
<D_COST>20000.0</D_COST> |
Currency format for cost |
<D_DEPRN>166.67</D_DEPRN> |
Currency format for Depreciation |
<D_YTD_DEPRN >166.67</D_YTD_DEPRN> |
Currency format for Year – To – Date Depreciation |
<D_DEPRN_RESERVE>11833.33</D_DEPRN_RESERVE> |
Currency format for Depreciation Reserve |
Oracle Assets CIP Statistics Extract
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.
Parameters
| 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 |
Data Output
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
< G_SETUP >
The following table describes data obtained by < Q_SETUP >.
| XML Tag | Description |
|---|---|
<COMPANY_NAME>VISION ENTERPRISES</COMPANY_NAME> |
Company Name |
<BOOK>OPS CORP</BOOK> |
Asset Book |
<ACCOUNTING_FLEX_STRUCTURE>101</ACCOUNTING_FLEX_STRUCTURE> |
Account Flex Structure |
<DISTRIBUTION_SOURCE_BOOK>OPS CORP</DISTRIBUTION_SOURCE_BOOK> |
Distribution Source Book |
<PRECISION>.00</PRECISION> |
Precision |
<CURRENCY_CODE>USD</CURRENCY_CODE> |
Currency Code |
<PERIOD1>Jan-06</PERIOD1> |
From Period |
<PERIOD2>Jul-06</PERIOD2> |
To Period |
< G_SOURCE >
The following table describes data obtained by <Q_ASSET>.
| XML Tag | Description |
|---|---|
<SOURCE>Manual Transactions</SOURCE> |
Source |
< G_COMPANY >
The following table describes data obtained by < Q_ASSET >.
| XML Tag | Description |
|---|---|
<COMP_CODE>01</COMP_CODE> |
Company Code |
< G_ASSET_TYPE >
The following table describes data obtained by < Q_ASSET >.
| XML Tag | Description |
|---|---|
<ASSET_TYPE_DESC>Group Asset</ASSET_TYPE_DESC> |
Asset Type Description |
<ASSET_TYPE>Group Asset</ASSET_TYPE> |
Asset Type |
< G_ACCOUNT >
The following table describes data obtained by < Q_ASSET >.
| XML Tag | Description |
|---|---|
<ACCOUNT>1540</ACCOUNT> |
Account |
< G_COST_CENTER >
The following table describes data obtained by < Q_ASSET >.
| XML Tag | Description |
|---|---|
<COST_CENTER>110</COST_CENTER> |
Cost Center |
< G_ASSET >
The following table describes data obtained by < Q_ASSET >.
| XML Tag | Description |
|---|---|
<ASSET_ORD>108272</ASSET_ORD> |
Asset Number |
<ASSET>108272 - GRP File Cabinets</ASSET> |
Asset |
< G_DETAIL >
The following table describes data obtained by < Q_ASSET >.
| XML Tag | Description |
|---|---|
<ORD_BY>2</ORD_BY> |
Order By |
<VEND_NUM>1013</VEND_NUM> |
Vendor Number |
<VEND_NAME>Advanced Network Devices</VEND_NAME> |
Vendor Name |
<INV_NUM>8765/2006</INV_NUM> |
Invoice Number |
<LINE_NUM>1</LINE_NUM> |
Line Number |
<DESCRIPTION>Vehicle</DESCRIPTION> |
Description |
<ORIG_COST>4000</ORIG_COST> |
Original Cost |
<COST>100</COST> |
Cost |
<INV_COST>4000</INV_COST> |
Invoice |
<FLAG>Y</FLAG> |
Cost Flag |
<TRANSACTION_DATE>2006-07-31T00:00:00.000-07:00</TRANSACTION_DATE> |
Transaction Date |
<ADDITION_TYPE>LIZING</ADDITION_TYPE> |
Addition Type |
<INDUSTRY_CODE>03</INDUSTRY_CODE> |
Industry Code |
<STATISTICAL_CODE>02</STATISTICAL_CODE> |
Statistical Code |
<TARIFF_NUMBER>78965432</TARIFF_NUMBER> |
Tariff Number |
<ITEM_NUMBER>456345</ITEM_NUMBER> |
Item Number |
<RESERVE>00000</RESERVE> |
Reserve |
Oracle Assets Retirement Tax Register Extract
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.
Parameters
| 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 |
Data Output
The Asset Retirement Tax Register extract generates the following groups.
-
GAIN
-
LOSS
-
FREE_OF_CHARGE
< GAIN >
The following table describes data obtained by <Q_GAIN>.
| XML Tag | Description |
|---|---|
<G_ASSET_NAME>VISION ENTERPRISES</G_ASSET_NAME> |
Asset Name |
<G_ASSET_ID>120</G_ASSET_ID> |
Asset Identifier |
<G_LIFE_IN_MONTHS>10</G_LIFE_IN_MONTHS> |
Life in months |
<LIFE_IN_MONTHS>10</LIFE_IN_MONTHS> |
Life in months |
<TEST_LIFE_IN_MONTHS>10</TEST_LIFE_IN_MONTHS> |
Life in months |
<G_ASSET_NUMBER>101</G_ASSET_NUMBER> |
Asset Number |
<G_DATE_PLACED_IN_SERVICE>Jan-06</G_DATE_PLACED_IN_SERVICE> |
Date Placed in service |
<G_RETIREMENT_DATE>Jul-06</G_RETIREMENT_DATE> |
Retirement Date |
<G_ACTUAL_LIFE>10</G_ACTUAL_LIFE> |
Actual Life |
<G_PROCEEDS_OF_SALE>0</G_PROCEEDS_OF_SALE> |
Proceeds of sale |
<G_COST_OF_REMOVAL>0</G_COST_OF_REMOVAL> |
Cost Of Removal |
<G_NET_BOOK_VALUE>9984.12</G_NET_BOOK_VALUE> |
Net Book Value |
<G_GAIN_AMOUNT>0</G_GAIN_AMOUNT> |
Gain Amount |
<G_LOSS_AMOUNT>9984.12</G_LOSS_AMOUNT> |
Loss Amount |
<G_WRITE_OFF_TIME>12.00</G_WRITE_OFF_TIME> |
Write Off Time |
<G_WRITE_OFF_AMOUNT>120.00</G_WRITE_OFF_AMOUNT> |
Write Off Amount |
< LOSS >
The following table describes data obtained by <Q_LOSS>.
| XML Tag | Description |
|---|---|
<L_ASSET_ID>120</L_ASSET_ID> |
Asset Identifier |
<L_ASSET_NAME>VISION ENTERPRISES</L_ASSET_NAME> |
Asset Name |
<L_ASSET_NUMBER>101</L_ASSET_NUMBER> |
Asset Number |
<L_DATE_PLACED_IN_SERVICE>Jan-06</L_DATE_PLACED_IN_SERVICE> |
Date Placed in service |
<L_RETIREMENT_DATE>Jul-06</L_RETIREMENT_DATE> |
Retirement Date |
<L_ACTUAL_LIFE>10</L_ACTUAL_LIFE> |
Actual Life |
<L_PROCEEDS_OF_SALE>0</L_PROCEEDS_OF_SALE> |
Proceeds of sale |
<L_COST_OF_REMOVAL>0</L_COST_OF_REMOVAL> |
Cost Of Removal |
<L_NET_BOOK_VALUE>9984.12</L_NET_BOOK_VALUE> |
Net Book Value |
<L_GAIN_AMOUNT>0</L_GAIN_AMOUNT> |
Gain Amount |
<L_LOSS_AMOUNT>9984.12</L_LOSS_AMOUNT> |
Loss Amount |
<L_WRITE_OFF_TIME>12.00</L_WRITE_OFF_TIME> |
Write Off Time |
<L_WRITE_OFF_AMOUNT>120.00</L_WRITE_OFF_AMOUNT> |
Write Off Amount |
< FREE_OF_CHARGE >
The following table describes data obtained by <Q_FREE_OF_CHARGE>.
| XML Tag | Description |
|---|---|
<F_ASSET_NAME>VISION ENTERPRISES</F_ASSET_NAME> |
Asset Description |
<F_ASSET_ID>120</F_ASSET_ID> |
Asset ID |
<F_ASSET_NUMBER>101</F_ASSET_NUMBER> |
Asset Number |
<F_DATE_PLACED_IN_SERVICE>Jan-06</F_DATE_PLACED_IN_SERVICE> |
Date Placed in Service |
<F_RETIREMENT_DATE>Jul-06</F_RETIREMENT_DATE> |
Retirement Date |
<F_ACTUAL_LIFE>10</F_ACTUAL_LIFE> |
Actual Life |
<F_PROCEEDS_OF_SALE>0</F_PROCEEDS_OF_SALE> |
Proceeds of sale |
<F_COST_OF_REMOVAL>0</F_COST_OF_REMOVAL> |
Cost Of Removal |
<F_NET_BOOK_VALUE>9984.12</F_NET_BOOK_VALUE> |
Net Book Value |
<F_GAIN_AMOUNT>0</F_GAIN_AMOUNT> |
Gain Amount |
<F_LOSS_AMOUNT>9984.12</F_LOSS_AMOUNT> |
Loss Amount |
<F_WRITE_OFF_TIME>12.00</F_WRITE_OFF_TIME> |
Write Off Time |
<F_WRITE_OFF_AMOUNT>120.00</F_WRITE_OFF_AMOUNT> |
Write Off Amount |
Oracle Assets Tofes Yud Alef Extract
This extract satisfies the income tax reporting requirements for each period. It displays financial and descriptive information from each asset.
Parameters
| 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 |
Data Output
The Tofes Yud Alef-1342-Report (Israel) extract generates the following groups.
-
G_ASSET_TOT
-
G_RETIRE_TOT
-
G_RETIRE_TOT_SUB
-
G_SELFCOMPANY
< G_ASSET_TOT >
The following table describes data obtained by < Q_ASSET >.
| XML Tag | Description |
|---|---|
<ASSET_NO>108070</ASSET_NO> |
Asset Number |
<ASSET_DESC>Toshiba Laptop</ASSET_DESC> |
Asset Description |
<MAJOR_CATEGORY>Values have not been entered for one or more required segments.</MAJOR_CATEGORY> |
Major Category |
<MINOR_CATEGORY>Values have not been entered for one or more required segments.</MINOR_CATEGORY> |
Minor Category |
<PURCHASE_DATE>2005-11-21T00:00:00.000-08:00</PURCHASE_DATE> |
Purchase Date |
<DATE_PLACED_IN_SERVICE>2005-11-21T00:00:00.000-08:00</DATE_PLACED_IN_SERVICE> |
Date Placed in Service |
<ORG_ASSET_COST>2876</ORG_ASSET_COST> |
Asset Cost |
<YTD_TRANS_AMOUNTS>0</YTD_TRANS_AMOUNTS> |
Transaction Amount |
<DEPR_OFF_RATE>33.33</DEPR_OFF_RATE> |
Depreciation Date |
<DEPR_CLAIM_RATE>3.64849899194413576323908600210316459654E01</DEPR_CLAIM_RATE> |
Depreciation Claim Rate |
<YTD_DEPR_AMT>639.11</YTD_DEPR_AMT> |
Year-to-date Depreciation Amount |
<ACCUM_DEPR_PRIOR_YR>0</ACCUM_DEPR_PRIOR_YR> |
Depreciation up to previous period that was selected to run report |
< G_RETIRE_TOT >
The following table describes data obtained by < Q_RETIRE >.
| XML Tag | Description |
|---|---|
<ASSET_NO>108070</ASSET_NO> |
Asset Number |
<ASSET_DESC>Toshiba Laptop</ASSET_DESC> |
Asset Description |
<MAJOR_CATEGORY>Values have not been entered for one or more required segments.</MAJOR_CATEGORY> |
Major Category |
<MINOR_CATEGORY>Values have not been entered for one or more required segments.</MINOR_CATEGORY> |
Minor Category |
<PURCHASE_DATE>2005-11-21T00:00:00.000-08:00</PURCHASE_DATE> |
Purchase Date |
<DATE_PLACED_IN_SERVICE>2005-11-21T00:00:00.000-08:00</DATE_PLACED_IN_SERVICE> |
Date Placed In Service |
<ORG_ASSET_COST>2876</ORG_ASSET_COST> |
Asset Cost |
<YTD_TRANS_AMOUNTS>0</YTD_TRANS_AMOUNTS> |
Transaction Amount |
<DEPR_OFF_RATE>33.33</DEPR_OFF_RATE> |
Depreciation Date |
<DEPR_CLAIM_RATE>3.64849899194413576323908600210316459654E01</DEPR_CLAIM_RATE> |
Depreciation Claim Rate |
<YTD_DEPR_AMT>639.11</YTD_DEPR_AMT> |
Year-to-Date Depreciation Amount |
<ACCUM_DEPR_PRIOR_YR>0</ACCUM_DEPR_PRIOR_YR> |
Depreciation up to previous period that was selected to run report |
< G_RETIRE_TOT_SUB >
The following table describes data obtained by < Q_RETIRE >.
| XML Tag | Description |
|---|---|
<ORG_ASSET_COST_SUB>2876</ORG_ASSET_COST_SUB> |
Asset Cost |
<YTD_TRANS_AMOUNTS_SUBC>0</YTD_TRANS_AMOUNTS_SUB> |
Transaction Amount |
<DEPR_OFF_RATE_SUB>33.33</DEPR_OFF_RATE_SUB> |
Depreciation Date |
<DEPR_CLAIM_RATE_SUB>3.64849899194413576323908600210316459654E01</DEPR_CLAIM_RATE_SUB> |
Depreciation Claim Rate |
<YTD_DEPR_AMOUNT_SUB>639.11</YTD_DEPR_AMOUNT_SUB> |
Year to date depreciation Amount |
<ACCUM_DEPR_PRIOR_YR_SUB>0</ACCUM_DEPR_PRIOR_YR_SUB> |
Depreciation up to previous period than selected to run report |
< G_RETIRE_TOT_SUB >
The following table describes data obtained by < Q_RETIRE >.
| XML Tag | Description |
|---|---|
<COMPANY_NAME>Vison Operations (USA)</COMPANY_NAME> |
Company Name |
<CURRENCY_CODE>USD</CURRENCY_CODE> |
Currency Code |
<ENTERPRISE_NAME>Vision Operations</ENTERPRISE_NAME> |
Enterprise Name |
<TAXPAYER_ID>10</TAXPAYER_ID> |
Tax Payer Identifier |
<TAX_OFFICER_NUMBER>100</TAX_OFFICER_NUMBER> |
Tax Office Number |
<BOOK_TYPE_CODE>OPS CORP</BOOK_TYPE_CODE> |
Book Type Code |
<BOOK_TYPE_NAME>OPERATIONS CORPORATE BOOK</BOOK_TYPE_NAME> |
Boom Type Name |
<TAX_YEAR>2006</TAX_YEAR> |
Tax Year |
Oracle Assets Depreciation Summary Tax Extract
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.
Parameters
| 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 |
Data Output
The Depreciation Summary Tax extract generates the following groups.
-
DEPRN_AMOUNT
< DEPRN_AMOUNT >
The following table describes data obtained by < Q_DEPRN_AMOUNT >:
| XML Tag | Description |
|---|---|
<DEPRN_GROUP>Intangible Assets</DEPRN_GROUP> |
Depreciation Group |
<RECOV_COST_TA>0</RECOV_COST_TA> |
Recoverable Cost/Tangible Assets |
<RECOV_COST_ITA>5000</RECOV_COST_ITA> |
Recoverable Cost/Tangible Assets |
<DEP_AMT_TA_PTD>0</DEP_AMT_TA_PTD> |
Depreciation Amount/Tangible Assets/During the Period |
<DEP_AMT_TA_YTD>0</DEP_AMT_TA_YTD> |
Depreciation Amount/Tangible Assets/During the Year |
<DEP_AMT_ITA_PTD>189.4</DEP_AMT_ITA_PTD> |
Depreciation Amount/Intangible Assets/During the Period |
<DEP_AMT_ITA_YTD>568.2</DEP_AMT_ITA_YTD> |
Depreciation Amount/Intangible Assets/During the Year |