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

Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Таблица / Table paTaxes — Taxes

Таблица / Table: paTaxes — «Taxes». Маска имени таблицы / Table name mask: «paTaxes%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?
ActivityFlag INT INTEGER 0 0 1 TaxActivityFlag Tax activity flag      
AddTableId NCHAR STRING 4 0 4 AddTableId Additional table identifier      
AddTableValueNum TINYINT X_TINYINT 0 0 2 AddTableValueNum Additional table value number      
CalcAmountType TINYINT X_TINYINT 0 0 1 CalcAmountType Type of calculation tax amount 0 — automatic,

1 — by percentage,

2 — by tax table,

3 — by additional table,

4 — by fixed amount
   
CalcRuleType INT INTEGER 0 0 1 TaxCalcRuleType Tax calculation rule type      
ClassifRecCode NCHAR STRING 25 0 25 TaxClassificationRecCode Tax classification record code      
Comments NVARCHAR(MAX) X_NVARCHAR_MAX 0 0 5000 TaxComments Tax comments      
CommentsAlt NVARCHAR(MAX) X_NVARCHAR_MAX 0 0 5000 TaxCommentsAlt Tax comments alternative      
CreditAccStr NVARCHAR ACCSTR 120 0 120 TaxCreditAccStrMask Tax credit accounting string mask      
DateUsageType TINYINT X_TINYINT 0 0 1 DateUsageType Type of usage wage dates 0 — end wage type date,

1 — start wage type date,

2 — payment date
   
DebitAccStr NVARCHAR ACCSTR 120 0 120 TaxDebitAccStrMask Tax debit accounting string mask      
EmplCatDictCode NCHAR STRING 3 0 3 EmplCatDictCode Employee dictionary of categories      
EmplHistCatCode NCHAR STRING 2 0 2 EmplHistCatCode Employee history category      
FixedAmount NUMERIC X_NUMERIC 28 8 20 FixedAmount Fixed amount      
Id INT INTEGER 0 0 10 TaxId Tax identifier   1 Да / Yes
LastUpdate DATETIME X_DATETIME 0 0 17 TaxLastUpdate Tax last update datetime      
Percentage NUMERIC X_NUMERIC 28 8 20 TaxPercentage Tax percentage      
ReasonDictCode NCHAR STRING 3 0 3 TaxReasonDictCode Tax reason dictionary code      
TaxTableId NCHAR STRING 4 0 4 TaxTableId Tax table identifier      

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