Lawson Insight Technical Documentation |
|
AMASTITADJ
AMASTITADJ FILE
Asset Item Adjustment
The Asset Item Adjustment file is an audit file that stores records of
changes that are made to Asset Item file records. Each asset item adjustment
record describes the before and after values of asset item fields that were
changed, as well as the date and time of the change and the operator who made
the changes.
REFERENCED BY
AM225 AMDL.1
UPDATED BY
AM115 AM117 AM125 AM15.1 AM15.2 AM15.3
AM15.4 AM170 AM20.1 AM20.2 AM20.3 AM20.4
AM20.5 AM20.6 AM21.1 AM21.2 AM21.3 AM21.4
AM21.5 AM21.6 AM300 AM500 AM51.1 AM551
AM96.1 AM97.1 AM98.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AIA-ASSET Numeric 10 AM115 AM117
Element: Asset Key field. This is the asset for the AM15.1 AM15.2
asset item adjustment. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-SEQ-NUMBER Numeric 6 AM115 AM117
Element: Sequence NumbeKey field. The sequence number is a AM15.1 AM15.2
unique number assigned to each AM15.3 AM15.4
transaction in the Lawson system. AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-PROCESS-SEQ Numeric 6 AM115 AM117
Element: Process SequenKey field. This is the sequence number AM15.1 AM15.2
for the adjustment process. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-ITEM-NBR Alpha 32 AM115 AM117
Element: Item Number The number assigned to the asset item. AM15.1 AM15.2
The item number must be unique within an AM15.3 AM15.4
asset, but can be duplicated from asset AM20.1 AM20.3
to asset. An item is part of an asset AM21.1 AM21.3
composed of different elements, but AM500 AM51.1
depreciated as a common asset unit. AM551 AM97.1
AIA-TO-ITEM-NBR Alpha 32 AM115 AM117
Element: To Item NumberThe number assigned to the asset item AM15.1 AM15.2
for the transfer-to asset. The item AM15.3 AM15.4
number must be unique within an AM20.1 AM20.3
asset, but can be duplicated from asset AM21.1 AM21.3
to asset. AM500 AM51.1
AM551 AM97.1
AIA-DESCRIPTION Alpha 30 (Lower Case) AM115 AM117
Element: Description This is the item description. AM15.1 AM15.2
AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-TO-DESCRIPTION Alpha 30 (Lower Case) AM115 AM117
Element: To DescriptionThis is the item description for the AM15.1 AM15.2
to-asset. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-PURCHASE-DATE Numeric 8 (yyyymmdd) AM115 AM117
Element: Purchase Date The date the asset was purchased. This AM15.1 AM15.2
purchased date can be different from the AM15.3 AM15.4
in-service dates for the depreciation AM20.1 AM20.3
books used. AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-TO-PURCH-DATE Numeric 8 (yyyymmdd) AM115 AM117
Element: To Purchase DaThis is the purchase date for the AM15.1 AM15.2
transfer-to asset. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-ITEM-QUANTITY Numeric 8 AM115 AM117
Element: Item Quantity The number of units that make up the AM15.1 AM15.2
asset item. Each unit of an item is AM15.3 AM15.4
exactly the same as every other unit of AM20.1 AM20.3
the item. AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-TO-IT-QUANTITY Numeric 8 AM115 AM117
Element: To Item QuantiThis is the item quantity for the AM15.1 AM15.2
to-asset. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-ITEM-COST-BASE Signed 18.2 AM115 AM117
Item Cost Base This is the item cost in the base AM15.1 AM15.2
Currency currency. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-TO-IT-CST-BASE Signed 18.2 AM115 AM117
To Item Cost Base This is the item cost in the base AM15.1 AM15.2
Currency currency for the transfer-to asset. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-ITEM-TAX-BASE Signed 18.2 AM115 AM117
Item Tax Base This is the item tax in the base AM15.1 AM15.2
Currency currency. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-TO-IT-TAX-BASE Signed 18.2 AM115 AM117
To Item Tax Base This is the item tax in the base AM15.1 AM15.2
Currency currency for the transfer-to asset. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-ITEM-COST-TRAN Signed 18.2 AM115 AM117
Item Cost This is the item cost in the AM15.1 AM15.2
Transaction Currency transaction currency. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-TO-IT-CST-TRAN Signed 18.2 AM115 AM117
To Item Cost Tran This is the to-asset item cost in the AM15.1 AM15.2
Currency transaction currency. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-ITEM-TAX-TRAN Signed 18.2 AM115 AM117
Item Tax This is the item tax in the base AM15.1 AM15.2
Transaction Currency currency. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-TO-IT-TAX-TRAN Signed 18.2 AM115 AM117
To Item Tax Tran This is the to-asset item tax in the AM15.1 AM15.2
Currency transaction currency. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-BASE-ND Numeric 1 AM115 AM117
Base Number of The number of decimal positions defined AM15.1 AM15.2
Decimals for the company base currency. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-TRAN-ND Numeric 1 AM115 AM117
Transaction Number The number of decimal positions defined AM15.1 AM15.2
of Decimals for the transaction currency. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-PO-NBR Alpha 14 AM115 AM117
Element: PO Number The Purchase Order Number field is an AM15.1 AM15.2
optional field for your reference. It AM15.3 AM15.4
contains the number of the original AM20.1 AM20.3
purchase order on which this asset was AM21.1 AM21.3
included. AM500 AM51.1
AM551 AM97.1
AIA-TO-PO-NBR Alpha 14 AM115 AM117
Element: To PO Number This is the purchase order number for AM15.1 AM15.2
the transfer-to asset. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-PO-RELEASE Numeric 4 AM115 AM117
Element: PO Release Used to identify a purchase order AM15.1 AM15.2
release (created from a Blanket or AM15.3 AM15.4
Standing order). AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-TO-PO-RELEASE Numeric 4 AM115 AM117
Element: To PO Release This is the PO Release Number for the AM15.1 AM15.2
to-asset, used to identify a purchase AM15.3 AM15.4
order release (created from a Blanket or AM20.1 AM20.3
Standing order). AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-PO-CODE Alpha 4 AM115 AM117
Element: PO Code This is the purchase order code. AM15.1 AM15.2
AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-TO-PO-CODE Alpha 4 AM115 AM117
Element: To PO Code This is the purchase order code for the AM15.1 AM15.2
to-asset. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-VENDOR Alpha 9 (Right Justified) AM115 AM117
Element: Vendor The vendor's identification code. AM15.1 AM15.2
AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-TO-VENDOR Alpha 9 (Right Justified) AM115 AM117
Element: To Vendor This is the vendor code for the AM15.1 AM15.2
transfer-to asset. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-VENDOR-NAME Alpha 30 AM115 AM117
Element: Vendor Name This is the vendor name for the asset. AM15.1 AM15.2
AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-TO-VENDOR-NAME Alpha 30 AM115 AM117
Element: To Vendor NameThis is the vendor name for the AM15.1 AM15.2
transfer-to asset. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-INVOICE Alpha 22 AM115 AM117
Element: Invoice Used to identify the invoice. AM15.1 AM15.2
AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-TO-INVOICE Alpha 22 AM115 AM117
Element: To Invoice This is the invoice identifier for the AM15.1 AM15.2
transfer-to asset. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-SUFFIX Numeric 3 AM115 AM117
Element: Suffix This is the suffix for the invoice. AM15.1 AM15.2
AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-DIST-SEQ-NBR Numeric 4 AM115 AM117
Distribution A unique sequence number. AM15.1 AM15.2
Sequence Number AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-MODEL-NUMBER Alpha 30 AM115 AM117
Element: Model Number This is the model number for the asset AM15.1 AM15.2
item. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-TO-MODEL-NBR Alpha 30 AM115 AM117
Element: To Model NumbeThis is the model number for the AM15.1 AM15.2
to-asset item. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-SERIAL-NUMBER Alpha 30 AM115 AM117
Element: Serial Number This is the serial number of the asset AM15.1 AM15.2
item. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-TO-SERIAL-NBR Alpha 30 AM115 AM117
Element: To Serial NumbThis is the serial number of the AM15.1 AM15.2
to-asset item. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-ACTIVITY Alpha 15 AM115 AM117
Element: Activity This is the activity for the asset AM15.1 AM15.2
being adjusted. Activities are the AM15.3 AM15.4
processes or procedures that produce AM20.1 AM20.3
work. Cost objects (products, services, AM21.1 AM21.3
customers, and so on) are the reasons AM500 AM51.1
for performing the activity. Activities AM551 AM97.1
and cost object activities are used
synonymously in the Lawson Activity
Management system. Direct costs are
posted to activities, and indirect costs
are allocated to activities based on
activity drivers.
AIA-TO-ACTIVITY Alpha 15 AM115 AM117
Element: To Activity This is the activity for the AM15.1 AM15.2
transfer-to asset. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-ACCT-CATEGORY Alpha 5 AM115 AM117
Element: Account CategoThis is the account category for the AM15.1 AM15.2
asset being adjusted. Account categories AM15.3 AM15.4
are groupings of costs, revenues, or a AM20.1 AM20.3
combination of both used for reporting AM21.1 AM21.3
and inquiries for activities in the AM500 AM51.1
Activity Management system. All AM551 AM97.1
transactions are posted to an account
category within an activity.
AIA-TO-ACCT-CAT Alpha 5 AM115 AM117
Element: To Account CatThis is the account category for the AM15.1 AM15.2
transfer-to asset. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-ITEM-LOC-DTL Alpha 14 AM115 AM117
Element: Item Loc Dtl This field contains the location detail AM15.1 AM15.2
for the item. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-TO-ITM-LOC-DTL Alpha 14 AM115 AM117
Element: To Itm Loc DtlThis field contains the new location AM15.1 AM15.2
detail for the item. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-BAR-CODE Alpha 30 AM115 AM117
Element: Bar Code This field contains the bar code AM15.1 AM15.2
assigned to the asset item. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-TO-BAR-CODE Alpha 30 AM115 AM117
Element: Bar Code This field contains the new bar code AM15.1 AM15.2
assigned to the asset item. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-INV-DATE Numeric 8 (yyyymmdd) AM115 AM117
Element: Invoice Date This is the system-generated date for AM15.1 AM15.2
the last date the inventory was made. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-TO-INV-DATE Numeric 8 (yyyymmdd) AM115 AM117
Element: To Inv Date This is the new system-generated AM15.1 AM15.2
inventory date. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-INV-TIME Numeric 6 (hhmmss) AM115 AM117
Element: Inv Time This is the last system-generated AM15.1 AM15.2
inventory time. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-TO-INV-TIME Numeric 6 (hhmmss) AM115 AM117
Element: To Inv Time This is the new system-generated AM15.1 AM15.2
inventory time. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AIA-INV-ITEM-COND Alpha 1 AM115 AM117
Element: Inv Item Cond This field contains the assessed AM15.1 AM15.2
condition of the item before the item AM15.3 AM15.4
was adjusted. Valid values are: AM20.1 AM20.3
G = Good AM21.1 AM21.3
F = Fair AM500 AM51.1
D = Damaged AM551 AM97.1
AIA-TO-INV-IT-COND Alpha 1 AM115 AM117
Element: To Inv It CondThs is the new assessed condition of the AM15.1 AM15.2
item. Valid values are: AM15.3 AM15.4
G = Good AM20.1 AM20.3
F = Fair AM21.1 AM21.3
D = Damaged AM500 AM51.1
AM551 AM97.1
AMASTITADJ FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AIASET1 ASSET AM115 AM117
PROCESS-SEQ AM125 AM15.1
SEQ-NUMBER AM15.2 AM15.3
AM15.4 AM170
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM225 AM300
AM500 AM51.1
AM551 AM96.1
AM97.1 AM98.1
AIASET2 ASSET AMDL.1
SEQ-NUMBER
PROCESS-SEQ
AMASTITADJ FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amassetadj AMASSETADJ Required
AIA-ASSET -> ASA-ASSET
AIA-PROCESS-SEQ -> ASA-PROCESS-SEQ
Amastitem AMASTITEM Required
AIA-ASSET -> ASI-ASSET
AIA-SEQ-NUMBER -> ASI-SEQ-NUMBER
|