Please enable JavaScript to view this site.

thankQ Help

These tables contain the data to be imported. These will be a series of tables that map to the tables in thankQ. The mapping can be one to one, or one Import table could map to two or more live tables. In general the import tables are designed to be as close to the thankQ tables as possible.

Examples:

•IMPORT_PRODUCT maps to PRODUCT.

•IMPORT_CONTACTS maps to CONTACT and CONTACTATTRIBUTE depending on the columns imported.

•IMPORT_PAYMENTS maps to OBJECT, BATCHHEADER, BATCHITEM, BATCHITEMPLEDGE, BATCHITEMSPLIT, and BATCHITEMRELATIONSHIP depending on the columns imported.

Each table will have the columns that correspond to those in thankQ, in addition each of these tables will always have the following extra columns:

Column Name

Type

Comments

ID

BIGINT

An autogenerated ID for each record.

IMPORTID

VARCHAR(50)

The Import this record belongs to.

CONFIGURATIONID

VARCHAR(50)

The configuration ID used by the import.

IMPORTSTATUS

VARCHAR(50)

Status of this record.

ARCHIVERECORD

VARCHAR(5)

Optional (only on specific tables). Signals thankQ to Archive the record.

DELETERECORD

VARCHAR(5)

Optional (only on specific tables). Signals thankQ to Delete the record.