Таблица: HR02 - «Standard Resources» («Стандартные Ресурсы»)

Поле Тип поля Scala Длина Scala Комментарий Первич­ный ключ?
HR02001 VSTRING 10 ResourceID Да
HR02002 VSTRING 35 Name  
HR02003 VSTRING 35 Address1  
HR02004 VSTRING 35 Address2  
HR02005 VSTRING 35 Address3  
HR02006 VSTRING 35 Address4  
HR02007 VSTRING 20 TelephoneNo  
HR02008 VSTRING 20 MobileTeleNo  
HR02009 VSTRING 20 TelefaxNo  
HR02010 VSTRING 15 PagerNo  
HR02011 VSTRING 10 CarRegNo1  
HR02012 VSTRING 10 CarRegNo2  
HR02013 VSTRING 30 Remark1  
HR02014 VSTRING 30 Remark2  
HR02015 VSTRING 15 Department  
HR02016 VSTRING 10 ServiceGroup  
HR02017 VSTRING 4 Category  
HR02018 VSTRING 3 CertifCode1  
HR02019 VSTRING 3 CertifCode2  
HR02020 VSTRING 3 CertifCode3  
HR02021 VSTRING 3 CertifCode4  
HR02022 VSTRING 3 CertifCode5  
HR02023 VSTRING 6 CentreWarehNo  
HR02024 VSTRING 2 PriceCode  
HR02025 VSTRING 1 PayrollTrans  
HR02026 VSTRING 6 PayrollCodeA  
HR02027 VSTRING 6 PayrollCodeB  
HR02028 VSTRING 6 PayrollCodeC  
HR02029 VSTRING 6 PayrollCodeD  
HR02030 VSTRING 6 PayrollCodeE  
HR02031 VSTRING 6 PayrollCodeF  
HR02032 MONEY 20 HourlyCostA  
HR02033 MONEY 20 HourlyCostB  
HR02034 MONEY 20 HourlyCostC  
HR02035 MONEY 20 HourlyCostD  
HR02036 MONEY 20 HourlyCostE  
HR02037 MONEY 20 HourlyCostF  
HR02038 X_NUMERIC 12 AvailHrsMon  
HR02039 X_NUMERIC 12 AvailHrsTue  
HR02040 X_NUMERIC 12 AvailHrsWed  
HR02041 X_NUMERIC 12 AvailHrsThu  
HR02042 X_NUMERIC 12 AvailHrsFri  
HR02043 X_NUMERIC 12 AvailHrsSat  
HR02044 X_NUMERIC 12 AvailHrsSun  
HR02045 DATE 8 NonOpPerFrD1  
HR02046 DATE 8 NonOpPerToD1  
HR02047 DATE 8 NonOpPerFrD2  
HR02048 DATE 8 NonOpPerToD2  
HR02049 DATE 8 NonOpPerFrD3  
HR02050 DATE 8 NonOpPerToD3  
HR02051 DATE 8 NonOpPerFrD4  
HR02052 DATE 8 NonOpPerToD4  
HR02053 VSTRING 6 Spare  
HR02054 VSTRING 6 Spare  
HR02055 VSTRING 6 Spare  
HR02056 VSTRING 6 Spare  
HR02057 VSTRING 10 PAEmpCode  
HR02058 VSTRING 6 ServiceCall  
HR02059 VSTRING 1 CallStatus  
HR02060 VSTRING 1 MultipleCalls  
HR02061 VSTRING 6 CommonWH  
HR02062 VSTRING 1 TypeEngineer  
HR02063 VSTRING 6 WorkSchedule  
HR02064 ACCSTR 50 AccString  
HR02065 VSTRING 6 WIPWarehouse  
HR02066 VSTRING 6 WIPBinGood  
HR02067 VSTRING 6 WarehouseBad  
HR02068 VSTRING 6 WIPBinBad  
HR02069 VSTRING 10 Workstation  
HR02070 VSTRING 6 ProfessCode  
HR02071 VSTRING 12 CostAccount  
HR02072 VSTRING 10 CapacityFactor  
HR02073 VSTRING 10 ResourceGrp  
HR02074 DATE 8 NonOpPerFrD5  
HR02075 DATE 8 NonOpPerToD5  
HR02076 DATE 8 NonOpPerFrD6  
HR02077 DATE 8 NonOpPerToD6  
HR02078 DATE 8 NonOpPerFrD7  
HR02079 DATE 8 NonOpPerToD7  
HR02080 DATE 8 NonOpPerFrD8  
HR02081 DATE 8 NonOpPerToD8  

Навигация: Структура БД Scala/iScala | Scala 5.1 SR13 | Resource Management (Управление Персоналом) | Standard Resources (Стандартные Ресурсы)