One level Up / 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 PA4B — Employee Templates

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

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
PA4B001 NCHAR STRING 6 0 6 EmployeeCode Employee Code   1 Да / Yes
PA4B002 NVARCHAR VSTRING 15 0 15 SocialSecuNo Social Security Number      
PA4B003 NVARCHAR VSTRING 25 0 25 Name Name      
PA4B004 NVARCHAR VSTRING 25 0 25 Address1 Address Line 1      
PA4B005 NVARCHAR VSTRING 25 0 25 Address2 Address Line 2      
PA4B006 NVARCHAR VSTRING 25 0 25 Address3 Address Line 3      
PA4B007 NVARCHAR VSTRING 15 0 15 TelephoneNo Telephone Number      
PA4B008 NCHAR STRING 2 0 2 CommuniCode1 Country Code      
PA4B009 NCHAR STRING 2 0 2 CommuniCode2 Community Code 2      
PA4B010 NCHAR STRING 2 0 2 CommuniCode3 Estate Code      
PA4B011 DATETIME DATE 0 0 8 DayOfEmployment Day of Employment      
PA4B012 DATETIME DATE 0 0 8 DayOfLeaving Day of Leaving      
PA4B013 NCHAR SWITCH 1 0 1 Sex Sex 1 — Male

2 — Female
   
PA4B014 NCHAR STRING 1 0 1 StatistCode1 Statistic Code 1      
PA4B015 NCHAR STRING 1 0 1 StatistCode2 Statistic Code 2      
PA4B016 NCHAR STRING 1 0 1 StatistCode3 Statistic Code 3      
PA4B017 NCHAR STRING 1 0 1 StatistCode4 Statistic Code 4      
PA4B018 NCHAR STRING 1 0 1 StatistCode5 Statistic Code 5      
PA4B019 NCHAR STRING 1 0 1 StatistCode6 Statistic Code 6      
PA4B020 NCHAR STRING 3 0 3 Spare (obsolete)      
PA4B021 NCHAR STRING 5 0 5 LabourAgreementArea Contact Area      
PA4B022 NCHAR STRING 1 0 1 PaymentPeriod Payment Basis      
PA4B023 NCHAR STRING 1 0 1 WayOfPayment Payment Method 1 — Cash payment

2 — Postal giro

3 — Bank automatic payment
   
