CLAUSION.DREXTRADATA functions
'=DRExtraData(Datatype_Code;Doc_Serie;Account_No;Year;ExtraField_ID...)
Get account balance (debit: positive, credit: negative)
DRExtraData 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 2025, 2024, ... |
|
Extra Field ID |
ID |
Typically E01, 1, 2, ..., 12 |
|
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 dimension is 9 |
|
*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.