-
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 are orders?
All Changes to objects are orders
all transactions are orders
all orders must have a workflow (to further work with them)
List 4 different kinds of Data Types in a DDIC
1. Base Type Fields (text, number, date, long)
2. Reference Types ("mem_doc_bp(doc_id)" --> value is loaded each time the field is called)
3. ID Types (shows the ID of the referenced table)
4. Object Type ("mem_doc_bp(doc_id.domi_country.name" Reference to other DDIC)
What 2 kind of Fields are there in a DDIC
simple fields
indexed fields
A DDIC consists of the following 3 parts:
- Constructor (only in memory layer)
- fields
- methods
4 Data Dictionary types
1. Memory DDIC
2. Table DDIC
3. Datamarts
4. Pillar DDIC's
What are singeltons?
Singeltons are special Data Dictionaries which which are always available
.session
.lookup
Explain the parts of the structure of a "function" in AVQ script
- function parameters
- define return data type
- function variables (local variables)
- function program logic + return value
What is the difference between a procedure and a function?
- procedure has no return value
- function has a return value
With which script code can you show an error message on the user's screen?
session.raise_ui_err
name 4 important script packages in AVQ script
1. UTIL
2. FORMAT
3. ERR
4. TAB
How do you declare a variable in AVQ script?
begin
declare
l_var1 number;
how do you assign a value to a variable
l_var := obj_person(i_person_id).lang.name
explain the 4 different statements you know in AVQ script
1. for ... loop
- for bp in p.bp_list loop end loop;
2. if... then
if p.lang.name='English' then.. end if;
3. case statement
case p.lang.name
when 'English' then... end case;
4. with statement
with XXXX as p do
end with;
What is coalesce?
Coalesce returns the first "not null" value of the objects in the parameters
coalesce(p.hometown,p.person, p.profession)
name the 3 possible form types in AVQ
- standard form (designed by AVQ, not changeable by the customer)
- overridden Standard Form (designed by AVQ, changes by the customer)
- Custom form (public, can be based on AVQ form or own sources)
Name the 2 categories forms can be divided into
default forms: are called after the business type they're designed for, covers all the basis + all the information that COULD be used
non-default forms: specialized forms for a specific purpose, only some possible fields are shown
What is the form controller?
Resides between the form and the order and transforms the visible data into the values of the order fields (transforms values)
list the 3 sources used for form customisation?
- doc definition (form)
- win definition (subwindows)
- INTF def
Naming Conventions for form sources?
BUSINESS_TYPE.extension
in a source, how do you access data of the underlying business type?
via doc.x example doc.first_name
which in this context means "mem_doc_bt --> mem_doc_bp.first_name)
what does the form compiler do?
the form compiler uses the source to create the necessary PL/SQL code
What are the 2 customisation approaches for forms?
1. override an existing standard form
2. create a custom form based on the underlying DDIC of the BT
What can you do when you override a standard form (2 answers correct)
What form Elements do you know of?
1. Structuring elements like groups & Sections
2. Content elements: fields, labels, buttons
what is the keyword for the form?
Form 1.1
What are the keywords for the placing of content / structuring elements in the form?
top & left
what happens if no keyword for placing is specified for a structuring/content element? (1 answer correct)
what are the 5 design essentials when structuring a form?
Proportions: Areas look better if their width is greater than their height, forms should have a side ration of 1:1 to 1:2 (widht to height)
Balance: A form is divided by a vertical line in the middle, information should be the same on both sides of the line
Symmetry: Specifies that horizontally opposed elements should be of similar type or size
Sequence: Users eye should be led sequentally through the form without having to jump back, most important information should be top left
Simplicity: Designed as simply as possible
can you restrict access to certain fields of a form?
no, not directly. you can however create a new form without the fields you dont want to be shown
What is the BASE_META_TYP_ID and the META_TYP of a form?
the BASE_META_TYPE_ID is the ID of the base meta type, example BP "105"
the new META_TYP entry is a new entry unique to the form
What happens if there is an entry in FORM_ID in the table WFC_ACTION?
The WFC is only available in this particular meta_typ (also known as FORM)
if there is no entry, the WFC is available in all meta_typs with the same BASE_META_TYP_ID
What does the header of a form look like?
[Form 1.1]
doc definition BP
How do you define fields in a FORM (general convention)
field_name field_type (field properties)
what field properties are there (4)
- edit
- switch
- mandatory
- hide
if you use the field property "mandatory", what happens with the field?
it is "marked" as mandatory, but it will not be checked.
the check if the field is filled in is done with Order Validation OV
List 5 different field types
- Label
- Text
- Number
- Code
- Obj
- Date
- Multiline
- screen_report
- list
- table
make an example of static field mapping in forms?
Field
value [doc.bp_branch]
What does the keyword "auto" do in static field mapping?
auto means that the field is automatically calculated if you switch it "on".
switch MUST be active for this field
what is the difference between "tab" and "taborder"
taborder defines how you "tab" through the form
tab is for defining the subwindows
Name 3 level of events for the Form Event Handler
- field level
- form level
- doc level
