Frames | No Frames

Return to Stylus Studio EDIFACT home page.
Return to Stylus Studio EDIFACT D04B Messages page.
UN/EDIFACT
UNITED NATIONS STANDARD MESSAGE (UNSM)

Accounting entries message

Version:D
Release:04B
Contr. Agency:UN
Revision:2
Date:2004-11-23
SOURCE:TBG12 Accounting and Auditing, Registration, Financial Information Services

CONTENTS
Accounting entries message
  1. INTRODUCTION
  2. SCOPE
    1. Functional definition
    2. Field of application
    3. Principles
  3. REFERENCES
  4. TERMS AND DEFINITIONS
    1. Standard terms and definitions
  5. MESSAGE DEFINITION
    1. Segment clarification
    2. Segment index (alphabetical sequence by tag)
    3. Message structure
      1. Segment table

For general information on UN standard message types see UN Trade Data Interchange Directory, UNTDID, Part 4, Section 2.3, UN/ECE UNSM General Introduction


This message also occurs in the following versions of this standard:
D98A, D98B, D99A, D99B, D00A, D00B, D01A, D01B, D01C, D02A, D02B, D03A, D03B, D04A, D04B

0. INTRODUCTION

This specification provides the definition of the Accounting entries message (ENTREC) to be used in Electronic Data Interchange (EDI) between trading partners involved in administration, commerce and transport.


1. SCOPE


1.1. Functional definition

A message used to exchange accounting entries between an enterprise and whoever may use them for the purpose of accounting, auditing, cost accounting, consolidation, financial analysis, etc.


1.2. Field of application

The Accounting entries message may be used for both national and international applications. It is based on universal practice related to administration, commerce and transport, and is not dependent on the type of business or industry.


1.3. Principles

The accounting entries may be prepared by an enterprise, a service bureau, a chartered accountant or an auditor - referred to as sender - for various parties - known as recipients - such as another enterprise, another service bureau, another chartered accountant or another auditor.

The accounting entries are reflecting the activity of the enterprise. Merged with the chart of accounts, they enable to establish the ledger and consequently the trial balance.

The term accounting entries is taken to mean a set of automated accounting records relating to the same event. A computerized accounting record is an accounting entry item consisting of several logically interrelated data items specifying the value date of an amount, its origin, its account concerned, its debit or credit amount and its references to the relevant document.

The message ENTREC contains information concerning a set of entries for a given journal and period. The frequency of collected data ranges from daily to annually.


2. REFERENCES

See UNTDID, Part 4, Chapter 2.3 UN/ECE UNSM - General Introduction, Section 1.


3. TERMS AND DEFINITIONS


3.1. Standard terms and definitions

See UNTDID, Part 4, Chapter 2.3 UN/ECE UNSM - General Introduction, Section 2.


4. MESSAGE DEFINITION


4.1. Segment clarification

This section should be read in conjunction with the segment table which indicates mandatory, conditional and repeating requirements.

0010 UNH, Message header

A service segment starting and uniquely identifying a message. The message type code for the Accounting entries message is ENTREC.

Note: Accounting entries messages conforming to this document must contain the following data in segment UNH, composite S009:

Data element0065ENTREC
0052D
005404B
0051UN

0020 BGM, Beginning of message

Segment identifying the type of accounting entries message.

0030 DTM, Date/time/period

A segment containing the opening and closing dates of the accounting period of the accounting entries and the preparation date of the message.

0040 RFF, Reference

Segment containing the number of the used chart of accounts linked to the message and its version number.

0050 CUX, Currencies

A segment providing currencies which are specific to the accounting entries message.

0060 FTX, Free text

A segment with free information, in coded or clear form, for the purpose of providing additional clarification solely concerning the summary section.

0070 Segment Group 1: NAD-RFF-SG2

A segment group giving information on sender, recipient and intermediary.

0080 NAD, Name and address

A segment to identify the sender, recipient or intermediary.

0090 RFF, Reference

A segment to provide references which are specific to the concerned party.

0100 Segment Group 2: CTA-COM

A group of segments to specify contacts and related communication numbers.

0110 CTA, Contact information

A segment to provide contacts related to the party.

0120 COM, Communication contact

A segment to provide communication numbers of the contact.

0130 Segment Group 3: CCI-CAV

A group of segments to provide accounting, fiscal, social or legal characteristics of the enterprise accounting.

0140 CCI, Characteristic/class id

A segment to identify the accounting, fiscal, social or legal characteristic.

0150 CAV, Characteristic value

A segment to provide the value of the above characteristic.

0160 Segment Group 4: DTM-SG5-SG11

