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

Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Таблица / Table ScaAuditChangeStepsCD — The table is used to track changes in tables attributed to ChangeSet steps

Таблица / Table: ScaAuditChangeStepsCD — «Company-dependent ChangeStep registry». Маска имени таблицы / Table name mask: «ScaAuditChangeSteps%cc»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
_ChangeSetGUID UNIQUEIDENTIFIER X_UNIQUEIDENTIFIER 0 0 36 ChangeSetGUID Change Set GUID GUID of the ChangeSet to which the step it attributed    
_DataRows BIGINT X_BIGINT 0 0 20 DataRows Number of Changed Rows Number of rows affected by the operation    
_ShortTableName NVARCHAR VSTRING 128 0 128 TableName Table Name Short name of the table in which changes occurred    
_SQLUser NVARCHAR VSTRING 256 0 256 SQLUser SQL User SQL connection user    
_StepStartTimeOffset DATETIMEOFFSET X_DATETIMEOFFSET 3 0 34 StepStartTimeOffset Step Start Date-Time with TimeZone Offset Step Start Date-Time with TimeZone Offset    
_StepStartUTCTime DATETIME2 X_DATETIME2 3 0 27 StepStartUTCTime Step start UTC Date-Time The date/time when the step began, in UTC    
_TableName NVARCHAR VSTRING 128 0 128 TableName Table Name Full name of the table in which changes occurred    
TempID BIGINT X_BIGINT 0 0 20 TempID Change Step Row ID Temporary identifier of the row 1 Да / Yes

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