Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else... / Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще...
Таблица: HR01 - «Resource Master File» («Мастер-Файл ресурсов»)
| Поле | Тип поля Scala | Длина Scala | Комментарий | Первичный ключ? |
| HR01001 | VSTRING | 10 | ResourceID | Да |
| HR01002 | VSTRING | 35 | Name | |
| HR01003 | VSTRING | 35 | Address1 | |
| HR01004 | VSTRING | 35 | Address2 | |
| HR01005 | VSTRING | 35 | Address3 | |
| HR01006 | VSTRING | 35 | Address4 | |
| HR01007 | VSTRING | 20 | TelephoneNo | |
| HR01008 | VSTRING | 20 | MobileTeleNo | |
| HR01009 | VSTRING | 20 | TelefaxNo | |
| HR01010 | VSTRING | 15 | PagerNo | |
| HR01011 | VSTRING | 10 | CarRegNo1 | |
| HR01012 | VSTRING | 10 | CarRegNo2 | |
| HR01013 | VSTRING | 30 | Remark1 | |
| HR01014 | VSTRING | 30 | Remark2 | |
| HR01015 | VSTRING | 15 | Department | |
| HR01016 | VSTRING | 10 | ServiceGroup | |
| HR01017 | VSTRING | 4 | Category | |
| HR01018 | VSTRING | 3 | CertifCode1 | |
| HR01019 | VSTRING | 3 | CertifCode2 | |
| HR01020 | VSTRING | 3 | CertifCode3 | |
| HR01021 | VSTRING | 3 | CertifCode4 | |
| HR01022 | VSTRING | 3 | CertifCode5 | |
| HR01023 | VSTRING | 6 | CentreWarehNo | |
| HR01024 | VSTRING | 2 | PriceCode | |
| HR01025 | VSTRING | 1 | PayrollTrans | |
| HR01026 | VSTRING | 6 | PayrollCodeA | |
| HR01027 | VSTRING | 6 | PayrollCodeB | |
| HR01028 | VSTRING | 6 | PayrollCodeC | |
| HR01029 | VSTRING | 6 | PayrollCodeD | |
| HR01030 | VSTRING | 6 | PayrollCodeE | |
| HR01031 | VSTRING | 6 | PayrollCodeF | |
| HR01032 | MONEY | 20 | HourlyCostA | |
| HR01033 | MONEY | 20 | HourlyCostB | |
| HR01034 | MONEY | 20 | HourlyCostC | |
| HR01035 | MONEY | 20 | HourlyCostD | |
| HR01036 | MONEY | 20 | HourlyCostE | |
| HR01037 | MONEY | 20 | HourlyCostF | |
| HR01038 | X_NUMERIC | 12 | AvailHrsMon | |
| HR01039 | X_NUMERIC | 12 | AvailHrsTue | |
| HR01040 | X_NUMERIC | 12 | AvailHrsWed | |
| HR01041 | X_NUMERIC | 12 | AvailHrsThu | |
| HR01042 | X_NUMERIC | 12 | AvailHrsFri | |
| HR01043 | X_NUMERIC | 12 | AvailHrsSat | |
| HR01044 | X_NUMERIC | 12 | AvailHrsSun | |
| HR01045 | DATE | 8 | NonOpPerFrD1 | |
| HR01046 | DATE | 8 | NonOpPerToD1 | |
| HR01047 | DATE | 8 | NonOpPerFrD2 | |
| HR01048 | DATE | 8 | NonOpPerToD2 | |
| HR01049 | DATE | 8 | NonOpPerFrD3 | |
| HR01050 | DATE | 8 | NonOpPerToD3 | |
| HR01051 | DATE | 8 | NonOpPerFrD4 | |
| HR01052 | DATE | 8 | NonOpPerToD4 | |
| HR01053 | VSTRING | 6 | Spare | |
| HR01054 | VSTRING | 6 | Spare | |
| HR01055 | VSTRING | 6 | Spare | |
| HR01056 | VSTRING | 6 | Spare | |
| HR01057 | VSTRING | 10 | PAEmpCode | |
| HR01058 | VSTRING | 6 | ServiceCall | |
| HR01059 | VSTRING | 1 | CallStatus | |
| HR01060 | VSTRING | 1 | MultipleCalls | |
| HR01061 | VSTRING | 6 | CommonWH | |
| HR01062 | VSTRING | 1 | TypeEngineer | |
| HR01063 | VSTRING | 6 | WorkSchedule | |
| HR01064 | ACCSTR | 50 | AccString | |
| HR01065 | VSTRING | 6 | WIPWarehouse | |
| HR01066 | VSTRING | 6 | WIPBinGood | |
| HR01067 | VSTRING | 6 | WarehouseBad | |
| HR01068 | VSTRING | 6 | WIPBinBad | |
| HR01069 | VSTRING | 10 | Workstation | |
| HR01070 | VSTRING | 6 | ProfessCode | |
| HR01071 | VSTRING | 12 | CostAccount | |
| HR01072 | VSTRING | 10 | CapacityFactor | |
| HR01073 | VSTRING | 10 | ResourceGrp | |
| HR01074 | DATE | 8 | NonOpPerFrD5 | |
| HR01075 | DATE | 8 | NonOpPerToD5 | |
| HR01076 | DATE | 8 | NonOpPerFrD6 | |
| HR01077 | DATE | 8 | NonOpPerToD6 | |
| HR01078 | DATE | 8 | NonOpPerFrD7 | |
| HR01079 | DATE | 8 | NonOpPerToD7 | |
| HR01080 | DATE | 8 | NonOpPerFrD8 | |
| HR01081 | DATE | 8 | NonOpPerToD8 | |
| HR01082 | VSTRING | 50 | ResEMailAdr |
Навигация: Структура БД Scala/iScala | Scala 5.1 SR13 | Resource Management (Управление Персоналом) | Resource Master File (Мастер-Файл ресурсов)
/* */