Frames | No Frames

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

Balance message

Version:D
Release:99B
Contr. Agency:UN
Revision:1
Date:1999-09-11
SOURCE:European Board for EDIFACT Standardization - EEG11

CONTENTS
Balance 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)
    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 Balance message (BALANC) 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 enterprise related balances between the enterprise and whoever may use them for the purpose of accounting, auditing, cost accounting, consolidation, financial analysis, etc.


1.2. Field of Application

The Balance 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 and auditing partners of an enterprise require accounting information, most of which is of a common nature. In order, therefore, to cope with the practice, an enterprise (parent company, subsidiary, division, etc.), a service bureau, a chartered accountant or an auditor - referred to as a sender

  • may transmit balances to the various parties involved - known as recipients - such as another enterprise (parent company, subsidiary, division, etc.), another service bureau, another chartered accountant or another auditor. The trial balance is based on the accounting entries reflecting the activity of the enterprise and the chart of accounts. It enables the preparation of the financial statements. The term balance is taken to mean an accounting document that for a given period, consists of a list of all accounts from the same accounting system. Each account indicates debit or credit total amounts in local and foreign currencies. The balance can be transmitted at a given moment for control purposes. The message BALANC contains information concerning a balance for a given period. The frequency of this message 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 Balance message is BALANC.

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

Data element0065BALANC
0052D
005499B
0051UN

0020 BGM, Beginning of message

A segment identifying the balance message.

0030 DTM, Date/time/period

A segment containing balance opening and closing dates and its preparation date.

0040 RFF, Reference

A segment containing the number of the balance linked to the message and its version number.

0050 CUX, Currencies

A segment providing currencies which are specific to the balance message.

0060 FTX, Free text

A segment containing free text information, in coded or clear form, giving additional clarifications solely concerning the summary section. In computer-to-computer exchanges such text information will normally require the receiver to process this segment manually.

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 a party.

0090 RFF, Reference

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

0100 Segment Group 2: CTA-COM

A segment group to identify 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 balance.

0140 CCI, Characteristic/class id

A segment to identify a characteristic.

0150 CAV, Characteristic value

A segment to provide the value of the characteristic.

0160 Segment Group 4: LIN-MOA-DTM-RFF-QTY-SG5

A segment group providing the following relevant information for a given period of the balance : account number and its identification, period, quantity, stated value and record number.

0170 LIN, Line item

A segment indicating the trial balance line number within the message.

0180 MOA, Monetary amount

A segment containing detailed information about debit or credit trend of the amount, the amount itself in local and original currency and the currency code relating to these amounts.

0190 DTM, Date/time/period

A segment giving detailed information on the opening and closing dates of account.

0200 RFF, Reference

A segment containing a reference number which may be a journal page number (folio) and sequence number within the folio (line) as a single reference number or a serial number assigned at bookkeeping entry level (record number) for a given period.

0210 QTY, Quantity

A segment specifying the quantity and the measure unit relative to the amount of the accounting trial balance.

0220 Segment Group 5: CPT-SG6

A segment group containing detailed information identifying an account.

0230 CPT, Account identification

A segment containing detailed information identifying the treated main account number and its subsidiary account numbers.

0240 Segment Group 6: CCI-CAV

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

0250 CCI, Characteristic/class id

A segment to identify a characteristic.

0260 CAV, Characteristic value

A segment to provide the value of the characteristic.

0270 Segment Group 7: EQN-MOA

A segment group providing information on trial balance amounts and quantities. This group provides totals for verification purposes.

0280 EQN, Number of units

A segment specifying the number of balance lines for a given period relative to the balance message.

0290 MOA, Monetary amount

A segment adding up the total amounts in local and all foreign currencies in the balance message.

0300 Segment Group 8: AUT-DTM

A segment group to provide authentication information.

0310 AUT, Authentication result

A segment to provide authentication results.

0320 DTM, Date/time/period

A segment to provide the date of authentication.

0330 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
EQN Number of units
FTX Free text
LIN Line item
MOA Monetary amount
NAD Name and address
QTY Quantity
RFF Reference
UNH Message header
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 (M)
├─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 ×99999 (M)
├─LIN Line item ×1 (M)
├─MOA Monetary amount ×999 (M)
├─DTM Date/time/period ×1 (C)
├─RFF Reference ×1 (C)
├─QTY Quantity ×10 (C)
└─Segment Group 5 ×9 (M)
──├─CPT Account identification ×1 (M)
──└─Segment Group 6 ×99 (C)
────├─CCI Characteristic/class id ×1 (M)
────└─CAV Characteristic value ×1 (C)
├─Segment Group 7 ×1 (M)
├─EQN Number of units ×1 (M)
└─MOA Monetary amount ×9 (M)
├─Segment Group 8 ×1 (C)
├─AUT Authentication result ×1 (M)
└─DTM Date/time/period ×1 (C)
└─UNT Message trailer ×1 (M)

Return to Stylus Studio EDIFACT D99B 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 Simplify Legacy Data Integration with Stylus Studio XML Enterprise Edition - Free Download!
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-2011 All Rights Reserved.