|
|
AMASTBKTRF FILE
Asset Book Transfer
This file contains historical asset book information related to transfers.
REFERENCED BY
AM115 AM125 AM145 AM15.1 AM15.2 AM15.3
AM15.4 AM170 AM20.1 AM20.2 AM20.3 AM20.4
AM20.5 AM20.6 AM230 AM40.1 AM40.2 AM500
AM96.1 AM98.1
UPDATED BY
AM135 AM30.1 AM30.2 AM300 AM310 AM520
AM700 AM956
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ABT-ASSET Numeric 10 AM135 AM30.1
Asset Key field. The asset number contains up AM30.2 AM956
to ten numeric characters that uniquely
identify an asset. Assets are
automatically numbered system-wide.
ABT-TO-ASSET Numeric 10 AM135 AM30.1
To Asset This is the to-asset for the transfer. AM30.2 AM956
ABT-BOOK Alpha 10 AM135 AM30.1
Book Key field. This is a user-defined book AM30.2 AM520
name. Books are used by assets for AM956
calculating depreciation, replacement
cost, and insurance values, and for
reporting.
ABT-PROCESS-SEQ Numeric 4 AM135 AM30.1
Process Sequence Key field. This is the sequence number AM30.2 AM956
for the transfer process.
ABT-BOOK-STATUS Alpha 1 AM135 AM30.1
Book Status This field indicates the status of the AM30.2 AM956
book: Active or Inactive.
A = Active
I = Inactive
ABT-LIFE Numeric 4 AM135 AM30.1
Life This is the asset life in months. AM30.2 AM956
ABT-LIFE-REM Signed 7.3 AM135 AM30.1
Life Remaining This is the remaining life for the AM30.2 AM956
asset.
ABT-BOOK-BASIS Signed 15.2 AM135 AM30.1
Book Basis This field contains the amount on which AM30.2 AM956
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
To Book Basis This field contains the amount on which AM956
the depreciation calculations for the
transfer-to asset book are based.
ABT-METHOD Alpha 10 AM135 AM30.1
Method This is the asset book depreciation AM30.2 AM956
method.
ABT-METH-SWITCHED Alpha 1 AM135 AM30.1
Method Switched This is the switch used to indicate AM30.2 AM956
when the Asset Management system has
switched the depreciation method to STL
(Straight Line). It remains blank until
the switch occurs. The system then fills
in an asterisk ("*").
Valid values are:
# = (Blank); the switch is not in use.
* = (Asterisk); the depreciation method
has been switched to STL (Straight
Line).
ABT-INSRV-DATE Numeric 8 (yyyymmdd) AM135 AM30.1
In Service Date This is the in-service date for the AM30.2 AM956
asset.
Note: The in-service date can be
different for each depreciation book
used.
ABT-METH-TABLE-YR Numeric 2 AM135 AM30.1
Method Table Year This field indicates what year of its AM30.2 AM956
life an asset is in. Various tables use
this year in their calculations.
ABT-CONVENTION Alpha 2 AM135 AM30.1
Convention This is the in-service convention for AM30.2 AM956
the asset, which determines the amount
of depreciation it receives in its first
and last years in service.
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 Year
NM = Next Month
ABT-DEPR-STARTDATE Numeric 8 (yyyymmdd) AM135 AM30.1
Depreciation Start This is the date from which AM30.2 AM956
Date depreciation calculation begins.
ABT-LIFE-YEARS Signed 5.2 AM135 AM30.1
Life Years This is the asset life in years. AM30.2
ABT-STATUS-CP-CALC Alpha 1 AM135 AM30.1
Calculate Curr This field indicates whether AM30.2 AM956
Period Status depreciation has been calculated for the
current period.
ABT-LIFE-CP Signed 5.3 AM135 AM30.1
Life This is the portion of the asset life AM30.2 AM956
for the current period.
ABT-TRAN-ND Numeric 1 AM135 AM30.1
Transaction Number The number of decimal positions defined AM30.2 AM956
of Decimals for the transaction currency.
ABT-DEPR-CP Signed 15.2 AM135 AM30.1
Current Period This is the depreciation amount for the AM30.2 AM956
Depreciation current period for the from-asset.
ABT-TO-DEPR-CP Signed 15.2 AM135 AM30.1
To Current Period This is the current period depreciation AM30.2 AM956
Depreciation amount for the to-asset.
ABT-DEPR-CP-ALLOW Signed 15.2 AM135 AM30.1
Curr Period Deprec This is the depreciation allowed for AM30.2 AM956
Allowed the from-asset in the current period.
ABT-TO-DP-CP-ALLOW Signed 15.2 AM135 AM30.1
To Current Period This is the depreciation allowed in the AM30.2 AM956
Depr Allowed current period for the to-asset.
ABT-DEPR-YTD Signed 15.2 AM135 AM30.1
Year-to-Date This is the year-to-date depreciation AM30.2 AM956
Depreciation for the from-asset.
ABT-TO-DEPR-YTD Signed 15.2 AM135 AM30.1
To YTD Depreciation This is the year-to-date depreciation AM30.2 AM956
for the to-asset.
ABT-DEPR-YTD-ALLOW Signed 15.2 AM135 AM30.1
Year-to-Date Depr This is the year-to-date depreciation AM30.2 AM956
Allowed allowance for the from-asset.
ABT-TO-DP-YTD-ALLO Signed 15.2 AM135 AM30.1
To YTD Depreciation This is the year-to-date depreciation AM30.2 AM956
Allowed allowance for the to-asset.
ABT-DEPR-YTD-OVRRD Signed 15.2 AM135 AM30.1
Year-to-Date Deprec This is the year-to-date depreciation AM30.2 AM956
Override override amount for the from-asset.
ABT-TO-DP-YTD-OVRD Signed 15.2 AM135 AM30.1
To YTD Depreciation This is the year-to-date depreciation AM30.2 AM956
Override override amount for the to-asset.
ABT-DEPR-LTD Signed 15.2 AM135 AM30.1
Life-to-Date This is the life-to-date depreciation AM30.2 AM956
Depreciation for the from-asset.
ABT-TO-DEPR-LTD Signed 15.2 AM135 AM30.1
To LTD Depreciation This is the life-to-date depreciation AM30.2 AM956
for the to-asset.
ABT-DEPR-LTD-ALLOW Signed 15.2 AM135 AM30.1
Life-to-Date Deprec This is the life-to-date depreciation AM30.2 AM956
Allowed allowance for the from-asset.
ABT-TO-DP-LTD-ALLO Signed 15.2 AM135 AM30.1
To LTD Depreciation This is the life-to-date depreciation AM30.2 AM956
Allowed allowance for the to-asset.
ABT-LAST-CLOSE Signed 15.2 AM135 AM30.1
Last Close This is the last closed balance for the AM30.2 AM956
from-asset.
ABT-TO-LAST-CLOSE Signed 15.2 AM135 AM30.1
To-Asset Last Close This is the last closed balance for the AM30.2 AM956
to-asset.
ABT-FIRST-LAST-FL Alpha 1 AM135 AM30.1
First/Last Flag This field is an internal, AM30.2 AM956
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 AM30.1
Year-to-Date This is the length of time an asset has AM30.2 AM956
Inactivity been inactive year-to-date.
ABT-INACT-LTD Signed 7.3 AM135 AM30.1
Life-to-Date This is the time an asset has been AM30.2 AM956
Inactivity inactive life-to-date.
ABT-SALVAGE-VALUE Signed 15.2 AM135 AM30.1
Salvage Value This is the salvage value of the AM30.2 AM956
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 AM30.1
To Salvage Value This is the salvage value for the AM30.2 AM956
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 AM30.1
Business Percent This is the business use percentage for AM30.2 AM956
the asset.
ABT-PERSONAL-USE Alpha 10 AM135 AM30.1
Personal Use A personal use code defines the AM30.2 AM956
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-1YR-EXP Signed 15.2 AM700
Old First Year This is the old first year expense for
Expense the from-asset.
ABT-TO-1YR-EXP Signed 15.2 AM700
To Old First Year This is the old first year expense for
Expense the to-asset.
ABT-YR1-EXP Signed 15.2 AM135 AM30.1
New First Year This is the new first year expense for AM30.2 AM700
Expense the from-asset. It represents the amount AM956
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 New First Year This is the new first year expense for AM700
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 AM30.1
Tax Credit Table A user-defined tax credit table, which 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 AM30.1
Property Tax Credit This is the tax credit amount for the AM30.2 AM956
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 AM30.1
Tax Credit This is the tax credit amount for the AM30.2 AM956
from-asset.
ABT-TO-TAX-CREDIT Signed 15.2 AM30.1 AM30.2
To Tax Credit This is the tax credit amount for the
to-asset.
ABT-INS-METHOD Alpha 10 AM135 AM30.1
Insurance Method This is the insurance method for the AM30.2
asset.
ABT-INS-ACT-VAL Signed 15.2 AM135 AM30.1
Actual Insurance This is the actual insurance value for 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 AM30.1
Computed Insurance This is the computed insurance value 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 AM30.1
Replacement Method This is the replacement method for the AM30.2
asset.
ABT-RPL-CMPTD-VAL Signed 15.2 AM135 AM30.1
Computed This is the computed replacement value 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
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
Transfer Type This field indicates the type of the
transfer.
ABT-AST-TAG-NBR Derived
Tag Number This is the tag, a user-definable
identifier, for the asset.
ABT-TO-AST-TAG Derived
To Tag Number This is the tag for the to-asset.
ABT-AST-ASSET-GRP Derived
Asset Group This is the asset group for the
from-asset.
ABT-TO-AST-GROUP Derived
To Asset Group This is the asset group for the
to-asset.
ABT-BOOK-CURRENCY Derived
Book Currency This is the currency for the book.
ABT-TRF-CREAT-DATE Derived
Creation Date This is the date the transfer was
created.
ABT-TRF-CREAT-TIME Derived
Creation Time This is the time the transfer was
created.
ABT-TRF-CREATOR-ID Derived
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
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM230
AM30.1 AM30.2
AM300 AM40.1
AM40.2 AM500
AM520 AM700
AM956 AM96.1
AM98.1
ABTSET2 ASSET AM310
BOOK
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
|