Touchstone 4.0 Database Documentation
tImportDefault Table
Description
Provides the default setting information to be used for import.
Properties
Creation Date5/31/2016 9:46 AM
File GroupPRIMARY
Text File GroupPRIMARY
System Object
Published for Replication
Rows6
Data Space Used72.00 KB
Index Space Used40.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key ImportDefaultSID

Unique system-generated sequential identifier for the import default record.

Integer4   
 BusinessUnitSID

Unique system-generated sequential identifier for the business unit record.

Integer4   
 ImportMappingSetSID

Unique system-generated sequential identifier for the mapping set record using during import.

For a complete list of records, see tImportMappingSet Table.

Integer4  
 Value

XML string that defines the default values set for the different import fields, such as Currency and Construction Code.

Xml16  
 EnteredDateDate and time when ImportDefault row was entered.VarWChar10 
(getutcdate())
 
 EditedDateDate and time when ImportDefault row was last modifiedVarWChar10 
(getutcdate())
 
Objects that tImportDefault depends on
 Database ObjectObject TypeDescriptionDep Level
tImportMappingSet tabletImportMappingSetTableUsed during import, this table provides mapping between the fields in the source input file to the columns in the target database table.1
See Also

Related Objects

AIRUserSetting Database

 

 


AIR Client Confidential

© 2016. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.