Category pool

Within a TGKML script it is possible to use the categories grouping's nodes labeled as "pool" (for further details see Editable categories pool) using the following syntax

Category.Pool ([node code|grouping code])

Let's see some example about the behavior of the system when the abovementioned function is used within the script.

Let us assume we have the following script:

[LO].[X00000](Category.Pool([01|$])) := ...

where 01 is a categories grouping's node labeled as pool. Let's assume that:

• CAT_1 and CAT_2 are two categories related to he node 01;
• USER_1 is authorized to write on the category CAT_1;
• USER_2 is authorized to write on the category CAT_2;

and that data on the database are:

Entity	Account	Scenario	Category	Dest1	Dest2	Period	Amount	Origin
A00	X00000	2013BDG	CAT_1	D11	D21	01	10	INPUT_DEFORM
A00	X00000	2013BDG	CAT_2	D11	D22	01	20	INPUT_DEFORM

The user USER_1 runs the script and has as result 100. In this case the system writes on the database following data

Entity	Account	Scenario	Category	Dest1	Dest2	Period	Amount	Origin
A00	X00000	2013BDG	CAT_1	D11	D21	01	10	INPUT_DEFORM
A00	X00000	2013BDG	CAT_2	D11	D22	01	20	INPUT_DEFORM
A00	X00000	2013BDG	CAT_1	D11	D21	01	70	PROC_CALCULATED

The user USER_2 runs the script and has as result 110. Inthis case the system writes on the database following data

Entity	Account	Scenario	Category	Dest1	Dest2	Period	Amount	Origin
A00	X00000	2013BDG	CAT_1	D11	D21	01	10	INPUT_DEFORM
A00	X00000	2013BDG	CAT_2	D11	D22	01	20	INPUT_DEFORM
A00	X00000	2013BDG	CAT_1	D11	D21	01	70	PROC_CALCULATED
A00	X00000	2013BDG	CAT_2	D11	D22	01	10	PROC_CALCULATED

If in the Input part of the script the currency is not specified, while reading data the system performs a reading from fixed point on the category node specified in the output part.

The system, at the deletion step, deletes data by user.