One level Up / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «Resourse Management»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица HR01 — Resource Master Table

Таблица: 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 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 Expences Allowed [Yes] – Engineer is allowed to report expenses on the mobile device;
[No] – Engineer is NOT allowed to report expenses on the mobile device
   

Навигация: