MPE_XLMAP_INFO

The MPE_XLMAP_INFO table provides information about a particular XLMAP_ID

The information is optional (unless you wish to configure a non-default target table).

See also:

• Excel Uploads
• MPE_XLMAP_DATA
• MPE_XLMAP_RULES

Columns

• TX_FROM num: SCD2 open datetime
• 🔑 TX_TO num: SCD2 close datetime
• 🔑 XLMAP_ID char(32): A unique, UPPERCASE reference for the excel map.
• XLMAP_DESCRIPTION char(1000): Map Description
• XLMAP_TARGETLIBDS char(41): An alternative target table to which to upload the data. This MUST have the same structure as the MPE_XLMAP_DATA table. The table must also be configured in MPE_TABLES.