COBISOFT Documentation

User Tools

Site Tools

You are here: start » COBI.wms » Management Database
cobi.wms:management_database

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
cobi.wms:management_database [2023/06/28 16:07] – [Optional columns] tkammercobi.wms:management_database [2025/09/18 10:16] (current) – [Importing licenses] thuth
Line 207: Line 207:
 insert into licenses (license) values ('LICENSE_2'); insert into licenses (license) values ('LICENSE_2');
 insert into licenses (license) values ('LICENSE_3'); insert into licenses (license) values ('LICENSE_3');
 +</code>
 +
 +The licenses table also has an optional ''notes'' column which you can use for notes about the license.  For example, if you have both regular COBI.wms licenses as well as COBI.ppc licenses in the same database, you can differentiate them through these notes.  Or, when importing test licenses that are only valid for a limited time, you can enter this as a note.  Examples:
 +
 +<code sql>
 +insert into licenses (license, notes) values ('LICENSE_1', 'WMS');
 +insert into licenses (license, notes) values ('LICENSE_2', 'PPC');
 +insert into licenses (license, notes) values ('LICENSE_3', 'PPC, valid until November 2023');
 </code> </code>
  
Line 277: Line 285:
   * ''PDN'': Receipt   * ''PDN'': Receipt
   * ''PKL'': Picking   * ''PKL'': Picking
 +  * ''RDR'': Sales order
   * ''DLN'': Delivery   * ''DLN'': Delivery
   * ''RPD'': Purchase return   * ''RPD'': Purchase return
Line 283: Line 292:
   * ''IPN'': Receipt from production   * ''IPN'': Receipt from production
   * ''PRQ'': Purchase request   * ''PRQ'': Purchase request
-  * ''POR'': Purchase order+  * ''POR'': Purchase Order
   * ''ITM'': Wares list   * ''ITM'': Wares list
   * ''INC'': Inventory counting   * ''INC'': Inventory counting
   * ''WTQ'': Inventory transfer request   * ''WTQ'': Inventory transfer request
   * ''PRINT'': Label printing   * ''PRINT'': Label printing
 +  * ''ITEM'': Item info
  
 For your convenience, here is a template for calling the ''setUserPermission'' procedure once for every module, which you can copy & paste into SQL Server Management Studio or HANA Studio: For your convenience, here is a template for calling the ''setUserPermission'' procedure once for every module, which you can copy & paste into SQL Server Management Studio or HANA Studio:
Line 298: Line 308:
 exec setUserPermission 'username', 'PDN', 1; exec setUserPermission 'username', 'PDN', 1;
 exec setUserPermission 'username', 'PKL', 1; exec setUserPermission 'username', 'PKL', 1;
 +exec setUserPermission 'username', 'RDR', 1;
 exec setUserPermission 'username', 'DLN', 1; exec setUserPermission 'username', 'DLN', 1;
 exec setUserPermission 'username', 'RPD', 1; exec setUserPermission 'username', 'RPD', 1;
Line 309: Line 320:
 exec setUserPermission 'username', 'WTQ', 1; exec setUserPermission 'username', 'WTQ', 1;
 exec setUserPermission 'username', 'PRINT', 1; exec setUserPermission 'username', 'PRINT', 1;
 +exec setUserPermission 'username', 'ITEM', 1;
  
 -- SAP HANA -- SAP HANA
Line 316: Line 328:
 call setUserPermission('username', 'PDN', 1); call setUserPermission('username', 'PDN', 1);
 call setUserPermission('username', 'PKL', 1); call setUserPermission('username', 'PKL', 1);
 +call setUserPermission('username', 'RDR', 1);
 call setUserPermission('username', 'DLN', 1); call setUserPermission('username', 'DLN', 1);
 call setUserPermission('username', 'RPD', 1); call setUserPermission('username', 'RPD', 1);
Line 327: Line 340:
 call setUserPermission('username', 'WTQ', 1); call setUserPermission('username', 'WTQ', 1);
 call setUserPermission('username', 'PRINT', 1); call setUserPermission('username', 'PRINT', 1);
 +call setUserPermission('username', 'ITEM', 1);
 </code> </code>
  
Line 340: Line 354:
 exec setDevicePermission deviceID, 'PDN', 1; exec setDevicePermission deviceID, 'PDN', 1;
 exec setDevicePermission deviceID, 'PKL', 1; exec setDevicePermission deviceID, 'PKL', 1;
 +exec setDevicePermission deviceID, 'RDR', 1;
 exec setDevicePermission deviceID, 'DLN', 1; exec setDevicePermission deviceID, 'DLN', 1;
 exec setDevicePermission deviceID, 'RPD', 1; exec setDevicePermission deviceID, 'RPD', 1;
Line 351: Line 366:
 exec setDevicePermission deviceID, 'WTQ', 1; exec setDevicePermission deviceID, 'WTQ', 1;
 exec setDevicePermission deviceID, 'PRINT', 1; exec setDevicePermission deviceID, 'PRINT', 1;
 +exec setDevicePermission deviceID, 'ITEM', 1;
  
 -- SAP HANA -- SAP HANA
Line 358: Line 374:
 call setDevicePermission(deviceID, 'PDN', 1); call setDevicePermission(deviceID, 'PDN', 1);
 call setDevicePermission(deviceID, 'PKL', 1); call setDevicePermission(deviceID, 'PKL', 1);
 +call setDevicePermission(deviceID, 'RDR', 1);
 call setDevicePermission(deviceID, 'DLN', 1); call setDevicePermission(deviceID, 'DLN', 1);
 call setDevicePermission(deviceID, 'RPD', 1); call setDevicePermission(deviceID, 'RPD', 1);
Line 369: Line 386:
 call setDevicePermission(deviceID, 'WTQ', 1); call setDevicePermission(deviceID, 'WTQ', 1);
 call setDevicePermission(deviceID, 'PRINT', 1); call setDevicePermission(deviceID, 'PRINT', 1);
 +call setDevicePermission(deviceID, 'ITEM', 1);
 </code> </code>
  
 Change ''deviceID'' to the correct device ID number via search & replace, and switch the 1 at the end to a 0 for the modules to disable. Change ''deviceID'' to the correct device ID number via search & replace, and switch the 1 at the end to a 0 for the modules to disable.
cobi.wms/management_database.1687961233.txt.gz · Last modified: by tkammer
Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki