Import/export template > Module Common Data > Import/export template BOMC (Commercial BOM) 

Use this template to extract bills of material data. You can use it to import bills of material (BOM) data from any third party product into Sage X3 and to export from Sage X3.

Imported data is converted into the right format to populate the commercial bill of material header information (function Commercial BOMs (GESBODC)). Components (materials), quantities and fields associated with products such as validity dates on the following tab are also populated:

  • Component

Prerequisites

Other prerequisites

Tables to be completed

The following tables are used by the function. Their content must be updated if necessary :

Table

Table description

TABBOMALT [TBO]

BOM codes

ITMBOM [ITB]

Products - BOMs

Operation

Template BOMC - Commercial BOM must be active.

Data import

Bills of materials (BOMs) consist of a header and links.
The main table to set up is the BOM (BOM header) table. The BOM table is linked to the BOD object.
To import BOMs you must set up two identifiers, one for the header table (table BOM) and one for the link table (table BOMD).
The main object is automatically detected with the main key which is the product/route coupling.

The existence of links is acknowledged according to the following criteria:

  • Search with the sequence number and the component product reference. If the line exists it is modified, otherwise it is created.
  • The BOM import processes the link deletion. A link is deleted if it is imported with a link quantity equal to zero (0).

Data export

All BOM codes are exported.

Mandatory fields in the template

Table BOM - Header BOMs

  • Parent product code (ITMREF)
  • BOM alternative (BOMALT)

Table BOMD - Detail BOMs (links)

  • Link sequence number (BOMSEQ)
  • Additional sequence number (case of options/variables).
  • Component product code (CPNITMREF)
  • Link quantity (LIKQTY)

Error messages

In addition to the generic error messages, the following messages can appear during the entry :

Code type incompatible

The BOM code (product + code) is already in use. You must use a different BOM code.

Tables used

This template can be used in import and export modes. The data is updated in the following tables :

Table

Table description

ACCES [ACC]

Access by user

ATEXTRA [AXX]

Texts to translate

BOM [BOH]

Header BOMS

BOMD [BOD]

Detail BOMs

FACILITY [FCY]

Sites

ITMBOM [ITB]

Products - BOMs

ITMCATEG [ITG]

Product category

ITMFACILIT [ITF]

Products-sites

ITMMASTER [ITM]

Products

TABBOMALT [TBO]

BOM codes