Таблица: MP63 - «Routings». Маска имени таблицы: «MP63%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
MP63001 | NCHAR | STRING | 1 | 0 | 1 | OperationType | Operation Type | 1 | Да | |
MP63002 | NCHAR | STRING | 35 | 0 | 35 | ParentItem | Parent Stock Item | 2 | Да | |
MP63003 | NCHAR | STRING | 2 | 0 | 2 | Alternate | Alternate Routing | 3 | Да | |
MP63004 | NCHAR | STRING | 3 | 0 | 3 | OperationNo | Operation Number | 4 | Да | |
MP63005 | INT | INTEGER | 0 | 0 | 1 | OPType | Work Centre Is Sub Contractor | |||
MP63006 | NVARCHAR | VSTRING | 20 | 0 | 20 | Description | Description | |||
MP63007 | NVARCHAR | VSTRING | 8 | 0 | 8 | WorkCenter | Work Centre | |||
MP63008 | NVARCHAR | VSTRING | 15 | 0 | 15 | ToolNumber | Tool Number | |||
MP63009 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | SetupTime1 | Setup Time 1 | |||
MP63010 | NUMERIC | X_NUMERIC | 16 | 8 | 8 | ProductRate1 | Production Rate 1 | |||
MP63011 | NUMERIC | X_NUMERIC | 17 | 8 | 9 | RunTime1 | Run Time 1 | |||
MP63012 | NVARCHAR | VSTRING | 9 | 0 | 9 | Spare | (obsolete) | |||
MP63013 | NCHAR | STRING | 3 | 0 | 3 | CodeOpenRunTime | Open Time Code | |||
MP63014 | NVARCHAR | VSTRING | 3 | 0 | 3 | Spare | (obsolete) | |||
MP63015 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | QueueTime | Queue Time | |||
MP63016 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | MoveTime | Move Time | |||
MP63017 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | Overlap | Overlapping Time | |||
MP63018 | NUMERIC | MONEY | 28 | 8 | 20 | SubcontrCost | Sub-contractor Cost | |||
MP63019 | NVARCHAR | VSTRING | 3 | 0 | 3 | CostCode | Cost Code | |||
MP63020 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | SetupCrew | Setup Crew Number | |||
MP63021 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | RunCrew | Run Crew Number | |||
MP63022 | INT | INTEGER | 0 | 0 | 2 | NumberOfTime | Job Tickets | |||
MP63023 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | SetupTime2 | Setup Time 2 | |||
MP63024 | NUMERIC | X_NUMERIC | 16 | 8 | 8 | ProductRate2 | Production Rate 2 | |||
MP63025 | NUMERIC | X_NUMERIC | 17 | 8 | 9 | RunTime2 | Run Time 2 | |||
MP63026 | INT | INTEGER | 0 | 0 | 1 | TextCode | Text Code Exist | |||
MP63027 | NVARCHAR | ACCSTR | 50 | 0 | 50 | AccString | Accounting String | |||
MP63028 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | (obsolete) | |||
MP63029 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | (obsolete) | |||
MP63030 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | (obsolete) | |||
MP63031 | INT | INTEGER | 0 | 0 | 2 | AccCode | Accounting Code | |||
MP63032 | NUMERIC | X_NUMERIC | 12 | 8 | 4 | NoResources | Number of Resources | |||
MP63033 | INT | INTEGER | 0 | 0 | 5 | LeadTime | Lead Time | |||
MP63034 | NUMERIC | X_NUMERIC | 12 | 8 | 4 | ScrapFactor | Scrap % | |||
MP63035 | NVARCHAR | VSTRING | 3 | 0 | 3 | ProductiCode | Production Code | |||
MP63036 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | (obsolete) | |||
MP63037 | NVARCHAR | VSTRING | 35 | 0 | 35 | ReturnItem | Return Stock Item | |||
MP63038 | NVARCHAR | VSTRING | 1 | 0 | 1 | WeightType | Weight Type | |||
MP63039 | NVARCHAR | VSTRING | 1 | 0 | 1 | RulePrinting | Printing Rule | |||
MP63040 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | Quantity | Quantity | |||
MP63041 | NVARCHAR | VSTRING | 1 | 0 | 1 | OpType | Type | |||
MP63042 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | YieldFactor | Yield Factor | |||
MP63043 | NVARCHAR | VSTRING | 2 | 0 | 2 | CompSetupTime | Competence - Setup Time | |||
MP63044 | NVARCHAR | VSTRING | 2 | 0 | 2 | CompetRunTime | Competence - Run Time | |||
MP63045 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | SetupTimeInner | Setup Time Inner | |||
MP63046 | NCHAR | SWITCH | 1 | 0 | 1 | Dispatching | Dispatching | |||
MP63047 | NUMERIC | MONEY | 28 | 8 | 20 | StandardCost | Standard Cost | |||
MP63048 | NCHAR | SWITCH | 1 | 0 | 1 | NotDependVolume | Volume Independent | |||
MP63049 | NVARCHAR | VSTRING | 1 | 0 | 1 | CriticalOperation | Is Critical Operation | |||
MP63050 | NCHAR | SWITCH | 1 | 0 | 1 | GRPMainOP | GRP Main Operation | |||
MP63051 | NVARCHAR | VSTRING | 1 | 0 | 1 | Spare | (obsolete) | |||
MP63052 | NVARCHAR | VSTRING | 12 | 0 | 12 | Spare | (obsolete) |
Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Material Production Control | Routings