Таблица: ScaAttachments - «ScaAttachments». Маска имени таблицы: «ScaAttachments»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
AttachmentGroupID | NCHAR | STRING | 38 | 0 | 38 | AttachmentGroupID | ||||
AttachmentID | NCHAR | STRING | 38 | 0 | 38 | AttachmentID | 1 | Да | ||
Code | NVARCHAR | VSTRING | 255 | 0 | 255 | Code | ||||
Comment | NTEXT | X_NTEXT | 0 | 0 | 0 | Comment | ||||
CompanyCode | NVARCHAR | VSTRING | 2 | 0 | 2 | CompanyCode | ||||
EditComputerName | NVARCHAR | VSTRING | 255 | 0 | 255 | This field contain information about the user computer, who opened the file for editing | ||||
EditFileName | NVARCHAR | VSTRING | 255 | 0 | 255 | This field contain information about the file, which opened for editing | ||||
EditUserName | NVARCHAR | VSTRING | 255 | 0 | 255 | this field contain information about the user, who opened the file for editing | ||||
FileData | IMAGE | X_IMAGE | 0 | 0 | 0 | This field contains binary data of attachment file | ||||
FileDataSize | INT | INTEGER | 0 | 0 | 10 | This field contains size of binary data in FileData | ||||
FileName | NVARCHAR | VSTRING | 255 | 0 | 255 | FileName | ||||
Year | INT | INTEGER | 0 | 0 | 4 | Year |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | System objects | ScaAttachments