CLAUSION.DRDATA functions
CLAUSION.DRDATA (Datatype_Code;Doc_Serie;Account_No...)
Get account balance (debit: positive, credit: negative)
CLAUSION.DRDATA functions
Content |
Type |
Possible values* |
Notes |
|---|---|---|---|
Datatype |
ID |
Typically ACT, BUD, EST, ... |
|
Document series / number |
ID |
10000, 20000, 60002, ... |
Use ";" as separator for multiple choices. You can also select just one document series or number. You cannot select both series and numbers at the same time. Clausion custom parameters not supported. |
Account |
ID |
979989P, 199999P, 299999P, ... |
|
Year |
ID |
Typically 2020, 2019, ... |
|
Period |
ID |
Typically 0, 1, 2, ..., 12 |
|
Is cumulative |
boolean |
TRUE or FALSE |
No quotes. False means periodical. |
Currency |
ID |
UNIT, GROUP or a specific currency: EUR, SEK, USD, ... |
|
DIM00 unit |
ID |
Organization-specific unit codes |
|
DIM00 counter unit |
ID |
Organization-specific unit codes |
Optional. This argument only for DIM00. When empty, takes value from argument 8. |
DIM00 hierarchy |
ID |
Could be, for example, "STRUCTURE1" |
Optional. Hierarchy used for consolidation units. When empty, the first hierarchy is used. |
DIM01 unit |
ID |
Optional |
|
DIM01 hierarchy |
ID |
Optional |
|
DIM02 unit |
ID |
Optional |
|
DIM02 hierarchy |
ID |
Optional |
|
DIM03 unit |
ID |
Optional |
|
DIM03 hierarchy |
ID |
Optional |
|
... |
Last possible hierarchy is 9 |
||
Dimension extra field filter |
Filter |
Extra field definition + operator + filtering value, for example, "E01=Europe" |
Optional. Use vertical bar "|" as a separator for multiple filters. Wrap the extra field value with curly brackets "{}" if the value includes special characters. Use semicolon ";" as a separator for multiple operators. The operators for extra field operations are "=" (equal to), "!=" (not equal to), "<" (less than), "<=" (equal to or less than), ">" (greater than), ">=" (equal to or greater than), "BT" (between), "!BT" (not between), "CT" (contains), "IN" (in), "!IN" (not in). Note: The following special characters are not supported in the value: curly brackets "{}", vertical bar "|", semicolon ";", quotation mark ", and angle brackets "<" and ">". |
*Account, language, currency, etc. included in the system. The listed accounts or other values are examples and they may differ from the values you have in use.