Таблица: MP66 - «WO BOM, Issue». Маска имени таблицы: «MP66%cc00»
Поле | Тип поля | Тип поля iScala | Длина поля | Точность | Длина iScala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
MP66001 | NCHAR | STRING | 10 | 0 | 10 | WorkOrderNo | Work Order Number | 1 | Да | |
MP66002 | NCHAR | STRING | 10 | 0 | 10 | ReportNo | Report Number | 2 | Да | |
MP66003 | NCHAR | STRING | 4 | 0 | 4 | Numer | Number | 3 | Да | |
MP66004 | NCHAR | STRING | 35 | 0 | 35 | Component | Stock Item Code Component | 4 | Да | |
MP66005 | NCHAR | STRING | 4 | 0 | 4 | IssueLineNo | Issue Line Number | 5 | Да | |
MP66006 | NVARCHAR | VSTRING | 12 | 0 | 12 | BatchNo | Batch ID | |||
MP66007 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | QtyReservedMP | Quantity Reserved (MP Unit) | |||
MP66008 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | QtyReservedSC | Quantity Reserved (Stock Unit) | |||
MP66009 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | QtyIssuedMP | Quantity Issued (MP Unit) | |||
MP66010 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | QtyIssuecdSC | Quantity Issued (Stock Unit) | |||
MP66011 | DATETIME | DATE | 0 | 0 | 8 | PlanIssueDateMP66 | Planned Issue Date | |||
MP66012 | DATETIME | DATE | 0 | 0 | 8 | ActualIssueDate | Actual Issue Date | |||
MP66013 | INT | INTEGER | 0 | 0 | 6 | ActualIssueTime | Actual Issue Time | |||
MP66014 | NUMERIC | MONEY | 28 | 8 | 20 | UnitCostPrice | Unit Cost Price | |||
MP66015 | NVARCHAR | VSTRING | 6 | 0 | 6 | WareHouse | Warehouse | |||
MP66016 | NCHAR | STRING | 12 | 0 | 12 | UsedToBatch | Used to Batch | |||
MP66017 | NCHAR | SWITCH | 1 | 0 | 1 | CreatedByPickRequest | Created by Picking Request |
Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Material Production Control | Work Order BOM Issues