AMASTBKRIN – Asset Book Reinstatement

System: Asset Management (AM)
Prefix: RIB
Primary key: ASSET, BOOK, CREATION-DATE, CREATION-TIME
Fields: 69
Updated by: 4 programs
Referenced by: 1 program

AMASTBKRIN is the Asset Book Reinstatement table in Lawson Asset Management (prefix RIB). It is indexed by ASSET, BOOK, CREATION-DATE, CREATION-TIME (RIBSET1); alternate indexes: RIBSET2 and RIBSET3. It is related 1:1 to AMASSET, AMASSETRIN, AMASTBOOK, AMASTTYPE, AMBOOK, AMDIVISION and AMLOCATION. It is updated by AM300, AM310, AM330 and AM41.1 and referenced by AM241. The table has 69 fields, 3 indexes and 7 documented relations.

About AMASTBKRIN

This file contains audit asset book information related to reinstated disposals. It contains a copy of the disposal information contained in AMASTBKDSP, plus reinstatement information.

Fields (69)

Column = COBOL field name without the RIB- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`RIB-ASSET` PK 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.	AM41.1
`RIB-BOOK` PK BOOK	Alpha 10	Key field. This field contains a user-defined book name. Books are used by assets for calculating depreciation, replacement cost, and insurance values, and for reporting.	AM41.1
`RIB-BOOK-COST-SALE` BOOK_COST_SALE	Signed 18.2	This is the cost of sale for the asset disposal.	AM41.1
`RIB-CST-SALE-OVRRD` CST_SALE_OVRRD	Signed 18.2	This is the overriding amount for the book cost of sale.	AM41.1
`RIB-BOOK-PROCEEDS` BOOK_PROCEEDS	Signed 18.2	This field contains the proceeds for the asset disposal.	AM41.1
`RIB-PROCEEDS-OVRRD` PROCEEDS_OVRRD	Signed 18.2	This is the overriding amount for the book proceeds from the disposal.	AM41.1
`RIB-GAIN-LOSS` GAIN_LOSS	Signed 18.2	This field contains the gain or loss for the asset disposal.	AM41.1
`RIB-GN-LS-OVERRIDE` GN_LS_OVERRIDE	Signed 18.2	This field contains the gain or loss override for the asset disposal.	AM41.1
`RIB-DEFER-GN-LS` DEFER_GN_LS	Signed 18.2	This field contains the deferred gain or loss for the asset disposal.	AM41.1
`RIB-DEFER-OVERRIDE` DEFER_OVERRIDE	Signed 18.2	This field contains the deferred gain or loss override for the asset disposal.	AM41.1
`RIB-TC-RECAPTURE` TC_RECAPTURE	Signed 18.2	This is the tax credit recapture amount for the asset disposal.	AM41.1
`RIB-TC-OVERRIDE` TC_OVERRIDE	Signed 18.2	This is the tax credit recapture override for the asset disposal.	AM41.1
`RIB-BOOK-BASIS` BOOK_BASIS	Signed 18.2	This field contains the book basis amount on which the depreciation calculations for the disposed asset are based. Note: The depreciation basis amount can be different for each depreciation book used.	AM41.1
`RIB-TRAN-ND` TRAN_ND	Numeric 1	The number of decimal positions defined for the transaction currency.	AM41.1
`RIB-DSP-DEPR` DSP_DEPR	Signed 18.2	This is the depreciation expense associated with the disposal.	AM41.1
`RIB-DSP-DEPR-OVRRD` DSP_DEPR_OVRRD	Signed 18.2	This is the depreciation expense override amount associated with the disposal.	AM41.1
`RIB-DEPR-YTD` DEPR_YTD	Signed 18.2	This is the year-to-date depreciation for the disposed asset.	AM41.1
`RIB-DEPR-YTD-ALLOW` DEPR_YTD_ALLOW	Signed 18.2	This is the year-to-date depreciation allowance for the disposed asset.	AM41.1
`RIB-DEPR-YTD-OVRRD` DEPR_YTD_OVRRD	Signed 18.2	This is the year-to-date depreciation override for the disposed asset..	—
`RIB-DEPR-LTD` DEPR_LTD	Signed 18.2	This is the life-to-date depreciation for the disposed-of asset.	AM41.1
`RIB-DEPR-LTD-ALLOW` DEPR_LTD_ALLOW	Signed 18.2	This is the life-to-date depreciation allowance for the disposed asset.	AM41.1
`RIB-SALVAGE-VALUE` SALVAGE_VALUE	Signed 18.2	This is the salvage value of the asset, or value remaining, at the end of the asset's life. It can be zero. If the depreciation method is SL (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), 125DB (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.	AM41.1
`RIB-YR1-EXP` YR1_EXP	Signed 18.2	This is the new first year expense amount for the 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.	AM41.1
`RIB-TC-PROPERTY` TC_PROPERTY	Signed 18.2	This is the tax credit amount for the asset, if you are taking a tax credit for used property.	AM41.1
`RIB-TAX-CREDIT` TAX_CREDIT	Signed 18.2	This is the tax credit amount for the asset.	AM41.1
`RIB-INS-ACT-VAL` INS_ACT_VAL	Signed 18.2	This is the actual insurance value for the asset.	AM41.1
`RIB-INS-CMPTD-VAL` INS_CMPTD_VAL	Signed 18.2	This is the computed replacement value for the asset.	AM41.1
`RIB-RPL-CMPTD-VAL` RPL_CMPTD_VAL	Signed 18.2	This is the computed replacement value for the asset.	AM41.1
`RIB-NEW-AST-BASIS` NEW_AST_BASIS	Signed 18.2	If the disposal was a partial disposal, a new asset was defined. This field contains the new asset basis, or the amount on which depreciation calculations for the new asset are based.	AM41.1
`RIB-CASH-PAID` CASH_PAID	Signed 18.2	This is the amount of cash paid in the asset disposal.	AM41.1
`RIB-OLD-AST-ADJ-BS` OLD_AST_ADJ_BS	Signed 18.2	This is the adjusted basis for the old asset.	AM41.1
`RIB-AMT-REALIZED` AMT_REALIZED	Signed 18.2	This is the amount realized through the disposal.	AM41.1
`RIB-AMT-GIVEN-UP` AMT_GIVEN_UP	Signed 18.2	This is the amount of depreciation given up as a result of the disposal.	AM41.1
`RIB-NEW-AST-ADJ-BS` NEW_AST_ADJ_BS	Signed 18.2	If the disposal was a partial disposal, a new asset was defined. This is the adjusted basis for the new asset.	AM41.1
`RIB-NEW-ASSET` NEW_ASSET	Numeric 10	If the disposal was partial disposal, a new asset was defined. This is the new asset number.	AM41.1
`RIB-AST-DSP-ASSET` AST_DSP_ASSET	Derived	This is the number of the disposed-of asset.	—
`RIB-AST-ASSET-GRP` AST_ASSET_GRP	Derived	This is the asset group for the new asset.	—
`RIB-AST-TAG-NBR` AST_TAG_NBR	Derived	This is the tag for the new asset.	—
`RIB-AST-DESCRIP` AST_DESCRIP	Derived	This is the new asset description.	—
`RIB-ASD-DSP-DATE` ASD_DSP_DATE	Derived	This is the effective date for the asset disposal.	—
`RIB-ASD-FULL-PART` ASD_FULL_PART	Derived	This field indicates whether the disposal was a full or partial disposal.	—
`RIB-ASD-DSP-METH` ASD_DSP_METH	Derived	This is the way in which the asset was disposed of.	—
`RIB-ASD-DSP-PROP` ASD_DSP_PROP	Derived	This is the user-defined name of a disposal property. It represents a kind of disposed-of asset.	—
`RIB-BOOK-CURRENCY` BOOK_CURRENCY	Derived	This is the currency for the book.	—
`RIB-DSP-CREAT-DATE` DSP_CREAT_DATE	Derived	This is the creation date for the disposal.	—
`RIB-DSP-CREAT-TIME` DSP_CREAT_TIME	Derived	This is the creation time for the disposal.	—
`RIB-DSP-CREATOR-ID` DSP_CREATOR_ID	Derived	This is the ID of the person who created the disposal.	—
`RIB-AMB-DESC` AMB_DESC	Derived	This is the description of the book.	—
`RIB-ASB-BOOK-BASIS` ASB_BOOK_BASIS	Derived	This field contains the amount on which the depreciation calculations for the book are based.	—
`RIB-ASB-METHOD` ASB_METHOD	Derived	This is the asset book depreciation method.	—
`RIB-ASB-LIFE` ASB_LIFE	Derived	This is the life of the asset.	—
`RIB-ASB-LIFE-REM` ASB_LIFE_REM	Derived	This is the remaining life for the asset.	—
`RIB-ASB-INSRV-DATE` ASB_INSRV_DATE	Derived	This is the in-service date for the asset.	—
`RIB-ASB-CONVENTION` ASB_CONVENTION	Derived	This is the in-service convention for the asset.	—
`RIB-DSP-OVERRIDE` DSP_OVERRIDE	Derived	The word "OVERRIDE" displays if the disposal amount has been overridden.	—
`RIB-PROC-OVERRIDE` PROC_OVERRIDE	Derived	The word "OVERRIDE" displays if the proceeds amount has been overridden.	—
`RIB-COS-OVERRIDE` COS_OVERRIDE	Derived	The word "OVERRIDE" displays if the expense amount has been overridden.	—
`RIB-DEFR-OVERRIDE` DEFR_OVERRIDE	Derived	The word "OVERRIDE" displays if the deferred gain or loss amount has been overridden.	—
`RIB-TCRECAP-OVERRD` TCRECAP_OVERRD	Derived	The word "OVERRIDE" displays if the tax credit recapture amount has been overridden.	—
`RIB-CALC-DEPR-LTD` CALC_DEPR_LTD	Derived	This is the life-to-date calculated depreciation	—
`RIB-DSP-NET-VALUE` DSP_NET_VALUE	Derived	The Disposal Net Value is calculated as follows: Book Basis - Life-to-Date Depreciation.	—
`RIB-AST-LOCATION` AST_LOCATION	Derived	This is the location associated with the asset.	—
`RIB-AST-DIVISION` AST_DIVISION	Derived	This is the division associated with the asset.	—
`RIB-AST-TYPE` AST_TYPE	Derived	This is the type associated with the asset.	—
`RIB-AST-SUBTYPE` AST_SUBTYPE	Derived	This is the subtype associated with the asset.	—
`RIB-CREATION-DATE` PK CREATION_DATE	Numeric 8 (yyyymmdd)	This is the record creation date	AM41.1
`RIB-CREATION-TIME` PK CREATION_TIME	Numeric 6 (hhmmss)	This is the record creation time	AM41.1
`RIB-CREATOR-ID` CREATOR_ID	Alpha 10	This is the login ID of the person creating the record.	AM41.1
`RIB-REINSTATE-DATE` REINSTATE_DATE	Numeric 8 (yyyymmdd)	This is the reinstatement date for the disposed asset.	AM41.1

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Used in
`RIBSET1`	`ASSET`, `BOOK`, `CREATION-DATE`, `CREATION-TIME`	Primary, KeyChange	AM241, AM300, AM330, AM41.1
`RIBSET2`	`BOOK`, `ASSET`, `CREATION-DATE`, `CREATION-TIME`		AM310
`RIBSET3`	`ASSET`, `REINSTATE-DATE`, `BOOK`, `CREATION-DATE`, `CREATION-TIME`		AM41.1

