Skip to main content

Table lists which can have large number of records in Ax 2012

Image
By
If you are facing database or application performance issue then you can check these tables that may have large number of records.


ECORESPRODUCTVARIANTDIMENSIONVALUE
INVENTBATCH
ECORESPRODUCTMASTERDIMENSIONVALUE
ECORESPRODUCTMASTERDIMENSIONVALUE
ECORESPRODUCT
ECORESPRODUCTTRANSLATION
ECORESPRODUCT
ECORESPRODUCTVARIANTDIMENSIONVALUE
INVENTDIMCOMBINATION
ECORESRELEASESESSIONPRODUCT
ECORESRELEASEPRODUCTLEGALENTITY
INVENTSUMLOGTTS
INVENTCOSTLISTPARM
GENERALJOURNALACCOUNTENTRY
GENERALJOURNALACCOUNTENTRYZAKAT_SA
SMMTRANSLOG
LEDGERENTRYJOURNALIZING
DIMENSIONFOCUSBALANCE
MARKUPTRANS
INVENTTRANSPOSTING
INVENTREPORTDIMHISTORY
SALESPARMLINE
SOURCEDOCUMENTLINE
INVENTTRANS
TRANSACTIONLOG
INVENTTRANSORIGIN
INVENTSETTLEMENT
SALESPARMSUBTABLE
SALESPARMTABLE
SOURCEDOCUMENTHEADER
SALESPARMUPDATE
SQLSYNCINFO
GENERALJOURNALENTRY
SUBLEDGERVOUCHERGENERALJOURNALENTRY
CUSTSETTLEMENT
SMMACTIVITYPARENTLINKTABLE
INVENTSUMDATETRANS
LEDGERTRANSSTATEMENTTMP
DIMENSIONFOCUSLEDGERDIMENSIONREFERENCE
SALESQUOTATIONPARMLINE
SALESLINE
INVENTTRANSORIGINSALESLINE
DIMENSIONFOCUSUNPROCESSEDTRANSACTIONS
CUSTCONFIRMTRANS
CUSTPACKINGSLIPTRANS
CUSTINVOICETRANS
DIMENSIONATTRIBUTELEVELVALUE
INVENTJOURNALTRANS
CUSTINVOICEPACKINGSLIPQUANTITYMATCH
CUSTTRANS
CUSTTRANSIDREF
SALESTABLE
WMSBILLOFLADINGCARRIER
INVENTTRANSORIGINJOURNALTRANS
SALESQUOTATIONPARMSUBTABLE
SALESQUOTATIONPARMTABLE
CUSTPACKINGSLIPVERSION
SALESPARMSUBLINE
CUSTPACKINGSLIPJOUR
CUSTPACKINGSLIPSALESLINK
CUSTCONFIRMJOUR
CUSTCONFIRMSALESLINK
CUSTINVOICEJOUR
CUSTINVOICESALESLINK
SALESSHIPPINGSTAT
WMSBILLOFLADING
INVENTSUM
WMSBILLOFLADINGORDER
LEDGERJOURNALTRANS
BATCHHISTORY
SALESQUOTATIONPARMUPDATE
SQLDICTIONARY
CUSTQUOTATIONTRANS
SALESQUOTATIONLINE
BATCHJOBHISTORY
CUSTACCOUNTSTATEMENTEXTTMP
DIMENSIONATTRIBUTEVALUEGROUPCOMBINATION
INVENTTRANSORIGINTRANSFER
SALESQUOTATIONTABLE
CUSTQUOTATIONCONFIRMTRANS
SMMOPPORTUNITYTABLE
SMMACTIVITIES
ECORESRELEASEPRODUCTLEGALENTITYLOG
SUBLEDGERJOURNALACCOUNTENTRYDISTRIBUTION
INVENTTRANSFERPARMLINE
CUSTQUOTATIONJOUR
CUSTQUOTATIONSALESLINK
DIMENSIONATTRIBUTEVALUEGROUP
DIMENSIONATTRIBUTEVALUECOMBINATION
INVENTJOURNALTABLE
SRSREPORTQUERY
LEDGERTRANSACTIONLISTTMP
INVENTTRANSFERJOURLINE
INVENTDIM
LEDGERENTRYJOURNAL
CUSTQUOTATIONCONFIRMJOUR
CUSTQUOTATIONCONFIRMSALESLINK
XREFTABLERELATION
EVENTINBOXDATA
EVENTINBOX
ACCOUNTINGDISTRIBUTION
DOCUREF
SYSEXCEPTIONTABLE
DOCUVALUE
INVENTTABLEMODULE
INVENTTRANSORIGINSALESQUOTATIONLINE
PRINTJOBHEADER
LEDGERJOURNALTRANSZAKAT_SA
INVENTTRANSFERLINE
INVENTTRANSORIGINTRANSFERRECEIVE
INVENTTRANSORIGINTRANSFERSHIP
INVENTTRANSORIGINTRANSFERTRANSITFROM
INVENTTRANSORIGINTRANSFERTRANSITTO
WORKCALENDARDATELINE
ASSETTRANS
SYSUSERLOG
LEDGERJOURNALTRANS_ASSET
WORKCALENDARDATE
P_PAYROLLPERIODICTRANS
LOGISTICSADDRESSCOUNTRYREGIONTRANSLATION
DMFINVENTJOURNALENTITY
INVENTCOUNTJOUR
INVENTTRANSFERPARMUPDATE
INVENTTRANSFERPARMTABLE
BANKACCOUNTTRANS
AIFDOCUMENTFIELD
SYSTRACETABLESQL
INVENTCOSTLIST
INVENTTRANSFERJOUR
CUSTPACKINGSLIPBACKORDERLINEHISTORY
SYSLASTVALUE
CUSTPACKINGSLIPBACKORDERLINE
DMFSALESLINEENTITY
INVENTTRANSORIGINJOURNALTRANSRECEIPT
PURCHLINEHISTORY
INVENTITEMINVENTSETUP
INVENTITEMPURCHSETUP
INVENTITEMSALESSETUP
INVENTITEMLOCATION
INVENTITEMSETUPSUPPLYTYPE
INVENTTABLE
ECORESSTORAGEDIMENSIONGROUPITEM
ECORESTRACKINGDIMENSIONGROUPITEM
INVENTMODELGROUPITEM
INVENTITEMGROUPITEM
ITEMCOST
DMFSTAGINGEXECUTIONERRORS
ITEMCOSTHISTORY
ECORESSIZE
DMFECORESSIZEENTITY
PURCHPARMLINE
PURCHPARMLINE_ASSET
DIMENSIONATTRIBUTEVALUEGROUPSTATUS
CUSTPACKINGSLIPTRANSHISTORY
INVENTITEMPRICE
DIMENSIONATTRIBUTEVALUECOMBINATIONSTATUS
UNITOFMEASURECONVERSION
SYSEXPIMPTABLE
DMFSALESTABLEENTITY
LEDGERTRIALBALANCETMP
P_EMPLDEDUCTIONTRANS
INVENTTRANSFERTABLE
DMFPRODUCTENTITY
DMFUNITOFMEASURECONVERSIONENTITY
XREFPATHS
SALESJOURNALAUTOSUMMARY
ACCOUNTINGEVENT
DMFLEDGERJOURNALENTITY
P_EOSPROVISIONPERIODLINES
XREFREFERENCES
SUBLEDGERJOURNALACCOUNTENTRY
DIRORGPERSONRELATIONS
INVENTITEMLOCATIONCOUNTINGSTATUS
P_LOANSDETAILS
DIMENSIONATTRIBUTEVALUESETITEM
PURCHLINE
ECORESPRODUCTMASTERDIMENSIONVALUE
ECORESPRODUCTIDENTIFIER
ECORESPRODUCTDIMENSIONGROUPPRODUCT
ECORESPRODUCTMASTERMODELINGPOLICY
ECORESPRODUCTMASTERDIMENSIONVALUE
ECORESPRODUCTMASTERDIMENSIONVALUE
VENDPACKINGSLIPTRANS
VENDPACKINGSLIPTRANS_INTRASTAT
P_VACATIONTRANS
INVENTTRANSORIGINPURCHLINE
LEDGERJOURNALTABLE
P_PAYROLLPERIODICHEADER
DMFTARGETXMLTOENTITYMAP
PDSVENDBATCHINFO
ECORESSTORAGEDIMENSIONGROUPPRODUCT
ECORESTRACKINGDIMENSIONGROUPPRODUCT
SOURCEDOCUMENTLINERELIEVINGAMOUNT
SOURCEDOCUMENTLINERELIEVING
VENDINVOICEPACKINGSLIPQUANTITYMATCH
VENDINVOICETRANS
INVENTITEMGROUPFORM
VENDSETTLEMENT
P_PAYROLLPERIODICPERIODSLICES
P_PAYROLLPERIODPAYMENTS
ITEMS_MISSED
TEMPINVENTTABLE
VENDINVOICEINFOLINE
VENDINVOICEINFOLINE_ASSET
VENDINVOICEMATCHINGLINE
VENDINVOICEINFOSUBLINE
P_PAYROLLPERIODPAYMENTSLINES
NUMBERSEQUENCEHISTORY
IMPORTITEMPRICES
DMFTARGETXML
VENDTRANS
DIMENSIONATTRIBUTEVALUE
CUSTTRANSOPEN
SRSREPORTPREPROCESSEDDETAILS
CUSTAGINGLINE
SALESSHIPPINGSTATHISTORY
ASSETTABLE
LOGISTICSELECTRONICADDRESS
PURCHPARMUPDATE
ASSETBOOK
ASSETBOOKMERGE
NUMBERSEQUENCETABLE
LEDGERPERIODMODULEACCESSCONTROL
PURCHPARMTABLE
PURCHPARMSUBTABLE
XREFNAMES
DIRPARTYRELATIONSHIP
INVENTCOSTBUNDLELIST
SRSTMPDATASTORE
LOGISTICSLOCATION
INVENTCLOSING
DIRPARTYLOCATION
LOGISTICSLOCATIONROLETRANSLATION
SUBLEDGERJOURNALENTRY
SYSUTILELEMENTSLOG
DIRPARTYTABLE
SYSTRACETABLESQLTABREF
P_EMPLALLOWANCETRANS
NUMBERSEQUENCEREFERENCE
VENDPURCHORDERJOUR
CUSTTABLE
DIMENSIONATTRIBUTEVALUESET
PURCHTABLEVERSION
LOGISTICSPOSTALADDRESS
SYSIMAGETABLE
SYSLABELLOG
DIRORGANIZATIONNAME
PURCHTABLEHISTORY
DIRPARTYLOCATIONROLE
DIRPARTYTABLE
JOURNALERROR
RETAILCUSTTABLE
SYSTEMSEQUENCES

