Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: HR01 - «Resource Master File». Маска имени таблицы: «HR01%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
HR01001 | NVARCHAR | VSTRING | 10 | 0 | 10 | ResourceID | Resource Code | 1 | Да | |
HR01002 | NVARCHAR | VSTRING | 35 | 0 | 35 | Name | Resource Name | |||
HR01003 | NVARCHAR | VSTRING | 35 | 0 | 35 | Address1 | Address Line 1 | |||
HR01004 | NVARCHAR | VSTRING | 35 | 0 | 35 | Address2 | Address Line 2 | |||
HR01005 | NVARCHAR | VSTRING | 35 | 0 | 35 | Address3 | Address Line 3 | |||
HR01006 | NVARCHAR | VSTRING | 35 | 0 | 35 | Address4 | Address Line 4 | |||
HR01007 | NVARCHAR | VSTRING | 20 | 0 | 20 | TelephoneNo | Telephone Number | |||
HR01008 | NVARCHAR | VSTRING | 20 | 0 | 20 | MobileTeleNo | Mobile Phone Number | |||
HR01009 | NVARCHAR | VSTRING | 20 | 0 | 20 | TelefaxNo | Telefax Number | |||
HR01010 | NVARCHAR | VSTRING | 15 | 0 | 15 | PagerNo | Pager Number | |||
HR01011 | NVARCHAR | VSTRING | 10 | 0 | 10 | CarRegNo1 | Car Registration Number 1 | |||
HR01012 | NVARCHAR | VSTRING | 10 | 0 | 10 | CarRegNo2 | Car Registration Number 2 | |||
HR01013 | NVARCHAR | VSTRING | 30 | 0 | 30 | Remark1 | Remark Line 1 | |||
HR01014 | NVARCHAR | VSTRING | 30 | 0 | 30 | Remark2 | Remark Line 2 | |||
HR01015 | NVARCHAR | VSTRING | 15 | 0 | 15 | Department | Department | |||
HR01016 | NVARCHAR | VSTRING | 10 | 0 | 10 | ServiceGroup | Resource Group | |||
HR01017 | NVARCHAR | VSTRING | 4 | 0 | 4 | Category | Category | |||
HR01018 | NVARCHAR | VSTRING | 3 | 0 | 3 | Spare | (obsolete) | |||
HR01019 | NVARCHAR | VSTRING | 3 | 0 | 3 | Spare | (obsolete) | |||
HR01020 | NVARCHAR | VSTRING | 3 | 0 | 3 | Spare | (obsolete) | |||
HR01021 | NVARCHAR | VSTRING | 3 | 0 | 3 | Spare | (obsolete) | |||
HR01022 | NVARCHAR | VSTRING | 3 | 0 | 3 | Spare | (obsolete) | |||
HR01023 | NVARCHAR | VSTRING | 6 | 0 | 6 | CentreWarehNo | Warehouse Local | |||
HR01024 | NVARCHAR | VSTRING | 2 | 0 | 2 | PriceCode | Price Code | |||
HR01025 | NVARCHAR | VSTRING | 1 | 0 | 1 | PayrollTrans | Create Payroll Transactions | |||
HR01026 | NVARCHAR | VSTRING | 6 | 0 | 6 | PayrollCodeA | Wage Type Cost Type A | |||
HR01027 | NVARCHAR | VSTRING | 6 | 0 | 6 | PayrollCodeB | Wage Type Cost Type B | |||
HR01028 | NVARCHAR | VSTRING | 6 | 0 | 6 | PayrollCodeC | Wage Type Cost Type C | |||
HR01029 | NVARCHAR | VSTRING | 6 | 0 | 6 | PayrollCodeD | Wage Type Cost Type D | |||
HR01030 | NVARCHAR | VSTRING | 6 | 0 | 6 | PayrollCodeE | Wage Type Cost Type E | |||
HR01031 | NVARCHAR | VSTRING | 6 | 0 | 6 | PayrollCodeF | Wage Type Cost Type F | |||
HR01032 | NUMERIC | MONEY | 28 | 8 | 20 | HourlyCostA | Cost per Hour Cost Type A | |||
HR01033 | NUMERIC | MONEY | 28 | 8 | 20 | HourlyCostB | Cost per Hour Cost Type B | |||
HR01034 | NUMERIC | MONEY | 28 | 8 | 20 | HourlyCostC | Cost per Hour Cost Type C | |||
HR01035 | NUMERIC | MONEY | 28 | 8 | 20 | HourlyCostD | Cost per Hour Cost Type D | |||
HR01036 | NUMERIC | MONEY | 28 | 8 | 20 | HourlyCostE | Cost per Hour Cost Type E | |||
HR01037 | NUMERIC | MONEY | 28 | 8 | 20 | HourlyCostF | Cost per Hour Cost Type F | |||
HR01038 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | AvailHrsMon | (obsolete) | |||
HR01039 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | AvailHrsTue | (obsolete) | |||
HR01040 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | AvailHrsWed | (obsolete) | |||
HR01041 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | AvailHrsThu | (obsolete) | |||
HR01042 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | AvailHrsFri | (obsolete) | |||
HR01043 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | AvailHrsSat | (obsolete) | |||
HR01044 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | AvailHrsSun | (obsolete) | |||
HR01045 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerFrD1 | (obsolete) | |||
HR01046 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerToD1 | (obsolete) | |||
HR01047 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerFrD2 | (obsolete) | |||
HR01048 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerToD2 | (obsolete) | |||
HR01049 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerFrD3 | (obsolete) | |||
HR01050 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerToD3 | (obsolete) | |||
HR01051 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerFrD4 | (obsolete) | |||
HR01052 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerToD4 | (obsolete) | |||
HR01053 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | (obsolete) | |||
HR01054 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | (obsolete) | |||
HR01055 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | (obsolete) | |||
HR01056 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | (obsolete) | |||
HR01057 | NVARCHAR | VSTRING | 10 | 0 | 10 | PAEmpCode | Payroll Employee Code | |||
HR01058 | NVARCHAR | VSTRING | 6 | 0 | 6 | ServiceCall | Service Call | |||
HR01059 | NVARCHAR | VSTRING | 1 | 0 | 1 | CallStatus | Call Status | |||
HR01060 | NVARCHAR | VSTRING | 1 | 0 | 1 | MultipleCalls | Accept Multiple Calls | |||
HR01061 | NVARCHAR | VSTRING | 6 | 0 | 6 | CommonWH | Warehouse Common | |||
HR01062 | NVARCHAR | VSTRING | 1 | 0 | 1 | TypeEngineer | Resource Type | 0 -. Internal human resource
1 - Resource group 2 - External resource 3 - Internal machine resource |
||
HR01063 | NVARCHAR | VSTRING | 6 | 0 | 6 | WorkSchedule | Work Schedule | |||
HR01064 | NVARCHAR | ACCSTR | 50 | 0 | 50 | AccString | Accounting String | |||
HR01065 | NVARCHAR | VSTRING | 6 | 0 | 6 | WIPWarehouse | Warehouse Resource | |||
HR01066 | NVARCHAR | VSTRING | 6 | 0 | 6 | WIPBinGood | Bin Delivery | |||
HR01067 | NVARCHAR | VSTRING | 6 | 0 | 6 | WarehouseBad | Warehouse (Bad) | |||
HR01068 | NVARCHAR | VSTRING | 6 | 0 | 6 | WIPBinBad | Bin (WIP Bad) | |||
HR01069 | NVARCHAR | VSTRING | 10 | 0 | 10 | Workstation | Work Station | |||
HR01070 | NVARCHAR | VSTRING | 6 | 0 | 6 | ProfessCode | Profession Code | |||
HR01071 | NVARCHAR | VSTRING | 12 | 0 | 12 | CostAccount | Cost Account | |||
HR01072 | NVARCHAR | VSTRING | 10 | 0 | 10 | CapacityFactor | Capacity Factor | |||
HR01073 | NVARCHAR | VSTRING | 10 | 0 | 10 | ResourceGrp | (obsolete) | |||
HR01074 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerFrD5 | (obsolete) | |||
HR01075 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerToD5 | (obsolete) | |||
HR01076 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerFrD6 | (obsolete) | |||
HR01077 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerToD6 | (obsolete) | |||
HR01078 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerFrD7 | (obsolete) | |||
HR01079 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerToD7 | (obsolete) | |||
HR01080 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerFrD8 | (obsolete) | |||
HR01081 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerToD8 | (obsolete) | |||
HR01082 | NVARCHAR | VSTRING | 50 | 0 | 50 | ResEMailAdr | Email Address | |||
HR01083 | NCHAR | STRING | 10 | 0 | 10 | Supplier_Code | Supplier Code | |||
HR01084 | INT | INTEGER | 0 | 0 | 9 | Calendar_Collection_Reference | Calendar Collection | |||
HR01085 | NCHAR | STRING | 10 | 0 | 10 | Customer Code | Customer Code |
Навигация: Структура БД iScala | iScala 2.2 HF 2.3318 - 2.02.3318 | Resourse Management | Resource Master Table