One level Up / One level Up: Изменение полей в таблицах БД iScala 3.5 по сравнению с iScala 2.2 / Difference between DB structure of iScala 3.5 and iScala 2.2

Изменения структуры таблиц модуля «Зарплата» / Payroll tables structure changes

Только таблицы со стандартными именами (длиной 8 символов) / Only tables with standard names (8 characters long)

Название Таблицы / Table Name Описание Таблицы / Table Description Поле / Field Расширенный комментарий / Extended Comment Тип данных / Data Type Длина поля iScala 3.5/ iScala 3.5 Length Точность iScala 3.5/ iScala 3.5 Precision Длина поля iScala 2.2/ iScala 2.2 Length Точность iScala 2.2/ iScala 2.2 Precision Новое поле? / is a New Field?
PA03 PA03 Wage Types PA03002 Description NVARCHAR 256   25   —
PA03 PA03 Wage Types PA03003 Explanation NVARCHAR 256   25   —
PA03 PA03 Wage Types PA03007 Accounting String NVARCHAR 120   50   —
PA03 PA03 Wage Types PA03012 Question 1 — Label NVARCHAR 256   15   —
PA03 PA03 Wage Types PA03013 Question 2 — Label NVARCHAR 256   15   —
PA04 PA04 Employees PA04068 Accounting String NVARCHAR 120   50   —
PA05 PA05 Fixed W/Types PA05004 Accounting String NVARCHAR 120   50   —
PA06 PA06 Statistics PA06005 Accounting String NVARCHAR 120   50   —
PA07 PA07 Reported W/T PA07005 Accounting String NVARCHAR 120   50   —
PA09 PA09 Work Calcul. PA09005 Accounting String NVARCHAR 120   50   —
PA17 PA17 Payroll Trans PA17001 Record Counter NUMERIC 9   8   —
PA17 PA17 Payroll Trans PA17002 Transaction Number NCHAR 9   6   —
PA17 PA17 Payroll Trans PA17003 Line Number NCHAR 7   5   —
PA17 PA17 Payroll Trans PA17006 Accounting String NVARCHAR 120   50   —
PA17 PA17 Payroll Trans PA17009 Accounting String (Line Currency) NVARCHAR 120   50   —
PA17 PA17 Payroll Trans PA17011 Transaction Line Text NVARCHAR 100   25   —
PA17 PA17 Payroll Trans PA17013 Transaction Code 2 NVARCHAR 25   23   —
PA17 PA17 Payroll Trans PA17024 In Closing Period NCHAR 8   5   —
PA17 PA17 Payroll Trans PA17026 Unit Code INT 4   2   —
PA17 PA17 Payroll Trans PA17030 PL Reference NCHAR 9   6   —
PA17 PA17 Payroll Trans PA17037 Transaction Text (Line Currency) NVARCHAR 100   25   —
PA17 PA17 Payroll Trans PA17038 Accounting String Second NVARCHAR 120   50   —
PA17 PA17 Payroll Trans PA17039 Printed By NCHAR 8   — — +
PA17 PA17 Payroll Trans PA17040 Date Printed DATETIME 8   — — +
PA17 PA17 Payroll Trans PA17041 Tax type TINYINT 1   — — +
PA17 PA17 Payroll Trans PA17042 Tax identifier INT 4   — — +
PA17 PA17 Payroll Trans PA17043 Allocation number NVARCHAR 3   — — +
PA17 PA17 Payroll Trans PA17044 Allocation line number TINYINT 2   — — +
PA17 PA17 Payroll Trans PA17045 Source line number NVARCHAR 7   — — +
PA17 PA17 Payroll Trans PA17046 Tax amount type TINYINT 1   — — +
PA23 PA23 Prev.Employees PA23068 Accounting String NVARCHAR 120   50   —
PA33 PA33 Time Sheets PA33005 Accounting String NVARCHAR 120   50   —
PA35 PA35 Calcul.Models PA35104 Model type NCHAR 1   — — +
PA35 PA35 Calcul.Models PA35105 Detail persist schema NCHAR 1   — — +
PA35 PA35 Calcul.Models PA35106 A skip flag of employee card validation code N 24(custom calculation model) NCHAR 1   — — +
PA39 PA39 Dictionaries PA39008 Comment 1 NVARCHAR 256   25   —
PA39 PA39 Dictionaries PA39009 Comment 2 NVARCHAR 256   25   —
PA39 PA39 Dictionaries PA39010 Comment 3 NVARCHAR 256   25   —
PA39 PA39 Dictionaries PA39011 Comment 4 NVARCHAR 256   25   —
PA46 PA46 Emp.Rec.Chng. PA46004 Accounting String NVARCHAR 120   50   —
PA4B PA4B Std.Employees PA4B068 Accounting String NVARCHAR 120   50   —
PA60 PA60 Ts Details TransID Transaction identifier INT 4   — — +
PA60 PA60 Ts Details TsAccString Timesheet Accounting String NVARCHAR 120   50   —
PA60 PA60 Ts Details TsTimeType Timesheet Time Type NVARCHAR 4   3   —
PA60 PA60 Ts Details TsValue Timesheet Value NUMERIC 12 8 13   —
PA61 PA61 Ts Main AccString Accounting String NVARCHAR 120   50   —
PA75 PA75 Payroll History PerDataLEndDate Periodical accumulators data load end date DATETIME 8   — — +
PA75 PA75 Payroll History PerDataLStartDate Periodical data load start date DATETIME 8   — — +
PA76 PA76 Payroll Transaction FinYear Financial year INT 4   — — +
PA76 PA76 Payroll Transaction IsJointGLTransaction Is Joint GL Transaction BIT 1   — — +
PA76 PA76 Payroll Transaction TransactionIdGl Transaction Number General Ledger NCHAR 9   6   —
PA76 PA76 Payroll Transaction TransactionIdGlReversal Transaction Number General Ledger Reversal NCHAR 9   6   —
PA76 PA76 Payroll Transaction TransactionIdPa Transaction Number Payroll NCHAR 9   6   —
PA76 PA76 Payroll Transaction TransactionIdPaReversal Transaction Number Payroll Reversal NCHAR 9   6   —
PAL1 PAL1 Comp Report Main PAR1010 Report engine type INT 4   — — +
PAL1 PAL1 Comp Report Main PAR1011 Last Executed Time DATETIME 17   — — +
PAL1 PAL1 Comp Report Main PAR1012 Last Executed User NVARCHAR 256   — — +
PAL2 PAL2 Comp Report Details PAR2005 File Name NVARCHAR 300   150   —
PAL2 PAL2 Comp Report Details PAR2007 Data Sub Type NVARCHAR 300   3   —
PAL2 PAL2 Comp Report Details PAR2009 Sorting Term NVARCHAR 300   150   —
PAR1 PAR1 Report Main PAR1010 Report engine type INT 4   — — +
PAR1 PAR1 Report Main PAR1011 Last Executed Time DATETIME 17   — — +
PAR1 PAR1 Report Main PAR1012 Last Executed User NVARCHAR 256   — — +
PAR2 PAR2 Report Details PAR2005 File Name NVARCHAR 300   150   —
PAR2 PAR2 Report Details PAR2007 Data Sub Type NVARCHAR 300   3   —
PAR2 PAR2 Report Details PAR2009 Sorting Term NVARCHAR 300   150   —
PAR3 PAR3 Definition PAR3010 Reference to user assistance language resource NVARCHAR 150   — — +
PAR3 PAR3 Definition PAR3011 Field format INT 4   — — +
PAR3 PAR3 Definition PAR3012 Store Personal Identifier TINYINT 1   — — +
PAR3 PAR3 Definition PAR3013 Replacement Value NVARCHAR 256   — — +