Single-Bolt-Idents (PDMS_BS.DAT) - Intergraph Smart Reference Data - Version 10.1 - Customization & Programming - Hexagon

Intergraph Smart Reference Data Integration (10.1)

Language
English
Product
Intergraph Smart Reference Data
Search by Category
Customization & Programming
Smart Materials/Smart Reference Data Version
10.1

This file contains complete information about the bolt ident. The format in which details are extracted to the files when you transfer an ident depends on values defined in the Level column. For PDMS_BS.DAT file, by default, BLTA is set at level 1, BLIS at 2, SBOL at 3, and rest of the attributes at level 4 as shown in the following screenshot.

You can customize the Levels.

BS.DAT-Levels

An attribute is always represented with a modifier as <OLD> or <NEW>. <OLD> indicates that the data is already available in Destinations and <NEW> indicates new data. From the following screenshot, BLTA, BLIS, and SBOL have the modifier as <OLD> indicating that the data is already available in Destinations and LENG, NSTD, XTRA, BITEM, BITLE, BDIA, and NOFF have the modifier as <NEW> indicating that the data is new.

The following table provides more details about the attributes in the PDMS_BS.DAT file.

BLTA

  • Definition: BLTA

  • Retrieval Source: '/'||cc.commodity_id||'-'||i.input_1||'-BLTA'

  • Retrieval Method: BASE_COLUMN

BLIS

  • Definition: BLIS

  • Retrieval Source: '/'||cc.commodity_id||'-'||i.input_1||'-BLIST'

  • Retrieval Method: BASE_COLUMN

SBOL

  • Definition: SBOL

  • Retrieval Source: '/'||cc.commodity_id||'-'||i.input_1||'-BS'

  • Retrieval Method: BASE_COLUMN

BDIAMETER

  • Definition: Diameter of the Bolt Geometry.

  • Retrieval Source: i.input_1

  • Retrieval Method: BASE_COLUMN

LENG

  • Definition: Length

  • Retrieval Source: PDMS Default

  • Retrieval Method: NONE

NOFF

  • Definition: Number Off

  • Retrieval Source: PDMS Default

  • Retrieval Method: NONE

NSTD

  • Definition: NSTD

  • Retrieval Source: cc.commodity_id||'-'||i.input_1

  • Retrieval Method: BASE_COLUMN

XTRA

  • Definition: XTRA

  • Retrieval Source: PDMS Default

  • Retrieval Method: NONE

BITEM

  • Definition: BITEM

  • Retrieval Source: m_pck_pdms_lookup.get_pdms_bitem(i.ident,i.input_1)

  • Retrieval Method: BASE_COLUMN

BITLE

  • Definition: BITLE

  • Retrieval Source: m_pck_pdms_lookup.get_pdms_bitle(i.ident,i.input_1)

  • Retrieval Method: BASE_COLUMN

Following image gives you a visual of the file format and data extraction.

BS.dat