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.
| 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-TYPERVL_TYPE | Numeric 1 | — | — |
RVL-COMPANYCOMPANY | Numeric 4 | — | — |
RVL-BOOKBOOK | 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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
RVLSET1 | ASSET, PROCESS-SEQ | Primary | AM155 | |
RVLSET2 | ASSET, PROCESS-SEQ, BOOK | — | ||
RVLSET3 | ASSET, PROCESS-SEQ, RVL-TYPE | — |
Programs
No Lawson programs are documented as updating or referencing this table.