One level Up / 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 HR06 — Work Schedule (not used)

Таблица / 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: