Metadata Tables
This document describes system audit tables in
IBM® Controller.
saoverview
This view presents an overview of logged activities, and points to the tables where you can find information about the logged events.
| Column Name | Description |
|---|---|
| systempart | The system function part |
| table_name | The name of the table where the actual row is collected from, e.g. saxbo (System Audit table for xbo, companies) |
| controlleruser | The name of the Controller user that made the change |
| dbuser | The database user account used |
| actiontype | The action performed: INSERT, DELETE or UPDATE |
| changedate | The date and time of the action |
| sequence_no | The unique id for the row in the table where the actual row is collected from, e.g. column saxbo_id in table saxbo |
| unique_columns | The primary key columns in the main table, e.g. column bol (company code) in table xbo |
| unique_value | The value for the primary key column above, e.g. company 1000 in column bol in table saxbo (or table xbo) |
saxacqamount
This table displays acquisition values. Values are stored per currency.
Note: There
is no specific standard report for the investment register. A summary
of activities in the investment register is available in the Browse Data report, the saoverview table.
| Column Name | Description |
|---|---|
| compowner | Owning company (parent) |
| compowned | Owned company (daughter) |
| konctyp | Consolidation type |
| datum | Date |
| linenumber | Line number |
| rnumber | Row number |
| vernr | Journal no |
| vkod | Currency |
| bokbelopp | Amount |
| currencyflag | Flag to decide if this is in parent currency etc |
saxacqcurr
This table displays the main currency for parent/daughter relationships for acquisition values.
Note: There is no specific
standard report for the investment register. A summary of activities
in the investment register is available in the Browse Data report, the saoverview table.
| Column Name | Description |
|---|---|
| compowner | Owning company (parent) |
| compowned | Owned company (daughter) |
| vkod | Currency |
saxacqdepr
This table displays depreciations of goodwill for acquisition values.
Note: There is no specific standard report
for the investment register. A summary of activities in the investment
register is available in the Browse Data report,
the saoverview table.
| Column Name | Description |
|---|---|
| compowner | Owning company (parent) |
| compowned | Owned company (daughter) |
| konctyp | Consolidation type |
| datum | Date |
| linenumber | Line number |
| rnumber | Row number |
| vernr | Journal number |
| vkod | Currency |
| flag | Flag, A for automatic, M for manual |
| deprdatum | Depreciation date |
| akt | Actuality |
| konto | Account for depreciation |
| deprbelopp | Amount |
saxacqmain
This is the main table for acquisition values.
Note: There is no specific standard report for the investment register.
A summary of activities in the investment register is available in
the Browse Data report, the saoverview table.
| Column Name | Description |
|---|---|
| compowner | Owning company (parent) |
| compowned | Owned company (daughter) |
| konctyp | Consolidation type |
| datum | Date |
| linenumber | Line number |
| rnumber | Row number |
| vernr | Journal number |
| konto | Account |
| dim1 | Dim1 |
| dim2 | Dim 2 |
| dim3 | Dim 3 |
| dim4 | Dim 4 |
| btyp | Journal type |
| bookcomp | Book to this company |
| avskrproc | Depreciation percentage |
| agproc | Owning percentage |
| rostproc | Voting percentage |
| antaktier | Number of shares |
| extaktier | Flag for external shares |
| nombelopp | Amount, (nominal) |
| markvbelopp | Amount (market value) |
| externalname | Name on external shares |
| linkdate | Linkdate |
saxbo
This table displays logged changes for company structures.
| Column Name | Description |
|---|---|
| saxbo_id | Identity number, unique id |
| systempart | The system function part |
| sourcename | The source in the Controller Client where the change was made |
| controlleruser | The name of the Controller user that made the change |
| dbuser | The database user account used |
| actiontype | The action performed: INSERT, DELETE or UPDATE |
| changedate | The date and time of the action |
| bol | Company code |
| sortord | Sortorder in popups |
| vkodlc | currency code for local currency |
| vkodtc | Not used in Controller |
| boltyp | company type |
| peboll | N/A |
| bjboll | N/A |
| transmet | method for currency translation |
| transvkd | method used except for this currency code |
| aktiv | active flag |
| soldper | sold by period |
| detmul | A=use base information=outer leaves in the company tree, D=use this group as a leave, M=do not consolidate this group as a subgroup |
saxbocon
This table displays logged changes for Consolidation types.
| Column Name | Description |
|---|---|
| saxbocon_id | Identity number, unique id |
| systempart | The system function part |
| sourcename | The source in the Controller Client where the change was made |
| controlleruser | The name of the Controller user that made the change |
| dbuser | The database user account used |
| actiontype | The action performed: INSERT, DELETE or UPDATE |
| changedate | The date and time of the action |
| konctyp | consolidation type |
| sortord | sortorder in popups |
| aktiv | active flag |
| actgen | N/A (always F) |
| konctypref | N/A |
| modbol | |
| koncern | N/A |
| pebol | N/A |
| bjbol | N/A |
| petop | N/A (always F) |
| peber | L=Legal consolidation type, M=management consolidation type |
| ismanual | T=manual consolidation structure otherwise F |
| peberic | L=if intercompany is legal otherwise M for management |
| peberip | L=if intercompany profit is legal otherwise M for management |
| isgrpjournalacq | N/A |
| isgrpjournalic | True if group journal for intercompany |
| isgrpjournalip | True if group journals for intercompany profit |
saxbostruc
This table displays logged changes for the Company structure table.
| Column Name | Description |
|---|---|
| saxbostruc_id | Identity number, unique id |
| systempart | The system function part |
| sourcename | The source in the Controller Client where the change was made |
| controlleruser | The name of the Controller user that made the change |
| dbuser | The database user account used |
| actiontype | The action performed: INSERT, DELETE or UPDATE |
| changedate | The date and time of the action |
| konctyp | Consolidation type code |
| metkonc | Consolidation method |
| koncern | company code for group |
| bol | company code connected to consolidation type/group |
| boltyp | company type |
| percown | owned % |
| percvote | vote % |
| modtyp | |
| percmin | minority % |
| metkman | T indicates manual set consolidation method |
| percoman | owned % (manual set) |
| percvman | votes % (manual set) |
| percmman | minority % (manual set) |
| frper | valid from YYYYMM (company connected from) |
| toper | valid to YYYYMM (company connected to) |
| percdown | % direct owned |
| perceq | % equity |
| percsplit | % split |
| percdman | manual flag (direct owned) |
| perceman | manual flag (direct owned) |
| percsman | manual flag (split) |
| unittype | S=Sub unit, L=Legal unit, N=others |
saxcecols
This table displays logged changes for Control tables, Automatic Journals, that control which columns in the xevent_r table that should be displayed and if the value should be mandatory or default.
| Column Name | Description |
|---|---|
| saxcecols_id | Identity number, unique id |
| systempart | The system function part |
| sourcename | The source in the Controller Client where the change was made |
| controlleruser | The name of the Controller user that made the change |
| dbuser | The database user account used |
| actiontype | The action performed: INSERT, DELETE or UPDATE |
| changedate | The date and time of the action |
| cevent | Event |
| rowcolumn | Column no |
| ccolumn | Column name in xevent_r |
| show | Show/don't show |
| defa | Default value |
| head_text | Column text |
| mandatory | Mandatory/Not mandatory |
| issystem | Flag for system events |
saxceevent
This table displays logged changes for the main table for events in Control tables, Automatic Journals.
| Column Name | Description |
|---|---|
| saxceevent_id | Identity number, unique id |
| systempart | The system function part |
| sourcename | The source in the Controller Client where the change was made |
| controlleruser | The name of the Controller user that made the change |
| dbuser | The database user account used |
| actiontype | The action performed: INSERT, DELETE or UPDATE |
| changedate | The date and time of the action |
| cevent | Event code |
| text | Text |
| destiny | Not used |
| condition | Condition |
| coeff | Coefficient (number) |
| idlevel | Level |
| etyp | Etyp |
| flag1 | Flag for enable/disable calculation of change in structure |
| category | Category (1-22, type of event) |
| active | Active/not active |
| flag2 | Enable/disable special calculation for movement accounts |
| issystem | Flag for system events |
saxceht02
This table displays logged changes for the control table for investment adjustments.
| Column Name | Description |
|---|---|
| saxceht02_id | Identity number, unique id |
| systempart | The system function part |
| sourcename | The source in the Controller Client where the change was made |
| controlleruser | The name of the Controller user that made the change |
| dbuser | The database user account used |
| actiontype | The action performed: INSERT, DELETE or UPDATE |
| changedate | The date and time of the action |
| period | Period, 01, 02 etc. |
| refperiod | Reference period |
saxceht03
This table displays logged changes for the Dutch event for Control tables, Automatic Journals.
| Column Name | Description |
|---|---|
| saxceht03_id | Identity number, unique id |
| systempart | The system function part |
| sourcename | The source in the Controller Client where the change was made |
| controlleruser | The name of the Controller user that made the change |
| dbuser | The database user account used |
| actiontype | The action performed: INSERT, DELETE or UPDATE |
| changedate | The date and time of the action |
| company | Company |
| method | Method used for consolidation when having negative equity, (1, 2, 3) |
saxcemeth
This table displays logged changes for event calculation methods for Control tables, Automatic Journals.
| Column Name | Description |
|---|---|
| saxcemeth_id | Identity number, unique id |
| systempart | The system function part |
| sourcename | The source in the Controller Client where the change was made |
| controlleruser | The name of the Controller user that made the change |
| dbuser | The database user account used |
| actiontype | The action performed: INSERT, DELETE or UPDATE |
| changedate | The date and time of the action |
| calc_code | Code |
| meth_desc | Text |
| amount_typ | Amount type |
| rate_typ | Rate type |
| issystem | Flag for system events |
saxcemsel
This table displays logged changes for event selection methods, lines, for Control tables, Automatic Journals and for E221.
| Column Name | Description |
|---|---|
| saxcemsel_id | Identity number, unique id |
| systempart | The system function part |
| sourcename | The source in the Controller Client where the change was made |
| controlleruser | The name of the Controller user that made the change |
| dbuser | The database user account used |
| actiontype | The action performed: INSERT, DELETE or UPDATE |
| changedate | The date and time of the action |
| msel | Code |
| metkonc | Consolidation method, (P, S, E etc.) |
| modtyp | Mother/Not mother |
| issystem | Flag for system events |
saxcereg_h
This table displays logged changes for event rules, headings, for Control tables, Automatic Journals.
| Column Name | Description |
|---|---|
| saxcereg_h_id | Identity number, unique id |
| systempart | The system function part |
| sourcename | The source in the Controller Client where the change was made |
| controlleruser | The name of the Controller user that made the change |
| dbuser | The database user account used |
| actiontype | The action performed: INSERT, DELETE or UPDATE |
| changedate | The date and time of the action |
| regel_id | Code |
| regel_desc | Text |
| issystem | Flag for system events |
saxceregel
This table displays logged changes for event rules, lines, for Control tables, Automatic Journals.
| Column Name | Description |
|---|---|
| saxceregel_id | Identity number, unique id |
| systempart | The system function part |
| sourcename | The source in the Controller Client where the change was made |
| controlleruser | The name of the Controller user that made the change |
| dbuser | The database user account used |
| actiontype | The action performed: INSERT, DELETE or UPDATE |
| changedate | The date and time of the action |
| regel_id | Code |
| metkonc | Consolidation method company (P, S, E etc) |
| modtyp | Mother/Not mother, company |
| metkonc_p | Consolidation method counterpart (P, S, E etc) |
| modtyp_p | Mother/Not mother, counterpart |
| calc_code | Calculation code (entry in xcemeth) |
| issystem | Flag for system events |
saxcesel_h
This table displays logged changes for event selection method, headings, for Control tables, Automatic Journals.
| Column Name | Description |
|---|---|
| saxcesel_id | Identity number, unique id |
| systempart | The system function part |
| sourcename | The source in the Controller Client where the change was made |
| controlleruser | The name of the Controller user that made the change |
| dbuser | The database user account used |
| actiontype | The action performed: INSERT, DELETE or UPDATE |
| changedate | The date and time of the action |
| msel_id | Code |
| msel_desc | Text |
| issystem | Flag for system events |
saxcetax
This table displays logged changes for events, tax-tables, for Control tables, Automatic Journals.
| Column Name | Description |
|---|---|
| saxcetax_id | Identity number, unique id |
| systempart | The system function part |
| sourcename | The source in the Controller Client where the change was made |
| controlleruser | The name of the Controller user that made the change |
| dbuser | The database user account used |
| actiontype | The action performed: INSERT, DELETE or UPDATE |
| changedate | The date and time of the action |
| konto | Account |
| taxrate | Tax-rate |
saxconsmethodpercent
This table displays logged changes for default percentages during generation of xkstruc, the company table.
| Column Name | Description |
|---|---|
| saxconsmethodpercent_id | Identity number, unique id |
| systempart | The system function part |
| sourcename | The source in the Controller Client where the change was made |
| controlleruser | The name of the Controller user that made the change |
| dbuser | The database user account used |
| actiontype | The action performed: INSERT, DELETE or UPDATE |
| changedate | The date and time of the action |
| consmeth | Consolidation method |
| frpct | From percent |
| topct | To percent |
saxevent_h
This table displays logged changes for control table headings for automatic journals.
| Column Name | Description |
|---|---|
| saxevent_h_id | Identity number, unique id |
| systempart | The system function part |
| sourcename | The source in the Controller Client where the change was made |
| controlleruser | The name of the Controller user that made the change |
| dbuser | The database user account used |
| actiontype | The action performed: INSERT, DELETE or UPDATE |
| changedate | The date and time of the action |
| cevent | Event code |
| vernr | Journal no |
| clover | Closing version |
| btyp | Journal type |
| dim1 | Dim1 |
| dim2 | Dim 2 |
| dim3 | Dim 3 |
| dim4 | Dim 4 |
| konto_offset | Offset account |
saxevent_r
This table displays logged changes for control table rows for automatic journals.
| Column Name | Description |
|---|---|
| saxevent_r_id | Identity number, unique id |
| systempart | The system function part |
| sourcename | The source in the Controller Client where the change was made |
| controlleruser | The name of the Controller user that made the change |
| dbuser | The database user account used |
| actiontype | The action performed: INSERT, DELETE or UPDATE |
| changedate | The date and time of the action |
| cevent | Event code |
| konto | Account (from) |
| konto2 | Account 2 (from) |
| tecken_ib | Sign OB (not used) |
| tecken_pf | Sign |
| konto_ib | Account OB (not used) |
| konto_pf | Account (to) |
| typ | |
| varde | |
| extra | |
| regel_id | Rule id (entry in xceregel) |
| gm_ind | Group/Minority (G/M) indicator, (percentage to use) |
| cc_ind | Post value on company or counterpart (blank, C) |
| msel | Selection method (entry in xcemsel) |
| dim1 | Dim1 |
| dim2 | |
| dim3 | |
| dim4 | |
| konto_cond | Condition account |
| tax | Flag if using tax rates |
| method | Flag for Dutch event |
| ftyp | Flag used in calculating currency translation diff in acquisitions |
| kontoa | |
| kontob | |
| kontoc | |
| kontod | |
| flag1 | |
| flag2 | |
| txt1 | |
| txt2 |
saxgrp
This table displays logged changes for group information in linked structures, rights.
| Column Name | Description |
|---|---|
| saxgrp_id | Identity number, unique id |
| systempart | The system function part |
| sourcename | The source in the Controller Client where the change was made |
| controlleruser | The name of the Controller user that made the change |
| dbuser | The database user account used |
| actiontype | The action performed: INSERT, DELETE or UPDATE |
| changedate | The date and time of the action |
| typ | Group Type |
| grupp | Group ID |
| losord | Password, encrypted |
| kod1 | |
| iamb | Reconcile before export T/F |
| iexport | No export of incorrect data T/F (inst.rights) |
| isecurity | Force security T/F (inst.rights) |
| istatus | Force status T/F (inst.rights) |
| ilock | Lock data at export T/F (inst.rights) |
saxgrpcon
This table displays logged changes for connections between groups in linked structures, rights.
| Column Name | Description |
|---|---|
| saxgrpcon_id | Identity number, unique id |
| systempart | The system function part |
| sourcename | The source in the Controller Client where the change was made |
| controlleruser | The name of the Controller user that made the change |
| dbuser | The database user account used |
| actiontype | The action performed: INSERT, DELETE or UPDATE |
| changedate | The date and time of the action |
| frgrptyp | From Group type |
| frgrupp | From Group ID |
| togrptyp | To Group type |
| togrupp | To Group ID |
| userrw | Read or Wright R/W |
saxifstyrd
This table displays logged changes for differences in control tables, intercompany balances.
| Column Name | Description |
|---|---|
| saxifstyrd_id | Identity number, unique id |
| systempart | The system function part |
| sourcename | The source in the Controller Client where the change was made |
| controlleruser | The name of the Controller user that made the change |
| dbuser | The database user account used |
| actiontype | The action performed: INSERT, DELETE or UPDATE |
| changedate | The date and time of the action |
| vernr | Journal number |
| difftype | Difference type (+,-,P,N) +/- = Positive/Negative diff, P/N = Positive/Negative currency translation diff. |
| chtype | Change type (O,Y,C) O=Opening Balance, Y=Closing Balance, C=This years difference |
| konto | Account for difference booking |
| dim1 | Dimensions to account above |
| dim2 | |
| dim3 | |
| dim4 |
saxifstyrh
This table displays logged changes for control table headers, intercompany balances.
| Column Name | Description |
|---|---|
| saxifstyrh_id | Identity number, unique id |
| systempart | The system function part |
| sourcename | The source in the Controller Client where the change was made |
| controlleruser | The name of the Controller user that made the change |
| dbuser | The database user account used |
| actiontype | The action performed: INSERT, DELETE or UPDATE |
| changedate | The date and time of the action |
| vernr | Journal Number |
| diffput | Post difference on... (0,1) 0 = Payables/Expenses, 1=Receivables/Income |
| active | Active (1,0) 1=Active |
| kontoof1 | Offset account |
| dim1 | Dimensions to offset account |
| dim2 | |
| dim3 | |
| dim4 | |
| clover | Closing version (empty, value) If value, calculations are only made on this closing version, else all. |
| btyp | Journal Type (empty,value) If value, put all eliminations on this B-type, else same as original. |
| btypdiff | Journal type for differences (empty, value) If value, put elimination differences on this B-type, else same as original |
| ccdim | Counter dimension (1,0) 1=Counter dimensions are used. |
| adjdim | Adjustment dimension (1,0) 1=Adjustment dimensions are used |
| onlmatch |
saxifstyrht
This table displays logged changes for control table header texts, intercompany balances.
| Column Name | Description |
|---|---|
| saxifstyrht_id | Identity number, unique id |
| systempart | The system function part |
| sourcename | The source in the Controller Client where the change was made |
| controlleruser | The name of the Controller user that made the change |
| dbuser | The database user account used |
| actiontype | The action performed: INSERT, DELETE or UPDATE |
| changedate | The date and time of the action |
| vernr | Journal number |
| localeid | Locale ID |
| vertext | Journal text |
saxifstyrr
This table displays logged changes for control table header rows, intercompany balances.
| Column Name | Description |
|---|---|
| saxifstyrr_id | Identity number, unique id |
| systempart | The system function part |
| sourcename | The source in the Controller Client where the change was made |
| controlleruser | The name of the Controller user that made the change |
| dbuser | The database user account used |
| actiontype | The action performed: INSERT, DELETE or UPDATE |
| changedate | The date and time of the action |
| vernr | Journal number |
| konto1 | From account |
| konto2 | To account |
| tecken | Sign (-1,1) |
| hv | Window position (H,L) H=Right window (Payables/Expenses), V=Left (Receivables/Income) |
| id_rule | Split rule (empty,E,1) Empty=Normal, E=External part, 1=100% |
| cc_ind | Counterpart indicator (empty,C) Empty=Normal, C=Counterpart |
saxipmain
This table displays logged changes for control table, intercompany profit.
| Column Name | Description |
|---|---|
| saxipmain_id | Identity number, unique id |
| systempart | The system function part |
| sourcename | The source in the Controller Client where the change was made |
| controlleruser | The name of the Controller user that made the change |
| dbuser | The database user account used |
| actiontype | The action performed: INSERT, DELETE or UPDATE |
| changedate | The date and time of the action |
| id | Journal number |
| activetab | If journal is active or not |
| marginuse | Margin used |
| adjmarginuse | Adjusted margin used |
| flag1 | Flag |
| flag2 | Flag |
| flag3 | Flag |
saxipstand
This table displays logged changes for control table, intercompany profit.
| Column Name | Description |
|---|---|
| saxipstand_id | Identity number, unique id |
| systempart | The system function part |
| sourcename | The source in the Controller Client where the change was made |
| controlleruser | The name of the Controller user that made the change |
| dbuser | The database user account used |
| actiontype | The action performed: INSERT, DELETE or UPDATE |
| changedate | The date and time of the action |
| tableno | Table |
| account | Account |
| company | Company |
| ccompany | Counter Company |
| dim1 | Dimension 1 |
| dim2 | Dimension 2 |
| dim3 | Dimension 3 |
| dim4 | Dimension 4 |
| margin | Margin |
| adjmargin | If adjustment margin is used or not |
saxipstandh
This table displays logged changes for control table, intercompany profit.
| Column Name | Description |
|---|---|
| saxipstandh_id | Identity number, unique id |
| systempart | The system function part |
| sourcename | The source in the Controller Client where the change was made |
| controlleruser | The name of the Controller user that made the change |
| dbuser | The database user account used |
| actiontype | The action performed: INSERT, DELETE or UPDATE |
| changedate | The date and time of the action |
| tableno | Table |
| dummy1 |
saxipstandht
This table displays logged changes for control table, intercompany profit.
| Column Name | Description |
|---|---|
| saxipstandht_id | Identity number, unique id |
| systempart | The system function part |
| sourcename | The source in the Controller Client where the change was made |
| controlleruser | The name of the Controller user that made the change |
| dbuser | The database user account used |
| actiontype | The action performed: INSERT, DELETE or UPDATE |
| changedate | The date and time of the action |
| tableno | Table |
| localeid | Locale ID |
| vertext | Verification text |
saxipstyrd
This table displays logged changes for control table, intercompany profit.
| Column Name | Description |
|---|---|
| saxipstyrd_id | Identity number, unique id |
| systempart | The system function part |
| sourcename | The source in the Controller Client where the change was made |
| controlleruser | The name of the Controller user that made the change |
| dbuser | The database user account used |
| actiontype | The action performed: INSERT, DELETE or UPDATE |
| changedate | The date and time of the action |
| vernr | Journal Number |
| bs | Buyer (B) or Seller (S) |
| chtype | Change type (O, Y, C) |
| sign | Sign |
| konto | Account |
| dim1 | Dimension 1 |
| dim2 | Dimension 2 |
| dim3 | Dimension 3 |
| dim4 | Dimension 4 |
saxipstyrh
This table displays logged changes for control table, intercompany profit.
| Column Name | Description |
|---|---|
| saxipstyrh_id | Identity number, unique id |
| systempart | The system function part |
| sourcename | The source in the Controller Client where the change was made |
| controlleruser | The name of the Controller user that made the change |
| dbuser | The database user account used |
| actiontype | The action performed: INSERT, DELETE or UPDATE |
| changedate | The date and time of the action |
| vernr | Journal Number |
| active | If journal is active or not |
| kontoof1 | Offset account |
| dim1 | Dimension 1 |
| dim2 | Dimension 2 |
| dim3 | Dimension 3 |
| dim4 | Dimension 4 |
| clover | Closing version |
| btyp | Journal type |
| ccdim | If Counter Dimension is used or not |
| adjdim | If Adjustment Dimension is used or not |
saxipstyrht
This table displays logged changes for control table, intercompany profit.
| Column Name | Description |
|---|---|
| saxipstyrht_id | Identity number, unique id |
| systempart | The system function part |
| sourcename | The source in the Controller Client where the change was made |
| controlleruser | The name of the Controller user that made the change |
| dbuser | The database user account used |
| actiontype | The action performed: INSERT, DELETE or UPDATE |
| changedate | The date and time of the action |
| vernr | Journal Number |
| localeid | Locale ID |
| vertext | Journal Name |
saxipstyrr
This table displays logged changes for control table, intercompany profit.
| Column Name | Description |
|---|---|
| saxipstyrr_id | Identity number, unique id |
| systempart | The system function part |
| sourcename | The source in the Controller Client where the change was made |
| controlleruser | The name of the Controller user that made the change |
| dbuser | The database user account used |
| actiontype | The action performed: INSERT, DELETE or UPDATE |
| changedate | The date and time of the action |
| vernr | Journal Number |
| konto_sales | Sales Account |
| konto_stock | Inventory Account |
saxkonfig
This table displays logged changes for the general configuration and personal defaults.
| Column Name | Description |
|---|---|
| saxkonfig_id | Identity number, unique id |
| systempart | The system function part |
| sourcename | The source in the Controller Client where the change was made |
| controlleruser | The name of the Controller user that made the change |
| dbuser | The database user account used |
| actiontype | The action performed: INSERT, DELETE or UPDATE |
| changedate | The date and time of the action |
| typ1 | Type of information C=General config, U=Personal defaults, V=version information, U=User group information |
| typ2 | Variable name |
| anvid | User name |
| vtyp | C=character value, F=boolean, L=numerical |
| konftxt | Value stored |
saxkonto
This table displays logged changes for account information in the account structure.
| Column Name | Description |
|---|---|
| saxkonto_id | Identity number, unique id |
| systempart | The system function part |
| sourcename | The source in the Controller Client where the change was made |
| controlleruser | The name of the Controller user that made the change |
| dbuser | The database user account used |
| actiontype | The action performed: INSERT, DELETE or UPDATE |
| changedate | The date and time of the action |
| konto | Account |
| niv1 | Dimension level 1, 0-6 |
| niv2 | Dimension level 2, 0-6 |
| niv3 | Dimension level 3, 0-6 |
| niv4 | Dimension level 4, 0-6 |
| tkntyp | Sign change from default, 1/-1 |
| radtyp | Type of Account |
| ndec | Number of decimals (for statistic accounts), 0-6 |
| konsol | Should amount for the account be consolidated, T/F |
| intercomp | Intercompany code, ' '/I/J/M/A |
| shares | Shares, ' '/I/E |
| comments | Can comments be stored on the account, and is it mandatory, T/F/M |
| tkn1 | Sign for summation 1, -1/1 |
| sum1 | Summation Account 1, xkonto.konto |
| tkn2 | Sign for summation 2 |
| sum2 | Summation Account 2 |
| tkn3 | Sign for summation 3 |
| sum3 | Summation Account 3 |
| ambtkn1 | +/-/I/J/K/L |
| ambkonto1 | Account, xkonto.konto |
| ambtkn2 | +/-/I/J/K/L |
| ambkonto2 | Account, xkonto.konto |
| odktkn | B/M/D/N/E/F/G/K/L/I/C/O/P/U/V/Z/X/A |
| odkonto | Account, xkonto.konto |
| omimtkn | B/M/D/N/E/F/G/K/L/I/C/O/P/U/V/Z/X/A |
| omkonto | Account, xkonto.konto |
| sumrad | Summation account, T/F |
| grp | N/A |
| sortord | Sort order, 0-...; |
| typ2 | Movement Account, ' '/T/C |
| interdim | Interdimension information, T/F |
| copyjou | Copy journals the alternative way, T/F |
| copyrev | Copy reversing journals the alternative way, T/F |
| iscalc | Is the account a calculation account, T/F |
saxkstruc
This table displays logged changes for generated company structures.
| Column Name | Description |
|---|---|
| saxkstruc_id | Identity number, unique id |
| systempart | The system function part |
| sourcename | The source in the Controller Client where the change was made |
| controlleruser | The name of the Controller user that made the change |
| dbuser | The database user account used |
| actiontype | The action performed: INSERT, DELETE or UPDATE |
| changedate | The date and time of the action |
| konctyp | Consolidation type |
| metkonc | Consolidation method |
| koncern | Group |
| bol | Company |
| boltyp | Company type |
| niva | Company level |
| percown | Percent owned |
| percvote | Percent votes |
| percmin | Percent minority |
| metkman | T if manual adjusted else F |
| percoman | T if manual adjusted else F |
| percvman | T if manual adjusted else F |
| percmman | T if manual adjusted else F |
| simple | F if cross owned |
| frper | Starting date |
| toper | Ending date |
| modtyp | T if parent else F |
| percdown | Percent direct owned |
| perceq | Percent indirect equity |
| percsplit | Percent indirect split |
| percdman | T if manual adjusted else F |
| perceman | T if manual adjusted else F |
| percsman | T if manual adjusted else F |
saxmedlem
This table displays logged changes for rights and linked structures for members in groups.
| Column Name | Description |
|---|---|
| saxmedlem_id | Identity number, unique id |
| systempart | The system function part |
| sourcename | The source in the Controller Client where the change was made |
| controlleruser | The name of the Controller user that made the change |
| dbuser | The database user account used |
| actiontype | The action performed: INSERT, DELETE or UPDATE |
| changedate | The date and time of the action |
| grptyp | Group type |
| grupp | Group ID |
| medlem | Member ID (e.g. Company, User, Form, Account...) |
| sortord | Sort order |
| kod1 | Read or Wright rights (R/W) |
saxmovem
This table displays logged changes for movement structures.
| Column Name | Description |
|---|---|
| saxmovem_id | Identity number, unique id |
| systempart | The system function part |
| sourcename | The source in the Controller Client where the change was made |
| controlleruser | The name of the Controller user that made the change |
| dbuser | The database user account used |
| actiontype | The action performed: INSERT, DELETE or UPDATE |
| changedate | The date and time of the action |
| konto | Account |
| niv1 | Dimension level 1, 0-6 |
| niv2 | Dimension level 2, 0-6 |
| niv3 | Dimension level 3, 0-6 |
| niv4 | Dimension level 4, 0-6 |
| tkntyp | Sign change from default, 1/-1 |
| radtyp | Type of Account |
| ndec | Number of decimals (for statistic accounts), 0-6 |
| konsol | Should amount for the account be consolidated, T/F |
| intercomp | Intercompany code, ' '/I/J/M/A |
| shares | Shares, ' '/I/E |
| comments | Can comments be stored on the account, and is it mandatory, T/F/M |
| tkn1 | Sign for summation 1, -1/1 |
| sum1 | Summation Account 1, xkonto.konto |
| tkn2 | Sign for summation 2 |
| sum2 | Summation Account 2 |
| tkn3 | Sign for summation 3 |
| sum3 | Summation Account 3 |
| ambtkn1 | +/-/I/J/K/L |
| ambkonto1 | Account, xkonto.konto |
| ambtkn2 | +/-/I/J/K/L |
| ambkonto2 | Account, xkonto.konto |
| odktkn | B/M/D/N/E/F/G/K/L/I/C/O/P/U/V/Z/X/A |
| odkonto | Account, xkonto.konto |
| omimtkn | B/M/D/N/E/F/G/K/L/I/C/O/P/U/V/Z/X/A |
| omkonto | Account, xkonto.konto |
| sumrad | Summation account, T/F |
| grp | N/A |
| sortord | Sort order, 0-...; |
| typ2 | Movement Account, ' '/T/C |
| interdim | Interdimension information, T/F |
| copyjou | Copy journals the alternative way, T/F |
| copyrev | Copy reversing journals the alternative way, T/F |
| iscalc | Is the account a calculation account, T/F |
SABDLOG
This table displays information about when Edit mode is enabled and disabled in the Browse Data function.
| Column Name | Description |
|---|---|
| sabdlog_id | Identity number, unique id |
| systempart | The system function part |
| sourcename | The source in the Controller Client where the change was made |
| controlleruser | The name of the Controller user that made the change |
| dbuser | The database user account used |
| actiontype | The action performed: ENABLE, DISABLE |
| changedate | The date and time of the action |
SATRGLOG
This table displays when the system audit log is enabled and disabled. Note that the functionality of the system audit log is designed to track user activities, but sometimes activities are initiated by the system, for example automatic operations impacting the areas included in the system audit log. As a result of that, the system audit log is disabled and enabled to exclude activities triggered by the system without any impact on user activities. These automatic enable/disable activities are included in the satrglog.
| Column Name | Description |
|---|---|
| satrglog_id | Identity number, unique id |
| trigger_name | Name of the trigger |
| trigger_status | The trigger status: Enabled or Disabled |
| trigger_text | Description |
| controlleruser | The name of the Controller user that made the change |
| dbuser | The database user account used |
| changedate | The date and time of the action |