Typical mapping issues: the order of qualified segments/loops

From time to time I face trading partners, which require a particular order of qualified segments/loops. For example, N1 (BY), then N1 (SE), then N1 (SF) and then N1 (ST). So I ask developers who work on the outbound maps to generate such things in the order defined in the specifications. I.e. if the spec lists DTM (010) first and DTM (002) second, the map should do the same – just in case. For inbound maps I obviously ask developers not to use positions but qualifiers.

Gennady Kim

Typical mapping issues: CTT-01 in X12 856

A typical issue – when an unexperienced developer works on the outbound X12 856 documents (ASNs/Ship Notices), they often populate CTT-01 with the number of products this Ship Notice contains. Partly because of its definition of

CTT-01 354 Number of Line Items
Total number of line items in the transaction set

But for X12 856 CTT-01 should contain the number of HL groups/loops. There is a note about it in the standard:

NOTES 3/010 Number of line items (CTT01) is the accumulation of the number of HL segments. If used, hash total (CTT02) is the sum of the value of units shipped (SN102) for each SN1 segment.

Gennady Kim

Typical mapping issues: Vendor Number

Decided to start publishing very short posts about typical issues/mistakes map developers make working on the maps.

And Vendor Number is one of the things (unexperienced) developers often do not understand. For some reasons they think it is some kind of an additional document identifier, like PO number – and map it (I witnessed it multiple times) to things like Sales Order number, End Customer PO number or even PO number itself.

The reality is that Vendor Numbers are IDs buyer/purchaser assigns to its vendors/suppliers, and it stays the same across the documents with the same sender/receiver ID.

Usually it comes in Purchase Orders (X12 850) as

REF*IA*12345'

and should be sent back in Invoices (X12 810) the same way

REF*IA*12345'

In some cases it might be even hardcoded in the outbound maps.
Gennady Kim