Таблица: 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