AMASTBOOK FILE Asset Book The Asset Book file stores the asset book records used to depreciate assets. Each asset book record describes the depreciation parameters needed to depreciate an asset, based on a specific depreciation book assigned to the asset. Each Asset file record may have one or more related records in the Asset Book file, one for each book assigned to the asset. REFERENCED BY AM220 AM222 AM225 AM240 AM255 AM260 AM265 AM280 AM285 AM290 AM292 AM295 AM957 AM01.1 AM01.2 AM01.3 AM04.1 AM90.1 AM90.2 UPDATED BY AM115 AM120 AM125 AM135 AM145 AM15.1 AM15.2 AM15.3 AM15.4 AM170 AM180 AM185 AM190 AM192 AM195 AM20.1 AM20.2 AM20.3 AM20.4 AM20.5 AM20.6 AM30.1 AM30.2 AM300 AM310 AM40.1 AM40.2 AM40.3 AM500 AM520 AM580 AM60.1 AM700 AM951 AM952 AM953 AM956 AM96.1 AM98.1 FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY ASB-ASSET Numeric 10 AM115 AM135 Asset The asset number associated with the AM145 AM15.1 asset book record. AM15.2 AM15.3 AM15.4 AM170 The asset number contains up to ten AM20.1 AM20.2 numeric characters that uniquely AM20.3 AM20.4 identify an asset. Assets are AM20.5 AM20.6 automatically numbered system-wide. AM30.1 AM30.2 AM40.1 AM40.2 AM500 AM951 AM952 AM956 AM96.1 AM98.1 ASB-BOOK Alpha 10 AM115 AM120 Book A book name assigned to the asset. AM15.1 AM15.2 Books are user-defined and are used by AM15.3 AM15.4 assets for calculating depreciation, AM170 AM20.1 replacement cost, and insurance values, AM20.2 AM20.3 and for reporting. AM20.4 AM20.5 AM20.6 AM30.1 AM500 AM520 AM96.1 AM98.1 ASB-BOOK-STATUS Alpha 1 AM115 AM120 Book Status This field identifies the status of the AM125 AM15.1 book. AM15.2 AM15.3 AM15.4 AM170 A = Active AM20.1 AM20.2 I = Inactive AM20.3 AM20.4 AM20.5 AM20.6 AM30.1 AM500 AM951 AM952 AM956 AM96.1 AM98.1 ASB-LIFE Numeric 4 AM115 AM120 Life The life value of the asset, expressed AM125 AM15.1 in months. AM15.2 AM15.3 AM15.4 AM170 Note: The asset life can be different AM180 AM20.1 for each depreciation book used. AM20.2 AM20.3 AM20.4 AM20.5 AM20.6 AM280 AM30.1 AM500 AM951 AM952 AM956 AM96.1 AM98.1 ASB-LIFE-REM Signed 7.3 AM115 AM120 Life Remaining The asset life remaining, expressed in AM125 AM15.1 months. This value represents the number AM15.2 AM15.3 of months the Asset Management system AM15.4 AM170 will continue to depreciate the asset. AM180 AM190 AM192 AM20.1 AM20.2 AM20.3 AM20.4 AM20.5 AM20.6 AM280 AM30.1 AM500 AM580 AM951 AM952 AM956 AM96.1 AM98.1 ASB-BOOK-BASIS Signed 15.2 AM115 AM135 Book Basis The amount on which the depreciation AM145 AM15.1 calculations are based. AM15.2 AM15.3 AM15.4 AM170 Note: The depreciation basis amount can AM192 AM20.1 be different for each depreciation book AM20.2 AM20.3 used. AM20.4 AM20.5 AM20.6 AM30.1 AM30.2 AM40.1 AM40.2 AM40.3 AM500 AM951 AM952 AM956 AM96.1 AM98.1 ASB-METHOD Alpha 10 AM115 AM120 Method The method the book uses to calculate AM125 AM15.1 depreciation for the asset. Standard AM15.2 AM15.3 depreciation methods are predefined. AM15.4 AM170 Additional methods can be user defined AM20.1 AM20.2 for the following kinds of methods: AM20.3 AM20.4 compute statements, annual percent AM20.5 AM20.6 tables, and annual and period units of AM30.1 AM500 production tables. Valid predefined AM951 AM952 values are: AM956 AM96.1 AM98.1 SL = Straight Line. 200DB = 200 percent declining balance. 175DB = 175 percent declining balance. 150DB = 150 percent declining balance. 125DB = 125 percent declining balance. SYD = Sum of the year's digits. ASB-METH-SWITCHED Alpha 1 AM115 AM15.1 Method Switched This field indicates whether the Asset AM15.2 AM15.3 Management system has switched the AM15.4 AM170 depreciation method to the optimizing AM180 AM20.1 method. Valid values are: AM20.2 AM20.3 AM20.4 AM20.5 N = No. AM20.6 AM30.1 Y = Yes. AM500 AM951 AM952 AM956 AM96.1 AM98.1 ASB-INSRV-DATE Numeric 8 (yyyymmdd) AM115 AM120 In Service Date The date the asset was placed in AM125 AM15.1 service. AM15.2 AM15.3 AM15.4 AM170 Note: The in-service date can be AM20.1 AM20.2 different for each depreciation book AM20.3 AM20.4 used. AM20.5 AM20.6 AM30.1 AM500 AM951 AM952 AM956 AM96.1 AM98.1 ASB-METH-TABLE-YR Numeric 2 AM115 AM125 Method Table Year The year the asset was placed in AM15.1 AM15.2 service. AM15.3 AM15.4 AM170 AM195 AM20.1 AM20.2 AM20.3 AM20.4 AM20.5 AM20.6 AM30.1 AM500 AM580 AM951 AM952 AM956 AM96.1 AM98.1 ASB-CONVENTION Alpha 2 AM115 AM120 Convention The depreciation convention assigned to AM125 AM15.1 the book. This value is used to AM15.2 AM15.3 determine the first and last years' AM15.4 AM170 depreciation amounts to take. Valid AM20.1 AM20.2 values are: AM20.3 AM20.4 AM20.5 AM20.6 FM = Full Month. AM30.1 AM500 HM = Modified Half Month. AM951 AM952 MM = Mid Month. AM956 AM96.1 NM = Next Month. AM98.1 HY = Half Year. MY = Modified Half Year. FY = Full Year. AD = Actual Days. MQ = Mid Quarter. Note: See data file text for the Method file for more information on each convention. ASB-DEPR-STARTDATE Numeric 8 (yyyymmdd) AM115 AM125 Depreciation Start The date depreciation calculations AM15.1 AM15.2 Date began or will begin for the asset. AM15.3 AM15.4 AM170 AM192 AM20.1 AM20.2 AM20.3 AM20.4 AM20.5 AM20.6 AM30.1 AM500 AM580 AM951 AM952 AM956 AM96.1 AM98.1 ASB-LIFE-YEARS Signed 5.2 AM115 AM120 Life Years The total life value of the asset, AM125 AM15.1 expressed in years. This value is AM15.2 AM15.3 calculated by dividing the Life value by AM15.4 AM170 12. AM20.1 AM20.2 AM20.3 AM20.4 AM20.5 AM20.6 AM30.1 AM500 AM96.1 AM98.1 ASB-STATUS-CP-CALC Alpha 1 AM115 AM15.1 Calc Status Current This field indicates whether AM15.2 AM15.3 Period depreciation has been calculated for the AM15.4 AM170 current period. AM180 AM190 AM20.1 AM20.2 AM20.3 AM20.4 AM20.5 AM20.6 AM30.1 AM500 AM951 AM952 AM956 AM96.1 AM98.1 ASB-LIFE-CP Signed 5.3 AM115 AM15.1 Current Period Life This is the current period portion of AM15.2 AM15.3 the asset life. AM15.4 AM170 AM180 AM190 AM192 AM20.1 AM20.2 AM20.3 AM20.4 AM20.5 AM20.6 AM280 AM30.1 AM500 AM951 AM952 AM96.1 AM98.1 ASB-TRAN-ND Numeric 1 AM115 AM135 Transaction Number The number of decimal positions defined AM145 AM15.1 of Decimals for the transaction currency. AM15.2 AM15.3 AM15.4 AM170 AM20.1 AM20.2 AM20.3 AM20.4 AM20.5 AM20.6 AM30.1 AM30.2 AM40.1 AM40.2 AM500 AM580 AM951 AM952 AM956 AM96.1 AM98.1 ASB-DEPR-CP Signed 15.2 AM115 AM135 Current Period This is the current period depreciation AM145 AM15.1 Depreciation for this book. This amount includes only AM15.2 AM15.3 the business use, not the personal use, AM15.4 AM170 portion of the depreciation AM180 AM190 AM192 AM20.1 AM20.2 AM20.3 AM20.4 AM20.5 AM20.6 AM280 AM30.1 AM30.2 AM40.1 AM40.3 AM500 AM951 AM952 AM956 AM96.1 AM98.1 ASB-DEPR-CP-ALLOW Signed 15.2 AM115 AM135 Current Period Depr This is the current period depreciation AM15.1 AM15.2 Allowed allowed for the book. This amount is AM15.3 AM15.4 equivalent to the full depreciation, AM170 AM180 including business and personal use. AM190 AM192 AM20.1 AM20.2 AM20.3 AM20.4 AM20.5 AM20.6 AM280 AM30.1 AM30.2 AM40.1 AM500 AM951 AM952 AM96.1 AM98.1 ASB-DEPR-YTD Signed 15.2 AM115 AM125 Year-to-Date This is the year-to-date depreciation AM135 AM145 Depreciation amount for the book. This amount AM15.1 AM15.2 includes only the business use, not the AM15.3 AM15.4 personal use, portion of the AM170 AM190 depreciation. AM192 AM195 AM20.1 AM20.2 AM20.3 AM20.4 AM20.5 AM20.6 AM30.1 AM30.2 AM40.1 AM40.2 AM40.3 AM500 AM580 AM951 AM952 AM956 AM96.1 AM98.1 ASB-DEPR-YTD-ALLOW Signed 15.2 AM115 AM125 Year-to-Date Depr This is the year-to-date depreciation AM135 AM145 Allowed allowed for the book. This amount is AM15.1 AM15.2 equivalent to the full depreciation, AM15.3 AM15.4 including business and personal use. AM170 AM190 AM192 AM195 AM20.1 AM20.2 AM20.3 AM20.4 AM20.5 AM20.6 AM30.1 AM30.2 AM40.1 AM40.2 AM500 AM951 AM952 AM956 AM96.1 AM98.1 ASB-DEPR-YTD-OVRRD Signed 15.2 AM115 AM125 Year-to-Date Depr This is the year-to-date depreciation AM135 AM145 Override override amount. AM15.1 AM15.2 AM15.3 AM15.4 AM170 AM192 AM195 AM20.1 AM20.2 AM20.3 AM20.4 AM20.5 AM20.6 AM30.1 AM30.2 AM40.1 AM40.2 AM500 AM60.1 AM951 AM952 AM956 AM96.1 AM98.1 ASB-DEPR-LTD Signed 15.2 AM115 AM125 Life-to-Date This is the life-to-date depreciation AM135 AM145 Depreciation amount for the book. This amount AM15.1 AM15.2 includes only the business use, not the AM15.3 AM15.4 personal use, portion of the AM170 AM190 depreciation. AM192 AM20.1 AM20.2 AM20.3 AM20.4 AM20.5 AM20.6 AM30.1 AM30.2 AM40.1 AM40.2 AM40.3 AM500 AM580 AM951 AM952 AM956 AM96.1 AM98.1 ASB-DEPR-LTD-ALLOW Signed 15.2 AM115 AM125 Life-to-Date Depr This is the life-to-date depreciation AM135 AM145 Allowed allowed for the book. This amount is AM15.1 AM15.2 equivalent to the full depreciation, AM15.3 AM15.4 including business and personal use. AM170 AM190 AM192 AM20.1 AM20.2 AM20.3 AM20.4 AM20.5 AM20.6 AM30.1 AM30.2 AM40.1 AM40.2 AM500 AM951 AM952 AM956 AM96.1 AM98.1 ASB-LAST-CLOSE Signed 15.2 AM115 AM135 Last Close This is the balance in the last-closed AM15.1 AM15.2 period for this book. AM15.3 AM15.4 AM170 AM190 AM192 AM20.1 AM20.2 AM20.3 AM20.4 AM20.5 AM20.6 AM30.1 AM30.2 AM500 AM951 AM952 AM956 AM96.1 AM98.1 ASB-FIRST-LAST-FL Alpha 1 AM115 AM125 First or Last Flag This field is an internal, AM15.1 AM15.2 system-maintained value used to control AM15.3 AM15.4 depreciation calculations during the AM170 AM190 first and last years of an asset's life. AM192 AM195 AM20.1 AM20.2 Valid values are: AM20.3 AM20.4 AM20.5 AM20.6 F = First. This is the first in-service AM30.1 AM500 year for the asset. AM580 AM951 AM952 AM956 M = Middle. The asset is in a year other AM96.1 AM98.1 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 will continue to depreciate the asset beyond the original asset life. ASB-INACT-YTD Signed 5.3 AM115 AM15.1 Inactive This is the number of inactive months AM15.2 AM15.3 Year-to-Date for the book year-to-date. AM15.4 AM170 AM190 AM192 AM195 AM20.1 AM20.2 AM20.3 AM20.4 AM20.5 AM20.6 AM30.1 AM500 AM951 AM952 AM96.1 AM98.1 ASB-INACT-LTD Signed 7.3 AM115 AM15.1 Inactive This is the number of inactive months AM15.2 AM15.3 Life-to-Date for the book life-to-date. AM15.4 AM170 AM190 AM192 AM20.1 AM20.2 AM20.3 AM20.4 AM20.5 AM20.6 AM30.1 AM500 AM951 AM952 AM956 AM96.1 AM98.1 ASB-SALVAGE-VALUE Signed 15.2 AM115 AM135 Salvage Value The salvage value of the asset at the AM145 AM15.1 end of the asset's life. It can be zero. AM15.2 AM15.3 AM15.4 AM170 If the depreciation method is STL AM192 AM20.1 (Straight Line), the basis used for the AM20.2 AM20.3 depreciation calculation is the asset AM20.4 AM20.5 cost less this salvage value. AM20.6 AM30.1 AM30.2 AM40.1 If the depreciation method is DDB AM40.2 AM500 (Double Declining Balance), 150 (150% AM951 AM952 Declining Balance), or 175 (175% AM956 AM96.1 Declining Balance), the basis used for AM98.1 the depreciation calculation is the asset cost. Depreciation will be taken until the total amount taken is equal to the asset cost less this salvage value. ASB-BUS-PERCENT Signed 5.2 AM115 AM15.1 Business Percent The business percent usage of the AM15.2 AM15.3 asset. If this value is less than 100 AM15.4 AM170 percent, the value is used in AM20.1 AM20.2 depreciation calculations. AM20.3 AM20.4 AM20.5 AM20.6 AM30.1 AM500 AM951 AM952 AM956 AM96.1 AM98.1 ASB-PERSONAL-USE Alpha 10 AM115 AM15.1 Personal Use The personal use code assigned to the AM15.2 AM15.3 asset. A personal use code defines the AM15.4 AM170 personal use options that asset books AM20.1 AM20.2 use to calculate depreciation, tax AM20.3 AM20.4 credits, and annual depreciation limits AM20.5 AM20.6 up to twenty years. The code is user AM30.1 AM500 definable. AM951 AM952 AM956 AM96.1 AM98.1 ASB-1YR-EXP Signed 15.2 AM700 AM956 Old First Year This is the old first year expense Expense amount for an asset for which First Year Expense is allowed. First Year Expense is a depreciation amount allowed by U.S. tax laws to be allocated as you direct on certain classes of assets. You can select the assets for which you apply this special depreciation and the depreciation amount to be applied to each asset. The Asset Management system maintains the history of these allocations and ensures that the total allowed is not exceeded. ASB-YR1-EXP Signed 15.2 AM115 AM135 New First Year This is the new first year expense AM145 AM15.1 Expense amount. It represents the amount to AM15.2 AM15.3 expense for the First Year Expense AM15.4 AM170 option. This U.S. tax option allows you AM192 AM20.1 to expense and not depreciate a total AM20.2 AM20.3 dollar amount for the assets of each AM20.4 AM20.5 eligible company. AM20.6 AM30.1 AM30.2 AM40.1 AM40.2 AM500 AM700 AM951 AM952 AM96.1 AM98.1 ASB-TC-TABLE Alpha 10 AM115 AM15.1 Tax Credit Table A user-defined tax credit table, which AM15.2 AM15.3 defines tax credit percentages and AM15.4 AM170 annual tax credit recapture percentages AM20.1 AM20.2 for up to twenty years. Asset books use AM20.3 AM20.4 tax credit tables to calculate tax AM20.5 AM20.6 credits. AM30.1 AM500 AM952 AM956 AM96.1 AM98.1 ASB-TC-PROPERTY Signed 15.2 AM115 AM135 Tax Credit Property If you are taking a tax credit for used AM145 AM15.1 property, this field contains the amount AM15.2 AM15.3 that qualifies for the credit. AM15.4 AM170 AM192 AM20.1 AM20.2 AM20.3 AM20.4 AM20.5 AM20.6 AM30.1 AM30.2 AM40.1 AM40.2 AM500 AM951 AM952 AM956 AM96.1 AM98.1 ASB-TAX-CREDIT Signed 15.2 AM115 AM135 Tax Credit This is the amount of tax credit taken AM145 AM15.1 for this asset. AM15.2 AM15.3 AM15.4 AM170 AM192 AM20.1 AM20.2 AM20.3 AM20.4 AM20.5 AM20.6 AM30.1 AM30.2 AM40.1 AM40.2 AM500 AM951 AM952 AM956 AM96.1 AM98.1 ASB-INS-METHOD Alpha 10 AM115 AM15.1 Insurance Method The method used to calculate insurance AM15.2 AM15.3 values for the asset. AM15.4 AM170 AM20.1 AM20.2 AM20.3 AM20.4 AM20.5 AM20.6 AM30.1 AM500 AM952 AM956 AM96.1 AM98.1 ASB-INS-ACT-VAL Signed 15.2 AM115 AM135 Insurance Actual The actual insurance value of the asset. AM145 AM15.1 Value AM15.2 AM15.3 AM15.4 AM170 AM192 AM20.1 AM20.2 AM20.3 AM20.4 AM20.5 AM20.6 AM30.1 AM30.2 AM40.1 AM40.2 AM500 AM952 AM956 AM96.1 AM98.1 ASB-INS-CMPTD-VAL Signed 15.2 AM115 AM135 Insurance Computed The calculated insurance value for the AM145 AM15.1 Value asset. AM15.2 AM15.3 AM15.4 AM170 AM185 AM192 AM20.1 AM20.2 AM20.3 AM20.4 AM20.5 AM20.6 AM30.1 AM30.2 AM40.1 AM40.2 AM500 AM952 AM956 AM96.1 AM98.1 ASB-RPL-METHOD Alpha 10 AM115 AM15.1 Replacement Method The method used to calculate AM15.2 AM15.3 replacement values for the asset. AM15.4 AM170 AM20.1 AM20.2 AM20.3 AM20.4 AM20.5 AM20.6 AM30.1 AM500 AM952 AM956 AM96.1 AM98.1 ASB-RPL-CMPTD-VAL Signed 15.2 AM115 AM135 Replacement The calculated replacement value for AM145 AM15.1 Computed Value the asset. AM15.2 AM15.3 AM15.4 AM170 AM185 AM192 AM20.1 AM20.2 AM20.3 AM20.4 AM20.5 AM20.6 AM30.1 AM30.2 AM40.1 AM40.2 AM500 AM952 AM956 AM96.1 AM98.1 ASB-CREATION-DATE Numeric 8 (yyyymmdd) AM145 AM40.1 Creation Date The date the asset book record was AM40.2 AM951 created. AM952 AM956 ASB-CREATION-TIME Numeric 6 (hhmmss) AM145 AM40.1 Creation Time The time the asset book record was AM40.2 AM951 created. AM952 AM956 ASB-CREATOR-ID Alpha 10 AM145 AM40.1 Creator ID This field identifies the operator who AM40.2 AM951 created the asset book record. AM952 AM956 ASB-BOOK-DESC Derived Book Description The book description. ASB-BOOK-VALUE Derived Book Value The book value is calculated as follows: Book Basis - Life-to-date Depreciation. ASB-SALVAGE-PCT Derived Salvage Percentage Salvage percentage is calculated as follows: Salvage Value / Book Basis. ASB-BK-YR-END-DATE Derived Book Year-End Date The last date of the fiscal year. ASB-BK-YR-BEG-DATE Derived Book Year-Begin Date The first date of the fiscal year. ASB-BK-PD-PER-YR Derived Book Periods Per The number of periods defined for the Year fiscal year. ASB-BK-DEPR-PD-CLS Derived Book Depreciation This field identifies the number of Period Close depreciation periods that are closed in the fiscal year. ASB-BK-PD-CLOSE-DT Derived Book Period Close The last date of the current period. Date ASB-BK-PD-CURR-DT Derived Book Current Period This field identifies the closing date Close Date of the current period. ASB-BK-REQ Derived Book Required This field indicates whether the book is a required book to be used by all new assets being added. ASB-BK-POSTING Derived Posting Book This field identifies whether the book is a posting book that posts journal entries to the general ledger. ASB-BK-BOOK-STATUS Derived Book Status The status of the book. ASB-BK-CURRENCY-CD Derived Currency Code The currency code assigned to the book. ASB-BK-METH-SWITCH Derived Method Switch This field identifies whether the depreciation method can be switched for the book. ASB-TAG Derived Tag The tag number assigned to the asset. ASB-ASSET-GRP Derived Asset Group The asset group assigned to the asset. ASB-DEPR-YTD-OVER Derived Year-to-Date Deprec The word "OVERRIDE" displays if there Override is a year-to-date depreciation override amount. ASB-AST-DESC Derived Asset Description This is the asset description. ASB-AST-STATUS Derived Asset Status This is the asset status. ASB-AST-LOCATION Derived Ast Location ASB-AST-DIVISION Derived Ast Division ASB-AST-TYPE Derived Ast Type ASB-AST-SUBTYPE Derived Ast Subtype AMASTBOOK FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN ASBSET1 ASSET AM115 AM120 BOOK AM125 AM135 AM145 AM15.1 AM15.2 AM15.3 AM15.4 AM170 AM180 AM185 AM190 AM192 AM195 AM20.1 AM20.2 AM20.3 AM20.4 AM20.5 AM20.6 AM220 AM222 AM225 AM240 AM255 AM260 AM265 AM280 AM285 ... ASBSET2 BOOK AM01.1 AM01.2 ASSET AM01.3 AM04.1 AM120 AM135 AM220 AM260 AM285 AM310 AM520 AM60.1 AM90.1 AM90.2 AMASTBOOK FILE RELATIONS ONE TO ONE RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH Amasset AMASSET Not Required ASB-ASSET -> AST-ASSET Amastbkdsp AMASTBKDSP Not Required ASB-ASSET -> ABD-ASSET ASB-BOOK -> ABD-BOOK Amasttype AMASTTYPE Not Required AST-COMPANY -> ATP-COMPANY AST-ASSET-TYPE -> ATP-ASSET-TYPE AST-SUB-TYPE -> ATP-SUB-TYPE Ambook AMBOOK Required ASB-BOOK -> AMB-BOOK Amcalendar AMCALENDAR Not Required ASB-BOOK -> AMC-BOOK AST-COMPANY -> AMC-COMPANY Amdivision AMDIVISION Not Required AST-DIVISION -> DIV-DIVISION Amlocation AMLOCATION Not Required AST-LOCATION-NAME -> LOC-LOCATION-NAME Ammethod AMMETHOD Required ASB-METHOD -> AMM-METHOD AMASTBOOK FILE RELATIONS ONE TO MANY RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH Amastbkadj AMASTBKADJ ASB-ASSET -> ABA-ASSET ASB-BOOK -> ABA-BOOK ABA-PROCESS-SEQ Amastbktrf AMASTBKTRF ASB-ASSET -> ABT-ASSET ASB-BOOK -> ABT-BOOK ABT-PROCESS-SEQ |