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 MP57 MP57001 StockCode STRING 35 35 0 Stock Item Code
MP57 MP57002 LeadTimeOneLevel INTEGER 3 0 0 Lead Time, One Level
MP57 MP57003 LeadTExclP INTEGER 3 0 0 Cumulated Lead Time Excluding Purchase Lead Time
MP57 MP57004 LeadTInclP INTEGER 3 0 0 Cumulated Lead Time Including Purchase Lead Time
MP57 MP57005 IntCodeComp INTEGER 3 0 0 Internal code for lead-time calculation
MP57 MP57006 PrevStdCost MONEY 20 28 8 Standard Cost Previous
MP57 MP57007 Suffix VSTRING 8 8 0 Suffix
MP57 MP57008 SumofStdCosts MONEY 20 28 8 Cumulated standard cost
MP57 MP57009 ComingStdCosts MONEY 20 28 8 Standard Cost Next
MP57 MP57010 SimuStdCosts MONEY 20 28 8 Standard Cost Simulated
MP57 MP57011 SpcProdCost1 MONEY 20 28 8 Special Production Cost 1
MP57 MP57012 SpcProdCost2 MONEY 20 28 8 Special Production Cost 2
MP57 MP57013 SpcProdCost3 MONEY 20 28 8 Special Production Cost 3
MP57 MP57014 SpcProdCost4 MONEY 20 28 8 Special Production Cost 4
MP57 MP57015 CostingModel VSTRING 6 6 0 Costing Model
MP57 MP57016 CostingFact VSTRING 6 6 0 Costing Factor
MP57 MP57017 IntCompCost INTEGER 3 0 0 Internal code for standard cost calculation
MP57 MP57018 DrawingNo VSTRING 20 20 0 Drawing Number
MP57 MP57019 Spare VSTRING 8 8 0 Forecast number
MP57 MP57020 LatestVerDate DATE 8 0 0 Latest Version Date, Manufacturing BOM
MP57 MP57021 PlanningMethod VSTRING 1 1 0 Planning code
MP57 MP57022 MPSPlanned SWITCH 1 1 0 Used in MPS Planning
MP57 MP57023 StockIssCode INTEGER 1 0 0 Planning Code
MP57 MP57024 Planner VSTRING 15 15 0 Planner
MP57 MP57025 Spare INTEGER 2 0 0 Manufacturing Method
MP57 MP57026 LotSizingTechnique INTEGER 1 0 0 Lot Size Technique
MP57 MP57027 Multiple X_NUMERIC 12 20 8 Planned Quantity Multiple
MP57 MP57028 SafetyStock X_NUMERIC 12 20 8 Safety Stock
MP57 MP57029 SafetyTime INTEGER 3 0 0 Safety Time
MP57 MP57030 Forecast1 X_NUMERIC 12 20 8 Forecast 1
MP57 MP57031 Forecast2 X_NUMERIC 12 20 8 Forecast 2
MP57 MP57032 Forecast3 X_NUMERIC 12 20 8 Forecast 3
MP57 MP57033 Forecast4 X_NUMERIC 12 20 8 Forecast 4
MP57 MP57034 Spare VSTRING 35 35 0 Picture ID
MP57 MP57035 CriticalMat SWITCH 1 1 0 Critical Material
MP57 MP57036 UnitPerLot X_NUMERIC 12 20 8 No of Units per Lot
MP57 MP57037 SizeOfLot X_NUMERIC 12 20 8 Lot Size
MP57 MP57038 LotUnitCode INTEGER 4 0 0 Unit Code Lot
MP57 MP57039 LotStuffing X_NUMERIC 12 20 8 Lot Stuffing
MP57 MP57040 Yeild X_NUMERIC 6 14 8 Yield %
MP57 MP57041 LowLevelCode INTEGER 2 0 0 Low level code
MP57 MP57042 MRPNeed INTEGER 1 0 0 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.
MP57 MP57043 MRPDaysOR INTEGER 3 0 0 MRP - Reservation in Days
MP57 MP57044 WOthroughBoM SWITCH 1 1 0 Stop Creating WO through BOM
MP57 MP57045 MRPDaysNeed INTEGER 3 0 0 MRP - Number of Days Due Before Need
MP57 MP57046 CalcReorPoint VSTRING 1 1 0 Reorder Point Flag 0 - Planned by reservations.
1 - Planned by reorder point, not in MRP
2 - Manual planning.
MP57 MP57047 SparePartCode INTEGER 1 0 0 Spare Part Flag 1 - Not a spare part
2 - May be a spare part
3 - Always a spare part
MP57 MP57048 Status INTEGER 1 0 0 Status
MP57 MP57049 ECHManufact SWITCH 1 1 0 Create ECH on Manufacturing BOM
MP57 MP57050 ECHEngineering SWITCH 1 1 0 Create ECH on Engineering BOM
MP57 MP57051 PresStdCost DATE 8 0 0 Last Date for Present Standard Cost Calculation
MP57 MP57052 VerNoManufact VSTRING 10 10 0 Version Number Manufacturing BOM
MP57 MP57053 VerNoEngineering VSTRING 10 10 0 Version Number Engineering BOM
MP57 MP57054 LatVerDatEng DATE 8 0 0 Last Version Date Engineering BOM
MP57 MP57055 Scrap X_NUMERIC 6 14 8 Scrap %
MP57 MP57056 PrintOutMPS SWITCH 1 1 0 Print on MPS/MPS Purchase Plan
MP57 MP57057 FreeTxtStock VSTRING 1 1 0 Text exists
MP57 MP57058 OpenCompExist INTEGER 2 0 0 Open component exists
MP57 MP57059 OpenQtyExist INTEGER 2 0 0 Open quantity exists
MP57 MP57060 OpenTimeExist INTEGER 2 0 0 Open time exists
MP57 MP57061 ManufactRel INTEGER 4 0 0 Manufacturing BOM Release Number
MP57 MP57062 EngineerRel INTEGER 4 0 0 Engineering BOM Release Number
MP57 MP57063 DispatchTerm VSTRING 20 20 0 Dispatch Term
MP57 MP57064 WOAutomatCre INTEGER 1 0 0 Create Work Order from Sales Order
MP57 MP57065 Configuration VSTRING 35 35 0 Configuration Code
MP57 MP57066 WOBatchTraceability VSTRING 1 1 0 Work Order Batch Traceability
MP57 MP57067 LeadTimeMRP INTEGER 3 0 0 Lead Time MRP Calculation
MP57 MP57068 SPARE INTEGER 3 0 0 Time margin 1
MP57 MP57069 SPARE INTEGER 3 0 0 Time margin 2
MP57 MP57070 ReceiptWH VSTRING 6 6 0 Warehouse for Receipt
MP57 MP57071 ProductionWH VSTRING 6 6 0 Warehouse for Manufacturing
MP57 MP57072 DrawingFormat VSTRING 1 1 0 Drawing Format
MP57 MP57073 Spare SWITCH 1 1 0 Create ECH on OP
MP57 MP57074 DDFFileNo INTEGER 1 0 0 Document Layout Code
MP57 MP57075 CostingQty X_NUMERIC 12 20 8 Costing Quantity
MP57 MP57076 MRPdaysFixed INTEGER 5 0 0 MRP - Fixed Period of Time
MP57 MP57077 Spare INTEGER 10 0 0 Version Number, Operations
MP57 MP57078 Spare INTEGER 8 0 0 Latest Version Date, Operations
MP57 MP57079 Spare INTEGER 4 0 0 Release No, Operations
MP57 MP57080 Spare INTEGER 1 0 0 Lead Time Unit
MP57 MP57081 LeadTimeLevel INTEGER 3 0 0 Lead Time to Level on Stock
MP57 MP57082 MaxStock X_NUMERIC 12 20 8 Max Stock
MP57 MP57083 TurnoverPlan X_NUMERIC 12 20 8 Turnover, Planned
MP57 MP57084 TurnoverAct X_NUMERIC 12 20 8 Turnover, Actual
MP57 MP57085 NoOfIssues INTEGER 12 0 0 Number of issues
MP57 MP57086 LatUsageDate DATE 8 0 0 Latest Usage Date
MP57 MP57087 QuantityUsed X_NUMERIC 12 20 8 Quantity Used
MP57 MP57088 ExistsInBoMs INTEGER 6 0 0 Exists in number of BOM:s
MP57 MP57089 ExtrStockCode VSTRING 35 35 0 Extra Stock Code
MP57 MP57090 VerNoStock INTEGER 10 0 0 Version Number Stock
MP57 MP57091 LatVerDatStock DATE 8 0 0 Latest Version Date Stock
MP57 MP57092 OperatHist SWITCH 1 1 0 Operation History
MP57 MP57093 OperHistDate DATE 8 0 0 Operation History date
MP57 MP57094 VerOperation INTEGER 10 0 0 Version Operation
MP57 MP57095 RelNoOperation INTEGER 4 0 0 Release No Operation
MP57 MP57096 StockStatCode INTEGER 1 0 0 Stock Status Code
MP57 MP57097 StopWOBfunc SWITCH 1 1 0 Stop in B-function
MP57 MP57098 OrdPropFcast SWITCH 1 1 0 Do not Create Order Proposals From Forecast
MP57 MP57099 ManWrkCentre VSTRING 8 8 0 Managing Work Centre
MP57 MP57100 ORContMat SWITCH 1 1 0 Sales Order Controlled Material
MP57 MP57101 Kanban SWITCH 1 1 0 Kanban
MP57 MP57102 AltMatPrice MONEY 20 28 8 Alt. Material Price
MP57 MP57103 FixLeadtime INTEGER 3 0 0 Fixed lead time
MP57 MP57104 VarLeadtime INTEGER 3 0 0 Variable lead time
MP57 MP57105 ModeratTime INTEGER 3 0 0 Moderation time
MP57 MP57106 ControlTime INTEGER 3 0 0 Control time
MP57 MP57107 FamilyCode VSTRING 1 1 0 Family code
MP57 MP57108 Family VSTRING 4 4 0 Family
MP57 MP57109 AddSpcCost SWITCH 1 1 0 Add Special Costs to Standard Cost
MP57 MP57110 AltCalcModel VSTRING 6 6 0 Alt. Calculus Model
MP57 MP57111 BatchPattern VSTRING 6 6 0 Batch Pattern
MP57 MP57112 FPODate DATE 8 0 0 FPO-Date
MP57 MP57113 Spare VSTRING 20 20 0 Forecast Segment
MP57 MP57114 Spare VSTRING 12 12 0 Spare
MP57 MP57115 Spare VSTRING 3 3 0 Spare
MP57 MP57116 Spare VSTRING 3 3 0 Spare
MP57 MP57117 Spare VSTRING 3 3 0 Spare
MP57 MP57118 Spare STRING 8 8 0 Spare
MP57 MP57119 Spare STRING 8 8 0 Spare
MP57 MP57120 Spare STRING 8 8 0 Spare
MP57 MP57121 AccLeadtime INTEGER 3 0 0 Acc. Lead time, MRP
MP57 MP57122 BOMStatusTypeM INTEGER 2 0 0 BOM Status Type M
MP57 MP57123 BOMStatusTypeE INTEGER 2 0 0 BOM Status Type E
MP57 MP57124 PlanningTimeFence INTEGER 4 0 0 Planning Time Fence
MP57 MP57125 DemandTimeFence INTEGER 4 0 0 Demand Time Fence
MP57 MP57126 ForecastConsumptionPeriod INTEGER 1 0 0 Forecast Consumption Period
MP57 MP57127 ForecastConsumptionOrder INTEGER 1 0 0 Forecast Consumption Order
MP57 MP57128 BackwardPeriods INTEGER 2 0 0 Backward Periods
MP57 MP57129 ForwardPeriods INTEGER 2 0 0 Forward Periods
MP57 MP57130 ForecastConsumptionRuleforcurrentperiod INTEGER 1 0 0 Forecast Consumption Rule for current period
MP57 MP57131 ForecastConsumptionRuleforpreviousperiods INTEGER 1 0 0 Forecast Consumption Rule for previous periods
MP57 MP57132 ForecastConsumptionRulefornextperiodswithinDTF INTEGER 1 0 0 Forecast Consumption Rule for next periods within DTF
MP57 MP57133 ForecastConsumptionRulefornextperiodsbeyondDTF INTEGER 1 0 0 Forecast Consumption Rule for next periods beyond DTF
MP57 MP57134 LastPTFDate DATE 8 0 0 Last PTF date MPS
MP57 MP57135 LastPTFDateMRP DATE 8 0 0 Last PTF date MRP/SRP
MP57 MP57136 ExcludedFromMRPNet SWITCH 1 1 0 Excluded from MRP net
MP57 MP57137 DaysBeforeNeedToSearchCoverage INTEGER 5 0 0 Days before need to search coverage
MP57 MP57138 DaysAfterNeedToSearchCoverage INTEGER 5 0 0 Days after need to search coverage
MP57 MP57139 SafetyStockLeadTime INTEGER 3 0 0 Safety Stock Lead Time
MP57 MP57140 AllowProposalTypeChange SWITCH 1 1 0 Allow change of proposal type
MP57 MP57141 FixedBucketSchedule INTEGER 2 0 0 Fixed Bucket Schedule for MRP/MPS
MP57 MP57142 BackFlushCode INTEGER 1 0 0 Back Flush Code
MP57 MP57143 CreateECHonDisassemblyBOM SWITCH 1 1 0 Create ECH on Disassembly BOM
MP57 MP57144 CreateECHonRepairBOM SWITCH 1 1 0 Create ECH on Repair BOM
MP57 MP57145 VersionNumDisassemblyBOM VSTRING 10 10 0 Version number, Disassembly BOM
MP57 MP57146 VersionNumRepairBOM VSTRING 10 10 0 Version number, Repair BOM
MP57 MP57147 DisassemblyBOMReleaseNum INTEGER 4 0 0 Release number Disassembly
MP57 MP57148 RepairBOMReleaseNum INTEGER 4 0 0 Release number Repair
MP57 MP57149 LastVersionDateDisassemblyBOM DATE 8 0 0 Last version date, Disassembly BOM
MP57 MP57150 LastVersionDateRepairBOM DATE 8 0 0 Last version date, Repair BOM
MP57 MP57151 BOMStatusDisassemblyBOM INTEGER 2 0 0 BOM status, Disassembly BOM
MP57 MP57152 BOMStatusRepairBOM INTEGER 2 0 0 BOM status, Repair BOM
MP57 MP57153 GRPfromSalesOrder SWITCH 1 1 0 Capacity planning from sales order