ACP 1. Ordner

Own Questions

Own Questions

46

0.0 (0)

Jost Odermatt

Study

Jost Odermatt

About these flashcards

Diese Karteikarten bieten eine grundlegende Einführung in die Informatik, insbesondere im Kontext von Avaloq. Sie behandeln Themen wie die Struktur und Nutzung von Quellen, die Definition und Verwendung von Code-Tabellen, sowie die Unterschiede zwischen verschiedenen Arten von APIs und Skripten. Die Karteikarten sind ideal für Anfänger, die die Grundlagen der Avaloq-Systeme verstehen möchten, und bieten praktische Beispiele und Erklärungen zu wichtigen Konzepten.

Flashcards

46

Students

18

Language

German

Category

Computer Science

Level

Primary School

Created / Updated

28.01.2013 / 08.05.2022

Each source type has its own...

...compiler.

By what can a parameterisation specialist change a source delivered by avaloq?

By overriding (the system knows which part of the source is changed) or overwriting if allowed by avaloq it's flagd in the CODE_SRC_TYPE table.

Whats one advantage of using the source concept?

It's that parameterisation and scripting is stored outside of the ABS, even if it can also be found in the system.

What defines if a namespace is needed?

The source type

When is no namespace prefix needed?

• overrides/overwrites of Avaloq sources (if allowed)

• sources generated by the Avaloq Banking System on behalf of the user, e.g. Extn-DDIC sources

• sources that are linked to (table) items delivered by Avaloq, e.g. order validations that are linked

to a business type

• the source name part of a source connected to a master source delivered by Avaloq, e.g. a task

template of a client (TQ_SRC_LIST.CLT$MY_LIST) for a task definition (TQ_SRC_LIST) that is

delivered with the kernel.

• source types with a local validity, i.e. sources that are never part of a third party parameterisation,

e.g. printer sources

The namespace is checked for:

• sources that are part of a portable parameterisation, e.g. Avaloq script packages, base

parameters, or code tables

• the second part of the source name of a slave source, i.e. a source that is linked to a master

source delivered by Avaloq or another third party vendor

Whats the difference between declarative and procedural Avaloq Script Source?

Indeed the name of the sources as well as the syntax is validated by the parser and the sources framework. This is the case for Avaloq source types such as code table definition, code table data, auditing, printer definition, user definition,

task and task template definition.

To check this opportunity, please check the column REV_CMPL in table CODE_SRC_TYPE.

Other Avaloq source types however rely heavily on procedural logic. This is the case for script reports,

incoming and outgoing messages and obviously for Avaloq script sources. There is also a certain

number of types of sources that can make use of procedural logic, but do not necessarily have to.

What are the main advantage of DDICs?

• the provision of abstract access to data, i.e. that the data is accessible logically (business view)
instead of physically
• the encapsulation of the underlying kernel routines and thus the provision of a stable interface
to the outside world

Avaloq ICE Script package in context with an order start with:

<namespace>$doc_<intl_id>

Avaloq ICE Script packages in context with an object starts with:

<namespace>$obj_<intl_id>

Where are CODE_ tables defined?

In the table CODE_TAB_DEF

What are CODE_ tables?

Code tables are definition tables that contain predefined values in one domain. For each domain and for each context a separate code table exists.

With which keyword do you import an API into ABS?

keyword native

There are three (3) types of APIs within the ABS:

