-
Fichier Détails
| Cartes-fiches | 191 |
|---|---|
| Utilisateurs | 20 |
| Langue | English |
| Catégorie | Informatique |
| Niveau | Autres |
| Crée / Actualisé | 24.09.2017 / 05.06.2025 |
| Lien de web |
https://card2brain.ch/box/20170924_avaloq_acp_certification
|
| Intégrer |
<iframe src="https://card2brain.ch/box/20170924_avaloq_acp_certification/embed" width="780" height="150" scrolling="no" frameborder="0"></iframe>
|
What is the concept behind the cost engine?
- Every change in a transaction sends an event to the cost engine
- when the order is finished an event package is created
- event package is the sent to the booking engine
customisation of costs in 2 steps
1. defining cost master data
2. defining cost rules
In cost rule, what do the following entries mean:
QTY_1_TYPE
QTY_1_BOUND
QTY_TYPE
QTY_SIGN
FACTOR
GRADUATED
QTY_1_TYPE: Calculate on WHICH quantity the boundaries base (for example shares, gross amount?)
QTY_1_BOUND: boundaries of 1_type
QTY_TYPE: on which quantity is the COST based on (number of shares / gross amount of transaction)
QTY_SIGN: -ABS for minus, ABS for plus costs (costs are negative so -ABS usually)
FACTOR: cost tariff, for example 0.005 (= 0.5%)
GRADUATED: + various rules are aggrevated, – they are not
How many rule sets for the booking engine are there? Name(s) of the rule set(s)?
One Rule Set - DFLT
What is a shared container?
Every client container is a shared container. Each client container is linked with the bank (BP) itself.
Only a "bank" container can be a single container
differences between booking and balancing
Booking happens realtime | balancing is ad-hoc
Booking can modify orders| balancing does not modify orders
Difference between primary and rule based bookings
- Primary Bookings are defined by Avaloq in the Kernel – cannot be changed
- Rule Based Booking are defined by the bank / developers
Name 2 additional functionalities of the booking engine
Posting Checks: Bookings must be balanced (costs are always debited)
Position Checks: blocked or pledged positions cant be debited
Difference between money account (MACC) and Interim Account
MACC: Interest Calculation, Keys & Classifications, External Report
Interim Account: No Interest, No Keys & No Classification, Internal Reporting
Name the 2 booking principles
- Debit = Credit (Sum of all Event Packages (Bookings) must be = 0)
- All Primary Bookings are first booked on a net position before transferred to the MACC or Interim (net position is always zero and never shown to the customer) Customer only sees one booking on his account
Booking Engine: What is the Event Status
Workflow status represents the status of an order
Event Status represents the status of the bookings
Every Workflow Status has exactly one event status
Book Engine recalculates the rule-based booking every event status change
What is PKO Position Keeping Occurences
Dimensions for accounting standards -AVQ can support different accounting standards, For example Multi GAAP (General Accepted Accounting Principles)
What is Lot Accounting in the Booking Engine?
1. Position is composed by one or several lots
2. every purchase or sell creates a new lot
3. the order in which the lots are dissolved can be defined, this is called lot accounting (basically LIFO/HIFO and so on)
Booking Engine: What is the difference between Soft & Hard Recalculation of Orders
Soft Recalc
Change of the reference currency
Backdated orders
Move dates on already verified orders
Hard Recalc
Manually triggered by the User
List the 3 Pillars within the context of the Balance Engine
Balance Pillar, Position Pillar, Collateral Pillar
Table for CTX Actions?
CTX_ACTION
Table for the Cost Engine Rules
COST_RULE_LD
Table for the Cost Master Data
CODE_BOOK_KIND
In which table can you create the carts of accounts?
BALLAC_LD
In which table can you define the balancing rules?
BALSTRU_RULE_LD
Explain the connection between business units and balance structures?
- Every Balance Structure belongs to one BU
- Every BU can have multiple Balance Structures
What are the steps of implementing a working balance structure?
1. Enter charts of accounts (BALLAC_LD)
2. Define Balancing rules (BALSTRU_RULE_LD)
3. Calculate necessary pillars
API for creating a balance structure
k.balstru#.put
Which Actions for the entries can you define within the Charts of Accounts table BALACC_LD?
I: Inserts a new Balance Account (BA). If BA alreads exists, it is like an U = Update
U: Updates a balance account
C: Closes the Balance Account, the record will NOT be deleted for historicising reason + has a closing date
D: Deletes the Balance Account together with the Container and the Money Account.If one of it has once be used, the record will stay in BALACC_LD
R: Reopen or reactivate a C = Closed Balance Account
NULL: Nothing happens
Security consists of the following 3 Aspects
Confidentiality (Focus of ACP Course): Ensuring that information is only accessible by authorised users
Integrity: Data you see on the screen are accurate and correct
Availability: The Data must be available almost 100% of the time (99,9%) à Business Requirement
What are examples of securable objects in AVQ?
for example:
Order, Adress, Cards, Printers, Objects
List 2 important user types in the AVQ Security Concept
- chargeable end user
- role user holding access rights
List the 6 general access rights with their respective (priorities)
1. any
2. automatic insert
3. ignore
4. unprotected ones and according to access codes
5. according to access codes
6. none
Whate are the 2 kinds of security "concepts"?
open security: maximum access and restrict the system until the access matches your wishes
closed security: no access and grant more access until the access matches your wishes
What is the sentinel business unit?
- Is a virtual business unit
- parameterisation of Sentinel Business Unit will be applied for all business units
Name the 5 security areas in AVQ (like object security)
- Object Security
- Order Security
- Workflow Security
- Override Security
- Data Extraction Security
Which API is used for AVQ security (acccess codes)
sec_admin_intf#.
List the 6 API functions to use with the API security interface + their parameters
.access#upsert (i_intl_id, i_user_id, i_descr)
.xxx#add_access (i_obj_id, i_access_id) (the same for the next 4)
xxx= .obj#
.meta_typ#
.override#
.wfc_action# (i_meta_typ_id, i_wfc_action_id, i_access_id)
Which API is used for AVQ security (user administration)
user_admin_intf#
how do you add an access_code to a user through an API (without parameters)
user_admin_intf#.user#add_access
Difference between Avaloq Script and PL/SQL
Script: No data access through SQL Queries
Script: Symbolic data access
PL/SQL: Direct Data access on physical level
List 3-5 Examples (areas in AVQ Param) where you can use Avaloq Script
Order Validation, Report Writer, Avaloq Message Interface, Context Actions usw.
List the 3 Layers of the AVQ Application Interface
- Kernel / Object Layer
- Order Persistence Layer
- Memory Layer
How does an Object / Order move through the different kernels? make an example with a BP (BP00) and the workflow modify
If you “open” a BP (BP00) object (modify), it gets “copied” out of the “Kernel Layer”
After the modifying you can “hold” (store_obj(8)), BP00 is now on the “order persistence layer” (modifying is locked by the order)
Order on the “Order Persistence Layer” is opened and after that WFC “Verify_Direct” (store_obj(5)) is executed copy of the object BP00 is written into the “Kernel Layer”
(store_obj(1)), you release the Object from the Order à DISCARDING nothing is written into the kernel
Naming Convention for the DDIC's of the different layers + 2 special DDIC's
Order on Memory Layer: mem_doc...
Order on Persistence Layer: doc_...
Order on Kernel Layer: obj_....
Information about the session: session.
Provides access to lookup functionality, it is possible to find objects, code table ID’s and other information through this business objects.: lookup.
