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 MP58 MP58001 ModelNo STRING 6 6 0 Model Number
MP58 MP58002 Text0 VSTRING 19 19 0 Line 00 Description
MP58 MP58003 Base0 VSTRING 3 3 0 Line 00 Base
MP58 MP58004 Constant0 VSTRING 10 10 0 Line 00 Constant
MP58 MP58005 SumConcept0 INTEGER 1 0 0 Line 00 Summarisation Number
MP58 MP58006 Text1 VSTRING 19 19 0 Line 01 Description
MP58 MP58007 Base1 VSTRING 3 3 0 Line 01 Base
MP58 MP58008 Constant1 VSTRING 10 10 0 Line 01 Constant
MP58 MP58009 SumConcept1 INTEGER 1 0 0 Line 01 Summarisation Number
MP58 MP58010 Text2 VSTRING 19 19 0 Line 02 Description
MP58 MP58011 Base2 VSTRING 3 3 0 Line 02 Base
MP58 MP58012 Constant2 VSTRING 10 10 0 Line 02 Constant
MP58 MP58013 SumConcept2 INTEGER 1 0 0 Line 02 Summarisation Number
MP58 MP58014 Text3 VSTRING 19 19 0 Line 03 Description
MP58 MP58015 Base3 VSTRING 3 3 0 Line 03 Base
MP58 MP58016 Constant3 VSTRING 10 10 0 Line 03 Constant
MP58 MP58017 SumConcept3 INTEGER 1 0 0 Line 03 Summarisation Number
MP58 MP58018 Text4 VSTRING 19 19 0 Line 04 Description
MP58 MP58019 Base4 VSTRING 3 3 0 Line 04 Base
MP58 MP58020 Constant4 VSTRING 10 10 0 Line 04 Constant
MP58 MP58021 SumConcept4 INTEGER 1 0 0 Line 04 Summarisation Number
MP58 MP58022 Text5 VSTRING 19 19 0 Line 05 Description
MP58 MP58023 Base5 VSTRING 3 3 0 Line 05 Base
MP58 MP58024 Constant5 VSTRING 10 10 0 Line 05 Constant
MP58 MP58025 SumConcept5 INTEGER 1 0 0 Line 05 Summarisation Number
MP58 MP58026 Text6 VSTRING 19 19 0 Line 06 Description
MP58 MP58027 Base6 VSTRING 3 3 0 Line 06 Base
MP58 MP58028 Constant6 VSTRING 10 10 0 Line 06 Constant
MP58 MP58029 SumConcept6 INTEGER 1 0 0 Line 06 Summarisation Number
MP58 MP58030 Text7 VSTRING 19 19 0 Line 07 Description
MP58 MP58031 Base7 VSTRING 3 3 0 Line 07 Base
MP58 MP58032 Constant7 VSTRING 10 10 0 Line 07 Constant
MP58 MP58033 SumConcept7 INTEGER 1 0 0 Line 07 Summarisation Number
MP58 MP58034 Text8 VSTRING 19 19 0 Line 08 Description
MP58 MP58035 Base8 VSTRING 3 3 0 Line 08 Base
MP58 MP58036 Constant8 VSTRING 10 10 0 Line 08 Constant
MP58 MP58037 SumConcept8 INTEGER 1 0 0 Line 08 Summarisation Number
MP58 MP58038 Text9 VSTRING 19 19 0 Line 09 Description
MP58 MP58039 Base9 VSTRING 3 3 0 Line 09 Base
MP58 MP58040 Constant9 VSTRING 10 10 0 Line 09 Constant
MP58 MP58041 SumConcept9 INTEGER 1 0 0 Line 09 Summarisation Number
MP58 MP58042 Text10 VSTRING 19 19 0 Line 10 Description
MP58 MP58043 Base10 VSTRING 3 3 0 Line 10 Base
MP58 MP58044 Constant10 VSTRING 10 10 0 Line 10 Constant
MP58 MP58045 SumConcept10 INTEGER 1 0 0 Line 10 Summarisation Number
MP58 MP58046 Text11 VSTRING 19 19 0 Line 11 Description
MP58 MP58047 Base11 VSTRING 3 3 0 Line 11 Base
MP58 MP58048 Constant11 VSTRING 10 10 0 Line 11 Constant
MP58 MP58049 SumConcept11 INTEGER 1 0 0 Line 11 Summarisation Number
MP58 MP58050 Text12 VSTRING 19 19 0 Line 12 Description
MP58 MP58051 Base12 VSTRING 3 3 0 Line 12 Base
MP58 MP58052 Constant12 VSTRING 10 10 0 Line 12 Constant
MP58 MP58053 SumConcept12 INTEGER 1 0 0 Line 12 Summarisation Number
MP58 MP58054 Text13 VSTRING 19 19 0 Line 13 Description
MP58 MP58055 Base13 VSTRING 3 3 0 Line 13 Base
MP58 MP58056 Constant13 VSTRING 10 10 0 Line 13 Constant
MP58 MP58057 SumConcept13 INTEGER 1 0 0 Line 13 Summarisation Number
MP58 MP58058 Text14 VSTRING 19 19 0 Line 14 Description
MP58 MP58059 Base14 VSTRING 3 3 0 Line 14 Base
MP58 MP58060 Constant14 VSTRING 10 10 0 Line 14 Constant
MP58 MP58061 SumConcept14 INTEGER 1 0 0 Line 14 Summarisation Number
MP58 MP58062 DescSpcProd0 VSTRING 19 19 0 Specific Cost Bas X0 - Description
MP58 MP58063 DescSpcProd1 VSTRING 19 19 0 Specific Cost Bas X1 - Description
MP58 MP58064 DescSpcProd2 VSTRING 19 19 0 Specific Cost Bas X2 - Description
MP58 MP58065 DescSpcProd3 VSTRING 19 19 0 Specific Cost Bas X3 - Description
MP58 MP58066 DefFreeBase0 VSTRING 11 11 0 Free Base F0 - Description
MP58 MP58067 DefFreeBase1 VSTRING 11 11 0 Free Base F1 - Description
MP58 MP58068 DefFreeBase2 VSTRING 11 11 0 Free Base F2 - Description
MP58 MP58069 DefFreeBase3 VSTRING 11 11 0 Free Base F3 - Description
MP58 MP58070 TypeIncrea0 INTEGER 1 0 0 Line 00 Overhead Sum
MP58 MP58071 TypeIncrea1 INTEGER 1 0 0 Line 01 Overhead Sum
MP58 MP58072 TypeIncrea2 INTEGER 1 0 0 Line 02 Overhead Sum
MP58 MP58073 TypeIncrea3 INTEGER 1 0 0 Line 03 Overhead Sum
MP58 MP58074 TypeIncrea4 INTEGER 1 0 0 Line 04 Overhead Sum
MP58 MP58075 TypeIncrea5 INTEGER 1 0 0 Line 05 Overhead Sum
MP58 MP58076 TypeIncrea6 INTEGER 1 0 0 Line 06 Overhead Sum
MP58 MP58077 TypeIncrea7 INTEGER 1 0 0 Line 07 Overhead Sum
MP58 MP58078 TypeIncrea8 INTEGER 1 0 0 Line 08 Overhead Sum
MP58 MP58079 TypeIncrea9 INTEGER 1 0 0 Line 09 Overhead Sum
MP58 MP58080 TypeIncrea10 INTEGER 1 0 0 Line 10 Overhead Sum
MP58 MP58081 TypeIncrea11 INTEGER 1 0 0 Line 11 Overhead Sum
MP58 MP58082 TypeIncrea12 INTEGER 1 0 0 Line 12 Overhead Sum
MP58 MP58083 TypeIncrea13 INTEGER 1 0 0 Line 13 Overhead Sum
MP58 MP58084 TypeIncrea14 INTEGER 1 0 0 Line 14 Overhead Sum
MP58 MP58085 AccCode0 INTEGER 2 0 0 Line 00 Accounting Code
MP58 MP58086 AccCode1 INTEGER 2 0 0 Line 01 Accounting Code
MP58 MP58087 AccCode2 INTEGER 2 0 0 Line 02 Accounting Code
MP58 MP58088 AccCode3 INTEGER 2 0 0 Line 03 Accounting Code
MP58 MP58089 AccCode4 INTEGER 2 0 0 Line 04 Accounting Code
MP58 MP58090 AccCode5 INTEGER 2 0 0 Line 05 Accounting Code
MP58 MP58091 AccCode6 INTEGER 2 0 0 Line 06 Accounting Code
MP58 MP58092 AccCode7 INTEGER 2 0 0 Line 07 Accounting Code
MP58 MP58093 AccCode8 INTEGER 2 0 0 Line 08 Accounting Code
MP58 MP58094 AccCode9 INTEGER 2 0 0 Line 09 Accounting Code
MP58 MP58095 AccCode10 INTEGER 2 0 0 Line 10 Accounting Code
MP58 MP58096 AccCode11 INTEGER 2 0 0 Line 11 Accounting Code
MP58 MP58097 AccCode12 INTEGER 2 0 0 Line 12 Accounting Code
MP58 MP58098 AccCode13 INTEGER 2 0 0 Line 13 Accounting Code
MP58 MP58099 AccCode14 INTEGER 2 0 0 Line 14 Accounting Code
MP58 MP58100 ModelDescr VSTRING 25 25 0 Model Description
MP58 MP58101 ActivityTypePR0 INTEGER 1 0 0 Line 00 Activity Type Project
MP58 MP58102 ActivityTypePR1 INTEGER 1 0 0 Line 01 Activity Type Project
MP58 MP58103 ActivityTypePR2 INTEGER 1 0 0 Line 02 Activity Type Project
MP58 MP58104 ActivityTypePR3 INTEGER 1 0 0 Line 03 Activity Type Project
MP58 MP58105 ActivityTypePR4 INTEGER 1 0 0 Line 04 Activity Type Project
MP58 MP58106 ActivityTypePR5 INTEGER 1 0 0 Line 05 Activity Type Project
MP58 MP58107 ActivityTypePR6 INTEGER 1 0 0 Line 06 Activity Type Project
MP58 MP58108 ActivityTypePR7 INTEGER 1 0 0 Line 07 Activity Type Project
MP58 MP58109 ActivityTypePR8 INTEGER 1 0 0 Line 08 Activity Type Project
MP58 MP58110 ActivityTypePR9 INTEGER 1 0 0 Line 09 Activity Type Project
MP58 MP58111 ActivityTypePR10 INTEGER 1 0 0 Line 10 Activity Type Project
MP58 MP58112 ActivityTypePR11 INTEGER 1 0 0 Line 11 Activity Type Project
MP58 MP58113 ActivityTypePR12 INTEGER 1 0 0 Line 12 Activity Type Project
MP58 MP58114 ActivityTypePR13 INTEGER 1 0 0 Line 13 Activity Type Project
MP58 MP58115 ActivityTypePR14 INTEGER 1 0 0 Line 14 Activity Type Project