One level Up / One level Up: Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Список таблиц модуля «Управление Производством» / List of tables of module «Material Production Control»

Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511 :: Таблица / Table MP56 — MPC Parameters

Таблица / Table: MP56 — «MPC Parameters». Маска имени таблицы / Table name mask: «MP56%cc%yy»

Поле / Field Тип поля / Field Type Тип поля Scala / iScala Field Type Длина поля / Field length Точность / Precision Длина Scala / iScala length Комментарий / Comment Расширенный комментарий / Extended comment Дополнительное описание / Additional description Позиция в индексе / Index position Первичный ключ? / Is Primary key?
MP56001 NCHAR STRING 2 0 2 YearCode Year   1 Да / Yes
MP56002 INT INTEGER 0 0 3 IntCodeCalcL Internal Code Calculation Lead Time      
MP56003 INT INTEGER 0 0 3 IntCodeCalc Internal Code Calculus      
MP56004 NVARCHAR VSTRING 10 0 10 Spare (obsolete)      
MP56005 NVARCHAR VSTRING 10 0 10 Spare (obsolete)      
MP56006 NVARCHAR VSTRING 10 0 10 Spare (obsolete)      
MP56007 NVARCHAR VSTRING 6 0 6 Validity Effective Date      
MP56008 NVARCHAR VSTRING 6 0 6 OpeComponent Open Items      
MP56009 NVARCHAR VSTRING 6 0 6 OpenQuantity Open Quantity      
MP56010 NVARCHAR VSTRING 6 0 6 Warehouse Warehouse      
MP56011 NVARCHAR VSTRING 6 0 6 ExtraSetup Extra Setup and Runtime      
MP56012 NVARCHAR VSTRING 6 0 6 AccPossibility Accounting Possibility      
MP56013 NVARCHAR VSTRING 6 0 6 OpenTime Open Setup/Run      
MP56014 NVARCHAR VSTRING 6 0 6 ConfirmCOWO Confirm Conversion Customer Order to Work Order      
MP56015 NVARCHAR VSTRING 6 0 6 UseStockEval Use Evaluation Model from Stock Control      
MP56016 NVARCHAR VSTRING 6 0 6 StockTransact Stock Transactions: Use Accounting Code from Component      
MP56017 NVARCHAR VSTRING 6 0 6 AlterRouting Alternate Routings      
MP56018 NVARCHAR VSTRING 6 0 6 ReportingMat Manual Reporting of Material      
MP56019 NVARCHAR VSTRING 6 0 6 ReportRout Manual Reporting of Routing      
MP56020 INT INTEGER 0 0 1 MateriaIssue When are Material Issue      
MP56021 INT INTEGER 0 0 1 OperatReport When are Operation Reported      
MP56022 NVARCHAR VSTRING 6 0 6 RecLastOperation Receipt at Reporting Last Operation      
MP56023 NVARCHAR VSTRING 6 0 6 ImmediateUpd Immediate Update at Receipt with Work Order      
MP56024 NVARCHAR VSTRING 6 0 6 Spare Spare      
MP56025 NVARCHAR VSTRING 6 0 6 Spare Special Cost Calculation      
MP56026 NVARCHAR VSTRING 6 0 6 OpnrSameNo BOM: Number = Operation Number      
MP56027 INT INTEGER 0 0 2 Number Number Increment      
MP56028 INT INTEGER 0 0 2 Opnr Operation Number Increment      
MP56029 NVARCHAR VSTRING 6 0 6 Rate Use Production Rate      
MP56030 NVARCHAR VSTRING 6 0 6 Spare (obsolete)      
MP56031 NVARCHAR VSTRING 6 0 6 Spare (obsolete)      
MP56032 NVARCHAR VSTRING 6 0 6 Spare (obsolete)      
MP56033 NUMERIC NUMBER 20 0 10 ReplenishmentProp ReplenishmentProposals      
MP56034 NUMERIC NUMBER 20 0 10 MRPReportNo (obsolete)      
MP56035 NVARCHAR VSTRING 6 0 6 Pegging Pegging      
MP56036 INT INTEGER 0 0 6 LowestStrLev Lowest Structure Level      
MP56037 NUMERIC NUMBER 20 0 10 OrderSerieA (obsolete)      
MP56038 NUMERIC NUMBER 20 0 10 OrderSerieB (obsolete)      
MP56039 NUMERIC NUMBER 20 0 10 OrderSerieC (obsolete)      
MP56040 NUMERIC NUMBER 20 0 10 OrderSerieD (obsolete)      
MP56041 NUMERIC NUMBER 20 0 10 OrderSerieE (obsolete)      
MP56042 NUMERIC NUMBER 20 0 10 OrderSerieF (obsolete)      
MP56043 NUMERIC NUMBER 20 0 10 ReportNumber (obsolete)      
MP56044 NVARCHAR VSTRING 1 0 1 LoadingCode Loading Code 0 — Forward planning