Relations

One to one (7) — lookups and parents

Relation	Table	Rules	Condition	Field map
Amasset	AMASSET	Not Required	Valid When RIB-ASSET != Zeroes	`RIB-ASSET` → `AST-ASSET`
Amassetrin	AMASSETRIN	Not Required		`RIB-ASSET` → `RIN-ASSET`, `RIB-CREATION-DATE` → `RIN-CREATION-DATE`, `RIB-CREATION-TIME` → `RIN-CREATION-TIME`
Amastbook	AMASTBOOK	Not Required		`RIB-ASSET` → `ASB-ASSET`, `RIB-BOOK` → `ASB-BOOK`
Amasttype	AMASTTYPE	Not Required		`AST-COMPANY` → `ATP-COMPANY`, `AST-ASSET-TYPE` → `ATP-ASSET-TYPE`, `AST-SUB-TYPE` → `ATP-SUB-TYPE`
Ambook	AMBOOK	Not Required		`RIB-BOOK` → `AMB-BOOK`
Amdivision	AMDIVISION	Not Required		`AST-DIVISION` → `DIV-DIVISION`
Amlocation	AMLOCATION	Not Required		`AST-LOCATION-NAME` → `LOC-LOCATION-NAME`

AMASTBKRIN – Asset Book Reinstatement

About AMASTBKRIN

Fields (69)

Indexes (3)

Relations

One to one (7) — lookups and parents

Programs

Updated by (4)

Referenced by (1)