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 PA23 — Previous Employees

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PA23001 NCHAR STRING 6 0 6 EmployeeCode Employee Code   1 Да / Yes
PA23002 NVARCHAR VSTRING 15 0 15 SocSecuritNo Social Security Number      
PA23003 NVARCHAR VSTRING 25 0 25 Name Name      
PA23004 NVARCHAR VSTRING 25 0 25 Address1 Address Line 1      
PA23005 NVARCHAR VSTRING 25 0 25 Address2 Address Line 2      
PA23006 NVARCHAR VSTRING 25 0 25 Address3 Address Line 3      
PA23007 NVARCHAR VSTRING 15 0 15 TelephoneNo Telephone Number      
PA23008 NCHAR STRING 2 0 2 CommunCode1 Country Code      
PA23009 NCHAR STRING 2 0 2 CommunCode2 Community Code 2      
PA23010 NCHAR STRING 2 0 2 CommunCode3 Estate Code      
PA23011 DATETIME DATE 0 0 8 DayOfEmployment Day of Employment      
PA23012 DATETIME DATE 0 0 8 DayOfLeaving Day of Leaving      
PA23013 NCHAR SWITCH 1 0 1 Sex Sex 1 — Male

2 — Female
   
PA23014 NCHAR STRING 1 0 1 StatistCode1 Statistic Code 1      
PA23015 NCHAR STRING 1 0 1 StatistCode2 Statistic Code 2      
PA23016 NCHAR STRING 1 0 1 StatistCode3 Statistic Code 3      
PA23017 NCHAR STRING 1 0 1 StatistCode4 Statistic Code 4      
PA23018 NCHAR STRING 1 0 1 StatistCode5 Statistic Code 5      
PA23019 NCHAR STRING 1 0 1 StatistCode6 Statistic Code 6      
PA23020 NCHAR STRING 3 0 3 Spare (obsolete)      
PA23021 NCHAR STRING 5 0 5 LabourAgreementArea Contact Area      
PA23022 NCHAR STRING 1 0 1 PaymentPeriod Payment Basis      
PA23023 NCHAR STRING 1 0 1 WayOfPayment Payment Method 1 — Cash payment

2 — Postal giro

3 — Bank automatic payment
   
PA23024 NVARCHAR VSTRING 15 0 15 BankAccNo Bank Account Number      
PA23025 NCHAR STRING 1 0 1 PersonalCategory Personnel Category      
PA23026 NCHAR STRING 2 0 2 UnionNo Union Code      
PA23027 NCHAR STRING 4 0 4 ProfessiCode Profession Code      
PA23028 NCHAR STRING 4 0 4 EducationCode Education Code      
PA23029 NCHAR STRING 5 0 5 Category Category      
PA23030 NCHAR STRING 5 0 5 Department Department      
PA23031 NCHAR STRING 1 0 1 FormerCostCentre (obsolete)      
PA23032 NCHAR STRING 1 0 1 FormerProduct (obsolete)      
PA23033 NCHAR STRING 1 0 1 FormerProject (obsolete)      
PA23034 NCHAR STRING 1 0 1 ExtraTaxCharge Deduct Remaining Tax      
PA23035 NCHAR STRING 8 0 8 ExtraTax Limitation Tax YTD      
PA23036 NCHAR STRING 8 0 8 PaidExtraTax Limitation Tax Date      
PA23037 NCHAR STRING 2 0 2 TaxCalcModel Tax Calculation Method      
PA23038 NCHAR STRING 4 0 4 TableNo Tax Table      
PA23039 NCHAR STRING 1 0 1 ColumnNo Tax Table Column      
PA23040 NCHAR STRING 4 0 4 Percent Percent Reduction      
PA23041 NCHAR STRING 8 0 8 Amount Amount Reduction      
PA23042 NCHAR STRING 8 0 8 ExistenceMinimum Subsistence Minimum      
PA23043 NCHAR STRING 1 0 1 VacationCalcModel Vacation Calculation Model      
PA23044 NCHAR STRING 3 0 3 VacationDaysPerYear Vacation Days per Year      
PA23045 NVARCHAR VSTRING 25 0 25 TaxformText1 Tax Form Text Line 1      
PA23046 NVARCHAR VSTRING 25 0 25 TaxformText2 Tax Form Text Line 2      
PA23047 NVARCHAR VSTRING 25 0 25 TaxformText3 Tax Form Text Line 3      
PA23048 NVARCHAR VSTRING 25 0 25 TaxformText4 Tax Form Text Line 4      
PA23049 NVARCHAR VSTRING 20 0 20 UserDefField8 User Defined Parameter 8      
PA23050 NVARCHAR VSTRING 20 0 20 UserDefField9 User Defined Parameter 9      
PA23051 NVARCHAR VSTRING 20 0 20 UserDefField10 User Defined Parameter 10      
PA23052 NVARCHAR VSTRING 20 0 20 UserDefField1 User Defined Parameter 1      
PA23053 NVARCHAR VSTRING 20 0 20 UserDefField2 User Defined Parameter 2      
PA23054 NVARCHAR VSTRING 20 0 20 UserDefField3 User Defined Parameter 3      
PA23055 NVARCHAR VSTRING 20 0 20 UserDefField4 User Defined Parameter 4      
PA23056 NVARCHAR VSTRING 20 0 20 UserDefField5 User Defined Parameter 5      
PA23057 NVARCHAR VSTRING 20 0 20 UserDefField6 User Defined Parameter 6      
PA23058 NVARCHAR VSTRING 20 0 20 UserDefField7 User Defined Parameter 7      
PA23059 NVARCHAR VSTRING 25 0 25 RemarkLine1 Remark Line 1      
PA23060 NVARCHAR VSTRING 25 0 25 RemarkLine2 Remark Line 2      
PA23061 DATETIME DATE 0 0 8 LastUpdDate Date Updated      
PA23062 NVARCHAR VSTRING 25 0 25 NameSrchKey Search Name      
PA23063 NCHAR SWITCH 1 0 1 PayrollTax1 Calculate Social Tax 1      
PA23064 NCHAR SWITCH 1 0 1 PayrollTax2 Calculate Social Tax 2      
PA23065 NCHAR SWITCH 1 0 1 PayrollTax3 Calculate Social Tax 3      
PA23066 NCHAR SWITCH 1 0 1 PayrollTax4 Calculate Social Tax 4      
PA23067 NCHAR SWITCH 1 0 1 PayrollTax5 Calculate Social Tax 5      
PA23068 NVARCHAR ACCSTR 120 0 120 AccStringGL Accounting String      
PA23069 NCHAR STRING 5 0 5 WrkPlaceNo Work Place Number      
PA23070 NCHAR STRING 4 0 4 VacationCategory Vacation Code      
PA23071 NCHAR STRING 4 0 4 WorkSchedule Work Calendar      
PA23072 NCHAR STRING 8 0 8 DateOfBirth Date of Birth      
PA23073 NCHAR SWITCH 1 0 1 PayrollTax6 Calculate Social Tax 6      
PA23074 NCHAR SWITCH 1 0 1 PayrollTax7 Calculate Social Tax 7      
PA23075 NCHAR SWITCH 1 0 1 PayrollTax8 Calculate Social Tax 8      
PA23076 NCHAR SWITCH 1 0 1 PayrollTax9 Calculate Social Tax 9      
PA23077 NCHAR SWITCH 1 0 1 PayrollTax10 Calculate Social Tax 10      
PA23078 NCHAR SWITCH 1 0 1 IsEmplResigned Has Resigned      
PA23079 NVARCHAR VSTRING 30 0 30 Spare (obsolete)      

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