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 MP50 MP50001 WorkcentCode STRING 8 8 0 Work Centre
MP50 MP50002 Description VSTRING 30 30 0 Description
MP50 MP50003 OperationDescr VSTRING 20 20 0 Description Operation
MP50 MP50004 TypeWorkCenter VSTRING 1 1 0 Work Centre Type 0 - Machine resource
1 - Personnel resource
2 - Sub-contractor
MP50 MP50005 Family VSTRING 8 8 0 Family
MP50 MP50006 ForemanArea VSTRING 6 6 0 Foreman Area
MP50 MP50007 Department VSTRING 8 8 0 Department
MP50 MP50008 DocumentCode INTEGER 2 0 0 Document Layout
MP50 MP50009 Location VSTRING 10 10 0 Location
MP50 MP50010 ResourcesNo X_NUMERIC 4 12 8 Number of Resources
MP50 MP50011 ResourceJob X_NUMERIC 4 12 8 Number of Resources per Job
MP50 MP50012 Utilization X_NUMERIC 5 13 8 Utilization %
MP50 MP50013 NoShiftsDay X_NUMERIC 4 12 8 Number of Shifts per Day
MP50 MP50014 NoHoursShft X_NUMERIC 5 13 8 Number of Hours per Shift
MP50 MP50015 QueueTime X_NUMERIC 5 13 8 Queue Time
MP50 MP50016 Spare VSTRING 10 10 0 (obsolete)
MP50 MP50017 MoveTime X_NUMERIC 5 13 8 Move Time
MP50 MP50018 SetupTime X_NUMERIC 5 13 8 Setup Time
MP50 MP50019 CstCodeLabor VSTRING 3 3 0 Cost Code Labour
MP50 MP50020 FixCostHour X_NUMERIC 11 19 8 Fixed Machine Cost per Hour
MP50 MP50021 VarCostHour X_NUMERIC 11 19 8 Variable Machine Cost per Hour
MP50 MP50022 Spare VSTRING 5 5 0 (obsolete)
MP50 MP50023 Spare VSTRING 5 5 0 (obsolete)
MP50 MP50024 SetupCrew X_NUMERIC 5 13 8 Persons in Setup Crew per Hour
MP50 MP50025 RunCrew X_NUMERIC 5 13 8 Persons in Run Crew per Hour
MP50 MP50026 Spare VSTRING 10 10 0 (obsolete)
MP50 MP50027 AccString ACCSTR 120 120 0 Accounting String
MP50 MP50028 Spare VSTRING 6 6 0 (obsolete)
MP50 MP50029 Spare VSTRING 12 12 0 (obsolete)
MP50 MP50030 LoadingYN SWITCH 1 1 0 Loading
MP50 MP50031 ReportingCode VSTRING 1 1 0 Reporting Code 0 - Reporting of actual time used
1 - The time used is set to the product costing time
MP50 MP50032 MaterialCode VSTRING 2 2 0 Material Code
MP50 MP50033 LoadCode VSTRING 2 2 0 Loading Code
MP50 MP50034 Spare VSTRING 10 10 0 (obsolete)
MP50 MP50035 TimeInterval INTEGER 3 0 0 Maintenance Time Interval
MP50 MP50036 MaintInstruct VSTRING 3 3 0 Maintenance Instructions
MP50 MP50037 LatestMaintDt DATE 8 0 0 Last Maintenance Date
MP50 MP50038 FreeText7 VSTRING 20 20 0 User Defined Field 7
MP50 MP50039 FreeText8 VSTRING 20 20 0 User Defined Field 8
MP50 MP50040 FreeText9 VSTRING 20 20 0 User Defined Field 9
MP50 MP50041 FreeText10 VSTRING 20 20 0 User Defined Field 10
MP50 MP50042 Spare VSTRING 10 10 0 (obsolete)
MP50 MP50043 FreeText1 VSTRING 20 20 0 User Defined Field 1
MP50 MP50044 FreeText2 VSTRING 20 20 0 User Defined Field 2
MP50 MP50045 FreeText3 VSTRING 20 20 0 User Defined Field 3
MP50 MP50046 FreeText4 VSTRING 20 20 0 User Defined Field 4
MP50 MP50047 FreeText5 VSTRING 20 20 0 User Defined Field 5
MP50 MP50048 FreeText6 VSTRING 20 20 0 User Defined Field 6
MP50 MP50049 Description1 VSTRING 60 60 0 Description Line 1
MP50 MP50050 Description2 VSTRING 60 60 0 Description Line 2
MP50 MP50051 Description3 VSTRING 60 60 0 Description Line 3
MP50 MP50052 Description4 VSTRING 60 60 0 Description Line 4
MP50 MP50053 QtyReportYN SWITCH 1 1 0 Only Quantity Reporting
MP50 MP50054 Spare VSTRING 3 3 0 (obsolete)
MP50 MP50055 Spare VSTRING 6 6 0 (obsolete)
MP50 MP50056 Spare VSTRING 6 6 0 (obsolete)
MP50 MP50057 AccCode INTEGER 2 0 0 Accounting Code
MP50 MP50058 StatisticsYN SWITCH 1 1 0 Save Statistics
MP50 MP50059 DispTermCode VSTRING 1 1 0 Dispatch Code 0 - No dispatch order
1 - From stock code
2 - Stock code
3 - Tool number
MP50 MP50060 WrkOrderDoc1 INTEGER 2 0 0 Work Order Document 1 Indicates the type of document that shall be printed for work orders
0 - No document selected
1 - Job ticket
2 - Picking list by operation
3 - Labels
4 - Pallet labels
MP50 MP50061 WODoc1Print INTEGER 1 0 0 Work Order Document 1 Print Option Indicates when the selected document shall be printed:
1 - At start of reporting
2 - At partial reporting
3 - At - end of reporting
MP50 MP50062 QtyPrintCod1 INTEGER 1 0 0 Work Order Document 1 Quantity Option Indicates how number of print-outs is controlled.
1 - According to quantity field
2 - Reported quantity
3 - Total reported quantity
4 - Planned quantity
5 - Remaining quantity
MP50 MP50063 NoPrintfWOD1 INTEGER 2 0 0 Work Order Document 1 Number of Print-outs
MP50 MP50064 WrkOrderDoc2 INTEGER 2 0 0 Work Order Document 2 Indicates the type of document that shall be printed for work orders
0 - No document selected
1 - Job ticket
2 - Picking list by operation
3 - Labels
4 - Pallet labels
MP50 MP50065 WODoc2Print INTEGER 1 0 0 Work Order Document 2 Print Option Indicates when the selected document shall be printed:
1 - At start of reporting
2 - At partial reporting
3 - At - end of reporting
MP50 MP50066 QtyPrintCod2 INTEGER 1 0 0 Work Order Document 2 Quantity Option Indicates how number of print-outs is controlled.
1 - According to quantity field
2 - Reported quantity
3 - Total reported quantity
4 - Planned quantity
5 - Remaining quantity
MP50 MP50067 NoPrintfWOD2 INTEGER 2 0 0 Work Order Document 2 Number of Print-outs
MP50 MP50068 WrkOrderDoc3 INTEGER 2 0 0 Work Order Document 3 Indicates the type of document that shall be printed for work orders
0 - No document selected
1 - Job ticket
2 - Picking list by operation
3 - Labels
4 - Pallet labels
MP50 MP50069 WODoc3Print INTEGER 1 0 0 Work Order Document 3 Print Option Indicates when the selected document shall be printed:
1 - At start of reporting
2 - At partial reporting
3 - At - end of reporting
MP50 MP50070 QtyPrintCod3 INTEGER 1 0 0 Work Order Document 3 Quantity Option Indicates how number of print-outs is controlled.
1 - According to quantity field
2 - Reported quantity
3 - Total reported quantity
4 - Planned quantity
5 - Remaining quantity
MP50 MP50071 NoPrintfWOD3 INTEGER 2 0 0 Work Order Document 3 Number of Print-outs
MP50 MP50072 WrkOrderDoc4 INTEGER 2 0 0 Work Order Document 4 Indicates the type of document that shall be printed for work orders
0 - No document selected
1 - Job ticket
2 - Picking list by operation
3 - Labels
4 - Pallet labels
MP50 MP50073 WODoc4Print INTEGER 1 0 0 Work Order Document 4 Print Option Indicates when the selected document shall be printed:
1 - At start of reporting
2 - At partial reporting
3 - At - end of reporting
MP50 MP50074 QtyPrintCod4 INTEGER 1 0 0 Work Order Document 4 Quantity Option Indicates how number of print-outs is controlled.
1 - According to quantity field
2 - Reported quantity
3 - Total reported quantity
4 - Planned quantity
5 - Remaining quantity
MP50 MP50075 NoPrintfWOD4 INTEGER 2 0 0 Work Order Document 4 Number of Print-outs
MP50 MP50076 WrkOrderDoc5 INTEGER 2 0 0 Work Order Document 5 Indicates the type of document that shall be printed for work orders
0 - No document selected
1 - Job ticket
2 - Picking list by operation
3 - Labels
4 - Pallet labels
MP50 MP50077 WODoc5Print INTEGER 1 0 0 Work Order Document 5 Print Option Indicates when the selected document shall be printed:
1 - At start of reporting
2 - At partial reporting
3 - At - end of reporting
MP50 MP50078 QtyPrintCod5 INTEGER 1 0 0 Work Order Document 5 Quantity Option Indicates how number of print-outs is controlled.
1 - According to quantity field
2 - Reported quantity
3 - Total reported quantity
4 - Planned quantity
5 - Remaining quantity
MP50 MP50079 NoPrintfWOD5 INTEGER 2 0 0 Work Order Document 5 Number of Print-outs
MP50 MP50080 ProductCode VSTRING 3 3 0 Production Code
MP50 MP50081 CapacFactor VSTRING 2 2 0 Capacity Factor
MP50 MP50082 Yield X_NUMERIC 6 14 8 Yield %
MP50 MP50083 ReturnItem VSTRING 35 35 0 Return Stock Item
MP50 MP50084 WeightType VSTRING 1 1 0 Weight Type
MP50 MP50085 TimeUsedPer X_NUMERIC 12 20 8 Time Used Period
MP50 MP50086 TimeUsedAccu X_NUMERIC 12 20 8 Time Used Accumulated
MP50 MP50087 HrsInBudget X_NUMERIC 12 20 8 Budgeted Number of Hours
MP50 MP50088 CriticalRes VSTRING 1 1 0 Critical Resource
MP50 MP50089 Flowgroup VSTRING 8 8 0 Flow Group
MP50 MP50090 Warehouse VSTRING 6 6 0 Warehouse
MP50 MP50091 CalendarColRefCalc INTEGER 9 0 0 Calendar Collection Calculated
MP50 MP50092 CalendarColRefActual INTEGER 9 0 0 Calendar Collection Actual
MP50 MP50093 CalcDateNumHours DATE 8 0 0 Calculation Date of Number of Hours
MP50 MP50094 SupplierCode STRING 10 10 0 Supplier Code
MP50 MP50095 FlagSendMaterial STRING 1 1 0 Flag Send Material
MP50 MP50096 FlagCreatePOForLabour STRING 1 1 0 Flag Create PO For Labour
MP50 MP50097 PONumberSerie STRING 1 1 0 PO Number Serie
MP50 MP50098 PartialDeliveryPermitted VSTRING 1 1 0 defines whether to report partial delivery for Subcontract Labour at this Work Centre or not
MP50 MP50099 OverDeliveryPermitted VSTRING 1 1 0 defines whether to report over delivery for Subcontract Labour at this Work Centre or not
MP50 MP50100 QtyForPayment VSTRING 1 1 0 defines the possibility to report actual quantity for payment Subcontract Labour at this Work Centre
MP50 MP50101 PickingRequest STRING 1 1 0 Picking Request
MP50 MP50102 GenericCalendarPM INTEGER 9 0 0 Generic Calendar PM
MP50 MP50103 InternalCustomer STRING 10 10 0 Internal Customer
MP50 MP50104 Site STRING 4 4 0 Site
MP50 MP50105 MasterAssetCode STRING 35 35 0 Master Asset Code
MP50 MP50106 AssetValueComponentNumber STRING 10 10 0 Asset Value Component Number