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