Reserved words and special characters

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

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

Logical operator.

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

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

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

Internal variable used by AccountingIntegrator Enabler  Rule Engine.

Internal variable used by AccountingIntegrator Enabler  Rule Engine.

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

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

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

Environment Function domain code activated for the session.

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.

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

Root syntax for environment functions.

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.

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

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

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

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

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

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

Internal constant.

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.  

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

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

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

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

Internal constant.

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

Date Function that calculates the difference between two dates.

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

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

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

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

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

Logical operator.

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

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

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

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

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

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

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

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

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.

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

Internal constant.

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

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.