|
|
AMASTITCNV FILE
Asset Item Conversion
This file contains non-Lawson asset item information to be converted to asset
items in the Lawson Asset Management system.
REFERENCED BY
AM96.1 AM98.1
UPDATED BY
AM97.1 AM500
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ITC-CONVERSION-NBR Alpha 22 AM97.1
Element: Conversion NumRequired key. This is the number for
the asset to be converted.
ITC-SEQ-NUMBER Numeric 6 AM97.1
Element: Sequence NumbeRequired key. The sequence number is a
unique number assigned to each
transaction to be transferred into the
Lawson system.
ITC-ITEM-NBR Alpha 32 AM97.1
Element: Item Number The user-defined number assigned to the
asset item. The item number must be
unique within an asset, but can be
duplicated from asset to asset.
ITC-DESCRIPTION Alpha 30 (Lower Case) AM97.1
Element: Item DescriptiThis is the item description.
ITC-PURCHASE-DATE Numeric 8 (yyyymmdd) AM97.1
Element: Purchase Date This is the date the asset was
purchased. The purchase date can be
different from the in-service dates for
the depreciation books.
ITC-ITEM-QUANTITY Numeric 8 AM97.1
Element: Item Quantity Item quantity is the number of units
that make up the asset item.
ITC-ITEM-COST-BASE Signed 15.2 AM97.1
Item Cost Base This is the cost for the item in
Currency General Ledger base currency.
ITC-ITEM-TAX-BASE Signed 15.2 AM97.1
Item Tax Base This is the tax on the item in General
Currency Ledger base currency.
ITC-ITEM-COST-TRAN Signed 15.2 AM97.1
Item Cost This is the item cost in transaction
Transaction Currency (asset) currency.
ITC-ITEM-TAX-TRAN Signed 15.2 AM97.1
Item Tax This is the tax associated with the
Transaction Currency item in transaction (asset) currency.
ITC-PO-NBR Alpha 14 AM97.1
Purchase Order The Purchase Order Number field is for
Number your reference. It contains the original
purchase order number on which this
asset item was included.
ITC-PO-RELEASE Numeric 4 AM97.1
Element: PO Release Used to identify a purchase order
release (created from a Blanket or
Standing order).
ITC-PO-CODE Alpha 4 AM97.1
Element: PO Code This is the purchase order code.
ITC-VENDOR Alpha 9 (Right Justified) AM97.1
Element: Vendor This is the vendor's identification
code.
ITC-VENDOR-NAME Alpha 30 AM97.1
Element: Vendor Name This is the vendor's name for the asset
item.
ITC-INVOICE Alpha 22 AM97.1
Element: Invoice This number identifies the invoice for
the item.
ITC-MODEL-NUMBER Alpha 30 AM97.1
Element: Model Number This is the model number of the asset
item.
ITC-SERIAL-NUMBER Alpha 30 AM97.1
Element: Serial Number This is the serial number of the asset
item.
ITC-ACTIVITY Alpha 15 AM97.1
Element: 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.
Activities are grouped or organized by
activity levels. There are two types of
activities: "posting allowed" and
"summary only." Use posting level
activities to budget and maintain all
posted transactions. Summary activities
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
ITC-ACCT-CATEGORY Alpha 5 AM97.1
Element: Account CategoAccount categories are groupings of
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in the Lawson Activity
Management system. All transactions are
posted to an account category within an
activity.
ITC-ITEM-LOC-DTL Alpha 14 AM97.1
Element: Item Loc Dtl This field contains the location detail
assigned to the item.
ITC-BAR-CODE Alpha 30 AM97.1
Element: Bar Code This field contains the bar code
assigned to the item.
ITC-INV-DATE Numeric 8 (yyyymmdd)
Element: Invoice Date This field contains the date of the last
inventory.
ITC-INV-TIME Numeric 6 (hhmmss)
Element: Inv Time This field contains the time of the last
inventory.
ITC-INV-ITEM-COND Alpha 1 AM97.1
Element: Inv Item Cond This field contains the assessed
condition of the item. Valid values
are:
G = Good
F = Fair
D = Damaged
AMASTITCNV FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ITCSET1 CONVERSION-NBR AM500 AM96.1
SEQ-NUMBER AM97.1 AM98.1
AMASTITCNV FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amassetcnv AMASSETCNV Not Required
ITC-CONVERSION-NBR -> ACN-CONVERSION-NBR
Amcnvasset AMCNVASSET Not Required
ITC-CONVERSION-NBR -> CVA-CONVERSION-NBR
AMASTITCNV FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amastbkcnv AMASTBKCNV
ITC-CONVERSION-NBR -> ABC-CONVERSION-NBR
ABC-BOOK
Amastmxcnv AMASTMXCNV
ITC-CONVERSION-NBR -> MCV-CONVERSION-NBR
MCV-MATRIX-CAT
Amasttrcnv AMASTTRCNV
ITC-CONVERSION-NBR -> TNC-CONVERSION-NBR
TNC-SEQ-NUMBER
|
