AMASSETRIN

Asset Reinstatement

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.

REFERENCED BY
AM241


UPDATED BY
AM170 AM300 AM41.1 AM330

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RIN-ASSET
Element: Asset
Numeric 10
Required. 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
Element: Dsp Status
Alpha 1
This field indicates the status of the disposal. Valid values are: R = Released N = Not Released
AM170 AM41.1
RIN-DSP-DATE
Element: Dsp Date
Numeric 8 (yyyymmdd)
This is the date of the disposal.
AM41.1
RIN-DSP-METHOD
Element: Dsp Method
Alpha 1
This 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
Element: Dsp Property
Alpha 10
This is the user-defined name of a disposal property. It represents a kind of disposed-of asset.
AM41.1
RIN-DSP-QUANTITY
Element: Item Tot Qty
Numeric 10
This field indicates the asset quantity disposed of.
AM41.1
RIN-LEASE-COMPANY
Element: Company
Numeric 4
The lessor company for the disposed leased asset.
AM41.1
RIN-LEASE
Element: Lease
Alpha 19
The lease number associated with the disposed leased asset.
AM41.1
RIN-ASSET-GROUP
Element: Asset Group
Alpha 10
The asset group assigned to the disposed leased asset.
AM41.1
RIN-FULL-PARTIAL
Element: Full Partial
Alpha 1
This 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
Element: Proceeds Curr
Alpha 5
This is the currency for the Proceeds account.
AM41.1
RIN-PROCEEDS
Element: Intl Amt
Signed 18.2
This field contains the proceeds of the sale of this asset based on the book value in this record.
AM41.1
RIN-COST-SALE-CURR
Element: Cost Sale Curr
Alpha 5
This is the currency for the cost of the sale of the asset.
AM41.1
RIN-COST-SALE
Element: Intl Amt
Signed 18.2
This is the cost of the sale of the asset.
AM41.1
RIN-ITEM-TOT-QTY
Element: Item Tot Qty
Numeric 10
This is the total item quantity for the disposal.
AM41.1
RIN-IT-TOT-CSTBASE
Element: Intl Amt
Signed 18.2
This is the total item cost in the base currency.
AM41.1
RIN-IT-TOT-CSTTRAN
Element: Intl Amt
Signed 18.2
This is the total item cost in the transaction currency.
AM41.1
RIN-IT-TOT-TAXBASE
Element: Intl Amt
Signed 18.2
This is the total item tax in the base currency.
AM41.1
RIN-IT-TOT-TAXTRAN
Element: Intl Amt
Signed 18.2
This is the total item tax in the transaction currency.
AM41.1
RIN-BASE-ND
Element: Base Nd
Numeric 1
The number of decimal positions defined for the company base currency.
AM41.1
RIN-TRAN-ND
Element: Acct Nd
Numeric 1
The number of decimal positions defined for the transaction currency.
AM41.1
RIN-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
AM41.1
RIN-ITEM-LAST-DATE
Element: Item Last Date
Numeric 8 (yyyymmdd)
This is the last changed date for the record.
AM41.1
RIN-ITEM-LAST-SEQ
Element: Seq Number
Numeric 6
This is the last sequence number for the last change to the record.
AM41.1
RIN-CREATION-DATE
Element: Creation Date
Numeric 8 (yyyymmdd)
This is the date that the disposal record was created.
AM41.1
RIN-CREATION-TIME
Element: Creation Time
Numeric 6 (hhmmss)
This is the time the disposal record was created.
AM41.1
RIN-CREATOR-ID
Element: Operator
Alpha 10
This is the ID of the person creating the disposal record.
AM41.1
RIN-AST-DSP-ASSET
Element: Ast Dsp Asset
Derived
This is the disposal asset.
RIN-AST-TAG-NBR
Element: Ast Tag Nbr
Derived
This is the asset tag number. A tag number is a user-definable identifier assigned to an asset.
RIN-AST-ASSET-GRP
Element: Ast Asset Grp
Derived
This 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
Element: Ast Descrip
Derived
This is the asset description for the disposed-of asset.
RIN-REINSTATE-DATE
Element: Reinstate Date
Numeric 8 (yyyymmdd)
This is the reinstatement date of the asset.
AM41.1
RIN-COMPANY
Element: Company
Numeric 4
This is the company the asset is associated with.
AM41.1


AMASSETRIN FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RINSET1 ASSET
CREATION-DATE
CREATION-TIME
AM170 AM300
AM330 AM41.1
RINSET2 COMPANY
ASSET
CREATION-DATE
CREATION-TIME
AM241


AMASSETRIN FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Amasset AMASSET Not Required
RIN-ASSET->AST-ASSET
Amassetdsp AMASSETDSP Not Required
RIN-ASSET->ASD-ASSET


AMASSETRIN FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Amastbkrin AMASTBKRIN
RIN-ASSET->RIB-ASSET
RIN-REINSTATE-DATE->RIB-REINSTATE-DATE
  RIB-BOOK
  RIB-CREATION-DATE
  RIB-CREATION-TIME
Amastitrin AMASTITRIN
RIN-ASSET->RIT-ASSET
RIN-REINSTATE-DATE->RIT-REINSTATE-DATE
  RIT-PROCESS-SEQ
  RIT-SEQ-NUMBER
  RIT-CREATION-DATE
  RIT-CREATION-TIME


File created: Thu Jun 09 02:04:52 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.