Apicosoft

ERP iScala Database Structure
iScala Supprort & Customization

Business processes implementation, ad-hock services, end-users training and education, maintenance support.

Read More Contact Us
Epicor Service Connect

Integration with any third-party services. Customize internal workflows.

Read More Contact Us
Reporting

SAP Crystal Reports, SQL Server Reporting Services, Excel.

Read More Contact Us
Tables
Name Description Dependences Example
MP00 Configuration Head Company MP000100
MP01 Configuration Lines Company MP010100
MP03 Accessory List Head Company MP030100
MP04 Accessory Lines Company MP040100
MP06 Automatic Accounting Schedule GOGS Company MP060100
MP07 Standard Cost Summary Company MP070100
MP08 Setup time per work centre Company MP080100
MP0B Distribution File Company MP0B0100
MP0D Configuration Word Order Company MP0D0100
MP10 Parameter Table for Time to Start Company MP100100
MP11 MPC Time to Start Proposals Company MP110100
MP12 Company MP120100
MP3L Company MP3L0100
MP50 Work Centers Company MP500100
MP52 Tools Company MP520100
MP54 Cost Codes Company MP540100
MP55 Sum.part of tmp MP550000
MP56 MPC Parameters Company Year MP560112
MP57 MPC Stock Item Details Company MP570100
MP58 MPC Calculus Models Company MP580100
MP59 MPC Calculus Constants Company MP590100
MP5A Component Mater MP5A0000
MP5B Cust. No/Order MP5B0000
MP5C Temp. Sel.Term MP5C0000
MP5D Temp.ECO Hist. MP5D0000
MP5E Wrk.OR Mater.An MP5E0000
MP5F Picking L. Sort MP5F0000
MP5G Wrk.Cum.Mater.1 MP5G0000
MP5H Wrk.Cum.Mater.2 MP5H0000
MP5I Wrk.Reconfigur. MP5I0000
MP5J Wrk.Dispatching MP5J0000
MP5K Wrk.Completed S MP5K0000
MP5M Wrk. Costing MP5M0000
MP5N Compare struct MP5N0000
MP5O Wrk. for MP0562 MP5O0000
MP60 Tmp.Actual cost MP600000
MP61 MPC Bill of Material Company MP610100
MP62 Work Centre Load Company MP620100
MP63 Routings Company MP630100
MP64 Work Orders Company MP640100
MP65 Work Order BOM Company MP650100
MP66 Work Order BOM Issues Company MP660100
MP67 Work Order Routings Company MP670100
MP68 Work Order Batch Lines Company MP680100
MP69 Dispatched Load Company MP690100
MP6E Master Planning Schedule Print-Out (Temp. File) MP6E0000
MP6F Temporary file for Mtrl. issues MP6F0000
MP6G Work File for use in SC06002 MP6G0000
MP6H Work File for use in SC0661 MP6H0000
MP6I Work File for use in SC0662 MP6I0000
MP6J Work File for use in SC0668 MP6J0000
MP6K Work File for use in SC0669 MP6K0000
MP6L Temp.file for Actual Cost/Sales Order MP6L0000
MP70 Free Headers Company MP700100
MP71 Free Texts Company MP710100
MP72 Enquiry File Company MP720100
MP73 Description Free Fields Company MP730100
MP74 Report Numbers Company MP740100
MP75 Production Statistics Company MP750100
MP76 Actual Cost Head Company MP760100
MP77 Actual Cost Material Company MP770100
MP78 Actual Cost Operations Company MP780100
MP79 Actual Cost Transactions Company MP790100
MP7A Family/Foreman area/Department temporary file MP7A0000
MP80 Calculus File Company MP800100
MP82 Work Center Calendar Company MP820100
MP83 Phantom Material List Temporary File MP830000
MP84 Phantom Operation List Temporary file MP840000
MP85 Customer Order to Work Order 1 Company MP850100
MP86 Customer Order to Work Order 2 Company MP860100
MP87 MPC Code File Company MP870100
MP89 Stock Planning + Gross Requirements (Temp. File) MP890000
MP8D Work File for use in SC0585 MP8D0000
MP90 Automatic Accounting Schedule WIP Company MP900100
MP91 WIP Transactions Company MP910100
MP92 MRP Stock Planning Company MP920100
MP93 MPS Stock Planning Company MP930100
MP94 Forecast Product Group Distribution Company MP940100
MP95 Forecasts Company MP950100
MP96 MRP/SRP Replenishment Proposals Company MP960100
MP97 ECO History Company MP970100
MP98 GOGS Order Accounting Company MP980100
MP9B Temporay File B for MRP MP9B0000
MP9C WIP Transactions Journal Company Year MP9C0112
MP9W WIP Transactions History Company MP9W0100
MPCM Graphical Planning Layer/Info colors Company MPCM0100
MPFC Company MPFC0100
MPGI MRP Group Dependent Item Data Company MPGI0100
MPGN MRP Group Independent Net Event Company MPGN0100
MPGP Graphical Planning Configuration Company MPGP0100
MPGR Node-Type configuration Company MPGR0100
MPGS MRP Group Dependent Net Event Company MPGS0100
MPLF MRP/MPS Action screen coordination table Company MPLF0100
MPLL Sales order lines to work order link Company MPLL0100
MPM0 Gross Requirement temporary file Company MPM00100
MPM1 Forecast OP temporay file Company MPM10100
MPM2 Forecast Workcenter temporary file Company MPM20100
MPM3 Forecast Load temporay file Company MPM30100
MPM4 API of forecast print-out temporary file MPM40000
MPM5 Gross Requirement temporary file MPM50000
MPMG Company MPMG0100
MPMS Definitions of fixed MRP/MPS bucket schedules Company MPMS0100
MPMW Company MPMW0100
MPOL Work order type description Company MPOL0100
MPOT Work order type setup Company MPOT0100
MPPG MRP Pegging Company MPPG0100
MPRO RMA link Company MPRO0100
sca_trg_Audit_MP50 Audit trigger for MP50 table Company sca_trg_Audit_MP500100
sca_trg_Audit_MP54 Audit trigger for MP54 table Company sca_trg_Audit_MP540100
sca_trg_Audit_MP57 Audit trigger for MP57 table Company sca_trg_Audit_MP570100
sca_trg_Audit_MP61 Audit trigger for MP61 table Company sca_trg_Audit_MP610100
sca_trg_Audit_MP63 Audit trigger for MP63 table Company sca_trg_Audit_MP630100

