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

Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Таблица / Table MP58 — MPC Calculus Models

Таблица / Table: MP58 — «MPC Calculus Models». Маска имени таблицы / Table name mask: «MP58%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
MP58001 NCHAR STRING 6 0 6 ModelNo Model Number   1 Да / Yes
MP58002 NVARCHAR VSTRING 19 0 19 Text0 Line 00 Description      
MP58003 NVARCHAR VSTRING 3 0 3 Base0 Line 00 Base      
MP58004 NVARCHAR VSTRING 10 0 10 Constant0 Line 00 Constant      
MP58005 INT INTEGER 0 0 1 SumConcept0 Line 00 Summarisation Number      
MP58006 NVARCHAR VSTRING 19 0 19 Text1 Line 01 Description      
MP58007 NVARCHAR VSTRING 3 0 3 Base1 Line 01 Base      
MP58008 NVARCHAR VSTRING 10 0 10 Constant1 Line 01 Constant      
MP58009 INT INTEGER 0 0 1 SumConcept1 Line 01 Summarisation Number      
MP58010 NVARCHAR VSTRING 19 0 19 Text2 Line 02 Description      
MP58011 NVARCHAR VSTRING 3 0 3 Base2 Line 02 Base      
MP58012 NVARCHAR VSTRING 10 0 10 Constant2 Line 02 Constant      
MP58013 INT INTEGER 0 0 1 SumConcept2 Line 02 Summarisation Number      
MP58014 NVARCHAR VSTRING 19 0 19 Text3 Line 03 Description      
MP58015 NVARCHAR VSTRING 3 0 3 Base3 Line 03 Base      
MP58016 NVARCHAR VSTRING 10 0 10 Constant3 Line 03 Constant      
MP58017 INT INTEGER 0 0 1 SumConcept3 Line 03 Summarisation Number      
MP58018 NVARCHAR VSTRING 19 0 19 Text4 Line 04 Description      
MP58019 NVARCHAR VSTRING 3 0 3 Base4 Line 04 Base      
MP58020 NVARCHAR VSTRING 10 0 10 Constant4 Line 04 Constant      
MP58021 INT INTEGER 0 0 1 SumConcept4 Line 04 Summarisation Number      
MP58022 NVARCHAR VSTRING 19 0 19 Text5 Line 05 Description      
MP58023 NVARCHAR VSTRING 3 0 3 Base5 Line 05 Base      
MP58024 NVARCHAR VSTRING 10 0 10 Constant5 Line 05 Constant      
MP58025 INT INTEGER 0 0 1 SumConcept5 Line 05 Summarisation Number      
MP58026 NVARCHAR VSTRING 19 0 19 Text6 Line 06 Description      
MP58027 NVARCHAR VSTRING 3 0 3 Base6 Line 06 Base      
MP58028 NVARCHAR VSTRING 10 0 10 Constant6 Line 06 Constant      
MP58029 INT INTEGER 0 0 1 SumConcept6 Line 06 Summarisation Number      
MP58030 NVARCHAR VSTRING 19 0 19 Text7 Line 07 Description      
MP58031 NVARCHAR VSTRING 3 0 3 Base7 Line 07 Base      
MP58032 NVARCHAR VSTRING 10 0 10 Constant7 Line 07 Constant      
MP58033 INT INTEGER 0 0 1 SumConcept7 Line 07 Summarisation Number      
MP58034 NVARCHAR VSTRING 19 0 19 Text8 Line 08 Description      
MP58035 NVARCHAR VSTRING 3 0 3 Base8 Line 08 Base      
MP58036 NVARCHAR VSTRING 10 0 10 Constant8 Line 08 Constant      
MP58037 INT INTEGER 0 0 1 SumConcept8 Line 08 Summarisation Number      
MP58038 NVARCHAR VSTRING 19 0 19 Text9 Line 09 Description      
MP58039 NVARCHAR VSTRING 3 0 3 Base9 Line 09 Base      
MP58040 NVARCHAR VSTRING 10 0 10 Constant9 Line 09 Constant      
MP58041 INT INTEGER 0 0 1 SumConcept9 Line 09 Summarisation Number      
MP58042 NVARCHAR VSTRING 19 0 19 Text10 Line 10 Description      
MP58043 NVARCHAR VSTRING 3 0 3 Base10 Line 10 Base      
MP58044 NVARCHAR VSTRING 10 0 10 Constant10 Line 10 Constant      
MP58045 INT INTEGER 0 0 1 SumConcept10 Line 10 Summarisation Number      
MP58046 NVARCHAR VSTRING 19 0 19 Text11 Line 11 Description      
MP58047 NVARCHAR VSTRING 3 0 3 Base11 Line 11 Base      
MP58048 NVARCHAR VSTRING 10 0 10 Constant11 Line 11 Constant      
MP58049 INT INTEGER 0 0 1 SumConcept11 Line 11 Summarisation Number      
MP58050 NVARCHAR VSTRING 19 0 19 Text12 Line 12 Description      
MP58051 NVARCHAR VSTRING 3 0 3 Base12 Line 12 Base      
MP58052 NVARCHAR VSTRING 10 0 10 Constant12 Line 12 Constant      
MP58053 INT INTEGER 0 0 1 SumConcept12 Line 12 Summarisation Number      
MP58054 NVARCHAR VSTRING 19 0 19 Text13 Line 13 Description      
MP58055 NVARCHAR VSTRING 3 0 3 Base13 Line 13 Base      
MP58056 NVARCHAR VSTRING 10 0 10 Constant13 Line 13 Constant      
MP58057 INT INTEGER 0 0 1 SumConcept13 Line 13 Summarisation Number      
MP58058 NVARCHAR VSTRING 19 0 19 Text14 Line 14 Description      
MP58059 NVARCHAR VSTRING 3 0 3 Base14 Line 14 Base      
MP58060 NVARCHAR VSTRING 10 0 10 Constant14 Line 14 Constant      
MP58061 INT INTEGER 0 0 1 SumConcept14 Line 14 Summarisation Number      
MP58062 NVARCHAR VSTRING 19 0 19 DescSpcProd0 Specific Cost Bas X0 — Description      
MP58063 NVARCHAR VSTRING 19 0 19 DescSpcProd1 Specific Cost Bas X1 — Description      
MP58064 NVARCHAR VSTRING 19 0 19 DescSpcProd2 Specific Cost Bas X2 — Description      
MP58065 NVARCHAR VSTRING 19 0 19 DescSpcProd3 Specific Cost Bas X3 — Description      
MP58066 NVARCHAR VSTRING 11 0 11 DefFreeBase0 Free Base F0 — Description      
MP58067 NVARCHAR VSTRING 11 0 11 DefFreeBase1 Free Base F1 — Description      
MP58068 NVARCHAR VSTRING 11 0 11 DefFreeBase2 Free Base F2 — Description      
MP58069 NVARCHAR VSTRING 11 0 11 DefFreeBase3 Free Base F3 — Description      
MP58070 INT INTEGER 0 0 1 TypeIncrea0 Line 00 Overhead Sum      
MP58071 INT INTEGER 0 0 1 TypeIncrea1 Line 01 Overhead Sum      
MP58072 INT INTEGER 0 0 1 TypeIncrea2 Line 02 Overhead Sum      
MP58073 INT INTEGER 0 0 1 TypeIncrea3 Line 03 Overhead Sum      
MP58074 INT INTEGER 0 0 1 TypeIncrea4 Line 04 Overhead Sum      
MP58075 INT INTEGER 0 0 1 TypeIncrea5 Line 05 Overhead Sum      
MP58076 INT INTEGER 0 0 1 TypeIncrea6 Line 06 Overhead Sum      
MP58077 INT INTEGER 0 0 1 TypeIncrea7 Line 07 Overhead Sum      
MP58078 INT INTEGER 0 0 1 TypeIncrea8 Line 08 Overhead Sum      
MP58079 INT INTEGER 0 0 1 TypeIncrea9 Line 09 Overhead Sum      
MP58080 INT INTEGER 0 0 1 TypeIncrea10 Line 10 Overhead Sum      
MP58081 INT INTEGER 0 0 1 TypeIncrea11 Line 11 Overhead Sum      
MP58082 INT INTEGER 0 0 1 TypeIncrea12 Line 12 Overhead Sum      
MP58083 INT INTEGER 0 0 1 TypeIncrea13 Line 13 Overhead Sum      
MP58084 INT INTEGER 0 0 1 TypeIncrea14 Line 14 Overhead Sum      
MP58085 INT INTEGER 0 0 2 AccCode0 Line 00 Accounting Code      
MP58086 INT INTEGER 0 0 2 AccCode1 Line 01 Accounting Code      
MP58087 INT INTEGER 0 0 2 AccCode2 Line 02 Accounting Code      
MP58088 INT INTEGER 0 0 2 AccCode3 Line 03 Accounting Code      
MP58089 INT INTEGER 0 0 2 AccCode4 Line 04 Accounting Code      
MP58090 INT INTEGER 0 0 2 AccCode5 Line 05 Accounting Code      
MP58091 INT INTEGER 0 0 2 AccCode6 Line 06 Accounting Code      
MP58092 INT INTEGER 0 0 2 AccCode7 Line 07 Accounting Code      
MP58093 INT INTEGER 0 0 2 AccCode8 Line 08 Accounting Code      
MP58094 INT INTEGER 0 0 2 AccCode9 Line 09 Accounting Code      
MP58095 INT INTEGER 0 0 2 AccCode10 Line 10 Accounting Code      
MP58096 INT INTEGER 0 0 2 AccCode11 Line 11 Accounting Code      
MP58097 INT INTEGER 0 0 2 AccCode12 Line 12 Accounting Code      
MP58098 INT INTEGER 0 0 2 AccCode13 Line 13 Accounting Code      
MP58099 INT INTEGER 0 0 2 AccCode14 Line 14 Accounting Code      
MP58100 NVARCHAR VSTRING 25 0 25 ModelDescr Model Description      
MP58101 INT INTEGER 0 0 1 ActivityTypePR0 Line 00 Activity Type Project      
MP58102 INT INTEGER 0 0 1 ActivityTypePR1 Line 01 Activity Type Project      
MP58103 INT INTEGER 0 0 1 ActivityTypePR2 Line 02 Activity Type Project      
MP58104 INT INTEGER 0 0 1 ActivityTypePR3 Line 03 Activity Type Project      
MP58105 INT INTEGER 0 0 1 ActivityTypePR4 Line 04 Activity Type Project      
MP58106 INT INTEGER 0 0 1 ActivityTypePR5 Line 05 Activity Type Project      
MP58107 INT INTEGER 0 0 1 ActivityTypePR6 Line 06 Activity Type Project      
MP58108 INT INTEGER 0 0 1 ActivityTypePR7 Line 07 Activity Type Project      
MP58109 INT INTEGER 0 0 1 ActivityTypePR8 Line 08 Activity Type Project      
MP58110 INT INTEGER 0 0 1 ActivityTypePR9 Line 09 Activity Type Project      
MP58111 INT INTEGER 0 0 1 ActivityTypePR10 Line 10 Activity Type Project      
MP58112 INT INTEGER 0 0 1 ActivityTypePR11 Line 11 Activity Type Project      
MP58113 INT INTEGER 0 0 1 ActivityTypePR12 Line 12 Activity Type Project      
MP58114 INT INTEGER 0 0 1 ActivityTypePR13 Line 13 Activity Type Project      
MP58115 INT INTEGER 0 0 1 ActivityTypePR14 Line 14 Activity Type Project      

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