AMSYSOPTS – System Options
- System
- Asset Management (AM)
- Prefix
AMO- Primary key
COMPANY,CREATION-DATE,CREATION-TIME- Fields
- 25
- Updated by
- 1 program
- Referenced by
- 0 programs
AMSYSOPTS is the System Options table in Lawson Asset Management (prefix AMO). It is indexed by COMPANY, CREATION-DATE, CREATION-TIME (AMOSET1). It is related 1:M to AMSYSOPTAU. It is updated by AM700. The table has 25 fields, 1 index and 1 documented relation.
About AMSYSOPTS
No description in the Lawson data dictionary.
Fields (25)
Column = COBOL field name without the AMO- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#AMO-COMPANY PKCOMPANY | Numeric 4 | This is the General Ledger company that the system default settings are associated with. | AM700 |
#AMO-CREATION-DATE PKCREATION_DATE | Numeric 8 (yyyymmdd) | This is the date that the setting were last adjusted. | AM700 |
#AMO-CREATION-TIME PKCREATION_TIME | Numeric 6 (hhmmss) | This is the time that the setting were last adjusted. | AM700 |
#AMO-CREATOR-IDCREATOR_ID | Alpha 10 | This is the login ID of the individual making the setting changes. | AM700 |
#AMO-OLD-HOLD-CODEOLD_HOLD_CODE | Alpha 1 | This is the hold code setting before the change. Valid values are:
| AM700 |
#AMO-NEW-HOLD-CODENEW_HOLD_CODE | Alpha 1 | This is the hold code setting after the change. Valid values are:
| AM700 |
#AMO-OLD-ITEM-FLAGOLD_ITEM_FLAG | Alpha 1 | This is the item numbering flag before the change. Valid values are:
| AM700 |
#AMO-NEW-ITEM-FLAGNEW_ITEM_FLAG | Alpha 1 | This is the item numbering flag after the change. Valid values are:
| AM700 |
#AMO-OLD-EXP-ACT-FLOLD_EXP_ACT_FL | Alpha 1 | This is the depreciation expense activity flag before the change. Valid values are:
| AM700 |
#AMO-NEW-EXP-ACT-FLNEW_EXP_ACT_FL | Alpha 1 | This is the depreciation expense activity flag after the change. Valid values are:
| AM700 |
#AMO-OLD-REM-LIFE-FOLD_REM_LIFE_F | Alpha 1 | This is the calculate remaining life flag before the change. Valid values are:
| AM700 |
#AMO-NEW-REM-LIFE-FNEW_REM_LIFE_F | Alpha 1 | This is the calculate remaining life flag after the change. Valid values are:
| AM700 |
#AMO-OLD-CONS-JE-FLOLD_CONS_JE_FL | Alpha 1 | This is the consolidate journal entry flag before the change. Valid values are:
| AM700 |
#AMO-NEW-CONS-JE-FLNEW_CONS_JE_FL | Alpha 1 | This is the consolidate journal entry flag after the change. Valid values are:
| AM700 |
#AMO-OLD-DISP-JE-FLOLD_DISP_JE_FL | Alpha 1 | This is the display journal entry flag before the change. Valid values are:
| — |
#AMO-NEW-DISP-JE-FLNEW_DISP_JE_FL | Alpha 1 | This is the display journal entry flag after the change. Valid values are:
| AM700 |
#AMO-OLD-DEP-EXP-FLOLD_DEP_EXP_FL | Alpha 1 | This is the depreciation expense allocation flag before the change. Valid values are:
| AM700 |
#AMO-NEW-DEP-EXP-FLNEW_DEP_EXP_FL | Alpha 1 | This is the current depreciation allocation flag. Valid values are: The value of this flag overrides the value of the DEP-EXP-ALLOC flag in AMSTYPE.
| AM700 |
#AMO-BLANK-AMBLANK_AM | Derived | Not used. | — |
#AMO-NEW-SPLIT-FLAGNEW_SPLIT_FLAG | Alpha 1 | —
| — |
#AMO-OLD-SPLIT-FLAGOLD_SPLIT_FLAG | Alpha 1 | —
| — |
#AMO-NEW-DISTRIB-FLNEW_DISTRIB_FL | Alpha 1 | —
| — |
#AMO-OLD-DISTRIB-FLOLD_DISTRIB_FL | Alpha 1 | —
| — |
#AMO-NEW-EVENT-ACCTNEW_EVENT_ACCT | Alpha 1 | —
| — |
#AMO-OLD-EVENT-ACCTOLD_EVENT_ACCT | Alpha 1 | —
| — |
Indexes (1)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
AMOSET1 |
| Primary | — |
Relations
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | |||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Amsysoptau | AMSYSOPTAU |
|
Programs
Updated by (1)
- AM700 Depreciation Expense Allocation Update