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 MP64 MP64001 WorkorderNo STRING 10 10 0 Work Order Number
MP64 MP64002 StockCode VSTRING 35 35 0 Stock Item Code
MP64 MP64003 Warehouse VSTRING 6 6 0 Warehouse
MP64 MP64004 PlannedQty X_NUMERIC 12 20 8 Quantity Planned
MP64 MP64005 ManufactQty X_NUMERIC 12 20 8 Quantity Manufactured
MP64 MP64006 Alternate VSTRING 2 2 0 Alternate Routing
MP64 MP64007 SchedulCode VSTRING 1 1 0 Schedule Code 0 - Forward scheduling
1 - Backwards scheduling
2 - Locked scheduling
MP64 MP64008 CustomerNo VSTRING 10 10 0 Customer Code
MP64 MP64009 SalesOrderNo STRING 10 10 0 Sales Order Number
MP64 MP64010 SalesOrdLine STRING 6 6 0 Sales Order Line Number
MP64 MP64011 ReqDelDate DATE 8 0 0 Date Requested
MP64 MP64012 PlnStartDate DATE 8 0 0 Planned Start Date
MP64 MP64013 PlanDueDate DATE 8 0 0 Planned Due Date
MP64 MP64014 DueDate DATE 8 0 0 Due Date
MP64 MP64015 WorkorderType INTEGER 1 0 0 Work Order Type 0 - Normal work order
1 - Work order created for sales order
MP64 MP64016 MatReservDate DATE 8 0 0 Material Reservation Date
MP64 MP64017 text1 VSTRING 25 25 0 Text Line 1
MP64 MP64018 text2 VSTRING 25 25 0 Text Line 2
MP64 MP64019 text3 VSTRING 25 25 0 Text Line 3
MP64 MP64020 OptionExist VSTRING 1 1 0 Option Exist
MP64 MP64021 ExtrDesExist VSTRING 1 1 0 Extra Description Exist
MP64 MP64022 OpenQtyExist VSTRING 1 1 0 Open Quantity Exist
MP64 MP64023 OpenTimeExist VSTRING 1 1 0 Open Time Exist
MP64 MP64024 Planner VSTRING 15 15 0 Planner
MP64 MP64025 SelectionTerm VSTRING 15 15 0 Selection Term
MP64 MP64026 RegistDate DATE 8 0 0 Date Entered
MP64 MP64027 OptionRegistered DATE 8 0 0 Option Entered
MP64 MP64028 ReleaseDate DATE 8 0 0 Release Date
MP64 MP64029 LastChngDate DATE 8 0 0 Last Date Changed
MP64 MP64030 ResponsChng VSTRING 15 15 0 Changed By
MP64 MP64031 ChngVersion INTEGER 2 0 0 Change Version
MP64 MP64032 ScheduleDate DATE 8 0 0 Schedule Date
MP64 MP64033 StopDate DATE 8 0 0 Stop Date
MP64 MP64034 Priority INTEGER 1 0 0 Priority
MP64 MP64035 ResponsPriority VSTRING 15 15 0 Priority Set By
MP64 MP64036 Staging SWITCH 1 1 0 Material Availability Test
MP64 MP64037 StagingDate DATE 8 0 0 Staging Date
MP64 MP64038 WOCloseDate DATE 8 0 0 Work Order Close Date
MP64 MP64039 PlanLeadtime INTEGER 3 0 0 Planned Lead Time
MP64 MP64040 Leadtime INTEGER 3 0 0 Lead Time
MP64 MP64041 CopiedFromWO STRING 10 10 0 Work Order Copied From
MP64 MP64042 RoutingExist VSTRING 1 1 0 Routing Exist
MP64 MP64043 Lot X_NUMERIC 12 20 8 Lot
MP64 MP64044 AddressName VSTRING 35 35 0 Address Name
MP64 MP64045 Address1 VSTRING 35 35 0 Address Line 1
MP64 MP64046 Address2 VSTRING 35 35 0 Address Line 2
MP64 MP64047 Address3 VSTRING 35 35 0 Address Line 3
MP64 MP64048 PickListDate DATE 8 0 0 Date Picking List Printed
MP64 MP64049 MatReqDate DATE 8 0 0 Material Requisition Date
MP64 MP64050 TravelerDate DATE 8 0 0 Traveller Date
MP64 MP64051 LabelDate DATE 8 0 0 Label Date 1
MP64 MP64052 Label2Date DATE 8 0 0 Label Date 2
MP64 MP64053 TravVendDate DATE 8 0 0 Traveller Supplier Date
MP64 MP64054 RepVendDate DATE 8 0 0 Reporting Supplier Date
MP64 MP64055 JobTicketDate DATE 8 0 0 Job Ticket Date
MP64 MP64056 OperListDate DATE 8 0 0 Operation List Date
MP64 MP64057 ProductCost SWITCH 1 1 0 Production Cost
MP64 MP64058 ActualCost SWITCH 1 1 0 Create Actual Cost
MP64 MP64059 SummActCost SWITCH 1 1 0 Summarized Actual Cost
MP64 MP64060 ActCostDate DATE 8 0 0 Actual Cost Date
MP64 MP64061 MaterialIssued DATE 8 0 0 Material Issue Date
MP64 MP64062 AllMatIssued DATE 8 0 0 Date All Material Issued
MP64 MP64063 Only2Or3Comp VSTRING 1 1 0 Only 2 or 3 Components
MP64 MP64064 OperatStarted DATE 8 0 0 Operation Started
MP64 MP64065 OperatFinished DATE 8 0 0 Operation Finished
MP64 MP64066 AutoMakeOperation SWITCH 1 1 0 Automatically Create Operation List
MP64 MP64067 MatShortage INTEGER 6 0 0 Material Shortage
MP64 MP64068 AccString ACCSTR 120 120 0 Accounting String
MP64 MP64069 Spare VSTRING 6 6 0 (obsolete)
MP64 MP64070 Spare VSTRING 6 6 0 (obsolete)
MP64 MP64071 AccCode INTEGER 2 0 0 Accounting Code
MP64 MP64072 NoPickList INTEGER 2 0 0 Picking List by Operation Copies
MP64 MP64073 NoMatReq INTEGER 2 0 0 Picking List Copies
MP64 MP64074 NoTraveler INTEGER 2 0 0 Traveller Document Copies
MP64 MP64075 NoLabel INTEGER 2 0 0 Label Type 1 Copies
MP64 MP64076 NoLabel2 INTEGER 2 0 0 Label Type 2 Copies
MP64 MP64077 NoTravVendor INTEGER 2 0 0 Traveller Vendor Document Copies
MP64 MP64078 NoRepVendor INTEGER 2 0 0 Report Work Order Receipt Copies
MP64 MP64079 NoJobTicket INTEGER 2 0 0 Job Ticket Copies
MP64 MP64080 NoOperatList INTEGER 2 0 0 Operation List Copies
MP64 MP64081 ActStartDate DATE 8 0 0 Actual Start Date
MP64 MP64082 Address4 VSTRING 35 35 0 Address Line 4
MP64 MP64083 ResponsStop VSTRING 10 10 0 Stopped By
MP64 MP64084 BoMExist SWITCH 1 1 0 BOM Exist
MP64 MP64085 OldQuantity X_NUMERIC 12 20 8 Quantity Old
MP64 MP64086 OldDueDate DATE 8 0 0 Due Date Old
MP64 MP64087 TotalScrap X_NUMERIC 12 20 8 Total Scrap Quantity
MP64 MP64088 Status1 INTEGER 2 0 0 Status 1 0 - Work order entered
1 - Work order entered and in batch queue
2 - Bill of material and operation list created
3 - Work order released
7 - Work order provisionally closed. This work order cannot be closed.
8 - Closed
9 - Saved
MP64 MP64089 Status2 INTEGER 2 0 0 Status 2 0 - No batch in progress
1/2 - Batch in progress
MP64 MP64090 SOStructLineNo STRING 6 6 0 Sales Order Sub-line Number
MP64 MP64091 NoUnitsLot X_NUMERIC 12 20 8 Number of Units per Lot
MP64 MP64092 SizeOfLot X_NUMERIC 12 20 8 Size of Lot
MP64 MP64093 RestQty X_NUMERIC 12 20 8 Rest Quantity
MP64 MP64094 OldSizeOfLot X_NUMERIC 12 20 8 Old Size of Lot
MP64 MP64095 ShopScheduled VSTRING 1 1 0 Shop Scheduled
MP64 MP64096 MakeWOMatList SWITCH 1 1 0 Create Work Order from Material List
MP64 MP64097 WONumberSerie VSTRING 1 1 0 Work Order Number Counter
MP64 MP64098 WIPAccounted SWITCH 1 1 0 WIP Accounted
MP64 MP64099 ShortageNo INTEGER 4 0 0 Shortage Number
MP64 MP64100 VersionStock STRING 10 10 0 Version Stock Item
MP64 MP64101 VersionStructure STRING 10 10 0 Version BOM
MP64 MP64102 VersionOperation STRING 10 10 0 Version Operation
MP64 MP64103 DrawingNo VSTRING 20 20 0 Drawing Number
MP64 MP64104 DelLineNo STRING 4 4 0 Delivery Line Number
MP64 MP64105 ORCheck VSTRING 1 1 0 Check for Sales Order
MP64 MP64106 IncludedCriticalPath VSTRING 1 1 0 Included in Critical Path
MP64 MP64107 Spare VSTRING 3 3 0 (obsolete)
MP64 MP64108 Spare VSTRING 3 3 0 (obsolete)
MP64 MP64109 Spare VSTRING 3 3 0 (obsolete)
MP64 MP64110 Spare VSTRING 20 20 0 (obsolete)
MP64 MP64111 Spare VSTRING 20 20 0 (obsolete)
MP64 MP64112 Spare VSTRING 20 20 0 (obsolete)
MP64 MP64113 WIPAmount MONEY 20 28 8 WIP Amount
MP64 MP64114 StandardCost MONEY 20 28 8 Standard Cost
MP64 MP64115 ProjectNumber VSTRING 12 12 0 Project Number
MP64 MP64116 SubProjectNumber VSTRING 6 6 0 Sub-Project
MP64 MP64117 ActivityLine VSTRING 6 6 0 Activity Line Number
MP64 MP64118 ActivityStructLine VSTRING 6 6 0 Activity Sub-line Number
MP64 MP64119 WONumber STRING 10 10 0 Work Order Number
MP64 MP64120 ReportNo STRING 10 10 0 Report Number
MP64 MP64121 Number STRING 4 4 0 Number
MP64 MP64122 PlannedBatch STRING 12 12 0 Planned Batch
MP64 MP64123 RequestNo STRING 10 10 0 Customer Request Number
MP64 MP64124 ReminderDateFPO DATE 8 0 0 Reminder Date FPO
MP64 MP64125 StartDateTimeFactor X_NUMERIC 12 20 8 Start Date Time Factor
MP64 MP64126 DueDateTimeFactor X_NUMERIC 12 20 8 Due Date Time Factor
MP64 MP64127 Address5 VSTRING 35 35 0 Address Line 5
MP64 MP64128 Address6 VSTRING 35 35 0 Address Line 6
MP64 MP64129 CountryCode VSTRING 3 3 0 Country Code
MP64 MP64130 Address7 VSTRING 35 35 0 Address Line 7
MP64 MP64131 RMAReference VSTRING 10 10 0 RMA Reference
MP64 MP64132 RMAComment VSTRING 50 50 0 RMA Comment
MP64 MP64133 RMAReferenceNo VSTRING 10 10 0 RMA Reference No.
MP64 MP64134 ATPWOShift INTEGER 1 0 0 ATP WO Shift
MP64 MP64135 ActualATPPeriodShiftDays INTEGER 1 0 0 Actual ATP period shift days