AMASTBKTRF

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


UPDATED BY
AM135 AM154 AM30.1 AM30.2 AM300 AM310
AM520 AC160 AM115 AM117 AM125 AM15.1
AM15.2 AM15.3 AM15.4 AM170 AM19.1 AM19.2
AM20.1 AM20.2 AM20.3 AM20.4 AM20.5 AM20.6
AM21.1 AM21.2 AM21.3 AM21.4 AM21.5 AM21.6
AM22.1 AM22.2 AM330 AM500 AM551 AM96.1
AM98.1 AP115 AP125 AP126 AP131 AP20.1
AP20.2 AP20.3 AP20.4 AP20.5 AP20.7 AP21.1
AP220 AP23.1 AP25.1 AP25.2 AP26.1 AP27.1
AP30.2 AP30.4 AP305 AP510 API1.1 API2.1
CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220
CX30.1 CX300 CX506 CXCP.1 DR100 IC12.1
IC140 IC141 IC142 IC145 IC243 IC330
IC64.1 IC64.2 IC64.3 IC64.4 IC64.5 IC64.6
IC64.7 IC64.8 IC64.9 IC66.1 IC83.1 MA126
MA180 MA278 MA41.1 MA41.2 MA41.4 MA41.7
MA42.1 MA42.2 MA43.1 MA43.2 MA43.3 MA43.4
MA43.6 MA43.7 MA44.1 MA44.2 MA53.1 MA530
MA531 MA60.2 MA60.3 MA60.5 MA61.1 MA63.1
MA65.1 MA66.2 MA67.2 MA67.3 MA68.2 MA68.3
MA68.5 MA69.1 MA70.1 MA75.1 MA80.1 MAI1.1
PD10.1 PD10.2 PD130 PD20.1 PD20.2 PD20.3
PD570 PO04.1 PO04.2 PO10.1 PO10.2 PO100
PO101 PO115 PO120 PO122 PO131 PO132
PO136 PO15.1 PO15.2 PO15.4 PO150 PO17.1
PO190 PO20.1 PO20.6 PO20.9 PO204 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO22.3
PO22.4 PO220 PO222 PO224 PO225 PO229
PO23.1 PO230 PO234 PO24.1 PO25.1 PO25.5
PO25.6 PO25.7 PO251 PO26.3 PO26.7 PO26.9
PO27.2 PO27.3 PO27.4 PO275 PO276 PO277
PO28.2 PO280 PO29.1 PO30.1 PO30.2 PO30.3
PO30.4 PO300 PO31.1 PO31.2 PO32.2 PO32.4
PO33.1 PO34.1 PO35.1 PO36.1 PO36.2 PO38.1
PO39.1 PO39.2 PO44.1 PO50.1 PO52.1 PO520
PO536 PO54.5 POCP.1 POI3.1 POID.1 POII.1
POIJ.1 RQ01.1 RQ10.1 RQ10.2 RQ10.3 RQ10.4
RQ10.5 RQ11.1 RQ12.1 RQ13.1 RQ13.2 RQ35.1
RQ44.1 RQ500 RQ810 RQIB.1 RQIF.1 RQII.1
RQIJ.1 WH130 WH132 WH190 WH20.2 WH20.7
WH222 WH30.1 WH30.2 WH30.3 WH30.4 WH31.1
WH31.2 WH31.3 WH31.4 WH32.1 WH32.2 WH32.3
WH32.4 WH32.5 WH33.1 WH33.2 WH33.3 WH33.4
WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830

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.
AM135 AM154
AM30.1 AM30.2
ABT-TO-ASSET
Element: To Asset
Numeric 10
This is the to-asset for the transfer.
AM135 AM154
AM30.1 AM30.2
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.
AM135 AM154
AM30.1 AM30.2
AM520
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.
AM135 AM154
AM30.1 AM30.2
ABT-PROCESS-SEQ
Element: Process Sequence
Numeric 6
Key field. This is the sequence number for the transfer process.
AM135 AM154
AM30.1 AM30.2
ABT-BOOK-STATUS
Element: Book Status
Alpha 1
This field indicates the status of the book. Valid values are: A = Active I = Inactive
AM135 AM154
AM30.1 AM30.2
ABT-BOOK-CURR
Element: Book Curr
Alpha 5
AM135 AM154
AM30.1 AM30.2
ABT-TO-BOOK-CURR
Element: To Book Curr
Alpha 5
AM135 AM154
AM30.1 AM30.2
ABT-BOOK-CURR-ND
Element: Book Curr Nd
Numeric 1
AM135 AM154
AM30.1 AM30.2
ABT-TO-BK-CURR-ND
Element: To Bk Curr Nd
Numeric 1
AM135 AM154
AM30.1 AM30.2
ABT-LIFE
Element: Life
Numeric 4
This is the asset life in months.
AM135 AM154
AM30.1 AM30.2
ABT-LIFE-REM
Element: Life Remaining
Signed 7.3
This is the remaining life for the asset.
AM135 AM154
AM30.1 AM30.2
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.
AM135 AM154
AM30.1 AM30.2
ABT-FR-BOOK-BASIS
Element: Intl Amt
Signed 18.2
AM135 AM154
AM30.1 AM30.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.
AM135 AM154
AM30.1 AM30.2
ABT-METHOD
Element: Method
Alpha 10
This is the asset book depreciation method.
AM135 AM154
AM30.1 AM30.2
ABT-METH-SWITCHED
Element: Method Switched
Alpha 1
AM135 AM154
AM30.1 AM30.2
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.
AM135 AM154
AM30.1 AM30.2
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.
AM135 AM154
AM30.1 AM30.2
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
AM135 AM154
AM30.1 AM30.2
ABT-DEPR-STARTDATE
Depreciation Start
Date
Numeric 8 (yyyymmdd)
This is the date from which depreciation calculation begins.
AM135 AM154
AM30.1 AM30.2
ABT-LIFE-YEARS
Element: Life Years
Signed 5.2
This is the asset life in years.
AM135 AM154
AM30.1 AM30.2
ABT-STATUS-CP-CALC
Calculate Curr
Period Status
Alpha 1
This field indicates whether depreciation has been calculated for the current period.
AM135 AM154
AM30.1 AM30.2
ABT-LIFE-CP
Element: Life
Signed 5.3
This is the portion of the asset life for the current period.
AM135 AM154
AM30.1 AM30.2
ABT-TRAN-ND
Transaction Number
of Decimals
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
AM135 AM154
AM30.1 AM30.2
ABT-TO-TRAN-ND
Element: Acct Nd
Numeric 1
The number of decimal positions defined for the To-Book transaction currency.
AM135 AM154
AM30.1 AM30.2
ABT-DEPR-CP
Current Period
Depreciation
Signed 18.2
This is the depreciation amount for the current period for the from-asset.
AM135 AM154
AM30.1 AM30.2
ABT-FR-DEPR-CP
Element: Intl Amt
Signed 18.2
AM135 AM154
AM30.1 AM30.2
ABT-TO-DEPR-CP
To Current Period
Depreciation
Signed 18.2
This is the current period depreciation amount for the to-asset.
AM135 AM154
AM30.1 AM30.2
ABT-DEPR-CP-ALLOW
Curr Period Deprec
Allowed
Signed 18.2
This is the depreciation allowed for the from-asset in the current period.
AM135 AM154
AM30.1 AM30.2
ABT-FR-DP-CP-ALLOW
Element: Intl Amt
Signed 18.2
AM135 AM154
AM30.1 AM30.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.
AM135 AM154
AM30.1 AM30.2
ABT-DEPR-YTD
Year-to-Date
Depreciation
Signed 18.2
This is the year-to-date depreciation for the from-asset.
AM135 AM154
AM30.1 AM30.2
ABT-FR-DEPR-YTD
Element: Intl Amt
Signed 18.2
AM135 AM154
AM30.1 AM30.2
ABT-TO-DEPR-YTD
Element: To YTD Depreciation
Signed 18.2
This is the year-to-date depreciation for the to-asset.
AM135 AM154
AM30.1 AM30.2
ABT-DEPR-YTD-ALLOW
Year-to-Date Depr
Allowed
Signed 18.2
This is the year-to-date depreciation allowance for the from-asset.
AM135 AM154
AM30.1 AM30.2
ABT-FR-DP-YTD-ALLO
Element: Intl Amt
Signed 18.2
AM135 AM154
AM30.1 AM30.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.
AM135 AM154
AM30.1 AM30.2
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.
AM135 AM154
AM30.1 AM30.2
ABT-FR-DP-YTD-OVRD
Element: Intl Amt
Signed 18.2
AM135 AM154
AM30.1 AM30.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.
AM135 AM154
AM30.1 AM30.2
ABT-DEPR-LTD
Life-to-Date
Depreciation
Signed 18.2
This is the life-to-date depreciation for the from-asset.
AM135 AM154
AM30.1 AM30.2
ABT-FR-DEPR-LTD
Element: Intl Amt
Signed 18.2
AM135 AM154
AM30.1 AM30.2
ABT-TO-DEPR-LTD
Element: To LTD Depreciation
Signed 18.2
This is the life-to-date depreciation for the to-asset.
AM135 AM154
AM30.1 AM30.2
ABT-DEPR-LTD-ALLOW
Life-to-Date Deprec
Allowed
Signed 18.2
This is the life-to-date depreciation allowance for the from-asset.
AM135 AM154
AM30.1 AM30.2
ABT-FR-DP-LTD-ALLO
Element: Intl Amt
Signed 18.2
AM135 AM154
AM30.1 AM30.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.
AM135 AM154
AM30.1 AM30.2
ABT-LAST-CLOSE
Element: Last Close
Signed 18.2
This is the last closed balance for the from-asset.
AM135 AM154
AM30.1 AM30.2
ABT-FR-LAST-CLOSE
Element: Intl Amt
Signed 18.2
AM135 AM154
AM30.1 AM30.2
ABT-TO-LAST-CLOSE
Element: To-Asset Last Close
Signed 18.2
This is the last closed balance for the to-asset.
AM135 AM154
AM30.1 AM30.2
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.
AM135 AM154
AM30.1 AM30.2
ABT-INACT-YTD
Year-to-Date
Inactivity
Signed 5.3
This is the length of time an asset has been inactive year-to-date.
AM135 AM154
AM30.1 AM30.2
ABT-INACT-LTD
Life-to-Date
Inactivity
Signed 7.3
This is the time an asset has been inactive life-to-date.
AM135 AM154
AM30.1 AM30.2
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.
AM135 AM154
AM30.1 AM30.2
ABT-FR-SALV-VALUE
Element: Intl Amt
Signed 18.2
AM135 AM154
AM30.1 AM30.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.
AM135 AM154
AM30.1 AM30.2
ABT-BUS-PERCENT
Element: Business Percent
Signed 5.2
This is the business use percentage for the asset.
AM135 AM154
AM30.1 AM30.2
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.
AM135 AM154
AM30.1 AM30.2
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.
AM135 AM154
AM30.1 AM30.2
ABT-FR-YR1-EXP
Element: Intl Amt
Signed 18.2
AM135 AM154
AM30.1 AM30.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.
AM135 AM154
AM30.1 AM30.2
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.
AM135 AM154
AM30.1 AM30.2
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.
AM135 AM154
AM30.1 AM30.2
ABT-FR-TC-PROPERTY
Element: Intl Amt
Signed 18.2
AM135 AM154
AM30.1 AM30.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.
AM135 AM154
AM30.1 AM30.2
ABT-TAX-CREDIT
Element: Tax Credit
Signed 18.2
This is the tax credit amount for the from-asset.
AM135 AM154
AM30.1 AM30.2
ABT-FR-TAX-CREDIT
Element: Intl Amt
Signed 18.2
AM135 AM154
AM30.1 AM30.2
ABT-TO-TAX-CREDIT
Element: To Tax Credit
Signed 18.2
This is the tax credit amount for the to-asset.
AM135 AM154
AM30.1 AM30.2
ABT-INS-METHOD
Element: Insurance Method
Alpha 10
This is the insurance method for the asset.
AM135 AM154
AM30.1 AM30.2
ABT-INS-ACT-VAL
Actual Insurance
Value
Signed 18.2
This is the actual insurance value for the from-asset.
AM135 AM154
AM30.1 AM30.2
ABT-FR-INS-ACT-VAL
Element: Intl Amt
Signed 18.2
AM135 AM154
AM30.1 AM30.2
ABT-TO-INS-ACT-VAL
To Actual Insurance
Value
Signed 18.2
This is the actual insurance value for the to-asset.
AM135 AM154
AM30.1 AM30.2
ABT-INS-CMPTD-VAL
Computed Insurance
Value
Signed 18.2
This is the computed insurance value for the from-asset.
AM135 AM154
AM30.1 AM30.2
ABT-FR-INS-CMPTD
Element: Intl Amt
Signed 18.2
AM135 AM154
AM30.1 AM30.2
ABT-TO-INS-CMPTD
To Computed
Insurance Value
Signed 18.2
This is the computed insurance value for the to-asset.
AM135 AM154
AM30.1 AM30.2
ABT-RPL-METHOD
Element: Replacement Method
Alpha 10
This is the replacement method for the asset.
AM135 AM154
AM30.1 AM30.2
ABT-RPL-CMPTD-VAL
Computed
Replacement Value
Signed 18.2
This is the computed replacement value for the from-asset.
AM135 AM154
AM30.1 AM30.2
ABT-FR-RPL-CMPTD
Element: Intl Amt
Signed 18.2
AM135 AM154
AM30.1 AM30.2
ABT-TO-RPL-CMPTD
To Computed
Replacement Value
Signed 18.2
This is the computed replacement value for the to-asset.
AM135 AM154
AM30.1 AM30.2
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.


AMASTBKTRF FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ABTSET1 ASSET
PROCESS-SEQ
BOOK
...
AC160 AM115
AM117 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM155
AM170 AM19.1
AM19.2 AM190
AM192 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM22.1
ABTSET2 ASSET
BOOK
PROCESS-SEQ
AM230 AM281
AM310 AMDL.1
ABTSET3 ASSET
PROCESS-SEQ
TO-BOOK
BOOK
AM230 AM30.1


AMASTBKTRF FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Amasset AMASSET Not Required
ABT-ASSET->AST-ASSET
Amassettrf AMASSETTRF Not Required
ABT-ASSET->ATF-ASSET
ABT-PROCESS-SEQ->ATF-PROCESS-SEQ
Amastbook AMASTBOOK Required
ABT-ASSET->ASB-ASSET
ABT-BOOK->ASB-BOOK
Ambook AMBOOK Not Required
ABT-BOOK->AMB-BOOK
To Book AMBOOK Not Required
ABT-TO-BOOK->AMB-BOOK


File created: Thu Jun 09 02:05:00 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.