• Secured APIs (name often – not always - contains a #, like FORMAT#). The source of these APIs

cannot be shown, they are "wrapped" [secured by Oracle]

• Non Secured APIs (like DEF% or NETW_%) are created during the compilation of a source. The

source of these APIs can be shown.

• Client written APIs, e.g. for solving bank specific mathematical rules, following the principle

"develop once – use often".

Which table allows to define default values in an entry mask depending on defined criterion? Whats the naming convention of those BTC sources in ICE?

DOC_DFLT_VAL_RULE nad _LD for the loader table

NAMING {META_TYPE}.DOC_FLD.RULE

Which roule engine allows default naming of an object? How is the naming convention of this BTC source?

Table OF_ITEM_FMT_RULE for loader _LD

Naming convention {META_TYPE}.OF.RULE

Which is the most important rule loader table for costs?

COST_RULE (_LD)

What source type has workflow rules and whats the naming convention?

BTC Business Type Config [META-TYPE].WFC

Whats a base parameter?

A base parameter is stored in one source Naming convention BASE.[BASE_PAR_INTL_ID]

What are the four types of context action? CTX_ACTION

DOC

OBJ

CODE

BTC

Describe the structure of the main window...

Keyboard commands:

= turn,

= for-/backward,

= scroll

1. Avaloq Button

2. Ribbon

3. Sidebar (personalized access to overviews)

4. Work Area

5. Tabs

6. Message Bar

7. Status Bar

What information contains the Status Bar?

Keyboard commands:

= turn,

= for-/backward,

= scroll

Date, Default Printer, Database, Release

What could be a person (PERS) in Avaloq?

Keyboard commands:

= turn,

= for-/backward,

= scroll

- Account Owner

- Beneficiary Owner

- Legal Guardian

- Authority

- Payee

Which are the object attributes?

Keyboard commands:

= turn,

= for-/backward,

= scroll

Classifications and classes, keys, additions, remarks, relations, collections

Whats the difference between 3.4k and 3.4m?

Keyboard commands:

= turn,

= for-/backward,

= scroll

3.4k is equal to 3.4 * 1'000

3.4m is equal to 3.4000 it puts 3x '0' at the end

What's the difference between +7v and +7_v?

Keyboard commands:

= turn,

= for-/backward,

= scroll

+7v is an additional seven value days added.

+7_v is an addition of seven days but the day needs to be a value day (Sa. & So. is counted backwards)

Whats the difference between ? _ and % *?

Keyboard commands:

= turn,

= for-/backward,

= scroll

?_ only one letter is missing with %* more than one is missing...with SQL statement LIKE!

What the term eotw means?

Keyboard commands:

= turn,

= for-/backward,

= scroll

end of this week...date

Whats the difference between RUN and SUBMIT in Avaloq?

Keyboard commands:

= turn,

= for-/backward,

= scroll

RUN runs synchron, one have to wait until its finished.

SUBMIT runs asynchron, runs in the background

Whats the META-TYPE ID for a BP?

Keyboard commands:

= turn,

= for-/backward,

= scroll

105

What contains the table META_TYPE?

All objects ID, INTL_ID, NAME etc. e.g. BP

105, bp, BP etc.

What's the out text norm for? OUT_TEXT_NORM

For the labeling of fields/groups...

How are tables named?

Tables are named according to a hierarchical method, starting with e.g. CODE_, OBJ_ or DOC_ followed by the abbreviation code for an object type or a business type.

What contains a CODE_ table?

Code tables contain constants and can be modified via sources, both starting with CODE_

Can customer define their own CODE_ table?

Yes the can!

How is modification of parameterisation tables possible?

Via source or via API.

How many letters has a namespace?

2-4 letters

What can you say about the normal naming convention?

Namespace $ INTL_ID '_' DESCRIPTION

e.g. ACAD$PB_SSN

What does status corrput mean?

Avaloq ok / Oracle NOK

What des status 'error' mean?

Avaloq NOK

1 / 46

Flashcards

Which table allows to define default values in an entry mask depending on defined criterion? Whats the naming convention of those BTC sources in ICE?

DOC_DFLT_VAL_RULE nad _LD for the loader table

NAMING {META_TYPE}.DOC_FLD.RULE

Which roule engine allows default naming of an object? How is the naming convention of this BTC source?

Table OF_ITEM_FMT_RULE for loader _LD

Naming convention {META_TYPE}.OF.RULE

Which is the most important rule loader table for costs?

COST_RULE (_LD)

What source type has workflow rules and whats the naming convention?

BTC Business Type Config [META-TYPE].WFC

Whats a base parameter?

A base parameter is stored in one source Naming convention BASE.[BASE_PAR_INTL_ID]

What are the four types of context action? CTX_ACTION

DOC

OBJ

CODE

BTC

1
2

Study