Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SOPS113B
Product: Manufacturing (346)
Series: 3rd Party
Display Name: pref_sop_sys Group Display Name: Manufacturing SOP
Physical Name: SOPS113B
Technical Name: pref_sop_sys
Group Technical Name: Manufacturing SOP
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | CMPANYID ![]() | Company ID | INT5 | Integer | 4 | |
Key to the Company Master (SY01500).
Click to show/hideSELECT
['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 | ||||||
2 | SALESORDERNUMBER_I ![]() | Sales Order Number | STR17_IV_Document_Number | String | 17 | |
3 | SOGENERATE_I ![]() | SO Generate | SO_CB_Generate | Boolean | 0 | |
4 | SOREOPENSO_I ![]() | SO Reopen SO | SO_CB_REOPEN_SO | Boolean | 0 | |
5 | GBORDERSTATUS_I ![]() | GB Order Status | GB | Integer | 0 | |
6 | LOCNCODE ![]() | Location Code | STR10_Location_Code | String | 10 | |
Key to the Site Setup (IV40700).
Click to show/hideSELECT
['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 | ||||||
7 | SOPFOB_I ![]() | SOP_FOB | STR15 | String | 15 | |
8 | SOCBAUTOMO ![]() | Enable Silent MO Generation | SO_CB_Auto_MO | Boolean | 0 | |
9 | SOCBSILENTAUTOMO ![]() | Enable Manual MO Generation | SO_CB_Auto_MO | Boolean | 0 | |
10 | SOCBSCHEDAUTOMO ![]() | SO CB Schedule Auto MO | SO_CB_Schedule_MO | Boolean | 0 | |
11 | SOCBPICKAUTOMO ![]() | SO CB Picklist Auto MO | SO_CB_Generate_Picklist_MO | Boolean | 0 | |
12 | SOCBTODAYDUEDATE ![]() | SO CB Today To Due Date | SO_CB_Assign_Today_Due_Date | Boolean | 0 | |
13 | SOCBREUSEPROMDATE ![]() | SO CB Reuse Prom & Due Date | SO_CB_Reuse_Promise_Due_Date | Boolean | 0 | |
14 | SOCBEDITCHARGES ![]() | SO CB Editable Charges | SO_CB_Editable_Charges | Boolean | 0 | |
15 | SOCBDOWNDAYS ![]() | SO CB Down Days | SO_CB_Down_Days | Boolean | 0 | |
16 | SOCBALLOWEDCHGSI ![]() | SO CB Allow Editable Charges | SO_CB_Allow_Editable_Charges | Boolean | 0 | |
17 | MANUFACTUREORDERST_I ![]() | Manufacture Order Status | DDL_WO_Status | Integer | 0 | |
18 | MANUFACTUREORDPRI_I ![]() | Manufacture Order Priority | DDL_MOP_Priority | Integer | 0 | |
19 | SOGBMOSTATUS ![]() | SO GB MO Status | GB | Integer | 0 | |
20 | MANUFACTUREORDER_I ![]() | Manufacture Order | STR30_UC | String | 30 | |
21 | DRAWFROMSITE_I ![]() | Draw From Site | STR10_Location_Code | String | 10 | |
22 | SCHEDULINGPREFEREN_I ![]() | Scheduling Preference | STR20 | String | 20 | |
23 | ICSSAUTOMOFROMSOI ![]() | ICSS Auto MO From SO | STR30_LBAU | String | 30 | |
24 | ICSSSODISCOUNTSI ![]() | ICSS SO Discounts | STR30_LBAU | String | 30 | |
25 | TRDISPCT ![]() | Trade Discount Percent | INT4_%2 | Integer | 4 | |
26 | TRDISAMT ![]() | Trade Discount Amount | DLR17_RBS0_UTR$ | Currency | 17 | |
27 | SOCBREORDER ![]() | SO CB Reorder | SO_CB_Reorder | Boolean | 0 | |
28 | SOCBUSEEXPIREDATE ![]() | SO CB Use Expiration Date | SO_CB_Use_Expire_Date | Boolean | 0 | |
29 | SODAYSTOEXPIRE ![]() | SO Days To Expire | INT9 | Long Integer | 9 | |
30 | DEX_ROW_ID ![]() | int | int | 10 | ||
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. |