AM500 – Asset Management Interface

System
Asset Management (AM)
Type
Batch program
Updates
79 tables
References
78 tables

AM500 (Asset Management Interface) is a Lawson Asset Management batch program. It updates ADDRDATA, AMACCOUNT, AMACCTAU, AMACCTGPAU, AMACCTGRP, AMASSET, AMASSETADJ, AMASSETCNV and 71 more and references AMASSETBOD, AMASSETDSP, AMASSETTRF, AMASTBKCNV, AMASTBKDSP, AMASTBKTRF, AMASTITCNV, AMASTITDSP and 70 more.

About AM500

Run Asset Management Interface (AM500) to import asset information from anon-Lawson application to the Lawson Asset Management application. NOTE Before you run this program, you must format and import the non-Lawson files into each Lawson conversion file you want to convert. **Processing Effect For UNIX/Windows platforms: This conversion program converts the asset, item, asset book, asset attribute, and asset transaction information from the following: Asset Conversion (AMASSETCNV), Asset Item Conversion (AMASTITCNV), Asset Book Conversion (AMASTBKCNV), Asset Transaction Conversion (AMASTTRCNV), and Asset Attribute Conversion (AMASTMXCNV). The asset, item, and book files must be converted at the same time. The attribute and transaction files can both be converted at the same time as the other files, or can each be converted separately. For the System i platform: This conversion program converts the asset, item, asset book, asset attribute, and asset transaction information from the following: Asset Conversion (DBAMACN), Asset Item Conversion (DBAMITC), Asset Book Conversion (DBAMABC), Asset Transaction Conversion (DBAMTNC), and Asset Attribute Conversion (DBAMMCV). The asset, item, and book files must be converted at the same time. The attribute and transaction files can both be converted at the same time as the other files, or can each be converted separately.

Updated files (79)

TableDescriptionSystem
ADDRDATAAddress CodeIF
AMACCOUNTAsset Management AccountAM
AMACCTAUAsset Account AuditAM
AMACCTGPAUAsset Account Group AuditAM
AMACCTGRPAsset Account GroupAM
AMASSETAssetAM
AMASSETADJAsset AdjustmentAM
AMASSETCNVAsset ConversionAM
AMASSETDSPAsset DisposalAM
AMASSETGRPAsset GroupAM
AMASSETTRFAsset TransferAM
AMASTBKADJAsset Book AdjustmentAM
AMASTBKCNVAsset Book ConversionAM
AMASTBKDSPAsset Book DisposalAM
AMASTBKTRFAsset Book TransferAM
AMASTBOOKAsset BookAM
AMASTITADJAsset Item AdjustmentAM
AMASTITCNVAsset Item ConversionAM
AMASTITDSPAsset Item DisposalAM
AMASTITEMAsset ItemAM
AMASTITTRFAsset Item TransferAM
AMASTMXCNVAsset Attribute ConversionAM
AMASTMXVALAsset AttributesAM
AMASTRECAPAsset Depreciation RecaptureAM
AMASTRPAIRAsset RepairAM
AMASTTRCNVAsset Transaction ConversionAM
AMASTTYPAUAsset Type AuditAM
AMASTTYPEAsset TypeAM
AMAUGROUPAsset Accounting Unit GroupAM
AMAUGRPAUAM Accounting Unit Group AuditAM
AMBKHISTAsset Book HistoryAM
AMBKHISTXPeriod Asset Book HistoryAM
AMBKTRANSAsset Book TransactionsAM
AMCALENDARAsset CalendarAM
AMCLASSDEPThis file contains the depreciation information for account level depreciation to support Telecommunications Industry…AM
AMCNTRLAUAsset System Options AuditAM
AMCNVASSETAsset Conversion NumberAM
AMCONTROLAsset Internal ControlAM
AMCTLTRANSAsset Control TransactionAM
AMDIVISIONAsset DivisionAM
AMDIVISNAUAM Division AuditAM
AMLOCATIONAsset LocationAM
AMLOCAUDITAM Location AuditAM
AMMONITORNo description in the Lawson data dictionaryAM
AMPUHISPersonal Use HistoryAM
AMSEGBLOCKNo description in the Lawson data dictionaryAM
AMTAXAUTHTax AuthorityAM
AMTRANSAsset TransactionAM
AMTRANSUMMAsset Transaction SummaryAM
APAPPROVALInvoice ApprovalAP
APAUDITVendor Invoice AuditAP
APCOMMENTSCommentsAP
APCONTACTNo description in the Lawson data dictionaryAP
APCPYVNDVendor Company CodesAP
APHLDINVHoldAP
APVENADDRAP Vendor AddressAP
APVENBALVendor BalanceAP
APVENCERTNo description in the Lawson data dictionaryAP
APVENGROUPVendor GroupAP
APVENLOCVendor LocationAP
APVENMASTVendor Master RecordAP
APVENPAYNo description in the Lawson data dictionaryAP
CBBANKINSTBank Transaction CodeCB
CBCASHCODECash CodeCB
CBCHECKAccounts Payable Cash PaymentCB
CKPOINTNo description in the Lawson data dictionary
CUSTDESCAR Group CustomerAR
GLNLOCDTLNo description in the Lawson data dictionaryIC
MXLISTHDRAttribute List HeaderIF
MXLISTMBRAttribute ListIF
MXOBJCATAttribute ObjectIF
POPOVUFNo description in the Lawson data dictionaryPO
POVENDLOCVendor Location MasterPO
POVENDORPO Vendor MasterPO
SYSTEMCODESystem CodeIF
TXCODEMASTTax Code MasterTX
TXCOMPANYTax CompanyTX
TXTAXCODETax Code MaintenanceTX
TXTAXTABLETax TableTX

Referenced files (78)

TableDescriptionSystem
AMASSETBODNo description in the Lawson data dictionaryAM
AMASSETDSPAsset DisposalAM
AMASSETTRFAsset TransferAM
AMASTBKCNVAsset Book ConversionAM
AMASTBKDSPAsset Book DisposalAM
AMASTBKTRFAsset Book TransferAM
AMASTITCNVAsset Item ConversionAM
AMASTITDSPAsset Item DisposalAM
AMASTITTRFAsset Item TransferAM
AMASTRPAIRAsset RepairAM
AMBOOKAsset Book NameAM
AMCOMPUTEComputeAM
AMLOCDTLLocation DetailAM
AMMETHODAsset MethodAM
AMPUCODEAsset Personal Use CodeAM
AMTABLEPCTPercent TableAM
AMTABLETAXAsset Management Tax TableAM
AMTRANSBODNo description in the Lawson data dictionaryAM
AMTYPALLOCThe The Asset Management Type Allocation file stores the allocation history for a type (type and subtype).AM
AMTYPALLOXThe Asset Type Allocation Detail file stores the accounting units and percentages for each company, asset type (or…AM
AMUOPPDSUnits of Production PeriodsAM
APACCRCODEInvoice Accrual CodeAP
APAPIHISTVendor Invoice HistoryAP
APAPPROVALInvoice ApprovalAP
APAUTHORAuthority CodeAP
APCOMMENTSCommentsAP
APCOMPANYAccounts Payable CompanyAP
APCONTACTNo description in the Lawson data dictionaryAP
APCPYVNDVendor Company CodesAP
APDISCCODEDiscount CodeAP
APDISTHDRDistribution Code HeaderAP
APHLDINVHoldAP
APHOLDCODEHold CodeAP
APINCCODEIncome CodeAP
APINVOICEAccounts Payable InvoiceAP
APPAYMENTInvoice PaymentAP
APPROCGRPProcess GroupAP
APUSRFLDEFAP User Field DefinitionAP
APVENBALVendor BalanceAP
APVENCERTNo description in the Lawson data dictionaryAP
APVENCLASSVendor ClassAP
APVENLOCVendor LocationAP
APVNMXVALNo description in the Lawson data dictionaryAP
ARCUSTGRPAccounts Receivable Cust GroupAR
CBCHECKAccounts Payable Cash PaymentCB
CBUSERCash Ledger UserCB
CBUSRCLASSCash Ledger User ClassCB
CUCONVCurrency Exhange RateIF
CURELATCurrency RelationshipsIF
EEADVANCEEmployee AdvanceAP
EEAPPROVALExpense Advance Approval CodeAP
EEEXPENSEEmployee ExpenseAP
GLADDRESSGeneral Ledger Company AddressIF
GLCGCPYCompany Group CompanyIF
GLCHARTGeneral Ledger ChartIF
GLCODESGeneral Ledger CodesIF
GLNLOCDTLNo description in the Lawson data dictionaryIC
GLSYSTEMGeneral Ledger CompanyIF
INSTCTRYCDIntrastat Country CodesTX
INSTREGNIntrastat Region CodeTX
LMLEASELease InformationLM
LMLEASESEGThis file stores the user analysis values for a lease.LM
MAINVHANDInvoice Handling CodeMA
MAMATCHTBLMatch TableMA
MAMSGTOLNo description in the Lawson data dictionaryMA
MAMTCHRULEMatching RulesMA
MXCATDEFAttribute DefinitionIF
MXELEMENTAttribute ElementIF
MXLISTDTLAttribute List DetailIF
MXVALIDATEAttribute ValidationIF
POAOCDTLAdd On Cost DetailPO
POITEMVENPO Vendor Item InformationPO
POVAGRMTHDVendor AgreementPO
POVENDLOCVendor Location MasterPO
PROCUREGRPProcurement GroupPO
PURCHORDERPurchase Order MasterPO
TXTAXRATETax RateTX
WFSETUPNo description in the Lawson data dictionaryWF

Program calls

Invoked programs (21)

ACAC, ACTA, AMCO, API4, GLCC, IFAC, IFAU, IFCU, IFFC, IFGT, IFLU, IFOB, IFRS, IFSC, IFSG, IFUP, SLFD, SLSB, SLSE, SLSS, SLSU