2012年11月19日星期一

X++ Function Categories and their Functions [AX 2012]

Category
Description
Business
Functions that input financial data and calculate formulas.
Compiler Verified
(also named Intrinsic)
Functions that have their input value verified by the compiler. If the input value is not found to match any existing object in the Application Object Tree (AOT), the compiler issues an error.
The inputs to these functions must be literals, because the compiler cannot determine the value that a variable contains at run time.
Container
Functions that operate on the container data type of X++.
Convert
Functions that translate data of one type into data of another type.
Date
Functions that operate on the date data type.
Enum
Functions that operate on enum objects.
Math
Functions that perform mathematical calculations.
Miscellaneous
Functions that do not belong to any specific category.
Reflection
Functions that access the metadata about objects and return other metadata about them.
Session
Functions that change or report on the context of the current user connection.
String
Functions that operate on the str data type.

The following table lists the X++ functions that belong in each previous category.
Category
X++ function
Business
  • cTerm
  • ddb
  • dg
  • fv
  • idg
  • intvMax
  • intvName
  • intvNo
  • intvNorm
  • pmt
  • pt
  • pv
  • rate
  • sln
  • syd
  • term
Compiler Verified
(also named Intrinsic)
  • attributeStr
  • classNum
  • classStr
  • configurationKeyNum
  • configurationKeyStr
  • datasetStr
  • enumNum
  • enumStr
  • evalBuf
  • extendedTypeNum
  • extendedTypeStr
  • fieldNum
  • fieldPName
  • fieldStr
  • formControlStr
  • formStr
  • identifierstr
  • indexNum
  • indexStr
  • licenseCodeNum
  • licenseCodeStr
  • literalStr
  • menuItemActionStr
  • menuItemDisplayStr
  • menuItemOutputStr
  • menuStr
  • methodStr
  • perspectiveNum
  • perspectiveStr
  • queryDataSourceStr
  • queryStr
  • reportStr
  • resourceStr
  • runBuf
  • securityKeyNum
  • securityKeyStr
  • ssrsReportStr
  • staticMethodStr
  • tableCollectionStr
  • tableFieldGroupStr
  • tableMethodStr
  • tableNum
  • tablePName
  • tableStaticMethodStr
  • tableStr
  • varStr
  • webActionItemStr
  • webDisplayContentItemStr
  • webFormStr
  • webletItemStr
  • webMenuStr
  • webOutputContentItemStr
  • webPageDefStr
  • webReportStr
  • webSiteDefStr
  • webSiteTempStr
  • webStaticFileStr
  • webUrlItemStr
  • webWebpartStr
  • workflowApprovalStr
  • workflowCategoryStr
  • workflowTaskStr
  • workflowTemplateStr
Container
  • conDel
  • conFind
  • conIns
  • conLen
  • conNull
  • conPeek
  • conPoke
Convert
  • any2Enum
  • any2Date
  • any2Guid
  • any2Int
  • any2Int64
  • any2Real
  • any2Str
  • char2Num
  • Date2Num
  • Date2Str
  • Datetime2Str
  • formattedStr2Num
  • guid2Str
  • int2Str
  • int642Str
  • num2Char
  • num2Date
  • num2Str
  • str2Enum
  • str2Date
  • str2Datetime
  • str2Guid
  • str2Int
  • str2Int64
  • str2Num
  • str2Time
  • time2Str
  • uint2Str
Date
  • dayName
  • dayOfMth
  • dayOfWk
  • dayOfYr
  • endMth
  • maxDate
  • mkDate
  • mthName
  • mthOfYr
  • nextMth
  • nextQtr
  • nextYr
  • prevMth
  • prevQtr
  • prevYr
  • timeNow
  • today
  • wkOfYr
  • year
Enum
  • enum2Str
  • enumCnt
Math
  • abs
  • acos
  • asin
  • atan
  • corrFlagGet
  • corrFlagSet
  • cos
  • cosh
  • decRound
  • exp
  • exp10
  • frac
  • log10
  • logN
  • power
  • round
  • sin
  • sinh
  • tan
  • tanh
  • trunc
Miscellaneous
  • beep
  • classIdGet
  • dimOf
  • getPrefix
  • max
  • maxInt
  • min
  • minInt
  • newGuid
  • setPrefix
  • sleep
  • systemDateget
  • systemDateset
Reflection
  • fieldId2Name
  • fieldId2PName
  • fieldName2Id
  • indexId2Name
  • indexName2Id
  • refPrintAll
  • tableId2Name
  • tableId2PName
  • tableName2Id
  • typeOf
Session
  • curExt
  • curUserId
  • SessionId
  • funcName
  • prmIsDefault
  • runAs
String
  • match
  • strAlpha
  • strCmp
  • strColSeq
  • strDel
  • strFind
  • strFmt
  • strIns
  • strKeep
  • strLen
  • strLine
  • strLTrim
  • strLwr
  • strNFind
  • strPoke
  • strPrompt
  • strRem
  • strRep
  • strRTrim
  • strScan
  • strUpr
  • subStr