Record Type Reference

Every DATANORM record type the app reads, what it produces and which setting controls it.

Each line in a DATANORM file starts with an identifying letter, the record type. The table below shows which ones the app processes.

Processed record types

Rec.	Meaning	Result in Business Central	Setting
V	Header record	Version, supplier and currency of the file; drives detection	always
A	Main article record	Article in staging	Process Articles
B	Additional article record (V4 only)	Enriches the A record of the same article	Process Articles
T	Long text	Extended text on the item	Process Texts
P	Price change	Price staging and from there price list lines	Process Prices
Z	Scale prices and surcharges	Price lines with a minimum quantity	Process Surcharges
S	Product group	DATANORM product group	Process Product Groups
R	Discount group	DATANORM discount group with its rate	Process Discount Groups
D	Dimensions	Measurements on the article	Process Dimensions
G	Graphic and image reference	Reference number on the article	Process Graphics
C	Service lines	Service data	Process Services
J	Set / part list	Assembly BOM on the set item	Process Part Lists
K	Header of a data block	Structural information about the file	always
E	End record	Closes the file and confirms completeness	always

The settings live under Record Filters in Base Configuration.

V, K and E records are always read because they structure the file. Every other record type can be switched off individually – for example to take only the prices from a very large file.

Notes on individual record types

A and B records belong together (DATANORM 4)

A V4 article consists of an A record and a B record sharing the same article number. The app merges both into one staging record and counts in Merged Source Records how many lines it was built from.

If the same article number appears more than once, the app updates the existing record instead of creating a second one.

One P record can carry up to three articles (DATANORM 4)

In DATANORM 4 a single price change line carries up to three article blocks, each with its own article number, price indicator and price. The app reads all blocks. A file with 9 lines can therefore yield 25 price records.

The price indicator decides which price is filled

The price indicator distinguishes list price (1) from net price (2). The app stores the values in separate fields so that an article's two prices cannot overwrite each other. Which one becomes the purchase price is controlled by Purchase Price Source, see Purchase Price Lists.

A J record always describes the complete set

DATANORM never delivers sets as a delta, always in full. The app therefore replaces an existing assembly BOM rather than appending lines to it. See Building Assembly BOMs.

The calling flag controls optional lines

Lines with calling flag 2 or 4 are optional lines the user selects within the set. By default the app only takes automatically inserted lines. Enable Include Optional Set Lines to pick up the optional ones as well.