1 — Backwards planning

2 — Locked planning
   
MP56045 NVARCHAR VSTRING 6 0 6 UpdBillMat Automatic Update of BOM      
MP56046 NVARCHAR VSTRING 6 0 6 UpdRoutList Automatic Update of Routing      
MP56047 NVARCHAR VSTRING 6 0 6 CreaCostSyst Create Actual Cost per Work Order      
MP56048 INT INTEGER 0 0 2 MatRoutList Picking List by Operation Copies      
MP56049 INT INTEGER 0 0 2 MatRequList Picking List Copies      
MP56050 INT INTEGER 0 0 2 RoutingLists Operation List Copies      
MP56051 INT INTEGER 0 0 2 ShopTravellers Traveller Document Copies      
MP56052 INT INTEGER 0 0 2 JobTickets Job Ticket Copies      
MP56053 INT INTEGER 0 0 2 LabelsType1 Label Type 1 Copies      
MP56054 INT INTEGER 0 0 2 LabelsType2 Label Type 2 Copies      
MP56055 INT INTEGER 0 0 2 ShopTravSubc Traveller Vendor Document Copies      
MP56056 INT INTEGER 0 0 2 ReportReceipts Report Work Order Receipt Copies      
MP56057 INT INTEGER 0 0 2 TravellerVen Routing List Copies      
MP56058 INT INTEGER 0 0 1 Spare (obsolete)      
MP56059 INT INTEGER 0 0 1 COWOBatch (obsolete)      
MP56060 NVARCHAR VSTRING 6 0 6 AnswOpenEnqu Open Enquiries at Customer Order to Work Order      
MP56061 INT INTEGER 0 0 2 DaysBefDeliv Number of Days Due to Delivery Date      
MP56062 NVARCHAR VSTRING 6 0 6 CummMatRequL Cumulated Picking List      
MP56063 INT INTEGER 0 0 1 SpecOrderNo Work Order Number Setting from Customer Order 0 — Order series entered manually

1 — Use sales order number plus 2 last character in order position
   
MP56064 NUMERIC NUMBER 20 0 10 OrderSerieG (obsolete)      
MP56065 NUMERIC NUMBER 20 0 10 OrderSerieH (obsolete)      
MP56066 NUMERIC NUMBER 20 0 10 OrderSerieI (obsolete)      
MP56067 NUMERIC NUMBER 20 0 10 OrderSerieJ (obsolete)      
MP56068 NUMERIC NUMBER 20 0 10 OrderSerieK (obsolete)      
MP56069 NUMERIC NUMBER 20 0 10 OrderSerieL (obsolete)      
MP56070 NUMERIC NUMBER 20 0 10 OrderSerieM (obsolete)      
MP56071 NUMERIC NUMBER 20 0 10 OrderSerieN (obsolete)      
MP56072 NUMERIC NUMBER 20 0 10 OrderSerieO (obsolete)      
MP56073 NUMERIC NUMBER 20 0 10 OrderSerieP (obsolete)      
MP56074 NUMERIC NUMBER 20 0 10 OrderSerieQ (obsolete)      
MP56075 NUMERIC NUMBER 20 0 10 OrderSerieR (obsolete)      
MP56076 NUMERIC NUMBER 20 0 10 OrderSerieS (obsolete)      
MP56077 NUMERIC NUMBER 20 0 10 OrderSerieT (obsolete)      
MP56078 NUMERIC NUMBER 20 0 10 OrderSerieU (obsolete)      
MP56079 NUMERIC NUMBER 20 0 10 OrderSerieV (obsolete)      
MP56080 NUMERIC NUMBER 20 0 10 OrderSerieW (obsolete)      
MP56081 NUMERIC NUMBER 20 0 10 OrderSerieX (obsolete)      
MP56082 NUMERIC NUMBER 20 0 10 OrderSerieY (obsolete)      
MP56083 NUMERIC NUMBER 20 0 10 OrderSerieZ (obsolete)      
MP56084 INT INTEGER 0 0 1 TypeMatCost Material Cost Option for Purchased Items The material cost for bought items that the program will use in the standard cost calculation to calculate material cost.

1 — Purchase price

2 — Average purchase price

3 — Standard cost

4 — Landed cost
   
MP56085 INT INTEGER 0 0 3 TimeMargin Time Margin      
MP56086 NVARCHAR VSTRING 6 0 6 Spare Update with Zero Standard Cost      
MP56087 NVARCHAR VSTRING 6 0 6 UpdateLatestCalcDate Update Last Cost Calculation Date      
MP56088 NVARCHAR VSTRING 15 0 15 SummDescr1 Summer Term 1 Description      
MP56089 NVARCHAR VSTRING 3 0 3 Abbreviat1 Summary Term 1 Abbreviation      
MP56090 NVARCHAR VSTRING 15 0 15 SummDescr2 Summer Term 2 Description      
MP56091 NVARCHAR VSTRING 3 0 3 Abbreviat2 Summary Term 2 Abbreviation      
MP56092 NVARCHAR VSTRING 15 0 15 SummDescr3 Summer Term 3 Description      
MP56093 NVARCHAR VSTRING 3 0 3 Abbreviat3 Summary Term 3 Abbreviation      
MP56094 NVARCHAR VSTRING 15 0 15 SummDescr4 Summer Term 4 Description      
MP56095 NVARCHAR VSTRING 3 0 3 Abbreviat4 Summary Term 4 Abbreviation      
MP56096 NVARCHAR VSTRING 15 0 15 SummDescr5 Summer Term 5 Description      
MP56097 NVARCHAR VSTRING 3 0 3 Abbreviat5 Summary Term 5 Abbreviation      
MP56098 NVARCHAR VSTRING 15 0 15 SummDescr6 Summer Term 6 Description      
MP56099 NVARCHAR VSTRING 3 0 3 Abbreviat6 Summary Term 6 Abbreviation      
MP56100 NVARCHAR VSTRING 15 0 15 SummDescr7 Summer Term 7 Description      
MP56101 NVARCHAR VSTRING 3 0 3 Abbreviat7 Summary Term 7 Abbreviation      
MP56102 NVARCHAR VSTRING 15 0 15 SummDescr8 Summer Term 8 Description      
MP56103 NVARCHAR VSTRING 3 0 3 Abbreviat8 Summary Term 8 Abbreviation      
MP56104 NVARCHAR VSTRING 15 0 15 SummDescr9 Summer Term 9 Description      
MP56105 NVARCHAR VSTRING 3 0 3 Abbreviat9 Summary Term 9 Abbreviation      
MP56106 NVARCHAR VSTRING 12 0 12 GenDiffAcc General Difference Account      
MP56107 NVARCHAR VSTRING 3 0 3 LanguageCode Language      
MP56108 NVARCHAR VSTRING 6 0 6 DetailedGLTrans Detailed GL Transactions (pos 1) and Reporting Number as Text (pos 2)      
MP56109 NUMERIC NUMBER 20 0 9 NLTransCount (obsolete)      
MP56110 NUMERIC NUMBER 20 0 9 MPCTranCount (obsolete)      
MP56111 NVARCHAR VSTRING 6 0 6 IntegrToNL Integrated with General Ledger      
MP56112 NVARCHAR VSTRING 6 0 6 UseNLTrCount Use General Ledger Transaction Number      
MP56113 NVARCHAR VSTRING 6 0 6 WIPAccounting Create WIP Transactions      
MP56114 INT INTEGER 0 0 1 WIPCrStockItem Valuation of Receipt from WIP 0 — Stock deduction account will be updated with WIP amount.

1 — Stock deduction account will be updated with standard cost. Total variance posted to general account

2 — Stock deduction account updated with standard cost. Rest-variance posted to general account

3 — Stock deduction account updated with standard cost. Rest-variance posted to general account, (this applies when stock valuation model is different from standard cost).
   
MP56115 NVARCHAR VSTRING 12 0 12 Spare (obsolete)      
MP56116 NVARCHAR VSTRING 6 0 6 WIPTransact WIP Transactions: Use Accounting Code from Component      
MP56117 NVARCHAR VSTRING 6 0 6 UpdateWOOnReceipt Update Connected Work Order at Work Order Receipt      
MP56118 NVARCHAR VSTRING 6 0 6 UpdateOROnReceipt Update Connected Sales Order at Work Order Receipt      
MP56119 INT INTEGER 0 0 1 AutMatAnaliz Automatic Material Analysis      
MP56120 INT INTEGER 0 0 1 ForecDayinWk Master Planning: Day for Week to Day Conversion      
MP56121 INT INTEGER 0 0 2 ForecDayinMh Master Planning: Day for Month to Day Conversion      
MP56122 INT INTEGER 0 0 1 ForecSegonCu Master Planning: Section for Customer      
MP56123 INT INTEGER 0 0 1 ForecStat Master Planning: Summarise from Statistics      
MP56124 NUMERIC NUMBER 20 0 10 MatRepNoCounter (obsolete)      
MP56125 INT INTEGER 0 0 2 SortNoPickLi Sorting Number for Picking List      
MP56126 INT INTEGER 0 0 6 WOBatchIncr Work Order Batch Line Increment      
MP56127 NVARCHAR VSTRING 6 0 6 Spare Check All Warehouse at Material Analysis      
MP56128 NVARCHAR VSTRING 6 0 6 Spare Include Planned Orders in Material Analysis      
MP56129 NVARCHAR VSTRING 6 0 6 Spare (obsolete)      
MP56130 NVARCHAR VSTRING 6 0 6 SaveDistrDailyFctAs Save distributed daily forecast as      
MP56131 INT INTEGER 0 0 9 CalCollectionForecastDistr Calendar Collection for forecast distribution      
MP56132 NVARCHAR VSTRING 6 0 6 DefaultDistributionPeriod Default Distribution Period      
MP56133 NVARCHAR VSTRING 6 0 6 DeleteDailyFctBySel Delete Daily Forecasts by selection      
MP56134 NVARCHAR VSTRING 6 0 6 Spare (obsolete)      
MP56135 NVARCHAR VSTRING 6 0 6 Spare (obsolete)      
MP56136 NCHAR SWITCH 1 0 1 PTFSource PTF Source      
MP56137 INT INTEGER 0 0 4 PlanningTimeFence Planning Time Fence      
MP56138 NVARCHAR VSTRING 6 0 6 IncludeContactReserv Include Contract reservatioms in MPS, MRP, and SRP      
MP56139 NCHAR STRING 1 0 1 DeliveryTimePlanninginPurchProp DeliveryTimePlanning_in_Purch_Prop      
MP56140 INT INTEGER 0 0 1 ConvertTo ConvertTo      
MP56141 INT INTEGER 0 0 1 DefPurchOrderType DefaultPurchaseOrderType      
MP56142 INT INTEGER 0 0 1 DefRequisitionType DefaultRequisitionType      
MP56143 INT INTEGER 0 0 1 ConvertToSRP ConvertTo (SRP)      
MP56144 INT INTEGER 0 0 1 DefPurchOrderTypeSRP DefaultPurchaseOrderType (SRP)      
MP56145 INT INTEGER 0 0 1 DefRequisitionTypeSRP DefaultRequisitionType (SRP)      
MP56146 NVARCHAR VSTRING 1 0 1 PartialDeliveryPermitted default value for Subcontract WC parameter ‘Partial Delivery Permitted’      
MP56147 NVARCHAR VSTRING 1 0 1 OverDeliveryPermitted default value for Subcontract WC parameter ‘Over Delivery Permitted’      
MP56148 NVARCHAR VSTRING 1 0 1 QtyForPayment default value for Subcontract WC parameter ‘Quantity for payment’      
MP56149 NCHAR SWITCH 1 0 1 ConsiderLockedBatchesInMRP Consider Locked Batches In MRP      
MP56150 NCHAR SWITCH 1 0 1 ConsiderAllocatedQtyInMRP Consider Allocated Qty In MRP      
MP56151 NCHAR SWITCH 1 0 1 ForecastSegmentAsWarehouse Forecast Segment As Warehouse      
MP56152 INT INTEGER 0 0 9 CalendarForScheduledMRP Calendar For Scheduled MRP      
MP56153 INT INTEGER 0 0 2 SelectionEventMRP Selection for Event driven MRP      
MP56154 INT INTEGER 0 0 1 NumberOfRetries Number of retries      
MP56155 INT INTEGER 0 0 2 MaterialIssueLineIncrement Material Issue Line Increment      
MP56156 DATETIME DATE 0 0 8 FixedStartDate Fixed Start Date      
MP56157 INT INTEGER 0 0 1 OrderToSearchPlannedReceipts Order to search planned receipts      
MP56158 INT INTEGER 0 0 3 TimeTypePM Time type PM      
MP56159 INT INTEGER 0 0 1 AltRoutingFromBOM Alt. routing in WO creation from BOM      
MP56160 NVARCHAR VSTRING 2 0 2 AltRoutingCode Alt. routing for sub work orders      
MP56161 INT INTEGER 0 0 1 UpdateOR Update sales order      
MP56162 INT INTEGER 0 0 1 UpdateORTill Update sales order till      
MP56163 INT INTEGER 0 0 1 AllowORQtyAdjust Allow sales order qty adj      
MP56164 NCHAR SWITCH 1 0 1 CreateWOWithoutBOM Create work orders without BOM via B-function      
MP56165 NCHAR SWITCH 1 0 1 QueueMoveTimeLT Shall Queue and Move time be included in lead-times      
MP56166 INT INTEGER 0 0 1 WHSubcontrPO WH on subcontract PO      
MP56167 NCHAR SWITCH 1 0 1 WIPcostIsActualCostAtAverage Planned WIP cost is Actual cost at Average valuation      
MP56168 NCHAR SWITCH 1 0 1 WIPcostIsActualCostAtFIFO Planned WIP cost is Actual cost at FIFO valuation      
MP56169 NCHAR SWITCH 1 0 1 WIPcostIsActualCostAtStandard Planned WIP cost is Actual cost at Standard cost valuation      
MP56170 NCHAR SWITCH 1 0 1 WIPcostIsActualCostAtLIFO Planned WIP cost is Actual cost at LIFO valuation      
MP56171 INT INTEGER 0 0 2 AccCode2StdCost Accounting code 2, std. cost      
MP56172 NCHAR SWITCH 1 0 1 ExcludeCCOrders Exclude Credit blocked sales/service orders from MRP/MPS      

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