Таблица: 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 (Стандартные Ресурсы)