Таблица: MP67 - «WO Routings». Маска имени таблицы: «MP67%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
MP67001 | NCHAR | STRING | 10 | 0 | 10 | WorkOrderNo | Work Order Number | 1 | Да | |
MP67002 | NCHAR | STRING | 10 | 0 | 10 | RportingNo | Report Number | 2 | Да | |
MP67003 | NCHAR | STRING | 3 | 0 | 3 | OperationNo | Operation Number | 3 | Да | |
MP67004 | INT | INTEGER | 0 | 0 | 1 | OpType | Work Centre Is Sub Contractor | |||
MP67005 | NVARCHAR | VSTRING | 20 | 0 | 20 | Description | Description | |||
MP67006 | NVARCHAR | VSTRING | 8 | 0 | 8 | WorkCenter | Work Centre | |||
MP67007 | NVARCHAR | VSTRING | 15 | 0 | 15 | ToolNumber | Tool Number | |||
MP67008 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | SetupTime1 | Setup Time 1 | |||
MP67009 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | ProductionRate1 | Production Rate 1 | |||
MP67010 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | RunTime1 | Run Time 1 | |||
MP67011 | NVARCHAR | VSTRING | 9 | 0 | 9 | Spare | (obsolete) | |||
MP67012 | NCHAR | STRING | 3 | 0 | 3 | CodeOpenRunTime | Open Time Code | |||
MP67013 | NVARCHAR | VSTRING | 3 | 0 | 3 | Spare | (obsolete) | |||
MP67014 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | QueueTime | Queue Time | |||
MP67015 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | MoveTime | Move Time | |||
MP67016 | NUMERIC | X_NUMERIC | 15 | 8 | 7 | Overlap | Overlapping Time | |||
MP67017 | NUMERIC | MONEY | 28 | 8 | 20 | SubcontractCost | Sub-contractor Cost | |||
MP67018 | NVARCHAR | VSTRING | 3 | 0 | 3 | CostCode | Cost Code | |||
MP67019 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | SetupCrew | Setup Crew Number | |||
MP67020 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | RunCrew | Run Crew Number | |||
MP67021 | INT | INTEGER | 0 | 0 | 2 | NumbersOfTime | Job Tickets | |||
MP67022 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | SetupTime2 | Setup Time 2 | |||
MP67023 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | ProductionRate2 | Production Rate 2 | |||
MP67024 | NUMERIC | X_NUMERIC | 28 | 8 | 20 | RunTime2 | Run Time 2 | |||
MP67025 | NVARCHAR | VSTRING | 1 | 0 | 1 | TextCode | Text Code Exist | |||
MP67026 | NVARCHAR | ACCSTR | 50 | 0 | 50 | AccountingString | Accounting String | |||
MP67027 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | (obsolete) | |||
MP67028 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | (obsolete) | |||
MP67029 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | (obsolete) | |||
MP67030 | INT | INTEGER | 0 | 0 | 2 | AccountingCode | Accounting Code | |||
MP67031 | INT | INTEGER | 0 | 0 | 10 | LeadTime | Lead Time | |||
MP67032 | DATETIME | DATE | 0 | 0 | 8 | StartDate | Start Date | |||
MP67033 | DATETIME | DATE | 0 | 0 | 8 | DueDate | Due Date | |||
MP67034 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | IssuedSetupTime | Issued Setup Time | |||
MP67035 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | IssuedRuntime | Issued Run Time | |||
MP67036 | INT | INTEGER | 0 | 0 | 1 | OperationClosed | Operation Closed | |||
MP67037 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | PreviousScrap | Previous Scrap | |||
MP67038 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Scrap | Scrap | |||
MP67039 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | WorkOrderQuantity | Quantity Work Order | |||
MP67040 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | ManufacturedQuant | Quantity Manufactured | |||
MP67041 | INT | INTEGER | 0 | 0 | 1 | Priority | Priority | |||
MP67042 | NVARCHAR | VSTRING | 2 | 0 | 2 | Calender | Calendar | |||
MP67043 | INT | INTEGER | 0 | 0 | 1 | Released | Released | |||
MP67044 | INT | INTEGER | 0 | 0 | 2 | Level | Level | |||
MP67045 | NUMERIC | X_NUMERIC | 12 | 8 | 4 | NOResources | Number of Resources | |||
MP67046 | INT | INTEGER | 0 | 0 | 1 | OpenTimeRegistered | Open Time Entered | |||
MP67047 | NVARCHAR | VSTRING | 35 | 0 | 35 | ParentItem | Parent Stock Item | |||
MP67048 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | BreakTime | Break Time | |||
MP67049 | NVARCHAR | VSTRING | 1 | 0 | 1 | RunPlanned | Run Planned | |||
MP67050 | NVARCHAR | VSTRING | 8 | 0 | 8 | ActualCostWC | Actual Cost Work Centre | |||
MP67051 | NVARCHAR | VSTRING | 3 | 0 | 3 | ActualCostCC | Actual Cost Cost Code | |||
MP67052 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | ActualCostSetup | Actual Cost Setup Crew | |||
MP67053 | NUMERIC | X_NUMERIC | 13 | 8 | 5 | ActualCostRunCrew | Actual Cost Run Crew | |||
MP67054 | NVARCHAR | VSTRING | 15 | 0 | 15 | ActualCostToolNo | Actual Cost Tool Number | |||
MP67055 | NUMERIC | MONEY | 28 | 8 | 20 | ActualCostSubCost | Actual Cost Sub-contract Cost | |||
MP67056 | NCHAR | SWITCH | 1 | 0 | 1 | ActualCostItem | Actual Cost Item | |||
MP67057 | DATETIME | DATE | 0 | 0 | 8 | ActualStartDate | Actual Start Date | |||
MP67058 | INT | INTEGER | 0 | 0 | 2 | Status1 | Status 1 | 0 - Created
1 - Scheduled 2 - Dispatched 3 - Started 4 - Stopped 5 - Finished |
||
MP67059 | INT | INTEGER | 0 | 0 | 2 | Status2 | Status 2 | 0 - Production statistics has not been update
1 - Production statistics updated |
||
MP67060 | NUMERIC | X_NUMERIC | 12 | 8 | 4 | ScrapFactor | Scrap % | |||
MP67061 | NUMERIC | MONEY | 28 | 8 | 20 | PlannedSetupCost | Planned Setup Cost | |||
MP67062 | NUMERIC | MONEY | 28 | 8 | 20 | PlannedRunCost | Planned Run Cost | |||
MP67063 | NUMERIC | MONEY | 28 | 8 | 20 | PlanWCVaraibleCost | Planned Work Centre Variable Cost | |||
MP67064 | NUMERIC | MONEY | 28 | 8 | 20 | PlanWCFixedCost | Planned Work Centre Fixed Cost | |||
MP67065 | NUMERIC | MONEY | 28 | 8 | 20 | PlanToolVarCost | Planned Tool Variable Cost | |||
MP67066 | NUMERIC | MONEY | 28 | 8 | 20 | PlanToolFixCost | Planned Tool Fixed Cost | |||
MP67067 | NUMERIC | MONEY | 28 | 8 | 20 | WIPAmount | WIP Amount | |||
MP67068 | NVARCHAR | VSTRING | 10 | 0 | 10 | Person | Person | |||
MP67069 | NCHAR | STRING | 10 | 0 | 10 | ReportingNumber2 | Report Number Reversed | Used internally as a reversed index | ||
MP67070 | NVARCHAR | VSTRING | 3 | 0 | 3 | ProductionCode | Production Code | |||
MP67071 | NVARCHAR | VSTRING | 6 | 0 | 6 | Spare | (obsolete) | |||
MP67072 | NVARCHAR | VSTRING | 35 | 0 | 35 | ReturnItem | Return Stock Item | |||
MP67073 | NVARCHAR | VSTRING | 1 | 0 | 1 | WeightType | Weight Type | |||
MP67074 | NVARCHAR | VSTRING | 1 | 0 | 1 | PrintingRules | Printing Rules | |||
MP67075 | NUMERIC | X_NUMERIC | 18 | 8 | 10 | Quantity | Quantity | |||
MP67076 | INT | INTEGER | 0 | 0 | 1 | StatusFlag | Status Flag | |||
MP67077 | NUMERIC | MONEY | 28 | 8 | 20 | StandardCost1 | Standard Cost 1 | |||
MP67078 | NUMERIC | MONEY | 28 | 8 | 20 | StandardCost2 | Standard Cost 2 | |||
MP67079 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | ScrapMP67 | Scrap | |||
MP67080 | DATETIME | DATE | 0 | 0 | 8 | LatestReportDate | Last Report Date | |||
MP67081 | DATETIME | DATE | 0 | 0 | 8 | DueDate | Due Date | |||
MP67082 | INT | INTEGER | 0 | 0 | 1 | OperationType | Operation Type | |||
MP67083 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | Yield | Yield % | |||
MP67084 | INT | INTEGER | 0 | 0 | 2 | CompSetupTime | Competence - Setup Time | |||
MP67085 | INT | INTEGER | 0 | 0 | 2 | compRunningTime | Competence - Run Time | |||
MP67086 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | SetupTimeInner | Setup Time Inner | |||
MP67087 | NCHAR | SWITCH | 1 | 0 | 1 | ShowOperation | Show Operation | |||
MP67088 | NCHAR | SWITCH | 1 | 0 | 1 | DependVolume | Depend Volume | |||
MP67089 | NCHAR | SWITCH | 1 | 0 | 1 | CriticalOperation | Critical Operation | |||
MP67090 | NCHAR | SWITCH | 1 | 0 | 1 | GRPMainOP | GRP Main Operation | |||
MP67091 | NCHAR | STRING | 1 | 0 | 1 | OpEvenLoaded | Operation Even Loaded | |||
MP67092 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | StartDateCapacity | Start Date Capacity | |||
MP67093 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | DueDateCapacity | Due Date Capacity | |||
MP67094 | NVARCHAR | VSTRING | 9 | 0 | 9 | Spare | (obsolete) | |||
MP67095 | NVARCHAR | VSTRING | 4 | 0 | 4 | Spare | (obsolete) |
Навигация: Структура БД iScala | iScala 2.2 HF 2.3318 - 2.02.3318 | Material Production Control | Work Order Routings