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.
UPDATED BY
| FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
AIA-ASSET
Element: Asset | Numeric 10
Key field. This is the asset for the
asset item adjustment.
|
|
AIA-SEQ-NUMBER
Element: Sequence Number | Numeric 6
Key field. The sequence number is a
unique number assigned to each
transaction in the Lawson system.
|
|
AIA-PROCESS-SEQ
Element: Process Sequence | Numeric 6
Key field. This is the sequence number
for the adjustment process.
|
|
AIA-ITEM-NBR
Element: Item Number | Alpha 32
The number assigned to the asset item.
The item number must be unique within an
asset, but can be duplicated from asset
to asset. An item is part of an asset
composed of different elements, but
depreciated as a common asset unit.
|
|
AIA-TO-ITEM-NBR
Element: To Item Number | Alpha 32
The number assigned to the asset item
for the transfer-to asset. The item
number must be unique within an
asset, but can be duplicated from asset
to asset.
|
|
AIA-DESCRIPTION
Element: Description | Alpha 30 (Lower Case)
This is the item description.
|
|
AIA-TO-DESCRIPTION
Element: To Description | Alpha 30 (Lower Case)
This is the item description for the
to-asset.
|
|
AIA-PURCHASE-DATE
Element: Purchase Date | Numeric 8 (yyyymmdd)
The date the asset was purchased. This
purchased date can be different from the
in-service dates for the depreciation
books used.
|
|
AIA-TO-PURCH-DATE
Element: To Purchase Date | Numeric 8 (yyyymmdd)
This is the purchase date for the
transfer-to asset.
|
|
AIA-ITEM-QUANTITY
Element: Item Quantity | Numeric 8
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.
|
|
AIA-TO-IT-QUANTITY
Element: To Item Quantity | Numeric 8
This is the item quantity for the
to-asset.
|
|
AIA-ITEM-COST-BASE
Item Cost Base
Currency | Signed 18.2
This is the item cost in the base
currency.
|
|
AIA-TO-IT-CST-BASE
To Item Cost Base
Currency | Signed 18.2
This is the item cost in the base
currency for the transfer-to asset.
|
|
AIA-ITEM-TAX-BASE
Item Tax Base
Currency | Signed 18.2
This is the item tax in the base
currency.
|
|
AIA-TO-IT-TAX-BASE
To Item Tax Base
Currency | Signed 18.2
This is the item tax in the base
currency for the transfer-to asset.
|
|
AIA-ITEM-COST-TRAN
Item Cost
Transaction Currency | Signed 18.2
This is the item cost in the
transaction currency.
|
|
AIA-TO-IT-CST-TRAN
To Item Cost Tran
Currency | Signed 18.2
This is the to-asset item cost in the
transaction currency.
|
|
AIA-ITEM-TAX-TRAN
Item Tax
Transaction Currency | Signed 18.2
This is the item tax in the base
currency.
|
|
AIA-TO-IT-TAX-TRAN
To Item Tax Tran
Currency | Signed 18.2
This is the to-asset item tax in the
transaction currency.
|
|
AIA-BASE-ND
Base Number of
Decimals | Numeric 1
The number of decimal positions defined
for the company base currency.
|
|
AIA-TRAN-ND
Transaction Number
of Decimals | Numeric 1
The number of decimals assigned to a
particular account as determined by the
account currency.
|
|
AIA-PO-NBR
Element: PO Number | Alpha 14
The Purchase Order Number field is an
optional field for your reference. It
contains the number of the original
purchase order on which this asset was
included.
|
|
AIA-TO-PO-NBR
Element: To PO Number | Alpha 14
This is the purchase order number for
the transfer-to asset.
|
|
AIA-PO-RELEASE
Element: PO Release | Numeric 4
Used to identify a purchase order
release (created from a Blanket or
Standing order).
|
|
AIA-TO-PO-RELEASE
Element: To PO Release | Numeric 4
Used to identify a purchase order
release (created from a Blanket or
Standing order).
|
|
AIA-PO-CODE
Element: PO Code | Alpha 4
This is the purchase order code.
|
|
AIA-TO-PO-CODE
Element: To PO Code | Alpha 4
This is the purchase order code.
|
|
AIA-VENDOR
Element: Vendor | Alpha 9 (Right Justified)
The vendor's identification code.
|
|
AIA-TO-VENDOR
Element: To Vendor | Alpha 9 (Right Justified)
This is the vendor code for the
transfer-to asset.
|
|
AIA-VENDOR-NAME
Element: Vendor Name | Alpha 30
This is the vendor name for the asset.
|
|
AIA-TO-VENDOR-NAME
Element: To Vendor Name | Alpha 30
This is the vendor name for the
transfer-to asset.
|
|
AIA-INVOICE
Element: Invoice | Alpha 22
Used to identify the invoice.
|
|
AIA-TO-INVOICE
Element: To Invoice | Alpha 22
This is the invoice identifier for the
transfer-to asset.
|
|
AIA-SUFFIX
Element: Suffix | Numeric 3
This is the suffix for the invoice.
|
|
AIA-DIST-SEQ-NBR
Distribution
Sequence Number | Numeric 6
A unique sequence number.
|
|
AIA-MODEL-NUMBER
Element: Model Number | Alpha 30
This is the model number for the asset
item.
|
|
AIA-TO-MODEL-NBR
Element: To Model Number | Alpha 30
This is the model number for the
to-asset item.
|
|
AIA-SERIAL-NUMBER
Element: Serial Number | Alpha 30
This is the serial number of the asset
item.
|
|
AIA-TO-SERIAL-NBR
Element: To Serial Number | Alpha 30
This is the serial number of the
to-asset item.
|
|
AIA-ACTIVITY
Element: Activity | Alpha 15
This is the activity for the asset
being adjusted. Activities are the
processes or procedures that produce
work. Cost objects (products, services,
customers, and so on) are the reasons
for performing the activity. Activities
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
Element: To Activity | Alpha 15
This is the activity for the
transfer-to asset.
|
|
AIA-ACCT-CATEGORY
Element: Account Category | Alpha 5
This is the account category for the
asset being adjusted. Account categories
are groupings of costs, revenues, or a
combination of both used for reporting
and inquiries for activities in the
Activity Management system. All
transactions are posted to an account
category within an activity.
|
|
AIA-TO-ACCT-CAT
Element: To Account Category | Alpha 5
This is the account category for the
transfer-to asset.
|
|
AIA-ITEM-LOC-DTL
Element: Item Loc Dtl | Alpha 14
This field contains the location detail
for the item.
|
|
AIA-TO-ITM-LOC-DTL
Element: To Itm Loc Dtl | Alpha 14
This field contains the new location
detail for the item.
|
|
AIA-BAR-CODE
Element: Bar Code | Alpha 30
This field contains the bar code
assigned to the asset item.
|
|
AIA-TO-BAR-CODE
Element: Bar Code | Alpha 30
This field contains the new bar code
assigned to the asset item.
|
|
AIA-INV-DATE
Element: Inv Date | Numeric 8 (yyyymmdd)
This is the system-generated date for
the last date the inventory was made.
|
|
AIA-TO-INV-DATE
Element: To Inv Date | Numeric 8 (yyyymmdd)
This is the new system-generated
inventory date.
|
|
AIA-INV-TIME
Element: Inv Time | Numeric 6 (hhmmss)
This is the last system-generated
inventory time.
|
|
AIA-TO-INV-TIME
Element: To Inv Time | Numeric 6 (hhmmss)
This is the new system-generated
inventory time.
|
|
AIA-INV-ITEM-COND
Element: Inv Item Cond | Alpha 1
This field contains the assessed
condition of the item before the item
was adjusted. Valid values are:
G = Good
F = Fair
D = Damaged
|
|
AIA-TO-INV-IT-COND
Element: To Inv It Cond | Alpha 1
Ths is the new assessed condition of the
item. Valid values are:
G = Good
F = Fair
D = Damaged
|
|
AIA-GRANT
Element: Grant | Alpha 30
|
|
AIA-TO-GRANT
Element: Grant | Alpha 30
|
|
