AMASTITTRF – Asset Item Transfer

System
Asset Management (AM)
Prefix
ITR
Primary key
ASSET, PROCESS-SEQ, SEQ-NUMBER
Fields
41
Updated by
268 programs
Referenced by
2 programs

AMASTITTRF is the Asset Item Transfer table in Lawson Asset Management (prefix ITR). It is indexed by ASSET, PROCESS-SEQ, SEQ-NUMBER (ITRSET1); alternate indexes: ITRSET2. It is related 1:1 to AMASTITEM. It is updated by AC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 and 260 more and referenced by AM235 and AMDL.1. The table has 41 fields, 2 indexes and 1 documented relation.

About AMASTITTRF

This file contains historical asset item information related to transfers.

Fields (41)

Column = COBOL field name without the ITR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
ITR-ASSET PK
ASSET		Numeric 10Key field. This is the transfer-from asset. The asset number contains up to ten numeric characters that uniquely identify an asset. Assets are automatically numbered system-wide.AM135, AM154, AM30.1, AM30.2
ITR-TO-ASSET
TO_ASSET		Numeric 10This is the transfer-to asset. The asset number contains up to ten numeric characters that uniquely identify an asset. Assets are automatically numbered system-wide.AM135, AM154, AM30.1, AM30.2
ITR-PROCESS-SEQ PK
PROCESS_SEQ		Numeric 6Key field. This is the sequence number for this transfer process.AM135, AM154, AM30.1, AM30.2
ITR-TRANSFER-DATE
TRANSFER_DATE		Numeric 8 (yyyymmdd)This is the date of the transfer.AM135, AM154, AM30.1, AM30.2
ITR-TRANSFER-TYPE
TRANSFER_TYPE		Alpha 1This is type of the transfer: intracompany or intercompany
  • T Intracompany
  • I Intercompany
