Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: MP65 - «WO BOM» («Зак.на работу, Список мат-лов»)
| Поле | Тип поля Scala | Длина Scala | Комментарий | Первичный ключ? |
| MP65001 | STRING | 10 | WorkOrderNo | Да |
| MP65002 | STRING | 10 | ReportNo | Да |
| MP65003 | STRING | 4 | Number | Да |
| MP65004 | STRING | 35 | Component | Да |
| MP65005 | STRING | 3 | CodeOpenItem | |
| MP65006 | VSTRING | 10 | Reference | |
| MP65007 | X_NUMERIC | 20 | Quantity | |
| MP65008 | STRING | 3 | CodeOpenQty | |
| MP65009 | VSTRING | 3 | Spare | |
| MP65010 | X_NUMERIC | 4 | ScrapFactor | |
| MP65011 | VSTRING | 6 | WareHouse | |
| MP65012 | VSTRING | 35 | ParentItem | |
| MP65013 | VSTRING | 4 | Spare | |
| MP65014 | SWITCH | 1 | NotDependVol | |
| MP65015 | DATE | 8 | MaterResDate | |
| MP65016 | X_NUMERIC | 12 | IssuedQty | |
| MP65017 | VSTRING | 1 | TextCode | |
| MP65018 | SWITCH | 1 | DependingLot | |
| MP65019 | SWITCH | 1 | Released | |
| MP65020 | VSTRING | 1 | Spare | |
| MP65021 | X_NUMERIC | 12 | WOQuantity | |
| MP65022 | X_NUMERIC | 12 | ReservedQty | |
| MP65023 | SWITCH | 1 | OptionRegistered | |
| MP65024 | SWITCH | 1 | OpenQtyReg | |
| MP65025 | X_NUMERIC | 12 | TotalScrap | |
| MP65026 | SWITCH | 1 | ActCostItem | |
| MP65027 | STRING | 10 | ParentRepNo | |
| MP65028 | INTEGER | 12 | InternalCounter | |
| MP65029 | X_NUMERIC | 12 | BoMQuantity | |
| MP65030 | MONEY | 20 | PlanMtrlCost | |
| MP65031 | MONEY | 20 | ActMtrlCost | |
| MP65032 | MONEY | 20 | StdCostPrice | |
| MP65033 | MONEY | 20 | WIPAmount | |
| MP65034 | INTEGER | 3 | Level | |
| MP65035 | STRING | 10 | MadeWrkOrdNo | |
| MP65036 | INTEGER | 2 | UnitCode | |
| MP65037 | VSTRING | 8 | AssemblyStation | |
| MP65038 | INTEGER | 1 | SparePartCode | |
| MP65039 | X_NUMERIC | 7 | Distribution | |
| MP65040 | STRING | 10 | RepNoMaterial | |
| MP65041 | X_NUMERIC | 10 | UnitConvFactor | |
| MP65042 | STRING | 3 | OperationNo | |
| MP65043 | SWITCH | 1 | CriticalMaterial | |
| MP65044 | SWITCH | 1 | BoundToOrder | |
| MP65045 | STRING | 10 | PurchOrderNo | |
| MP65046 | STRING | 9 | PurchOrdLine | |
| MP65047 | STRING | 4 | DelivLineNo | |
| MP65048 | VSTRING | 12 | Spare | |
| MP65049 | VSTRING | 12 | Spare | |
| MP65050 | VSTRING | 3 | Spare | |
| MP65051 | VSTRING | 3 | Spare | |
| MP65052 | VSTRING | 20 | Spare | |
| MP65053 | VSTRING | 12 | ProjectNumber | |
| MP65054 | VSTRING | 6 | SubProjectNumber | |
| MP65055 | VSTRING | 6 | ActivityLine | |
| MP65056 | VSTRING | 3 | ActivityStructLine |
Навигация: Структура БД Scala/iScala | Scala 5.1 SR13 | MPC (Управление Производством) | WO BOM (Зак.на работу, Список мат-лов)
/* */