AMASSETRVL – No description in the Lawson data dictionary
- System
- Asset Management (AM)
- Prefix
RVL- Primary key
ASSET,PROCESS-SEQ- Fields
- 47
- Updated by
- 0 programs
- Referenced by
- 0 programs
AMASSETRVL is a Lawson Asset Management table (prefix RVL); no description in the lawson data dictionary. It is indexed by ASSET, PROCESS-SEQ (RVLSET1); alternate indexes: RVLSET2 and RVLSET3. The table has 47 fields, 3 indexes and 0 documented relations.
About AMASSETRVL
No description in the Lawson data dictionary.
Fields (47)
Column = COBOL field name without the RVL- 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 |
|---|---|---|---|
#RVL-ASSET PKASSET | Numeric 10 | — | — |
#RVL-PROCESS-SEQ PKPROCESS_SEQ | Numeric 6 | — | — |
#RVL-STATUSSTATUS | Alpha 1 | — | — |
#RVL-RVL-TOT-CSTBASRVL_TOT_CSTBAS | Signed 18.2 | — | — |
#RVL-RVL-TOT-TAXBASRVL_TOT_TAXBAS | Signed 18.2 | — | — |
#RVL-RVL-TOT-CSTTRNRVL_TOT_CSTTRN | Signed 18.2 | — | — |
#RVL-RVL-TOT-TAXTRNRVL_TOT_TAXTRN | Signed 18.2 | — | — |
#RVL-RVL-DATERVL_DATE | Numeric 8 (yyyymmdd) | — | — |
#RVL-RVL-TIMERVL_TIME | Numeric 8 | — | — |
#RVL-ORG-TOT-CSTBASORG_TOT_CSTBAS | Signed 18.2 | — | — |
#RVL-ORG-TOT-TAXBASORG_TOT_TAXBAS | Signed 18.2 | — | — |
#RVL-ORG-TOT-CSTTRNORG_TOT_CSTTRN | Signed 18.2 | — | — |
#RVL-ORG-TOT-TAXTRNORG_TOT_TAXTRN | Signed 18.2 | — | — |
#RVL-RVL-AMOUNTRVL_AMOUNT | Signed 18.2 | — | — |
#RVL-RVL-PRECENTRVL_PRECENT | Signed 7.3 | — | — |
#RVL-RVL-TYPE SET3RVL_TYPE | Numeric 1 | — | — |
#RVL-COMPANYCOMPANY | Numeric 4 | — | — |
#RVL-BOOK SET2BOOK | Alpha 10 | — | — |
#RVL-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | — | — |
#RVL-TAG-NBRTAG_NBR | Alpha 12 | — | — |
#RVL-LEASE-COMPANYLEASE_COMPANY | Numeric 4 | — | — |
#RVL-LEASELEASE | Alpha 19 | — | — |
#RVL-ASSET-GROUPASSET_GROUP | Alpha 10 | — | — |
#RVL-OBJ-IDOBJ_ID | Numeric 12 | — | — |
#RVL-ASSET-CATEGORYASSET_CATEGORY | Alpha 1 | — | — |
#RVL-SIMULATEDSIMULATED | Alpha 1 | — | — |
#RVL-WORK-IN-PROCWORK_IN_PROC | Alpha 1 | — | — |
#RVL-TAX-EXEMPTTAX_EXEMPT | Alpha 1 | — | — |
#RVL-USEDUSED | Alpha 1 | — | — |
#RVL-BASE-NDBASE_ND | Numeric 1 | — | — |
#RVL-TRAN-NDTRAN_ND | Numeric 1 | — | — |
#RVL-ASSET-TYPEASSET_TYPE | Alpha 10 | — | — |
#RVL-SUB-TYPESUB_TYPE | Alpha 10 | — | — |
#RVL-LOCATION-NAMELOCATION_NAME | Alpha 15 | — | — |
#RVL-DIVISIONDIVISION | Alpha 15 | — | — |
#RVL-CURRENCY-CODECURRENCY_CODE | Alpha 5 | — | — |
#RVL-ITEM-LAST-DATEITEM_LAST_DATE | Numeric 8 (yyyymmdd) | — | — |
#RVL-ITEM-LAST-SEQITEM_LAST_SEQ | Numeric 6 | — | — |
#RVL-ACCT-GRPACCT_GRP | Alpha 10 | — | — |
#RVL-ACCT-UNITACCT_UNIT | Alpha 15 | — | — |
#RVL-AU-GROUPAU_GROUP | Alpha 10 | — | — |
#RVL-SELECT-NAMESELECT_NAME | Alpha 15 | — | — |
#RVL-CREATION-DATECREATION_DATE | Numeric 8 (yyyymmdd) | — | — |
#RVL-CREATION-TIMECREATION_TIME | Numeric 8 | — | — |
#RVL-OPERATOROPERATOR | Alpha 10 | — | — |
#RVL-ACTIVITYACTIVITY | Alpha 15 | — | — |
#RVL-ACCT-CATEGORYACCT_CATEGORY | Alpha 5 | — | — |
Indexes (3)
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 |
|---|---|---|---|---|
RVLSET1 |
| Primary | AM155 | |
RVLSET2 |
| — | ||
RVLSET3 |
| — |
Programs
No Lawson programs are documented as updating or referencing this table.