One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Payroll»

Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Таблица / Table paTimeTransBatch — Headers of time transactions

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

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

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