Export table
The export table is the main table in the.mdb file and includes the core fields in a database. The export table must contain one or more records, and each table row represents a case document and its core metadata.
New documents imported into a case must have a level_1 value. A level is a way of grouping or organizing documents in folders or directories, much as they are organized on a computer. All other level field values are optional.
The following table describes the core fields in the export table.
| Type |
Size |
Mandatory |
Description |
|
| main_id |
Number |
|
No |
Unique ID for each document in the case assigned by the application. |
| Document_ID |
Text |
255 |
Yes |
A unique ID for each document in the case. IDs can include numbers and alphabetic characters, but not Unicode characters. |
| Host_Reference |
Text |
255 |
No |
If the document has a parent document, this field contains the parent document ID. This relates to the source/attachment option. |
| Document_Date |
Date |
12 |
No |
A document’s main date field. The default date format is dd-mmm-yyyy. Note: You can specify other date formats. |
| Estimated |
Boolean |
3 |
No |
Yes, for an estimated document date; otherwise, No or blank. If a scanned paper document has an unclear date on it, the user can estimate the date based on available information. |
| Document_Type |
Text |
255 |
No |
The document type, for example, letter or minutes. This is separate from the native file type. If a Document_Type value does not exist when importing documents into a case, the application adds it to the case’s defined document types. The best practice is to establish a predefined list of standard types with meaningful names. |
| Title |
Text |
255 |
No |
The title of the document. Note: The title can include Unicode characters. |
| level_1 through level_10 |
Text |
20 |
No |
Fields that you can use to organize source documents, control user access to documents, or set a hierarchy for document organization. Level names cannot include the following: Unicode characters The following special characters: Angle brackets (< >) Slashes ( / ) Colons ( : ) Asterisks ( * ) Question marks ( ? ) Pipes ( | ) Backslashes ( \ ) Quotation marks ( " ) A dot ( . ) as the last character Note: New documents imported into a case must have a level_1 value. You do not need level information when updating metadata for existing documents. |
| Description |
Memo |
|
No |
This text appears as the document description. |