EDIFACT Invoices Field Mapping Profiles

 

Want to dive deeper into EDIFACT?

Background information on the EDIFACT file format can be found here (from EDItEUR):


What is Edifact?

EDIFACT is a documentation standard used to exchange electronic business libraries. Some library vendors use EDIFACT documents to provide electronic invoicing to libraries.

An EDIFACT invoice consists of a header, one or more invoice lines, and a footer.

  • Segments of the invoice are separated by an apostrophe ( ' ) or caret ( ^ )

  • Within a segment, each field is separated by a plus sign (+)

  • Within a field, each subfield is separated by a colon ( : )

  • A qualifier may also be appended to a subfield, following the subfield's data, and pre-pended with a colon


Default field mapping profiles for common vendors

Default field mapping profiles are provided in FOLIO for a number of common vendors, listed below. The links will take you to the profile on the main FOLIO snapshot environment (see the wiki homepage for login information if needed.) The default profiles can be edited, duplicated, or deleted, as needed by an individual library. 

Amalivre (formerly Aux Amateurs)

Monograph invoice

https://folio-snapshot.dev.folio.org/settings/data-import/mapping-profiles/view/fedf651c-5287-4775-9bc4-dd2460df97e3?sort=name

Casalini

Monograph invoice

https://folio-snapshot.dev.folio.org/settings/data-import/mapping-profiles/view/7a5b35cf-d574-4f1e-9610-b429372f8140?sort=name

CNPIEC

Monograph invoice

https://folio-snapshot.dev.folio.org/settings/data-import/mapping-profiles/view/8f7e326f-326f-471f-88c2-724ee8e3b2e9?sort=name

Coutts

Monograph invoice

https://folio-snapshot.dev.folio.org/settings/data-import/mapping-profiles/view/fd351093-8df0-4f4e-b202-32ca5a0f00c6?sort=name

EBSCO

Serials invoice

https://folio-snapshot.dev.folio.org/settings/data-import/mapping-profiles/view/c89cf275-3ebf-4271-ae89-343dd5824d75?sort=name

Erasmus

Monograph invoice

https://folio-snapshot.dev.folio.org/settings/data-import/mapping-profiles/view/6cdd60de-b8c1-41ce-ab57-6684d5a18fad?sort=name

GOBI

Monograph invoice

https://folio-snapshot.dev.folio.org/settings/data-import/mapping-profiles/view/2ad182ee-75e8-4bdb-b859-530543a064dc?sort=name

Harrassowitz

Serials invoice

https://folio-snapshot.dev.folio.org/settings/data-import/mapping-profiles/view/5c117edc-4f1a-4395-9a9f-ea48f28798d5?sort=name

Hein

Serials invoice

https://folio-snapshot.dev.folio.org/settings/data-import/mapping-profiles/view/4f8505ce-59c8-42f1-b925-b1e57d8f9269?sort=name

Midwest

Monograph invoice

https://folio-snapshot.dev.folio.org/settings/data-import/mapping-profiles/view/950d9436-6a96-40f6-94c8-9ae39aef26e4?sort=name

Nardi

Monograph invoice

https://folio-snapshot.dev.folio.org/settings/data-import/mapping-profiles/view/8bc2ad7e-5bcf-4ee3-af34-236c0f7875ca?sort=name

WT Cox

Serials invoice

https://folio-snapshot.dev.folio.org/settings/data-import/mapping-profiles/view/7bfd8670-b3f1-447c-ac43-29e04324809c?sort=name

Default profiles are incomplete

Note that the default profiles are provided as a place for libraries to start. They are NOT complete enough to import invoices for a production library until they are edited, linked to an action profile, and linked to a job profile.


Adapting the default field mapping profiles for individual library use

For each data element in the field mapping profile, the library can specify default (constant) data or a mapping to one or more areas in the EDIFACT file or in the invoice line's related purchase order line (POL).

Fields that need to be added to a library's local copy of the field mapping include:

  • Invoice information

    • Batch group

    • Acquisitions unit (if used by your library)

  • Vendor information

    • Vendor name - use organization lookup to connect it to an existing organization in your library tenant

  • Extended information

    • Payment method - choose from the drop-down

    • Currency and exchange rate - if you need different from default


Using default FOLIO data in EDIFACT mappings

Default data must be enclosed in double quotation marks, e.g. Terms: "Net 30"

If the field has pre-defined reference data, a drop down list appears. When a value is selected from a drop down list, it will automatically be enclosed in quotation marks. To avoid types if a field has a drop down list, libraries are encouraged to select a default value from the list, rather than typing the value into the field. 


Â