PA4B024 NVARCHAR VSTRING 15 0 15 BankAccounNo Bank Account Number      
PA4B025 NCHAR STRING 1 0 1 PersonalCategory Personnel Category      
PA4B026 NCHAR STRING 2 0 2 UnionNo Union Code      
PA4B027 NCHAR STRING 4 0 4 ProfessiCode Profession Code      
PA4B028 NCHAR STRING 4 0 4 EducatioCode Education Code      
PA4B029 NCHAR STRING 5 0 5 Category Category      
PA4B030 NCHAR STRING 5 0 5 Department Department      
PA4B031 NCHAR STRING 1 0 1 FormerCostCentre (obsolete)      
PA4B032 NCHAR STRING 1 0 1 FormerProduct (obsolete)      
PA4B033 NCHAR STRING 1 0 1 FormerProject (obsolete)      
PA4B034 NCHAR STRING 1 0 1 ExtraTaxChrg Deduct Remaining Tax      
PA4B035 NCHAR STRING 8 0 8 ExtraTax Limitation Tax YTD      
PA4B036 NCHAR STRING 8 0 8 PaidExtraTax Limitation Tax Date      
PA4B037 NCHAR STRING 2 0 2 TaxCalcModel Tax Calculation Method      
PA4B038 NCHAR STRING 4 0 4 TableNo Tax Table      
PA4B039 NCHAR STRING 1 0 1 ColumnNo Tax Table Column      
PA4B040 NCHAR STRING 4 0 4 Percent Percent Reduction      
PA4B041 NCHAR STRING 8 0 8 Amount Amount Reduction      
PA4B042 NCHAR STRING 8 0 8 ExistenceMinimum Subsistence Minimum      
PA4B043 NCHAR STRING 1 0 1 VacatCalcModel Vacation Calculation Model      
PA4B044 NCHAR STRING 3 0 3 VacaDayYear Vacation Days per Year      
PA4B045 NVARCHAR VSTRING 25 0 25 TaxformText1 Tax Form Text Line 1      
PA4B046 NVARCHAR VSTRING 25 0 25 TaxformText2 Tax Form Text Line 2      
PA4B047 NVARCHAR VSTRING 25 0 25 TaxformText3 Tax Form Text Line 3      
PA4B048 NVARCHAR VSTRING 25 0 25 TaxformText4 Tax Form Text Line 4      
PA4B049 NVARCHAR VSTRING 20 0 20 UserDefFld8 User Defined Parameter 8      
PA4B050 NVARCHAR VSTRING 20 0 20 UserDefFld9 User Defined Parameter 9      
PA4B051 NVARCHAR VSTRING 20 0 20 UserDefFld10 User Defined Parameter 10      
PA4B052 NVARCHAR VSTRING 20 0 20 UserDefFld1 User Defined Parameter 1      
PA4B053 NVARCHAR VSTRING 20 0 20 UserDefFld2 User Defined Parameter 2      
PA4B054 NVARCHAR VSTRING 20 0 20 UserDefFld3 User Defined Parameter 3      
PA4B055 NVARCHAR VSTRING 20 0 20 UserDefFld4 User Defined Parameter 4      
PA4B056 NVARCHAR VSTRING 20 0 20 UserDefFld5 User Defined Parameter 5      
PA4B057 NVARCHAR VSTRING 20 0 20 UserDefFld6 User Defined Parameter 6      
PA4B058 NVARCHAR VSTRING 20 0 20 UserDefFld7 User Defined Parameter 7      
PA4B059 NVARCHAR VSTRING 25 0 25 RemarkLine1 Remark Line 1      
PA4B060 NVARCHAR VSTRING 25 0 25 RemarkLine2 Remark Line 2      
PA4B061 DATETIME DATE 0 0 8 LastUpdDate Date Updated      
PA4B062 NVARCHAR VSTRING 25 0 25 NameSrchKey Search Name      
PA4B063 NCHAR SWITCH 1 0 1 PayrollTax1 Calculate Social Tax 1      
PA4B064 NCHAR SWITCH 1 0 1 PayrollTax2 Calculate Social Tax 2      
PA4B065 NCHAR SWITCH 1 0 1 PayrollTax3 Calculate Social Tax 3      
PA4B066 NCHAR SWITCH 1 0 1 PayrollTax4 Calculate Social Tax 4      
PA4B067 NCHAR SWITCH 1 0 1 PayrollTax5 Calculate Social Tax 5      
PA4B068 NVARCHAR VSTRING 50 0 50 AccStringGL Accounting String      
PA4B069 NCHAR STRING 5 0 5 WrkPlaceNo Work Place Number      
PA4B070 NCHAR STRING 4 0 4 VacationCategory Vacation Code      
PA4B071 NCHAR STRING 4 0 4 WorkSchedule Work Calendar      
PA4B072 NCHAR STRING 8 0 8 DateOfBirth Date of Birth      
PA4B073 NCHAR SWITCH 1 0 1 PayrollTax6 Calculate Social Tax 6      
PA4B074 NCHAR SWITCH 1 0 1 PayrollTax7 Calculate Social Tax 7      
PA4B075 NCHAR SWITCH 1 0 1 PayrollTax8 Calculate Social Tax 8      
PA4B076 NCHAR SWITCH 1 0 1 PayrollTax9 Calculate Social Tax 9      
PA4B077 NCHAR SWITCH 1 0 1 PayrollTax10 Calculate Social Tax 10      
PA4B078 NCHAR SWITCH 1 0 1 IsEmplResigned Has Resigned      
PA4B079 NVARCHAR VSTRING 30 0 30 Spare (obsolete)      
PA4B080 INT INTEGER 0 0 1 IBANactivation IBAN Activation      

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