AMASSETRIN FILE
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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RIN-ASSET Numeric 10 AM41.1
Asset Number Required. The asset number contains up
to ten numeric characters that uniquely
identify an asset. Assets are
automatically numbered system-wide.
RIN-DSP-STATUS Alpha 1 AM170 AM41.1
Dsp Status This field indicates the status of the
disposal. Valid values are:
R = Released
N = Not Released
RIN-DSP-DATE Numeric 8 (yyyymmdd) AM41.1
Dsp Date This is the date of the disposal.
RIN-DSP-METHOD Alpha 1 AM41.1
Dsp Method 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
RIN-DSP-PROPERTY Alpha 10 AM41.1
Dsp Property This is the user-defined name of a
disposal property. It represents a kind
of disposed-of asset.
RIN-DSP-QUANTITY Numeric 10 AM41.1
Dsp Quantity This field indicates the asset quantity
disposed of.
RIN-LEASE-COMPANY Numeric 4 AM41.1
Lease Company The lessor company for the disposed
leased asset.
RIN-LEASE Alpha 19 AM41.1
Lease The lease number associated with the
disposed leased asset.
RIN-ASSET-GROUP Alpha 10 AM41.1
Asset Group The asset group assigned to the
disposed leased asset.
RIN-FULL-PARTIAL Alpha 1 AM41.1
Full Partial 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
RIN-PROCEEDS-CURR Alpha 5 AM41.1
Proceeds Curr This is the currency for the Proceeds
account.
RIN-PROCEEDS Signed 15.2 AM41.1
Proceeds This field contains the proceeds of the
sale of this asset based on the book
value in this record.
RIN-COST-SALE-CURR Alpha 5 AM41.1
Cost Sale Curr This is the currency for the cost of
the sale of the asset.
RIN-COST-SALE Signed 15.2 AM41.1
Cost Sale This is the cost of the sale of the
asset.
RIN-ITEM-TOT-QTY Numeric 10 AM41.1
Item Tot Qty This is the total item quantity for the
disposal.
RIN-IT-TOT-CSTBASE Signed 15.2 AM41.1
It Tot Cstbase This is the total item cost in the base
currency.
RIN-IT-TOT-CSTTRAN Signed 15.2 AM41.1
It Tot Csttran This is the total item cost in the
transaction currency.
RIN-IT-TOT-TAXBASE Signed 15.2 AM41.1
It Tot Taxbase This is the total item tax in the base
currency.
RIN-IT-TOT-TAXTRAN Signed 15.2 AM41.1
It Tot Taxtran This is the total item tax in the
transaction currency.
RIN-BASE-ND Numeric 1 AM41.1
Base Number Of The number of decimal positions defined
Decimals for the company base currency.
RIN-TRAN-ND Numeric 1 AM41.1
Transaction Number The number of decimal positions defined
of Decimals for the transaction currency.
RIN-CURRENCY-CODE Alpha 5 AM41.1
Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
RIN-ITEM-LAST-DATE Numeric 8 (yyyymmdd) AM41.1
Item Last Date This is the last changed date for the
record.
RIN-ITEM-LAST-SEQ Numeric 6 AM41.1
Item Last Seq This is the last sequence number for
the last change to the record.
RIN-CREATION-DATE Numeric 8 (yyyymmdd) AM41.1
Creation Date This is the date that the disposal
record was created.
RIN-CREATION-TIME Numeric 6 (hhmmss) AM41.1
Creation Time This is the time the disposal record
was created.
RIN-CREATOR-ID Alpha 10 AM41.1
Creator Id This is the ID of the person creating
the disposal record.
RIN-AST-DSP-ASSET Derived
Ast Dsp Asset This is the disposal asset.
RIN-AST-TAG-NBR Derived
Ast Tag Nbr This is the asset tag number. A tag
number is a user-definable identifier
assigned to an asset.
RIN-AST-ASSET-GRP Derived
Ast Asset Grp 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 Derived
Ast Descrip This is the asset description for the
disposed-of asset.
RIN-REINSTATE-DATE Numeric 8 (yyyymmdd) AM41.1
Reinstate Date This is the reinstatement date of the
asset.
RIN-COMPANY Numeric 4 AM41.1
Company This is the company the asset is
associated with.
AMASSETRIN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RINSET1 ASSET This index accesses the reinstatement AM170 AM300
CREATION-DATE information by asset. AM41.1
CREATION-TIME
RINSET2 COMPANY This index accesses the reinstatement AM241
ASSET information by company.
CREATION-DATE
CREATION-TIME
AMASSETRIN FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME 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
|
