AMASTITRIN FILE
This file contains audit asset item information related to reinstated
disposals. It contains a copy of the disposal information previously contained
in AMASTITDSP, plus reinstatment information.
UPDATED BY
AM300 AM41.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RIT-ASSET Numeric 10 AM41.1
Asset Number Key field. The asset number contains up
to ten numeric characters that uniquely
identify an asset. Assets ~$3
AMASTITRINSEQ-NUMBER
Key field. A unique number assigned to
each transaction in the Lawson system.
RIT-SEQ-NUMBER Numeric 6 AM41.1
Record Sequence A unique number assigned to each
Number transaction to be transferred into the
Lawson system.
RIT-PROCESS-SEQ Numeric 4 AM41.1
Process Seq This is the sequence number for this
disposal process.
RIT-DSP-DATE Numeric 8 (yyyymmdd) AM41.1
Dsp Date This is the date of the disposal.
RIT-DSP-METHOD Alpha 1 AM41.1
Dsp Method This is the date of the disposal.
A = Abandoned
D = Donated
E = Exchanged
P = Purged
R = Retired
S = Sold
T = Traded
O = Other
RIT-DSP-QUANTITY Numeric 10 AM41.1
Dsp Quantity This is the asset quantity that was
disposed of.
RIT-ITEM-NBR Alpha 32 AM41.1
Item Nbr The number assigned to the asset item.
The item number must be unique within an
asset, but can be duplicated from asset
to asset. The item number identifies an
item of an asset composed of different
elements but depreciated as a common
asset unit.
RIT-ITEM-QUANTITY Numeric 8 AM41.1
Item Quantity The number of units that make up the
asset item. Each unit of an item is
exactly the same as every other unit of
the item.
RIT-ITEM-COST-BASE Signed 15.2 AM41.1
Item Cost Base This is the item cost in the base
currency.
RIT-ITEM-TAX-BASE Signed 15.2 AM41.1
Item Tax Base This is the tax on the item in the base
currency.
RIT-ITEM-COST-TRAN Signed 15.2 AM41.1
Item Cost Tran This is the item cost in the
transaction currency.
RIT-ITEM-TAX-TRAN Signed 15.2 AM41.1
Item Tax Tran This is the tax on the item in the
transaction currency.
RIT-BASE-ND Numeric 1 AM41.1
Base Number Of The number of decimal positions defined
Decimals for the base currency.
RIT-TRAN-ND Numeric 1 AM41.1
Transaction Number The number of decimal positions defined
of Decimals for the transaction currency.
RIT-BAR-CODE Alpha 30 AM41.1
Bar Code This field contains the bar code of the
item being disposed.
RIT-CREATION-DATE Numeric 8 (yyyymmdd) AM41.1
Creation Date This field contains the record creation
date.
RIT-CREATION-TIME Numeric 6 (hhmmss) AM41.1
Creation Time This field contains the record creation
time.
RIT-CREATOR-ID Alpha 10 AM41.1
Creator Id This field contains the login ID of the
person creating the record.
RIT-REINSTATE-DATE Numeric 8 (yyyymmdd) AM41.1
Reinstate Date This field contains the reinstatement
date of the disposed item.
AMASTITRIN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RITSET1 ASSET This index accesses information by AM300 AM41.1
PROCESS-SEQ asset number and process sequence
SEQ-NUMBER number.
CREATION-DATE
CREATION-TIME
RITSET2 ASSET This index accesses information by
REINSTATE-DATEasset number and reinstatement date.
PROCESS-SEQ
SEQ-NUMBER
CREATION-DATE
CREATION-TIME
AMASTITRIN FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amastitem AMASTITEM Required
RIT-ASSET -> ASI-ASSET (ASISET1)
RIT-SEQ-NUMBER -> ASI-SEQ-NUMBER
|