Best Practice | Object Key Tables
  • 04 Jul 2025
  • 2 Minutes to read
  • Dark
    Light

Best Practice | Object Key Tables

  • Dark
    Light

Article summary

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:

ApplicationObject,Table Name,Object Key1,Object Key2,Object Key3,Object Key4PM Docs ExtensibleUser Extension Fields Extensible
Asset Management Fixed AssetsFAASSETFAASSETCompany CodeAsset CodeYY
Asset Management Purchase OrderPOMASTPOMASTCompany CodePO NumNY
Asset Management Purchase Requisition - AttachmentsPORQENTPOREQCompany CodeProject CodeDocument IDYN
Asset Management Purchase Requisition - User ExtensionsPORQENTPOREQCompany CodeReq NumberNY
Asset Management InventoryCIITEMCIITEMCompany CodeItem CodeNY
Core System Business PartnersBPVENDORSBPVENDORSCompany CodeBusiness Partner CodeNY
Core System System ContactsSYSCONTACTSYSCONTACTContact codeNY
Financials AP Registered Invoice DistributionAPREGDISTAPREGDISTCompany CodeInvoice CodeYN
Financials VoucherAPVOUCHERVOUCHERCompany CodeVendor CodeInvoice CodeDuplicate IDYY
Financials AP ChequeAPCHEQUEAPCHEQUECompany CodeInvoice CodeYN
Financials AP VendorAPVENAPVENCompany CodeBusiness Partner CodeYN
Financials AR InvoiceARINVARINVCompany CodeInvoice CodeYN
Human Capital Management Employee ProfilePYEMPLOYEEPYEMPLOYEE_TABLEEmp NumberYY
Opportunity Management OrganizationsOMORGBPARTNERS_TABLEBusiness Partner CodeNY
Opportunity Management OpportunityOMOPPOOMOPPORTUNITYCompany CodeOpportunity CodeNY
Opportunity Management Opportunity UDF TabOMOPPOUDFOMOPPORTUNITYCompany CodeOpportunity CodeNY
Project Controls JobJCJOBJCJOB_TABLECompany CodeJob CodeN
Project Controls Job BillingJBCONTJBCONTCompany CodeContract CodeYY
Project Controls Owner Change OrderCMOWNCOCMOWNCOCompany CodeProject CodeOwner Change CodeYY
Project Controls Potential Change ItemPCIHEADERCMMASTCompany CodeJob CodePCI CodeYY
Project Controls SubcontractSCMASTSCMASTCompany CodeVendor CodeContract CodeChange CodeYY
Project Controls Subcontract Schedule of LinesSCSCHEDSCSCHEDSchedule of Line VUUIDYY
Project Management AddendumPMADDENDPMADDENDCompany CodeProject CodeAddendum IDYY
Project Management CommunicationPMCMNPMCMNCompany CodeProject CodeYY
Project Management Daily JournalPMDAYJRPMJOURNALCompany CodeProject CodeJournal IDYY
Project Management IssuesDMISSUEDMISSUECompany CodeProject CodeIssue IDYY
Project Management ItemsPMITEMPMITEMCompany CodeProject CodeBatch NumberYY
Project Management NoticePMPLPMPUNCHLISTCompany CodeProject CodeNotice IDYY
Project Management Subcontract PrequalificationPREQUALUDFPREQUALBusiness Partner CodeYN
Project Management ProjectPMPROJECTPMPROJECT_TABLECompany CodeProject CodeYY
Project Management PunchlistPMPLPMPUNCHLISTCompany CodeProject CodePunch List CodeYY
Project Management RFIPMRFIPMRFICompany CodeProject CodeRFI IDcellYY
Project Management SubmittalPMSBMPMSUBMITTALCompany CodeProject CodeSubmittal IDYY
Project Management TransmittalPMTRANSMITTALPMTRANSMITTALCompany CodeProject CodeTransmittal IDYY