One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Список таблиц модуля /List of tables of module «Stock Control»

Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0429 :: Таблица / Table SC1C — Stock Budget Profiles 5-9

Таблица / Table: SC1C — «Stock Parameters 3». Маска имени таблицы / Table name mask: «SC1C%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
SC1C001 NCHAR STRING 2 0 2 Year_ Year   1 Да / Yes
SC1C002 NVARCHAR VSTRING 20 0 20 BudMod5Per01 Budget Model 5 Period 1      
SC1C003 NVARCHAR VSTRING 20 0 20 BudMod5Per02 Budget Model 5 Period 2      
SC1C004 NVARCHAR VSTRING 20 0 20 BudMod5Per03 Budget Model 5 Period 3      
SC1C005 NVARCHAR VSTRING 20 0 20 BudMod5Per04 Budget Model 5 Period 4      
SC1C006 NVARCHAR VSTRING 20 0 20 BudMod5Per05 Budget Model 5 Period 5      
SC1C007 NVARCHAR VSTRING 20 0 20 BudMod5Per06 Budget Model 5 Period 6      
SC1C008 NVARCHAR VSTRING 20 0 20 BudMod5Per07 Budget Model 5 Period 7      
SC1C009 NVARCHAR VSTRING 20 0 20 BudMod5Per08 Budget Model 5 Period 8      
SC1C010 NVARCHAR VSTRING 20 0 20 BudMod5Per09 Budget Model 5 Period 9      
SC1C011 NVARCHAR VSTRING 20 0 20 BudMod5Per10 Budget Model 5 Period 10      
SC1C012 NVARCHAR VSTRING 20 0 20 BudMod5Per11 Budget Model 5 Period 11      
SC1C013 NVARCHAR VSTRING 20 0 20 BudMod5Per12 Budget Model 5 Period 12      
SC1C014 NVARCHAR VSTRING 20 0 20 BudMod5Per13 Budget Model 5 Period 13      
SC1C015 NVARCHAR VSTRING 20 0 20 BudMod5Per14 Budget Model 5 Period 14      
SC1C016 NVARCHAR VSTRING 20 0 20 BudMod5Per15 Budget Model 5 Period 15      
SC1C017 NVARCHAR VSTRING 20 0 20 BudMod5Per16 Budget Model 5 Period 16      
SC1C018 NVARCHAR VSTRING 20 0 20 BudMod5Per17 Budget Model 5 Period 17      
SC1C019 NVARCHAR VSTRING 20 0 20 BudMod5Per18 Budget Model 5 Period 18      
SC1C020 NCHAR STRING 1 0 1 Spare (obsolete)      
SC1C021 NCHAR STRING 1 0 1 Spare (obsolete)      
SC1C022 NVARCHAR VSTRING 20 0 20 BudMod6Per01 Budget Model 6 Period 1      
SC1C023 NVARCHAR VSTRING 20 0 20 BudMod6Per02 Budget Model 6 Period 2      
SC1C024 NVARCHAR VSTRING 20 0 20 BudMod6Per03 Budget Model 6 Period 3      
SC1C025 NVARCHAR VSTRING 20 0 20 BudMod6Per04 Budget Model 6 Period 4      
SC1C026 NVARCHAR VSTRING 20 0 20 BudMod6Per05 Budget Model 6 Period 5      
SC1C027 NVARCHAR VSTRING 20 0 20 BudMod6Per06 Budget Model 6 Period 6      
SC1C028 NVARCHAR VSTRING 20 0 20 BudMod6Per07 Budget Model 6 Period 7      
SC1C029 NVARCHAR VSTRING 20 0 20 BudMod6Per08 Budget Model 6 Period 8      
SC1C030 NVARCHAR VSTRING 20 0 20 BudMod6Per09 Budget Model 6 Period 9      
SC1C031 NVARCHAR VSTRING 20 0 20 BudMod6Per10 Budget Model 6 Period 10      
SC1C032 NVARCHAR VSTRING 20 0 20 BudMod6Per11 Budget Model 6 Period 11      
SC1C033 NVARCHAR VSTRING 20 0 20 BudMod6Per12 Budget Model 6 Period 12      
SC1C034 NVARCHAR VSTRING 20 0 20 BudMod6Per13 Budget Model 6 Period 13      
SC1C035 NVARCHAR VSTRING 20 0 20 BudMod6Per14 Budget Model 6 Period 14      
SC1C036 NVARCHAR VSTRING 20 0 20 BudMod6Per15 Budget Model 6 Period 15      
SC1C037 NVARCHAR VSTRING 20 0 20 BudMod6Per16 Budget Model 6 Period 16      
SC1C038 NVARCHAR VSTRING 20 0 20 BudMod6Per17 Budget Model 6 Period 17      
SC1C039 NVARCHAR VSTRING 20 0 20 BudMod6Per18 Budget Model 6 Period 18      
SC1C040 NCHAR STRING 1 0 1 Spare (obsolete)      
SC1C041 NCHAR STRING 1 0 1 Spare (obsolete)      
SC1C042 NVARCHAR VSTRING 20 0 20 BudMod7Per01 Budget Model 7 Period 1      
SC1C043 NVARCHAR VSTRING 20 0 20 BudMod7Per02 Budget Model 7 Period 2      
SC1C044 NVARCHAR VSTRING 20 0 20 BudMod7Per03 Budget Model 7 Period 3      
SC1C045 NVARCHAR VSTRING 20 0 20 BudMod7Per04 Budget Model 7 Period 4      
SC1C046 NVARCHAR VSTRING 20 0 20 BudMod7Per05 Budget Model 7 Period 5      
SC1C047 NVARCHAR VSTRING 20 0 20 BudMod7Per06 Budget Model 7 Period 6      
SC1C048 NVARCHAR VSTRING 20 0 20 BudMod7Per07 Budget Model 7 Period 7      
SC1C049 NVARCHAR VSTRING 20 0 20 BudMod7Per08 Budget Model 7 Period 8      
SC1C050 NVARCHAR VSTRING 20 0 20 BudMod7Per09 Budget Model 7 Period 9      
SC1C051 NVARCHAR VSTRING 20 0 20 BudMod7Per10 Budget Model 7 Period 10      
SC1C052 NVARCHAR VSTRING 20 0 20 BudMod7Per11 Budget Model 7 Period 11      
SC1C053 NVARCHAR VSTRING 20 0 20 BudMod7Per12 Budget Model 7 Period 12      
SC1C054 NVARCHAR VSTRING 20 0 20 BudMod7Per13 Budget Model 7 Period 13      
SC1C055 NVARCHAR VSTRING 20 0 20 BudMod7Per14 Budget Model 7 Period 14      
SC1C056 NVARCHAR VSTRING 20 0 20 BudMod7Per15 Budget Model 7 Period 15      
SC1C057 NVARCHAR VSTRING 20 0 20 BudMod7Per16 Budget Model 7 Period 16      
SC1C058 NVARCHAR VSTRING 20 0 20 BudMod7Per17 Budget Model 7 Period 17      
SC1C059 NVARCHAR VSTRING 20 0 20 BudMod7Per18 Budget Model 7 Period 18      
SC1C060 NCHAR STRING 1 0 1 Spare (obsolete)      
SC1C061 NCHAR STRING 1 0 1 Spare (obsolete)      
SC1C062 NVARCHAR VSTRING 20 0 20 BudMod8Per01 Budget Model 8 Period 1      
SC1C063 NVARCHAR VSTRING 20 0 20 BudMod8Per02 Budget Model 8 Period 2      
SC1C064 NVARCHAR VSTRING 20 0 20 BudMod8Per03 Budget Model 8 Period 3      
SC1C065 NVARCHAR VSTRING 20 0 20 BudMod8Per04 Budget Model 8 Period 4      
SC1C066 NVARCHAR VSTRING 20 0 20 BudMod8Per05 Budget Model 8 Period 5      
SC1C067 NVARCHAR VSTRING 20 0 20 BudMod8Per06 Budget Model 8 Period 6      
SC1C068 NVARCHAR VSTRING 20 0 20 BudMod8Per07 Budget Model 8 Period 7      
SC1C069 NVARCHAR VSTRING 20 0 20 BudMod8Per08 Budget Model 8 Period 8      
SC1C070 NVARCHAR VSTRING 20 0 20 BudMod8Per09 Budget Model 8 Period 9      
SC1C071 NVARCHAR VSTRING 20 0 20 BudMod8Per10 Budget Model 8 Period 10      
SC1C072 NVARCHAR VSTRING 20 0 20 BudMod8Per11 Budget Model 8 Period 11      
SC1C073 NVARCHAR VSTRING 20 0 20 BudMod8Per12 Budget Model 8 Period 12      
SC1C074 NVARCHAR VSTRING 20 0 20 BudMod8Per13 Budget Model 8 Period 13      
SC1C075 NVARCHAR VSTRING 20 0 20 BudMod8Per14 Budget Model 8 Period 14      
SC1C076 NVARCHAR VSTRING 20 0 20 BudMod8Per15 Budget Model 8 Period 15      
SC1C077 NVARCHAR VSTRING 20 0 20 BudMod8Per16 Budget Model 8 Period 16      
SC1C078 NVARCHAR VSTRING 20 0 20 BudMod8Per17 Budget Model 8 Period 17      
SC1C079 NVARCHAR VSTRING 20 0 20 BudMod8Per18 Budget Model 8 Period 18      
SC1C080 NCHAR STRING 1 0 1 Spare (obsolete)      
SC1C081 NCHAR STRING 1 0 1 Spare (obsolete)      
SC1C082 NVARCHAR VSTRING 20 0 20 BudMod9Per01 Budget Model 9 Period 1      
SC1C083 NVARCHAR VSTRING 20 0 20 BudMod9Per02 Budget Model 9 Period 2      
SC1C084 NVARCHAR VSTRING 20 0 20 BudMod9Per03 Budget Model 9 Period 3      
SC1C085 NVARCHAR VSTRING 20 0 20 BudMod9Per04 Budget Model 9 Period 4      
SC1C086 NVARCHAR VSTRING 20 0 20 BudMod9Per05 Budget Model 9 Period 5      
SC1C087 NVARCHAR VSTRING 20 0 20 BudMod9Per06 Budget Model 9 Period 6      
SC1C088 NVARCHAR VSTRING 20 0 20 BudMod9Per07 Budget Model 9 Period 7      
SC1C089 NVARCHAR VSTRING 20 0 20 BudMod9Per08 Budget Model 9 Period 8      
SC1C090 NVARCHAR VSTRING 20 0 20 BudMod9Per09 Budget Model 9 Period 9      
SC1C091 NVARCHAR VSTRING 20 0 20 BudMod9Per10 Budget Model 9 Period 10      
SC1C092 NVARCHAR VSTRING 20 0 20 BudMod9Per11 Budget Model 9 Period 11      
SC1C093 NVARCHAR VSTRING 20 0 20 BudMod9Per12 Budget Model 9 Period 12      
SC1C094 NVARCHAR VSTRING 20 0 20 BudMod9Per13 Budget Model 9 Period 13      
SC1C095 NVARCHAR VSTRING 20 0 20 BudMod9Per14 Budget Model 9 Period 14      
SC1C096 NVARCHAR VSTRING 20 0 20 BudMod9Per15 Budget Model 9 Period 15      
SC1C097 NVARCHAR VSTRING 20 0 20 BudMod9Per16 Budget Model 9 Period 16      
SC1C098 NVARCHAR VSTRING 20 0 20 BudMod9Per17 Budget Model 9 Period 17      
SC1C099 NVARCHAR VSTRING 20 0 20 BudMod9Per18 Budget Model 9 Period 18      

Навигация / Navigation: