SQL Rapportage

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