[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | FA_DEPRN_TAX_REP_ITF |
|---|---|
| Object Type: | TABLE |
| Owner: | FA |
| FND Design Data: |  OFA.FA_DEPRN_TAX_REP_ITF
|
| Subobject Name: | |
| Status: | VALID |
Depreciable Assets Tax Reports interim table
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| FA_DEPRN_TAX_REP_ITF_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
 REQUEST_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| REQUEST_ID | NUMBER | (15) | Yes | Concurrent request ID |
| YEAR | NUMBER | Reporting target year | ||
| ASSET_ID | NUMBER | (15) | Asset identification number | |
| ASSET_NUMBER | VARCHAR2 | (15) | User assigned asset number | |
| ASSET_DESCRIPTION | VARCHAR2 | (80) | Description of the asset | |
| NEW_USED | VARCHAR2 | (4) | Indicateds whether asset is new or used | |
| BOOK_TYPE_CODE | VARCHAR2 | (15) | Book name | |
| MINOR_CATEGORY | VARCHAR2 | (150) | Minor category value | |
| TAX_ASSET_TYPE | VARCHAR2 | (15) | First character of minor category value | |
| MINOR_CAT_DESC | VARCHAR2 | (240) | Description of Minor category value | |
| STATE | VARCHAR2 | (150) | State value of location Flexfield | |
| START_UNITS_ASSIGNED | NUMBER | Units assigned at prior date | ||
| END_UNITS_ASSIGNED | NUMBER | Units assigned at target date | ||
| START_COST | NUMBER | Cost at prior date | ||
| END_COST | NUMBER | Cost at target date | ||
| INCREASE_COST | NUMBER | Increase Cost for a year | ||
| DECREASE_COST | NUMBER | Decrease Cost for a year | ||
| THEORETICAL_NBV | NUMBER | Japan Theoretical logic calculated NBV | ||
| EVALUATED_NBV | NUMBER | Japan Evaluated logic calculated NBV | ||
| DATE_PLACED_IN_SERVICE | DATE | Date the asset placed in service | ||
| ERA_NAME_NUM | VARCHAR2 | (1) | Japan Imperial name code of date placed in service | |
| ADD_ERA_YEAR | NUMBER | Japan Imperial year of date placed in service | ||
| ADD_MONTH | NUMBER | Month of date placed in service | ||
| START_LIFE | NUMBER | Life at prior date | ||
| END_LIFE | NUMBER | Life at target date | ||
| THEORETICAL_RESIDUAL_RATE | NUMBER | Japan Theoretical logic residual rate | ||
| EVALUATED_RESIDUAL_RATE | NUMBER | Japan Evaluated logic residual rate | ||
| ADJUSTED_RATE | NUMBER | Actual rate used to calculate depreciation for flat-rate method | ||
| EXCEPTION_CODE | VARCHAR2 | (20) | Exception of tax standard code | |
| EXCEPTION_RATE | NUMBER | Exception of tax standard rate | ||
| THEORETICAL_TAXABLE_COST | NUMBER | Taxable standard cost for Theoretical NBV | ||
| EVALUATED_TAXABLE_COST | NUMBER | Taxable standard cost for Evaluated NBV | ||
| ALL_REASON_TYPE | VARCHAR2 | (30) | Reason type for Detail report by asset type(All) | |
| ALL_REASON_CODE | VARCHAR2 | (1) | Reason code for Detail report by asset type(All). 1:New Asset, 2:Used Asset, 3:Transfer in, 4: Other. | |
| ALL_DESCRIPTION | VARCHAR2 | (30) | Description for Detail report by asset type(All) | |
| ADDDEC_REASON_TYPE | VARCHAR2 | (30) | Reason type for Detail report by asset type Addition report or Decrease report | |
| ADDDEC_REASON_CODE | VARCHAR2 | (1) | Reason code for Detail report by asset type Addition report or Decrease report. if addition, 1:New Addition, 2:Used Addition, 3:Transfer in, 4:Other. if decrease, 1:Sale, 2:Retirement, 3:Transfer out, 4:Other. | |
| DEC_TYPE | VARCHAR2 | (1) | Decrease Type for Detail Report by Asset Type (Decrease Assets) Report, 1: All, 2: Partial | |
| ADDDEC_DESCRIPTION | VARCHAR2 | (30) | Description for Detail report by asset type Addition report or Decrease report | |
| ADD_DEC_FLAG | VARCHAR2 | (1) | Addition or Dercrease flag. A:Addition, D:Decrease. | |
| CREATED_BY | NUMBER | (15) | Yes | Standard who column |
| CREATION_DATE | DATE | Yes | Standard who column | |
| LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
| FUNCTIONAL_CURRENCY_CODE | VARCHAR2 | (15) | Functional currency code from GL set of book | |
| ORGANIZATION_NAME | VARCHAR2 | (80) | Company name of system controls |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_ID
, YEAR
, ASSET_ID
, ASSET_NUMBER
, ASSET_DESCRIPTION
, NEW_USED
, BOOK_TYPE_CODE
, MINOR_CATEGORY
, TAX_ASSET_TYPE
, MINOR_CAT_DESC
, STATE
, START_UNITS_ASSIGNED
, END_UNITS_ASSIGNED
, START_COST
, END_COST
, INCREASE_COST
, DECREASE_COST
, THEORETICAL_NBV
, EVALUATED_NBV
, DATE_PLACED_IN_SERVICE
, ERA_NAME_NUM
, ADD_ERA_YEAR
, ADD_MONTH
, START_LIFE
, END_LIFE
, THEORETICAL_RESIDUAL_RATE
, EVALUATED_RESIDUAL_RATE
, ADJUSTED_RATE
, EXCEPTION_CODE
, EXCEPTION_RATE
, THEORETICAL_TAXABLE_COST
, EVALUATED_TAXABLE_COST
, ALL_REASON_TYPE
, ALL_REASON_CODE
, ALL_DESCRIPTION
, ADDDEC_REASON_TYPE
, ADDDEC_REASON_CODE
, DEC_TYPE
, ADDDEC_DESCRIPTION
, ADD_DEC_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, FUNCTIONAL_CURRENCY_CODE
, ORGANIZATION_NAME
FROM FA.FA_DEPRN_TAX_REP_ITF;
FA.FA_DEPRN_TAX_REP_ITF does not reference any database object
FA.FA_DEPRN_TAX_REP_ITF is referenced by following:
FA
FA_DEPRN_TAX_REP_ITF#
|
|
|
|