Название Таблицы / Table Name | Описание Таблицы / Table Description | Поле / Field | Расширенный комментарий / Extended Comment | Тип данных / Data Type | Длина поля iScala 3.5/ iScala 3.5 Length | Точность iScala 3.5/ iScala 3.5 Precision | Длина поля iScala 2.2/ iScala 2.2 Length | Точность iScala 2.2/ iScala 2.2 Precision | Новое поле? / is a New Field? |
MP06 | MPC Automatic Coding Schedule | MP06004 | Accounting code 1 | NCHAR | 2 | — | — | + | |
MP06 | MPC Automatic Coding Schedule | MP06005 | Accounting code 2 | NCHAR | 2 | — | — | + | |
MP06 | MPC Automatic Coding Schedule | MP06006 | Extra code | NCHAR | 2 | — | — | + | |
MP07 | MPC Std. Cost Summary | MP07021 | Type | NCHAR | 1 | — | — | + | |
MP08 | Setup time per WC | MP08001 | Work Centre | NCHAR | 8 | — | — | + | |
MP08 | Setup time per WC | MP08002 | From Stock code | NVARCHAR | 35 | — | — | + | |
MP08 | Setup time per WC | MP08003 | To Stock code | NVARCHAR | 35 | — | — | + | |
MP08 | Setup time per WC | MP08004 | Setup time | NUMERIC | 6 | 8 | — | — | + |
MP12 | Forecast History | MP12001 | Type | NCHAR | 2 | — | — | + | |
MP12 | Forecast History | MP12002 | Forecast number | NCHAR | 4 | — | — | + | |
MP12 | Forecast History | MP12003 | Section | NCHAR | 10 | — | — | + | |
MP12 | Forecast History | MP12004 | Stock Code | NCHAR | 35 | — | — | + | |
MP12 | Forecast History | MP12005 | Year/Month | NCHAR | 6 | — | — | + | |
MP12 | Forecast History | MP12006 | Need date | NCHAR | 8 | — | — | + | |
MP12 | Forecast History | MP12007 | Day,Week,Month,Year | NCHAR | 1 | — | — | + | |
MP12 | Forecast History | MP12008 | Quantity | NUMERIC | 12 | 8 | — | — | + |
MP12 | Forecast History | MP12009 | Distributed — No/Yes (0/1) | NCHAR | 1 | — | — | + | |
MP12 | Forecast History | MP12010 | Distributed From Week, Month or Year | INT | 1 | — | — | + | |
MP12 | Forecast History | MP12011 | Distribution Month List | NVARCHAR | 6 | — | — | + | |
MP12 | Forecast History | MP12012 | Distribution Week List | NVARCHAR | 6 | — | — | + | |
MP12 | Forecast History | MP12013 | Distribution Day List | NVARCHAR | 6 | — | — | + | |
MP12 | Forecast History | MP12014 | Group number | NVARCHAR | 4 | — | — | + | |
MP12 | Forecast History | MP12015 | Creation Date | DATETIME | 8 | — | — | + | |
MP12 | Forecast History | MP12016 | Creation Time | NCHAR | 6 | — | — | + | |
MP12 | Forecast History | MP12017 | User ID | NVARCHAR | 8 | — | — | + | |
MP3L | Extended Proposal Lines | MP3L001 | Supplier | NCHAR | 10 | — | — | + | |
MP3L | Extended Proposal Lines | MP3L002 | StockCode | NCHAR | 35 | — | — | + | |
MP3L | Extended Proposal Lines | MP3L003 | Del.Date | DATETIME | 8 | — | — | + | |
MP3L | Extended Proposal Lines | MP3L004 | OrderNo | NCHAR | 10 | — | — | + | |
MP3L | Extended Proposal Lines | MP3L005 | BTT_Code | NCHAR | 6 | — | — | + | |
MP3L | Extended Proposal Lines | MP3L006 | LTE_No | INT | 9 | — | — | + | |
MP3L | Extended Proposal Lines | MP3L007 | LTR_No | INT | 9 | — | — | + | |
MP3L | Extended Proposal Lines | MP3L008 | Variation_Code | NCHAR | 10 | — | — | + | |
MP3L | Extended Proposal Lines | MP3L009 | Milestone_Type | INT | 9 | — | — | + | |
MP3L | Extended Proposal Lines | MP3L010 | CalendarID | NCHAR | 10 | — | — | + | |
MP3L | Extended Proposal Lines | MP3L011 | Duration | NUMERIC | 18 | 8 | — | — | + |
MP3L | Extended Proposal Lines | MP3L012 | Actual_Start_Date | DATETIME | 8 | — | — | + | |
MP3L | Extended Proposal Lines | MP3L013 | Actual_Finish_Date | DATETIME | 8 | — | — | + | |
MP3L | Extended Proposal Lines | MP3L014 | InvoiceNo | NCHAR | 25 | — | — | + | |
MP3L | Extended Proposal Lines | MP3L015 | OwnerType | NCHAR | 4 | — | — | + | |
MP3L | Extended Proposal Lines | MP3L016 | OwnerID | NVARCHAR | 35 | — | — | + | |
MP3L | Extended Proposal Lines | MP3L017 | TimeUnit | NCHAR | 1 | — | — | + | |
MP3L | Extended Proposal Lines | MP3L018 | Spare | NCHAR | 4 | — | — | + | |
MP3L | Extended Proposal Lines | MP3L019 | UDMS_Code | NCHAR | 6 | — | — | + | |
MP3L | Extended Proposal Lines | MP3L020 | Status | INT | 1 | — | — | + | |
MP3L | Extended Proposal Lines | MP3L021 | Original_Start_Date | DATETIME | 8 | — | — | + | |
MP3L | Extended Proposal Lines | MP3L022 | Original_Finish_Date | DATETIME | 8 | — | — | + | |
MP50 | Work Centers | MP50027 | Accounting String | NVARCHAR | 120 | 50 | — | ||
MP50 | Work Centers | MP50094 | Supplier Code | NCHAR | 10 | — | — | + | |
MP50 | Work Centers | MP50095 | Flag Send Material | NCHAR | 1 | — | — | + | |
MP50 | Work Centers | MP50096 | Flag Create PO For Labour | NCHAR | 1 | — | — | + | |
MP50 | Work Centers | MP50097 | PO Number Serie | NCHAR | 1 | — | — | + | |
MP50 | Work Centers | MP50098 | defines whether to report partial delivery for Subcontract Labour at this Work Centre or not | NVARCHAR | 1 | — | — | + | |
MP50 | Work Centers | MP50099 | defines whether to report over delivery for Subcontract Labour at this Work Centre or not | NVARCHAR | 1 | — | — | + | |
MP50 | Work Centers | MP50100 | defines the possibility to report actual quantity for payment Subcontract Labour at this Work Centre | NVARCHAR | 1 | — | — | + | |
MP50 | Work Centers | MP50101 | Picking Request | NCHAR | 1 | — | — | + | |
MP50 | Work Centers | MP50102 | Generic Calendar PM | INT | 9 | — | — | + | |
MP50 | Work Centers | MP50103 | Internal Customer | NCHAR | 10 | — | — | + | |
MP50 | Work Centers | MP50104 | Site | NCHAR | 4 | — | — | + | |
MP50 | Work Centers | MP50105 | Master Asset Code | NCHAR | 35 | — | — | + | |
MP50 | Work Centers | MP50106 | Asset Value Component Number | NCHAR | 10 | — | — | + | |
MP52 | Tools | MP52010 | Accounting String | NVARCHAR | 120 | 50 | — | ||
MP56 | MPC Parameters | MP56109 | (obsolete) | NUMERIC | 9 | 6 | — | ||
MP56 | MPC Parameters | MP56110 | (obsolete) | NUMERIC | 9 | 6 | — | ||
MP56 | MPC Parameters | MP56131 | Calendar Collection for forecast distribution | INT | 9 | 6 | — | ||
MP56 | MPC Parameters | MP56136 | PTF Source | NCHAR | 1 | 6 | — | ||
MP56 | MPC Parameters | MP56137 | Planning Time Fence | INT | 4 | 6 | — | ||
MP56 | MPC Parameters | MP56139 | DeliveryTimePlanning_in_Purch_Prop | NCHAR | 1 | — | — | + | |
MP56 | MPC Parameters | MP56140 | ConvertTo | INT | 1 | — | — | + | |
MP56 | MPC Parameters | MP56141 | DefaultPurchaseOrderType | INT | 1 | — | — | + | |
MP56 | MPC Parameters | MP56142 | DefaultRequisitionType | INT | 1 | — | — | + | |
MP56 | MPC Parameters | MP56143 | ConvertTo (SRP) | INT | 1 | — | — | + | |
MP56 | MPC Parameters | MP56144 | DefaultPurchaseOrderType (SRP) | INT | 1 | — | — | + | |
MP56 | MPC Parameters | MP56145 | DefaultRequisitionType (SRP) | INT | 1 | — | — | + | |
MP56 | MPC Parameters | MP56146 | default value for Subcontract WC parameter ‘Partial Delivery Permitted’ | NVARCHAR | 1 | — | — | + | |
MP56 | MPC Parameters | MP56147 | default value for Subcontract WC parameter ‘Over Delivery Permitted’ | NVARCHAR | 1 | — | — | + | |
MP56 | MPC Parameters | MP56148 | default value for Subcontract WC parameter ‘Quantity for payment’ | NVARCHAR | 1 | — | — | + | |
MP56 | MPC Parameters | MP56149 | Consider Locked Batches In MRP | NCHAR | 1 | — | — | + | |
MP56 | MPC Parameters | MP56150 | Consider Allocated Qty In MRP | NCHAR | 1 | — | — | + | |
MP56 | MPC Parameters | MP56151 | Forecast Segment As Warehouse | NCHAR | 1 | — | — | + | |
MP56 | MPC Parameters | MP56152 | Calendar For Scheduled MRP | INT | 9 | — | — | + | |
MP56 | MPC Parameters | MP56153 | Selection for Event driven MRP | INT | 2 | — | — | + | |
MP56 | MPC Parameters | MP56154 | Number of retries | INT | 1 | — | — | + | |
MP56 | MPC Parameters | MP56155 | Material Issue Line Increment | INT | 2 | — | — | + | |
MP56 | MPC Parameters | MP56156 | Fixed Start Date | DATETIME | 8 | — | — | + | |
MP56 | MPC Parameters | MP56157 | Order to search planned receipts | INT | 1 | — | — | + | |
MP56 | MPC Parameters | MP56158 | Time type PM | INT | 3 | — | — | + | |
MP56 | MPC Parameters | MP56159 | Alt. routing in WO creation from BOM | INT | 1 | — | — | + | |
MP56 | MPC Parameters | MP56160 | Alt. routing for sub work orders | NVARCHAR | 2 | — | — | + | |
MP56 | MPC Parameters | MP56161 | Update sales order | INT | 1 | — | — | + | |
MP56 | MPC Parameters | MP56162 | Update sales order till | INT | 1 | — | — | + | |
MP56 | MPC Parameters | MP56163 | Allow sales order qty adj | INT | 1 | — | — | + | |
MP56 | MPC Parameters | MP56164 | Create work orders without BOM via B-function | NCHAR | 1 | — | — | + | |
MP56 | MPC Parameters | MP56165 | Shall Queue and Move time be included in lead-times | NCHAR | 1 | — | — | + | |
MP56 | MPC Parameters | MP56166 | WH on subcontract PO | INT | 1 | — | — | + | |
MP56 | MPC Parameters | MP56167 | Planned WIP cost is Actual cost at Average valuation | NCHAR | 1 | — | — | + | |
MP56 | MPC Parameters | MP56168 | Planned WIP cost is Actual cost at FIFO valuation | NCHAR | 1 | — | — | + | |
MP56 | MPC Parameters | MP56169 | Planned WIP cost is Actual cost at Standard cost valuation | NCHAR | 1 | — | — | + | |
MP56 | MPC Parameters | MP56170 | Planned WIP cost is Actual cost at LIFO valuation | NCHAR | 1 | — | — | + | |
MP56 | MPC Parameters | MP56171 | Accounting code 2, std. cost | INT | 2 | — | — | + | |
MP56 | MPC Parameters | MP56172 | Exclude Credit blocked sales/service orders from MRP/MPS | NCHAR | 1 | — | — | + | |
MP56 | MPC Parameters | MP56173 | Copy To OP | NVARCHAR | 20 | — | — | + | |
MP56 | MPC Parameters | MP56174 | Confirmation Controlled by Planner | NCHAR | 1 | — | — | + | |
MP56 | MPC Parameters | MP56175 | ATP Period Shift | INT | 1 | — | — | + | |
MP56 | MPC Parameters | MP56176 | Number of Decimals, Reported Runtime | INT | 1 | — | — | + | |
MP56 | MPC Parameters | MP56177 | Release WO After Change | NCHAR | 1 | — | — | + | |
MP56 | MPC Parameters | MP56178 | Plan disconnected material at first operation | NCHAR | 1 | — | — | + | |
MP57 | MPC Stockfile | MP57038 | Unit Code Lot | INT | 4 | 2 | — | ||
MP57 | MPC Stockfile | MP57124 | Planning Time Fence | INT | 4 | — | — | + | |
MP57 | MPC Stockfile | MP57125 | Demand Time Fence | INT | 4 | — | — | + | |
MP57 | MPC Stockfile | MP57126 | Forecast Consumption Period | INT | 1 | — | — | + | |
MP57 | MPC Stockfile | MP57127 | Forecast Consumption Order | INT | 1 | — | — | + | |
MP57 | MPC Stockfile | MP57128 | Backward Periods | INT | 2 | — | — | + | |
MP57 | MPC Stockfile | MP57129 | Forward Periods | INT | 2 | — | — | + | |
MP57 | MPC Stockfile | MP57130 | Forecast Consumption Rule for current period | INT | 1 | — | — | + | |
MP57 | MPC Stockfile | MP57131 | Forecast Consumption Rule for previous periods | INT | 1 | — | — | + | |
MP57 | MPC Stockfile | MP57132 | Forecast Consumption Rule for next periods within DTF | INT | 1 | — | — | + | |
MP57 | MPC Stockfile | MP57133 | Forecast Consumption Rule for next periods beyond DTF | INT | 1 | — | — | + | |
MP57 | MPC Stockfile | MP57134 | Last PTF date MPS | DATETIME | 8 | — | — | + | |
MP57 | MPC Stockfile | MP57135 | Last PTF date MRP/SRP | DATETIME | 8 | — | — | + | |
MP57 | MPC Stockfile | MP57136 | Excluded from MRP net | NCHAR | 1 | — | — | + | |
MP57 | MPC Stockfile | MP57137 | Days before need to search coverage | INT | 5 | — | — | + | |
MP57 | MPC Stockfile | MP57138 | Days after need to search coverage | INT | 5 | — | — | + | |
MP57 | MPC Stockfile | MP57139 | Safety Stock Lead Time | INT | 3 | — | — | + | |
MP57 | MPC Stockfile | MP57140 | Allow change of proposal type | NCHAR | 1 | — | — | + | |
MP57 | MPC Stockfile | MP57141 | Fixed Bucket Schedule for MRP/MPS | INT | 2 | — | — | + | |
MP57 | MPC Stockfile | MP57142 | Back Flush Code | INT | 1 | — | — | + | |
MP57 | MPC Stockfile | MP57143 | Create ECH on Disassembly BOM | NCHAR | 1 | — | — | + | |
MP57 | MPC Stockfile | MP57144 | Create ECH on Repair BOM | NCHAR | 1 | — | — | + | |
MP57 | MPC Stockfile | MP57145 | Version number, Disassembly BOM | NVARCHAR | 10 | — | — | + | |
MP57 | MPC Stockfile | MP57146 | Version number, Repair BOM | NVARCHAR | 10 | — | — | + | |
MP57 | MPC Stockfile | MP57147 | Release number Disassembly | INT | 4 | — | — | + | |
MP57 | MPC Stockfile | MP57148 | Release number Repair | INT | 4 | — | — | + | |
MP57 | MPC Stockfile | MP57149 | Last version date, Disassembly BOM | DATETIME | 8 | — | — | + | |
MP57 | MPC Stockfile | MP57150 | Last version date, Repair BOM | DATETIME | 8 | — | — | + | |
MP57 | MPC Stockfile | MP57151 | BOM status, Disassembly BOM | INT | 2 | — | — | + | |
MP57 | MPC Stockfile | MP57152 | BOM status, Repair BOM | INT | 2 | — | — | + | |
MP57 | MPC Stockfile | MP57153 | Capacity planning from sales order | NCHAR | 1 | — | — | + | |
MP5D | Temp.ECO Hist. | MP5D011 | ScrapFactor | NUMERIC | 6 | 8 | 4 | 8 | — |
MP5D | Temp.ECO Hist. | MP5D021 | Lead-time offset | INT | 3 | 12 | 8 | — | |
MP5D | Temp.ECO Hist. | MP5D024 | UnitCode | INT | 4 | 2 | — | ||
MP5G | Wrk.Cum.Mater.1 | MP5G013 | AccString | NVARCHAR | 120 | 50 | — | ||
MP5I | Wrk.Reconfigur. | MP5I008 | OpenScrapFactor | NUMERIC | 6 | 8 | 4 | 8 | — |
MP5J | Wrk.Dispatching | MP5J015 | UnitCode | INT | 4 | 2 | — | ||
MP60 | Tmp.Actual cost | MP60007 | RunTime | NUMERIC | 20 | 8 | 9 | 8 | — |
MP60 | Tmp.Actual cost | MP60010 | TimeDiffer | NUMERIC | 20 | 8 | 11 | 8 | — |
MP61 | MPC Bill of Material | MP61011 | Scrap % | NUMERIC | 6 | 8 | 4 | 8 | — |
MP61 | MPC Bill of Material | MP61024 | Unit Code | INT | 4 | 2 | — | ||
MP62 | Workcentre Load | MP62016 | Start Date Time Factor (Op) | NUMERIC | 12 | 8 | — | — | + |
MP62 | Workcentre Load | MP62017 | Due Date Time Factor (Op) | NUMERIC | 12 | 8 | — | — | + |
MP62 | Workcentre Load | MP62018 | MRP proposal link | NVARCHAR | 10 | — | — | + | |
MP63 | Routings | MP63027 | Accounting String | NVARCHAR | 120 | 50 | — | ||
MP63 | Routings | MP63034 | Scrap % | NUMERIC | 6 | 8 | 4 | 8 | — |
MP64 | Work Orders | MP64044 | Address Name | NVARCHAR | 35 | 25 | — | ||
MP64 | Work Orders | MP64045 | Address Line 1 | NVARCHAR | 35 | 25 | — | ||
MP64 | Work Orders | MP64046 | Address Line 2 | NVARCHAR | 35 | 25 | — | ||
MP64 | Work Orders | MP64047 | Address Line 3 | NVARCHAR | 35 | 25 | — | ||
MP64 | Work Orders | MP64068 | Accounting String | NVARCHAR | 120 | 50 | — | ||
MP64 | Work Orders | MP64082 | Address Line 4 | NVARCHAR | 35 | 25 | — | ||
MP64 | Work Orders | MP64124 | Reminder Date FPO | DATETIME | 8 | — | — | + | |
MP64 | Work Orders | MP64125 | Start Date Time Factor | NUMERIC | 12 | 8 | — | — | + |
MP64 | Work Orders | MP64126 | Due Date Time Factor | NUMERIC | 12 | 8 | — | — | + |
MP64 | Work Orders | MP64127 | Address Line 5 | NVARCHAR | 35 | — | — | + | |
MP64 | Work Orders | MP64128 | Address Line 6 | NVARCHAR | 35 | — | — | + | |
MP64 | Work Orders | MP64129 | Country Code | NVARCHAR | 3 | — | — | + | |
MP64 | Work Orders | MP64130 | Address Line 7 | NVARCHAR | 35 | — | — | + | |
MP64 | Work Orders | MP64131 | RMA Reference | NVARCHAR | 10 | — | — | + | |
MP64 | Work Orders | MP64132 | RMA Comment | NVARCHAR | 50 | — | — | + | |
MP64 | Work Orders | MP64133 | RMA Reference No. | NVARCHAR | 10 | — | — | + | |
MP64 | Work Orders | MP64134 | ATP WO Shift | INT | 1 | — | — | + | |
MP64 | Work Orders | MP64135 | Actual ATP period shift days | INT | 1 | — | — | + | |
MP65 | WO BOM | MP65010 | Scrap % | NUMERIC | 6 | 8 | 4 | 8 | — |
MP65 | WO BOM | MP65036 | Unit Code | INT | 4 | 2 | — | ||
MP65 | WO BOM | MP65057 | Not Issued Quantity [SC Unit] | NUMERIC | 12 | 8 | — | — | + |
MP65 | WO BOM | MP65058 | Special line | NCHAR | 1 | — | — | + | |
MP65 | WO BOM | MP65059 | Accounting String | NVARCHAR | 120 | — | — | + | |
MP66 | WO BOM, Issue | MP66017 | Created by Picking Request | NCHAR | 1 | — | — | + | |
MP67 | WO Routings | MP67026 | Accounting String | NVARCHAR | 120 | 50 | — | ||
MP67 | WO Routings | MP67035 | Issued Run Time | NUMERIC | 20 | 8 | 10 | 8 | — |
MP67 | WO Routings | MP67060 | Scrap % | NUMERIC | 6 | 8 | 4 | 8 | — |
MP67 | WO Routings | MP67096 | Start Date Time Factor | NUMERIC | 12 | 8 | — | — | + |
MP67 | WO Routings | MP67097 | Due Date Time Factor | NUMERIC | 12 | 8 | — | — | + |
MP67 | WO Routings | MP67098 | Accessory Run Time | NUMERIC | 20 | 8 | — | — | + |
MP69 | Load File | MP69018 | Start Date Time Factor (Op) | NUMERIC | 12 | 8 | — | — | + |
MP69 | Load File | MP69019 | Due Date Time Factor (Op) | NUMERIC | 12 | 8 | — | — | + |
MP6G | Work File for use in SC06002 | MP6G011 | ScrapFactor | NUMERIC | 6 | 8 | 4 | 8 | — |
MP6G | Work File for use in SC06002 | MP6G024 | UnitCode | INT | 4 | 2 | — | ||
MP75 | Production Statistics | MP75017 | Run Time | NUMERIC | 20 | 8 | 10 | 8 | — |
MP75 | Production Statistics | MP75018 | Run Time Planned | NUMERIC | 20 | 8 | 10 | 8 | — |
MP76 | Actual Cost Head | MP76018 | Accounting String | NVARCHAR | 120 | 50 | — | ||
MP76 | Actual Cost Head | MP76028 | Scrap % | NUMERIC | 6 | 8 | 4 | 8 | — |
MP76 | Actual Cost Head | MP76042 | WO type | INT | 1 | — | — | + | |
MP76 | Actual Cost Head | MP76043 | RMA Reference | NVARCHAR | 10 | — | — | + | |
MP76 | Actual Cost Head | MP76044 | RMA Comment | NVARCHAR | 50 | — | — | + | |
MP76 | Actual Cost Head | MP76045 | RMA Reference No. | NVARCHAR | 10 | — | — | + | |
MP77 | Actual Cost Matr. | MP77006 | Scrap % | NUMERIC | 6 | 8 | 4 | 8 | — |
MP77 | Actual Cost Matr. | MP77020 | Unit Code | INT | 4 | 12 | — | ||
MP77 | Actual Cost Matr. | MP77024 | Accounting String | NVARCHAR | 120 | — | — | + | |
MP78 | Actual Cost Op. | MP78015 | Accounting String | NVARCHAR | 120 | 50 | — | ||
MP82 | WC Calendar | MP82006 | Saved Capacity | NUMERIC | 10 | 8 | — | — | + |
MP85 | C.order -> WO 1 | MP85025 | Release Batch | NVARCHAR | 38 | — | — | + | |
MP85 | C.order -> WO 1 | MP85026 | Due Date Time Factor | NUMERIC | 12 | 8 | — | — | + |
MP85 | C.order -> WO 1 | MP85027 | Material reservation date | DATETIME | 8 | — | — | + | |
MP85 | C.order -> WO 1 | MP85028 | Text line 1 | NVARCHAR | 25 | — | — | + | |
MP85 | C.order -> WO 1 | MP85029 | Text line 2 | NVARCHAR | 25 | — | — | + | |
MP85 | C.order -> WO 1 | MP85030 | Text line 3 | NVARCHAR | 25 | — | — | + | |
MP85 | C.order -> WO 1 | MP85031 | RMA Reference | NVARCHAR | 10 | — | — | + | |
MP85 | C.order -> WO 1 | MP85032 | RMA Comment | NVARCHAR | 50 | — | — | + | |
MP85 | C.order -> WO 1 | MP85033 | RMA Reference No. | NVARCHAR | 10 | — | — | + | |
MP85 | C.order -> WO 1 | MP85034 | ATP WO Shift | INT | 1 | — | — | + | |
MP86 | C.order -> WO 2 | MP86016 | Open Scrap % | NUMERIC | 6 | 8 | 4 | 8 | — |
MP86 | C.order -> WO 2 | MP86030 | Accessory Operation | NCHAR | 3 | — | — | + | |
MP90 | Auto Acctg WIP. | MP90004 | Accounting code 1 | NCHAR | 2 | — | — | + | |
MP90 | Auto Acctg WIP. | MP90005 | Accounting code 2 | NCHAR | 2 | — | — | + | |
MP90 | Auto Acctg WIP. | MP90006 | Extra code | NCHAR | 2 | — | — | + | |
MP91 | WIP Transact. I | MP91011 | Accounting String | NVARCHAR | 120 | 50 | — | ||
MP92 | MRP Mtrl. | MP92028 | Planning date | DATETIME | 8 | — | — | + | |
MP92 | MRP Mtrl. | MP92029 | Firmed order | NCHAR | 1 | — | — | + | |
MP92 | MRP Mtrl. | MP92030 | Purchase Price | NUMERIC | 20 | 8 | — | — | + |
MP92 | MRP Mtrl. | MP92031 | Currency Code | INT | 2 | — | — | + | |
MP92 | MRP Mtrl. | MP92032 | Discount | NUMERIC | 6 | 8 | — | — | + |
MP92 | MRP Mtrl. | MP92033 | Supplier | NVARCHAR | 10 | — | — | + | |
MP92 | MRP Mtrl. | MP92034 | Contract Number | NVARCHAR | 10 | — | — | + | |
MP92 | MRP Mtrl. | MP92035 | Contract Line | NVARCHAR | 6 | — | — | + | |
MP92 | MRP Mtrl. | MP92036 | Quantity PCU | NUMERIC | 12 | 8 | — | — | + |
MP92 | MRP Mtrl. | MP92037 | Factor SC->PC | NUMERIC | 10 | 8 | — | — | + |
MP92 | MRP Mtrl. | MP92038 | Alternate Routing | NVARCHAR | 2 | — | — | + | |
MP92 | MRP Mtrl. | MP92039 | Scheduling Code | INT | 1 | — | — | + | |
MP92 | MRP Mtrl. | MP92040 | Number of units per lot | NUMERIC | 12 | 8 | — | — | + |
MP92 | MRP Mtrl. | MP92041 | Lot Size | NUMERIC | 12 | 8 | — | — | + |
MP92 | MRP Mtrl. | MP92042 | Need from MRP group | NVARCHAR | 6 | — | — | + | |
MP92 | MRP Mtrl. | MP92043 | Allocated Qty | NUMERIC | 12 | 8 | — | — | + |
MP92 | MRP Mtrl. | MP92044 | Locked Qty | NUMERIC | 12 | 8 | — | — | + |
MP92 | MRP Mtrl. | MP92045 | Used/Covered Qty | NUMERIC | 12 | 8 | — | — | + |
MP92 | MRP Mtrl. | MP92046 | Message | INT | 8 | — | — | + | |
MP92 | MRP Mtrl. | MP92047 | Never More | NVARCHAR | 1 | — | — | + | |
MP92 | MRP Mtrl. | MP92048 | Start Date Time Factor | NUMERIC | 12 | 8 | — | — | + |
MP92 | MRP Mtrl. | MP92049 | Due Date Time Factor | NUMERIC | 12 | 8 | — | — | + |
MP92 | MRP Mtrl. | MP92050 | Material reservation date | DATETIME | 8 | — | — | + | |
MP92 | MRP Mtrl. | MP92051 | PTF date | DATETIME | 8 | — | — | + | |
MP92 | MRP Mtrl. | MP92052 | Original start date | DATETIME | 8 | — | — | + | |
MP92 | MRP Mtrl. | MP92053 | Text line 1 | NVARCHAR | 25 | — | — | + | |
MP92 | MRP Mtrl. | MP92054 | Text line 2 | NVARCHAR | 25 | — | — | + | |
MP92 | MRP Mtrl. | MP92055 | Text line 3 | NVARCHAR | 25 | — | — | + | |
MP92 | MRP Mtrl. | MP92056 | Source Warehouse, STO | NVARCHAR | 6 | — | — | + | |
MP92 | MRP Mtrl. | MP92057 | Shipping date, STO | DATETIME | 8 | — | — | + | |
MP92 | MRP Mtrl. | MP92058 | Delivery date, STO | DATETIME | 8 | — | — | + | |
MP92 | MRP Mtrl. | MP92059 | Recently Released | NCHAR | 1 | — | — | + | |
MP92 | MRP Mtrl. | MP92060 | ATP WO Shift | INT | 1 | — | — | + | |
MP92 | MRP Mtrl. | MP92061 | Requested Date | DATETIME | 8 | — | — | + | |
MP93 | MPS Mtrl. | MP93028 | Planning date | DATETIME | 8 | — | — | + | |
MP93 | MPS Mtrl. | MP93029 | Firmed order | NCHAR | 1 | — | — | + | |
MP93 | MPS Mtrl. | MP93030 | Purchase Price | NUMERIC | 20 | 8 | — | — | + |
MP93 | MPS Mtrl. | MP93031 | Currency Code | INT | 2 | — | — | + | |
MP93 | MPS Mtrl. | MP93032 | Discount | NUMERIC | 6 | 8 | — | — | + |
MP93 | MPS Mtrl. | MP93033 | Supplier | NVARCHAR | 10 | — | — | + | |
MP93 | MPS Mtrl. | MP93034 | Contract Number | NVARCHAR | 10 | — | — | + | |
MP93 | MPS Mtrl. | MP93035 | Contract Line | NVARCHAR | 6 | — | — | + | |
MP93 | MPS Mtrl. | MP93036 | Quantity PCU | NUMERIC | 12 | 8 | — | — | + |
MP93 | MPS Mtrl. | MP93037 | Factor SC->PC | NUMERIC | 10 | 8 | — | — | + |
MP93 | MPS Mtrl. | MP93038 | Alternate Routing | NVARCHAR | 2 | — | — | + | |
MP93 | MPS Mtrl. | MP93039 | Scheduling Code | INT | 1 | — | — | + | |
MP93 | MPS Mtrl. | MP93040 | Number of units per lot | NUMERIC | 12 | 8 | — | — | + |
MP93 | MPS Mtrl. | MP93041 | Lot Size | NUMERIC | 12 | 8 | — | — | + |
MP93 | MPS Mtrl. | MP93042 | Start Date Time Factor | NUMERIC | 12 | 8 | — | — | + |
MP93 | MPS Mtrl. | MP93043 | Due Date Time Factor | NUMERIC | 12 | 8 | — | — | + |
MP93 | MPS Mtrl. | MP93044 | Material reservation date | DATETIME | 8 | — | — | + | |
MP93 | MPS Mtrl. | MP93045 | PTF date | DATETIME | 8 | — | — | + | |
MP93 | MPS Mtrl. | MP93046 | Original start date | DATETIME | 8 | — | — | + | |
MP93 | MPS Mtrl. | MP93047 | Text line 1 | NVARCHAR | 25 | — | — | + | |
MP93 | MPS Mtrl. | MP93048 | Text line 2 | NVARCHAR | 25 | — | — | + | |
MP93 | MPS Mtrl. | MP93049 | Text line 3 | NVARCHAR | 25 | — | — | + | |
MP93 | MPS Mtrl. | MP93050 | Source Warehouse, STO | NVARCHAR | 6 | — | — | + | |
MP93 | MPS Mtrl. | MP93051 | Shipping date, STO | DATETIME | 8 | — | — | + | |
MP93 | MPS Mtrl. | MP93052 | Delivery date, STO | DATETIME | 8 | — | — | + | |
MP93 | MPS Mtrl. | MP93053 | ATP WO Shift | INT | 1 | — | — | + | |
MP93 | MPS Mtrl. | MP93054 | Requested Date | DATETIME | 8 | — | — | + | |
MP96 | MRP/SRP Repl. Prop. | MP96019 | OriginalDeliveryDate | DATETIME | 8 | — | — | + | |
MP96 | MRP/SRP Repl. Prop. | MP96020 | User ID | NVARCHAR | 8 | — | — | + | |
MP96 | MRP/SRP Repl. Prop. | MP96021 | Order type | INT | 1 | — | — | + | |
MP96 | MRP/SRP Repl. Prop. | MP96022 | Release Batch | NVARCHAR | 38 | — | — | + | |
MP96 | MRP/SRP Repl. Prop. | MP96023 | Proposal Source | NVARCHAR | 1 | — | — | + | |
MP96 | MRP/SRP Repl. Prop. | MP96024 | Purchase Price | NUMERIC | 20 | 8 | — | — | + |
MP96 | MRP/SRP Repl. Prop. | MP96025 | Currency Code | INT | 2 | — | — | + | |
MP96 | MRP/SRP Repl. Prop. | MP96026 | Discount | NUMERIC | 6 | 8 | — | — | + |
MP96 | MRP/SRP Repl. Prop. | MP96027 | Contract Number | NVARCHAR | 10 | — | — | + | |
MP96 | MRP/SRP Repl. Prop. | MP96028 | Contract Line | NVARCHAR | 6 | — | — | + | |
MP96 | MRP/SRP Repl. Prop. | MP96029 | Requisition Type | INT | 1 | — | — | + | |
MP96 | MRP/SRP Repl. Prop. | MP96030 | Source Warehouse | NVARCHAR | 6 | — | — | + | |
MP96 | MRP/SRP Repl. Prop. | MP96031 | Reminder Date FPO | DATETIME | 8 | — | — | + | |
MP97 | ECO History | MP97012 | Old Value: Scrap % | NUMERIC | 6 | 8 | 4 | 8 | — |
MP97 | ECO History | MP97022 | Old Value: Lead Time Offset | INT | 3 | 12 | 8 | — | |
MP97 | ECO History | MP97033 | New Value: Scrap % | NUMERIC | 6 | 8 | 4 | 8 | — |
MP97 | ECO History | MP97043 | New Value: Lead Time Offset | INT | 3 | 12 | 8 | — | |
MP97 | ECO History | MP97048 | New Value: Unit Code | INT | 4 | 2 | — | ||
MP97 | ECO History | MP97055 | Old Value:: Unit Code | INT | 4 | 2 | — | ||
MP9B | Temporay File B for MRP | MP9B015 | ScrapFactor | NUMERIC | 6 | 8 | 4 | 8 | — |
MP9C | WIP Transact. II | MP9C001 | Record Counter | NUMERIC | 9 | 8 | — | ||
MP9C | WIP Transact. II | MP9C002 | Transaction Number | NCHAR | 9 | 6 | — | ||
MP9C | WIP Transact. II | MP9C003 | Line Number | NCHAR | 7 | 5 | — | ||
MP9C | WIP Transact. II | MP9C006 | Accounting String | NVARCHAR | 120 | 50 | — | ||
MP9C | WIP Transact. II | MP9C009 | Accounting String Line Currency | NVARCHAR | 120 | 50 | — | ||
MP9C | WIP Transact. II | MP9C011 | Transaction Line Text | NVARCHAR | 100 | 25 | — | ||
MP9C | WIP Transact. II | MP9C013 | Tool Number | NVARCHAR | 25 | 23 | — | ||
MP9C | WIP Transact. II | MP9C024 | Link Code | NCHAR | 8 | 5 | — | ||
MP9C | WIP Transact. II | MP9C026 | Unit Code | INT | 4 | 2 | — | ||
MP9C | WIP Transact. II | MP9C030 | PL Reference | NCHAR | 9 | 6 | — | ||
MP9C | WIP Transact. II | MP9C037 | Transaction Text Line Currency | NVARCHAR | 100 | 25 | — | ||
MP9C | WIP Transact. II | MP9C038 | Printed By | NCHAR | 8 | — | — | + | |
MP9C | WIP Transact. II | MP9C039 | Date Printed | DATETIME | 8 | — | — | + | |
MP9C | WIP Transact. II | MP9C040 | AAS code | NVARCHAR | 25 | — | — | + | |
MP9W | WIP Transactions History | MP9W011 | Accounting String | NVARCHAR | 120 | 50 | — | ||
MPFC | Forecast Consumption Table | MPFC001 | Forecast Type | NVARCHAR | 2 | — | — | + | |
MPFC | Forecast Consumption Table | MPFC002 | Forecast Number | NVARCHAR | 4 | — | — | + | |
MPFC | Forecast Consumption Table | MPFC003 | Forecast Segment | NVARCHAR | 10 | — | — | + | |
MPFC | Forecast Consumption Table | MPFC004 | Stock Item Code | NCHAR | 35 | — | — | + | |
MPFC | Forecast Consumption Table | MPFC005 | Year Month | NVARCHAR | 6 | — | — | + | |
MPFC | Forecast Consumption Table | MPFC006 | Period | NVARCHAR | 8 | — | — | + | |
MPFC | Forecast Consumption Table | MPFC007 | Time Unit | NVARCHAR | 1 | — | — | + | |
MPFC | Forecast Consumption Table | MPFC008 | Transaction Source | NVARCHAR | 1 | — | — | + | |
MPFC | Forecast Consumption Table | MPFC009 | Order Number | NVARCHAR | 10 | — | — | + | |
MPFC | Forecast Consumption Table | MPFC010 | Original Line Number | NVARCHAR | 20 | — | — | + | |
MPFC | Forecast Consumption Table | MPFC011 | Consumed Qty | NUMERIC | 12 | 8 | — | — | + |
MPFC | Forecast Consumption Table | MPFC012 | Demand Date | DATETIME | 8 | — | — | + | |
MPGI | MRP Group Dep Item Data | MPGI001 | MRP Group | NVARCHAR | 6 | — | — | + | |
MPGI | MRP Group Dep Item Data | MPGI002 | Stock Code | NVARCHAR | 35 | — | — | + | |
MPGI | MRP Group Dep Item Data | MPGI003 | Lot Sizing Technique | INT | 1 | — | — | + | |
MPGI | MRP Group Dep Item Data | MPGI004 | Order Qty For EOQ, FOQ, MOQ | NUMERIC | 12 | 8 | — | — | + |
MPGI | MRP Group Dep Item Data | MPGI005 | Bucket Size | INT | 5 | — | — | + | |
MPGI | MRP Group Dep Item Data | MPGI006 | Multiple For Qty Adjustment | NUMERIC | 12 | 8 | — | — | + |
MPGI | MRP Group Dep Item Data | MPGI007 | Safety Stock | NUMERIC | 12 | 8 | — | — | + |
MPGI | MRP Group Dep Item Data | MPGI008 | Safety Stock Lead Time | INT | 3 | — | — | + | |
MPGI | MRP Group Dep Item Data | MPGI009 | Due Before Need | INT | 3 | — | — | + | |
MPGI | MRP Group Dep Item Data | MPGI010 | Reservation/Forecast | INT | 1 | — | — | + | |
MPGI | MRP Group Dep Item Data | MPGI011 | Days For Reservations | INT | 3 | — | — | + | |
MPGI | MRP Group Dep Item Data | MPGI012 | Standard Warehouse For Delivery | NVARCHAR | 6 | — | — | + | |
MPGI | MRP Group Dep Item Data | MPGI013 | Excluded From MRP Net | NCHAR | 1 | — | — | + | |
MPGI | MRP Group Dep Item Data | MPGI014 | Days Before Need To Search Coverage | INT | 5 | — | — | + | |
MPGI | MRP Group Dep Item Data | MPGI015 | Days After Need To Search Coverage | INT | 5 | — | — | + | |
MPGI | MRP Group Dep Item Data | MPGI016 | Lead Time MRP | INT | 3 | — | — | + | |
MPGI | MRP Group Dep Item Data | MPGI017 | Fixed Bucket Schedule for MRP | INT | 2 | — | — | + | |
MPGN | MRP Group Indep Net Event | MPGN001 | Stock Code | NVARCHAR | 35 | — | — | + | |
MPGR | Node-Type configuration | MPGR005 | Order Type Activated (T/F) | NCHAR | 1 | — | — | + | |
MPGS | MRP Group Dep Net Event | MPGS001 | Stock Code | NVARCHAR | 35 | — | — | + | |
MPGS | MRP Group Dep Net Event | MPGS002 | MRP Group | NVARCHAR | 6 | — | — | + | |
MPGS | MRP Group Dep Net Event | MPGS003 | Previous Checksum | INT | 11 | — | — | + | |
MPGS | MRP Group Dep Net Event | MPGS004 | New Checksum | INT | 11 | — | — | + | |
MPGS | MRP Group Dep Net Event | MPGS005 | Net Event | INT | 1 | — | — | + | |
MPGS | MRP Group Dep Net Event | MPGS006 | Calculation Status | INT | 1 | — | — | + | |
MPGS | MRP Group Dep Net Event | MPGS007 | Internal Net Event | INT | 1 | — | — | + | |
MPGS | MRP Group Dep Net Event | MPGS008 | Delete MRP | INT | 1 | — | — | + | |
MPGS | MRP Group Dep Net Event | MPGS009 | Calculation Date Time | DATETIME | 17 | — | — | + | |
MPLF | Action screen coordination table | MPLF001 | Stock Item | NVARCHAR | 35 | — | — | + | |
MPLF | Action screen coordination table | MPLF002 | MRP Group | NVARCHAR | 6 | — | — | + | |
MPLF | Action screen coordination table | MPLF003 | Session GUID | NVARCHAR | 42 | — | — | + | |
MPLL | Sales order lines to work order link | MPLL001 | Work order | NVARCHAR | 10 | — | — | + | |
MPLL | Sales order lines to work order link | MPLL002 | Sales order | NVARCHAR | 10 | — | — | + | |
MPLL | Sales order lines to work order link | MPLL003 | Sales order line | NVARCHAR | 6 | — | — | + | |
MPLL | Sales order lines to work order link | MPLL004 | Sales order sub line | NVARCHAR | 6 | — | — | + | |
MPLL | Sales order lines to work order link | MPLL005 | SC-quantity | NUMERIC | 12 | 8 | — | — | + |
MPLL | Sales order lines to work order link | MPLL006 | Work order status | INT | 1 | — | — | + | |
MPLL | Sales order lines to work order link | MPLL007 | Conf. prod. date | DATETIME | 8 | — | — | + | |
MPLL | Sales order lines to work order link | MPLL008 | Fulfilment order | INT | 2 | — | — | + | |
MPLL | Sales order lines to work order link | MPLL009 | Quantity received | NUMERIC | 12 | 8 | — | — | + |
MPM4 | API of forecast print-out temporary file | MPM4010 | Creation Date | DATETIME | 8 | — | — | + | |
MPM4 | API of forecast print-out temporary file | MPM4011 | Creation Time | NCHAR | 6 | — | — | + | |
MPMG | MRP Group Definition | MPMG001 | MRP Group ID | NVARCHAR | 6 | — | — | + | |
MPMG | MRP Group Definition | MPMG002 | Description | NVARCHAR | 25 | — | — | + | |
MPMG | MRP Group Definition | MPMG003 | Master Warehouse | NVARCHAR | 6 | — | — | + | |
MPMG | MRP Group Definition | MPMG004 | Lead Time Warehouse | NVARCHAR | 6 | — | — | + | |
MPMS | Fixed MRP/MPS bucket schedule | MPMS001 | Schedule ID | INT | 2 | — | — | + | |
MPMS | Fixed MRP/MPS bucket schedule | MPMS002 | Description | NVARCHAR | 25 | — | — | + | |
MPMS | Fixed MRP/MPS bucket schedule | MPMS003 | Start date of schedule | DATETIME | 8 | — | — | + | |
MPMS | Fixed MRP/MPS bucket schedule | MPMS004 | Whole month buckets | NCHAR | 1 | — | — | + | |
MPMS | Fixed MRP/MPS bucket schedule | MPMS005 | Number of days for buckets | INT | 3 | — | — | + | |
MPMW | Warehouse-MRP Group Relation | MPMW001 | Warehouse | NVARCHAR | 6 | — | — | + | |
MPMW | Warehouse-MRP Group Relation | MPMW002 | MRP Group ID | NVARCHAR | 6 | — | — | + | |
MPOL | Work order type description | MPOL001 | WO type | INT | 1 | — | — | + | |
MPOL | Work order type description | MPOL002 | Language | NCHAR | 3 | — | — | + | |
MPOL | Work order type description | MPOL003 | Description | NVARCHAR | 25 | — | — | + | |
MPOT | Work order type setup | MPOT001 | WO type | INT | 1 | — | — | + | |
MPOT | Work order type setup | MPOT002 | Accounting code 2 | INT | 2 | — | — | + | |
MPOT | Work order type setup | MPOT003 | Use WO close | NCHAR | 1 | — | — | + | |
MPOT | Work order type setup | MPOT004 | Alt. Routing | NVARCHAR | 2 | — | — | + | |
MPOT | Work order type setup | MPOT005 | Number series | NVARCHAR | 1 | — | — | + | |
MPPG | MRP Pegging | MPPG001 | Receipt Type | NVARCHAR | 2 | — | — | + | |
MPPG | MRP Pegging | MPPG002 | Receipt Order | NVARCHAR | 10 | — | — | + | |
MPPG | MRP Pegging | MPPG003 | Receipt Line | NVARCHAR | 14 | — | — | + | |
MPPG | MRP Pegging | MPPG004 | Issue Type | NVARCHAR | 2 | — | — | + | |
MPPG | MRP Pegging | MPPG005 | Issue Order | NVARCHAR | 10 | — | — | + | |
MPPG | MRP Pegging | MPPG006 | Issue Line | NVARCHAR | 14 | — | — | + | |
MPPG | MRP Pegging | MPPG007 | Stock Code | NVARCHAR | 35 | — | — | + | |
MPPG | MRP Pegging | MPPG008 | MRP Group | NVARCHAR | 6 | — | — | + | |
MPPG | MRP Pegging | MPPG009 | Quantity | NUMERIC | 12 | 8 | — | — | + |
MPPG | MRP Pegging | MPPG010 | Split | NVARCHAR | 1 | — | — | + | |
MPRO | RMA link | MPRO001 | Repair WO | NVARCHAR | 10 | — | — | + | |
MPRO | RMA link | MPRO002 | Base WO | NVARCHAR | 10 | — | — | + |
Не забудьте посетить страницу «Наши услуги» и заказать интеграцию Epicor Service Connect, отчет SSRS или что-то еще... / Be sure to visit our Services page and order an Epicor Service Connect integration, SSRS report, or anything else...
На один уровень вверх / One level Up: Изменение полей в таблицах БД iScala 3.5 по сравнению с iScala 2.2 / Difference between DB structure of iScala 3.5 and iScala 2.2