Таблица | Table: paTimeTransBatch - «WebPa headers of time transactions». Маска имени таблицы | Table Name Mask: «paTimeTransBatch%cc00»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
Field Field Type iScala Field Type Field Length Pre­cision 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        
BatchID INT INTEGER 0 0 4 Batch identifier     1 Да / Yes
BatchStatus INT INTEGER 0 0 4 Batch Status   0 – Created, 1 - Submitted, 2 - Partially Accepted, 3 - Fully Accepted,
4 - Not Updateable
   
Comment NVARCHAR VSTRING 1024 0 1024 Some comment        
CreatedDate DATETIME DATE 0 0 8 Date when batch was created        
LastStatusDate DATETIME DATE 0 0 8 Date when BatchStatus field was changed        
OriginalFileName NVARCHAR VSTRING 255 0 255 Original file name provided by the External Time Attendance System        
Owner NVARCHAR VSTRING 255 0 255 Owner of the batch        
RefID NVARCHAR VSTRING 255 0 255 ID of the batch in External Time Attendance System        
Spare1 NVARCHAR VSTRING 255 0 255 Reserved for future use        
Spare2 NVARCHAR VSTRING 255 0 255 Reserved for future use        

Навигация / Shortcut: Структура БД iScala / iScala DB structure | Epicor iScala 2.3 SR3 - 2.03.12787 | Payroll | WebPa headers of time transactions