Best Practice | Object Key Tables
- 12 Feb 2025
- 1 Minute to read
- Print
- DarkLight
Best Practice | Object Key Tables
- Updated on 12 Feb 2025
- 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 |
---|---|---|---|---|---|---|
Asset Management | POMAST | POMAST | Company Code | PO Num | ||
Asset Management | PORQENT | POREQ | Company Code | Req Number | ||
Asset Management | CIITEM | CIITEM | Company Code | Item Code | ||
Accounts Payable | APVOUCHER | VOUCHER | Company Code | Vendor Code | Invoice Code | Duplicate ID |
Core System | BPVENDORS | BPVENDORS | Company Code | Bp Code | ||
Human Capital Management | PYEMPLOYEE | PYEMPLOYEE_TABLE | Emp Number | |||
Opportunity Managment | OMORG | BPARTNERS_TABLE | Bp Code | |||
Opportunity Managment | OMOPPO | OMOPPORTUNITY | Company Code | Opp Code | ||
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 |