Asset Book Transfer
This file contains historical asset book information related to transfers.
REFERENCED BY
AM145 | AM155 | AM190 | AM192 | AM230 | AM281 |
AM40.1 | AM40.2 | AM40.3 | AM40.4 | AM41.1 | AM41.2 |
AM502 | AM92.1 | AMDL.1 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||
---|---|---|---|---|---|---|---|---|
ABT-ASSET Element: Asset | Numeric 10 Key field. The asset number contains up to ten numeric characters that uniquely identify an asset. Assets are automatically numbered system-wide. |
|
||||||
ABT-TO-ASSET Element: To Asset | Numeric 10 This is the to-asset for the transfer. |
|
||||||
ABT-BOOK Element: Book | Alpha 10 Key field. This is a user-defined book name. Books are used by assets for calculating depreciation, replacement cost, and insurance values, and for reporting. |
|
||||||
ABT-TO-BOOK Element: To Book | Alpha 10 Key field. This is a user-defined book name. Books are used by assets for calculating depreciation, replacement cost, and insurance values, and for reporting. |
|
||||||
ABT-PROCESS-SEQ Element: Process Sequence | Numeric 6 Key field. This is the sequence number for the transfer process. |
|
||||||
ABT-BOOK-STATUS Element: Book Status | Alpha 1 This field indicates the status of the book. Valid values are: A = Active I = Inactive |
|
||||||
ABT-BOOK-CURR Element: Book Curr | Alpha 5 |
|
||||||
ABT-TO-BOOK-CURR Element: To Book Curr | Alpha 5 |
|
||||||
ABT-BOOK-CURR-ND Element: Book Curr Nd | Numeric 1 |
|
||||||
ABT-TO-BK-CURR-ND Element: To Bk Curr Nd | Numeric 1 |
|
||||||
ABT-LIFE Element: Life | Numeric 4 This is the asset life in months. |
|
||||||
ABT-LIFE-REM Element: Life Remaining | Signed 7.3 This is the remaining life for the asset. |
|
||||||
ABT-BOOK-BASIS Element: Book Basis | Signed 18.2 This field contains the amount on which the depreciation calculations for the book are based. Note: The depreciation basis amount can be different for each depreciation book used. |
|
||||||
ABT-FR-BOOK-BASIS Element: Intl Amt | Signed 18.2 |
|
||||||
ABT-TO-BOOK-BASIS Element: To Book Basis | Signed 18.2 This field contains the amount on which the depreciation calculations for the transfer-to asset book are based. |
|
||||||
ABT-METHOD Element: Method | Alpha 10 This is the asset book depreciation method. |
|
||||||
ABT-METH-SWITCHED Element: Method Switched | Alpha 1 |
|
||||||
ABT-INSRV-DATE Element: In Service Date | Numeric 8 (yyyymmdd) This is the in-service date for the asset. Note: The in-service date can be different for each depreciation book used. |
|
||||||
ABT-METH-TABLE-YR Element: Method Table Year | Numeric 2 This field indicates what year of its life an asset is in. Various tables use this year in their calculations. |
|
||||||
ABT-CONVENTION Element: Convention | Alpha 2 This is the in-service convention for the asset, which determines the amount of depreciation it receives in its first and last years in service. Valid values are: FM = Full Month HM = Modified Half Month AD = Actual Days HY = Half Year MY = Modified Half Year MQ = Mid Quarter MM = Mid Month FY = Full Month NM = Next Month |
|
||||||
ABT-DEPR-STARTDATE Depreciation Start Date | Numeric 8 (yyyymmdd) This is the date from which depreciation calculation begins. |
|
||||||
ABT-LIFE-YEARS Element: Life Years | Signed 5.2 This is the asset life in years. |
|
||||||
ABT-STATUS-CP-CALC Calculate Curr Period Status | Alpha 1 This field indicates whether depreciation has been calculated for the current period. |
|
||||||
ABT-LIFE-CP Element: Life | Signed 5.3 This is the portion of the asset life for the current period. |
|
||||||
ABT-TRAN-ND Transaction Number of Decimals | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
||||||
ABT-TO-TRAN-ND Element: Acct Nd | Numeric 1 The number of decimal positions defined for the To-Book transaction currency. |
|
||||||
ABT-DEPR-CP Current Period Depreciation | Signed 18.2 This is the depreciation amount for the current period for the from-asset. |
|
||||||
ABT-FR-DEPR-CP Element: Intl Amt | Signed 18.2 |
|
||||||
ABT-TO-DEPR-CP To Current Period Depreciation | Signed 18.2 This is the current period depreciation amount for the to-asset. |
|
||||||
ABT-DEPR-CP-ALLOW Curr Period Deprec Allowed | Signed 18.2 This is the depreciation allowed for the from-asset in the current period. |
|
||||||
ABT-FR-DP-CP-ALLOW Element: Intl Amt | Signed 18.2 |
|
||||||
ABT-TO-DP-CP-ALLOW To Current Period Depr Allowed | Signed 18.2 This is the depreciation allowed in the current period for the to-asset. |
|
||||||
ABT-DEPR-YTD Year-to-Date Depreciation | Signed 18.2 This is the year-to-date depreciation for the from-asset. |
|
||||||
ABT-FR-DEPR-YTD Element: Intl Amt | Signed 18.2 |
|
||||||
ABT-TO-DEPR-YTD Element: To YTD Depreciation | Signed 18.2 This is the year-to-date depreciation for the to-asset. |
|
||||||
ABT-DEPR-YTD-ALLOW Year-to-Date Depr Allowed | Signed 18.2 This is the year-to-date depreciation allowance for the from-asset. |
|
||||||
ABT-FR-DP-YTD-ALLO Element: Intl Amt | Signed 18.2 |
|
||||||
ABT-TO-DP-YTD-ALLO To YTD Depreciation Allowed | Signed 18.2 This is the year-to-date depreciation allowance for the to-asset. |
|
||||||
ABT-DEPR-YTD-OVRRD Year-to-Date Deprec Override | Signed 18.2 This is the year-to-date depreciation override amount for the from-asset. |
|
||||||
ABT-FR-DP-YTD-OVRD Element: Intl Amt | Signed 18.2 |
|
||||||
ABT-TO-DP-YTD-OVRD To YTD Depreciation Override | Signed 18.2 This is the year-to-date depreciation override amount for the to-asset. |
|
||||||
ABT-DEPR-LTD Life-to-Date Depreciation | Signed 18.2 This is the life-to-date depreciation for the from-asset. |
|
||||||
ABT-FR-DEPR-LTD Element: Intl Amt | Signed 18.2 |
|
||||||
ABT-TO-DEPR-LTD Element: To LTD Depreciation | Signed 18.2 This is the life-to-date depreciation for the to-asset. |
|
||||||
ABT-DEPR-LTD-ALLOW Life-to-Date Deprec Allowed | Signed 18.2 This is the life-to-date depreciation allowance for the from-asset. |
|
||||||
ABT-FR-DP-LTD-ALLO Element: Intl Amt | Signed 18.2 |
|
||||||
ABT-TO-DP-LTD-ALLO To LTD Depreciation Allowed | Signed 18.2 This is the life-to-date depreciation allowance for the to-asset. |
|
||||||
ABT-LAST-CLOSE Element: Last Close | Signed 18.2 This is the last closed balance for the from-asset. |
|
||||||
ABT-FR-LAST-CLOSE Element: Intl Amt | Signed 18.2 |
|
||||||
ABT-TO-LAST-CLOSE Element: To-Asset Last Close | Signed 18.2 This is the last closed balance for the to-asset. |
|
||||||
ABT-FIRST-LAST-FL Element: First/Last Flag | Alpha 1 This field is an internal, system-maintained value used to control depreciation calculations during the first and last years of an asset's life. Valid values are: F = First. This is the first in-service year for the asset. M = Middle. The asset is in a year other than the first or last. L = Last. This is the last in-service year for the asset. C = Completely Depreciated. The asset no longer participates in depreciation calculations. P = Post Recovery. The system continues to depreciate the asset beyond the original asset life. |
|
||||||
ABT-INACT-YTD Year-to-Date Inactivity | Signed 5.3 This is the length of time an asset has been inactive year-to-date. |
|
||||||
ABT-INACT-LTD Life-to-Date Inactivity | Signed 7.3 This is the time an asset has been inactive life-to-date. |
|
||||||
ABT-SALVAGE-VALUE Element: Salvage Value | Signed 18.2 This is the salvage value of the from-asset at the end of the asset's life. It can be zero. If the depreciation method is STL (Straight Line), the basis used for the depreciation calculation is the asset cost less this salvage value. If the depreciation method is 200DB (Double Declining Balance), 125 (125% Declining Balance), 150 (150% Declining Balance), or 175 (175% Declining Balance), the basis used for the depreciation calculation is the asset cost. Depreciation is taken until the total amount taken is equal to the asset cost less this salvage value. |
|
||||||
ABT-FR-SALV-VALUE Element: Intl Amt | Signed 18.2 |
|
||||||
ABT-TO-SALV-VALUE Element: To Salvage Value | Signed 18.2 This is the salvage value for the to-asset. If the depreciation method is Straight Line, the basis used for the depreciation calculation is the asset cost less this salvage value. If the depreciation method is 200DB (Double Declining Balance), 125 (125% Declining Balance), 150 (150% Declining Balance), or 175 (175% Declining Balance), the basis used for the depreciation calculation is the asset cost. Depreciation is taken until the total amount taken is equal to the asset cost less this salvage value. |
|
||||||
ABT-BUS-PERCENT Element: Business Percent | Signed 5.2 This is the business use percentage for the asset. |
|
||||||
ABT-PERSONAL-USE Element: Personal Use | Alpha 10 A personal use code defines the personal use options that asset books use to calculate depreciation, tax credits, and annual depreciation limits up to twenty years. The code is user-definable. |
|
||||||
ABT-YR1-EXP Element: First Year Expense | Signed 18.2 This is the new first year expense for the from-asset. It represents the amount to expense for the First Year Expense option. This U.S. tax option allows you to expense and not depreciate a total dollar amount for the assets of each eligible company. |
|
||||||
ABT-FR-YR1-EXP Element: Intl Amt | Signed 18.2 |
|
||||||
ABT-TO-YR1-EXP To First Year Expense | Signed 18.2 This is the new first year expense for the to-asset. This is the first year expense amount for the to-asset for the First Year Expense option. This U.S. tax option allows you to expense and not depreciate a total amount for the assets of each eligible company. |
|
||||||
ABT-TC-TABLE Element: Tax Credit Table | Alpha 10 A user-defined tax credit table, which defines tax credit percentages and annual tax credit recapture percentages for up to twenty years. Asset books use tax credit tables to calculate tax credits. |
|
||||||
ABT-TC-PROPERTY Element: Property Tax Credit | Signed 18.2 This is the tax credit amount for the from-asset, if you are taking a tax credit for used property. |
|
||||||
ABT-FR-TC-PROPERTY Element: Intl Amt | Signed 18.2 |
|
||||||
ABT-TO-TC-PROPERTY To Property Tax Credit | Signed 18.2 This is the tax credit amount for the to-asset, if you are taking a tax credit for used property. |
|
||||||
ABT-TAX-CREDIT Element: Tax Credit | Signed 18.2 This is the tax credit amount for the from-asset. |
|
||||||
ABT-FR-TAX-CREDIT Element: Intl Amt | Signed 18.2 |
|
||||||
ABT-TO-TAX-CREDIT Element: To Tax Credit | Signed 18.2 This is the tax credit amount for the to-asset. |
|
||||||
ABT-INS-METHOD Element: Insurance Method | Alpha 10 This is the insurance method for the asset. |
|
||||||
ABT-INS-ACT-VAL Actual Insurance Value | Signed 18.2 This is the actual insurance value for the from-asset. |
|
||||||
ABT-FR-INS-ACT-VAL Element: Intl Amt | Signed 18.2 |
|
||||||
ABT-TO-INS-ACT-VAL To Actual Insurance Value | Signed 18.2 This is the actual insurance value for the to-asset. |
|
||||||
ABT-INS-CMPTD-VAL Computed Insurance Value | Signed 18.2 This is the computed insurance value for the from-asset. |
|
||||||
ABT-FR-INS-CMPTD Element: Intl Amt | Signed 18.2 |
|
||||||
ABT-TO-INS-CMPTD To Computed Insurance Value | Signed 18.2 This is the computed insurance value for the to-asset. |
|
||||||
ABT-RPL-METHOD Element: Replacement Method | Alpha 10 This is the replacement method for the asset. |
|
||||||
ABT-RPL-CMPTD-VAL Computed Replacement Value | Signed 18.2 This is the computed replacement value for the from-asset. |
|
||||||
ABT-FR-RPL-CMPTD Element: Intl Amt | Signed 18.2 |
|
||||||
ABT-TO-RPL-CMPTD To Computed Replacement Value | Signed 18.2 This is the computed replacement value for the to-asset. |
|
||||||
ABT-TRF-TRF-DATE Element: Transfer Date | Derived This is the date of the transfer. |
|
||||||
ABT-TRF-FULL-PART Full or Partial Transfer | Derived This field shows whether the transfer is a full transfer (including all items) or a partial transfer (including only some items). |
|
||||||
ABT-TRF-TRF-TYPE Element: Transfer Type | Derived This field indicates the type of the transfer. |
|
||||||
ABT-AST-TAG-NBR Element: Tag Number | Derived This is the tag, a user-definable identifier, for the asset. |
|
||||||
ABT-TO-AST-TAG Element: To Tag Number | Derived This is the tag for the to-asset. |
|
||||||
ABT-AST-ASSET-GRP Element: Asset Group | Derived This is the asset group for the from-asset. |
|
||||||
ABT-TO-AST-GROUP Element: To Asset Group | Derived This is the asset group for the to-asset. |
|
||||||
ABT-BOOK-CURRENCY Element: Book Currency | Derived This is the currency for the book. |
|
||||||
ABT-TRF-CREAT-DATE Element: Creation Date | Derived This is the date the transfer was created. |
|
||||||
ABT-TRF-CREAT-TIME Element: Creation Time | Derived This is the time the transfer was created. |
|
||||||
ABT-TRF-CREATOR-ID Element: Creator ID | Derived This is the ID of the person who created the transfer. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ABTSET1 |
ASSET PROCESS-SEQ BOOK |
|
|||||||||||
ABTSET2 |
ASSET BOOK PROCESS-SEQ |
|
| ||||||||||
ABTSET3 |
ASSET PROCESS-SEQ TO-BOOK BOOK |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||
---|---|---|---|---|---|---|---|---|
Amasset | AMASSET |
Not Required
| ||||||
Amassettrf | AMASSETTRF |
Not Required
| ||||||
Amastbook | AMASTBOOK |
Required
| ||||||
Ambook | AMBOOK |
Not Required
| ||||||
To Book | AMBOOK |
Not Required
|
All trademarks and registered trademarks are the property of their
respective owners.