One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Список таблиц модуля /List of tables of module «Resourse Management»

Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Таблица / Table HR01 — Resource Master Table

Таблица / Table: HR01 — «Resource Master File». Маска имени таблицы / Table name mask: «HR01%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
HR01001 NVARCHAR VSTRING 10 0 10 ResourceID Resource Code   1 Да / Yes
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 Phone Number      
HR01008 NVARCHAR VSTRING 20 0 20 MobileTeleNo Mobile Phone Number      
HR01009 NVARCHAR VSTRING 20 0 20 TelefaxNo Fax 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 Spare      
HR01019 NVARCHAR VSTRING 3 0 3 Spare Spare      
HR01020 NVARCHAR VSTRING 3 0 3 Spare Spare      
HR01021 NVARCHAR VSTRING 3 0 3 Spare Spare      
HR01022 NVARCHAR VSTRING 3 0 3 Spare Spare      
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 Payroll Code Category A      
HR01027 NVARCHAR VSTRING 6 0 6 PayrollCodeB Payroll Code Category B      
HR01028 NVARCHAR VSTRING 6 0 6 PayrollCodeC Payroll Code Category C      
HR01029 NVARCHAR VSTRING 6 0 6 PayrollCodeD Payroll Code Category D      
HR01030 NVARCHAR VSTRING 6 0 6 PayrollCodeE Payroll Code Category E      
HR01031 NVARCHAR VSTRING 6 0 6 PayrollCodeF Payroll Code Category F      
HR01032 NUMERIC MONEY 28 8 20 HourlyCostA Hourly Cost Category A      
HR01033 NUMERIC MONEY 28 8 20 HourlyCostB Hourly Cost Category B      
HR01034 NUMERIC MONEY 28 8 20 HourlyCostC Hourly Cost Category C      
HR01035 NUMERIC MONEY 28 8 20 HourlyCostD Hourly Cost Category D      
HR01036 NUMERIC MONEY 28 8 20 HourlyCostE Hourly Cost Category E      
HR01037 NUMERIC MONEY 28 8 20 HourlyCostF Hourly Cost Category F      
HR01038 NUMERIC X_NUMERIC 20 8 12 AvailHrsMon Available Hours Monday      
HR01039 NUMERIC X_NUMERIC 20 8 12 AvailHrsTue Available Hours Tuesday      
HR01040 NUMERIC X_NUMERIC 20 8 12 AvailHrsWed Available Hours Wednesday      
HR01041 NUMERIC X_NUMERIC 20 8 12 AvailHrsThu Available Hours Thursday      
HR01042 NUMERIC X_NUMERIC 20 8 12 AvailHrsFri Available Hours Friday      
HR01043 NUMERIC X_NUMERIC 20 8 12 AvailHrsSat Available Hours Saturday      
HR01044 NUMERIC X_NUMERIC 20 8 12 AvailHrsSun Available Hours Sunday      
HR01045 DATETIME DATE 0 0 8 NonOpPerFrD1 Non-Operating Period 1 — From Date      
HR01046 DATETIME DATE 0 0 8 NonOpPerToD1 Non-Operating Period 1 — To Date      
HR01047 DATETIME DATE 0 0 8 NonOpPerFrD2 Non-Operating Period 2 — From Date      
HR01048 DATETIME DATE 0 0 8 NonOpPerToD2 Non-Operating Period 2 — To Date      
HR01049 DATETIME DATE 0 0 8 NonOpPerFrD3 Non-Operating Period 3 — From Date      
HR01050 DATETIME DATE 0 0 8 NonOpPerToD3 Non-Operating Period 3 — To Date      
HR01051 DATETIME DATE 0 0 8 NonOpPerFrD4 Non-Operating Period 4 — From Date      
HR01052 DATETIME DATE 0 0 8 NonOpPerToD4 Non-Operating Period 4 — To Date      
HR01053 NVARCHAR VSTRING 6 0 6 Spare Cost Centre      
HR01054 NVARCHAR VSTRING 6 0 6 Spare Product Code      
HR01055 NVARCHAR VSTRING 6 0 6 Spare Project Code      
HR01056 NVARCHAR VSTRING 6 0 6 Spare Cost Account      
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 Assign 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 120 0 120 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 WIP Bin, Bad (Parts-in)      
HR01069 NVARCHAR VSTRING 10 0 10 Workstation Workstation      
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 — Work Schedule      
HR01073 NVARCHAR VSTRING 10 0 10 ResourceGrp Part of resource group      
HR01074 DATETIME DATE 0 0 8 NonOpPerFrD5 Non-Operating Period 5 — From Date      
HR01075 DATETIME DATE 0 0 8 NonOpPerToD5 Non-Operating Period 5 — To Date      
HR01076 DATETIME DATE 0 0 8 NonOpPerFrD6 Non-Operating Period 6 — From Date      
HR01077 DATETIME DATE 0 0 8 NonOpPerToD6 Non-Operating Period 6 — To Date      
HR01078 DATETIME DATE 0 0 8 NonOpPerFrD7 Non-Operating Period 7 — From Date      
HR01079 DATETIME DATE 0 0 8 NonOpPerToD7 Non-Operating Period 7 — To Date      
HR01080 DATETIME DATE 0 0 8 NonOpPerFrD8 Non-Operating Period 8 — From Date      
HR01081 DATETIME DATE 0 0 8 NonOpPerToD8 Non-Operating Period 8 — To Date      
HR01082 NVARCHAR VSTRING 200 0 200 ResEMailAdr Email Address      
HR01083 NCHAR STRING 10 0 10 SupplierCode Supplier Code      
HR01084 INT INTEGER 0 0 9 CalendarColRef Calendar Collection      
HR01085 NCHAR STRING 10 0 10 CustomerCode Customer Code      
HR01086 NVARCHAR VSTRING 10 0 10 ManagerCode Manager code      
HR01087 NVARCHAR VSTRING 35 0 35 AddressLine5 Address Line 5      
HR01088 NVARCHAR VSTRING 35 0 35 AddressLine6 Address Line 6      
HR01089 NVARCHAR VSTRING 35 0 35 AddressLine7 Address Line 7      
HR01090 NVARCHAR VSTRING 3 0 3 CountryCode Country Code      
HR01091 NVARCHAR VSTRING 255 0 255 MobileLogin Mobile Login      
HR01092 NVARCHAR VSTRING 100 0 100 MobileHash Mobile Hash      
HR01093 NCHAR SWITCH 1 0 1 Blocked Blocked      
HR01094 NCHAR SWITCH 1 0 1 EntryOfExpencesAllowed Entry Of Expenses Allowed [Yes] – Engineer is allowed to report expenses on the mobile device;

[No] – Engineer is NOT allowed to report expenses on the mobile device
   

Навигация / Navigation: