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 |