One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Список таблиц модуля «Управление Материалами в Производстве»/List of tables of module «Material Production Control»

Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317 :: Таблица / Table MP07 — Standard Cost Summary

Таблица / Table: MP07 — «MPC Std. Cost Summary». Маска имени таблицы / Table name mask: «MP07%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
MP07001 NCHAR STRING 35 0 35 StockItem Stock Item Code   2 Да / Yes
MP07002 NCHAR STRING 6 0 6 Warehouse Warehouse   3 Да / Yes
MP07003 NUMERIC MONEY 28 8 20 AmountSum1 Amount Summary 1      
MP07004 NUMERIC X_NUMERIC 20 8 12 PercStdCostSum1 Percent of Standard Cost Summary 1      
MP07005 NUMERIC MONEY 28 8 20 AmountSum2 Amount Summary 2      
MP07006 NUMERIC X_NUMERIC 20 8 12 PercStdCostSum2 Percent of Standard Cost Summary 2      
MP07007 NUMERIC MONEY 28 8 20 AmountSum3 Amount Summary 3      
MP07008 NUMERIC X_NUMERIC 20 8 12 PercStdCostSum3 Percent of Standard Cost Summary 3      
MP07009 NUMERIC MONEY 28 8 20 AmountSum4 Amount Summary 4      
MP07010 NUMERIC X_NUMERIC 20 8 12 PercStdCostSum4 Percent of Standard Cost Summary 4      
MP07011 NUMERIC MONEY 28 8 20 AmountSum5 Amount Summary 5      
MP07012 NUMERIC X_NUMERIC 20 8 12 PercStdCostSum5 Percent of Standard Cost Summary 5      
MP07013 NUMERIC MONEY 28 8 20 AmountSum6 Amount Summary 6      
MP07014 NUMERIC X_NUMERIC 20 8 12 PercStdCostSum6 Percent of Standard Cost Summary 6      
MP07015 NUMERIC MONEY 28 8 20 AmountSum7 Amount Summary 7      
MP07016 NUMERIC X_NUMERIC 20 8 12 PercStdCostSum7 Percent of Standard Cost Summary 7      
MP07017 NUMERIC MONEY 28 8 20 AmountSum8 Amount Summary 8      
MP07018 NUMERIC X_NUMERIC 20 8 12 PercStdCostSum8 Percent of Standard Cost Summary 8      
MP07019 NUMERIC MONEY 28 8 20 AmountSum9 Amount Summary 9      
MP07020 NUMERIC X_NUMERIC 20 8 12 PercStdCostSum9 Percent of Standard Cost Summary 9      
MP07021 NCHAR STRING 1 0 1 Type Type   1 Да / Yes

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