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