IMPEXPREC table

 

IMPEXPREC – This table stores the recovery operations for import transactions in the Track-IT pro database. When an import operation is performed, it is stored in this table, as well as the SQL command to undo the import performed.

Ÿ      ID – The unique ID for the Import Recovery record. (PK)

Ÿ      DATE – The date the import/export was performed.

Ÿ      ACTION – “Import” for an import operation, “Export” for an export operation.

Ÿ      RECOVER – The recovery SQL command to undo the operation.

Ÿ      COUNT – How many records were affected by the import/export.