AM135, AM154, AM30.1, AM30.2
ITR-SEQ-NUMBER PK
SEQ_NUMBER		Numeric 6A unique number assigned to each transaction in the Lawson system. This is the from-asset sequence number for the transfer.AM135, AM154, AM30.1, AM30.2
ITR-TO-SEQ-NUMBER
TO_SEQ_NUMBER		Numeric 6A unique number assigned to each transaction in the Lawson system. This is the to-asset sequence number for the transfer.AM135, AM154, AM30.1, AM30.2
ITR-ITEM-NBR
ITEM_NBR		Alpha 32The 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.AM135, AM154, AM30.1, AM30.2
ITR-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The item description.AM135, AM154, AM30.1, AM30.2
ITR-PURCHASE-DATE
PURCHASE_DATE		Numeric 8 (yyyymmdd)This is the purchase date for the asset. The purchase date can be different from the in-service dates used for the depreciation books.AM135, AM154, AM30.1, AM30.2
ITR-ITEM-QUANTITY
ITEM_QUANTITY		Numeric 8The number of units that make up the from-asset item. Each unit of an item is exactly the same as every other unit of the item.AM135, AM154, AM30.1, AM30.2
ITR-TO-IT-QUANTITY
TO_IT_QUANTITY		Numeric 8The number of units that make up the to-asset item. Each unit of an item is exactly the same as every other unit of the item.AM135, AM154, AM30.1, AM30.2
ITR-ITEM-COST-BASE
ITEM_COST_BASE		Signed 18.2This is the item cost in the base currency for the from-asset.AM135, AM154, AM30.1, AM30.2
ITR-FR-IT-CST-BASE
FR_IT_CST_BASE		Signed 18.2—AM135, AM154, AM30.1, AM30.2
ITR-TO-IT-CST-BASE
TO_IT_CST_BASE		Signed 18.2This is the item cost in the base currency of the from-company for the to-asset.AM135, AM154, AM30.1, AM30.2
ITR-ITEM-TAX-BASE
ITEM_TAX_BASE		Signed 18.2This is the item tax for the from-asset in the base currency.AM135, AM154, AM30.1, AM30.2
ITR-FR-IT-TAX-BASE
FR_IT_TAX_BASE		Signed 18.2—AM135, AM154, AM30.1, AM30.2
ITR-TO-IT-TAX-BASE
TO_IT_TAX_BASE		Signed 18.2This is the item tax in the base currency of the from-company for the to-asset.AM135, AM154, AM30.1, AM30.2
ITR-ITEM-COST-TRAN
ITEM_COST_TRAN		Signed 18.2This is the item cost for the from-asset in the transaction currency.AM135, AM154, AM30.1, AM30.2
ITR-TO-IT-CST-TRAN
TO_IT_CST_TRAN		Signed 18.2This is the item cost for the to-asset in the transaction currency.AM135, AM154, AM30.1, AM30.2
ITR-ITEM-TAX-TRAN
ITEM_TAX_TRAN		Signed 18.2This is the item tax for the from-asset in the transaction currency.AM135, AM154, AM30.1, AM30.2
ITR-TO-IT-TAX-TRAN
TO_IT_TAX_TRAN		Signed 18.2This is the item tax for the to-asset in the transaction currency.AM135, AM154, AM30.1, AM30.2
ITR-BASE-ND
BASE_ND		Numeric 1The number of decimal positions defined for the from-company base currency.AM135, AM154, AM30.1, AM30.2
ITR-TO-BASE-ND
TO_BASE_ND		Numeric 1The number of decimal positions defined for the to-company base currency.AM135, AM154, AM30.1, AM30.2
ITR-TRAN-ND
TRAN_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.AM135, AM154, AM30.1, AM30.2
ITR-PO-NBR
PO_NBR		Alpha 14The purchase order number field is an optional field for your reference. You can enter the original purchase order number on which this asset was included.AM135, AM30.1, AM30.2
ITR-PO-RELEASE
PO_RELEASE		Numeric 4Used to identify a purchase order release (created from a Blanket or Standing order).AM135, AM30.1, AM30.2
ITR-PO-CODE
PO_CODE		Alpha 4This is the purchase order code.AM135, AM30.1, AM30.2
ITR-VENDOR
VENDOR		Alpha 9 (Right Justified)The vendor's identification code.AM135, AM154, AM30.1, AM30.2
ITR-VENDOR-NAME
VENDOR_NAME		Alpha 30This is the name of the vendor from whom the asset was purchased.AM135, AM154, AM30.1, AM30.2
ITR-INVOICE
INVOICE		Alpha 22This is the invoice identifier.AM135, AM154, AM30.1, AM30.2
ITR-SUFFIX
SUFFIX		Numeric 3This is the suffix for the invoice.AM135, AM154, AM30.1, AM30.2
ITR-DIST-SEQ-NBR
DIST_SEQ_NBR		Numeric 6This is the distribution sequence number for the item.AM135, AM154, AM30.1, AM30.2
ITR-MODEL-NUMBER
MODEL_NUMBER		Alpha 30This is model number of the item.AM135, AM154, AM30.1, AM30.2
ITR-SERIAL-NUMBER
SERIAL_NUMBER		Alpha 30This is the serial number of the item.AM135, AM154, AM30.1, AM30.2
ITR-ACTIVITY
ACTIVITY		Alpha 15This is the activity associated with the asset. 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.AM135, AM154, AM30.1, AM30.2
ITR-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5This is the account category associated with the asset. Account 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. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category.AM135, AM154, AM30.1, AM30.2
ITR-BAR-CODE
BAR_CODE		Alpha 30This field contains the asset item bar code.AM154
ITR-LOC-DTL
LOC_DTL		Alpha 14This field contains the asset item detail location bar code.AM135, AM154, AM30.1, AM30.2
ITR-TO-LOC-DTL
TO_LOC_DTL		Alpha 14This field contains the location detail bar code to which the item is being transferred.AM135, AM154, AM30.1, AM30.2
ITR-GRANT
GRANT		Alpha 30—AM135, AM154, AM30.1, AM30.2

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ITRSET1ASSET, PROCESS-SEQ, SEQ-NUMBERPrimaryAC160, AM115, AM117, AM125, AM135, AM15.1, AM15.2, AM15.3 +22 more (list truncated in source)
ITRSET2ASSET, SEQ-NUMBER, PROCESS-SEQAMDL.1

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
AmastitemAMASTITEMRequiredITR-ASSET → ASI-ASSET, ITR-SEQ-NUMBER → ASI-SEQ-NUMBER

Programs

Updated by (268)

Referenced by (2)