Таблица: MP9W - «WIP Transactions History». Маска имени таблицы: «MP9W%cc00»
| Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
| MP9W001 | NCHAR | STRING | 10 | 0 | 10 | WorkOrder | Work Order | 1 | Да | |
| MP9W002 | NCHAR | STRING | 2 | 0 | 2 | Type | Transaction Type | 2 | Да | |
| MP9W003 | NCHAR | STRING | 12 | 0 | 12 | ReporBatchNo | Report Number or Batch ID | 3 | Да | |
| MP9W004 | NCHAR | STRING | 4 | 0 | 4 | OperationNo | Operation Number | 4 | Да | |
| MP9W005 | NCHAR | STRING | 35 | 0 | 35 | Component | Stock Item Code Component | 5 | Да | |
| MP9W006 | NCHAR | STRING | 4 | 0 | 4 | Number | Line Number | 6 | Да | |
| MP9W007 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Quantity | Quantity | |||
| MP9W008 | NUMERIC | MONEY | 28 | 8 | 20 | Value | Amount (Local Currency) | |||
| MP9W009 | DATETIME | DATE | 0 | 0 | 8 | Date_ | Transaction Date | |||
| MP9W010 | INT | INTEGER | 0 | 0 | 2 | AccCode | Accounting Code | |||
| MP9W011 | NVARCHAR | ACCSTR | 50 | 0 | 50 | AccString | Accounting String | |||
| MP9W012 | NVARCHAR | VSTRING | 4 | 0 | 4 | Spare | (obsolete) | |||
| MP9W013 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | (obsolete) | |||
| MP9W014 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | (obsolete) | |||
| MP9W015 | NVARCHAR | VSTRING | 25 | 0 | 25 | Text | Text | |||
| MP9W016 | NVARCHAR | VSTRING | 8 | 0 | 8 | WorkCentre | Work Centre | |||
| MP9W017 | NVARCHAR | VSTRING | 15 | 0 | 15 | Tool | Tool Number | |||
| MP9W018 | NVARCHAR | VSTRING | 6 | 0 | 6 | Warehouse | Warehouse | |||
| MP9W019 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | SetUpTime | Setup Time | |||
| MP9W020 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | RunTime | Run Time | |||
| MP9W021 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | RunCrew | Run Crew | |||
| MP9W022 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | SetUpCrew | Setup Crew | |||
| MP9W023 | NUMERIC | MONEY | 28 | 8 | 20 | SubcontrCost | Sub-contractor Cost | |||
| MP9W024 | NUMERIC | MONEY | 28 | 8 | 20 | SetUpCost | Setup Cost | |||
| MP9W025 | NUMERIC | MONEY | 28 | 8 | 20 | RunCost | Run Cost | |||
| MP9W026 | NUMERIC | MONEY | 28 | 8 | 20 | VarWrkCtrCst | Work Centre Cost Variable | |||
| MP9W027 | NUMERIC | MONEY | 28 | 8 | 20 | FixWrkCtrCst | Work Centre Cost Fixed | |||
| MP9W028 | NUMERIC | MONEY | 28 | 8 | 20 | VarToolCost | Tool Cost Variable | |||
| MP9W029 | NUMERIC | MONEY | 28 | 8 | 20 | FixToolCost | Tool Cost Fixed | |||
| MP9W030 | INT | INTEGER | 0 | 0 | 1 | Status | Status | |||
| MP9W031 | NUMERIC | MONEY | 28 | 8 | 20 | WrkCtrOverhead | Work Centre Overhead | |||
| MP9W032 | NUMERIC | MONEY | 28 | 8 | 20 | AmountCC | Amount (Alternative Currency) | |||
| MP9W033 | NCHAR | STRING | 8 | 0 | 8 | Spare | Index Counter |
Навигация: Структура БД iScala | Epicor iScala 2.3 SR1 - 2.03.8155 | Material Production Control | WIP Transactions History
/* */