Fields
PK Table Name Description Type Length Precision Note
1 MP56 MP56001 YearCode STRING 2 2 0 Year
MP56 MP56002 IntCodeCalcL INTEGER 3 0 0 Internal Code Calculation Lead Time
MP56 MP56003 IntCodeCalc INTEGER 3 0 0 Internal Code Calculus
MP56 MP56004 Spare VSTRING 10 10 0 (obsolete)
MP56 MP56005 Spare VSTRING 10 10 0 (obsolete)
MP56 MP56006 Spare VSTRING 10 10 0 (obsolete)
MP56 MP56007 Validity VSTRING 6 6 0 Effective Date
MP56 MP56008 OpeComponent VSTRING 6 6 0 Open Items
MP56 MP56009 OpenQuantity VSTRING 6 6 0 Open Quantity
MP56 MP56010 Warehouse VSTRING 6 6 0 Warehouse
MP56 MP56011 ExtraSetup VSTRING 6 6 0 Extra Setup and Runtime
MP56 MP56012 AccPossibility VSTRING 6 6 0 Accounting Possibility
MP56 MP56013 OpenTime VSTRING 6 6 0 Open Setup/Run
MP56 MP56014 ConfirmCOWO VSTRING 6 6 0 Confirm Conversion Customer Order to Work Order
MP56 MP56015 UseStockEval VSTRING 6 6 0 Use Evaluation Model from Stock Control
MP56 MP56016 StockTransact VSTRING 6 6 0 Stock Transactions: Use Accounting Code from Component
MP56 MP56017 AlterRouting VSTRING 6 6 0 Alternate Routings
MP56 MP56018 ReportingMat VSTRING 6 6 0 Manual Reporting of Material
MP56 MP56019 ReportRout VSTRING 6 6 0 Manual Reporting of Routing
MP56 MP56020 MateriaIssue INTEGER 1 0 0 When are Material Issue
MP56 MP56021 OperatReport INTEGER 1 0 0 When are Operation Reported
MP56 MP56022 RecLastOperation VSTRING 6 6 0 Receipt at Reporting Last Operation
MP56 MP56023 ImmediateUpd VSTRING 6 6 0 Immediate Update at Receipt with Work Order
MP56 MP56024 Spare VSTRING 6 6 0 Spare
MP56 MP56025 Spare VSTRING 6 6 0 Special Cost Calculation
MP56 MP56026 OpnrSameNo VSTRING 6 6 0 BOM: Number = Operation Number
MP56 MP56027 Number INTEGER 2 0 0 Number Increment
MP56 MP56028 Opnr INTEGER 2 0 0 Operation Number Increment
MP56 MP56029 Rate VSTRING 6 6 0 Use Production Rate
MP56 MP56030 Spare VSTRING 6 6 0 (obsolete)
MP56 MP56031 Spare VSTRING 6 6 0 (obsolete)
MP56 MP56032 Spare VSTRING 6 6 0 (obsolete)
MP56 MP56033 ReplenishmentProp NUMBER 10 20 0 ReplenishmentProposals
MP56 MP56034 MRPReportNo NUMBER 10 20 0 (obsolete)
MP56 MP56035 Pegging VSTRING 6 6 0 Pegging
MP56 MP56036 LowestStrLev INTEGER 6 0 0 Lowest Structure Level
MP56 MP56037 OrderSerieA NUMBER 10 20 0 (obsolete)
MP56 MP56038 OrderSerieB NUMBER 10 20 0 (obsolete)
MP56 MP56039 OrderSerieC NUMBER 10 20 0 (obsolete)
MP56 MP56040 OrderSerieD NUMBER 10 20 0 (obsolete)
MP56 MP56041 OrderSerieE NUMBER 10 20 0 (obsolete)
MP56 MP56042 OrderSerieF NUMBER 10 20 0 (obsolete)
MP56 MP56043 ReportNumber NUMBER 10 20 0 (obsolete)
MP56 MP56044 LoadingCode VSTRING 1 1 0 Loading Code 0 - Forward planning
1 - Backwards planning
2 - Locked planning
MP56 MP56045 UpdBillMat VSTRING 6 6 0 Automatic Update of BOM
MP56 MP56046 UpdRoutList VSTRING 6 6 0 Automatic Update of Routing
MP56 MP56047 CreaCostSyst VSTRING 6 6 0 Create Actual Cost per Work Order
MP56 MP56048 MatRoutList INTEGER 2 0 0 Picking List by Operation Copies
MP56 MP56049 MatRequList INTEGER 2 0 0 Picking List Copies
MP56 MP56050 RoutingLists INTEGER 2 0 0 Operation List Copies
MP56 MP56051 ShopTravellers INTEGER 2 0 0 Traveller Document Copies
MP56 MP56052 JobTickets INTEGER 2 0 0 Job Ticket Copies
MP56 MP56053 LabelsType1 INTEGER 2 0 0 Label Type 1 Copies
MP56 MP56054 LabelsType2 INTEGER 2 0 0 Label Type 2 Copies
MP56 MP56055 ShopTravSubc INTEGER 2 0 0 Traveller Vendor Document Copies
MP56 MP56056 ReportReceipts INTEGER 2 0 0 Report Work Order Receipt Copies
MP56 MP56057 TravellerVen INTEGER 2 0 0 Routing List Copies
MP56 MP56058 Spare INTEGER 1 0 0 (obsolete)
MP56 MP56059 COWOBatch INTEGER 1 0 0 (obsolete)
MP56 MP56060 AnswOpenEnqu VSTRING 6 6 0 Open Enquiries at Customer Order to Work Order
MP56 MP56061 DaysBefDeliv INTEGER 2 0 0 Number of Days Due to Delivery Date
MP56 MP56062 CummMatRequL VSTRING 6 6 0 Cumulated Picking List
MP56 MP56063 SpecOrderNo INTEGER 1 0 0 Work Order Number Setting from Customer Order 0 - Order series entered manually
1 - Use sales order number plus 2 last character in order position
MP56 MP56064 OrderSerieG NUMBER 10 20 0 (obsolete)
MP56 MP56065 OrderSerieH NUMBER 10 20 0 (obsolete)
MP56 MP56066 OrderSerieI NUMBER 10 20 0 (obsolete)
MP56 MP56067 OrderSerieJ NUMBER 10 20 0 (obsolete)
MP56 MP56068 OrderSerieK NUMBER 10 20 0 (obsolete)
MP56 MP56069 OrderSerieL NUMBER 10 20 0 (obsolete)
MP56 MP56070 OrderSerieM NUMBER 10 20 0 (obsolete)
MP56 MP56071 OrderSerieN NUMBER 10 20 0 (obsolete)
MP56 MP56072 OrderSerieO NUMBER 10 20 0 (obsolete)
MP56 MP56073 OrderSerieP NUMBER 10 20 0 (obsolete)
MP56 MP56074 OrderSerieQ NUMBER 10 20 0 (obsolete)
MP56 MP56075 OrderSerieR NUMBER 10 20 0 (obsolete)
MP56 MP56076 OrderSerieS NUMBER 10 20 0 (obsolete)
MP56 MP56077 OrderSerieT NUMBER 10 20 0 (obsolete)
MP56 MP56078 OrderSerieU NUMBER 10 20 0 (obsolete)
MP56 MP56079 OrderSerieV NUMBER 10 20 0 (obsolete)
MP56 MP56080 OrderSerieW NUMBER 10 20 0 (obsolete)
MP56 MP56081 OrderSerieX NUMBER 10 20 0 (obsolete)
MP56 MP56082 OrderSerieY NUMBER 10 20 0 (obsolete)
MP56 MP56083 OrderSerieZ NUMBER 10 20 0 (obsolete)
MP56 MP56084 TypeMatCost INTEGER 1 0 0 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
MP56 MP56085 TimeMargin INTEGER 3 0 0 Time Margin
MP56 MP56086 Spare VSTRING 6 6 0 Update with Zero Standard Cost
MP56 MP56087 UpdateLatestCalcDate VSTRING 6 6 0 Update Last Cost Calculation Date
MP56 MP56088 SummDescr1 VSTRING 15 15 0 Summer Term 1 Description
MP56 MP56089 Abbreviat1 VSTRING 3 3 0 Summary Term 1 Abbreviation
MP56 MP56090 SummDescr2 VSTRING 15 15 0 Summer Term 2 Description
MP56 MP56091 Abbreviat2 VSTRING 3 3 0 Summary Term 2 Abbreviation
MP56 MP56092 SummDescr3 VSTRING 15 15 0 Summer Term 3 Description
MP56 MP56093 Abbreviat3 VSTRING 3 3 0 Summary Term 3 Abbreviation
MP56 MP56094 SummDescr4 VSTRING 15 15 0 Summer Term 4 Description
MP56 MP56095 Abbreviat4 VSTRING 3 3 0 Summary Term 4 Abbreviation
MP56 MP56096 SummDescr5 VSTRING 15 15 0 Summer Term 5 Description
MP56 MP56097 Abbreviat5 VSTRING 3 3 0 Summary Term 5 Abbreviation
MP56 MP56098 SummDescr6 VSTRING 15 15 0 Summer Term 6 Description
MP56 MP56099 Abbreviat6 VSTRING 3 3 0 Summary Term 6 Abbreviation
MP56 MP56100 SummDescr7 VSTRING 15 15 0 Summer Term 7 Description
MP56 MP56101 Abbreviat7 VSTRING 3 3 0 Summary Term 7 Abbreviation
MP56 MP56102 SummDescr8 VSTRING 15 15 0 Summer Term 8 Description
MP56 MP56103 Abbreviat8 VSTRING 3 3 0 Summary Term 8 Abbreviation
MP56 MP56104 SummDescr9 VSTRING 15 15 0 Summer Term 9 Description
MP56 MP56105 Abbreviat9 VSTRING 3 3 0 Summary Term 9 Abbreviation
MP56 MP56106 GenDiffAcc VSTRING 12 12 0 General Difference Account
MP56 MP56107 LanguageCode VSTRING 3 3 0 Language
MP56 MP56108 DetailedGLTrans VSTRING 6 6 0 Detailed GL Transactions (pos 1) and Reporting Number as Text (pos 2)
MP56 MP56109 NLTransCount NUMBER 9 20 0 (obsolete)
MP56 MP56110 MPCTranCount NUMBER 9 20 0 (obsolete)
MP56 MP56111 IntegrToNL VSTRING 6 6 0 Integrated with General Ledger
MP56 MP56112 UseNLTrCount VSTRING 6 6 0 Use General Ledger Transaction Number
MP56 MP56113 WIPAccounting VSTRING 6 6 0 Create WIP Transactions
MP56 MP56114 WIPCrStockItem INTEGER 1 0 0 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).
MP56 MP56115 Spare VSTRING 12 12 0 (obsolete)
MP56 MP56116 WIPTransact VSTRING 6 6 0 WIP Transactions: Use Accounting Code from Component
MP56 MP56117 UpdateWOOnReceipt VSTRING 6 6 0 Update Connected Work Order at Work Order Receipt
MP56 MP56118 UpdateOROnReceipt VSTRING 6 6 0 Update Connected Sales Order at Work Order Receipt
MP56 MP56119 AutMatAnaliz INTEGER 1 0 0 Automatic Material Analysis
MP56 MP56120 ForecDayinWk INTEGER 1 0 0 Master Planning: Day for Week to Day Conversion
MP56 MP56121 ForecDayinMh INTEGER 2 0 0 Master Planning: Day for Month to Day Conversion
MP56 MP56122 ForecSegonCu INTEGER 1 0 0 Master Planning: Section for Customer
MP56 MP56123 ForecStat INTEGER 1 0 0 Master Planning: Summarise from Statistics
MP56 MP56124 MatRepNoCounter NUMBER 10 20 0 (obsolete)
MP56 MP56125 SortNoPickLi INTEGER 2 0 0 Sorting Number for Picking List
MP56 MP56126 WOBatchIncr INTEGER 6 0 0 Work Order Batch Line Increment
MP56 MP56127 Spare VSTRING 6 6 0 Check All Warehouse at Material Analysis
MP56 MP56128 Spare VSTRING 6 6 0 Include Planned Orders in Material Analysis
MP56 MP56129 Spare VSTRING 6 6 0 (obsolete)
MP56 MP56130 SaveDistrDailyFctAs VSTRING 6 6 0 Save distributed daily forecast as
MP56 MP56131 CalCollectionForecastDistr INTEGER 9 0 0 Calendar Collection for forecast distribution
MP56 MP56132 DefaultDistributionPeriod VSTRING 6 6 0 Default Distribution Period
MP56 MP56133 DeleteDailyFctBySel VSTRING 6 6 0 Delete Daily Forecasts by selection
MP56 MP56134 Spare VSTRING 6 6 0 (obsolete)
MP56 MP56135 Spare VSTRING 6 6 0 (obsolete)
MP56 MP56136 PTFSource SWITCH 1 1 0 PTF Source
MP56 MP56137 PlanningTimeFence INTEGER 4 0 0 Planning Time Fence
MP56 MP56138 IncludeContactReserv VSTRING 6 6 0 Include Contract reservatioms in MPS, MRP, and SRP
MP56 MP56139 DeliveryTimePlanninginPurchProp STRING 1 1 0 DeliveryTimePlanning_in_Purch_Prop
MP56 MP56140 ConvertTo INTEGER 1 0 0 ConvertTo
MP56 MP56141 DefPurchOrderType INTEGER 1 0 0 DefaultPurchaseOrderType
MP56 MP56142 DefRequisitionType INTEGER 1 0 0 DefaultRequisitionType
MP56 MP56143 ConvertToSRP INTEGER 1 0 0 ConvertTo (SRP)
MP56 MP56144 DefPurchOrderTypeSRP INTEGER 1 0 0 DefaultPurchaseOrderType (SRP)
MP56 MP56145 DefRequisitionTypeSRP INTEGER 1 0 0 DefaultRequisitionType (SRP)
MP56 MP56146 PartialDeliveryPermitted VSTRING 1 1 0 default value for Subcontract WC parameter ‘Partial Delivery Permitted’
MP56 MP56147 OverDeliveryPermitted VSTRING 1 1 0 default value for Subcontract WC parameter ‘Over Delivery Permitted’
MP56 MP56148 QtyForPayment VSTRING 1 1 0 default value for Subcontract WC parameter ‘Quantity for payment’
MP56 MP56149 ConsiderLockedBatchesInMRP SWITCH 1 1 0 Consider Locked Batches In MRP
MP56 MP56150 ConsiderAllocatedQtyInMRP SWITCH 1 1 0 Consider Allocated Qty In MRP
MP56 MP56151 ForecastSegmentAsWarehouse SWITCH 1 1 0 Forecast Segment As Warehouse
MP56 MP56152 CalendarForScheduledMRP INTEGER 9 0 0 Calendar For Scheduled MRP
MP56 MP56153 SelectionEventMRP INTEGER 2 0 0 Selection for Event driven MRP
MP56 MP56154 NumberOfRetries INTEGER 1 0 0 Number of retries
MP56 MP56155 MaterialIssueLineIncrement INTEGER 2 0 0 Material Issue Line Increment
MP56 MP56156 FixedStartDate DATE 8 0 0 Fixed Start Date
MP56 MP56157 OrderToSearchPlannedReceipts INTEGER 1 0 0 Order to search planned receipts
MP56 MP56158 TimeTypePM INTEGER 3 0 0 Time type PM
MP56 MP56159 AltRoutingFromBOM INTEGER 1 0 0 Alt. routing in WO creation from BOM
MP56 MP56160 AltRoutingCode VSTRING 2 2 0 Alt. routing for sub work orders
MP56 MP56161 UpdateOR INTEGER 1 0 0 Update sales order
MP56 MP56162 UpdateORTill INTEGER 1 0 0 Update sales order till
MP56 MP56163 AllowORQtyAdjust INTEGER 1 0 0 Allow sales order qty adj
MP56 MP56164 CreateWOWithoutBOM SWITCH 1 1 0 Create work orders without BOM via B-function
MP56 MP56165 QueueMoveTimeLT SWITCH 1 1 0 Shall Queue and Move time be included in lead-times
MP56 MP56166 WHSubcontrPO INTEGER 1 0 0 WH on subcontract PO
MP56 MP56167 WIPcostIsActualCostAtAverage SWITCH 1 1 0 Planned WIP cost is Actual cost at Average valuation
MP56 MP56168 WIPcostIsActualCostAtFIFO SWITCH 1 1 0 Planned WIP cost is Actual cost at FIFO valuation
MP56 MP56169 WIPcostIsActualCostAtStandard SWITCH 1 1 0 Planned WIP cost is Actual cost at Standard cost valuation
MP56 MP56170 WIPcostIsActualCostAtLIFO SWITCH 1 1 0 Planned WIP cost is Actual cost at LIFO valuation
MP56 MP56171 AccCode2StdCost INTEGER 2 0 0 Accounting code 2, std. cost
MP56 MP56172 ExcludeCCOrders SWITCH 1 1 0 Exclude Credit blocked sales/service orders from MRP/MPS
MP56 MP56173 CopyToOP VSTRING 20 20 0 Copy To OP
MP56 MP56174 ConfirmationControlledbyPlanner SWITCH 1 1 0 Confirmation Controlled by Planner
MP56 MP56175 ATPPeriodShift INTEGER 1 0 0 ATP Period Shift
MP56 MP56176 NoDecRepRuntime INTEGER 1 0 0 Number of Decimals, Reported Runtime
MP56 MP56177 ReleaseWOAfterchange SWITCH 1 1 0 Release WO After Change
MP56 MP56178 PlanDisconnectedMtrlFirstOp SWITCH 1 1 0 Plan disconnected material at first operation