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