Avaloq ACP (DL)
Self-made preparation questions for the "Avaloq Certified Professional" exam
Self-made preparation questions for the "Avaloq Certified Professional" exam
-
- 1 / 267
-
Flashcards
In which sources are context actions being stored (naming/type)? Example?
- OBJ.ASSET.CTX (BUSINESS TYPE CONFIG)
- DOC.STEX.CTX (BUSINESS TYPE CONFIG)
Tables important for context actions?
- CTX_ACTION
- CTX_ACTION_RULE_LD
- (SEC_CTX_ACTION_ACCESS)
- (WFC_ACTION)
How can hierarchical context action menus be realised?
Items in CTX_ACTION table:
- parent_id
- is_parent (boolean)
How can a context action be linked to a workflow action?
- CTX_ACTION:
proc = "ctx_generic_action" - WFC_ACTION:
ctx_action_id = <id of ctx action>
How can a context action be made to execute a task?
CTX_ACTION: proc = "ctx_action_task#.show"
How can a context action be made to execute an Avaloq Script procedure?
CTX_ACTION: proc = "ctx_action_script#.exec ..."
List the 4 different cost calculation methods!
- constant method
- linear method
- degressive method
- minimum / maximum
How can confusions be avoided regarding minimum/maximum with regard to sign?
ABS[30:1000]
Are deferred costs treated as costs or as fees?
as fees
Tables relevant for cost engine?
- CODE_BOOK_KIND (defines cost master data)
- COST_RULE_LD
Input paramters for the Cost Rule Loading Task?
- rule set
- BU
- booking kind
Result items of a COST_RULE_LD entry?
- qty_type (basis of calculation; CODE_COST_QTY_TYPE)
- qty_sign
- factor
- minim_maxim
- offset
Book engine: types of bookings?
- primary bookings (hard-coded)
- rule-based bookings (balance the primary bookings)
Two important booking principles?
- debit = credit: total quantitites of all event packets (bookings) of every asset involved in one event (transaction) must be balanced
- net positions: primary bookings are first booked on a net position and transferred as one total amount to MACC or interim account. They always sum up to zero.
Two types of booking with regard to date?
- transaction-date-based booking (booked as soon as verified)
- value-date-based booking (only temporarily booked while waiting in a queue until value date, revaluation possible in the meantime)
Book engine: how many event stati possible per workflow status?
exactly one
Signs of bookings?
- credit bookings: +
- debit bookings: -
Debit bookings refer to an increase of an account, and credit bookings to a decrease in general.
Book engine: 2 types of recalculation?
- soft recalc: recalculation of book values
- hard recalc: actual rebooking (booking rules are re-evaluated)
What are the functionalities of the booking engine?
- perform bookings
- perform plausibility checks:
- bookings within an order must be balanced (otherwise difference posting)
- costs and fees are always debited on a customer's account
Booking engine: What are the properties of a money account?
- real/legal
- external reporting
- interest
- keys, classifications
- balance typically <> 0
What are the properties of an interim account?
They are mainly u8sed for settlement purposes and as a balance accounts; they serve as auxiliary accounts.
- internal
- internal reporting
- no interest
- no keys or classifications
- balance = 0
Tables relevant for book engine?
- BE_BOOK_RULE_LD
- BE_ASSET_MAP_RULE_LD (how to take various assets into account to check debit=credit)
- BE_POS_RULE_LD (checks and validations)
Matching criteria of BE_BOOK_RULE_LD?
- book_kind
- debcred ("D" matches debit primary booking; "C" matches credit primary booking)
How is it possible to make more than one offsetting booking for one primary booking?
seq_nr valuation constraint of BE_BOOK_RULE_LD
List the 5 user types (security)?
- chargeable end user
- role user holding access rights
- technical end users
- parameterisation end user
- virtual user
List all general access rights
- any
- automatic insert (with log)
- ignore (no log)
- unprotected one's and according to access rights
- according to access rights
- none
API to administrate user rights?
user_admin_intf#
API add/remove access codes from data/funtionality?
sec_admin_intf#
API to inspect visibility of data/funtionality of a specific user (read-only)?
sec_intf#
Tables related to security?
- SEC_USER: contains the actual user types
- CODE ACCESS: contains the access codes
- SEC_USER_ACCESS: links users and access codes
- SEC_XY_ACCESS: links access codes to XY (objects, meta_types, workflow actions, overrides, context actions): XY= action, ctx_action, meta_typ, obj, override
5 Features of Avaloq Script?
- Block structure
- modularity
- separate compilation
- static typing
- object-based type system
Structure of an Avaloq Script source?
[Script 1.0]
script package acad$my_package
is
import util;
l_count number;
--procedures and functions
end acad$my_package
Structure of an Avaloq Script procedure?
procedure my_proc
(
param1 number;
)
is
l_var1 number;
beging
...
end myProc;
Structure of an Avaloq Script function?
function my_funct
(
param1 number;
)
return number;
is
l_var_1 number;
begin
...
end my_funct;
Important Avaloq Script packages?
- util (special chacaracters, numbers, dates)
- format (formatting routines)
- err (format error messages)
- tab (manage text-based tables)
Avaloq Script: with statement?
with xfer.pos.(i).cert(j) as c do
c.qty := 5;
end with;
Avaloq Script: block statement
declase
l_count number;
begin
...
end;
architectural layers of the ABS?
- memory layer (order/date currently modified/displayed)
- order persistence layer (stored orders)
- object (kernel) layer
Types of orders?
- static data orders (no bookings; generate/manipulate objects)
- transactional orders (generate events that cause bookings via booking engine)
