|
|
AMASTBKTRF FILE
Asset Book Transfer
This file contains historical asset book information related to transfers.
REFERENCED BY
AM145 AM190 AM192 AM230 AM40.1 AM40.2
AM40.3 AM40.4 AM41.1 AM41.2 AMDL.1
UPDATED BY
AM135 AM154 AM30.1 AM30.2 AM300 AM310
AM520 AM115 AM125 AM15.1 AM15.2 AM15.3
AM15.4 AM170 AM20.1 AM20.2 AM20.3 AM20.4
AM20.5 AM20.6 AM21.1 AM21.2 AM21.3 AM21.4
AM21.5 AM21.6 AM330 AM500 AM551 AM96.1
AM98.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ABT-ASSET Numeric 10 AM135 AM154
Element: Asset Key field. The asset number contains up AM30.1 AM30.2
to ten numeric characters that uniquely
identify an asset. Assets are
automatically numbered system-wide.
ABT-TO-ASSET Numeric 10 AM135 AM154
Element: To Asset This is the to-asset for the transfer. AM30.1 AM30.2
ABT-BOOK Alpha 10 AM135 AM154
Element: Book Key field. This is a user-defined book AM30.1 AM30.2
name. Books are used by assets for AM520
calculating depreciation, replacement
cost, and insurance values, and for
reporting.
ABT-PROCESS-SEQ Numeric 4 AM135 AM154
Element: Process SequenKey field. This is the sequence number AM30.1 AM30.2
for the transfer process.
ABT-BOOK-STATUS Alpha 1 AM135 AM154
Element: Book Status This field indicates the status of the AM30.1 AM30.2
book. Valid values are:
A = Active
I = Inactive
ABT-LIFE Numeric 4 AM135 AM154
Element: Life This is the asset life in months. AM30.1 AM30.2
ABT-LIFE-REM Signed 7.3 AM135 AM154
Element: Life RemainingThis is the remaining life for the AM30.1 AM30.2
asset.
ABT-BOOK-BASIS Signed 15.2 AM135 AM154
Element: Book Basis This field contains the amount on which AM30.1 AM30.2
the depreciation calculations for the
book are based.
Note: The depreciation basis amount can
be different for each depreciation book
used.
ABT-TO-BOOK-BASIS Signed 15.2 AM30.1 AM30.2
Element: To Book Basis This field contains the amount on which
the depreciation calculations for the
transfer-to asset book are based.
ABT-METHOD Alpha 10 AM135 AM154
Element: Method This is the asset book depreciation AM30.1 AM30.2
method.
ABT-METH-SWITCHED Alpha 1 AM135 AM154
Element: Method Switched AM30.1 AM30.2
ABT-INSRV-DATE Numeric 8 (yyyymmdd) AM135 AM154
Element: In Service DatThis is the in-service date for the AM30.1 AM30.2
asset.
Note: The in-service date can be
different for each depreciation book
used.
ABT-METH-TABLE-YR Numeric 2 AM135 AM154
Element: Method Table YThis field indicates what year of its AM30.1 AM30.2
life an asset is in. Various tables use
this year in their calculations.
ABT-CONVENTION Alpha 2 AM135 AM154
Element: Convention This is the in-service convention for AM30.1 AM30.2
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 Numeric 8 (yyyymmdd) AM135 AM154
Depreciation Start This is the date from which AM30.1 AM30.2
Date depreciation calculation begins.
ABT-LIFE-YEARS Signed 5.2 AM135 AM154
Element: Life Years This is the asset life in years. AM30.1 AM30.2
ABT-STATUS-CP-CALC Alpha 1 AM135 AM154
Calculate Curr This field indicates whether AM30.1 AM30.2
Period Status depreciation has been calculated for the
current period.
ABT-LIFE-CP Signed 5.3 AM135 AM154
Element: Life This is the portion of the asset life AM30.1 AM30.2
for the current period.
ABT-TRAN-ND Numeric 1 AM135 AM154
Transaction Number AM30.1 AM30.2
of Decimals
ABT-DEPR-CP Signed 15.2 AM135 AM154
Current Period This is the depreciation amount for the AM30.1 AM30.2
Depreciation current period for the from-asset.
ABT-TO-DEPR-CP Signed 15.2 AM135 AM154
To Current Period This is the current period depreciation AM30.1 AM30.2
Depreciation amount for the to-asset.
ABT-DEPR-CP-ALLOW Signed 15.2 AM135 AM154
Curr Period Deprec This is the depreciation allowed for AM30.1 AM30.2
Allowed the from-asset in the current period.
ABT-TO-DP-CP-ALLOW Signed 15.2 AM135 AM154
To Current Period This is the depreciation allowed in the AM30.1 AM30.2
Depr Allowed current period for the to-asset.
ABT-DEPR-YTD Signed 15.2 AM135 AM154
Year-to-Date This is the year-to-date depreciation AM30.1 AM30.2
Depreciation for the from-asset.
ABT-TO-DEPR-YTD Signed 15.2 AM135 AM154
Element: To YTD DepreciThis is the year-to-date depreciation AM30.1 AM30.2
for the to-asset.
ABT-DEPR-YTD-ALLOW Signed 15.2 AM135 AM154
Year-to-Date Depr This is the year-to-date depreciation AM30.1 AM30.2
Allowed allowance for the from-asset.
ABT-TO-DP-YTD-ALLO Signed 15.2 AM135 AM154
To YTD Depreciation This is the year-to-date depreciation AM30.1 AM30.2
Allowed allowance for the to-asset.
ABT-DEPR-YTD-OVRRD Signed 15.2 AM135 AM154
Year-to-Date Deprec This is the year-to-date depreciation AM30.1 AM30.2
Override override amount for the from-asset.
ABT-TO-DP-YTD-OVRD Signed 15.2 AM135 AM154
To YTD Depreciation This is the year-to-date depreciation AM30.1 AM30.2
Override override amount for the to-asset.
ABT-DEPR-LTD Signed 15.2 AM135 AM154
Life-to-Date This is the life-to-date depreciation AM30.1 AM30.2
Depreciation for the from-asset.
ABT-TO-DEPR-LTD Signed 15.2 AM135 AM154
Element: To LTD DepreciThis is the life-to-date depreciation AM30.1 AM30.2
for the to-asset.
ABT-DEPR-LTD-ALLOW Signed 15.2 AM135 AM154
Life-to-Date Deprec This is the life-to-date depreciation AM30.1 AM30.2
Allowed allowance for the from-asset.
ABT-TO-DP-LTD-ALLO Signed 15.2 AM135 AM154
To LTD Depreciation This is the life-to-date depreciation AM30.1 AM30.2
Allowed allowance for the to-asset.
ABT-LAST-CLOSE Signed 15.2 AM135 AM154
Element: Last Close This is the last closed balance for the AM30.1 AM30.2
from-asset.
ABT-TO-LAST-CLOSE Signed 15.2 AM135 AM154
Element: To-Asset Last This is the last closed balance for the AM30.1 AM30.2
to-asset.
ABT-FIRST-LAST-FL Alpha 1 AM135 AM154
Element: First/Last FlaThis field is an internal, AM30.1 AM30.2
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 Signed 5.3 AM135 AM154
Year-to-Date This is the length of time an asset has AM30.1 AM30.2
Inactivity been inactive year-to-date.
ABT-INACT-LTD Signed 7.3 AM135 AM154
Life-to-Date This is the time an asset has been AM30.1 AM30.2
Inactivity inactive life-to-date.
ABT-SALVAGE-VALUE Signed 15.2 AM135 AM154
Element: Salvage Value This is the salvage value of the AM30.1 AM30.2
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-TO-SALV-VALUE Signed 15.2 AM135 AM154
Element: To Salvage ValThis is the salvage value for the AM30.1 AM30.2
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 Signed 5.2 AM135 AM154
Element: Business PerceThis is the business use percentage for AM30.1 AM30.2
the asset.
ABT-PERSONAL-USE Alpha 10 AM135 AM154
Element: Personal Use A personal use code defines the AM30.1 AM30.2
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 Signed 15.2 AM135 AM154
Element: First Year ExpThis is the new first year expense for AM30.1 AM30.2
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-TO-YR1-EXP Signed 15.2 AM30.1 AM30.2
To First Year This is the new first year expense for
Expense 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 Alpha 10 AM135 AM154
Element: Tax Credit TabA user-defined tax credit table, which AM30.1 AM30.2
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 Signed 15.2 AM135 AM154
Element: Property Tax CThis is the tax credit amount for the AM30.1 AM30.2
from-asset, if you are taking a tax
credit for used property.
ABT-TO-TC-PROPERTY Signed 15.2 AM30.1 AM30.2
To Property Tax This is the tax credit amount for the
Credit to-asset, if you are taking a tax credit
for used property.
ABT-TAX-CREDIT Signed 15.2 AM135 AM154
Element: Tax Credit This is the tax credit amount for the AM30.1 AM30.2
from-asset.
ABT-TO-TAX-CREDIT Signed 15.2 AM30.1 AM30.2
Element: To Tax Credit This is the tax credit amount for the
to-asset.
ABT-INS-METHOD Alpha 10 AM135 AM154
Element: Insurance MethThis is the insurance method for the AM30.1 AM30.2
asset.
ABT-INS-ACT-VAL Signed 15.2 AM135 AM154
Actual Insurance This is the actual insurance value for AM30.1 AM30.2
Value the from-asset.
ABT-TO-INS-ACT-VAL Signed 15.2 AM30.1 AM30.2
To Actual Insurance This is the actual insurance value for
Value the to-asset.
ABT-INS-CMPTD-VAL Signed 15.2 AM135 AM154
Computed Insurance This is the computed insurance value AM30.1 AM30.2
Value for the from-asset.
ABT-TO-INS-CMPTD Signed 15.2 AM30.1 AM30.2
To Computed This is the computed insurance value
Insurance Value for the to-asset.
ABT-RPL-METHOD Alpha 10 AM135 AM154
Element: Replacement MeThis is the replacement method for the AM30.1 AM30.2
asset.
ABT-RPL-CMPTD-VAL Signed 15.2 AM135 AM154
Computed This is the computed replacement value AM30.1 AM30.2
Replacement Value for the from-asset.
ABT-TO-RPL-CMPTD Signed 15.2 AM30.1 AM30.2
To Computed This is the computed replacement value
Replacement Value for the to-asset.
ABT-TRF-TRF-DATE Derived
Element: Transfer Date This is the date of the transfer.
ABT-TRF-FULL-PART Derived
Full or Partial This field shows whether the transfer
Transfer is a full transfer (including all items)
or a partial transfer (including only
some items).
ABT-TRF-TRF-TYPE Derived
Element: Transfer Type This field indicates the type of the
transfer.
ABT-AST-TAG-NBR Derived
Element: Tag Number This is the tag, a user-definable
identifier, for the asset.
ABT-TO-AST-TAG Derived
Element: To Tag Number This is the tag for the to-asset.
ABT-AST-ASSET-GRP Derived
Element: Asset Group This is the asset group for the
from-asset.
ABT-TO-AST-GROUP Derived
Element: To Asset GroupThis is the asset group for the
to-asset.
ABT-BOOK-CURRENCY Derived
Element: Book Currency This is the currency for the book.
ABT-TRF-CREAT-DATE Derived
Element: Creation Date This is the date the transfer was
created.
ABT-TRF-CREAT-TIME Derived
Element: Creation Time This is the time the transfer was
created.
ABT-TRF-CREATOR-ID Derived
Element: Creator ID This is the ID of the person who
created the transfer.
AMASTBKTRF FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ABTSET1 ASSET AM115 AM125
PROCESS-SEQ AM135 AM145
BOOK AM15.1 AM15.2
AM15.3 AM15.4
AM154 AM170
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
AM230 AM30.1
AM30.2 AM30.3
AM300 AM330
...
ABTSET2 ASSET AM230 AM310
BOOK AMDL.1
PROCESS-SEQ
AMASTBKTRF FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amasset AMASSET Not Required
Valid When ABT-ASSET != Zeroes
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
|
