Data entities for Cepheo Advanced Quality and Sample Management

Dawid Kaczmarek Updated by Dawid Kaczmarek

Data entities

The following data entities have been added for the data in the CEPHEO Quality and Sample management tables:   

Entity 

Type 

Advanced quality associations

EGLAQCInventTestAssociationTableEntity

Advanced quality control parameters

EGLAQCAdvancedQualityControlParametersEntity

Analysis methods

EGLAQCAnalysisMethodTableEntity

Inventory batch attributes (advanced quality control)

EGLAQCPdsBatchAttributesEntity

Item sampling (advanced quality control)

EGLAQCInventItemSamplingEntity

Batch disposition master (extended)

Lab sections

EGLAQCSampleLabSectionEntity

Test group members (advanced quality control)

EGLAQCInventTestGroupMemberEntity

Test groups (advanced quality control)

EGLAQCInventTestGroupEntity

Tests (advanced quality control)

EGLAQCInventTestTableEntity

Quality samples and types

EGLQSMProdLabSamplesAndTypesEntity (composite entity containing: Quality sample and Sample types)

Test of stability

EGLQSMTestOfDurabilityTableEntity (composite entity containing: Test of stability frequency table and Test of stability setup table)

Test of stability setup table

EGLQSMTestOfDurabilitySetupTableEntity

Test of stability frequency table

EGLQSMTestOfDurabilityFrequenceTableEntity

Sample warehouse location setup table

EGLQSMSampleWarehouseLocationSetupEntity

Sample types

EGLQSMSampleTypeTableEntity

Sample types setup table

EGLQSMSampleTypeRelationsEntity

Samples sample types

EGLQSMSampleSampleTypesTableEntity

Quality Sample Management Parameters

EGLQSMQualitySampleManagementParametersEntity

Quality sample

EGLQSMProdLabSampleRegTableEntity

EcoResReleasedProductV2Entity

The standard entity has been extended with the new field to setup 'Simulated sample creation group'

EGLAQCAdvancedQualityControlParametersEntity

The bespoke entity has been extended with the new field to setup calendar that is used for Quality work forecasting

EGLQWFReqSimulateSamplesGroupEntity (Sample simulation group)

Entity

Batch manufacturing extensions number group

Entity

Advanced quality order line results

Entity with code for updates on adv. Quality orders when inserted or updated via import using data entities: EGLAQCInventQualityOrderLineResultsEntity

EGLAQCUseIntegerTestResultRounding

EGLAQCUseIntegerTestResultRounding

Test result rounding on integers

EGLAQCInventTestResultRounding rule

Enable specific rounding principle

 EGLAQCForceTestResultRounding rule

Below only for import into same company due to the large number of references

Entity (below only for import into same company due to the large number of references)

Type 

Advanced quality order headers

EGLAQCInventQualityOrderTableEntity

Advanced quality order lines

EGLAQCInventQualityOrderLineEntity

Fail immediately (test group line)

EGLAQCTestFailed1_EGLAQCInventQualityOrderFailImmidiatly

Automatic creation of Non-conformance (test group line)

EGLAQCNonConformanceQualityOrders_EGLAQCNonConformanceQualityOrderAutoCreation 

Problem type (test group line)

EGLAQCNonConformanceQualityOrders_EGLAQCNonConformanceQualityOrderProblemType 

NOTE: Several other standard entities for quality control must be selected in a data project to perform export and import for the total set of data.

NOTE: When using the entity ‘Item Batches”, only records with Batch disposition code will be imported.

NOTE: When using the entity ‘Inventory batch attributes (advanced quality control)’, only records with an attribute value will be imported.

NOTE: If you are using the entity framework to include data for advanced quality order headers and lines, several standard transactional related data must be available in the company receiving the data, such as:

  • ·Reference order number (i.e., Purchase Id, Batch order Id ..)
  • ·Reference lot from the inventory module (Correct inventory transactions must be available)

How did we do?

Usage for Power App and Flow

Contact