Skip to main content

What are the Reserved words in Axapta

Following are the Reserved words list in Ax 2012

1
abstract
54
implements
2
anytype
55
index
3
as
56
insert_recordset
4
asc
57
int
5
at
58
int64
6
avg
59
interface
7
break
60
is
8
breakpoint
61
join
9
by
62
like
10
byRef
63
maxOf
11
case
64
minOf
12
catch
65
mod
13
changeCompany
66
new
14
class
67
next
15
client
68
noFetch
16
container
69
notExists
17
continue
70
null
18
count
71
optimisticLock
19
crossCompany
72
order
20
date
73
outer
21
default
74
pause
22
delegate
75
pessimisticLock
23
delete_from
76
print
24
desc
77
private
25
display
78
protected
26
div
79
public
27
do
80
real
28
edit
81
repeatableRead
29
else
82
retry
30
eventhandler
83
return
31
exists
84
reverse
32
extends
85
select
33
FALSE
86
server
34
final
87
setting
35
firstFast
88
static
36
firstOnly
89
str
37
firstOnly1
90
sum
38
firstOnly10
91
super
39
firstOnly100
92
switch
40
firstOnly1000
93
tableLock
41
flush
94
throw
42
for
95
TRUE
43
forceLiterals
96
try
44
forceNestedLoop
97
ttsAbort
45
forcePlaceholders
98
ttsBegin
46
forceSelectOrder
99
ttsCommit
47
forUpdate
100
unchecked
48
from
101
update_recordSet
49
generateonly
102
utcDateTime
50
group
103
validTimeState
51
guid
104
void
52
hint
105
where
53
if
106
while


107
window

Popular posts from this blog

Code to get customer Primary Address in Ax 2012

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...

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

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 DIMENSIONFOCUSLE...

Code to get Invoice settlement data for customer in ax 2012

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...