info
You are viewing documentation for CompuTec PDC 4.0, which runs on CompuTec AppEngine 3.0 (.NET 8).
If you use CompuTec PDC 3.0, see the CompuTec PDC 3.0 documentation.
When upgrading to CompuTec PDC 4.0, update all required CompuTec components together to ensure compatibility.
Before installing or upgrading, review the CompuTec PDC Installation Guide and the system requirements.
CompuTec PDC Related Database Tables
Here, you can find a list of main database tables used by CompuTec PDC.
| Table name | Description | |
|---|---|---|
| 1 | @CT_PF_OTRT | Employee's Tasks (PDCs tiles) |
| 2 | @CT_PF_TRT1 | Task lines |
| 3 | @CT_PF_TRT2 | Receipt/Issues in Task |
| 4 | @CT_PF_OOTR | Time Booking header |
| 5 | @CT_PF_OTR1 | Time Booking lines |
| 6 | @CT_PF_OTR2 | Employees lines in Time Bookings |
| 7 | @CT_PF_OTQY | Registered Quantities |
| 8 | @CT_PF_ORSC | Resources (used in Manufacturing Order) |
| 9 | @CT_PF_OMOR | Manufacturing Order header |
| 10 | @CT_PF_MOR3 | Items in Manufacturing Order |
| 11 | @CT_PF_MOR1 | Coproducts in Manufacturing Order |
| 12 | @CT_PF_MOR4 | Scraps in Manufacturing Order |
| 13 | @CT_PF_MOR2 | WIP Items in Manufacturing Order |
| 14 | @CT_PF_MOR12 | Operation in Manufacturing Order |
| 15 | @CT_PF_MOR16 | Linking Operation and resource in Manufacturing Order |
| 16 | @CT_PF_MOR15 | Operation Binding Properties in Manufacturing Order |
| 17 | @CT_PF_MOR6 | Sales Orders related to Manufacturing Order |
| 18 | @CT_PF_MOR19 | Attachments in Manufacturing Order |
| 19 | @CT_PF_MOR14 | Operation Binding |
| 20 | @CT_PF_OOPR | Operation header |
| 21 | @CT_PF_OPR1 | Operation Properties |
| 22 | @CT_PF_OPR2 | Resources linked with Operation |
| 23 | @CT_PF_OPDC | PDC settings |
| 24 | @CT_PF_AICH | Item Properties |
| 25 | @CT_PF_ODTM | Resources Downtimes |
| 26 | @CT_PF_OWDC | Weight document header |
| 27 | @CT_PF_WDC1 | Weight document lines |
| 28 | @CT_PF_OWLG | Weight log |
| 29 | OHEM | Employee Master Data |