CTG is the data table for the Category data.
| Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
|---|---|---|---|---|---|---|---|---|---|
| INR | Internal Unique ID of Category | Text | 8 | 1 | Edit | Yes | Public | ||
| EXTKEY | Key of Category | Text | 6 | 1 | Edit | Yes | Public | ||
| NAM | Name of Category | Text | 40 | 1 | Edit | Yes | Public | ||
| VER | Version Counter | Text | 4 | 1 | Edit | Yes | Public | ||
| BUSSTM | Business sectors | Stream | 1 | 0 | Source | Yes | Public | ||
| TRNCLA | Transaction Class | Text | 3 | 1 | 10 | Edit | Yes | Public | TRNCLS |
| TRNPAT | Transaction Pattern | Text | 6 | 1 | Edit | Yes | Public | ||
| TRNSTM | Transactions | Stream | 1 | 0 | Source | Yes | Public | ||
| ETGEXTKEY | Entity Group | Text | 8 | 1 | Edit | Yes | Public | ||
| GETFLDNRM | Field holding the normalized search fields | Text | 60 | 1 | Edit | Yes | Public |
| Name | Fields | Properties |
|---|---|---|
| CTG_EXTKEY | EXTKEY | |
| CTG_GETFLDNRM | GETFLDNRM | |
| CTG_INR | INR | Unique |
| CTG_NAM | NAM |
/
INR
Unique internal ID of a record within the table. The INR is a text field, which is created by retrieving the next valid entry from the counter CTG. The field INR is used to maintain links from other tables into this table.
Unique internal ID of a record within the table. The INR is a text field, which is created by retrieving the next valid entry from the counter of this table. The field INR is used to enable links from other tables to this table.
For contractdata the INR also links the two tables xxD and xxT as associated entries hold the same INR.
This field holds the version counter to keep track of the version history of a CTG entry. The individual versions are controlled by entries in the SLG table.
This field holds the version counter used to keep track of the history of an entry of this table. The individual versions are managed by entries in the SLG table.
This stream holds the list of business sectors for which this category is used.
This stream holds the list of business sectors for which this category is used.
This field holds the list of transactions for which this category is used. This list is defaulted by the entries in BUSSTM, TRNPAT and TRNCLA and can be manually reduced.
This field holds the list of transactions for which this category is used. This list is defaulted by the entries in fields business sector, transaction pattern and transactions and can be manually reduced.
This field can hold a pattern which reduces the list of available transactions. The pattern has to be defined with ?, e.g. ???AME will deliver all amendment trasnactions.
This field can hold a pattern which reduces the list of available transactions. The pattern has to be defined with ?, e.g. ???AME will deliver all amendment transactions.
This field can hold a transaction class as defined in DBIETP (transaction profile). The content is used to reduce the list of available transactions.
This field can hold a transaction class as defined in 'transaction profiles' (DBIETP). The content is used to reduce the list of available transactions.
This field holds the EXTKEY of the entity group which is the logical owner of this entry. This field is filled automatically during insert and is used as filter when accessing the database. Without special implementation only entries of the entity group of the currently active entity are visible to the user.
This field holds the external key of the owning entity group to identify the logical owner of this entry. This field is filled automatically during insert and is used as filter when accessing the database. Without special implementation only entries of the currently active entity group are visible to the user.
Field holding the concatenated and normalized sum of all search fields used by quick search. This is one of the fields set in a SdbSetNRMFields method defined in the table definition module.
Field holding the concatenated and normalized sum of all search fields used by quick search. This is one of the fields set in a SdbSetNRMFields method defined in the table definition module.
This field holds the external key to identify a Category.
This field holds the external key to identify a Category.
This is the visible name of a Category. This name is used in selection list and on panels to identify a Category.
This is the name of a Category. This name is used in selection list and on panels to identify a Category.