A segment group providing information on accounting entries by period.

0170 DTM, Date/time/period

A segment giving detailed information on the periods of the journal.

0180 Segment Group 5: RJL-SG6-SG7

A segment group providing information on accounting entries by journal.

0190 RJL, Accounting journal identification

A segment specifying the source journal and the type of accounting records of accounting entries for a given period.

0200 Segment Group 6: QTY-RFF-DTM-MOA

A segment group providing information on the totals and the quantities corresponding to the accounting records. For verification purposes, this group summarizes all the monetary amounts by journal and by period.

0210 QTY, Quantity

A segment specifying the number of accounting entries for a given journal and period.

0220 RFF, Reference

A segment containing references to a journal in a given period.

0230 DTM, Date/time/period

A segment containing the date of the concerned period.

0240 MOA, Monetary amount

A segment adding up the total amounts of the accounting records for a given journal and period in local and foreign currencies. It may also to be used to provide the total of the journal for the period.

0250 Segment Group 7: IND-RFF-FTX-SG8-SG10

A segment group providing the following relevant information for a given period and a specified accounting journal : record, account number, references, stated value, date and time, quantity and free text, together comprising an accounting record.

0260 IND, Index details

A segment containing the reference to an order number inside a folio, or the sequential number allocated to the entry of an accounting record for a given journal and period.

0270 RFF, Reference

A segment containing the number of the source document relating to the accounting record.

0280 FTX, Free text

A segment with free text information, in coded or clear form, to give an explanation of the accounting entry.

0290 Segment Group 8: LIN-CPT-DTM-FTX-PAI-RFF-QTY-TAX-FII-

CUX-MOA-SG9 A segment group containing all needed information on an accounting record.

0300 LIN, Line item

A segment identifying the line item of the accounting entries information sequence.

0310 CPT, Account identification

A segment containing detailed information identifying the principal active account number (general, analytical or budget account) or for subdivision of the accounting record concerned and the subsidiary account number of this principal account number.

0320 DTM, Date/time/period

A segment giving the date of accountancy concerning the accounting record : date of capture, date of source document, date of accounting validation, etc.

0330 FTX, Free text

A segment with free text information, in clear or coded form, to give a text for the entry describing whether the entry is analytical, budgetary or has valuation purposes.

0340 PAI, Payment instructions

A segment specifying the settlement method of the accounting record.

0350 RFF, Reference

A segment containing references to documents such as the number of source document, number of related document, internal source document reference, checking reference and European Tax-codes relating to the accounting record.

0360 QTY, Quantity

A segment specifying the quantity and measure unit relative to the monetary amount of the accounting record.

0370 TAX, Duty/tax/fee details

A segment specifying the tax type relative to the accounting record.

0380 FII, Financial institution information

A segment specifying the bank account numbers relative to the specified account.

0390 CUX, Currencies

A segment containing the currency details, currencies or currency rates used in the entry.

0400 MOA, Monetary amount

A segment containing detailed information on the debit or credit trend of the monetary amount, the monetary amount itself in the local currency and possibly the currency code relating to this monetary amount.

0410 Segment Group 9: CCI-CAV

A group of segments to provide accounting, fiscal, social or legal characteristics of the entries.

0420 CCI, Characteristic/class id

A segment to identify the accounting, fiscal, social or legal characteristic of the entry.

0430 CAV, Characteristic value

A segment to provide the value of the above characteristic.

0440 Segment Group 10: AUT-DTM

A segment group to provide authentication information to prevent insertion of an accounting entry between two accounting entries.

0450 AUT, Authentication result

A segment to provide authentication results.

0460 DTM, Date/time/period

A segment to provide the date of the authentication.

0470 Segment Group 11: QTY-RFF-DTM-MOA

A group of segments giving information on the totals and the quantities corresponding to the accounting records. For verification purposes this group summarizes all the monetary amounts by journal, for all periods.

0480 QTY, Quantity

A segment specifying the number of accounting entries for a given journal, for all periods.

0490 RFF, Reference

A segment containing references for a given journal, for the sub-period.

0500 DTM, Date/time/period

A segment specifying the date of the concerned sub-period.

0510 MOA, Monetary amount

A segment adding up the total amounts, in local and foreign currencies, of the accounting records for a given journal, for all periods. It may also be used to provide the total amount of the journal for all periods.

0520 UNS, Section control

A service segment used to separate the detail and summary sections of the message.

0530 Segment Group 12: QTY-RFF-DTM-MOA

A group of segments giving information on the totals and the quantities corresponding to the accounting records. For verification purposes, this summarizes all the monetary amounts.

0540 QTY, Quantity

A segment specifying the number of subperiods for the total periods concerned relative to the accounting entries message.

0550 RFF, Reference

A segment referencing a period using a reference number.

0560 DTM, Date/time/period

A segment specifying the dates for the total period.

0570 MOA, Monetary amount

A segment adding up the total amounts relating to the accounting entries message.

0580 Segment Group 13: AUT-DTM

A segment group to provide authentication information.

0590 AUT, Authentication result

A segment to provide authentication results.

0600 DTM, Date/time/period

A segment to provide the date of the authentication.

0610 UNT, Message trailer

A service segment ending a message, giving the total number of segments in the message (including the UNH & UNT) and the control reference number of the message.


4.2. Segment index (alphabetical sequence by tag)

AUT Authentication result
BGM Beginning of message
CAV Characteristic value
CCI Characteristic/class id
COM Communication contact
CPT Account identification
CTA Contact information
CUX Currencies
DTM Date/time/period
FII Financial institution information
FTX Free text
IND Index details
LIN Line item
MOA Monetary amount
NAD Name and address
PAI Payment instructions
QTY Quantity
RFF Reference
RJL Accounting journal identification
TAX Duty/tax/fee details
UNH Message header
UNS Section control
UNT Message trailer

4.3. Message structure


4.3.1. Segment table

├─UNH Message header ×1 (M)
├─BGM Beginning of message ×1 (M)
├─DTM Date/time/period ×99 (M)
├─RFF Reference ×99 (C)
├─CUX Currencies ×99 (C)
├─FTX Free text ×1 (C)
├─Segment Group 1 ×99 (M)
├─NAD Name and address ×1 (M)
├─RFF Reference ×9 (C)
└─Segment Group 2 ×99 (C)
──├─CTA Contact information ×1 (M)
──└─COM Communication contact ×9 (C)
├─Segment Group 3 ×99 (C)
├─CCI Characteristic/class id ×1 (M)
└─CAV Characteristic value ×1 (C)
├─Segment Group 4 ×999 (M)
├─DTM Date/time/period ×1 (M)
├─Segment Group 5 ×999 (M)
├─RJL Accounting journal identification ×1 (M)
├─Segment Group 6 ×1 (M)
├─QTY Quantity ×1 (M)
├─RFF Reference ×1 (C)
├─DTM Date/time/period ×1 (C)
└─MOA Monetary amount ×9 (M)
└─Segment Group 7 ×99999 (M)
──├─IND Index details ×1 (M)
──├─RFF Reference ×1 (M)
──├─FTX Free text ×1 (M)
──├─Segment Group 8 ×999 (M)
──├─LIN Line item ×1 (M)
──├─CPT Account identification ×4 (C)
──├─DTM Date/time/period ×9 (C)
──├─FTX Free text ×1 (C)
──├─PAI Payment instructions ×1 (C)
──├─RFF Reference ×9 (C)
──├─QTY Quantity ×9 (C)
──├─TAX Duty/tax/fee details ×9 (C)
──├─FII Financial institution information ×1 (C)
──├─CUX Currencies ×9 (C)
──├─MOA Monetary amount ×9 (M)
──└─Segment Group 9 ×9 (C)
────├─CCI Characteristic/class id ×1 (M)
────└─CAV Characteristic value ×1 (C)
──└─Segment Group 10 ×1 (C)
────├─AUT Authentication result ×1 (M)
────└─DTM Date/time/period ×1 (C)
└─Segment Group 11 ×1 (M)
──├─QTY Quantity ×1 (M)
──├─RFF Reference ×1 (C)
──├─DTM Date/time/period ×1 (C)
──└─MOA Monetary amount ×9 (M)
├─UNS Section control ×1 (M)
├─Segment Group 12 ×1 (M)
├─QTY Quantity ×1 (M)
├─RFF Reference ×1 (C)
├─DTM Date/time/period ×1 (C)
└─MOA Monetary amount ×9 (M)
├─Segment Group 13 ×1 (C)
├─AUT Authentication result ×1 (M)
└─DTM Date/time/period ×1 (C)
└─UNT Message trailer ×1 (M)

Return to Stylus Studio EDIFACT D04B Messages page.
EDI to XML Mapping for EDIFACT/X12 Convert EDIFACT/X12 Schemas to XML Schema Legacy Data Conversion Tools Access Relational Data as XML Visual XSLT and XQuery Mapping Tools EDIFACT to XML
Return to Stylus Studio EDIFACT home page.

Return to Stylus Studio home page.
Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.