Таблица: MP76 - «Actual Cost Head». Маска имени таблицы: «MP76%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
MP76001 | NCHAR | STRING | 10 | 0 | 10 | WorkorderNO | Work Order Number | 1 | Да | |
MP76002 | NVARCHAR | VSTRING | 35 | 0 | 35 | StockCode | Stock Item Code | |||
MP76003 | NVARCHAR | VSTRING | 6 | 0 | 6 | Warehouse | Warehouse | |||
MP76004 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | PlannedQty | Quantity Planned | |||
MP76005 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | ManufactQty | Quantity Manufactured | |||
MP76006 | NVARCHAR | VSTRING | 2 | 0 | 2 | Alternate | Alternate Routing | |||
MP76007 | NVARCHAR | VSTRING | 10 | 0 | 10 | CustomerNo | Customer Code | |||
MP76008 | NCHAR | STRING | 10 | 0 | 10 | SalesOrderNo | Sales Order Number | |||
MP76009 | NCHAR | STRING | 6 | 0 | 6 | SalesOrdLine | Sales Order Line Number | |||
MP76010 | DATETIME | DATE | 0 | 0 | 8 | DueDate | Due Date | |||
MP76011 | NVARCHAR | VSTRING | 15 | 0 | 15 | Planner | Planner | |||
MP76012 | NVARCHAR | VSTRING | 15 | 0 | 15 | SelectioTerm | Selection Term | |||
MP76013 | INT | INTEGER | 0 | 0 | 3 | PlanLeadtime | Planned Lead Time | |||
MP76014 | INT | INTEGER | 0 | 0 | 3 | Leadtime | Lead Time | |||
MP76015 | NVARCHAR | VSTRING | 12 | 0 | 12 | BatchNumber | Batch Number | |||
MP76016 | NCHAR | SWITCH | 1 | 0 | 1 | SumActualCst | Actual Cost is Summarized | |||
MP76017 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | Material Shortage | |||
MP76018 | NVARCHAR | ACCSTR | 50 | 0 | 50 | AccString | Accounting String | |||
MP76019 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | (obsolete) | |||
MP76020 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | (obsolete) | |||
MP76021 | INT | INTEGER | 0 | 0 | 2 | AccCode | Accounting Code | |||
MP76022 | DATETIME | DATE | 0 | 0 | 8 | ActStartDate | Actual Start Date | |||
MP76023 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | TotalScrap | Total Scrap | |||
MP76024 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | NoUnitsLot | Number of Units per Lot | |||
MP76025 | NUMERIC | X_NUMERIC | 16 | 8 | 8 | SizeOfLot | Size of Lot | |||
MP76026 | DATETIME | DATE | 0 | 0 | 8 | PlanStartDate | Planned Start Date | |||
MP76027 | DATETIME | DATE | 0 | 0 | 8 | PlanDueDate | Planned Due Date | |||
MP76028 | NUMERIC | X_NUMERIC | 12 | 8 | 4 | ScrapFactor | Scrap % | |||
MP76029 | NCHAR | STRING | 6 | 0 | 6 | ORStructLine | Sales Order Sub-line Number | |||
MP76030 | INT | INTEGER | 0 | 0 | 10 | VersionStock | Version Stock Item | |||
MP76031 | INT | INTEGER | 0 | 0 | 10 | VersionBoM | Version BOM | |||
MP76032 | INT | INTEGER | 0 | 0 | 10 | VersionOperations | Version Operation | |||
MP76033 | NVARCHAR | VSTRING | 20 | 0 | 20 | DrawingNo | Drawing Number | |||
MP76034 | NCHAR | STRING | 4 | 0 | 4 | DelivLineNo | Delivery Line Number | |||
MP76035 | NVARCHAR | VSTRING | 3 | 0 | 3 | Spare | (obsolete) | |||
MP76036 | NVARCHAR | VSTRING | 3 | 0 | 3 | Spare | (obsolete) | |||
MP76037 | NVARCHAR | VSTRING | 3 | 0 | 3 | Spare | (obsolete) | |||
MP76038 | NVARCHAR | VSTRING | 3 | 0 | 3 | Spare | (obsolete) | |||
MP76039 | NVARCHAR | VSTRING | 3 | 0 | 3 | Spare | (obsolete) | |||
MP76040 | NVARCHAR | VSTRING | 20 | 0 | 20 | Spare | Standard Cost | |||
MP76041 | NVARCHAR | VSTRING | 20 | 0 | 20 | Spare | (obsolete) |
Навигация: Структура БД iScala | iScala 2.2 HF 2.3318 - 2.02.3318 | Material Production Control | Actual Cost Head