Export_extras table
The export_extras table contains additional or non-core metadata about a document, for example, custodian information.
The following table describes the fields in the export_extras table.
|
Field |
Type |
Size |
Mandatory |
Description |
|
Document_ID |
Text |
255 |
Yes |
A unique ID for each document in the case. This links the metadata in the record to the correct document. Note: When importing, this field is mandatory for any record in the table, but the table does not have to contain a record for each Document_ID. |
|
theCategory |
Text |
50 |
Yes |
A predefined four-character string that identifies the data type. This string must be one of the following: TEXT: Text NUMB: Number BOOL: Boolean DATE: Date PICK: Pick list field MEMO: Memo-type field |
|
theLabel |
Text |
255 |
Yes |
The name or label of the field in the case. When importing, if a field with the same name and data type does not already exist, the application adds that field to the case. |
|
theValue |
Text |
255 |
Either theValue or memoValue; must contain data, depending on theCategory value |
Use for the value for all extra fields, except MEMO fields. The actual field data is a text string, regardless of whether it is a date, a text field, or a Boolean character. The following applies to imports: PICK-type fields: When theCategory=PICK, the import process creates a pick list entry in the target database for each delimited item in theValue category. MEMO-type fields use the memoValue field (see the memoValue description that follows) instead of the theValue field. The default date format for exports is dd- mmm-yyyy. Note: You can specify other date formats for imports. We recommend that you use YES or NO for Boolean fields. |
|
memoValue |
Memo |
Maximum number of characters per field: 64,000 |
|
A longer text block for theCategory = MEMO field. Note: This field can include Unicode characters. |