AMASTRPAIR – Asset Repair

System
Asset Management (AM)
Prefix
ASR
Primary key
ASSET, REPAIR-DATE, SEQ-NUMBER
Fields
26
Updated by
270 programs
Referenced by
1 program

AMASTRPAIR is the Asset Repair table in Lawson Asset Management (prefix ASR). It is indexed by ASSET, REPAIR-DATE, SEQ-NUMBER (ASRSET1). It is updated by AC160, AM115, AM117, AM118, AM135, AM15.1, AM15.2, AM15.3 and 262 more and referenced by AM224. The table has 26 fields, 1 index and 0 documented relations.

About AMASTRPAIR

The Asset Repair file stores repair and maintenance cost records for assets.

Fields (26)

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

Field / columnTypeDescription & valuesUpdated by
ASR-SYSTEM
SYSTEM		Alpha 2This field stores a two-character code that identifies the Lawson application system where the asset repair record was created. For example, GL = General Ledger, AP = Accounts Payable, and so on.AM118, AM18.1, AM18.2, AM20.6, AM21.6
ASR-ASSET PK
ASSET		Numeric 10The asset number of the asset that was repaired. The asset number contains up to ten numeric characters that uniquely identify an asset. Assets are automatically numbered system-wide. The asset number does not change unless an asset is partially transferred or disposed of.AM118, AM135, AM154, AM18.1, AM18.2, AM20.6, AM21.6, AM30.1 +1 more
ASR-TAG-NBR
TAG_NBR		Alpha 12The tag number of the asset that was repaired. The tag number is a user definable identifier assigned to an asset.AM118, AM18.1, AM18.2, AM20.6, AM21.6
ASR-SEQ-NUMBER PK
SEQ_NUMBER		Numeric 6A unique sequence number assigned to the repair record.AM118, AM18.1, AM18.2, AM20.6, AM21.6
ASR-VENDOR
VENDOR		Alpha 9 (Right Justified)The vendor number associated with the asset repair.AM118, AM18.1, AM18.2, AM20.6, AM21.6
ASR-INVOICE
INVOICE		Alpha 22The invoice number associated with the asset repair.AM118, AM18.1, AM18.2, AM20.6, AM21.6
ASR-SUFFIX
SUFFIX		Numeric 3The invoice suffix number associated with the asset repair.AM118, AM18.1, AM18.2, AM20.6, AM21.6
ASR-DIST-SEQ-NBR
DIST_SEQ_NBR		Numeric 6The distribution sequence number associated with the asset repair.AM118, AM18.1, AM18.2, AM20.6, AM21.6
ASR-ACTIVITY
ACTIVITY		Alpha 15The activity associated with the asset repair.AM118, AM18.1, AM18.2, AM20.6, AM21.6
ASR-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5The account category associated with the asset repair.AM118, AM18.1, AM18.2, AM20.6, AM21.6
ASR-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)A description of the asset repair.AM118, AM18.1, AM18.2, AM20.6, AM21.6
ASR-REPAIR-TRAN
REPAIR_TRAN		Signed 18.2The cost of the asset repair in the currency of the transaction.AM118, AM18.1, AM18.2, AM20.6, AM21.6
ASR-REPAIR-TX-TRAN
REPAIR_TX_TRAN		Signed 18.2The tax amount of the asset repair in the currency of the transaction.AM118, AM18.1, AM18.2, AM20.6, AM21.6
ASR-REPAIR-BASE
REPAIR_BASE		Signed 18.2The cost of the repair in the base currency of the posting company.AM118, AM18.1, AM18.2, AM20.6, AM21.6
ASR-REPAIR-TX-BASE
REPAIR_TX_BASE		Signed 18.2The tax amount of the asset repair in the base currency of the posting company.AM118, AM18.1, AM18.2, AM20.6, AM21.6
ASR-CURRENCY-CODE
CURRENCY_CODE		Alpha 5The currency of the transaction.AM118, AM18.1, AM18.2, AM20.6, AM21.6
ASR-TRAN-ND
TRAN_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.AM118, AM18.1, AM18.2, AM20.6, AM21.6
ASR-BASE-ND
BASE_ND		Numeric 1The number of decimal positions defined for the company base currency.AM118, AM18.1, AM18.2, AM20.6, AM21.6
ASR-REPAIR-DATE PK
REPAIR_DATE		Numeric 8 (yyyymmdd)The date the asset was repaired or maintained.AM118, AM18.1, AM18.2, AM20.6, AM21.6
ASR-PO-NBR
PO_NBR		Alpha 14The purchase order number field is an optional field for your reference. It is assumed to contain the original purchase order number on which this asset was included.AM118, AM18.1, AM18.2, AM20.6, AM21.6
ASR-PO-RELEASE
PO_RELEASE		Numeric 4Used to identify a purchase order release (created from a Blanket or Standing order).AM118, AM18.1, AM18.2, AM20.6, AM21.6
ASR-PO-CODE
PO_CODE		Alpha 4This is the purchase order code.AM118, AM18.1, AM18.2, AM20.6, AM21.6
ASR-CREATION-DATE
CREATION_DATE		Numeric 8 (yyyymmdd)The date the asset repair record was created.AM118, AM18.1, AM18.2, AM20.6, AM21.6
ASR-CREATION-TIME
CREATION_TIME		Numeric 6 (hhmmss)The time the asset repair record was created.AM118, AM18.1, AM18.2, AM20.6, AM21.6
ASR-CREATOR-ID
CREATOR_ID		Alpha 10This field identifies the operator that created the asset repair record.AM118, AM18.1, AM18.2, AM20.6, AM21.6
ASR-INV-COMPANY
INV_COMPANY		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.AM118, AM18.1, AM18.2, AM20.6, AM21.6

Indexes (1)

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

IndexKeysFlagsConditionUsed in
ASRSET1ASSET, REPAIR-DATE, SEQ-NUMBERPrimaryAC160, AM115, AM117, AM118, AM135, AM15.1, AM15.2, AM15.3 +22 more (list truncated in source)

Programs

Updated by (270)

Referenced by (1)