Таблица: MP75 - «Production Statistics». Маска имени таблицы: «MP75%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
MP75001 | NVARCHAR | VSTRING | 8 | 0 | 8 | Workcenter | Work Centre | |||
MP75002 | NCHAR | STRING | 10 | 0 | 10 | Workorder | Work Order | |||
MP75003 | NVARCHAR | VSTRING | 35 | 0 | 35 | WorkorderSC | Work Order Stock Item | |||
MP75004 | NVARCHAR | VSTRING | 35 | 0 | 35 | Phantom | Phantom Stock Item | |||
MP75005 | NCHAR | STRING | 3 | 0 | 3 | OperationNo | Operation Number | |||
MP75006 | NVARCHAR | VSTRING | 15 | 0 | 15 | SearchKey | Selection Term | |||
MP75007 | NVARCHAR | VSTRING | 15 | 0 | 15 | ToolNumber | Tool Number | |||
MP75008 | NVARCHAR | VSTRING | 8 | 0 | 8 | GroupFamily | Group Family | |||
MP75009 | NVARCHAR | VSTRING | 6 | 0 | 6 | FormanArea | Forman Area | |||
MP75010 | NVARCHAR | VSTRING | 8 | 0 | 8 | Department | Department | |||
MP75011 | NVARCHAR | VSTRING | 10 | 0 | 10 | Location | Location | |||
MP75012 | DATETIME | DATE | 0 | 0 | 8 | Date_ | Transaction Date | |||
MP75013 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Quantity | Quantity | |||
MP75014 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | PlanedQty | Quantity Planned | |||
MP75015 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | SetupTime | Setup Time | |||
MP75016 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | PlanSetupTime | Setup Time Planned | |||
MP75017 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | RunTime | Run Time | |||
MP75018 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | PlanRunTime | Run Time Planned | |||
MP75019 | NUMERIC | MONEY | 28 | 8 | 20 | FixOperatCst | Operation Cost Fixed | |||
MP75020 | NUMERIC | MONEY | 28 | 8 | 20 | VarOperatCst | Operation Cost Variable | |||
MP75021 | NUMERIC | MONEY | 28 | 8 | 20 | FixedCostWC | Work Centre Cost Fixed | |||
MP75022 | NUMERIC | MONEY | 28 | 8 | 20 | VaraibleWC | Work Centre Cost Variable | |||
MP75023 | NUMERIC | MONEY | 28 | 8 | 20 | SubcontrCost | Sub-contractor Cost | |||
MP75024 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | StopTime | Down Time | |||
MP75025 | NVARCHAR | VSTRING | 2 | 0 | 2 | StopCode | Down Time Code | |||
MP75026 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | ScrapQty | Scrap Quantity | |||
MP75027 | NVARCHAR | VSTRING | 2 | 0 | 2 | ScrapCode | Scrap Code | |||
MP75028 | NUMERIC | MONEY | 28 | 8 | 20 | ScrapCost | Scrap Cost | |||
MP75029 | NVARCHAR | VSTRING | 35 | 0 | 35 | Component | Stock Item Code Component | |||
MP75030 | NVARCHAR | VSTRING | 10 | 0 | 10 | Person | Person | |||
MP75031 | NCHAR | STRING | 8 | 0 | 8 | RecordNo | Record Number | 1 | Да | |
MP75032 | INT | INTEGER | 0 | 0 | 1 | Shift | Shift |
Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Material Production Control | Production Statistics