AMASTBKRVL – No description in the Lawson data dictionary

System
Asset Management (AM)
Prefix
BRV
Primary key
ASSET, BOOK, PROCESS-SEQ
Fields
56
Updated by
1 program
Referenced by
1 program

AMASTBKRVL is a Lawson Asset Management table (prefix BRV); no description in the lawson data dictionary. It is indexed by ASSET, BOOK, PROCESS-SEQ (BRVSET1); alternate indexes: BRVSET4. It is updated by AM155 and referenced by AM242. The table has 56 fields, 2 indexes and 0 documented relations.

About AMASTBKRVL

No description in the Lawson data dictionary.

Fields (56)

Column = COBOL field name without the BRV- 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 / columnTypeDescription & valuesUpdated by
#BRV-ASSET PK
ASSET		Numeric 10—AM155
#BRV-BOOK PK
BOOK		Alpha 10—AM155
#BRV-PROCESS-SEQ PK
PROCESS_SEQ		Numeric 6—AM155
#BRV-BOOK-STATUS
BOOK_STATUS		Alpha 1—AM155
#BRV-CURRENCY-CODE
CURRENCY_CODE		Alpha 5—AM155
#BRV-TRAN-ND
TRAN_ND		Numeric 1—AM155
#BRV-LIFE
LIFE		Numeric 4—AM155
#BRV-LIFE-REM
LIFE_REM		Signed 7.3—AM155
#BRV-BOOK-BASIS
BOOK_BASIS		Signed 18.2—AM155
#BRV-RVL-BOOK-BASIS
RVL_BOOK_BASIS		Signed 18.2—AM155
#BRV-RVL-ASSET-TYPE
RVL_ASSET_TYPE		Alpha 10——
#BRV-RVL-SUB-TYPE
RVL_SUB_TYPE		Alpha 10——
#BRV-RVL-STATUS
RVL_STATUS		Alpha 1——
#BRV-RVL-DATE
RVL_DATE		Numeric 8 (yyyymmdd)—AM155
#BRV-RVL-TIME
RVL_TIME		Numeric 8—AM155
#BRV-RVL-OPERATOR
RVL_OPERATOR		Alpha 10—AM155
#BRV-RVL-LTD
RVL_LTD		Signed 18.2——
#BRV-RVL-METHOD
RVL_METHOD		Alpha 1—AM155
#BRV-METHOD
METHOD		Alpha 10—AM155
#BRV-METH-SWITCHED
METH_SWITCHED		Alpha 1—AM155
#BRV-INSRV-DATE
INSRV_DATE		Numeric 8 (yyyymmdd)—AM155
#BRV-METH-TABLE-YR
METH_TABLE_YR		Numeric 4—AM155
#BRV-DEPR-STARTDATE
DEPR_STARTDATE		Numeric 8 (yyyymmdd)—AM155
#BRV-LIFE-YEARS
LIFE_YEARS		Signed 5.2—AM155
#BRV-STATUS-CP-CALC
STATUS_CP_CALC		Alpha 1——
#BRV-DEPR-CP
DEPR_CP		Signed 18.2—AM155
#BRV-DEPR-CP-ALLOW
DEPR_CP_ALLOW		Signed 18.2——
#BRV-DEPR-YTD
DEPR_YTD		Signed 18.2—AM155
#BRV-DEPR-YTD-ALLOW
DEPR_YTD_ALLOW		Signed 18.2——
#BRV-DEPR-YTD-OVRRD
DEPR_YTD_OVRRD		Signed 18.2——
#BRV-DEPR-LTD
DEPR_LTD		Signed 18.2—AM155
#BRV-DEPR-LTD-ALLOW
DEPR_LTD_ALLOW		Signed 18.2——
#BRV-LAST-CLOSE
LAST_CLOSE		Signed 18.2——
#BRV-FIRST-LAST-FL
FIRST_LAST_FL		Alpha 1——
#BRV-INACT-YTD
INACT_YTD		Signed 5.3——
#BRV-INACT-LTD
INACT_LTD		Signed 7.3——
#BRV-SALVAGE-VALUE
SALVAGE_VALUE		Signed 18.2—AM155
#BRV-BUS-PERCENT
BUS_PERCENT		Signed 5.2——
#BRV-PERSONAL-USE
PERSONAL_USE		Alpha 10——
#BRV-YR1-EXP
YR1_EXP		Signed 18.2——
#BRV-TC-TABLE
TC_TABLE		Alpha 10——
#BRV-TC-PROPERTY
TC_PROPERTY		Signed 18.2——
#BRV-TAX-CREDIT
TAX_CREDIT		Signed 18.2——
#BRV-INS-METHOD
INS_METHOD		Alpha 10——
#BRV-INS-ACT-VAL
INS_ACT_VAL		Signed 18.2——
#BRV-INS-CMPTD-VAL
INS_CMPTD_VAL		Signed 18.2——
#BRV-RPL-METHOD
RPL_METHOD		Alpha 10——
#BRV-RPL-CMPTD-VAL
RPL_CMPTD_VAL		Signed 18.2——
#BRV-AST-TAG-NBR
AST_TAG_NBR		Alpha 12—AM155
#BRV-RVL-AMOUNT
RVL_AMOUNT		Signed 18.2—AM155
#BRV-COMPANY SET4
COMPANY		Numeric 4—AM155
#BRV-RVL-DEPR-YTD
RVL_DEPR_YTD		Signed 18.2——
#BRV-RVL-DEPR-LTD
RVL_DEPR_LTD		Signed 18.2—AM155
#BRV-DIVISION
DIVISION		Alpha 15—AM155
#BRV-LOCATION-NAME
LOCATION_NAME		Alpha 15—AM155
#BRV-RVL-PERCENT
RVL_PERCENT		Signed 7.3—AM155

Indexes (2)

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.

IndexKeysFlagsConditionUsed in
BRVSET1
  1. ASSET
  2. BOOK
  3. PROCESS-SEQ
Primary—
BRVSET4
  1. COMPANY
  2. BOOK
  3. ASSET
  4. PROCESS-SEQ
AM242

Programs

Updated by (1)

Referenced by (1)