Labels:

Comments

Post a Comment

Popular posts from this blog

Code to get customer Primary Address in Ax 2012

By
Below Code to get customer Primary Address in Ax 2012. CustTable custTable_P; DirPartyTable dirPartyTable_P; DirPartyLocation dirPartyLocation_P; DirPartyLocationRole dirPartyLocationRole_P; LogisticsLocation logisticsLocation_P; LogisticsLocationRole logisticsLocationRole_P; LogisticsPostalAddress logisticsPostalAddress_P; LogisticsPostalAddress primaryAddress_P; while select custTable_P where custTable_P.AccountNum =='ED_01029' join dirPartyTable_P where dirPartyTable_P.RecId == custTable_P.Party join dirPartyLocation_P where dirPartyLocation_P.Party == custTable_P.Party && dirPartyLocation_P.IsPrimary==NoYes::Yes join dirPartyLocationRole_P where dirPartyLocationRole_P.PartyLocation == dirPartyLocation_P.RecId join logisticsLocationRole_P where logisticsLocationRole_P.RecId == dirPartyLocationRole
Post a Comment
Read more

Code to get Invoice settlement data for customer in ax 2012

By
This is simple Code to get Invoice settlement amount data for customer payment in ax 2012. This data is after posting of data. select sum(SettleAmountCur) from custSettlement where custSettlement.TransRecId == custtrans.RecId If you want get settlement amount before posting than you can refer spectrans table.The table SpecTrans contains all the transactions marked for settlement for payment journal. while select spectrans join custtransopen join custtrans where spectrans.SpecCompany == ledgerjournaltrans.DataAreaId && spectrans.SpecTableId == ledgerjournaltrans.TableId && spectrans.SpecRecId == ledgerjournaltrans.RecId && spectrans.RefCompany == custtranssopen.DataAreaId && spectrans.RefTableId == custtranssopen.TableId && spectrans.RefRecId == custtranssopen.RecId && custtransopen.RefRecId == custtrans.RecId && custtransopen.AccountNum == custtrans.AccountNum { info(str
Read more