Lawson Insight Technical Documentation |
|
AMCLASSDEP
AMCLASSDEP FILE
This file contains the depreciation information for account level depreciation
to support Telecommunications Industry requirements for class level
depreciation.
REFERENCED BY
AM90.6 AM90.7 AM01.1 AM01.2 AM01.3 AM282
UPDATED BY
AC160 AM115 AM117 AM15.1 AM15.2 AM15.3
AM15.4 AM170 AM180 AM19.1 AM19.2 AM190
AM20.1 AM20.2 AM20.3 AM20.4 AM20.5 AM20.6
AM21.1 AM21.2 AM21.3 AM21.4 AM21.5 AM21.6
AM500 AM551 AM96.1 AM98.1 AP115 AP125
AP126 AP131 AP20.1 AP20.2 AP20.3 AP20.4
AP20.5 AP20.7 AP21.1 AP220 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.2 AP30.4 AP305
API1.1 API2.1 BL120 BL122 BL130 BL20.1
BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520
BL820 BL92.1 MA180 MA41.1 MA41.2 MA41.4
MA41.7 MA43.1 MA43.2 MA43.3 MA43.4 MA43.6
MA43.7 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA63.1 MA65.1 MA66.2 MA66.3 MA67.2
MA67.3 MA68.2 MA68.3 MA68.5 MA70.1 MA75.1
MA80.1 MAI1.1 PD10.1 PD10.2 PD130 PD20.1
PD20.2 PD20.3 PO100 PO101 PO122 PO131
PO20.1 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO23.1 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO27.2 PO29.1 PO30.1 PO30.2 PO30.3
PO300 PO31.1 PO31.2 PO32.2 PO32.4 PO33.1
PO34.1 PO35.1 PO36.1 PO36.2 PO38.1 PO39.1
PO39.2 PO44.1 PO50.1 PO52.1 PO520 PO536
POI3.1 POID.1 POII.1 POIJ.1 RQ10.1 RQ10.2
WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CLD-COMPANY Numeric 4 AC160 AM115
Element: Company Identifies the AP company if the AM117 AM15.1
resource type = V. Identifies the HR AM15.2 AM15.3
company if the resource type = E. It is AM15.4 AM170
blank for type A, P or Q resources. AM180 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
...
CLD-BOOK Alpha 10 AC160 AM115
Element: Book A user-defined book name. Books are AM117 AM15.1
used by assets for calculating AM15.2 AM15.3
depreciation, replacement cost, and AM15.4 AM170
insurance values, and for reporting. AM180 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
...
CLD-ASSET-TYPE Alpha 10 AC160 AM115
Element: Asset Type An asset type represents a grouping of AM117 AM15.1
like assets. Asset types are used to AM15.2 AM15.3
group assets into reporting classes and AM15.4 AM170
to default common asset definition data. AM180 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
...
CLD-SUB-TYPE Alpha 10 AC160 AM115
Element: Sub Type An asset subtype represents a more AM117 AM15.1
detailed grouping of assets within an AM15.2 AM15.3
asset type grouping. Asset subtypes are AM15.4 AM170
used to group assets into reporting AM180 AM19.1
classes and allow common asset AM19.2 AM20.1
definition data to default. Subtypes AM20.2 AM20.3
must be unique within an asset type. AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
...
CLD-AST-ACCT-UNIT Alpha 15 AC160 AM115
Element: Acct Unit The accounting unit is a shorthand AM117 AM15.1
notation representing the variable level AM15.2 AM15.3
number. When used in the General Ledger AM15.4 AM170
Account Master file, the accounting unit AM180 AM19.1
must be defined in the General Ledger AM19.2 AM20.1
Names file as a posting accounting unit. AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
...
CLD-EXP-ACCT-UNIT Alpha 15 AC160 AM115
Element: Acct Unit The accounting unit is a shorthand AM117 AM15.1
notation representing the variable level AM15.2 AM15.3
number. When used in the General Ledger AM15.4 AM170
Account Master file, the accounting unit AM180 AM19.1
must be defined in the General Ledger AM19.2 AM20.1
Names file as a posting accounting unit. AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
...
CLD-ACM-ACCT-UNIT Alpha 15 AC160 AM115
Element: Acct Unit The accounting unit is a shorthand AM117 AM15.1
notation representing the variable level AM15.2 AM15.3
number. When used in the General Ledger AM15.4 AM170
Account Master file, the accounting unit AM180 AM19.1
must be defined in the General Ledger AM19.2 AM20.1
Names file as a posting accounting unit. AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
...
CLD-YR-END-DATE Numeric 8 (yyyymmdd) AC160 AM115
Element: Yr End Date AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM170
AM180 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
...
CLD-PERIOD Numeric 2 AC160 AM115
Element: Period This is the current accounting period. AM117 AM15.1
This field is updated by Period Closing AM15.2 AM15.3
(GL199). AM15.4 AM170
AM19.1 AM19.2
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM500 AM551
AM96.1 AM98.1
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
CLD-DEPR-CP Signed 18.2 AC160 AM115
Element: Intl Amt AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM170
AM180 AM19.1
AM19.2 AM190
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM500 AM551
AM96.1 AM98.1
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
...
CLD-DEPR-YTD Signed 18.2 AC160 AM115
Element: Intl Amt AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM170
AM180 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
...
CLD-DEPR-LTD Signed 18.2 AC160 AM115
Element: Intl Amt AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM170
AM180 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
...
CLD-STATUS-CP-CALC Alpha 1 AC160 AM115
Element: Status Cp CalcThis field indicates whether AM117 AM15.1
depreciation has been calculated for the AM15.2 AM15.3
current period. AM15.4 AM170
N = No AM180 AM19.1
Y = Yes AM19.2 AM190
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM500 AM551
AM96.1 AM98.1
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
...
CLD-RW-COMPUTE-AMT Signed 18.5 AM180
Element: Intl Cost
CLD-DEPR-RATE Percent 6.3 (Percent)
Element: Depr Rate 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 Numeric 8 (yyyymmdd) AC160 AM115
Element: Creation Date This is the date that this line was AM117 AM15.1
added to the requisition. AM15.2 AM15.3
AM15.4 AM170
AM180 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
...
CLD-CREATION-TIME Numeric 6 (hhmmss) AC160 AM115
Element: Creation Time The creation time. AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM170
AM180 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
...
CLD-CREATOR-ID Alpha 10 AC160 AM115
Element: Operator This field is used to store the login AM117 AM15.1
id of the person who entered the record. AM15.2 AM15.3
AM15.4 AM170
AM180 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1 AP115
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 API1.1
API2.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
...
AMCLASSDEP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CLDSET1 COMPANY AC160 AM115
BOOK AM117 AM15.1
ASSET-TYPE AM15.2 AM15.3
SUB-TYPE AM15.4 AM170
AST-ACCT-UNIT AM180 AM19.1
EXP-ACCT-UNIT AM19.2 AM20.1
ACM-ACCT-UNIT AM20.2 AM20.3
YR-END-DATE AM20.4 AM20.5
PERIOD AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM90.6
AM90.7 AM96.1
AM98.1 AP115
...
CLDSET2 COMPANY AM90.6 AM90.7
BOOK
ASSET-TYPE
SUB-TYPE
EXP-ACCT-UNIT
AST-ACCT-UNIT
ACM-ACCT-UNIT
YR-END-DATE
PERIOD
CLDSET3 COMPANY AM90.6 AM90.7
BOOK
ASSET-TYPE
SUB-TYPE
ACM-ACCT-UNIT
AST-ACCT-UNIT
EXP-ACCT-UNIT
YR-END-DATE
PERIOD
CLDSET4 COMPANY AM01.1 AM01.2
BOOK AM01.3 AM180
YR-END-DATE AM190 AM282
PERIOD
ASSET-TYPE
SUB-TYPE
AST-ACCT-UNIT
EXP-ACCT-UNIT
ACM-ACCT-UNIT
CLDSET5 BOOK
ASSET-TYPE
SUB-TYPE
COMPANY
AST-ACCT-UNIT
EXP-ACCT-UNIT
ACM-ACCT-UNIT
YR-END-DATE
PERIOD
CLDSET6 ASSET-TYPE
SUB-TYPE
BOOK
COMPANY
AST-ACCT-UNIT
EXP-ACCT-UNIT
ACM-ACCT-UNIT
YR-END-DATE
PERIOD
|