One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Список системных таблиц / System Tables

Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399 :: Таблица / Table ScaAttachments — ScaAttachments

Таблица / Table: ScaAttachments — «ScaAttachments». Маска имени таблицы / Table name mask: «ScaAttachments»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
AttachmentGroupID NCHAR STRING 38 0 38 AttachmentGroupID AttachmentGroupID      
AttachmentID NCHAR STRING 38 0 38 AttachmentID AttachmentID   1 Да / Yes
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      

Навигация / Navigation: