Asset Management – Lawson AM tables and programs

Asset Management (AM) in Lawson S3 v10 MSP6 has 101 tables, 160 online screens and 81 batch programs.

Tables (101)

TablePrefixDescriptionPrimary keyFields
AMACCOUNTAACAsset Management AccountCOMPANY, ACCT-GRP, ASSET-TYPE, SUB-TYPE, ACCT-TYPE, ASSET-EVENT10
AMACCTAUAAAAsset Account AuditCOMPANY, ACCT-GRP, ASSET-TYPE, SUB-TYPE, ACCT-TYPE, ASSET-EVENT, ACTION, DATE, TIME, UNIQUE-I-D16
AMACCTGPAUAGDAsset Account Group AuditCOMPANY, ACCT-GRP, ACTION, DATE, TIME, UNIQUE-I-D12
AMACCTGRPAAGAsset Account GroupCOMPANY, ACCT-GRP3
AMASSETASTAssetASSET87
AMASSETADJASAAsset AdjustmentASSET, PROCESS-SEQ70
AMASSETBODYAPNo description in the Lawson data dictionaryASSET7
AMASSETCNVACNAsset ConversionCONVERSION-NBR25
AMASSETDSPASDAsset DisposalASSET31
AMASSETGRPATGAsset GroupASSET-GROUP5
AMASSETINVITNAsset Item Adj InterfaceRUN-GROUP, ASSET, SEQ-NUMBER29
AMASSETRINRINAsset ReinstatementASSET, CREATION-DATE, CREATION-TIME33
AMASSETRVLRVLNo description in the Lawson data dictionaryASSET, PROCESS-SEQ47
AMASSETTRFATFAsset TransferASSET, PROCESS-SEQ73
AMASTBKADJABAAsset Book AdjustmentASSET, PROCESS-SEQ, BOOK76
AMASTBKCNVABCAsset Book ConversionCONVERSION-NBR, BOOK29
AMASTBKDSPABDAsset Book DisposalASSET, BOOK65
AMASTBKINVIBKAsset Book Item AdjustmentRUN-GROUP, BOOK, ASSET30
AMASTBKRINRIBAsset Book ReinstatementASSET, BOOK, CREATION-DATE, CREATION-TIME69
AMASTBKRVLBRVNo description in the Lawson data dictionaryASSET, BOOK, PROCESS-SEQ56
AMASTBKTRFABTAsset Book TransferASSET, PROCESS-SEQ, BOOK90
AMASTBOOKASBAsset BookASSET, BOOK70
AMASTCVBODYAQNo description in the Lawson data dictionaryCONVERSION-NBR7
AMASTITADJAIAAsset Item AdjustmentASSET, PROCESS-SEQ, SEQ-NUMBER55
AMASTITBODYAUNo description in the Lawson data dictionaryASSET, SEQ-NUMBER8
AMASTITCNVITCAsset Item ConversionCONVERSION-NBR, SEQ-NUMBER26
AMASTITDSPADSAsset Item DisposalASSET, PROCESS-SEQ, SEQ-NUMBER15
AMASTITEMASIAsset ItemASSET, SEQ-NUMBER46
AMASTITINVIIVThe Asset Item Master Inventory file contains the inventory information scanned by a hand-held terminal, and imported…RUN-GROUP, BAR-CODE, CREATION-DATE, CREATION-TIME11
AMASTITRINRITAsset Item ReinstatementASSET, PROCESS-SEQ, SEQ-NUMBER, CREATION-DATE, CREATION-TIME19
AMASTITTRFITRAsset Item TransferASSET, PROCESS-SEQ, SEQ-NUMBER41
AMASTMXCNVMCVAsset Attribute ConversionCONVERSION-NBR, MATRIX-CAT3
AMASTMXVALMXTAsset AttributesOBJ-ID, MATRIX-CAT3
AMASTRECAPRCPAsset Depreciation RecaptureRECAP-TYPE, ASSET, BOOK, RECAP-DATE6
AMASTRPAIRASRAsset RepairASSET, REPAIR-DATE, SEQ-NUMBER26
AMASTTRCNVTNCAsset Transaction ConversionCONVERSION-NBR, SEQ-NUMBER20
AMASTTYPAUASWAsset Type AuditCOMPANY, ASSET-TYPE, SUB-TYPE, ACTION, DATE, TIME, UNIQUE-I-D13
AMASTTYPEATPAsset TypeCOMPANY, ASSET-TYPE, SUB-TYPE9
AMAUGROUPAAUAsset Accounting Unit GroupCOMPANY, AU-GROUP15
AMAUGRPAUAUAAM Accounting Unit Group AuditCOMPANY, AU-GROUP, ACTION, DATE, TIME, UNIQUE-I-D12
AMBARCODEBCOBar CodeBAR-CODE4
AMBGRPBOOKAGBBook Group DetailBOOK, BOOK-GROUP3
AMBKHISTABHAsset Book HistoryASSET, BOOK, COMPANY, YR-END-DATE11
AMBKHISTXABXPeriod Asset Book HistoryASSET, BOOK, COMPANY, YR-END-DATE, PERIOD12
AMBKTEMPLTBKTBook TemplateASSET-TEMPLATE, BOOK15
AMBKTRANSABKAsset Book TransactionsASSET, BOOK, COMPANY, TRANS-STATUS, SEQ-NUMBER21
AMBKTYPEXADXAsset Book Type Rate DetailBOOK, ASSET-TYPE, SUB-TYPE, COMPANY, ACCT-UNIT6
AMBOOKAMBAsset Book NameBOOK11
AMBOOKGRPABGAsset Book Group HeaderBOOK-GROUP3
AMBOOKTYPEADRThis file contains the class depreciation file rate table for a book, type, or type and subtype.BOOK, ASSET-TYPE, SUB-TYPE4
AMCALENDARAMCAsset CalendarBOOK, COMPANY, YR-END-DATE30
AMCLASSDEPCLDThis file contains the depreciation information for account level depreciation to support Telecommunications Industry…COMPANY, BOOK, ASSET-TYPE, SUB-TYPE, AST-ACCT-UNIT, EXP-ACCT-UNIT, ACM-ACCT-UNIT, YR-END-DATE, PERIOD18
AMCNTRLAUAMLAsset System Options AuditCOMPANY, ACTION, DATE, TIME, UNIQUE-I-D11
AMCNVASSETCVAAsset Conversion NumberCONVERSION-NBR2
AMCOMPUTEACPComputeMETHOD4
AMCONTROLCTLAsset Internal ControlCOMPANY20
AMCTLTRANSACTAsset Control TransactionASSET6
AMDICTADTDictionaryELEMENT3
AMDICT2AMZNo description in the Lawson data dictionaryDB-FILE-PFX, FLD-NBR4
AMDIVISIONDIVAsset DivisionDIVISION2
AMDIVISNAUADWAM Division AuditDIVISION, ACTION, DATE, TIME, UNIQUE-I-D11
AMDSPPROPDSPAsset Disposal PropertyDSP-PROPERTY2
AMIAASTDIMIDAThe Asset Dimension file contains the fields which define the asset dimension of the AM data mart.AST-DIMENSION26
AMIABKDIMIBDNo description in the Lawson data dictionaryBOOK-DIMENSION5
AMIACALDIMITDNo description in the Lawson data dictionaryCAL-DIMENSION5
AMIACALDIXITXNo description in the Lawson data dictionaryCAL-DIMENSION, MBR-TYPE, YEAR, QUARTER, PERIOD7
AMIADIMADINo description in the Lawson data dictionaryDATA-MART-NAME15
AMIAMEADIMIMDThis file contains the measures which shall be output to the AM data mart.MEAS-DIMENSION26
AMIAMXDIMAMANo description in the Lawson data dictionaryDIMENSION-NAME, MX-DIM-TYPE, MATRIX-CAT6
AMIAOPDIMIDONo description in the Lawson data dictionaryOPT-DIMENSION2
AMINTERAMIAsset InterfaceCOMPANY, SEQ-NUMBER59
AMINTERAUAIUAsset Interface AuditCOMPANY, SEQ-NUMBER, ASSET-TEMPLATE, ACTION, DATE, TIME, UNIQUE-I-D14
AMLOCATIONLOCAsset LocationLOCATION-NAME29
AMLOCAUDITLOAAM Location AuditLOCATION-NAME, DATE, TIME, ACTION, UNIQUE-I-D12
AMLOCDTLLODLocation DetailLOCATION-NAME, LOC-DTL12
AMMETHODAMMAsset MethodMETHOD13
AMMONITORAMENo description in the Lawson data dictionaryCOMPANY, CONCUR-NBR8
AMPOASTDTLAODPO Asset DetailCOMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, DTL-SEQ-NBR41
AMPOASTHDRAOHPO Asset HeaderCOMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR17
AMPODFLTSAOTPO DefaultsCOMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR22
AMPRODCATAMPAsset Product CategoryCOMPANY, VENDOR, ASSET-TYPE, SUB-TYPE, MANUFACTURER, MODEL-NBR8
AMPUCODEAPUAsset Personal Use CodeBOOK, PERSONAL-USE16
AMPUHISPUHPersonal Use HistoryASSET, BOOK, YR-END-DATE7
AMRECALCAMRNo description in the Lawson data dictionaryCOMPANY, ASSET, BOOK, CREATION-DATE, CREATION-TIME27
AMRPRINTERRPIAsset Repair InterfaceCOMPANY, SEQ-NUMBER26
AMSEGBLOCKSGBNo description in the Lawson data dictionaryCOMPANY, ACCT-GRP, ASSET-TYPE, SUB-TYPE, ACCT-TYPE, ASSET-EVENT7
AMSELBKDTLAMKAsset Selection Book DetailSELECT-NAME, SELECT-TYPE, BOOK, TO-BOOK4
AMSELDTLSLDAsset Selection DetailSELECT-NAME, SELECT-TYPE, ASSET6
AMSELECTAMSAsset Processing SelectionSELECT-NAME, SELECT-TYPE36
AMSYSOPTAUAOANo description in the Lawson data dictionaryCOMPANY, CREATION-DATE, CREATION-TIME, ACTION, DATE, TIME, UNIQUE-I-D13
AMSYSOPTSAMOSystem OptionsCOMPANY, CREATION-DATE, CREATION-TIME25
AMTABLEPCTATBPercent TableMETHOD3
AMTABLETAXATTAsset Management Tax TableTC-TABLE6
AMTAXAUTHATATax AuthorityAUTH-TYPE, AUTHORITY2
AMTEMPLATEATMAsset TemplateASSET-TEMPLATE30
AMTRANSAMTAsset TransactionASSET, TRANS-STATUS, COMPANY, BOOK, SEQ-NUMBER37
AMTRANSBODYAWNo description in the Lawson data dictionaryASSET, TRANS-STATUS, COMPANY, BOOK, SEQ-NUMBER11
AMTRANSUMMATSAsset Transaction SummaryCOMPANY, BOOK, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, YR-END-DATE8
AMTYPALLOCALLThe The Asset Management Type Allocation file stores the allocation history for a type (type and subtype).COMPANY, ASSET-TYPE, SUB-TYPE, START-DATE, SEQUENCE-NBR10
AMTYPALLOXAXLThe Asset Type Allocation Detail file stores the accounting units and percentages for each company, asset type (or…COMPANY, ASSET-TYPE, SUB-TYPE, START-DATE, SEQUENCE-NBR, ACCT-UNIT7
AMUOPPDSUOPUnits of Production PeriodsMETHOD, METH-TABLE-YR8

Online screens (160)

ScreenDescriptionUpdatesReferences
AM00.1Book13
AM00.2Books13
AM01.1Current Calendar411
AM01.2Historical Calendar411
AM01.3Future Calendar411
AM02.1Methods41
AM02.2Units of Production Table Periods41
AM03.1Tax Credit Table10
AM04.1Personal Use13
AM05.1Account Group138
AM06.1Type138
AM06.2Types138
AM06.3Product Category148
AM06.4Asset Class Depreciation Rates15
AM06.5Asset Class Depreciation Rate Detail1410
AM06.6Depreciation Allocation36
AM07.1Location33
AM07.2Locations33
AM07.3Location Detail43
AM08.1Division77
AM08.2Divisions77
AM09.1Accounting Unit Group1010
AM10.1Book Group21
AM11.1Disposal Property10
AM11.2Disposal Properties10
AM12.1Addition Template2011
AM12.2Addition Template Detail List View2011
AM13.1Asset Group11
AM13.2Asset Groups11
AM15.1Single Invoice Interface7677
AM15.2Combine Invoice Interface7677
AM15.3Single Activity Interface7677
AM15.4Combine Activity Interface7677
AM15.5Invoice Interface Filter03
AM15.6Activity Interface Filter03
AM16.1System Options810
AM17.1PO Line Asset Defaults1914
AM18.1Repair Invoice Interface511
AM18.2Repair Activity Interface55
AM19.1PO Line Asset Detail8895
AM19.2Create Detail8894
AM19.3Totals13
AM19.4Asset Book Filter08
AM20.1Quick Addition7179
AM20.2Additions and Adjustments4532
AM20.3Items7070
AM20.4Books4532
AM20.5Journal Entries4426
AM20.6Repairs4422
AM20.7Projections17
AM20.8Projection Detail214
AM21.1Leased Asset Quick Addition7179
AM21.2Leased Asset Addition and Adjustment4532
AM21.3Items7070
AM21.4Books4532
AM21.5Journal Entries4425
AM21.6Repairs4422
AM21.7Projections17
AM21.8Projection Detail214
AM22.1Items7070
AM22.2Asset Book List View4532
AM23.1Asset Attributes38
AM23.2Values by Asset Attributes36
AM23.3Query List Members27
AM23.4Manual Asset List32
AM23.5Copy List30
AM25.1Mass Adjustment Selection313
AM25.2Mass Adjustment Filter211
AM25.3Mass Adjustment Totals08
AM30.1Transfers3022
AM30.2Items2817
AM30.3Journal Entries2118
AM35.1Mass Transfer Selection720
AM35.2Mass Transfer Filter04
AM35.3Mass Transfer Totals04
AM35.4Intercompany Transfer Books12
AM40.1Disposals3227
AM40.2Items2822
AM40.3Gain or Loss2318
AM40.4Journal Entries2118
AM41.1Reinstate Disposed Assets2721
AM41.2Reinstate Journal Entries2118
AM45.1Mass Disposal Selection520
AM45.2Mass Disposal Filter04
AM45.3Mass Disposal Totals07
AM51.1Item Update Adjust Interface Maint3458
AM52.1Inventory Interface Maintenance58
AM55.1Mass Revalue Selection311
AM60.1Annual Depreciation Override210
AM70.1Asset Analysis114
AM70.2Asset Totals03
AM70.3Item01
AM70.4Asset Filter29
AM75.1Account Analysis111
AM75.2Account Total04
AM75.3Account Filter04
AM80.1Transaction Analysis111
AM80.2Transaction Total04
AM80.3Transaction Filter04
AM81.1AM Interface Audit Analysis01
AM81.2AM Location Audit Analysis02
AM82.1AM System Options Audit Analysis02
AM82.2AM Asset Type Audit Analysis02
AM82.3AM Account Audit Analysis02
AM82.4AM Account Group Audit Analysis02
AM82.5AM Accounting Unit Group Audit Analysis02
AM82.6AM Division Audit Analysis02
AM83.1AM Period Closing Monitor01
AM85.1Activity Analysis112
AM85.2Activity Total04
AM85.3Activity Filter04
AM88.1Asset Dimension Definition39
AM88.2Book Dimension Definition35
AM88.3Measure Dimension Definition10
AM88.4Year Dimension Definition20
AM88.5Period Dimension Definition20
AM88.6Quarter Dimension Definition10
AM88.7Asset Filter1711
AM88.8Dimension Attributes14
AM88.9Optional Measures Dimension10
AM90.1Asset Book Analysis114
AM90.2Asset Book Totals06
AM90.3Asset Book Filter04
AM90.4Asset Book Salvage Analysis114
AM90.5Asset Book Depreciation Analysis116
AM90.6Class Depreciation Analysis19
AM90.7Class Depreciation Totals01
AM91.1Leased Asset Book Analysis113
AM91.2Leased Asset Book Totals06
AM91.3Leased Asset Book Filter04
AM91.4Leased Asset Book Salvage Analysis113
AM91.5Leased Asset Book Depreciation Analysis115
AM92.1Additional Book Conversion Adj2723
AM93.1Transaction Interface Adjustment312
AM94.1Attribute Interface Adjustment16
AM95.1Disposal Analysis115
AM95.2Disposal Totals04
AM95.3Disposal Filter03
AM95.4Disposal LTD Analysis115
AM95.5Disposal Gain or Loss Analysis115
AM95.6Disposal Proceeds or Cost Analysis115
AM96.1Asset Interface Adjustment4525
AM97.1Item Interface Adjustment3359
AM98.1Asset Book Interface Adjustment4634
AM99.1Transaction Balance Update25
AMAS.1OLAP Dimension Retrieval Format715
AMBD.1AM BOD Maintenance41
AMBD.2AM BOD Inquiry08
AMBK.1OLAP Dimension Retrieval Format710
AMBL.1Build AM Matrix List27
AMCO.1Comments01
AMCV.1OLAP Dimension Retrieval Format75
AMDL.1OLAP Data Load329
AMDM.1Asset Management Analysis Setup15
AMDM.2Book Dimension Attributes14
AMLF.1OLAP Dimension Retrieval Format75
AMMD.1OLAP Dimension Retrieval Format76
AMME.1OLAP Dimension Retrieval Format74
AMPD.1Olap Dimension Retrieval Format75
AMYR.1Olap Dimension Retrieval Format75

Batch programs (81)

ProgramDescriptionUpdatesReferences
AM115Mass Additions7777
AM117Mass Distribution Split7778
AM118Repair Release68
AM120Asset Book Copy517
AM125Mass Adjustments3831
AM135Mass Transfers3024
AM145Mass Disposals2928
AM152Inventory Update410
AM153Asset Bar Code Labels24
AM154AM Bar Code File Interface3822
AM155Mass Revalue2421
AM170Processing Release5022
AM180Depreciation Calculation and Listing2137
AM181AM Run Group Setup46
AM185Insurance and Replacement Calculation420
AM190Period Close2725
AM192Short Year Close3323
AM195Year End Close611
AM200System Setup Listings114
AM205Company Setup Listings315
AM206Product Category Workbook28
AM207Location Detail Workbook12
AM210Book Group Listing14
AM211Asset Template Workbook28
AM212Addition Template Listing213
AM213Asset Group Listing13
AM214Class Depreciation Rate Listing418
AM219PO Asset Detail Report213
AM220Addition Report426
AM221Asset or Tag Listing424
AM222Asset Book Listing423
AM223Item Listing423
AM224Repair Report419
AM225Adjustment Report426
AM230Transfer Report1526
AM235Item Transfer Report423
AM240Disposal Report428
AM241Reinstated Disposals Report212
AM242Revalue Report27
AM245Item Disposal Report424
AM250Inventory Worksheet422
AM251Item Adjustment Interface Listing29
AM252Inventory Comparison213
AM255Projection Report534
AM258Depreciation Recalculation Report215
AM260Asset Report427
AM265Property Report423
AM266Continuing Property Records215
AM267Asset Register427
AM270Account Balance Report418
AM275Transaction Report423
AM277Activity Report419
AM278Leased Asset Report426
AM280Current Year Depreciation Report633
AM281Depreciation History Report428
AM282Class Depreciation Report1621
AM285Book Comparison Report422
AM287Depreciable Asset Register426
AM288AM Audit Analysis Report311
AM290Tax Credit Report522
AM291Period Close Report210
AM292Recapture Report424
AM295FASB Reconciliation Report528
AM300Historical Purge216
AM305Asset Management Audit Purge72
AM310Book Purge1314
AM320Depreciation History Rebuild921
AM330Disposed Asset Purge2734
AM500Asset Management Interface7978
AM501Depreciation History Balances619
AM502Additional Book Conversion2824
AM520Book Name Change147
AM550Dictionary Load and Listing61
AM551Item Update Adjustment Interface7477
AM580Depreciation Recalculation718
AM588AM Audit Dicitionary Load20
AM700Depreciation Expense Allocation Update40
AM750AM shell program for BOD files14
AM970This program has been retired.10
AM980This program has been retired.10
AM990This program has been retired.10

Other tables used by Asset Management programs (130)

ACACCTCAT, ACACTIVITY, ACAMCODE, ADDRDATA, APACCRCODE, APAPIHIST, APAPPROVAL, APAUDIT, APAUTHOR, APCOMMENTS, APCOMPANY, APCONTACT, APCPYVND, APDISCCODE, APDISTHDR, APHLDINV, APHOLDCODE, APINCCODE, APINVOICE, APPAYMENT, APPROCGRP, APUAVAL, APUSRFLDEF, APVENADDR, APVENBAL, APVENCERT, APVENCLASS, APVENGROUP, APVENLOC, APVENMAST, APVENPAY, APVNMXVAL, ARCUSTGRP, AUMXVALUE, CBBANKINST, CBCASHCODE, CBCHECK, CBUSER, CBUSRCLASS, CMPUTE, CUCONV, CURELAT, CUSTDESC, EBCSVREC, EEADVANCE, EEAPPROVAL, EEEXPENSE, GLADDRESS, GLAMOUNTS, GLCGCPY, GLCHART, GLCHARTDTL, GLCHARTSUM, GLCODES, GLCPYGRP, GLINTCO, GLMASTER, GLNAMES, GLNLOCDTL, GLSYSTEM, IACALCMBR, IADRILL, IAFILEDEF, IAFILEDLT, IAFORMULA, ICCOMPANY, INSTCTRYCD, INSTREGN, LMLEASE, LMLEASESEG, MAAOCDTL, MAINVDTL, MAINVHAND, MAMAAHIST, MAMADHIST, MAMATCHTBL, MAMSGTOL, MAMTCHRULE, MAPOINV, MLCALMAP, MLCOLEDGER, MMDIST, MMUAVAL, MXCATDEF, MXELEMENT, MXLISTDTL, MXLISTHDR, MXLISTMBR, MXOBJCAT, MXTMPLDTL, MXTMPLHDR, MXVALIDATE, OLAPDBM, OLAPDIM, POAOCDTL, POAOCMAST, POAUDIT, POAUDRULES, POAUDTYPE, POCOMPANY, PODOCREF, POITEMVEN, POLINE, POPOVUF, PORECLINE, POREVISION, PORLNUF, PORQHUF, POVAGRMTHD, POVENDLOC, POVENDOR, PROCUREGRP, PURCHORDER, RATOTALS, REQHEADER, REQLINE, ROLAPDIM, ROLAPIDS, RQAUDIT, RWGRPDET, RWROWDET, SYSTEMCODE, TXCODEMAST, TXCOMPANY, TXTAXCODE, TXTAXRATE, TXTAXTABLE, ULPOST, ULTOTALS, WFSETUP