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