pref_sop_sys (SOPS113B)

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

Product: Manufacturing (346)
Series:

Display Name: pref_sop_sys
Physical Name: SOPS113B
Technical Name: pref_sop_sys

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1CMPANYID SearchCompany IDIntegerINT54
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['pref_sop_sys'].CMPANYID AS 'pref_sop_sys-Company ID'
       ,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
       SOPS113B AS ['pref_sop_sys']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['pref_sop_sys'].CMPANYID = ['Company Master'].CMPANYID
2SALESORDERNUMBER_I SearchSales Order NumberStringSTR17_IV_Document_Number17
3SOGENERATE_I SearchSO GenerateBooleanSO_CB_Generate0
4SOREOPENSO_I SearchSO Reopen SOBooleanSO_CB_REOPEN_SO0
5GBORDERSTATUS_I SearchGB Order StatusIntegerGB0
6LOCNCODE SearchLocation CodeStringSTR10_Location_Code10
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['pref_sop_sys'].LOCNCODE AS 'pref_sop_sys-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       SOPS113B AS ['pref_sop_sys']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['pref_sop_sys'].LOCNCODE = ['Site Setup'].LOCNCODE
7SOPFOB_I SearchSOP_FOBStringSTR1515
8SOCBAUTOMO SearchEnable Silent MO GenerationBooleanSO_CB_Auto_MO0
9SOCBSILENTAUTOMO SearchEnable Manual MO GenerationBooleanSO_CB_Auto_MO0
10SOCBSCHEDAUTOMO SearchSO CB Schedule Auto MOBooleanSO_CB_Schedule_MO0
11SOCBPICKAUTOMO SearchSO CB Picklist Auto MOBooleanSO_CB_Generate_Picklist_MO0
12SOCBTODAYDUEDATE SearchSO CB Today To Due DateBooleanSO_CB_Assign_Today_Due_Date0
13SOCBREUSEPROMDATE SearchSO CB Reuse Prom & Due DateBooleanSO_CB_Reuse_Promise_Due_Date0
14SOCBEDITCHARGES SearchSO CB Editable ChargesBooleanSO_CB_Editable_Charges0
15SOCBDOWNDAYS SearchSO CB Down DaysBooleanSO_CB_Down_Days0
16SOCBALLOWEDCHGSI SearchSO CB Allow Editable ChargesBooleanSO_CB_Allow_Editable_Charges0
17MANUFACTUREORDERST_I SearchManufacture Order StatusIntegerDDL_WO_Status0
18MANUFACTUREORDPRI_I SearchManufacture Order PriorityIntegerDDL_MOP_Priority0
19SOGBMOSTATUS SearchSO GB MO StatusIntegerGB0
20MANUFACTUREORDER_I SearchManufacture OrderStringSTR30_UC30
21DRAWFROMSITE_I SearchDraw From SiteStringSTR10_Location_Code10
22SCHEDULINGPREFEREN_I SearchScheduling PreferenceStringSTR2020
23ICSSAUTOMOFROMSOI SearchICSS Auto MO From SOStringSTR30_LBAU30
24ICSSSODISCOUNTSI SearchICSS SO DiscountsStringSTR30_LBAU30
25TRDISPCT SearchTrade Discount PercentIntegerINT4_%24
26TRDISAMT SearchTrade Discount AmountCurrencyDLR17_RBS0_UTR$17
27SOCBREORDER SearchSO CB ReorderBooleanSO_CB_Reorder0
28SOCBUSEEXPIREDATE SearchSO CB Use Expiration DateBooleanSO_CB_Use_Expire_Date0
29SODAYSTOEXPIRE SearchSO Days To ExpireLong IntegerINT99

Leave a Reply

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