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 TypeLength
1MANUFACTUREORDPRI_I SearchManufacture Order PriorityDDL_MOP_PriorityInteger0
2MANUFACTUREORDERST_I SearchManufacture Order StatusDDL_WO_StatusInteger0
3SALESORDERNUMBER_I SearchSales Order NumberSTR17_IV_Document_NumberString17
4SETUPKEY SearchSetup KeyINTInteger0
5SOCBAUTOMO SearchEnable Silent MO GenerationSO_CB_Auto_MOBoolean0
6SOCBSILENTAUTOMO SearchEnable Manual MO GenerationSO_CB_Auto_MOBoolean0
7SOCBSCHEDAUTOMO SearchSO CB Schedule Auto MOSO_CB_Schedule_MOBoolean0
8SOCBPICKAUTOMO SearchSO CB Picklist Auto MOSO_CB_Generate_Picklist_MOBoolean0
9SOCBTODAYDUEDATE SearchSO CB Today To Due DateSO_CB_Assign_Today_Due_DateBoolean0
10SOCBDOWNDAYS SearchSO CB Down DaysSO_CB_Down_DaysBoolean0
11SOGBMOSTATUS SearchSO GB MO StatusGBInteger0
12DRAWFROMSITE_I SearchDraw From SiteSTR10_Location_CodeString10
13SCHEDULINGPREFEREN_I SearchScheduling PreferenceSTR20String20
14ICSSAUTOMOFROMSOI SearchICSS Auto MO From SOSTR30_LBAUString30
15Requested_Ship_Date_Offs SearchRequested Ship Date OffsetINT5Integer4
16Change_MO_Status SearchChange MO StatusCB_Change_MO_StatusBoolean0
17Down_Day_Adjustement_Dir SearchDown Day Adjustement DirectionGBInteger0
18QTY_Edit_Allowed SearchQTY Edit AllowedSTR30_LBAUString30
19SOCBAPPLYCUSTPRIORITY SearchSO CB Apply Customer PrioritySO_CUST_PRIORITY_CBBoolean0
20SOPRIORITY1FROM SearchSO Priority1FromINT2_U0Integer2
21SOPRIORITY1TO SearchSO Priority1ToINT2_U0Integer2
22SOPRIORITY2FROM SearchSO Priority2FromINT2_U0Integer2
23SOPRIORITY2TO SearchSO Priority2ToINT2_U0Integer2
24SOPRIORITY3FROM SearchSO Priority3FromINT2_U0Integer2
25SOPRIORITY3TO SearchSO Priority3ToINT2_U0Integer2
26DEX_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 PartyManufacturing Series Sales Order Preferences (ISSP0201)

Leave a Reply

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