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.

Field / columnTypeDescription & valuesUpdated by
BRV-ASSET PK
ASSET
Numeric 10AM155
BRV-BOOK PK
BOOK
Alpha 10AM155
BRV-PROCESS-SEQ PK
PROCESS_SEQ
Numeric 6AM155
BRV-BOOK-STATUS
BOOK_STATUS
Alpha 1AM155
BRV-CURRENCY-CODE
CURRENCY_CODE
Alpha 5AM155
BRV-TRAN-ND
TRAN_ND
Numeric 1AM155
BRV-LIFE
LIFE
Numeric 4AM155
BRV-LIFE-REM
LIFE_REM
Signed 7.3AM155
BRV-BOOK-BASIS
BOOK_BASIS
Signed 18.2AM155
BRV-RVL-BOOK-BASIS
RVL_BOOK_BASIS
Signed 18.2AM155
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 8AM155
BRV-RVL-OPERATOR
RVL_OPERATOR
Alpha 10AM155
BRV-RVL-LTD
RVL_LTD
Signed 18.2
BRV-RVL-METHOD
RVL_METHOD
Alpha 1AM155
BRV-METHOD
METHOD
Alpha 10AM155
BRV-METH-SWITCHED
METH_SWITCHED
Alpha 1AM155
BRV-INSRV-DATE
INSRV_DATE
Numeric 8 (yyyymmdd)AM155
BRV-METH-TABLE-YR
METH_TABLE_YR
Numeric 4AM155
BRV-DEPR-STARTDATE
DEPR_STARTDATE
Numeric 8 (yyyymmdd)AM155
BRV-LIFE-YEARS
LIFE_YEARS
Signed 5.2AM155
BRV-STATUS-CP-CALC
STATUS_CP_CALC
Alpha 1
BRV-DEPR-CP
DEPR_CP
Signed 18.2AM155
BRV-DEPR-CP-ALLOW
DEPR_CP_ALLOW
Signed 18.2
BRV-DEPR-YTD
DEPR_YTD
Signed 18.2AM155
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.2AM155
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.2AM155
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 12AM155
BRV-RVL-AMOUNT
RVL_AMOUNT
Signed 18.2AM155
BRV-COMPANY
COMPANY
Numeric 4AM155
BRV-RVL-DEPR-YTD
RVL_DEPR_YTD
Signed 18.2
BRV-RVL-DEPR-LTD
RVL_DEPR_LTD
Signed 18.2AM155
BRV-DIVISION
DIVISION
Alpha 15AM155
BRV-LOCATION-NAME
LOCATION_NAME
Alpha 15AM155
BRV-RVL-PERCENT
RVL_PERCENT
Signed 7.3AM155

Indexes (2)

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

IndexKeysFlagsConditionUsed in
BRVSET1ASSET, BOOK, PROCESS-SEQPrimary
BRVSET4COMPANY, BOOK, ASSET, PROCESS-SEQAM242

Programs

Updated by (1)

Referenced by (1)