Таблица: MP57 - «MPC Stockfile». Маска имени таблицы: «MP57%cc00»
Поле | Тип поля | Тип поля Scala | Длина поля | Точность | Длина Scala | Комментарий | Расширенный комментарий | Дополнительное описание | Позиция в индексе | Первичный ключ? |
MP57001 | NCHAR | STRING | 35 | 0 | 35 | StockCode | Stock Item Code | 1 | Да | |
MP57002 | INT | INTEGER | 0 | 0 | 3 | LeadTimeOneLevel | Lead Time, One Level | |||
MP57003 | INT | INTEGER | 0 | 0 | 3 | LeadTExclP | Cumulated Lead Time Excluding Purchase Lead Time | |||
MP57004 | INT | INTEGER | 0 | 0 | 3 | LeadTInclP | Cumulated Lead Time Including Purchase Lead Time | |||
MP57005 | INT | INTEGER | 0 | 0 | 3 | IntCodeComp | Internal Code for Comparison (Lead Time) | |||
MP57006 | NUMERIC | MONEY | 28 | 8 | 20 | PrevStdCost | Standard Cost Previous | |||
MP57007 | NVARCHAR | VSTRING | 8 | 0 | 8 | Suffix | Suffix | |||
MP57008 | NUMERIC | MONEY | 28 | 8 | 20 | SumofStdCosts | Sum of Standard Cost on Succeeding Levels | |||
MP57009 | NUMERIC | MONEY | 28 | 8 | 20 | ComingStdCosts | Standard Cost Next | |||
MP57010 | NUMERIC | MONEY | 28 | 8 | 20 | SimuStdCosts | Standard Cost Simulated | |||
MP57011 | NUMERIC | MONEY | 28 | 8 | 20 | SpcProdCost1 | Special Production Cost 1 | |||
MP57012 | NUMERIC | MONEY | 28 | 8 | 20 | SpcProdCost2 | Special Production Cost 2 | |||
MP57013 | NUMERIC | MONEY | 28 | 8 | 20 | SpcProdCost3 | Special Production Cost 3 | |||
MP57014 | NUMERIC | MONEY | 28 | 8 | 20 | SpcProdCost4 | Special Production Cost 4 | |||
MP57015 | NVARCHAR | VSTRING | 6 | 0 | 6 | CostingModel | Costing Model | |||
MP57016 | NVARCHAR | VSTRING | 6 | 0 | 6 | CostingFact | Costing Factors | |||
MP57017 | INT | INTEGER | 0 | 0 | 3 | IntCompCost | Internal Code for Comparison (Costing) | |||
MP57018 | NVARCHAR | VSTRING | 20 | 0 | 20 | DrawingNo | Drawing Number | |||
MP57019 | NVARCHAR | VSTRING | 8 | 0 | 8 | Spare | (obsolete) | |||
MP57020 | DATETIME | DATE | 0 | 0 | 8 | LatestVerDate | Latest Version Date, Manufacturing BOM | |||
MP57021 | NVARCHAR | VSTRING | 1 | 0 | 1 | PlanningMethod | Planning Method | |||
MP57022 | NCHAR | SWITCH | 1 | 0 | 1 | MPSPlanned | Used in MPS Planning | |||
MP57023 | INT | INTEGER | 0 | 0 | 1 | StockIssCode | Planning Code | |||
MP57024 | NVARCHAR | VSTRING | 15 | 0 | 15 | Planner | Planner | |||
MP57025 | INT | INTEGER | 0 | 0 | 2 | Spare | (obsolete) | |||
MP57026 | INT | INTEGER | 0 | 0 | 1 | LotSizingTechnique | Lot Size Technique | |||
MP57027 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Multiple | Planned Quantity Multiple | |||
MP57028 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | SafetyStock | Safety Stock | |||
MP57029 | INT | INTEGER | 0 | 0 | 3 | SafetyTime | Safety Time | |||
MP57030 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Forecast1 | Forecast 1 | |||
MP57031 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Forecast2 | Forecast 2 | |||
MP57032 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Forecast3 | Forecast 3 | |||
MP57033 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | Forecast4 | Forecast 4 | |||
MP57034 | NVARCHAR | VSTRING | 35 | 0 | 35 | Spare | (obsolete) | |||
MP57035 | NCHAR | SWITCH | 1 | 0 | 1 | CriticalMat | Critical Material | |||
MP57036 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | UnitPerLot | No of Units per Lot | |||
MP57037 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | SizeOfLot | Lot Size | |||
MP57038 | INT | INTEGER | 0 | 0 | 2 | LotUnitCode | Unit Code Lot | |||
MP57039 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | LotStuffing | Lot Stuffing | |||
MP57040 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | Yeild | Yield % | |||
MP57041 | INT | INTEGER | 0 | 0 | 2 | LowLevelCode | Lowest Structure Level | |||
MP57042 | INT | INTEGER | 0 | 0 | 1 | MRPNeed | MRP - Based On Forecast/Reservation | Specifies what MRP is to be based upon:
0 - Both reservations and forecasts. 1 - Only reservations. 2 - Only forecasts. 3 - Greatest of reservation or forecasts. 4 - Sum of reservations and forecasts. |
||
MP57043 | INT | INTEGER | 0 | 0 | 3 | MRPDaysOR | MRP - Reservation in Days | |||
MP57044 | NCHAR | SWITCH | 1 | 0 | 1 | WOthroughBoM | Stop Creating WO through BOM | |||
MP57045 | INT | INTEGER | 0 | 0 | 3 | MRPDaysNeed | MRP - Number of Days Due Before Need | |||
MP57046 | NVARCHAR | VSTRING | 1 | 0 | 1 | CalcReorPoint | Reorder Point | 0 - Planned by reservations.
1 - Planned by reorder point, not in MRP 2 - Manual planning. |
||
MP57047 | INT | INTEGER | 0 | 0 | 1 | SparePartCode | Spare Part Code | 1 - Not a spare part
2 - May be a spare part 3 - Always a spare part |
||
MP57048 | INT | INTEGER | 0 | 0 | 1 | Status | Status | |||
MP57049 | NCHAR | SWITCH | 1 | 0 | 1 | ECHManufact | Create ECH on Manufacturing BOM | |||
MP57050 | NCHAR | SWITCH | 1 | 0 | 1 | ECHEngineering | Create ECH on Engineering BOM | |||
MP57051 | DATETIME | DATE | 0 | 0 | 8 | PresStdCost | Last Date for Present Standard Cost Calculation | |||
MP57052 | NVARCHAR | VSTRING | 10 | 0 | 10 | VerNoManufact | Version Number Manufacturing BOM | |||
MP57053 | NVARCHAR | VSTRING | 10 | 0 | 10 | VerNoEngineering | Version Number Engineering BOM | |||
MP57054 | DATETIME | DATE | 0 | 0 | 8 | LatVerDatEng | Last Version Date Engineering BOM | |||
MP57055 | NUMERIC | X_NUMERIC | 14 | 8 | 6 | Scrap | Scrap % | |||
MP57056 | NCHAR | SWITCH | 1 | 0 | 1 | PrintOutMPS | Print on MPS/MPS Purchase | |||
MP57057 | NVARCHAR | VSTRING | 1 | 0 | 1 | FreeTxtStock | Free Text on Stock Code Exists | |||
MP57058 | INT | INTEGER | 0 | 0 | 2 | OpenCompExist | Open Component Exists | |||
MP57059 | INT | INTEGER | 0 | 0 | 2 | OpenQtyExist | Open Quantity Exists | |||
MP57060 | INT | INTEGER | 0 | 0 | 2 | OpenTimeExist | Open Time Exists | |||
MP57061 | INT | INTEGER | 0 | 0 | 4 | ManufactRel | Manufacturing BOM Release Number | |||
MP57062 | INT | INTEGER | 0 | 0 | 4 | EngineerRel | Engineering BOM Release Number | |||
MP57063 | NVARCHAR | VSTRING | 20 | 0 | 20 | DispatchTerm | Dispatch Term | |||
MP57064 | INT | INTEGER | 0 | 0 | 1 | WOAutomatCre | Create Work Order from Sales Order | |||
MP57065 | NVARCHAR | VSTRING | 35 | 0 | 35 | Configuration | Configuration | |||
MP57066 | NVARCHAR | VSTRING | 1 | 0 | 1 | Spare | (obsolete) | |||
MP57067 | INT | INTEGER | 0 | 0 | 3 | LeadTimeMRP | Lead Time MRP Calculation | |||
MP57068 | INT | INTEGER | 0 | 0 | 3 | SPARE | (obsolete) | |||
MP57069 | INT | INTEGER | 0 | 0 | 3 | SPARE | (obsolete) | |||
MP57070 | NVARCHAR | VSTRING | 6 | 0 | 6 | ReceiptWH | Warehouse for Receipt | |||
MP57071 | NVARCHAR | VSTRING | 6 | 0 | 6 | ProductionWH | Warehouse for Manufacturing | |||
MP57072 | NVARCHAR | VSTRING | 1 | 0 | 1 | DrawingFormat | Drawing Format | |||
MP57073 | NCHAR | SWITCH | 1 | 0 | 1 | Spare | (obsolete) | |||
MP57074 | INT | INTEGER | 0 | 0 | 1 | DDFFileNo | Document Layout | |||
MP57075 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | CostingQty | Costing Quantity | |||
MP57076 | INT | INTEGER | 0 | 0 | 5 | MRPdaysFixed | MRP - Fixed Period of Time | |||
MP57077 | INT | INTEGER | 0 | 0 | 10 | Spare | (obsolete) | |||
MP57078 | INT | INTEGER | 0 | 0 | 8 | Spare | (obsolete) | |||
MP57079 | INT | INTEGER | 0 | 0 | 4 | Spare | (obsolete) | |||
MP57080 | INT | INTEGER | 0 | 0 | 1 | Spare | (obsolete) | |||
MP57081 | INT | INTEGER | 0 | 0 | 3 | LeadTimeLevel | Lead Time to Level on Stock | |||
MP57082 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | MaxStock | Max Stock | |||
MP57083 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | TurnoverPlan | Turnover Planned | |||
MP57084 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | TurnoverAct | Turnover Actual | |||
MP57085 | INT | INTEGER | 0 | 0 | 12 | NoOfIssues | Number of Issues | |||
MP57086 | DATETIME | DATE | 0 | 0 | 8 | LatUsageDate | Last Usage Date | |||
MP57087 | NUMERIC | X_NUMERIC | 20 | 8 | 12 | QuantityUsed | Quantity Used | |||
MP57088 | INT | INTEGER | 0 | 0 | 6 | ExistsInBoMs | Exists in Number of BOM | |||
MP57089 | NVARCHAR | VSTRING | 35 | 0 | 35 | ExtrStockCode | Extra Stock Code | |||
MP57090 | INT | INTEGER | 0 | 0 | 10 | VerNoStock | Version Number Stock | |||
MP57091 | DATETIME | DATE | 0 | 0 | 8 | LatVerDatStock | Latest Version Date Stock | |||
MP57092 | NCHAR | SWITCH | 1 | 0 | 1 | OperatHist | Operation History | |||
MP57093 | DATETIME | DATE | 0 | 0 | 8 | OperHistDate | Operation History Date | |||
MP57094 | INT | INTEGER | 0 | 0 | 10 | VerOperation | Version Operation | |||
MP57095 | INT | INTEGER | 0 | 0 | 4 | RelNoOperation | Release Number Operation | |||
MP57096 | INT | INTEGER | 0 | 0 | 1 | StockStatCode | Stock Status Code | |||
MP57097 | NCHAR | SWITCH | 1 | 0 | 1 | StopWOBfunc | Stop Work Order with B-function | |||
MP57098 | NCHAR | SWITCH | 1 | 0 | 1 | OrdPropFcast | Don't Create Order Proposals From Forecast | |||
MP57099 | NVARCHAR | VSTRING | 8 | 0 | 8 | ManWrkCentre | Managing Work Centre | |||
MP57100 | NCHAR | SWITCH | 1 | 0 | 1 | ORContMat | Sales Order Controlled Material | |||
MP57101 | NCHAR | SWITCH | 1 | 0 | 1 | Kanban | Kanban | |||
MP57102 | NUMERIC | MONEY | 28 | 8 | 20 | AltMatPrice | Alternative Material Price | |||
MP57103 | INT | INTEGER | 0 | 0 | 3 | FixLeadtime | Fixed Lead Time | |||
MP57104 | INT | INTEGER | 0 | 0 | 3 | VarLeadtime | Variable Lead Time | |||
MP57105 | INT | INTEGER | 0 | 0 | 3 | ModeratTime | Moderation Time | |||
MP57106 | INT | INTEGER | 0 | 0 | 3 | ControlTime | Control Time | |||
MP57107 | NVARCHAR | VSTRING | 1 | 0 | 1 | FamilyCode | Family Code | |||
MP57108 | NVARCHAR | VSTRING | 4 | 0 | 4 | Family | Family | |||
MP57109 | NCHAR | SWITCH | 1 | 0 | 1 | AddSpcCost | Add Special Costs to Standard Cost | |||
MP57110 | NVARCHAR | VSTRING | 6 | 0 | 6 | AltCalcModel | Alternative Calculus Model | |||
MP57111 | NVARCHAR | VSTRING | 6 | 0 | 6 | BatchPattern | Batch Pattern | |||
MP57112 | DATETIME | DATE | 0 | 0 | 8 | FPODate | FPO-Date | |||
MP57113 | NVARCHAR | VSTRING | 20 | 0 | 20 | Spare | (obsolete) | |||
MP57114 | NVARCHAR | VSTRING | 12 | 0 | 12 | Spare | (obsolete) | |||
MP57115 | NVARCHAR | VSTRING | 3 | 0 | 3 | Spare | (obsolete) | |||
MP57116 | NVARCHAR | VSTRING | 3 | 0 | 3 | Spare | (obsolete) | |||
MP57117 | NVARCHAR | VSTRING | 3 | 0 | 3 | Spare | (obsolete) | |||
MP57118 | NCHAR | STRING | 8 | 0 | 8 | Spare | (obsolete) | |||
MP57119 | NCHAR | STRING | 8 | 0 | 8 | Spare | (obsolete) | |||
MP57120 | NCHAR | STRING | 8 | 0 | 8 | Spare | (obsolete) | |||
MP57121 | INT | INTEGER | 0 | 0 | 3 | AccLeadtime | Accumulated Lead Time MRP | |||
MP57122 | INT | INTEGER | 0 | 0 | 2 | BOM status type M | BOM Status Type M | |||
MP57123 | INT | INTEGER | 0 | 0 | 2 | BOM status type E | BOM Status Type E | |||
MP57124 | INT | INTEGER | 0 | 0 | 4 | Planning Time Fence | ||||
MP57125 | INT | INTEGER | 0 | 0 | 4 | Demand Time Fence | ||||
MP57126 | INT | INTEGER | 0 | 0 | 1 | Forecast Consumption Period | Forecast Consumption Period | |||
MP57127 | INT | INTEGER | 0 | 0 | 1 | Forecast Consumption Order | Forecast Consumption Order | |||
MP57128 | INT | INTEGER | 0 | 0 | 2 | Backward Periods | Backward Periods | |||
MP57129 | INT | INTEGER | 0 | 0 | 2 | Forward Periods | Forward Periods | |||
MP57130 | INT | INTEGER | 0 | 0 | 1 | Forecast Consumption Rule for current period | Forecast Consumption Rule for current period | |||
MP57131 | INT | INTEGER | 0 | 0 | 1 | Forecast Consumption Rule for previous periods | Forecast Consumption Rule for previous periods | |||
MP57132 | INT | INTEGER | 0 | 0 | 1 | Forecast Consumption Rule for next periods within DTF | Forecast Consumption Rule for next periods within DTF | |||
MP57133 | INT | INTEGER | 0 | 0 | 1 | Forecast Consumption Rule for next periods beyond DTF | Forecast Consumption Rule for next periods beyond DTF | |||
MP57134 | DATETIME | DATE | 0 | 0 | 8 | Last PTF date | Last PTF date | |||
MP57135 | DATETIME | DATE | 0 | 0 | 8 | Last PTF date SRP/MRP | Last PTF date SRP/MRP |
Навигация: Структура БД iScala | Epicor iScala 2.3 - 2.03.3363 | Material Production Control | MPC Stock Item Details