Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/MPPS0130
Product: Manufacturing (346)
Series:
Display Name: MRP Setup File Group Display Name: Manufacturing MRP
Physical Name: MPPS0130
Technical Name: MRP_Setup
Group Technical Name: Manufacturing MRP
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | RUNNUMBER  | MRP_Run_Number | Long Integer | INT9 | 9 | |
| 2 | RUNSTARTDATE_I | Run Start Date | Date | Date_RJ | 0 | |
| 3 | RUNENDDATE_I | Run End Date | Date | Date_RJ | 0 | |
| 4 | CHANGEDATE_I | Change Date | Date | DT | 8 | |
| 5 | USERID | User ID | String | STR15_User_ID | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['MRP Setup File'].USERID AS 'MRP Setup File-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
MPPS0130 AS ['MRP Setup File']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['MRP Setup File'].USERID = ['Users Master'].USERID | ||||||
| 6 | STTITNUM | Start Item Number | String | STR30_Item_Number | 30 | |
| 7 | ENITMNBR | End Item Number | String | STR30_Item_Number | 30 | |
| 8 | MRPCBDAYS_I | MRP_CB_Days | Boolean | MRP_CB_Days | 0 | |
| 9 | MRPCBMONTHS_I | MRP_CB_Months | Boolean | MRP_CB_Months | 0 | |
| 10 | MRPCBUSER_I | MRP_CB_User | Boolean | MRP_CB_User | 0 | |
| 11 | MRPUSERSIZE_I | MRP_User_Size | Integer | INT4 | 4 | |
| 12 | MRPCBWEEKS_I | MRP_CB_Weeks | Boolean | MRP_CB_Weeks | 0 | |
| 13 | MRPRunDateI | MRP_Run_Date | Date | DT | 8 | |
| 14 | MRPRUNLENGTH_I | MRP_Run_Length | Integer | INT3 | 3 | |
| 15 | MRPRUNSPAN_I | MRP_Run_Span | Integer | MRP_Run_Span | 0 | |
| 16 | MRPREGENTYPE_I | MRP_Regen_Type | Integer | MRP_Regen_Type | 0 | |
| 17 | MRP_METHOD | MRP_Method | Integer | MRP_Method | 0 | |
| 18 | PASTDUE | MRP_Past_Due_Period | Integer | INT3_U0 | 3 | |
| 19 | MRPEITHER_I | MRP_INT_Either_Items | Integer | INT2 | 2 | |
| 20 | MRPCBMOVEIN | MRP_CB_Movein | Boolean | MRP_CB_Movin | 0 | |
| 21 | MRPCBTIMEFENCE | MRP_CB_Time_Fence | Boolean | MRP_CB_Time_Fence | 0 | |
| 22 | MOVEOUT | MoveOut | Boolean | CB | 0 | |
| 23 | CANCELED | Cancelled | Boolean | YN | 0 | |
| 24 | MRPCBCALCINACTIVE_I | MRP_CB_CalcInactive | Boolean | MRP_CB_CalcInactive | 0 | |
| 25 | CALCPASTDUE | MRP_CB_Calc_Past_Due | Boolean | MRP_CB_Calc_Past_Due | 0 | |
| 26 | MRP_CB_MO_Quote | MRP_CB_MO_Quote | Boolean | MRP_CB_MO_Quote | 0 | |
| 27 | MRP_CB_SO_Quote | MRP_CB_SO_Quote | Boolean | MRP_CB_SO_Quote | 0 | |
| 28 | MRPDDCONSTRAINT_I | MRP_DownDay_Constraint | Integer | DDL_MRP_DownDay_Constraint | 0 | |
| 29 | MRPSOREQFIRM_I | MRP_SO_Request_Firmed | Boolean | MRP_SO_Request_Firmed | 0 | |
| 30 | SCHEDULINGPREFEREN_I | Scheduling Preference | String | STR20 | 20 | |
| 31 | STRTTIME | Start Time | Time | TM6 | 6 | |
| 32 | ENDTIME | End Time | Time | TM6 | 6 | |
| 33 | STRTDATE | Start Date | Date | DT | 8 | |
| 34 | ENDDATE | End Date | Date | DT | 8 | |