Table of Contents

XLH - Header for Excel Mapping

Module XLH


Datafields

Name Helptext Description Data Type Len Codetable
INR Internal Unique ID Text 8
FILENAME Excel Filename Text 60
PURPOSE Excel Purpose Text 1 Embedded
TARGET Target Text 40 <fixed-length>
SMHINR INR of connected SMH Text 8
DOCMAC MAC Text 8
DATTIM Excel file timestamp Datetime 12

Datafield Description and Properties


Datafield INR Internal Unique ID

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.


Datafield PURPOSE Excel Purpose

Codetable
Code Text
F Fee calculation