пользователям программных продуктов Scala 5.0, Scala 5.1, iScala 2.1, iScala 2.2, iScala 2.3, iScala 3.0 (и так далее)

Таблица: MP57 - «MPC Stockfile». Маска имени таблицы: «MP57%cc00»

Поле Тип поля Тип поля iScala Длина поля Точ­ность Длина iScala Комментарий Расширенный комментарий Дополнительное описание Пози­ция в инде­ксе Первич­ный ключ?
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 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 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 WOBatchTraceability Work Order Batch Traceability      
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 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      
MP57135 DATETIME DATE 0 0 8 LastPTFDateMRP Last PTF date SRP/MRP      
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 Disassembly BOM, release number      
MP57148 INT INTEGER 0 0 4 RepairBOMReleaseNum Repair BOM, release number      
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 GRP from Sales Order      

Навигация: Структура БД iScala | Epicor iScala 3.00 (x64) - 3.00.02254 | Material Production Control | MPC Stock Item Details

TopList

© Алексей Васильев. 2004-2019. При использовании материалов ссылка обязательна.