One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Список таблиц модуля /List of tables of module «Material Production Control»

Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419 :: Таблица / Table MP57 — MPC Stock Item Details

Таблица / Table: MP57 — «MPC Stockfile». Маска имени таблицы / Table name mask: «MP57%cc00»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
MP57001 NCHAR STRING 35 0 35 StockCode Stock Item Code   1 Да / Yes
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 lead-time calculation      
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 Cumulated standard cost      
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 Factor      
MP57017 INT INTEGER 0 0 3 IntCompCost Internal code for standard cost calculation      
MP57018 NVARCHAR VSTRING 20 0 20 DrawingNo Drawing Number      
MP57019 NVARCHAR VSTRING 8 0 8 Spare Forecast number      
MP57020 DATETIME DATE 0 0 8 LatestVerDate Latest Version Date, Manufacturing BOM      
MP57021 NVARCHAR VSTRING 1 0 1 PlanningMethod Planning code      
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 Manufacturing Method      
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 Picture ID      
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 4 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 Low level code      
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 Flag 0 — Planned by reservations.

1 — Planned by reorder point, not in MRP

2 — Manual planning.
   
MP57047 INT INTEGER 0 0 1 SparePartCode Spare Part Flag 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 Plan      
MP57057 NVARCHAR VSTRING 1 0 1 FreeTxtStock Text 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 Code      
MP57066 NVARCHAR VSTRING 1 0 1 WOBatchTraceability Work Order Batch Traceability      
MP57067 INT INTEGER 0 0 3 LeadTimeMRP Lead Time MRP Calculation      
MP57068 INT INTEGER 0 0 3 SPARE Time margin 1      
MP57069 INT INTEGER 0 0 3 SPARE Time margin 2      
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 Create ECH on OP      
MP57074 INT INTEGER 0 0 1 DDFFileNo Document Layout Code      
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 Version Number, Operations      
MP57078 INT INTEGER 0 0 8 Spare Latest Version Date, Operations      
MP57079 INT INTEGER 0 0 4 Spare Release No, Operations      
MP57080 INT INTEGER 0 0 1 Spare Lead Time Unit      
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 Latest Usage Date      
MP57087 NUMERIC X_NUMERIC 20 8 12 QuantityUsed Quantity Used      
MP57088 INT INTEGER 0 0 6 ExistsInBoMs Exists in number of BOM:s      
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 No Operation      
MP57096 INT INTEGER 0 0 1 StockStatCode Stock Status Code      
MP57097 NCHAR SWITCH 1 0 1 StopWOBfunc Stop in B-function      
MP57098 NCHAR SWITCH 1 0 1 OrdPropFcast Do not 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 Alt. 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 Alt. 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 Forecast Segment      
MP57114 NVARCHAR VSTRING 12 0 12 Spare Spare      
MP57115 NVARCHAR VSTRING 3 0 3 Spare Spare      
MP57116 NVARCHAR VSTRING 3 0 3 Spare Spare      
MP57117 NVARCHAR VSTRING 3 0 3 Spare Spare      
MP57118 NCHAR STRING 8 0 8 Spare Spare      
MP57119 NCHAR STRING 8 0 8 Spare Spare      
MP57120 NCHAR STRING 8 0 8 Spare Spare      
MP57121 INT INTEGER 0 0 3 AccLeadtime Acc. Lead time, MRP      
MP57122 INT INTEGER 0 0 2 BOMStatusTypeM BOM Status Type M      
MP57123 INT INTEGER 0 0 2 BOMStatusTypeE BOM Status Type E      
MP57124 INT INTEGER 0 0 4 PlanningTimeFence Planning Time Fence      
MP57125 INT INTEGER 0 0 4 DemandTimeFence Demand Time Fence      
MP57126 INT INTEGER 0 0 1 ForecastConsumptionPeriod Forecast Consumption Period      
MP57127 INT INTEGER 0 0 1 ForecastConsumptionOrder Forecast Consumption Order      
MP57128 INT INTEGER 0 0 2 BackwardPeriods Backward Periods      
MP57129 INT INTEGER 0 0 2 ForwardPeriods Forward Periods      
MP57130 INT INTEGER 0 0 1 ForecastConsumptionRuleforcurrentperiod Forecast Consumption Rule for current period      
MP57131 INT INTEGER 0 0 1 ForecastConsumptionRuleforpreviousperiods Forecast Consumption Rule for previous periods      
MP57132 INT INTEGER 0 0 1 ForecastConsumptionRulefornextperiodswithinDTF Forecast Consumption Rule for next periods within DTF      
MP57133 INT INTEGER 0 0 1 ForecastConsumptionRulefornextperiodsbeyondDTF Forecast Consumption Rule for next periods beyond DTF      
MP57134 DATETIME DATE 0 0 8 LastPTFDate Last PTF date MPS      
MP57135 DATETIME DATE 0 0 8 LastPTFDateMRP Last PTF date MRP/SRP      
MP57136 NCHAR SWITCH 1 0 1 ExcludedFromMRPNet Excluded from MRP net      
MP57137 INT INTEGER 0 0 5 DaysBeforeNeedToSearchCoverage Days before need to search coverage      
MP57138 INT INTEGER 0 0 5 DaysAfterNeedToSearchCoverage Days after need to search coverage      
MP57139 INT INTEGER 0 0 3 SafetyStockLeadTime Safety Stock Lead Time      
MP57140 NCHAR SWITCH 1 0 1 AllowProposalTypeChange Allow change of proposal type      
MP57141 INT INTEGER 0 0 2 FixedBucketSchedule Fixed Bucket Schedule for MRP/MPS      
MP57142 INT INTEGER 0 0 1 BackFlushCode Back Flush Code      
MP57143 NCHAR SWITCH 1 0 1 CreateECHonDisassemblyBOM Create ECH on Disassembly BOM      
MP57144 NCHAR SWITCH 1 0 1 CreateECHonRepairBOM Create ECH on Repair BOM      
MP57145 NVARCHAR VSTRING 10 0 10 VersionNumDisassemblyBOM Version number, Disassembly BOM      
MP57146 NVARCHAR VSTRING 10 0 10 VersionNumRepairBOM Version number, Repair BOM      
MP57147 INT INTEGER 0 0 4 DisassemblyBOMReleaseNum Release number Disassembly      
MP57148 INT INTEGER 0 0 4 RepairBOMReleaseNum Release number Repair      
MP57149 DATETIME DATE 0 0 8 LastVersionDateDisassemblyBOM Last version date, Disassembly BOM      
MP57150 DATETIME DATE 0 0 8 LastVersionDateRepairBOM Last version date, Repair BOM      
MP57151 INT INTEGER 0 0 2 BOMStatusDisassemblyBOM BOM status, Disassembly BOM      
MP57152 INT INTEGER 0 0 2 BOMStatusRepairBOM BOM status, Repair BOM      
MP57153 NCHAR SWITCH 1 0 1 GRPfromSalesOrder Capacity planning from sales order      

Навигация / Navigation: