MFG_Module_Options_MRP (MPUF0130)

azurecurveProductsManufacturing (346)3rd PartyMFG_Module_Options_MRP (MPUF0130)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/MPUF0130

Product: Manufacturing (346)
Series: 3rd Party

Display Name: MFG_Module_Options_MRP
Physical Name: MPUF0130
Technical Name: MRP_Report_Options

Group Display Name: Manufacturing MRP
Group Technical Name: Manufacturing MRP

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1REPORTOPTION_I SearchReport OptionSTR20String2220
2REPORTINDEX_I SearchReport IndexDLR14Currency1014
3ASKECHTM SearchAsk Each TimeCB_Ask_Each_TimeBoolean20
4INCLGNDS SearchInclude LegendsCB_Include_LegendsBoolean20
5PRNTOFIL SearchPrint to FileCB_Print_to_FileBoolean20
6PRTOPRTR SearchPrint to PrinterCB_Print_to_PrinterBoolean20
7PRTOSCRN SearchPrint to ScreenCB_Print_to_ScreenBoolean20
8IFFILXST SearchIf File ExistingGBInteger20
9FILEXPNM SearchFile Export NameSTR255String256255
10EXPTTYPE SearchExport TypeINTInteger20
11STARTMCDESC_I SearchstartmcdescSTR30String3230
12STARTINSTDATE_I SearchstartinstdateDateDate46
13ENDMCDESC_I SearchendmcdescSTR30String3230
14ENDINSTDATE_I SearchendinstdateDateDate46
15SORTBY_I SearchsortbySTR_30String3230
16STTLOCCD SearchStart Location CodeSTR10_Location_CodeString1210
17ENLOCNCD SearchEnd Location CodeSTR10_Location_CodeString1210
18STTITNUM SearchStart Item NumberSTR30_Item_NumberString3230
19ENITMNBR SearchEnd Item NumberSTR30_Item_NumberString3230
20STARTBUYERID SearchStart Buyer IDSTR15_User_IDString1615
21STARTPLANNERCODE_I SearchStart Planner CodeSTR3_UCString43
22ENDBUYERID SearchEnd Buyer IDSTR15_User_IDString1615
23ENDPLANNERCODE_I SearchEnd Planner CodeSTR3_UCString43
24NETACROSSSITES_I SearchNet Across SitesBooleanBoolean20
25CBXUSETEXTBUTTONS_I SearchcbxUseTextButtonsCBBoolean20
26STVNDRID SearchStart Vendor IDSTR15_LBUString1615
27ENDVNDID SearchEnd Vendor IDSTR15_LBUString1615
28STTUSRID SearchStart User IDSTR15_User_IDString1615
29ENDUSRID SearchEnd User IDSTR15_User_IDString1615
30Start_Regen_Type SearchStart Regen TypeMRP_Regen_TypeInteger20
31End_Regen_Type SearchEnd Regen TypeMRP_Regen_TypeInteger20
32STRTDATE SearchStart DateDTDate48
33ENDDATE SearchEnd DateDTDate48
34DueDateFrom SearchDueDateFromDATE_LONGDate48
35DueDateTo SearchDueDateToDATE_LONGDate48
36ReleaseFrom SearchReleaseFromDATE_LONGDate48
37ReleaseTo SearchReleaseToDATE_LONGDate48
38Start_Counter SearchStart CounterINT9Long Integer49
39End_Counter SearchEnd CounterINT9Long Integer49
40MRPQTYNUM_I SearchMRP_Quantity_NumberINT2Integer22
41MRPUSERNAME_I SearchMRP_User_NameSTR20String2220
42RSRCID SearchResource IDSTR30String3230
43DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurveProductsManufacturing (346)3rd PartyMFG_Module_Options_MRP (MPUF0130)

Leave a Reply

Your email address will not be published. Required fields are marked *