На один уровень вверх / One level Up: Изменение полей в таблицах БД iScala 3.5 по сравнению с iScala 2.2 / Difference between DB structure of iScala 3.5 and iScala 2.2

Изменения структуры таблиц модуля «Управление Материалами в Производстве» / Material Production Control tables structure changes

Название Таблицы / 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   — — +