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 TypeLength
1REPORTOPTION_I SearchReport OptionSTR20String20
2REPORTINDEX_I SearchReport IndexDLR14Currency14
3ASKECHTM SearchAsk Each TimeCB_Ask_Each_TimeBoolean0
4INCLGNDS SearchInclude LegendsCB_Include_LegendsBoolean0
5PRNTOFIL SearchPrint to FileCB_Print_to_FileBoolean0
6PRTOPRTR SearchPrint to PrinterCB_Print_to_PrinterBoolean0
7PRTOSCRN SearchPrint to ScreenCB_Print_to_ScreenBoolean0
8IFFILXST SearchIf File ExistingGBInteger0
9FILEXPNM SearchFile Export NameSTR255String255
10EXPTTYPE SearchExport TypeINTInteger0
11STARTMCDESC_I SearchstartmcdescSTR30String30
12STARTINSTDATE_I SearchstartinstdateDateDate6
13ENDMCDESC_I SearchendmcdescSTR30String30
14ENDINSTDATE_I SearchendinstdateDateDate6
15SORTBY_I SearchsortbySTR_30String30
16STTLOCCD SearchStart Location CodeSTR10_Location_CodeString10
17ENLOCNCD SearchEnd Location CodeSTR10_Location_CodeString10
18STTITNUM SearchStart Item NumberSTR30_Item_NumberString30
19ENITMNBR SearchEnd Item NumberSTR30_Item_NumberString30
20STARTBUYERID SearchStart Buyer IDSTR15_User_IDString15
21STARTPLANNERCODE_I SearchStart Planner CodeSTR3_UCString3
22ENDBUYERID SearchEnd Buyer IDSTR15_User_IDString15
23ENDPLANNERCODE_I SearchEnd Planner CodeSTR3_UCString3
24NETACROSSSITES_I SearchNet Across SitesBooleanBoolean0
25CBXUSETEXTBUTTONS_I SearchcbxUseTextButtonsCBBoolean0
26STVNDRID SearchStart Vendor IDSTR15_LBUString15
27ENDVNDID SearchEnd Vendor IDSTR15_LBUString15
28STTUSRID SearchStart User IDSTR15_User_IDString15
29ENDUSRID SearchEnd User IDSTR15_User_IDString15
30Start_Regen_Type SearchStart Regen TypeMRP_Regen_TypeInteger0
31End_Regen_Type SearchEnd Regen TypeMRP_Regen_TypeInteger0
32STRTDATE SearchStart DateDTDate8
33ENDDATE SearchEnd DateDTDate8
34DueDateFrom SearchDueDateFromDATE_LONGDate8
35DueDateTo SearchDueDateToDATE_LONGDate8
36ReleaseFrom SearchReleaseFromDATE_LONGDate8
37ReleaseTo SearchReleaseToDATE_LONGDate8
38Start_Counter SearchStart CounterINT9Long Integer9
39End_Counter SearchEnd CounterINT9Long Integer9
40MRPQTYNUM_I SearchMRP_Quantity_NumberINT2Integer2
41MRPUSERNAME_I SearchMRP_User_NameSTR20String20
42RSRCID SearchResource IDSTR30String30
43DEX_ROW_ID Searchintint10

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 *