COBISOFT Documentation

User Tools

Site Tools

You are here: English » 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 [2024/12/05 08:15] – thuthcobi.wms:management_database [2025/09/18 10:16] (current) – [Importing licenses] thuth
Line 212: Line 212:
  
 <code sql> <code sql>
-insert into licenses (license, 'notes') values ('LICENSE_1', 'WMS'); +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_2', 'PPC'); 
-insert into licenses (license, 'notes') values ('LICENSE_3', 'PPC, valid until November 2023');+insert into licenses (license, notes) values ('LICENSE_3', 'PPC, valid until November 2023');
 </code> </code>
  
Line 285: Line 285:
   * ''PDN'': Receipt   * ''PDN'': Receipt
   * ''PKL'': Picking   * ''PKL'': Picking
 +  * ''RDR'': Sales order
   * ''DLN'': Delivery   * ''DLN'': Delivery
   * ''RPD'': Purchase return   * ''RPD'': Purchase return
Line 291: 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 306: 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 317: 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 324: 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 335: 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 348: 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 359: 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 366: 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 377: 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.1733382945.txt.gz · Last modified: by thuth
Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki