warning
You are viewing documentation for CompuTec PDC 3.0, which is supported until December 31, 2026. After this date, it will no longer receive regular support or maintenance updates.
We recommend upgrading to CompuTec PDC 4.0, which runs on CompuTec AppEngine 3.0 (.NET 8).
When upgrading, update all required CompuTec components together to ensure compatibility. Read more
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 |