One level Up / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «Payroll»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица paTimeTransBatch — Headers of time transactions

Таблица: paTimeTransBatch — «Headers of time transactions». Маска имени таблицы: «paTimeTransBatch%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
BatchFileName NVARCHAR VSTRING 255 0 255 Name of a batch file with time transactions Name of a batch file with time transactions      
BatchID INT INTEGER 0 0 4 Batch identifier Batch identifier   1 Да
BatchStatus INT INTEGER 0 0 4 Batch Status Batch Status 0 – Created, 1 — Submitted, 2 — Partially Accepted, 3 — Fully Accepted,
4 — Not Updateable
   
Comment NVARCHAR VSTRING 1024 0 1024 Some comment Some comment      
CreatedDate DATETIME DATE 0 0 8 Date when batch was created Date when batch was created      
LastStatusDate DATETIME DATE 0 0 8 Date when BatchStatus field was changed Date when BatchStatus field was changed      
OriginalFileName NVARCHAR VSTRING 255 0 255 Original file name provided by the External Time Attendance System Original file name provided by the External Time Attendance System      
Owner NVARCHAR VSTRING 255 0 255 Owner of the batch Owner of the batch      
RefID NVARCHAR VSTRING 255 0 255 ID of the batch in External Time Attendance System ID of the batch in External Time Attendance System      
Spare1 NVARCHAR VSTRING 255 0 255 Reserved for future use Reserved for future use      
Spare2 NVARCHAR VSTRING 255 0 255 Reserved for future use Reserved for future use      

Навигация: