пользователям программных продуктов Scala 5.1, iScala 2.1, iScala 2.2, iScala 2.3, iScala 3.0, iScala 3.1, iScala 3.2, iScala 3.3 (и так далее)
На один уровень выше / One level Up: Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Заработная плата» / List of tables of module «Payroll»

Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Таблица / Table PA04 — Employees

Таблица / Table: PA04 — «PA04 Employees». Маска имени таблицы / Table name mask: «PA04%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PA04001 NCHAR STRING 6 0 6 EmployeeCode Employee Code   1 Да / Yes
PA04002 NVARCHAR VSTRING 15 0 15 SocSecuritNo Social Security Number      
PA04003 NVARCHAR VSTRING 25 0 25 Name Name      
PA04004 NVARCHAR VSTRING 25 0 25 Address1 Address Line 1      
PA04005 NVARCHAR VSTRING 25 0 25 Address2 Address Line 2      
PA04006 NVARCHAR VSTRING 25 0 25 Address3 Address Line 3      
PA04007 NVARCHAR VSTRING 15 0 15 TelephoneNo Telephone Number      
PA04008 NCHAR STRING 2 0 2 CommunCode1 Country Code      
PA04009 NCHAR STRING 2 0 2 CommunCode2 Community Code 2      
PA04010 NCHAR STRING 2 0 2 CommunCode3 Estate Code      
PA04011 DATETIME DATE 0 0 8 EmploymDay Day of Employment      
PA04012 DATETIME DATE 0 0 8 DayOfLeaving Day of Leaving      
PA04013 NCHAR SWITCH 1 0 1 Sex Sex 1 — Male

2 — Female
   
PA04014 NCHAR STRING 1 0 1 StatCodes1 Statistic Code 1      
PA04015 NCHAR STRING 1 0 1 StatCodes2 Statistic Code 2      
PA04016 NCHAR STRING 1 0 1 StatCodes3 Statistic Code 3      
PA04017 NCHAR STRING 1 0 1 StatCodes4 Statistic Code 4      
PA04018 NCHAR STRING 1 0 1 StatCodes5 Statistic Code 5      
PA04019 NCHAR STRING 1 0 1 StatCodes6 Statistic Code 6      
PA04020 NCHAR STRING 3 0 3 Spare (obsolete)      
PA04021 NCHAR STRING 5 0 5 LabAgreeArea Contact Area      
PA04022 NCHAR STRING 1 0 1 PaymentPeriod Payment Basis      
PA04023 NCHAR STRING 1 0 1 WayOfPayment Payment Method 1 — Cash payment

2 — Postal giro

3 — Bank automatic payment
   
