AMCLASSDEP – This file contains the depreciation information for account level depreciation to support Telecommunications Industry…

System
Asset Management (AM)
Prefix
CLD
Primary key
COMPANY, BOOK, ASSET-TYPE, SUB-TYPE, AST-ACCT-UNIT, EXP-ACCT-UNIT, ACM-ACCT-UNIT, YR-END-DATE, PERIOD
Fields
18
Updated by
263 programs
Referenced by
6 programs

AMCLASSDEP is the This file contains the depreciation information for account level depreciation to support Telecommunications Industry… table in Lawson Asset Management (prefix CLD). It is indexed by COMPANY, BOOK, ASSET-TYPE, SUB-TYPE, AST-ACCT-UNIT, EXP-ACCT-UNIT, ACM-ACCT-UNIT, YR-END-DATE, PERIOD (CLDSET1); alternate indexes: CLDSET2, CLDSET3, CLDSET4, CLDSET5 and CLDSET6. It is updated by AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM170 and 255 more and referenced by AM01.1, AM01.2, AM01.3, AM282, AM90.6 and AM90.7. The table has 18 fields, 6 indexes and 0 documented relations.

About AMCLASSDEP

This file contains the depreciation information for account level depreciation to support Telecommunications Industry requirements for class level depreciation.

Fields (18)

Column = COBOL field name without the CLD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
CLD-COMPANY PK
COMPANY		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM170 +52 more (list truncated in source)
CLD-BOOK PK
BOOK		Alpha 10A user-defined book name. Books are used by assets for calculating depreciation, replacement cost, and insurance values, and for reporting.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM170 +52 more (list truncated in source)
CLD-ASSET-TYPE PK
ASSET_TYPE		Alpha 10An asset type represents a grouping of like assets. Asset types are used to group assets into reporting classes and to default common asset definition data.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM170 +52 more (list truncated in source)
CLD-SUB-TYPE PK
SUB_TYPE		Alpha 10An asset subtype represents a more detailed grouping of assets within an asset type grouping. Asset subtypes are used to group assets into reporting classes and allow common asset definition data to default. Subtypes must be unique within an asset type.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM170 +52 more (list truncated in source)
CLD-AST-ACCT-UNIT PK
AST_ACCT_UNIT		Alpha 15The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM170 +52 more (list truncated in source)
CLD-EXP-ACCT-UNIT PK
EXP_ACCT_UNIT		Alpha 15The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM170 +52 more (list truncated in source)
CLD-ACM-ACCT-UNIT PK
ACM_ACCT_UNIT		Alpha 15The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM170 +52 more (list truncated in source)
CLD-YR-END-DATE PK
YR_END_DATE		Numeric 8 (yyyymmdd)—AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM170 +52 more (list truncated in source)
CLD-PERIOD PK
PERIOD		Numeric 2This is the current accounting period. This field is updated by Period Closing (GL199).AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM170 +52 more (list truncated in source)
CLD-DEPR-CP
DEPR_CP		Signed 18.2—AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM170 +52 more (list truncated in source)
CLD-DEPR-YTD
DEPR_YTD		Signed 18.2—AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM170 +52 more (list truncated in source)
CLD-DEPR-LTD
DEPR_LTD		Signed 18.2—AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM170 +52 more (list truncated in source)
CLD-STATUS-CP-CALC
STATUS_CP_CALC		Alpha 1This field indicates whether depreciation has been calculated for the current period.
  • N No
  • Y Yes
AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM170 +52 more (list truncated in source)
CLD-RW-COMPUTE-AMT
RW_COMPUTE_AMT		Signed 18.5—AM180
CLD-DEPR-RATE
DEPR_RATE		Percent 6.3 (Percent)This field contains the depreciation rate that was used as a multiplier to the RW-Compute-Amt (Annual Depreciation Rate divided by Periods Per Year).—
CLD-CREATION-DATE
CREATION_DATE		Numeric 8 (yyyymmdd)This is the date that this line was added to the requisition.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM170 +52 more (list truncated in source)
CLD-CREATION-TIME
CREATION_TIME		Numeric 6 (hhmmss)The creation time.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM170 +52 more (list truncated in source)
CLD-CREATOR-ID
CREATOR_ID		Alpha 10This field is used to store the login id of the person who entered the record.AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM170 +52 more (list truncated in source)

Indexes (6)

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

IndexKeysFlagsConditionUsed in
CLDSET1COMPANY, BOOK, ASSET-TYPE, SUB-TYPE, AST-ACCT-UNIT, EXP-ACCT-UNIT, ACM-ACCT-UNIT, YR-END-DATE, PERIODPrimaryAC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM170 +22 more (list truncated in source)
CLDSET2COMPANY, BOOK, ASSET-TYPE, SUB-TYPE, EXP-ACCT-UNIT, AST-ACCT-UNIT, ACM-ACCT-UNIT, YR-END-DATE, PERIODAM90.6, AM90.7
CLDSET3COMPANY, BOOK, ASSET-TYPE, SUB-TYPE, ACM-ACCT-UNIT, AST-ACCT-UNIT, EXP-ACCT-UNIT, YR-END-DATE, PERIODAM90.6, AM90.7
CLDSET4COMPANY, BOOK, YR-END-DATE, PERIOD, ASSET-TYPE, SUB-TYPE, AST-ACCT-UNIT, EXP-ACCT-UNIT, ACM-ACCT-UNITAM01.1, AM01.2, AM01.3, AM180, AM190, AM282
CLDSET5BOOK, ASSET-TYPE, SUB-TYPE, COMPANY, AST-ACCT-UNIT, EXP-ACCT-UNIT, ACM-ACCT-UNIT, YR-END-DATE, PERIOD—
CLDSET6ASSET-TYPE, SUB-TYPE, BOOK, COMPANY, AST-ACCT-UNIT, EXP-ACCT-UNIT, ACM-ACCT-UNIT, YR-END-DATE, PERIOD—

Programs

Updated by (263)

Referenced by (6)