Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else... / Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще...
Таблица: MP91 - «WIP Transact. I». Маска имени таблицы: «MP91%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
MP91001 | NCHAR | STRING | 10 | 0 | 10 | WorkOrder | Work Order Number | 1 | Да | |
MP91002 | NCHAR | STRING | 2 | 0 | 2 | Type | Transaction Type | 01 - Product cost material
02 - Product cost routing 10 - Actual cost work order 11 - Actual cost material 12 - Actual cost routing 20 - Batch |
2 | Да |
MP91003 | NCHAR | STRING | 12 | 0 | 12 | ReporBatchNo | Report Number or Batch ID | 3 | Да | |
MP91004 | NCHAR | STRING | 4 | 0 | 4 | OperationNo | Operation Number | 4 | Да | |
MP91005 | NCHAR | STRING | 35 | 0 | 35 | Component | Stock Item Code Component | 5 | Да | |
MP91006 | NCHAR | STRING | 4 | 0 | 4 | Number | Line Number | 6 | Да | |
MP91007 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Quantity | Quantity | |||
MP91008 | NUMERIC | MONEY | 28 | 8 | 20 | Value | Amount (Local Currency) | |||
MP91009 | DATETIME | DATE | 0 | 0 | 8 | Date_ | Transaction Date | |||
MP91010 | INT | INTEGER | 0 | 0 | 2 | AccCode | Accounting Code | |||
MP91011 | NVARCHAR | ACCSTR | 50 | 0 | 50 | AccString | Accounting String | |||
MP91012 | NVARCHAR | VSTRING | 4 | 0 | 4 | Spare | (obsolete) | |||
MP91013 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | (obsolete) | |||
MP91014 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | (obsolete) | |||
MP91015 | NVARCHAR | VSTRING | 25 | 0 | 25 | Text | Text | |||
MP91016 | NVARCHAR | VSTRING | 8 | 0 | 8 | WorkCentre | Work Centre | |||
MP91017 | NVARCHAR | VSTRING | 15 | 0 | 15 | Tool | Tool Number | |||
MP91018 | NVARCHAR | VSTRING | 6 | 0 | 6 | Warehouse | Warehouse | |||
MP91019 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | SetUpTime | Setup Time | |||
MP91020 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | RunTime | Run Time | |||
MP91021 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | RunCrew | Run Crew | |||
MP91022 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | SetUpCrew | Setup Crew | |||
MP91023 | NUMERIC | MONEY | 28 | 8 | 20 | SubcontrCost | Sub-contractor Cost | |||
MP91024 | NUMERIC | MONEY | 28 | 8 | 20 | SetUpCost | Setup Cost | |||
MP91025 | NUMERIC | MONEY | 28 | 8 | 20 | RunCost | Run Cost | |||
MP91026 | NUMERIC | MONEY | 28 | 8 | 20 | VarWrkCtrCst | Work Centre Cost Fixed | |||
MP91027 | NUMERIC | MONEY | 28 | 8 | 20 | FixWrkCtrCst | Work Centre Cost Variable | |||
MP91028 | NUMERIC | MONEY | 28 | 8 | 20 | VarToolCost | Tool Cost Variable | |||
MP91029 | NUMERIC | MONEY | 28 | 8 | 20 | FixToolCost | Tool Cost Fixed | |||
MP91030 | INT | INTEGER | 0 | 0 | 1 | Status | Status | |||
MP91031 | NUMERIC | MONEY | 28 | 8 | 20 | WrkCtrOverhead | Work Centre Overhead | |||
MP91032 | NUMERIC | MONEY | 28 | 8 | 20 | AmountCC | Amount (Alternative Currency) | |||
MP91033 | NCHAR | STRING | 8 | 0 | 8 | Spare | Index Counter |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Material Production Control | WIP Transactions