Reserved words and special characters

Reserved words

Special Characters

About reserved words

Reserved words and special characters have a predefined meaning in the DML.

Reserved words

The following table lists and describes the set of reserved words in alphabetical order.

Term Description

ACCTAB

Table Function that searches for the line specified by the Table key parameter, and then returns the corresponding value.

ACCTABD

Table Function that returns the value of the Value column corresponding to the date specified.

AND

Logical operator.

CHECK

Technical Function that activates an external call to check a value in a repository external to AccountingIntegrator Enabler.

CHECKTAB

Table Function that checks that a Table entry corresponding to a Table key is present in the Table.

CHECKTABD

Table Function that checks that a Table entry corresponding to a Table key  is present in the Table for the date that you specify.

COND_EVT

Internal variable used by AccountingIntegrator Enabler  Rule Engine.

COND_SEG

Internal variable used by AccountingIntegrator Enabler  Rule Engine.

DATEMINUS

Date Function that subtracts the number of days that you specify from a date.

DATEPLUS

Date Function that adds the number of days that you specify to a date.

DAY

Date Function that returns the day of the month, expressed as a two-digit numeric value, from an expression that specifies the date.

DOMAIN

Environment Function domain code activated for the session.

ELSE

Part of the IF-THEN-ELSE Technical Function. The ELSE block is optional and includes one or more expressions that AccountingIntegrator Enabler executes when the condition returns false.

ENDDATE

Environment Function that identifies the end validity date of the applied Transformation-Rule.

ENV

Root syntax for environment functions.

ERR

Technical Function that enables you to check the Input-Event and define an error message to generate if an exception is encountered in the Input-Event in progress.

EXTTAB

Table Function that returns part of the contents of the specified Value column in a given Table.

EXTTABD

Table Function that returns part of the contents of the specified Value column in a given Table for a given date.

EVTCODE

Environment Function that displays the name of the processed Input-Event.

FIRSTGROUP

Environment Function that indicates whether the current Input-Event is the first in the group being processed.

FIRSTPHASE

Environment Function that indicates whether the current Input-Event is the first in the Phase being processed.

GROUP

Environment Function that returns the Group code of the processed Input- Event.

HIGH_VALUE

Internal constant.

IF

Part of the IF-THEN-ELSE Technical Function. The IF block is a DML expression that uses a Business-Document field and comparison and logical operators.  

INT The $INT function will be a predefined function in a future version of AcountingIntegrator.

INSTANCE

Environment Function that returns the instance code of the processed Input-Event.

JULIAN

Date Function that returns the year and the Julian day of the year for a given date.

LASTGROUP

Environment Function that indicates whether the current Input-Event is the last in the group being processed.

LASTPHASE

Environment Function that indicates whether the current Input-Event is the last in the Phase being processed.

LOW_VALUE

Internal constant.

MONTH

Date Function that returns the number of the  month from a given date.

NBDAYS

Date Function that calculates the difference between two dates.

NULL

Technical Function that sets the target field as a set of blank spaces irrespective of the data type associated with this field.

NUMSC

Environment Function that indicates the number assigned to the executed Financial-Case.

NUMSCSEG

Environment Function that indicates the numbers assigned to the executed Financial-Case and the generated Output-Event , in that order.

NUMSEG

Environment Function that indicates the number assigned to the generated Output-Event.

NUMSEGSC

Environment Function that indicates the numbers assigned to the generated Output-Event and the executed Financial-Case, in that order.

OR

Logical operator.

PHASE

Environment Function that returns the name of the Transformation Phase in progress.

RULE

Environment Function that returns the name of the applied Transformation-Rule.

SEARCH

Technical Function that activates an external call to retrieve a value from an external reference table.

SEGCODE

Environment Function that returns the name of the processed segment type.

SEGSTRUC

Environment Function that returns the name of the Business-Document in the generated Output-Event.

SENDER

Environment Function that returns the name of the Processing-Context-In for the session.

STARTDATE

Environment Function that returns the start validity date of the applied Transformation-Rule.

SYSDATE

Date Function that returns the current date and time of your operating system.

THEN

Part of the IF-THEN-ELSE Technical Function. The THEN block includes one or more expressions that AccountingIntegrator Enabler executes when the condition returns true.

VERSION

Environment Function that returns the version number of the processed Input-Event.

NUMERIC

Internal constant.

YEAR

Date Function that returns the year, expressed as a two-digit numeric value, from a given date.

YEAR4

Date Function that returns the year, expressed as a four-digit numeric value, from a given date.

Special Characters

The following table lists and describes the role of the DML special characters.

Character Meaning

space

If you usereserved words, you must separate them from the field names by a space.

Otherwise, spaces are not mandatory. However, they make phrases easier to understand.

The number of spaces between two elements in an expression does not affect the meaning of the phrase. Several successive spaces are the equivalent of a single space separator. However, each space is counted as a character in the expression.

" "

Double quotes are mandatory if you want to delimit the alphanumeric constant values.

Examples

"DESCRIPTION OF THE XX111 REFERENCE"

$ENV ("SENDER")

$ERR ("ERROR MESSAGE")

$EXTTAB (TABNAME; "0011008A"; TABLE KEY)

-

The minus sign is an arithmetic operator and precedes a negative integer.

+

The plus sign is an arithmetic operator and precedes a positive integer.

$

The dollar sign is used at the beginning of Function names.

Example

$ACCTABD

:=

The colon character followed by an equals sign assigns a value to a Variable.

Examples

@VARIABLE:= @VARIABLE + QTECDE

@NB_ME:= @NB_ME + 1

( )

Parentheses:

  • enclose Function parameters
  • indicate priority in expressions. Data in parentheses is processed before data that is not.

When parentheses are used, the number of opening parentheses must be equal to the number of closing parentheses. Otherwise, the expression is rejected when it is analyzed.

Expressions in parentheses can be nested one within the other. These levels are called parenthesis levels. An expression can have a maximum of 20 levels.

If parentheses do not change the priority of the operations, they are optional. However, they can make phrases easier to understand

,

The comma character separates a value assigned to a Variable from a Mapping Rule phrase associated with a target field.

Example

@QTE_TOT:= @QTE_TOT + QTECDE, QTECDE * (MTHT + MTTVA)

;

The semicolon character separates multiple parameters in DML Functions.

@

The @ character is mandatory if you want to identify a Variable in the Mapping Rule phrases or when attributing a value.

Example

@VARIABLE:= @VARIABLE+QTECDE, @QTE_TOT * (MTHT+MTTVA)

Back to top

Related Links