Provides the default settings for import jobs.
Touchstone 2022 Database Reference
tImportDefault Table
| Creation Date | 4/4/2022 3:02 AM |
| File Group | PRIMARY |
| Text File Group | PRIMARY |
| System Object |  |
| Published for Replication | |
| Rows | 8 |
| Data Space Used | 88.00 KB |
| Index Space Used | 48.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | ImportDefaultSID | Unique system-generated sequential identifier for the import default record. | int | 4 | |||
| BusinessUnitSID | Unique system-generated sequential identifier for the business unit associated with the defaults. | int | 4 | ||||
| ImportMappingSetSID | Unique system-generated sequential identifier for the mapping set record using during import. For a complete list of records, see tImportMappingSet Table. | int | 4 |  | |||
| Value | XML string that defines the default values set for the different import fields, such as Currency and Construction Code. | xml | 0 | | |||
| EnteredDate | Date and time when ImportDefault row was entered. | date | 8 | (getutcdate()) | |||
| EditedDate | Date and time when ImportDefault row was last modified | date | 8 | (getutcdate()) | |||
| Signature | System-generated sequential code for the import record. | nvarchar | 16 | | |||
| SignatureHash | System-generated code that represents the signature. For example: 0x37E1ABBA78E9A22E6DE6CBC47F573729. | varbinary | 8000 | | (hashbytes('MD5',[Signature])) |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tImportMappingSet | Table | Stores mappings between fields in input files and columns in target databases for import jobs. | 1 |