| Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
|---|---|---|---|---|---|---|---|---|---|
| INR | Unique INR of Excel file | Text | 8 | 1 | Edit | Yes | Public | ||
| FILENAME | Excel Filename | Text | 60 | 1 | Edit | Yes | Public | ||
| PURPOSE | Excel Purpose | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
| TARGET | Target | Text | 40 | 1 | Edit | Yes | Public | <fixed-length> | |
| SMHINR | INR of connected SMH | Text | 8 | 1 | Edit | Yes | Public | ||
| DOCMAC | MAC | Text | 8 | 1 | Edit | Yes | Public | ||
| DATTIM | Excel file timestamp | Datetime | 12 | 0 | Unknown | Yes | Public |
| Name | Fields | Properties |
|---|---|---|
| XLH_IDX | INR | Unique |
| XLH_PURPOSE | PURPOSE, TARGET |
/
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 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.
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.
Filename of the Excel to be mapped
Codetable showing the purpose of the Excel to be imported.
| Code | Text |
|---|---|
| F | Fee calculation |
For example fee type.
Unique internal ID to link this table with table for Structured Message Header (SMH ).
This field might either be empty if no protecting MAC has been created or it has to contain the MAC of the created message/document.
Date and Time when the Excel file was imported.