Таблица / Table: HR06 — «Work Schedule File Definition». Маска имени таблицы / Table name mask: «HR06%cc00»
| Поле / Field | Тип поля / Field Type | Тип поля Scala / iScala Field Type | Длина поля / Field length | Точность / Precision | Длина Scala / iScala length | Комментарий / Comment | Расширенный комментарий / Extended comment | Дополнительное описание / Additional description | Позиция в индексе / Index position | Первичный ключ? / Is Primary key? |
| HR06001 | NVARCHAR | VSTRING | 6 | 0 | 6 | WorkSchedID | Work Schedule Code | 1 | Да / Yes | |
| HR06002 | NVARCHAR | VSTRING | 4 | 0 | 4 | WorkSchedYr | Work Schedule Year | |||
| HR06003 | NVARCHAR | VSTRING | 25 | 0 | 25 | Name | Description | |||
| HR06004 | NVARCHAR | VSTRING | 5 | 0 | 5 | Sh1StTimeMon | Start Time 1 Monday | |||
| HR06005 | NVARCHAR | VSTRING | 5 | 0 | 5 | Sh1StTimeTue | Start Time 1 Tuesday | |||
| HR06006 | NVARCHAR | VSTRING | 5 | 0 | 5 | Sh1StTimeWed | Start Time 1 Wednesday | |||
| HR06007 | NVARCHAR | VSTRING | 5 | 0 | 5 | Sh1StTimeThu | Start Time 1 Thursday | |||
| HR06008 | NVARCHAR | VSTRING | 5 | 0 | 5 | Sh1StTimeFri | Start Time 1 Friday | |||
| HR06009 | NVARCHAR | VSTRING | 5 | 0 | 5 | Sh1StTimeSat | Start Time 1 Saturday | |||
| HR06010 | NVARCHAR | VSTRING | 5 | 0 | 5 | Sh1StTimeSun | Start Time 1 Sunday | |||
| HR06011 | NVARCHAR | VSTRING | 5 | 0 | 5 | Sh1EnTimeMon | End Time 1 Monday | |||
| HR06012 | NVARCHAR | VSTRING | 5 | 0 | 5 | Sh1EnTimeTue | End Time 1 Tuesday | |||
| HR06013 | NVARCHAR | VSTRING | 5 | 0 | 5 | Sh1EnTimeWed | End Time 1 Wednesday | |||
| HR06014 | NVARCHAR | VSTRING | 5 | 0 | 5 | Sh1EnTimeThu | End Time 1 Thursday | |||
| HR06015 | NVARCHAR | VSTRING | 5 | 0 | 5 | Sh1EnTimeFri | End Time 1 Friday | |||
| HR06016 | NVARCHAR | VSTRING | 5 | 0 | 5 | Sh1EnTimeSat | End Time 1 Saturday | |||
| HR06017 | NVARCHAR | VSTRING | 5 | 0 | 5 | Sh1EnTimeSun | End Time 1 Sunday | |||
| HR06018 | NVARCHAR | VSTRING | 5 | 0 | 5 | Sh2StTimeMon | Start Time 2 Monday | |||
| HR06019 | NVARCHAR | VSTRING | 5 | 0 | 5 | Sh2StTimeTue | Start Time 2 Tuesday | |||
| HR06020 | NVARCHAR | VSTRING | 5 | 0 | 5 | Sh2StTimeWed | Start Time 2 Wednesday | |||
| HR06021 | NVARCHAR | VSTRING | 5 | 0 | 5 | Sh2StTimeThu | Start Time 2 Thursday | |||
| HR06022 | NVARCHAR | VSTRING | 5 | 0 | 5 | Sh2StTimeFri | Start Time 2 Friday | |||
| HR06023 | NVARCHAR | VSTRING | 5 | 0 | 5 | Sh2StTimeSat | Start Time 2 Saturday | |||
| HR06024 | NVARCHAR | VSTRING | 5 | 0 | 5 | Sh2StTimeSun | Start Time 2 Sunday | |||
| HR06025 | NVARCHAR | VSTRING | 5 | 0 | 5 | Sh2EnTimeMon | End Time 2 Monday | |||
| HR06026 | NVARCHAR | VSTRING | 5 | 0 | 5 | Sh2EnTimeTue | End Time 2 Tuesday | |||
| HR06027 | NVARCHAR | VSTRING | 5 | 0 | 5 | Sh2EnTimeWed | End Time 2 Wednesday | |||
| HR06028 | NVARCHAR | VSTRING | 5 | 0 | 5 | Sh2EnTimeThu | End Time 2 Thursday | |||
| HR06029 | NVARCHAR | VSTRING | 5 | 0 | 5 | Sh2EnTimeFri | End Time 2 Friday | |||
| HR06030 | NVARCHAR | VSTRING | 5 | 0 | 5 | Sh2EnTimeSat | End Time 2 Saturday | |||
| HR06031 | NVARCHAR | VSTRING | 5 | 0 | 5 | Sh2EnTimeSun | End Time 2 Sunday | |||
| HR06032 | NVARCHAR | VSTRING | 5 | 0 | 5 | Sh3StTimeMon | Start Time 3 Monday | |||
| HR06033 | NVARCHAR | VSTRING | 5 | 0 | 5 | Sh3StTimeTue | Start Time 3 Tuesday | |||
| HR06034 | NVARCHAR | VSTRING | 5 | 0 | 5 | Sh3StTimeWed | Start Time 3 Wednesday | |||
| HR06035 | NVARCHAR | VSTRING | 5 | 0 | 5 | Sh3StTimeThu | Start Time 3 Thursday | |||
| HR06036 | NVARCHAR | VSTRING | 5 | 0 | 5 | Sh3StTimeFri | Start Time 3 Friday | |||
| HR06037 | NVARCHAR | VSTRING | 5 | 0 | 5 | Sh3StTimeSat | Start Time 3 Saturday | |||
| HR06038 | NVARCHAR | VSTRING | 5 | 0 | 5 | Sh3StTimeSun | Start Time 3 Sunday | |||
| HR06039 | NVARCHAR | VSTRING | 5 | 0 | 5 | Sh3EnTimeMon | End Time 3 Monday | |||
| HR06040 | NVARCHAR | VSTRING | 5 | 0 | 5 | Sh3EnTimeTue | End Time 3 Tuesday | |||
| HR06041 | NVARCHAR | VSTRING | 5 | 0 | 5 | Sh3EnTimeWed | End Time 3 Wednesday | |||
| HR06042 | NVARCHAR | VSTRING | 5 | 0 | 5 | Sh3EnTimeThu | End Time 3 Thursday | |||
| HR06043 | NVARCHAR | VSTRING | 5 | 0 | 5 | Sh3EnTimeFri | End Time 3 Friday | |||
| HR06044 | NVARCHAR | VSTRING | 5 | 0 | 5 | Sh3EnTimeSat | End Time 3 Saturday | |||
| HR06045 | NVARCHAR | VSTRING | 5 | 0 | 5 | Sh3EnTimeSun | End Time 3 Sunday | |||
| HR06046 | NVARCHAR | VSTRING | 5 | 0 | 5 | OvertimeMon | Overtime Monday | |||
| HR06047 | NVARCHAR | VSTRING | 5 | 0 | 5 | OvertimeTue | Overtime Tuesday | |||
| HR06048 | NVARCHAR | VSTRING | 5 | 0 | 5 | OvertimeWed | Overtime Wednesday | |||
| HR06049 | NVARCHAR | VSTRING | 5 | 0 | 5 | OvertimeThu | Overtime Thursday | |||
| HR06050 | NVARCHAR | VSTRING | 5 | 0 | 5 | OvertimeFri | Overtime Friday | |||
| HR06051 | NVARCHAR | VSTRING | 5 | 0 | 5 | OvertimeSat | Overtime Saturday | |||
| HR06052 | NVARCHAR | VSTRING | 5 | 0 | 5 | OvertimeSun | Overtime Sunday | |||
| HR06053 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerFrD1 | None Operational Period From Date 1 | |||
| HR06054 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerToD1 | None Operational Period To Date 1 | |||
| HR06055 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerFrD2 | None Operational Period From Date 2 | |||
| HR06056 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerToD2 | None Operational Period To Date 2 | |||
| HR06057 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerFrD3 | None Operational Period From Date 3 | |||
| HR06058 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerToD3 | None Operational Period To Date 3 | |||
| HR06059 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerFrD4 | None Operational Period From Date 4 | |||
| HR06060 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerToD4 | None Operational Period To Date 4 | |||
| HR06061 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerFrD5 | None Operational Period From Date 5 | |||
| HR06062 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerToD5 | None Operational Period To Date 5 | |||
| HR06063 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerFrD6 | None Operational Period From Date 6 | |||
| HR06064 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerToD6 | None Operational Period To Date 6 | |||
| HR06065 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerFrD7 | None Operational Period From Date 7 | |||
| HR06066 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerToD7 | None Operational Period To Date 7 | |||
| HR06067 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerFrD8 | None Operational Period From Date 8 | |||
| HR06068 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerToD8 | None Operational Period To Date 8 | |||
| HR06069 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerFrD9 | None Operational Period From Date 9 | |||
| HR06070 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerToD9 | None Operational Period To Date 9 | |||
| HR06071 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerFrD10 | None Operational Period From Date 10 | |||
| HR06072 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerToD10 | None Operational Period To Date 10 | |||
| HR06073 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerFrD11 | None Operational Period From Date 11 | |||
| HR06074 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerToD11 | None Operational Period To Date 11 | |||
| HR06075 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerFrD12 | None Operational Period From Date 12 | |||
| HR06076 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerToD12 | None Operational Period To Date 12 | |||
| HR06077 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerFrD13 | None Operational Period From Date 13 | |||
| HR06078 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerToD13 | None Operational Period To Date 13 | |||
| HR06079 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerFrD14 | None Operational Period From Date 14 | |||
| HR06080 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerToD14 | None Operational Period To Date 14 | |||
| HR06081 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerFrD15 | None Operational Period From Date 15 | |||
| HR06082 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerToD15 | None Operational Period To Date 15 | |||
| HR06083 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerFrD16 | None Operational Period From Date 16 | |||
| HR06084 | DATETIME | DATE | 0 | 0 | 8 | NonOpPerToD16 | None Operational Period To Date 16 | |||
| HR06085 | DATETIME | DATE | 0 | 0 | 8 | Spare | (obsolete) | |||
| HR06086 | DATETIME | DATE | 0 | 0 | 8 | Spare | (obsolete) | |||
| HR06087 | DATETIME | DATE | 0 | 0 | 8 | Spare | (obsolete) | |||
| HR06088 | DATETIME | DATE | 0 | 0 | 8 | Spare | (obsolete) | |||
| HR06089 | DATETIME | DATE | 0 | 0 | 8 | Spare | (obsolete) | |||
| HR06090 | DATETIME | DATE | 0 | 0 | 8 | Spare | (obsolete) | |||
| HR06091 | DATETIME | DATE | 0 | 0 | 8 | Spare | (obsolete) | |||
| HR06092 | DATETIME | DATE | 0 | 0 | 8 | Spare | (obsolete) | |||
| HR06093 | NVARCHAR | VSTRING | 5 | 0 | 5 | NonOpPerFrT1 | Non Operational Period From Time 1 | |||
| HR06094 | NVARCHAR | VSTRING | 5 | 0 | 5 | NonOpPerToT1 | Non Operational Period To Time 1 | |||
| HR06095 | NVARCHAR | VSTRING | 5 | 0 | 5 | NonOpPerFrT2 | Non Operational Period From Time 2 | |||
| HR06096 | NVARCHAR | VSTRING | 5 | 0 | 5 | NonOpPerToT2 | Non Operational Period To Time 2 | |||
| HR06097 | NVARCHAR | VSTRING | 5 | 0 | 5 | NonOpPerFrT3 | Non Operational Period From Time 3 | |||
| HR06098 | NVARCHAR | VSTRING | 5 | 0 | 5 | NonOpPerToT3 | Non Operational Period To Time 3 | |||
| HR06099 | NVARCHAR | VSTRING | 5 | 0 | 5 | NonOpPerFrT4 | Non Operational Period From Time 4 | |||
| HR06100 | NVARCHAR | VSTRING | 5 | 0 | 5 | NonOpPerToT4 | Non Operational Period To Time 4 | |||
| HR06101 | NVARCHAR | VSTRING | 5 | 0 | 5 | NonOpPerFrT5 | Non Operational Period From Time 5 | |||
| HR06102 | NVARCHAR | VSTRING | 5 | 0 | 5 | NonOpPerToT5 | Non Operational Period To Time 5 | |||
| HR06103 | NVARCHAR | VSTRING | 5 | 0 | 5 | NonOpPerFrT6 | Non Operational Period From Time 6 | |||
| HR06104 | NVARCHAR | VSTRING | 5 | 0 | 5 | NonOpPerToT6 | Non Operational Period To Time 6 | |||
| HR06105 | NVARCHAR | VSTRING | 5 | 0 | 5 | NonOpPerFrT7 | Non Operational Period From Time 7 | |||
| HR06106 | NVARCHAR | VSTRING | 5 | 0 | 5 | NonOpPerToT7 | Non Operational Period To Time 7 | |||
| HR06107 | NVARCHAR | VSTRING | 5 | 0 | 5 | NonOpPerFrT8 | Non Operational Period From Time 8 | |||
| HR06108 | NVARCHAR | VSTRING | 5 | 0 | 5 | NonOpPerToT8 | Non Operational Period To Time 8 | |||
| HR06109 | NVARCHAR | VSTRING | 5 | 0 | 5 | NonOpPerFrT9 | Non Operational Period From Time 9 | |||
| HR06110 | NVARCHAR | VSTRING | 5 | 0 | 5 | NonOpPerToT9 | Non Operational Period To Time 9 | |||
| HR06111 | NVARCHAR | VSTRING | 5 | 0 | 5 | NonOpPerFrT10 | Non Operational Period From Time 10 | |||
| HR06112 | NVARCHAR | VSTRING | 5 | 0 | 5 | NonOpPerToT10 | Non Operational Period To Time 10 | |||
| HR06113 | NVARCHAR | VSTRING | 5 | 0 | 5 | NonOpPerFrT11 | Non Operational Period From Time 11 | |||
| HR06114 | NVARCHAR | VSTRING | 5 | 0 | 5 | NonOpPerToT11 | Non Operational Period To Time 11 | |||
| HR06115 | NVARCHAR | VSTRING | 5 | 0 | 5 | NonOpPerFrT12 | Non Operational Period From Time 12 | |||
| HR06116 | NVARCHAR | VSTRING | 5 | 0 | 5 | NonOpPerToT12 | Non Operational Period To Time 12 | |||
| HR06117 | NVARCHAR | VSTRING | 5 | 0 | 5 | NonOpPerFrT13 | Non Operational Period From Time 13 | |||
| HR06118 | NVARCHAR | VSTRING | 5 | 0 | 5 | NonOpPerToT13 | Non Operational Period To Time 13 | |||
| HR06119 | NVARCHAR | VSTRING | 5 | 0 | 5 | NonOpPerFrT14 | Non Operational Period From Time 14 | |||
| HR06120 | NVARCHAR | VSTRING | 5 | 0 | 5 | NonOpPerToT14 | Non Operational Period To Time 14 | |||
| HR06121 | NVARCHAR | VSTRING | 5 | 0 | 5 | NonOpPerFrT15 | Non Operational Period From Time 15 | |||
| HR06122 | NVARCHAR | VSTRING | 5 | 0 | 5 | NonOpPerToT15 | Non Operational Period To Time 15 | |||
| HR06123 | NVARCHAR | VSTRING | 5 | 0 | 5 | NonOpPerFrT16 | Non Operational Period From Time 16 | |||
| HR06124 | NVARCHAR | VSTRING | 5 | 0 | 5 | NonOpPerToT16 | Non Operational Period To Time 16 | |||
| HR06125 | NVARCHAR | VSTRING | 5 | 0 | 5 | Spare | (obsolete) | |||
| HR06126 | NVARCHAR | VSTRING | 5 | 0 | 5 | Spare | (obsolete) | |||
| HR06127 | NVARCHAR | VSTRING | 5 | 0 | 5 | Spare | (obsolete) | |||
| HR06128 | NVARCHAR | VSTRING | 5 | 0 | 5 | Spare | (obsolete) | |||
| HR06129 | NVARCHAR | VSTRING | 5 | 0 | 5 | Spare | (obsolete) | |||
| HR06130 | NVARCHAR | VSTRING | 5 | 0 | 5 | Spare | (obsolete) | |||
| HR06131 | NVARCHAR | VSTRING | 5 | 0 | 5 | Spare | (obsolete) | |||
| HR06132 | NVARCHAR | VSTRING | 5 | 0 | 5 | Spare | (obsolete) |
Навигация / Navigation:
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список системных таблиц / System Tables
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Основными Средствами» / List of tables of module «Asset Management»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Контрактами» / List of tables of module «Contract Management»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Прямая выписка счетов» / List of tables of module «Direct Invoicing»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Главная Книга» / List of tables of module «General Ledger»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Ресурсами» / List of tables of module «Resourse Management»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «База данных рынка» / List of tables of module «Market Database»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Производством» / List of tables of module «Material Production Control»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Заказы на Продажу» / List of tables of module «Sales Order»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Заработная плата» / List of tables of module «Payroll»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Заказы на Закупку» / List of tables of module «Purchase Order»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Книга Закупок» / List of tables of module «Purchase Ledger»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Долговые обязательства» / List of tables of module «Promissory Notes»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление проектами» / List of tables of module «Project Management»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Запасами» / List of tables of module «Stock Control»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Книга Продаж» / List of tables of module «Sales Ledger»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление заказом на обслуживание» / List of tables of module «Service Order Management»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Статистика» / List of tables of module «Statistics»
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Системные Утилиты» / List of tables of module «System Utilities/Office Autom.»
