TEAMVIEWEREXQLSRV

EXQLSRV help (EN)

Management

This will start the Application Management:

BEHEER: START><!

Database

Open

General

Field	Description
Server	TODO
Database	TODO
New	TODO
Open	TODO

Recent Databases

Field	Description
Open	TODO

Information

General

Setup

Period

General

Field	Description
Period	TODO
Description	TODO
Alternative	TODO
From	TODO
To	TODO

Currency Rates

General

Field	Description
Transaction type	TODO
Rate type	TODO
From period	TODO

Transaction type

General

Field	Description
Transaction type	TODO
Description	TODO
Alternative	TODO
Currency rate transaction type	TODO
Storage method (Max 13P and no des	TODO

Transaction category

Country

General

Field	Description
Country	TODO
Description	TODO
Alternative	TODO

Currency

General

Field	Description
Currency	TODO
Description	TODO
Alternative	TODO
By	TODO
Divide/Multiply	TODO

Company type

General

Field	Description
Company type	TODO
Description	TODO
Alternative	TODO

Communication

General

Field	Description
Licensee	TODO
Language	TODO
Currency	TODO
Email ExQL server	TODO
Email application administrator	TODO
ExQL Server Folder	TODO
Automatically eliminate 100% IC	TODO
Email confirmation after incoming fo	TODO
Excel VBA Password	TODO
Excel XLS Password	TODO
- XLS H01	TODO
- XLS H02	TODO
- XLS H03	TODO
Display 0	TODO

Configure setup

Field	Description
Company	TODO
Consolidation structure	TODO
Country	TODO
Currency	TODO
Period	TODO
Transaction type	TODO
Transaction category	TODO
Account	TODO
Account structure	TODO
Dimension 1	TODO
Dimension structure 1	TODO
Dimension 2	TODO
Dimension structure 2	TODO
Activity	TODO

Installation manual

Field	Description
Subject	TODO
Body	TODO

Manual new version

Field	Description
Subject	TODO
Body	TODO

Company

Basic

General

Field	Description
Company	TODO
Description	TODO
Popular/des	TODO
Alternative	TODO
Popular/alt	TODO
Country	TODO
Currency	TODO
Language	TODO
Company type	TODO
Contact person	TODO
Reminder person	TODO
Email cc	TODO
2nd Email cc	TODO
3rd Email cc	TODO
4th Email cc	TODO
5th Email cc	TODO
6th Email cc	TODO
Blocked	TODO

Address

Field	Description
Address	TODO
Postal code	TODO
Town	TODO
Phone	TODO
Fax	TODO
Acquisition	TODO
Disinvestment	TODO

Employees

Field	Description
Contact person	TODO
Company	TODO
Search	TODO

Structure

General

Field	Description
Consolidation structure	TODO
Description	TODO
Transaction type	TODO
Period	TODO
Memo	TODO

Structure

Field	Description
Company	TODO
%	TODO
Type	TODO
Filter	TODO
Search	TODO

Account

Basic

General

Field	Description
Account	TODO
Description	TODO
Popular/des	TODO
Alternative	TODO
Popular/alt	TODO
Dimension 1	TODO
Dimension 2	TODO
Reference	TODO
Company	TODO
Financial	TODO
IC Elimination	TODO
IC Counter account	TODO
IC Difference account	TODO
Rate type	TODO
Blocked	TODO

Structure

General

Field	Description
Account structure	TODO
Description	TODO
Memo	TODO

Structure

Field	Description
Account	TODO
Search	TODO

Dimension 1

Basic

General

Field	Description
Dimension 1	TODO
Description	TODO
Alternative	TODO

Structure

General

Field	Description
Dimension structure 1	TODO
Description	TODO
Memo	TODO

Structure

Field	Description
Dimension 1	TODO
Search	TODO

Dimension 2

Basic

General

Field	Description
Dimension 2	TODO
Description	TODO
Alternative	TODO

Structure

General

Field	Description
Dimension structure 2	TODO
Description	TODO
Memo	TODO

Structure

Field	Description
Dimension 2	TODO
Search	TODO

Document

Basic

General

Field	Description
Document	TODO
Description	TODO
Alternative	TODO
Excel file	TODO
Type	TODO
Enable protection	TODO
Zip file	TODO
Reporting calendar	TODO
Send copy to FRMCCx	TODO
XLS Password	TODO
Memo	TODO

Email

Field	Description
Send to	TODO
Subject	TODO
Body	TODO
Send to	TODO
Subject reminder	TODO
Body	TODO
Attachment	TODO

Params

Field	Description
Type	TODO
Name	TODO
Description	TODO
Alternative	TODO
Default value	TODO
Filter/list	TODO
<>Filter/list	TODO
Company type (filter/list)	TODO
Blocked	TODO
Advanced	TODO

Authorisation

Field	Description
Search	TODO

Calendar

General

Field	Description
Reporting calendar	TODO
Description	TODO
Status	TODO
Start date	TODO
Reminder date	TODO
Document	TODO
Period	TODO
Transaction type	TODO
Consolidation structure	TODO
From company	TODO
Company type	TODO
Fiat structure	TODO
Blocked on	TODO
Send to	TODO
Copy to	TODO
Blocked	TODO

Companies

Field	Description
Company	TODO
Fiat	TODO
Search	TODO

Params

Field	Description
Value	TODO

History

General

Field	Description
Document	TODO
Type	TODO
From date	TODO
Company	TODO
Period	TODO
Transaction type	TODO
User	TODO

Authorisation

Profile

General

Field	Description
Profile	TODO
Description	TODO

Documents

Field	Description
Search	TODO

User

General

Field	Description
User	TODO
Description	TODO
Profile	TODO
Phone	TODO
Fax	TODO
Email	TODO
File extension (Setup)	TODO
Blocked on	TODO
Zip before Send	TODO
Sent on	TODO
Confirmed	TODO
Shared folder	TODO
Blocked	TODO

Additional Email

Field	Description
Additional Email	TODO
Zip before Send	TODO
Sent on	TODO
Confirmed	TODO

Documents

Field	Description
Search	TODO

Companies

Field	Description
Company	TODO
Consolidation structure	TODO
Search	TODO

History

General

Field	Description
User	TODO
Type	TODO
From date	TODO

Send setup

General

Field	Description
Profile	TODO
Selection	TODO
Additional Email	TODO
Send	TODO

BEHEER: EINDE><!

Import form

Database

Form

Report

Task

Draft

Unprotect

Help

Download update

Settings

Functions

ExQL_ADRES

This function shows the (absolute) range..

Argument	Beschrijving
p_range	a selected range..

ExQL_ORGOMS

Provides the description of the organisation of the filled in organisation code..

Argument	Beschrijving
p_orgnr	Company..
[p_opmaak]	0=Standard, 1=Upper-case letters, 2=Lower-case letters, 3=First digit is upper-case or 4=All words start with a capital..

ExQL_RANOMS

Looks for a value in the first column of a table and returns the value of a column (defined in the formula) of the same row..

Argument	Beschrijving
p_value	the value to look for in the first column of the defined p_range.
p_range	the datarange that contains the data to look for. This parameter can refer to a range or a range-name..
p_col	the number of the column in p_range that contains the requested p_value. When p_col is 1, the value in column 1 is picked up, when p_col is 2 the value from the second column etc..
[p_onjuist]	an error message is shown when the requested p_value is not found..
[p_opmaak]	0=Standard, 1=Upper-case letters, 2=Lower-case letters, 3=First digit is upper-case or 4=All words start with a capital..

ExQL_REFNR

Automatic numbering of previous reference number for the same account..

Argument	Beschrijving
[p_extra]	Prefix of the code..
[p_links]	Place prefix on the left (true or false).
[p_lengte]	Length of serial number..

ExQL_VALOMS

This function shows the currency description..

Argument	Beschrijving
p_valnr	Currency..
[p_opmaak]	0=Standard, 1=Upper-case letters, 2=Lower-case letters, 3=First digit is upper-case or 4=All words start with a capital..

ExQLSRV_ADMTAA

.

Argument	Beschrijving
	Currency..

ExQLSRV_ADMVAL

The basic (application) currency code is shown..

Argument	Beschrijving
	Currency..

ExQLSRV_BLAD

This function shows the name of the worksheet where the function is placed..

Argument	Beschrijving
	Currency..

ExQLSRV_CATALT

This function shows the alternative transaction category description..

Argument	Beschrijving
p_catnr	Transaction category..
[p_opmaak]	0=Standard, 1=Upper-case letters, 2=Lower-case letters, 3=First digit is upper-case or 4=All words start with a capital..

ExQLSRV_CATOMS

This function provides the description of the transaction category..

Argument	Beschrijving
p_catnr	Transaction category..
[p_orgtaa]	Defines the description to show. D=Default description or A=Alternative description..
[p_opmaak]	0=Standard, 1=Upper-case letters, 2=Lower-case letters, 3=First digit is upper-case or 4=All words start with a capital..

ExQLSRV_COPYCELLS

.

Argument	Beschrijving
p_van	From..
p_naar	To..
[p_execute]	Execute..

ExQLSRV_D1SOMS

This function shows the description of a dimension 1 structure..

Argument	Beschrijving
p_d1snr	Dimension 1 structure..
[p_opmaak]	0=Standard, 1=Upper-case letters, 2=Lower-case letters, 3=First digit is upper-case or 4=All words start with a capital..

ExQLSRV_D2SOMS

This function shows the description of a dimension 2 structure..

Argument	Beschrijving
p_d2snr	Dimension 2 structure..
[p_opmaak]	0=Standard, 1=Upper-case letters, 2=Lower-case letters, 3=First digit is upper-case or 4=All words start with a capital..

ExQLSRV_DI1ALT

The alternative description of dimension 1 is shown..

Argument	Beschrijving
p_di1nr	Dimension 1..
[p_opmaak]	0=Standard, 1=Upper-case letters, 2=Lower-case letters, 3=First digit is upper-case or 4=All words start with a capital..

ExQLSRV_DI1OMS

This function shows the description of dimension 1..

Argument	Beschrijving
p_di1nr	Dimension 1..
[p_orgtaa]	Defines the description to show. D=Default description or A=Alternative description..
[p_opmaak]	0=Standard, 1=Upper-case letters, 2=Lower-case letters, 3=First digit is upper-case or 4=All words start with a capital..

ExQLSRV_DI2ALT

This function shows the alternative description of dimension 2..

Argument	Beschrijving
p_di2nr	Dimension 2..
[p_opmaak]	0=Standard, 1=Upper-case letters, 2=Lower-case letters, 3=First digit is upper-case or 4=All words start with a capital..

ExQLSRV_DI2OMS

This function provides the description of dimension 2..

Argument	Beschrijving
p_di2nr	Dimension 2..
[p_orgtaa]	Defines the description to show. D=Default description or A=Alternative description..
[p_opmaak]	0=Standard, 1=Upper-case letters, 2=Lower-case letters, 3=First digit is upper-case or 4=All words start with a capital..

ExQLSRV_EMLZIP

This function defines the user setup and / or if the file is send zipped or unzipped. The outcome is TRUE or FALSE..

Argument	Beschrijving
p_mdweml	E-mail..

ExQLSRV_EVRBLK

This code shows whether fiat has been given to the organisation for this activity, base don activity code and organisation code..

Argument	Beschrijving
p_evtnr	Reporting calendar..
p_orgnr	Company..

ExQLSRV_EVRCNT

.

Argument	Beschrijving
p_evtnr	Reporting calendar..
p_orgnr	Company..

ExQLSRV_EVRDAT

.

Argument	Beschrijving
p_evtnr	Reporting calendar..
p_orgnr	Company..

ExQLSRV_EVREM2

This function provides the e-mail address of the reminder person of the organisation (at the moment the activity is activated). The reminder person will receive (and fill in) the form when the form is not send back in time by the contact person..

Argument	Beschrijving
p_evtnr	Reporting calendar..
p_orgnr	Company..

ExQLSRV_EVREMI

.

Argument	Beschrijving
p_evtnr	Reporting calendar..
p_orgnr	Company..

ExQLSRV_EVREML

The e-mail address of the contact person who receives and fills in forms of the organisation..

Argument	Beschrijving
p_evtnr	Reporting calendar..
p_orgnr	Company..

ExQLSRV_EVRSTA

The activity status of the organisation is provided, based on the organisation code and the activity code..

Argument	Beschrijving
p_evtnr	Reporting calendar..
p_orgnr	Company..
[p_orgtaa]	Defines the description to show. D=Default description or A=Alternative description..

ExQLSRV_EVTDVN

.

Argument	Beschrijving
p_evtnr	Reporting calendar..

ExQLSRV_EVTOMS

This function shows the activity description..

Argument	Beschrijving
p_evtnr	Reporting calendar..
[p_opmaak]	0=Standard, 1=Upper-case letters, 2=Lower-case letters, 3=First digit is upper-case or 4=All words start with a capital..

ExQLSRV_EVTORS

This function shows the description of the fiat scheme..

Argument	Beschrijving
p_evtnr	Reporting calendar..

ExQLSRV_EXPORS

.

Argument	Beschrijving
p_orsnr	Consolidation structure..

ExQLSRV_EXPSTR

.

Argument	Beschrijving
p_range	Range..
[p_sep]	Separator..
[p_offset]	.
[p_limit]	.

ExQLSRV_FORMULE

Is used to check if all editing is executed within the sheet..

Argument	Beschrijving
p_calc	Formula..

ExQLSRV_FRMOMS

.

Argument	Beschrijving
p_frmnr	Document..
[p_opmaak]	0=Standard, 1=Upper-case letters, 2=Lower-case letters, 3=First digit is upper-case or 4=All words start with a capital..

ExQLSRV_FRMTPE

.

Argument	Beschrijving
p_frmnr	Document..

ExQLSRV_ISFORMULA

Indicates if a cell contains a formula or a value..

Argument	Beschrijving
p_cel	.

ExQLSRV_JNLBDG

.

Argument	Beschrijving
p_pernr	Period..
p_tranr	Transaction type..
p_catnr	Transaction category..
p_orgnr	Company..
p_reknr	Account..
p_di1nr	Dimension 1..
p_di2nr	Dimension 2..
p_orgnr_cor	Intercompany code..
p_refnr	Reference..
[p_pervj]	.

ExQLSRV_JNLOMS

.

Argument	Beschrijving
p_pernr	Period..
p_tranr	Transaction type..
p_catnr	Transaction category..
p_orgnr	Company..
p_reknr	Account..
p_di1nr	Dimension 1..
p_di2nr	Dimension 2..
p_orgnr_cor	Intercompany code..
p_refnr	Reference..
[p_pervj]	.

ExQLSRV_LNDALT

Provides the alternative country description..

Argument	Beschrijving
p_lndnr	Country..
[p_opmaak]	0=Standard, 1=Upper-case letters, 2=Lower-case letters, 3=First digit is upper-case or 4=All words start with a capital..

ExQLSRV_LNDOMS

Provides the description of the country code..

Argument	Beschrijving
p_lndnr	Country..
[p_orgtaa]	Defines the description to show. D=Default description or A=Alternative description..
[p_opmaak]	0=Standard, 1=Upper-case letters, 2=Lower-case letters, 3=First digit is upper-case or 4=All words start with a capital..

ExQLSRV_MATCH

.

Argument	Beschrijving
p_p01	.
p_p02	.
p_p03	.
p_p04	.
p_p05	.
p_p06	.
p_p07	.
p_p08	.
p_p09	.
p_p10	.
p_p11	.
p_p12	.
p_p13	.
p_p14	.
p_p15	.
p_p16	.
p_p17	.
p_p18	.
p_p19	.
p_p20	.
p_p21	.

ExQLSRV_MATCH_ORGNR

.

Argument	Beschrijving
p_p01	.
p_p02	.
p_p03	.
p_p04	.
p_p05	.
p_p06	.
p_p07	.
p_p08	.
p_p09	.
p_p10	.
p_p11	.
p_p12	.
p_p13	.
p_p14	.
p_p15	.
p_p16	.
p_p17	.
p_p18	.
p_p19	.
p_p20	.
p_p21	.

ExQLSRV_MATCH_ORGNR_COR

.

Argument	Beschrijving
p_p01	.
p_p02	.
p_p03	.
p_p04	.
p_p05	.
p_p06	.
p_p07	.
p_p08	.
p_p09	.
p_p10	.
p_p11	.
p_p12	.
p_p13	.
p_p14	.
p_p15	.
p_p16	.
p_p17	.
p_p18	.
p_p19	.
p_p20	.
p_p21	.

ExQLSRV_MDWEML

Provides the e-mail address of an employee..

Argument	Beschrijving
p_mdwnr	User..

ExQLSRV_MDWOMS

Provides the description (is name) of an employee code..

Argument	Beschrijving
p_mdwnr	User..
[p_opmaak]	0=Standard, 1=Upper-case letters, 2=Lower-case letters, 3=First digit is upper-case or 4=All words start with a capital..

ExQLSRV_MDWORG

Defines if an employee and a company are connected..

Argument	Beschrijving
p_mdwnr	User..
p_orgnr	Company..

ExQLSRV_NOW

Shows date and time that the report is created..

Argument	Beschrijving
	User..

ExQLSRV_ORGADR

.

Argument	Beschrijving
p_orgnr	Company..
[p_opmaak]	0=Standard, 1=Upper-case letters, 2=Lower-case letters, 3=First digit is upper-case or 4=All words start with a capital..

ExQLSRV_ORGAL2

This function provides the alternative popular description of the organisation..

Argument	Beschrijving
p_orgnr	Company..
[p_opmaak]	0=Standard, 1=Upper-case letters, 2=Lower-case letters, 3=First digit is upper-case or 4=All words start with a capital..

ExQLSRV_ORGALT

This function provides the alternative organisation description..

Argument	Beschrijving
p_orgnr	Company..
[p_opmaak]	0=Standard, 1=Upper-case letters, 2=Lower-case letters, 3=First digit is upper-case or 4=All words start with a capital..

ExQLSRV_ORGBLK

Shows TRUE or FALSE to indicate if the organisation is blocked..

Argument	Beschrijving
p_orgnr	Company..

ExQLSRV_ORGCNT

.

Argument	Beschrijving
p_orgnr	Company..
p_orsnr	Consolidation structure..
[p_orsins]	0=Total impact or 1=Direct impact..

ExQLSRV_ORGEIG

This function is to calculate the ownership relation..

Argument	Beschrijving
p_orgnr	Company..
p_orsnr	Consolidation structure..
p_orgnr_rap	Reporting (parent)-company.
[p_orstpe]	0=Proportional or 1=Integral..
[p_orsins]	0=Total impact or 1=Direct impact..

ExQLSRV_ORGEML

This function provides the e-mail address (1 until 8) of the contact person of an organisation..

Argument	Beschrijving
p_orgnr	Company..
[p_mdwcnt]	Contact person (1/8)..
[p_frmnr]	Document..

ExQLSRV_ORGINS

This function provides all organisation codes that report (directly) to the reporting organisation. It regards the daughters of the organisation, based on a consolidation structure..

Argument	Beschrijving
p_orgnr_rap	Reporting (parent)-company.
p_orsnr	Consolidation structure..
[p_orsins]	0=Total impact or 1=Direct impact..

ExQLSRV_ORGLND

This function provides the land code of an organisation..

Argument	Beschrijving
p_orgnr	Company..

ExQLSRV_ORGMDW

This function provides the employee code (1 until 8) of the organisation..

Argument	Beschrijving
p_orgnr	Company..
[p_mdwcnt]	Contact person (1/8)..
[p_frmnr]	Document..

ExQLSRV_ORGNR

This function shows the reporting entity (mother company) of an organisation based on an organisation structure..

Argument	Beschrijving
p_orgnr	Company..
p_orsnr	Consolidation structure..
[p_orsins]	0=Total impact or 1=Direct impact..

ExQLSRV_ORGNR_COR

.

Argument	Beschrijving
p_p01	.
p_p02	.
p_p03	.
p_p04	.
p_p05	.
p_p06	.
p_p07	.
p_p08	.
p_p09	.
p_p10	.
p_p11	.
p_p12	.
p_p13	.
p_p14	.
p_p15	.
p_p16	.
p_p17	.
p_p18	.
p_p19	.
p_p20	.
p_p21	.

ExQLSRV_ORGOM2

This function provides the popular description of an organisation..

Argument	Beschrijving
p_orgnr	Company..
[p_orgtaa]	Defines the description to show. D=Default description or A=Alternative description..
[p_opmaak]	0=Standard, 1=Upper-case letters, 2=Lower-case letters, 3=First digit is upper-case or 4=All words start with a capital..

ExQLSRV_ORGOMS

This function provides the description of the organisation..

Argument	Beschrijving
p_orgnr	Company..
[p_orgtaa]	Defines the description to show. D=Default description or A=Alternative description..
[p_opmaak]	0=Standard, 1=Upper-case letters, 2=Lower-case letters, 3=First digit is upper-case or 4=All words start with a capital..

ExQLSRV_ORGTAA

This function provides the language code of the organisation..

Argument	Beschrijving
p_orgnr	Company..

ExQLSRV_ORGTPE

.

Argument	Beschrijving
p_orgnr	Company..
p_orsnr	Consolidation structure..
[p_orsins]	0=Total impact or 1=Direct impact..

ExQLSRV_ORGVAL

This function provides the currency code of the organisation..

Argument	Beschrijving
p_orgnr	Company..

ExQLSRV_ORGWPL

.

Argument	Beschrijving
p_orgnr	Company..
[p_opmaak]	0=Standard, 1=Upper-case letters, 2=Lower-case letters, 3=First digit is upper-case or 4=All words start with a capital..

ExQLSRV_ORSCNT

The number of organisations (daughter companies) that belong to the reporting unit of the provided organisation structure..

Argument	Beschrijving
p_orgnr_rap	Reporting (parent)-company.
p_orsnr	Consolidation structure..
[p_orsins]	0=Total impact or 1=Direct impact..

ExQLSRV_ORSNR

This function provides the consolidation structure code of certain period and transaction type..

Argument	Beschrijving
p_pernr	Period..
p_tranr	Transaction type..

ExQLSRV_ORSOMS

This function shows the description of the consolidation structure..

Argument	Beschrijving
p_orsnr	Consolidation structure..
[p_opmaak]	0=Standard, 1=Upper-case letters, 2=Lower-case letters, 3=First digit is upper-case or 4=All words start with a capital..

ExQLSRV_ORTALT

This function provides the alternative description of the organisation type..

Argument	Beschrijving
p_ortnr	Company type..
[p_opmaak]	0=Standard, 1=Upper-case letters, 2=Lower-case letters, 3=First digit is upper-case or 4=All words start with a capital..

ExQLSRV_ORTNR

This function provides the organisation type of the organisation..

Argument	Beschrijving
p_orgnr	Company..

ExQLSRV_ORTOMS

This function provides the description of the organisation type..

Argument	Beschrijving
p_ortnr	Company type..
[p_orgtaa]	Defines the description to show. D=Default description or A=Alternative description..
[p_opmaak]	0=Standard, 1=Upper-case letters, 2=Lower-case letters, 3=First digit is upper-case or 4=All words start with a capital..

ExQLSRV_PERALT

This function provides the alternative description of a period..

Argument	Beschrijving
p_pernr	Period..
[p_opmaak]	0=Standard, 1=Upper-case letters, 2=Lower-case letters, 3=First digit is upper-case or 4=All words start with a capital..

ExQLSRV_PERDTM

This function provides the end date of a period..

Argument	Beschrijving
p_pernr	Period..

ExQLSRV_PERDVN

This function provides the beginning date of a period..

Argument	Beschrijving
p_pernr	Period..

ExQLSRV_PERNR

This function gives a period code (under the condition that the period code is a 4-digit number code)..

Argument	Beschrijving
p_pernr	Period..
p_percnt	.
[p_jarcnt]	.
[p_jarcmd]	.
[p_permax]	.
[p_permin]	.

ExQLSRV_PEROMS

This function provides the description of a period..

Argument	Beschrijving
p_pernr	Period..
[p_orgtaa]	Defines the description to show. D=Default description or A=Alternative description..
[p_opmaak]	0=Standard, 1=Upper-case letters, 2=Lower-case letters, 3=First digit is upper-case or 4=All words start with a capital..

ExQLSRV_RANOMS

Looks for a value in the most left column of a table and provides a value from the same row from the referred column..

Argument	Beschrijving
p_value	the value to look for in the first column of the defined p_range.
p_range	.
p_col	.
[p_onjuist]	an error message is shown when the requested p_value is not found..
[p_opmaak]	0=Standard, 1=Upper-case letters, 2=Lower-case letters, 3=First digit is upper-case or 4=All words start with a capital..

ExQLSRV_REFNR

.

Argument	Beschrijving
p_p01	.
p_p02	.
p_p03	.
p_p04	.
p_p05	.
p_p06	.
p_p07	.
p_p08	.
p_p09	.
p_p10	.
p_p11	.
p_p12	.
p_p13	.
p_p14	.
p_p15	.
p_p16	.
p_p17	.
p_p18	.
p_p19	.
p_p20	.
p_p21	.

ExQLSRV_REKALT

This function provides the alternative description of an account..

Argument	Beschrijving
p_reknr	Account..
[p_opmaak]	0=Standard, 1=Upper-case letters, 2=Lower-case letters, 3=First digit is upper-case or 4=All words start with a capital..

ExQLSRV_REKAL2

This function provides the alternative popular description of an account..

Argument	Beschrijving
p_reknr	Account..
[p_opmaak]	0=Standard, 1=Upper-case letters, 2=Lower-case letters, 3=First digit is upper-case or 4=All words start with a capital..

ExQLSRV_REKICR

.

Argument	Beschrijving
p_reknr	Account..

ExQLSRV_REKICV

.

Argument	Beschrijving
p_reknr	Account..

ExQLSRV_REKOM2

This function provides the popular description of an account..

Argument	Beschrijving
p_reknr	Account..
[p_orgtaa]	Defines the description to show. D=Default description or A=Alternative description..
[p_opmaak]	0=Standard, 1=Upper-case letters, 2=Lower-case letters, 3=First digit is upper-case or 4=All words start with a capital..

ExQLSRV_REKOMS

This functie provides the description of an account..

Argument	Beschrijving
p_reknr	Account..
[p_orgtaa]	Defines the description to show. D=Default description or A=Alternative description..
[p_opmaak]	0=Standard, 1=Upper-case letters, 2=Lower-case letters, 3=First digit is upper-case or 4=All words start with a capital..

ExQLSRV_REPLACE

.

Argument	Beschrijving
p_expression	Expression..
p_find	Find..
p_replace	.

ExQLSRV_RESCNT

The number of accounts within an account structure, counting down from the account code provided. In other words, how many accounts roll up to the account provided..

Argument	Beschrijving
p_reknr	Account..
p_resnr	Account structure..
[p_resins]	.

ExQLSRV_RESOMS

This function provides the description of an account structure code..

Argument	Beschrijving
p_resnr	Account structure..
[p_opmaak]	0=Standard, 1=Upper-case letters, 2=Lower-case letters, 3=First digit is upper-case or 4=All words start with a capital..

ExQLSRV_SQL

.

Argument	Beschrijving
p_sql	SQL Statment..

ExQLSRV_SQLBDG

.

Argument	Beschrijving
p_sql	SQL Statment..

ExQLSRV_SQLCPY

.

Argument	Beschrijving
p_sql	SQL Statment..

ExQLSRV_TABCOLOR

.

Argument	Beschrijving
p_colorindex	.

ExQLSRV_TRAALT

This function provides the alternative description of a transaction code..

Argument	Beschrijving
p_tranr	Transaction type..
[p_opmaak]	0=Standard, 1=Upper-case letters, 2=Lower-case letters, 3=First digit is upper-case or 4=All words start with a capital..

ExQLSRV_TRAOMS

This function provides the (alternative) description of the transaction code..

Argument	Beschrijving
p_tranr	Transaction type..
[p_orgtaa]	Defines the description to show. D=Default description or A=Alternative description..
[p_opmaak]	0=Standard, 1=Upper-case letters, 2=Lower-case letters, 3=First digit is upper-case or 4=All words start with a capital..

ExQLSRV_VALALT

This function provides the alternative description of a currency code..

Argument	Beschrijving
p_valnr	Currency..
[p_opmaak]	0=Standard, 1=Upper-case letters, 2=Lower-case letters, 3=First digit is upper-case or 4=All words start with a capital..

ExQLSRV_VALFAC

This function shows the factor of a currency (factor per how many to calculate)..

Argument	Beschrijving
p_valnr	Currency..

ExQLSRV_VALFDV

This function shows whether the currency needs to be divided or multiplied by the currency factor..

Argument	Beschrijving
p_valnr	Currency..

ExQLSRV_VALKRS

This function provides the exchange rate for the combination of the requested currency, period, transaction type and type of calculation..

Argument	Beschrijving
p_valnr	Currency..
p_pernr	Period..
p_tranr	Transaction type..
p_vartpe	Currency type (AVG=Average or ULT=Closing Fx rate)..

ExQLSRV_VALOMS

This functie provides the description of a currency code..

Argument	Beschrijving
p_valnr	Currency..
[p_orgtaa]	Defines the description to show. D=Default description or A=Alternative description..
[p_opmaak]	0=Standard, 1=Upper-case letters, 2=Lower-case letters, 3=First digit is upper-case or 4=All words start with a capital..

ExQLSRV_VARTPE

This function retrieves the currency type from an account..

Argument	Beschrijving
p_reknr	Account..

ExQLSRV_SYSINFO

.

Argument	Beschrijving
p_sysnr	.

ExQLSRV_HYPERLINK

Returns a Hyperlinks collection that represents the hyperlinks for the worksheet..

Argument	Beschrijving
p_locatie	The location within the document associated with the hyperlink (Sheet1!A1)..
p_tekst	The text to be displayed for the specified hyperlink..