На один уровень вверх / 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 HR02 — Resource Templates

Таблица / Table: HR02 — «Standard Resources». Маска имени таблицы / Table name mask: «HR02%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
HR02001 NVARCHAR VSTRING 10 0 10 ResourceID Resource Template Code   1 Да / Yes
HR02002 NVARCHAR VSTRING 35 0 35 Name Resource Name      
HR02003 NVARCHAR VSTRING 35 0 35 Address1 Address Line 1      
HR02004 NVARCHAR VSTRING 35 0 35 Address2 Address Line 2      
HR02005 NVARCHAR VSTRING 35 0 35 Address3 Address Line 3      
HR02006 NVARCHAR VSTRING 35 0 35 Address4 Address Line 4      
HR02007 NVARCHAR VSTRING 20 0 20 TelephoneNo Telephone Number      
HR02008 NVARCHAR VSTRING 20 0 20 MobileTeleNo Mobile Phone Number      
HR02009 NVARCHAR VSTRING 20 0 20 TelefaxNo Telefax Number      
HR02010 NVARCHAR VSTRING 15 0 15 PagerNo Pager Number      
HR02011 NVARCHAR VSTRING 10 0 10 CarRegNo1 Car Registration Number 1      
HR02012 NVARCHAR VSTRING 10 0 10 CarRegNo2 Car Registration Number 2      
HR02013 NVARCHAR VSTRING 30 0 30 Remark1 Remark Line 1      
HR02014 NVARCHAR VSTRING 30 0 30 Remark2 Remark Line 2      
HR02015 NVARCHAR VSTRING 15 0 15 Department Department      
HR02016 NVARCHAR VSTRING 10 0 10 ServiceGroup Resource Group      
HR02017 NVARCHAR VSTRING 4 0 4 Category Category      
HR02018 NVARCHAR VSTRING 3 0 3 CertifCode1 (obsolete)      
HR02019 NVARCHAR VSTRING 3 0 3 CertifCode2 (obsolete)      
HR02020 NVARCHAR VSTRING 3 0 3 CertifCode3 (obsolete)      
HR02021 NVARCHAR VSTRING 3 0 3 CertifCode4 (obsolete)      
HR02022 NVARCHAR VSTRING 3 0 3 CertifCode5 (obsolete)      
HR02023 NVARCHAR VSTRING 6 0 6 CentreWarehNo Warehouse Local      
HR02024 NVARCHAR VSTRING 2 0 2 PriceCode Price Code      
HR02025 NVARCHAR VSTRING 1 0 1 PayrollTrans Create Payroll Transactions      
HR02026 NVARCHAR VSTRING 6 0 6 PayrollCodeA Wage Type Cost Type A      
HR02027 NVARCHAR VSTRING 6 0 6 PayrollCodeB Wage Type Cost Type B      
HR02028 NVARCHAR VSTRING 6 0 6 PayrollCodeC Wage Type Cost Type C      
HR02029 NVARCHAR VSTRING 6 0 6 PayrollCodeD Wage Type Cost Type D      
HR02030 NVARCHAR VSTRING 6 0 6 PayrollCodeE Wage Type Cost Type E      
HR02031 NVARCHAR VSTRING 6 0 6 PayrollCodeF Wage Type Cost Type F      
HR02032 NUMERIC MONEY 28 8 20 HourlyCostA Cost per Hour Cost Type A      
HR02033 NUMERIC MONEY 28 8 20 HourlyCostB Cost per Hour Cost Type B      
HR02034 NUMERIC MONEY 28 8 20 HourlyCostC Cost per Hour Cost Type C      
HR02035 NUMERIC MONEY 28 8 20 HourlyCostD Cost per Hour Cost Type D      
HR02036 NUMERIC MONEY 28 8 20 HourlyCostE Cost per Hour Cost Type E      
HR02037 NUMERIC MONEY 28 8 20 HourlyCostF Cost per Hour Cost Type F      
HR02038 NUMERIC X_NUMERIC 20 8 12 AvailHrsMon (obsolete)      
HR02039 NUMERIC X_NUMERIC 20 8 12 AvailHrsTue (obsolete)      
HR02040 NUMERIC X_NUMERIC 20 8 12 AvailHrsWed (obsolete)      
HR02041 NUMERIC X_NUMERIC 20 8 12 AvailHrsThu (obsolete)      
HR02042 NUMERIC X_NUMERIC 20 8 12 AvailHrsFri (obsolete)      
HR02043 NUMERIC X_NUMERIC 20 8 12 AvailHrsSat (obsolete)      
HR02044 NUMERIC X_NUMERIC 20 8 12 AvailHrsSun (obsolete)      
HR02045 DATETIME DATE 0 0 8 NonOpPerFrD1 (obsolete)      
HR02046 DATETIME DATE 0 0 8 NonOpPerToD1 (obsolete)      
HR02047 DATETIME DATE 0 0 8 NonOpPerFrD2 (obsolete)      
HR02048 DATETIME DATE 0 0 8 NonOpPerToD2 (obsolete)      
HR02049 DATETIME DATE 0 0 8 NonOpPerFrD3 (obsolete)      
HR02050 DATETIME DATE 0 0 8 NonOpPerToD3 (obsolete)      
HR02051 DATETIME DATE 0 0 8 NonOpPerFrD4 (obsolete)      
HR02052 DATETIME DATE 0 0 8 NonOpPerToD4 (obsolete)      
HR02053 NVARCHAR VSTRING 6 0 6 Spare (obsolete)      
HR02054 NVARCHAR VSTRING 6 0 6 Spare (obsolete)      
HR02055 NVARCHAR VSTRING 6 0 6 Spare (obsolete)      
HR02056 NVARCHAR VSTRING 6 0 6 Spare (obsolete)      
HR02057 NVARCHAR VSTRING 10 0 10 PAEmpCode Payroll Employee Code      
HR02058 NVARCHAR VSTRING 6 0 6 ServiceCall Service Call      
HR02059 NVARCHAR VSTRING 1 0 1 CallStatus Call Status      
HR02060 NVARCHAR VSTRING 1 0 1 MultipleCalls Accept Multiple Calls      
HR02061 NVARCHAR VSTRING 6 0 6 CommonWH Warehouse Common      
HR02062 NVARCHAR VSTRING 1 0 1 TypeEngineer Resource Type 0 -. Internal human resource

