General Data Format in the Example CIP - Intergraph Smart Materials - Version 10.2 - Help - Hexagon

Intergraph Smart Materials Classic Help

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Help
Smart Materials/Smart Reference Data Version
10.2

The USR_ID, LMOD, and INT_REV fields will be populated by a database trigger. The RECORD_STATUS field will be ‘N’ (default). OPIJ_ID will be populated by the OPI job.

The other fields must be populated in the same way you inserted the data in the table.

  • OPIS_ID is the primary key of the table and will be populated by the sequence M_SEQ_OPIS_ID.

  • OPIS_JOB_ID will be populated by the sequence M_SEQ_OPIS_JOB_ID. One opis_job_id is for all the data of one order.

  • PROJ_ID and DP_ID will be used to distribute the data in the table to the projects and disciplines.

  • SEQ will be used as the order sequence.

  • STRING contains the TAGs and their Values, similar to the format for the ASCII file.

For example, one STRING value could look like this:

POH_PROC_TYPE=I|PO_NUMBER=OPI_001|ORDER_TYPE=PO|SUP_CODE=SUP-100| ……..

You can find a file called opi_dtd.dtd on the Smart Materials disk that contains the document type definition (dtd) for the XML file. You can use all TAGS that are available in the opi_dtd.dtd file.