generated: 12.12.2016 18:34:51
by UC2010.accdb
AE Database 11.2 (Step 018)
| Name | Type | Len | Attributes | Description |
|---|---|---|---|---|
| TABLE_Name | Text | 10 | UC: Null=False | table name |
| TABLE_Name5 | Text | 5 | UC: Null=True | 5 digit table name |
| TABLE_Prefix | Text | 5 | UC: Null=True | prefix of the names (without _) |
| TABLE_Text | Text | 255 | UC: Null=True | description |
| TABLE_Lfd | Integer | 2 | UC: Null=True | sequence number for import |
| TABLE_UType | Text | 2 | UC: Null=True | update type of the table |
| TABLE_CheckFlg | Text | 1 | UC: Null=True | C=build checksum |
| TABLE_Check | Long Integer | 4 | UC: Null=True | checksum |
| TABLE_WhereIni | Text | 250 | UC: Null=True | WHERE clause for DB.Unload - INITIAL |
| TABLE_WhereDef | Text | 250 | UC: Null=True | WHERE clause for DB.Unload - DEFAULT |
| TABLE_Children | Memo | 0 | UC: Null=True L=1024 | child tables |
| TABLE_AvgLen | Long Integer | 4 | UC: Null=True | average length of the records |
| TABLE_IlmFlag | Text | 1 | UC: Null=True | Type of Table: S=Statistics(Partitioned), R=Reports(Partitioned), M=Misc(Partitioned), O=Object definition, E=Empty (data in these table is not necessary to start a server) |
| TABLE_IlmKey | Text | 20 | UC: Null=True | Field with Partition Key if available |
| TABLE_LoadAtomic | Integer | 2 | UC: Null=True | 1=Ensure that Initialdata in this table is deleted and loaded in a single transaction |
Indexes:
| Name | Fields |
|---|---|
| PK_TABLE | TABLE_Name |
| TABLE_IlmKey | TABLE_IlmKey |
Return to the Index File