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

Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Таблица / Table paEmplCard — Employees (Advanced PA)

Таблица / Table: paEmplCard — «Employees (Advanced PA)». Маска имени таблицы / Table name mask: «paEmplCard%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 256 0 256 SocialId Social Identity Number      
PA04003 NVARCHAR VSTRING 256 0 256 ShortName ShortName      
PA04004 NVARCHAR VSTRING 256 0 256 Address1 Address Line 1      
PA04005 NVARCHAR VSTRING 256 0 256 Address2 Address Line 2      
PA04006 NVARCHAR VSTRING 256 0 256 Address3 Address Line 3      
PA04007 NVARCHAR VSTRING 256 0 256 TelephoneNo Telephone Number      
PA04008 NVARCHAR VSTRING 256 0 256 CommunityCode1 Community Code 1      
PA04009 NVARCHAR VSTRING 256 0 256 CommunityCode2 Community Code 2      
PA04010 NVARCHAR VSTRING 256 0 256 CommunityCode3 Community Code 3      
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 Gender Gender 1 — Male

2 — Female
   
PA04014 NVARCHAR VSTRING 256 0 256 StatisticalCode1 Statistical Code 1      
PA04015 NVARCHAR VSTRING 256 0 256 StatisticalCode2 Statistical Code 2      
PA04016 NVARCHAR VSTRING 256 0 256 StatisticalCode3 Statistical Code 3      
PA04017 NVARCHAR VSTRING 256 0 256 StatisticalCode4 Statistical Code 4      
PA04018 NVARCHAR VSTRING 256 0 256 StatisticalCode5 Statistical Code 5      
PA04019 NVARCHAR VSTRING 256 0 256 StatisticalCode6 Statistical Code 6      
PA04020 NCHAR STRING 3 0 3 LanguageCode Language code      
PA04021 NVARCHAR VSTRING 256 0 256 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 256 0 256 BankAccountNo Bank Account Number      
PA04025 NVARCHAR VSTRING 256 0 256 PersonalCategory Personnel Category      
PA04026 NVARCHAR VSTRING 256 0 256 UnionNo Union Code      
PA04027 NVARCHAR VSTRING 256 0 256 ProfessiCode Profession Code      
PA04028 NVARCHAR VSTRING 256 0 256 EducatioCode Education Code      
PA04029 NVARCHAR VSTRING 256 0 256 Category Category      
PA04030 NVARCHAR VSTRING 256 0 256 Department Department      
PA04031 NVARCHAR VSTRING 256 0 256 FormerCostCentre FormerCostCentre      
PA04032 NVARCHAR VSTRING 256 0 256 FormerProduct FormerProduct      
PA04033 NVARCHAR VSTRING 256 0 256 FormerProject FormerProject      
PA04034 NVARCHAR VSTRING 256 0 256 ExtraTaxCharge Deduct Remaining Tax      
PA04035 NVARCHAR VSTRING 256 0 256 ExtraTax Limitation Tax YTD      
PA04036 NVARCHAR VSTRING 256 0 256 PaidExtraTax Limitation Tax Date      
PA04037 NVARCHAR VSTRING 256 0 256 TaxCalcModel Tax Calculation Method      
PA04038 NVARCHAR VSTRING 256 0 256 TableNo Tax Table      
PA04039 NVARCHAR VSTRING 256 0 256 ColumnNo Tax Table Column      
PA04040 NVARCHAR VSTRING 256 0 256 Percent Percent Reduction      
PA04041 NVARCHAR VSTRING 256 0 256 Amount Amount Reduction      
PA04042 NVARCHAR VSTRING 256 0 256 ExistenceMinimum Subsistence Minimum      
PA04043 NVARCHAR VSTRING 256 0 256 VacatCalcModel Vacation Calculation Model      
PA04044 NVARCHAR VSTRING 256 0 256 VacaDayYear Vacation Days per Year      
PA04045 NVARCHAR VSTRING 256 0 256 LastName Last Name      
PA04046 NVARCHAR VSTRING 256 0 256 PatronimicName Patronimic Name      
PA04047 NVARCHAR VSTRING 256 0 256 FirstName First Name      
PA04048 NVARCHAR VSTRING 256 0 256 ForeignLangName Foreign Language Name      
PA04049 NVARCHAR VSTRING 256 0 256 UsrDefField8 User Defined Parameter 8      
PA04050 NVARCHAR VSTRING 256 0 256 UsrDefField9 User Defined Parameter 9      
PA04051 NVARCHAR VSTRING 256 0 256 UrDefField10 User Defined Parameter 10      
PA04052 NVARCHAR VSTRING 256 0 256 UsrDefField1 User Defined Parameter 1      
PA04053 NVARCHAR VSTRING 256 0 256 UsrDefField2 User Defined Parameter 2      
PA04054 NVARCHAR VSTRING 256 0 256 UsrDefField3 User Defined Parameter 3      
PA04055 NVARCHAR VSTRING 256 0 256 UsrDefField4 User Defined Parameter 4      
PA04056 NVARCHAR VSTRING 256 0 256 UsrDefField5 User Defined Parameter 5      
PA04057 NVARCHAR VSTRING 256 0 256 UsrDefField6 User Defined Parameter 6      
PA04058 NVARCHAR VSTRING 256 0 256 UsrDefField7 User Defined Parameter 7      
PA04059 NVARCHAR VSTRING 256 0 256 RemarkLine1 Remark Line 1      
PA04060 NVARCHAR VSTRING 256 0 256 RemarkLine2 Remark Line 2      
PA04061 DATETIME DATE 0 0 8 LastUpdDate Date Updated      
PA04062 NVARCHAR VSTRING 256 0 256 NameSrchKey Search Name      
PA04063 NVARCHAR VSTRING 256 0 256 PayrollTax1 Calculate Social Tax 1      
PA04064 NVARCHAR VSTRING 256 0 256 PayrollTax2 Calculate Social Tax 2      
PA04065 NVARCHAR VSTRING 256 0 256 PayrollTax3 Calculate Social Tax 3      
PA04066 NVARCHAR VSTRING 256 0 256 PayrollTax4 Calculate Social Tax 4      
PA04067 NVARCHAR VSTRING 256 0 256 PayrollTax5 Calculate Social Tax 5      
PA04068 NVARCHAR ACCSTR 120 0 120 AccStringGL Accounting String      
PA04069 NVARCHAR VSTRING 256 0 256 WrkPlaceNo Work Place Number      
PA04070 NVARCHAR VSTRING 256 0 256 VacationCategory Vacation Code      
PA04071 NCHAR STRING 4 0 4 WorkSchedule Work Calendar      
PA04072 NCHAR STRING 8 0 8 DateOfBirth Date of Birth      
PA04073 NVARCHAR VSTRING 256 0 256 PayrollTax6 Calculate Social Tax 6      
PA04074 NVARCHAR VSTRING 256 0 256 PayrollTax7 Calculate Social Tax 7      
PA04075 NVARCHAR VSTRING 256 0 256 PayrollTax8 Calculate Social Tax 8      
PA04076 NVARCHAR VSTRING 256 0 256 PayrollTax9 Calculate Social Tax 9      
PA04077 NVARCHAR VSTRING 256 0 256 PayrollTax10 Calculate Social Tax 10      
PA04078 NCHAR STRING 1 0 1 Status Status 0 — Active,

1 — Resigned,

2 — Anonymized
   
PA04079 NVARCHAR VSTRING 32 0 32 TreeNodeId Tree Node Identifier      
PA04080 INT INTEGER 0 0 1 IBANactivation IBAN Activation      

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