Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: PA04 - «Employees» («Сотрудники»)
| Поле | Тип поля Scala | Длина Scala | Комментарий | Первичный ключ? |
| PA04001 | STRING | 6 | EmployeeCode | Да |
| PA04002 | VSTRING | 15 | SocSecuritNo | |
| PA04003 | VSTRING | 25 | Name | |
| PA04004 | VSTRING | 25 | Address1 | |
| PA04005 | VSTRING | 25 | Address2 | |
| PA04006 | VSTRING | 25 | Address3 | |
| PA04007 | VSTRING | 15 | TelephoneNo | |
| PA04008 | STRING | 2 | CommunCode1 | |
| PA04009 | STRING | 2 | CommunCode2 | |
| PA04010 | STRING | 2 | CommunCode3 | |
| PA04011 | DATE | 8 | EmploymDay | |
| PA04012 | DATE | 8 | DayOfLeaving | |
| PA04013 | SWITCH | 1 | Sex | |
| PA04014 | STRING | 1 | StatCodes1 | |
| PA04015 | STRING | 1 | StatCodes2 | |
| PA04016 | STRING | 1 | StatCodes3 | |
| PA04017 | STRING | 1 | StatCodes4 | |
| PA04018 | STRING | 1 | StatCodes5 | |
| PA04019 | STRING | 1 | StatCodes6 | |
| PA04020 | STRING | 3 | Spare | |
| PA04021 | STRING | 5 | LabAgreeArea | |
| PA04022 | STRING | 1 | PaymentPeriod | |
| PA04023 | STRING | 1 | WayOfPayment | |
| PA04024 | VSTRING | 15 | BankAccountNo | |
| PA04025 | STRING | 1 | PersonalCategory | |
| PA04026 | STRING | 2 | UnionNo | |
| PA04027 | STRING | 4 | ProfessiCode | |
| PA04028 | STRING | 4 | EducatioCode | |
| PA04029 | STRING | 5 | Category | |
| PA04030 | STRING | 5 | Department | |
| PA04031 | STRING | 1 | FormerCostCentre | |
| PA04032 | STRING | 1 | FormerProduct | |
| PA04033 | STRING | 1 | FormerProject | |
| PA04034 | STRING | 1 | ExtraTaxCharge | |
| PA04035 | STRING | 8 | ExtraTax | |
| PA04036 | STRING | 8 | PaidExtraTax | |
| PA04037 | STRING | 2 | TaxCalcModel | |
| PA04038 | STRING | 4 | TableNo | |
| PA04039 | STRING | 1 | ColumnNo | |
| PA04040 | STRING | 4 | Percent | |
| PA04041 | STRING | 8 | Amount | |
| PA04042 | STRING | 8 | ExistenceMinimum | |
| PA04043 | STRING | 1 | VacatCalcModel | |
| PA04044 | STRING | 3 | VacaDayYear | |
| PA04045 | VSTRING | 25 | TaxformText1 | |
| PA04046 | VSTRING | 25 | TaxformText2 | |
| PA04047 | VSTRING | 25 | TaxformText3 | |
| PA04048 | VSTRING | 25 | TaxformText4 | |
| PA04049 | VSTRING | 20 | UsrDefField8 | |
| PA04050 | VSTRING | 20 | UsrDefField9 | |
| PA04051 | VSTRING | 20 | UrDefField10 | |
| PA04052 | VSTRING | 20 | UsrDefField1 | |
| PA04053 | VSTRING | 20 | UsrDefField2 | |
| PA04054 | VSTRING | 20 | UsrDefField3 | |
| PA04055 | VSTRING | 20 | UsrDefField4 | |
| PA04056 | VSTRING | 20 | UsrDefField5 | |
| PA04057 | VSTRING | 20 | UsrDefField6 | |
| PA04058 | VSTRING | 20 | UsrDefField7 | |
| PA04059 | VSTRING | 25 | RemarkLine1 | |
| PA04060 | VSTRING | 25 | RemarkLine2 | |
| PA04061 | DATE | 8 | LastUpdDate | |
| PA04062 | VSTRING | 25 | NameSrchKey | |
| PA04063 | SWITCH | 1 | PayrollTax1 | |
| PA04064 | SWITCH | 1 | PayrollTax2 | |
| PA04065 | SWITCH | 1 | PayrollTax3 | |
| PA04066 | SWITCH | 1 | PayrollTax4 | |
| PA04067 | SWITCH | 1 | PayrollTax5 | |
| PA04068 | VSTRING | 50 | AccStringGL | |
| PA04069 | STRING | 5 | WrkPlaceNo | |
| PA04070 | STRING | 4 | VacationCategory | |
| PA04071 | STRING | 4 | WorkSchedule | |
| PA04072 | STRING | 8 | DateOfBirth | |
| PA04073 | SWITCH | 1 | PayrollTax6 | |
| PA04074 | SWITCH | 1 | PayrollTax7 | |
| PA04075 | SWITCH | 1 | PayrollTax8 | |
| PA04076 | SWITCH | 1 | PayrollTax9 | |
| PA04077 | SWITCH | 1 | PayrollTax10 | |
| PA04078 | SWITCH | 1 | IsEmplResigned | |
| PA04079 | VSTRING | 30 | Spare |
Навигация: Структура БД Scala/iScala | Scala 5.1 SR13 | Payroll (Зарплата Про) | Employees (Сотрудники)
/* */