Best Practice | Object Key Tables
- 18 Oct 2024
- 1 Minute to read
- Print
- DarkLight
Best Practice | Object Key Tables
- Updated on 18 Oct 2024
- 1 Minute to read
- Print
- DarkLight
Article summary
Did you find this summary helpful?
Thank you for your feedback
Object tables in CMiC are database tables that store rows of records. Each column corresponds to an attribute of an Object Type and represents how the data is stored in that object. The keys on a Object table are uniquely identifiable data sets that are used to retrieve a specific record.
Below are supported Object Types and Keys:
| Application | Object, | Table Name, | Object Key1, | Object Key2, | Object Key3, | Object Key4 |
|---|---|---|---|---|---|---|
| Accounts Payable | APVOUCHER | VOUCHER | Company Code | Vendor Code | Invoice Code | Duplicate ID |
| Core System | BPARTNERS | BPARTNERS_TABLE | Bp Code | |||
| Core System | BPVENDORS | BPVENDORS | Company Code | Bp Code | ||
| Human Capital Management | PYEMPLOYEE | PYEMPLOYEE_TABLE | Emp Number | |||
| Project Controls | JCJOB | JCJOB_TABLE | Company Code | Job Code | ||
| Project Controls | PCIHEADER | CMMAST | Company Code | Job Code | Cmm Code | |
| Project Controls | SCMAST | SCMAST | Company Code | Vendor Code | Contract Code | Change Code |
| Project Controls | SCSCHED | SCSCHED | ScschVuuid | |||
| Project Management | DMISSUE | DMISSUE | Company Code | Project Code | Issue ID | |
| Project Management | PMDAYJR | PMDAYJR | Company Code | Project Code | Journal ID | |
| Project Management | PMITEM | PMITEM | Company Code | Project Code | Batch Number | |
| Project Management | PMPL | PMPUNCHLIST | Company Code | Project Code | Punch List Code | |
| Project Management | PMPROJECT | PMPROJECT_TABLE | Company Code | Project Code | ||
| Project Management | PMRFI | PMRFI | Company Code | Project Code | RFI ID | |
| Project Management | PMSBM | PMSUBMITTAL | Company Code | Project Code | Submittal ID |