One level Up / 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   +