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

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

Таблица / Table: paTransStat — «Transactions Statistics». Маска имени таблицы / Table name mask: «paTransStat%cc%yy»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
AccStr NVARCHAR ACCSTR 120 0 120 AccStr Accounting string      
AccStrBiLine NVARCHAR ACCSTR 120 0 120 AccStrBiLine Bi-line accounting string      
AccStrCurr NVARCHAR ACCSTR 120 0 120 AccStrCurr Accounting String (Line Currency)      
AllocLineNum TINYINT X_TINYINT 0 0 2 AllocLineNum Allocation line number      
AllocNum NVARCHAR VSTRING 3 0 3 AllocNum Allocation number      
Amount NUMERIC MONEY 28 8 20 Amount Amount      
AmountCurr NUMERIC MONEY 28 8 20 AmountCurr Amount (Line Currency)      
ArchiveId INT INTEGER 0 0 8 ArchiveId Archive identifier   1 Да / Yes
BiLineSwitch TINYINT X_TINYINT 0 0 1 BiLineSwitch Bi-line switch 0 — not bi-line

1 — bi-line

2 — reversal
   
CurrCode INT INTEGER 0 0 2 CurrCode Currency code      
DateEnt DATETIME DATE 0 0 8 DateEnt Date of entering      
DatePrn DATETIME DATE 0 0 8 DatePrn Date of printing      
DateUpd DATETIME DATE 0 0 8 DateUpd Date of update      
EmplCode NCHAR STRING 6 0 6 EmplCode Employee code   4 Да / Yes
GLRunCnt NVARCHAR VSTRING 9 0 9 GLRunCnt GL running counter reference Reference to GL transaction line    
JournalNo NUMERIC NUMBER 20 0 6 JournalNo Journal number      
LineFlag BIT X_BIT 0 0 1 LineFlag Line flag 0 — normal line

1 — statistics line
   
LineNum NCHAR STRING 7 0 7 LineNum Transaction line number   3 Да / Yes
LineSign TINYINT X_TINYINT 0 0 1 LineSign Line sign      
LineType TINYINT X_TINYINT 0 0 1 LineType Line type      
NumOfDec TINYINT X_TINYINT 0 0 1 NumOfDec Number of decimals      
PayrollNum INT INTEGER 0 0 4 PayrollNum Payroll number      
SrcLineNum NVARCHAR VSTRING 7 0 7 SrcLineNum Source line number      
TaxAmountType TINYINT X_TINYINT 0 0 1 TaxAmountType Tax amount type 0 — no

1 — tax base

2 — tax total
   
TaxId INT INTEGER 0 0 4 TaxId Tax identifier      
TaxType TINYINT X_TINYINT 0 0 1 TaxType Tax type 0 — no tax line

1 — social benefit line

2 — tax line
   
TransDate DATETIME DATE 0 0 8 TransDate Transaction date      
TransNum NCHAR STRING 9 0 9 TransNum Transaction number   2 Да / Yes
TransText NVARCHAR VSTRING 100 0 100 TransText Transaction text      
TransTextCurr NVARCHAR VSTRING 100 0 100 TransTextCurr Transaction text (Line Currency)      
UserEntBy NVARCHAR VSTRING 8 0 8 UserEntBy User entered by      
UserPrnBy NVARCHAR VSTRING 8 0 8 UserPrnBy User print by      
UserUpdBy NVARCHAR VSTRING 8 0 8 UserUpdBy User updated by      
WageCode NCHAR STRING 6 0 6 WageCode Wage code      

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