Manufacturing Series Sales Order Preferences (ISSP0201)

azurecurveProductsManufacturing (346)3rd PartyManufacturing Series Sales Order Preferences (ISSP0201)

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

Product: Manufacturing (346)
Series: 3rd Party

Display Name: Manufacturing Series Sales Order Preferences
Physical Name: ISSP0201
Technical Name: IC_SOP_PREF

Group Display Name: Manufacturing SOP
Group Technical Name: Manufacturing SOP

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1MANUFACTUREORDPRI_I SearchManufacture Order PriorityDDL_MOP_PriorityInteger20
2MANUFACTUREORDERST_I SearchManufacture Order StatusDDL_WO_StatusInteger20
3SALESORDERNUMBER_I SearchSales Order NumberSTR17_IV_Document_NumberString1817
4SETUPKEY SearchSetup KeyINTInteger20
5SOCBAUTOMO SearchEnable Silent MO GenerationSO_CB_Auto_MOBoolean20
6SOCBSILENTAUTOMO SearchEnable Manual MO GenerationSO_CB_Auto_MOBoolean20
7SOCBSCHEDAUTOMO SearchSO CB Schedule Auto MOSO_CB_Schedule_MOBoolean20
8SOCBPICKAUTOMO SearchSO CB Picklist Auto MOSO_CB_Generate_Picklist_MOBoolean20
9SOCBTODAYDUEDATE SearchSO CB Today To Due DateSO_CB_Assign_Today_Due_DateBoolean20
10SOCBDOWNDAYS SearchSO CB Down DaysSO_CB_Down_DaysBoolean20
11SOGBMOSTATUS SearchSO GB MO StatusGBInteger20
12DRAWFROMSITE_I SearchDraw From SiteSTR10_Location_CodeString1210
13SCHEDULINGPREFEREN_I SearchScheduling PreferenceSTR20String2220
14ICSSAUTOMOFROMSOI SearchICSS Auto MO From SOSTR30_LBAUString3230
15Requested_Ship_Date_Offs SearchRequested Ship Date OffsetINT5Integer24
16Change_MO_Status SearchChange MO StatusCB_Change_MO_StatusBoolean20
17Down_Day_Adjustement_Dir SearchDown Day Adjustement DirectionGBInteger20
18QTY_Edit_Allowed SearchQTY Edit AllowedSTR30_LBAUString3230
19SOCBAPPLYCUSTPRIORITY SearchSO CB Apply Customer PrioritySO_CUST_PRIORITY_CBBoolean20
20SOPRIORITY1FROM SearchSO Priority1FromINT2_U0Integer22
21SOPRIORITY1TO SearchSO Priority1ToINT2_U0Integer22
22SOPRIORITY2FROM SearchSO Priority2FromINT2_U0Integer22
23SOPRIORITY2TO SearchSO Priority2ToINT2_U0Integer22
24SOPRIORITY3FROM SearchSO Priority3FromINT2_U0Integer22
25SOPRIORITY3TO SearchSO Priority3ToINT2_U0Integer22
26DEX_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 PartyManufacturing Series Sales Order Preferences (ISSP0201)

Leave a Reply

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