Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: PA4B - «Std.Employees» («Стд.сотрудники»)
| Поле | Тип поля Scala | Длина Scala | Комментарий | Первичный ключ? |
| PA4B001 | STRING | 6 | EmployeeCode | Да |
| PA4B002 | VSTRING | 15 | SocialSecuNo | |
| PA4B003 | VSTRING | 25 | Name | |
| PA4B004 | VSTRING | 25 | Address1 | |
| PA4B005 | VSTRING | 25 | Address2 | |
| PA4B006 | VSTRING | 25 | Address3 | |
| PA4B007 | VSTRING | 15 | TelephoneNo | |
| PA4B008 | STRING | 2 | CommuniCode1 | |
| PA4B009 | STRING | 2 | CommuniCode2 | |
| PA4B010 | STRING | 2 | CommuniCode3 | |
| PA4B011 | DATE | 8 | DayOfEmployment | |
| PA4B012 | DATE | 8 | DayOfLeaving | |
| PA4B013 | SWITCH | 1 | Sex | |
| PA4B014 | STRING | 1 | StatistCode1 | |
| PA4B015 | STRING | 1 | StatistCode2 | |
| PA4B016 | STRING | 1 | StatistCode3 | |
| PA4B017 | STRING | 1 | StatistCode4 | |
| PA4B018 | STRING | 1 | StatistCode5 | |
| PA4B019 | STRING | 1 | StatistCode6 | |
| PA4B020 | STRING | 3 | Spare | |
| PA4B021 | STRING | 5 | LabourAgreementArea | |
| PA4B022 | STRING | 1 | PaymentPeriod | |
| PA4B023 | STRING | 1 | WayOfPayment | |
| PA4B024 | VSTRING | 15 | BankAccounNo | |
| PA4B025 | STRING | 1 | PersonalCategory | |
| PA4B026 | STRING | 2 | UnionNo | |
| PA4B027 | STRING | 4 | ProfessiCode | |
| PA4B028 | STRING | 4 | EducatioCode | |
| PA4B029 | STRING | 5 | Category | |
| PA4B030 | STRING | 5 | Department | |
| PA4B031 | STRING | 1 | FormerCostCentre | |
| PA4B032 | STRING | 1 | FormerProduct | |
| PA4B033 | STRING | 1 | FormerProject | |
| PA4B034 | STRING | 1 | ExtraTaxChrg | |
| PA4B035 | STRING | 8 | ExtraTax | |
| PA4B036 | STRING | 8 | PaidExtraTax | |
| PA4B037 | STRING | 2 | TaxCalcModel | |
| PA4B038 | STRING | 4 | TableNo | |
| PA4B039 | STRING | 1 | ColumnNo | |
| PA4B040 | STRING | 4 | Percent | |
| PA4B041 | STRING | 8 | Amount | |
| PA4B042 | STRING | 8 | ExistenceMinimum | |
| PA4B043 | STRING | 1 | VacatCalcModel | |
| PA4B044 | STRING | 3 | VacaDayYear | |
| PA4B045 | VSTRING | 25 | TaxformText1 | |
| PA4B046 | VSTRING | 25 | TaxformText2 | |
| PA4B047 | VSTRING | 25 | TaxformText3 | |
| PA4B048 | VSTRING | 25 | TaxformText4 | |
| PA4B049 | VSTRING | 20 | UserDefFld8 | |
| PA4B050 | VSTRING | 20 | UserDefFld9 | |
| PA4B051 | VSTRING | 20 | UserDefFld10 | |
| PA4B052 | VSTRING | 20 | UserDefFld1 | |
| PA4B053 | VSTRING | 20 | UserDefFld2 | |
| PA4B054 | VSTRING | 20 | UserDefFld3 | |
| PA4B055 | VSTRING | 20 | UserDefFld4 | |
| PA4B056 | VSTRING | 20 | UserDefFld5 | |
| PA4B057 | VSTRING | 20 | UserDefFld6 | |
| PA4B058 | VSTRING | 20 | UserDefFld7 | |
| PA4B059 | VSTRING | 25 | RemarkLine1 | |
| PA4B060 | VSTRING | 25 | RemarkLine2 | |
| PA4B061 | DATE | 8 | LastUpdDate | |
| PA4B062 | VSTRING | 25 | NameSrchKey | |
| PA4B063 | SWITCH | 1 | PayrollTax1 | |
| PA4B064 | SWITCH | 1 | PayrollTax2 | |
| PA4B065 | SWITCH | 1 | PayrollTax3 | |
| PA4B066 | SWITCH | 1 | PayrollTax4 | |
| PA4B067 | SWITCH | 1 | PayrollTax5 | |
| PA4B068 | VSTRING | 50 | AccStringGL | |
| PA4B069 | STRING | 5 | WrkPlaceNo | |
| PA4B070 | STRING | 4 | VacationCategory | |
| PA4B071 | STRING | 4 | WorkSchedule | |
| PA4B072 | STRING | 8 | DateOfBirth | |
| PA4B073 | SWITCH | 1 | PayrollTax6 | |
| PA4B074 | SWITCH | 1 | PayrollTax7 | |
| PA4B075 | SWITCH | 1 | PayrollTax8 | |
| PA4B076 | SWITCH | 1 | PayrollTax9 | |
| PA4B077 | SWITCH | 1 | PayrollTax10 | |
| PA4B078 | SWITCH | 1 | IsEmplResigned | |
| PA4B079 | VSTRING | 30 | Spare |
Навигация: Структура БД Scala/iScala | Scala 5.1 SR13 | Payroll (Зарплата Про) | Std.Employees (Стд.сотрудники)
/* */