1 — Resource group

2 — External resource

3 — Internal machine resource		    
HR02063 NVARCHAR VSTRING 6 0 6 WorkSchedule Work Schedule      
HR02064 NVARCHAR ACCSTR 120 0 120 AccString Accounting String      
HR02065 NVARCHAR VSTRING 6 0 6 WIPWarehouse Warehouse Resource      
HR02066 NVARCHAR VSTRING 6 0 6 WIPBinGood Bin Delivery      
HR02067 NVARCHAR VSTRING 6 0 6 WarehouseBad Warehouse (Bad)      
HR02068 NVARCHAR VSTRING 6 0 6 WIPBinBad Bin (WIP Bad)      
HR02069 NVARCHAR VSTRING 10 0 10 Workstation Work Station      
HR02070 NVARCHAR VSTRING 6 0 6 ProfessCode Profession Code      
HR02071 NVARCHAR VSTRING 12 0 12 CostAccount Cost Account      
HR02072 NVARCHAR VSTRING 10 0 10 CapacityFactor Capacity Factor      
HR02073 NVARCHAR VSTRING 10 0 10 ResourceGrp (obsolete)      
HR02074 DATETIME DATE 0 0 8 NonOpPerFrD5 (obsolete)      
HR02075 DATETIME DATE 0 0 8 NonOpPerToD5 (obsolete)      
HR02076 DATETIME DATE 0 0 8 NonOpPerFrD6 (obsolete)      
HR02077 DATETIME DATE 0 0 8 NonOpPerToD6 (obsolete)      
HR02078 DATETIME DATE 0 0 8 NonOpPerFrD7 (obsolete)      
HR02079 DATETIME DATE 0 0 8 NonOpPerToD7 (obsolete)      
HR02080 DATETIME DATE 0 0 8 NonOpPerFrD8 (obsolete)      
HR02081 DATETIME DATE 0 0 8 NonOpPerToD8 (obsolete)      
HR02082 NVARCHAR VSTRING 200 0 200 ResEMailAdr Email Address      
HR02083 NCHAR STRING 10 0 10 SupplierCode Supplier Code      
HR02084 INT INTEGER 0 0 9 CalendarColRef Calendar Collection      
HR02085 NCHAR STRING 10 0 10 CustomerCode Customer Code      
HR02086 NVARCHAR VSTRING 10 0 10 ManagerCode Manager code      
HR02087 NVARCHAR VSTRING 35 0 35 AddressLine5 Address Line 5      
HR02088 NVARCHAR VSTRING 35 0 35 AddressLine6 Address Line 6      
HR02089 NVARCHAR VSTRING 35 0 35 AddressLine7 Address Line 7      
HR02090 NVARCHAR VSTRING 3 0 3 CountryCode Country Code      
HR02091 NVARCHAR VSTRING 255 0 255 MobileLogin Mobile Login      
HR02092 NVARCHAR VSTRING 100 0 100 MobileHash Mobile Hash      
HR02093 NCHAR SWITCH 1 0 1 Blocked Blocked      
HR02094 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
    

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