Single-Bolt-Points (PDMS_BS.DAT) - Intergraph Smart Reference Data - Version 10.0 - Training - Hexagon

Intergraph Smart Reference Data Training (2020)

Language
English
Product
Intergraph Smart Reference Data
Search by Category
Training
Smart Materials/Smart Reference Data Version
2020 (10.0)

This file contains complete information about the bolt ident. Each row will 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

The following image explains the data extraction and the file format used.

10.0 PDMD_BS