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 | SQL DB Length | Keyable Length |
|---|---|---|---|---|---|---|
| 1 | CMPANYID  | Company ID | INT5 | Integer | 2 | 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 | 18 | 17 |
| 3 | SOGENERATE_I | SO Generate | SO_CB_Generate | Boolean | 2 | 0 |
| 4 | SOREOPENSO_I | SO Reopen SO | SO_CB_REOPEN_SO | Boolean | 2 | 0 |
| 5 | GBORDERSTATUS_I | GB Order Status | GB | Integer | 2 | 0 |
| 6 | LOCNCODE | Location Code | STR10_Location_Code | String | 12 | 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 | 16 | 15 |
| 8 | SOCBAUTOMO | Enable Silent MO Generation | SO_CB_Auto_MO | Boolean | 2 | 0 |
| 9 | SOCBSILENTAUTOMO | Enable Manual MO Generation | SO_CB_Auto_MO | Boolean | 2 | 0 |
| 10 | SOCBSCHEDAUTOMO | SO CB Schedule Auto MO | SO_CB_Schedule_MO | Boolean | 2 | 0 |
| 11 | SOCBPICKAUTOMO | SO CB Picklist Auto MO | SO_CB_Generate_Picklist_MO | Boolean | 2 | 0 |
| 12 | SOCBTODAYDUEDATE | SO CB Today To Due Date | SO_CB_Assign_Today_Due_Date | Boolean | 2 | 0 |
| 13 | SOCBREUSEPROMDATE | SO CB Reuse Prom & Due Date | SO_CB_Reuse_Promise_Due_Date | Boolean | 2 | 0 |
| 14 | SOCBEDITCHARGES | SO CB Editable Charges | SO_CB_Editable_Charges | Boolean | 2 | 0 |
| 15 | SOCBDOWNDAYS | SO CB Down Days | SO_CB_Down_Days | Boolean | 2 | 0 |
| 16 | SOCBALLOWEDCHGSI | SO CB Allow Editable Charges | SO_CB_Allow_Editable_Charges | Boolean | 2 | 0 |
| 17 | MANUFACTUREORDERST_I | Manufacture Order Status | DDL_WO_Status | Integer | 2 | 0 |
| 18 | MANUFACTUREORDPRI_I | Manufacture Order Priority | DDL_MOP_Priority | Integer | 2 | 0 |
| 19 | SOGBMOSTATUS | SO GB MO Status | GB | Integer | 2 | 0 |
| 20 | MANUFACTUREORDER_I | Manufacture Order | STR30_UC | String | 32 | 30 |
| 21 | DRAWFROMSITE_I | Draw From Site | STR10_Location_Code | String | 12 | 10 |
| 22 | SCHEDULINGPREFEREN_I | Scheduling Preference | STR20 | String | 22 | 20 |
| 23 | ICSSAUTOMOFROMSOI | ICSS Auto MO From SO | STR30_LBAU | String | 32 | 30 |
| 24 | ICSSSODISCOUNTSI | ICSS SO Discounts | STR30_LBAU | String | 32 | 30 |
| 25 | TRDISPCT | Trade Discount Percent | INT4_%2 | Integer | 2 | 4 |
| 26 | TRDISAMT | Trade Discount Amount | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
| 27 | SOCBREORDER | SO CB Reorder | SO_CB_Reorder | Boolean | 2 | 0 |
| 28 | SOCBUSEEXPIREDATE | SO CB Use Expiration Date | SO_CB_Use_Expire_Date | Boolean | 2 | 0 |
| 29 | SODAYSTOEXPIRE | SO Days To Expire | INT9 | Long Integer | 4 | 9 |
| 30 | DEX_ROW_ID | int | int | 10 | 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. | ||||||