informacja
You are viewing documentation for CompuTec WMS 3.0, which runs on CompuTec AppEngine 3.0 (.NET 8).
If you use CompuTec WMS 2.0, see the CompuTec WMS 2.0 documentation.
When upgrading to CompuTec WMS 3.0, update all required CompuTec components together to ensure compatibility.
Before installing or upgrading, review the CompuTec WMS Installation Guide and the system requirements.
CompuTec WMS Related Database Tables
Here, you can find a list of main database tables used by CompuTec WMS.
| # | Table name | Description |
|---|---|---|
| 1 | @CT_WMS_BAR1 | WMS Barcode Decoder Rules |
| 2 | @CT_WMS_BAR2 | WMS Barcode Decoder Variables |
| 3 | @CT_WMS_CONFIG | WMS Configuration |
| 4 | @CT_WMS_DPCH | WMS Dispatch Data |
| 5 | @CT_WMS_INC1 | WMS Inventory Counting Line |
| 6 | @CT_WMS_INC2 | WMS Inventory Items Definition |
| 7 | @CT_WMS_INC3 | WMS Multiple Counters |
| 8 | @CT_WMS_INU1 | WMS Inventory Counting Line UDFs |
| 9 | @CT_WMS_IRG1 | Inventory Register Lines |
| 10 | @CT_WMS_OBAR | WMS Barcode Decoder |
| 11 | @CT_WMS_OBDA | WMS Barcode Decoder Assignment |
| 12 | @CT_WMS_OCCG | New Custom Configuration |
| 13 | @CT_WMS_OCCT | Custom Configuration |
| 14 | @CT_WMS_OCGN | Code Generator - SU Table - Last digits/values for records related to SU |
| 15 | @CT_WMS_OINC | WMS Inventory Counting Header |
| 16 | @CT_WMS_OINU | WMS Inventory Counting Header UDFs |
| 17 | @CT_WMS_OIRG | Inventory Register Header (Storage Units in transactions) |
| 18 | @CT_WMS_ONOT | WMS Notifications |
| 19 | @CT_WMS_OPAR | WMS Put Away Rules |
| 20 | @CT_WMS_OPBX | Packaging boxes |
| 21 | @CT_WMS_OPCR | Packaging rules |
| 22 | @CT_WMS_OPKI | Packaging Instruction |
| 23 | @CT_WMS_OPPD | PickAndPack Cache |
| 24 | @CT_WMS_OSBC | WMS Cache |
| 25 | @CT_WMS_OSCH | Storage Category Header |
| 26 | @CT_WMS_OSEM | Semaphor Header |
| 27 | @CT_WMS_OSLG | WMS Dispatch Logs |
| 28 | @CT_WMS_OSOA | WMS Sort Order Assignment |
| 29 | @CT_WMS_OSOD | WMS Sort Order Definition |
| 30 | @CT_WMS_OSRL | WMS Rules |
| 31 | @CT_WMS_OSTU | Storage Units Header |
| 32 | @CT_WMS_OSUA | Storage Units Action - on Pick List |
| 33 | @CT_WMS_OSVR | WMS Validation Rules |
| 34 | @CT_WMS_OUGR | WMS User Group |
| 35 | @CT_WMS_OVDA | Old Dispatch Control |
| 36 | @CT_WMS_OWTT | WMS Workflow Template Table |
| 37 | @CT_WMS_PKI1 | Packaging Instruction details |
| 38 | @CT_WMS_SCH1 | Storage Category Bins |
| 39 | @CT_WMS_SCH2 | Storage Category Items |
| 40 | @CT_WMS_SCH3 | Storage Category Item Groups |
| 41 | @CT_WMS_SCH4 | Storage Category UoMs |
| 42 | @CT_WMS_SCH5 | Storage Category UoM Groups |
| 43 | @CT_WMS_SOD1 | WMS Sort Order Block |
| 44 | @CT_WMS_SSCC | SSCC Definition |
| 45 | @CT_WMS_STU1 | Storage Unit lines |
| 46 | @CT_WMS_UGR1 | WMS User Group Member |