One level Up / One level Up: Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Список таблиц модуля «Material Production Control»

Структура таблиц Epicor iScala 3.0 FSP4 — 3.0.4267 :: Таблица MP0B — Distribution File

Таблица: MP0B — «Distribution File». Маска имени таблицы: «MP0B%cc00»

Поле Тип поля Тип поля Scala Длина поля Точ­ность Длина Scala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
MP0B001 NCHAR STRING 6 0 6 Number Distribution Number   1 Да
MP0B002 NCHAR STRING 10 0 10 Section Segment Code   2 Да
MP0B003 NCHAR STRING 4 0 4 Year_ Year   3 Да
MP0B004 NVARCHAR VSTRING 30 0 30 Description Description      
MP0B005 NVARCHAR VSTRING 1 0 1 MonthWeek Month or Week 0 — Month based distribution
1 — Week based distribution
   
MP0B006 NVARCHAR VSTRING 1 0 1 EvenDistribution Use Even Distribution      
MP0B007 NVARCHAR VSTRING 4 0 4 Field1 Percentage Month 1/Week 1      
MP0B008 NVARCHAR VSTRING 4 0 4 Field2 Percentage Month 2/Week 2      
MP0B009 NVARCHAR VSTRING 4 0 4 Field3 Percentage Month 3/Week 3      
MP0B010 NVARCHAR VSTRING 4 0 4 Field4 Percentage Month 4/Week 4      
MP0B011 NVARCHAR VSTRING 4 0 4 Field5 Percentage Month 5/Week 5      
MP0B012 NVARCHAR VSTRING 4 0 4 Field6 Percentage Month 6/Week 6      
MP0B013 NVARCHAR VSTRING 4 0 4 Field7 Percentage Month 7/Week 7      
MP0B014 NVARCHAR VSTRING 4 0 4 Field8 Percentage Month 8/Week 8      
MP0B015 NVARCHAR VSTRING 4 0 4 Field9 Percentage Month 9/Week 9      
MP0B016 NVARCHAR VSTRING 4 0 4 Field10 Percentage Month 10/Week 10      
MP0B017 NVARCHAR VSTRING 4 0 4 Field11 Percentage Month 11/Week 11      
MP0B018 NVARCHAR VSTRING 4 0 4 Field12 Percentage Month 12/Week 12      
MP0B019 NVARCHAR VSTRING 4 0 4 Field13 Percentage Week 13      
MP0B020 NVARCHAR VSTRING 4 0 4 Field14 Percentage Week 14      
MP0B021 NVARCHAR VSTRING 4 0 4 Field15 Percentage Week 15      
MP0B022 NVARCHAR VSTRING 4 0 4 Field16 Percentage Week 16      
MP0B023 NVARCHAR VSTRING 4 0 4 Field17 Percentage Week 17      
MP0B024 NVARCHAR VSTRING 4 0 4 Field18 Percentage Week 18      
MP0B025 NVARCHAR VSTRING 4 0 4 Field19 Percentage Week 19      
MP0B026 NVARCHAR VSTRING 4 0 4 Field20 Percentage Week 20      
MP0B027 NVARCHAR VSTRING 4 0 4 Field21 Percentage Week 21      
MP0B028 NVARCHAR VSTRING 4 0 4 Field22 Percentage Week 22      
MP0B029 NVARCHAR VSTRING 4 0 4 Field23 Percentage Week 23      
MP0B030 NVARCHAR VSTRING 4 0 4 Field24 Percentage Week 24      
MP0B031 NVARCHAR VSTRING 4 0 4 Field25 Percentage Week 25      
MP0B032 NVARCHAR VSTRING 4 0 4 Field26 Percentage Week 26      
MP0B033 NVARCHAR VSTRING 4 0 4 Field27 Percentage Week 27      
MP0B034 NVARCHAR VSTRING 4 0 4 Field28 Percentage Week 28      
MP0B035 NVARCHAR VSTRING 4 0 4 Field29 Percentage Week 29      
MP0B036 NVARCHAR VSTRING 4 0 4 Field30 Percentage Week 30      
MP0B037 NVARCHAR VSTRING 4 0 4 Field31 Percentage Week 31      
MP0B038 NVARCHAR VSTRING 4 0 4 Field32 Percentage Week 32      
MP0B039 NVARCHAR VSTRING 4 0 4 Field33 Percentage Week 33      
MP0B040 NVARCHAR VSTRING 4 0 4 Field34 Percentage Week 34      
MP0B041 NVARCHAR VSTRING 4 0 4 Field35 Percentage Week 35      
MP0B042 NVARCHAR VSTRING 4 0 4 Field36 Percentage Week 36      
MP0B043 NVARCHAR VSTRING 4 0 4 Field37 Percentage Week 37      
MP0B044 NVARCHAR VSTRING 4 0 4 Field38 Percentage Week 38      
MP0B045 NVARCHAR VSTRING 4 0 4 Field39 Percentage Week 39      
MP0B046 NVARCHAR VSTRING 4 0 4 Field40 Percentage Week 40      
MP0B047 NVARCHAR VSTRING 4 0 4 Field41 Percentage Week 41      
MP0B048 NVARCHAR VSTRING 4 0 4 Field42 Percentage Week 42      
MP0B049 NVARCHAR VSTRING 4 0 4 Field43 Percentage Week 43      
MP0B050 NVARCHAR VSTRING 4 0 4 Field44 Percentage Week 44      
MP0B051 NVARCHAR VSTRING 4 0 4 Field45 Percentage Week 45      
MP0B052 NVARCHAR VSTRING 4 0 4 Field46 Percentage Week 46      
MP0B053 NVARCHAR VSTRING 4 0 4 Field47 Percentage Week 47      
MP0B054 NVARCHAR VSTRING 4 0 4 Field48 Percentage Week 48      
MP0B055 NVARCHAR VSTRING 4 0 4 Field49 Percentage Week 49      
MP0B056 NVARCHAR VSTRING 4 0 4 Field50 Percentage Week 50      
MP0B057 NVARCHAR VSTRING 4 0 4 Field51 Percentage Week 51      
MP0B058 NVARCHAR VSTRING 4 0 4 Field52 Percentage Week 52      
MP0B059 NVARCHAR VSTRING 4 0 4 Field53 Percentage Week 53      

Навигация: