Таблица: MP86 - «C.order -> WO 2». Маска имени таблицы: «MP86%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
MP86001 | NCHAR | STRING | 1 | 0 | 1 | RecordType1 | Record Type 1 | 1 | Да | |
MP86002 | NCHAR | STRING | 1 | 0 | 1 | RecordType2 | Record Type 2 | 1 = Answer to open item and/or quantity
2 = Answer to open time 3 = Accessory 4 = Text |
2 | Да |
MP86003 | NCHAR | STRING | 10 | 0 | 10 | OrderNo | Sales Order Number | 3 | Да | |
MP86004 | NCHAR | STRING | 6 | 0 | 6 | SalOrdLineNo | Sales Order Line Number | 4 | Да | |
MP86005 | NCHAR | STRING | 6 | 0 | 6 | SOrdSubLine | Sales Order Sub-line Number | 5 | Да | |
MP86006 | NCHAR | STRING | 3 | 0 | 3 | Sequence | Sequence | 6 | Да | |
MP86007 | NCHAR | STRING | 35 | 0 | 35 | NoAccText | Line Number or Stock Item Code | 7 | Да | |
MP86008 | NVARCHAR | VSTRING | 83 | 0 | 83 | CoWo2AddrKey | Reference Key | |||
MP86009 | NVARCHAR | VSTRING | 35 | 0 | 35 | ParentScode | Parent Stock Item | |||
MP86010 | NCHAR | STRING | 10 | 0 | 10 | WorkOrdNoID4 | Work Order Number | |||
MP86011 | NVARCHAR | VSTRING | 35 | 0 | 35 | ConfigurList | Configuration ID | |||
MP86012 | INT | INTEGER | 0 | 0 | 6 | RevisionNo | Revision Number | |||
MP86013 | NCHAR | SWITCH | 1 | 0 | 1 | PrintOutFlag | ||||
MP86014 | NCHAR | SWITCH | 1 | 0 | 1 | SearchFlag | Search | |||
MP86015 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | OpenQuantity | Open Quantity | |||
MP86016 | NUMERIC | X_NUMERIC | 12 | 8 | 4 | OpScrapFactor | Open Scrap % | |||
MP86017 | NVARCHAR | VSTRING | 35 | 0 | 35 | OpenItem | Open Item | |||
MP86018 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | OpenSetupTime | Open Setup Time | |||
MP86019 | NUMERIC | X_NUMERIC | 17 | 8 | 9 | OpenRunTime | Open Run Time | |||
MP86020 | NVARCHAR | VSTRING | 8 | 0 | 8 | WrkCentreACC | Work Centre for Accessories | |||
MP86021 | NVARCHAR | VSTRING | 6 | 0 | 6 | WarehouseAcc | Warehouse for Accessories | |||
MP86022 | NCHAR | STRING | 10 | 0 | 10 | ReportNo | Report Number | |||
MP86023 | NCHAR | STRING | 4 | 0 | 4 | NoFromSC65 | Number | |||
MP86024 | NCHAR | STRING | 3 | 0 | 3 | OperatioSC67 | Operation Number | |||
MP86025 | NVARCHAR | VSTRING | 35 | 0 | 35 | OldOpenItem | Old Open Item | |||
MP86026 | NCHAR | STRING | 3 | 0 | 3 | QueryNoOpItm | Open Component Code | |||
MP86027 | NCHAR | STRING | 3 | 0 | 3 | QueryNoOpQty | Open Quantity Code | |||
MP86028 | NCHAR | STRING | 3 | 0 | 3 | QueryNoOpTime | Open Time Code | |||
MP86029 | NUMERIC | MONEY | 28 | 8 | 20 | SellingPrice | Selling Price |
Навигация: Структура БД iScala | iScala 2.2 HF 2.3318 - 2.02.3318 | Material Production Control | Customer Order to Work Order 2