Object ID's die automatisch omgezet worden in "Open" opdrachten:
- "OrganizationID", CRM_Organization.Oid
- "PersonID", CRM_Person.Oid
- "PersonOrganizationID", CRM_Person_Organization.Oid
- "EmployeeID", CRM_Employee.Oid
- "CustomerID", CRM_Customer.Oid
- "DebtorID", CRM_Debtor.Oid
- "CreditorID", CRM_Creditor.Oid
- "VendorID", CRM_Vendor.Oid
- "InternalID", CRM_Internal.Oid
- "EventID", EVNT_Event.Oid
- "InvoiceSellID", FINANC_Invoice_Sell.Oid
- "ProjectID", PROJ_Project.Oid
- "DeliveryID", PROJ_Delivery.Oid
- "TenderID", PROJ_Tender.Oid
- "OfferID", PROJ_Offer.Oid
- "CalculationID", PROJ_Calculation.Oid
- "JobID", PROJ_Job.Oid
- "OfferJobID", PROJ_OfferJob.Oid
- "PurchaseOrderID", PROJ_PurchaseOrder.Oid
In het onderstaande voorbeeld worden de kolommen "ProjectID" en "DeliveryID" automatisch omgezet in opdrachten om de objecten te openen. De kolommen zelf worden evrborgen.
SELECT PROJ.Project.Oid AS ProjectID, PROJ.Delivery.Oid AS DeliveryID, PROJ.Project.Code AS OpdrachtNr, PROJ.Project.Description AS Opdracht_Oms, PROJ.Delivery.DeliveryNr AS LeverNr, PROJ.Delivery.Description AS Levering_Oms, PROJ.Delivery.DeliveryDate AS Leverdatum, FROM PROJ.Delivery INNER JOIN PROJ.Project ON PROJ.Delivery.fkProject = PROJ.Project.Oid ORDER BY OpdrachtNr, LeverNr