PA04024 NVARCHAR VSTRING 15 0 15 BankAccountNo Bank Account Number      
PA04025 NCHAR STRING 1 0 1 PersonalCategory Personnel Category      
PA04026 NCHAR STRING 2 0 2 UnionNo Union Code      
PA04027 NCHAR STRING 4 0 4 ProfessiCode Profession Code      
PA04028 NCHAR STRING 4 0 4 EducatioCode Education Code      
PA04029 NCHAR STRING 5 0 5 Category Category      
PA04030 NCHAR STRING 5 0 5 Department Department      
PA04031 NCHAR STRING 1 0 1 FormerCostCentre (obsolete)      
PA04032 NCHAR STRING 1 0 1 FormerProduct (obsolete)      
PA04033 NCHAR STRING 1 0 1 FormerProject (obsolete)      
PA04034 NCHAR STRING 1 0 1 ExtraTaxCharge Deduct Remaining Tax      
PA04035 NCHAR STRING 8 0 8 ExtraTax Limitation Tax YTD      
PA04036 NCHAR STRING 8 0 8 PaidExtraTax Limitation Tax Date      
PA04037 NCHAR STRING 2 0 2 TaxCalcModel Tax Calculation Method      
PA04038 NCHAR STRING 4 0 4 TableNo Tax Table      
PA04039 NCHAR STRING 1 0 1 ColumnNo Tax Table Column      
PA04040 NCHAR STRING 4 0 4 Percent Percent Reduction      
PA04041 NCHAR STRING 8 0 8 Amount Amount Reduction      
PA04042 NCHAR STRING 8 0 8 ExistenceMinimum Subsistence Minimum      
PA04043 NCHAR STRING 1 0 1 VacatCalcModel Vacation Calculation Model      
PA04044 NCHAR STRING 3 0 3 VacaDayYear Vacation Days per Year      
PA04045 NVARCHAR VSTRING 25 0 25 TaxformText1 Tax Form Text Line 1      
PA04046 NVARCHAR VSTRING 25 0 25 TaxformText2 Tax Form Text Line 2      
PA04047 NVARCHAR VSTRING 25 0 25 TaxformText3 Tax Form Text Line 3      
PA04048 NVARCHAR VSTRING 25 0 25 TaxformText4 Tax Form Text Line 4      
PA04049 NVARCHAR VSTRING 20 0 20 UsrDefField8 User Defined Parameter 8      
PA04050 NVARCHAR VSTRING 20 0 20 UsrDefField9 User Defined Parameter 9      
PA04051 NVARCHAR VSTRING 20 0 20 UrDefField10 User Defined Parameter 10      
PA04052 NVARCHAR VSTRING 20 0 20 UsrDefField1 User Defined Parameter 1      
PA04053 NVARCHAR VSTRING 20 0 20 UsrDefField2 User Defined Parameter 2      
PA04054 NVARCHAR VSTRING 20 0 20 UsrDefField3 User Defined Parameter 3      
PA04055 NVARCHAR VSTRING 20 0 20 UsrDefField4 User Defined Parameter 4      
PA04056 NVARCHAR VSTRING 20 0 20 UsrDefField5 User Defined Parameter 5      
PA04057 NVARCHAR VSTRING 20 0 20 UsrDefField6 User Defined Parameter 6      
PA04058 NVARCHAR VSTRING 20 0 20 UsrDefField7 User Defined Parameter 7      
PA04059 NVARCHAR VSTRING 25 0 25 RemarkLine1 Remark Line 1      
PA04060 NVARCHAR VSTRING 25 0 25 RemarkLine2 Remark Line 2      
PA04061 DATETIME DATE 0 0 8 LastUpdDate Date Updated      
PA04062 NVARCHAR VSTRING 25 0 25 NameSrchKey Search Name      
PA04063 NCHAR SWITCH 1 0 1 PayrollTax1 Calculate Social Tax 1      
PA04064 NCHAR SWITCH 1 0 1 PayrollTax2 Calculate Social Tax 2      
PA04065 NCHAR SWITCH 1 0 1 PayrollTax3 Calculate Social Tax 3      
PA04066 NCHAR SWITCH 1 0 1 PayrollTax4 Calculate Social Tax 4      
PA04067 NCHAR SWITCH 1 0 1 PayrollTax5 Calculate Social Tax 5      
PA04068 NVARCHAR VSTRING 50 0 50 AccStringGL Accounting String      
PA04069 NCHAR STRING 5 0 5 WrkPlaceNo Work Place Number      
PA04070 NCHAR STRING 4 0 4 VacationCategory Vacation Code      
PA04071 NCHAR STRING 4 0 4 WorkSchedule Work Calendar      
PA04072 NCHAR STRING 8 0 8 DateOfBirth Date of Birth      
PA04073 NCHAR SWITCH 1 0 1 PayrollTax6 Calculate Social Tax 6      
PA04074 NCHAR SWITCH 1 0 1 PayrollTax7 Calculate Social Tax 7      
PA04075 NCHAR SWITCH 1 0 1 PayrollTax8 Calculate Social Tax 8      
PA04076 NCHAR SWITCH 1 0 1 PayrollTax9 Calculate Social Tax 9      
PA04077 NCHAR SWITCH 1 0 1 PayrollTax10 Calculate Social Tax 10      
PA04078 NCHAR SWITCH 1 0 1 IsEmplResigned Has Resigned      
PA04079 NVARCHAR VSTRING 32 0 32 Spare (obsolete)      
PA04080 INT INTEGER 0 0 1 IBANactivation IBAN Activation      

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