пользователям программных продуктов Scala 5.0, Scala 5.1, iScala 2.1, iScala 2.2, iScala 2.3, iScala 3.0 (и так далее)

Таблица: 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      
HR01086 NVARCHAR VSTRING 10 0 10 ManagerCode Manager code      

Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Resourse Management | Resource Master Table

TopList

© Алексей Васильев. 2004-2019. При использовании материалов ссылка обязательна.