AMASSETRIN – Asset Reinstatement

System
Asset Management (AM)
Prefix
RIN
Primary key
ASSET, CREATION-DATE, CREATION-TIME
Fields
33
Updated by
4 programs
Referenced by
1 program

AMASSETRIN is the Asset Reinstatement table in Lawson Asset Management (prefix RIN). It is indexed by ASSET, CREATION-DATE, CREATION-TIME (RINSET1); alternate indexes: RINSET2. It is related 1:1 to AMASSET and AMASSETDSP and 1:M to AMASTBKRIN and AMASTITRIN. It is updated by AM170, AM300, AM330 and AM41.1 and referenced by AM241. The table has 33 fields, 2 indexes and 4 documented relations.

About AMASSETRIN

This file contains audit information related to reinstated disposed assets. It is updated by Reinstate Disposed Assets (AM41.1). The file contains a copy of the disposal information previously contained in AMASSETDSP, plus reinstatement information.

Fields (33)

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

Field / columnTypeDescription & valuesUpdated by
RIN-ASSET PK
ASSET		Numeric 10Required. The asset number contains up to ten numeric characters that uniquely identify an asset. Assets are automatically numbered system-wide.AM41.1
RIN-DSP-STATUS
DSP_STATUS		Alpha 1This field indicates the status of the disposal. Valid values are:
  • R Released
  • N Not Released
AM170, AM41.1
RIN-DSP-DATE
DSP_DATE		Numeric 8 (yyyymmdd)This is the date of the disposal.AM41.1
RIN-DSP-METHOD
DSP_METHOD		Alpha 1This field indicates the way in which the asset was disposed of. Valid values are:
  • A Abandoned
  • D Donated
  • E Exchanged
  • P Purged
  • R Retired
  • S Sold
  • T Traded
  • O Other
AM41.1
RIN-DSP-PROPERTY
DSP_PROPERTY		Alpha 10This is the user-defined name of a disposal property. It represents a kind of disposed-of asset.AM41.1
RIN-DSP-QUANTITY
DSP_QUANTITY		Numeric 10This field indicates the asset quantity disposed of.AM41.1
RIN-LEASE-COMPANY
LEASE_COMPANY		Numeric 4The lessor company for the disposed leased asset.AM41.1
RIN-LEASE
LEASE		Alpha 19The lease number associated with the disposed leased asset.AM41.1
RIN-ASSET-GROUP
ASSET_GROUP		Alpha 10The asset group assigned to the disposed leased asset.AM41.1
RIN-FULL-PARTIAL
FULL_PARTIAL		Alpha 1This field indicates whether the disposal was full (including all asset items) or partial (including only some asset items). Valid values are:
  • F Full
  • P Partial
AM41.1
RIN-PROCEEDS-CURR
PROCEEDS_CURR		Alpha 5This is the currency for the Proceeds account.AM41.1
RIN-PROCEEDS
PROCEEDS		Signed 18.2This field contains the proceeds of the sale of this asset based on the book value in this record.AM41.1
RIN-COST-SALE-CURR
COST_SALE_CURR		Alpha 5This is the currency for the cost of the sale of the asset.AM41.1
RIN-COST-SALE
COST_SALE		Signed 18.2This is the cost of the sale of the asset.AM41.1
RIN-ITEM-TOT-QTY
ITEM_TOT_QTY		Numeric 10This is the total item quantity for the disposal.AM41.1
RIN-IT-TOT-CSTBASE
IT_TOT_CSTBASE		Signed 18.2This is the total item cost in the base currency.AM41.1
RIN-IT-TOT-CSTTRAN
IT_TOT_CSTTRAN		Signed 18.2This is the total item cost in the transaction currency.AM41.1
RIN-IT-TOT-TAXBASE
IT_TOT_TAXBASE		Signed 18.2This is the total item tax in the base currency.AM41.1
RIN-IT-TOT-TAXTRAN
IT_TOT_TAXTRAN		Signed 18.2This is the total item tax in the transaction currency.AM41.1
RIN-BASE-ND
BASE_ND		Numeric 1The number of decimal positions defined for the company base currency.AM41.1
RIN-TRAN-ND
TRAN_ND		Numeric 1The number of decimal positions defined for the transaction currency.AM41.1
RIN-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).AM41.1
RIN-ITEM-LAST-DATE
ITEM_LAST_DATE		Numeric 8 (yyyymmdd)This is the last changed date for the record.AM41.1
RIN-ITEM-LAST-SEQ
ITEM_LAST_SEQ		Numeric 6This is the last sequence number for the last change to the record.AM41.1
RIN-CREATION-DATE PK
CREATION_DATE		Numeric 8 (yyyymmdd)This is the date that the disposal record was created.AM41.1
RIN-CREATION-TIME PK
CREATION_TIME		Numeric 6 (hhmmss)This is the time the disposal record was created.AM41.1
RIN-CREATOR-ID
CREATOR_ID		Alpha 10This is the ID of the person creating the disposal record.AM41.1
RIN-AST-DSP-ASSET
AST_DSP_ASSET		DerivedThis is the disposal asset.—
RIN-AST-TAG-NBR
AST_TAG_NBR		DerivedThis is the asset tag number. A tag number is a user-definable identifier assigned to an asset.—
RIN-AST-ASSET-GRP
AST_ASSET_GRP		DerivedThis is the asset group for the disposed-of asset. An asset group represents a parent asset number used to group assets for reporting.—
RIN-AST-DESCRIP
AST_DESCRIP		DerivedThis is the asset description for the disposed-of asset.—
RIN-REINSTATE-DATE
REINSTATE_DATE		Numeric 8 (yyyymmdd)This is the reinstatement date of the asset.AM41.1
RIN-COMPANY
COMPANY		Numeric 4This is the company the asset is associated with.AM41.1

Indexes (2)

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

IndexKeysFlagsConditionUsed in
RINSET1ASSET, CREATION-DATE, CREATION-TIMEPrimaryAM170, AM300, AM330, AM41.1
RINSET2COMPANY, ASSET, CREATION-DATE, CREATION-TIMEAM241

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
AmassetAMASSETNot RequiredRIN-ASSET → AST-ASSET
AmassetdspAMASSETDSPNot RequiredRIN-ASSET → ASD-ASSET

One to many (2) — child tables

RelationTableRulesConditionField map
AmastbkrinAMASTBKRINRIN-ASSET → RIB-ASSET, RIN-REINSTATE-DATE → RIB-REINSTATE-DATE, → RIB-BOOK, → RIB-CREATION-DATE, → RIB-CREATION-TIME
AmastitrinAMASTITRINRIN-ASSET → RIT-ASSET, RIN-REINSTATE-DATE → RIT-REINSTATE-DATE, → RIT-PROCESS-SEQ, → RIT-SEQ-NUMBER, → RIT-CREATION-DATE, → RIT-CREATION-TIME

Programs

Updated by (4)

Referenced by (1)