Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
Таблица: MP57 - «Stockfile» («Файл запасов»)
| Поле | Тип поля Scala | Длина Scala | Комментарий | Первичный ключ? |
| MP57001 | STRING | 35 | StockCode | Да |
| MP57002 | INTEGER | 3 | LeadTimeOneLevel | |
| MP57003 | INTEGER | 3 | LeadTExclP | |
| MP57004 | INTEGER | 3 | LeadTInclP | |
| MP57005 | INTEGER | 3 | IntCodeComp | |
| MP57006 | MONEY | 20 | PrevStdCost | |
| MP57007 | VSTRING | 8 | Spare | |
| MP57008 | MONEY | 20 | SumofStdCosts | |
| MP57009 | MONEY | 20 | ComingStdCosts | |
| MP57010 | MONEY | 20 | SimuStdCosts | |
| MP57011 | MONEY | 20 | SpcProdCost1 | |
| MP57012 | MONEY | 20 | SpcProdCost2 | |
| MP57013 | MONEY | 20 | SpcProdCost3 | |
| MP57014 | MONEY | 20 | SpcProdCost4 | |
| MP57015 | VSTRING | 6 | CostingModel | |
| MP57016 | VSTRING | 6 | CostingFact | |
| MP57017 | INTEGER | 3 | IntCompCost | |
| MP57018 | VSTRING | 20 | DrawingNo | |
| MP57019 | VSTRING | 8 | Spare | |
| MP57020 | DATE | 8 | LatestVerDate | |
| MP57021 | VSTRING | 1 | PlanningMethod | |
| MP57022 | SWITCH | 1 | MPSPlanned | |
| MP57023 | INTEGER | 1 | StockIssCode | |
| MP57024 | VSTRING | 15 | Planner | |
| MP57025 | INTEGER | 2 | Spare | |
| MP57026 | INTEGER | 1 | LotSizingTechnique | |
| MP57027 | INTEGER | 6 | Multiple | |
| MP57028 | INTEGER | 12 | SafetyStock | |
| MP57029 | INTEGER | 3 | SafetyTime | |
| MP57030 | X_NUMERIC | 12 | Forecast1 | |
| MP57031 | X_NUMERIC | 12 | Forecast2 | |
| MP57032 | X_NUMERIC | 12 | Forecast3 | |
| MP57033 | X_NUMERIC | 12 | Forecast4 | |
| MP57034 | VSTRING | 35 | Spare | |
| MP57035 | SWITCH | 1 | CriticalMat | |
| MP57036 | X_NUMERIC | 12 | UnitPerLot | |
| MP57037 | X_NUMERIC | 12 | SizeOfLot | |
| MP57038 | INTEGER | 2 | LotUnitCode | |
| MP57039 | X_NUMERIC | 12 | LotStuffing | |
| MP57040 | X_NUMERIC | 6 | Yeild | |
| MP57041 | INTEGER | 2 | LowLevelCode | |
| MP57042 | INTEGER | 1 | MRPNeed | |
| MP57043 | INTEGER | 3 | MRPDaysOR | |
| MP57044 | SWITCH | 1 | WOthroughBoM | |
| MP57045 | INTEGER | 3 | MRPDaysNeed | |
| MP57046 | VSTRING | 1 | CalcReorPoint | |
| MP57047 | INTEGER | 1 | SparePartCode | |
| MP57048 | INTEGER | 1 | Status | |
| MP57049 | SWITCH | 1 | ECHManufact | |
| MP57050 | SWITCH | 1 | ECHEngineering | |
| MP57051 | DATE | 8 | PresStdCost | |
| MP57052 | VSTRING | 10 | VerNoManufact | |
| MP57053 | VSTRING | 10 | VerNoEngineering | |
| MP57054 | DATE | 8 | LatVerDatEng | |
| MP57055 | X_NUMERIC | 6 | Scrap | |
| MP57056 | SWITCH | 1 | PrintOutMPS | |
| MP57057 | VSTRING | 1 | FreeTxtStock | |
| MP57058 | INTEGER | 2 | OpenCompExist | |
| MP57059 | INTEGER | 2 | OpenQtyExist | |
| MP57060 | INTEGER | 2 | OpenTimeExist | |
| MP57061 | INTEGER | 4 | ManufactRel | |
| MP57062 | INTEGER | 4 | EngineerRel | |
| MP57063 | VSTRING | 20 | DispatchTerm | |
| MP57064 | INTEGER | 1 | WOAutomatCre | |
| MP57065 | VSTRING | 35 | Configuration | |
| MP57066 | VSTRING | 1 | Spare | |
| MP57067 | INTEGER | 3 | LeadTimeMRP | |
| MP57068 | INTEGER | 3 | SPARE | |
| MP57069 | INTEGER | 3 | SPARE | |
| MP57070 | VSTRING | 6 | ReceiptWH | |
| MP57071 | VSTRING | 6 | ProductionWH | |
| MP57072 | VSTRING | 1 | DrawingFormat | |
| MP57073 | SWITCH | 1 | Spare | |
| MP57074 | INTEGER | 1 | DDFFileNo | |
| MP57075 | X_NUMERIC | 12 | CostingQty | |
| MP57076 | INTEGER | 5 | MRPdaysFixed | |
| MP57077 | INTEGER | 10 | Spare | |
| MP57078 | INTEGER | 8 | Spare | |
| MP57079 | INTEGER | 4 | Spare | |
| MP57080 | INTEGER | 1 | Spare | |
| MP57081 | INTEGER | 3 | LeadTimeLevel | |
| MP57082 | X_NUMERIC | 12 | MaxStock | |
| MP57083 | MONEY | 12 | TurnoverPlan | |
| MP57084 | MONEY | 12 | TurnoverAct | |
| MP57085 | INTEGER | 12 | NoOfIssues | |
| MP57086 | DATE | 8 | LatUsageDate | |
| MP57087 | X_NUMERIC | 12 | QuantityUsed | |
| MP57088 | INTEGER | 6 | ExistsInBoMs | |
| MP57089 | VSTRING | 35 | ExtrStockCode | |
| MP57090 | INTEGER | 10 | VerNoStock | |
| MP57091 | DATE | 8 | LatVerDatStock | |
| MP57092 | SWITCH | 1 | OperatHist | |
| MP57093 | DATE | 8 | OperHistDate | |
| MP57094 | INTEGER | 10 | VerOperation | |
| MP57095 | INTEGER | 4 | RelNoOperation | |
| MP57096 | INTEGER | 1 | StockStatCode | |
| MP57097 | SWITCH | 1 | StopWOBfunc | |
| MP57098 | SWITCH | 1 | OrdPropFcast | |
| MP57099 | VSTRING | 8 | ManWrkCentre | |
| MP57100 | SWITCH | 1 | ORContMat | |
| MP57101 | SWITCH | 1 | Kanban | |
| MP57102 | MONEY | 20 | AltMatPrice | |
| MP57103 | INTEGER | 3 | FixLeadtime | |
| MP57104 | INTEGER | 3 | VarLeadtime | |
| MP57105 | INTEGER | 3 | ModeratTime | |
| MP57106 | INTEGER | 3 | ControlTime | |
| MP57107 | VSTRING | 1 | FamilyCode | |
| MP57108 | VSTRING | 4 | Family | |
| MP57109 | SWITCH | 1 | AddSpcCost | |
| MP57110 | VSTRING | 6 | AltCalcModel | |
| MP57111 | VSTRING | 6 | BatchPattern | |
| MP57112 | DATE | 8 | FPODate | |
| MP57113 | VSTRING | 20 | Spare | |
| MP57114 | VSTRING | 12 | Spare | |
| MP57115 | VSTRING | 3 | Spare | |
| MP57116 | VSTRING | 3 | Spare | |
| MP57117 | VSTRING | 3 | Spare | |
| MP57118 | STRING | 8 | Spare | |
| MP57119 | STRING | 8 | Spare | |
| MP57120 | STRING | 8 | Spare | |
| MP57121 | INTEGER | 3 | AccLeadtime |
Навигация: Структура БД Scala/iScala | Scala 5.1 SR13 | MPC (Управление Производством) | Stockfile (Файл запасов)
/* */