Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: PA23 - «Prev.Employees» («Предыдущие Сотр.»)
| Поле | Тип поля Scala | Длина Scala | Комментарий | Первичный ключ? |
| PA23001 | STRING | 6 | EmployeeCode | Да |
| PA23002 | VSTRING | 15 | SocSecuritNo | |
| PA23003 | VSTRING | 25 | Name | |
| PA23004 | VSTRING | 25 | Address1 | |
| PA23005 | VSTRING | 25 | Address2 | |
| PA23006 | VSTRING | 25 | Address3 | |
| PA23007 | VSTRING | 15 | TelephoneNo | |
| PA23008 | STRING | 2 | CommunCode1 | |
| PA23009 | STRING | 2 | CommunCode2 | |
| PA23010 | STRING | 2 | CommunCode3 | |
| PA23011 | DATE | 8 | DayOfEmployment | |
| PA23012 | DATE | 8 | DayOfLeaving | |
| PA23013 | SWITCH | 1 | Sex | |
| PA23014 | STRING | 1 | StatistCode1 | |
| PA23015 | STRING | 1 | StatistCode2 | |
| PA23016 | STRING | 1 | StatistCode3 | |
| PA23017 | STRING | 1 | StatistCode4 | |
| PA23018 | STRING | 1 | StatistCode5 | |
| PA23019 | STRING | 1 | StatistCode6 | |
| PA23020 | STRING | 3 | Spare | |
| PA23021 | STRING | 5 | LabourAgreementArea | |
| PA23022 | STRING | 1 | PaymentPeriod | |
| PA23023 | STRING | 1 | WayOfPayment | |
| PA23024 | VSTRING | 15 | BankAccNo | |
| PA23025 | STRING | 1 | PersonalCategory | |
| PA23026 | STRING | 2 | UnionNo | |
| PA23027 | STRING | 4 | ProfessiCode | |
| PA23028 | STRING | 4 | EducationCode | |
| PA23029 | STRING | 5 | Category | |
| PA23030 | STRING | 5 | Department | |
| PA23031 | STRING | 1 | FormerCostCentre | |
| PA23032 | STRING | 1 | FormerProduct | |
| PA23033 | STRING | 1 | FormerProject | |
| PA23034 | STRING | 1 | ExtraTaxCharge | |
| PA23035 | STRING | 8 | ExtraTax | |
| PA23036 | STRING | 8 | PaidExtraTax | |
| PA23037 | STRING | 2 | TaxCalcModel | |
| PA23038 | STRING | 4 | TableNo | |
| PA23039 | STRING | 1 | ColumnNo | |
| PA23040 | STRING | 4 | Percent | |
| PA23041 | STRING | 8 | Amount | |
| PA23042 | STRING | 8 | ExistenceMinimum | |
| PA23043 | STRING | 1 | VacationCalcModel | |
| PA23044 | STRING | 3 | VacationDaysPerYear | |
| PA23045 | VSTRING | 25 | TaxformText1 | |
| PA23046 | VSTRING | 25 | TaxformText2 | |
| PA23047 | VSTRING | 25 | TaxformText3 | |
| PA23048 | VSTRING | 25 | TaxformText4 | |
| PA23049 | VSTRING | 20 | UserDefField8 | |
| PA23050 | VSTRING | 20 | UserDefField9 | |
| PA23051 | VSTRING | 20 | UserDefField10 | |
| PA23052 | VSTRING | 20 | UserDefField1 | |
| PA23053 | VSTRING | 20 | UserDefField2 | |
| PA23054 | VSTRING | 20 | UserDefField3 | |
| PA23055 | VSTRING | 20 | UserDefField4 | |
| PA23056 | VSTRING | 20 | UserDefField5 | |
| PA23057 | VSTRING | 20 | UserDefField6 | |
| PA23058 | VSTRING | 20 | UserDefField7 | |
| PA23059 | VSTRING | 25 | RemarkLine1 | |
| PA23060 | VSTRING | 25 | RemarkLine2 | |
| PA23061 | DATE | 8 | LastUpdDate | |
| PA23062 | VSTRING | 25 | NameSrchKey | |
| PA23063 | SWITCH | 1 | PayrollTax1 | |
| PA23064 | SWITCH | 1 | PayrollTax2 | |
| PA23065 | SWITCH | 1 | PayrollTax3 | |
| PA23066 | SWITCH | 1 | PayrollTax4 | |
| PA23067 | SWITCH | 1 | PayrollTax5 | |
| PA23068 | VSTRING | 50 | AccStringGL | |
| PA23069 | STRING | 5 | WrkPlaceNo | |
| PA23070 | STRING | 4 | VacationCategory | |
| PA23071 | STRING | 4 | WorkSchedule | |
| PA23072 | STRING | 8 | DateOfBirth | |
| PA23073 | SWITCH | 1 | PayrollTax6 | |
| PA23074 | SWITCH | 1 | PayrollTax7 | |
| PA23075 | SWITCH | 1 | PayrollTax8 | |
| PA23076 | SWITCH | 1 | PayrollTax9 | |
| PA23077 | SWITCH | 1 | PayrollTax10 | |
| PA23078 | SWITCH | 1 | IsEmplResigned | |
| PA23079 | VSTRING | 30 | Spare |
Навигация: Структура БД Scala/iScala | Scala 5.1 SR13 | Payroll (Зарплата Про) | Prev.Employees (Предыдущие Сотр.)
/* */