Diagrams


Table

Intermediate Data Import

Fields

# Name Type
1 ID (ID) Integer AutoIncrement: Yes
2 Data Exch. No. (Data Exch. No.) Integer NotBlank: Yes
3 Table ID (Table ID) Integer NotBlank: Yes
4 Record No. (Record No.) Integer
5 Field ID (Field ID) Integer
6 Value (Value) Text250
7 Validate Only (Validate Only) Boolean
8 Parent Record No. (Parent Record No.) Integer

Keys

# Fields
0 ID (ID)
1 Data Exch. No.,Table ID,Record No.,Field ID (Data Exch. No.,Table ID,Record No.,Field ID) Clustered: Yes
2 Data Exch. No.,Table ID,Field ID (Data Exch. No.,Table ID,Field ID)

Table Relations To Other Tables

Field Related Table Related Field
Table ID (Table ID) AllObjWithCaption Object ID (Object ID) 1..n
Data Exch. No. (Data Exch. No.) Data Exch. Entry No. (Entry No.) 1..n
Field ID (Field ID) Field No. (No.) 1..n

Table Relations From Other Tables

From Table From Field