| Version: | D |
|---|---|
| Release: | 00B |
| Contr. Agency: | UN |
| Revision: | 1 |
| Date: | 2000-06-28 |
| SOURCE: | EBES - EEG11 - EDIFICAS - SWG D14 |
|
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: D99B, D00A, D00B, D01A, D01B, D01C, D02A, D02B, D03A, D03B, D04A, D04B |
This specification provides the definition of the Ledger message (LEDGER) to be used in Electronic Data Interchange (EDI) between trading partners involved in administration, commerce and transport.
The LEDGER message deals with the communication of accounting ledgers between an organization and whoever may use them for the purpose of accounting, auditing, cost accounting, consolidation, financial analysis, etc.
The Ledger 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.
The accounting ledger may be prepared by an enterprise, a service bureau, a chartered accountant or an auditor - referred as a sender - for various involved parties - known as recipient
See UNTDID, Part 4, Chapter 2.3 UN/ECE UNSM - General Introduction, Section 1.
See UNTDID, Part 4, Chapter 2.3 UN/ECE UNSM - General Introduction, Section 2.
This section should be read in conjunction with the segment table which indicates mandatory, conditional and repeating requirements.
Information to be provided in the Header section:
A service segment starting and uniquely identifying a message. The message type code for the Ledger message is LEDGER.
Note: Ledger messages conforming to this document must contain the following data in segment UNH, composite S009:
| Data element | 0065 | LEDGER |
| 0052 | D | |
| 0054 | 00B | |
| 0051 | UN |
Segment identifying the type of LEDGER message.
A segment containing the opening and closing dates of the accounting period of the accounting entries and the preparation date of the message.
Segment containing the number of the used chart of accounts linked to the message and its version number.
A segment providing currencies which are specific to the LEDGER message.
A segment with free text information, in coded or clear form, for the purpose of providing additional clarification.
A segment group giving information on sender, recipient and intermediary.
A segment to identify a party.
A segment to provide references which are specific to the concerned party.
A group of segments to specify contacts and related communication numbers.
A segment to provide contacts related to the party.
A segment to provide communication numbers of the contact.
A group of segments to provide accounting, fiscal, social or legal characteristics of the accounting ledger.
A segment to identify a characteristic.
A segment to provide the value of the characteristic.
Information to be provided in the Detail section:
0160 Segment group 4: SEQ-CPT-FII-SG5-SG9 A group of segments providing information on accounting entries by ledger.
A segment giving detailed information on the sequence of the ledger.
A segment containing detailed information identifying the active ledger account number (general, cost or budget account), or for evaluation, of the accounting record concerned or the subsidiary account number of this ledger account number.
A segment for the purpose of specifying the bank account numbers relating to the specified account.
A segment group providing the following relevant information for a given period and a specified accounting ledger : record, account number, references, stated value, date and time, quantity and free text, together comprising an accounting record.
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.
A segment containing the number of the source document relating to the accounting record.
A segment with free text information, in coded or clear form, to give an explanation of the accounting entry.
FII-CUX-MOA-SG7 A segment group containing all necessary information for an accounting record.
A segment identifying the line item of the accounting entries or records information sequence.
A segment containing detailed information identifying the account number (general, cost or budget account), or for evaluation of the accounting record concerned or the subsidiary account number.
A segment identifying the source document and the type of accounting records of accounting entries for a given period.
A segment giving the accountancy dates concerning the accounting record, date of capture, date of source document, date of accounting validation.
A segment with free text information, in coded or clear form, to give a text for the entry describing whether the record is cost, budgetary or have valuation purposes.
A segment specifying the settlement method of the accounting record.
A segment containing references to documents such as the number of the source document, number of the related document, the internal source document reference and the checking reference and tax codes relating to the accounting record.
A segment for the purpose of specifying a quantity relating to the monetary amount of the accounting record.
A segment for specifying the duties, tax or fee types relating to the accounting record.
A segment for the purpose of specifying the bank account numbers relating to the specified record.
A segment containing the currency details, currencies or currency rates used in the record.
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.
A group of segments to provide accounting, fiscal, social or legal characteristics of the accounting record.
A segment to identify a characteristic.
A segment to provide the value of the characteristic.
A segment group to provide authentication information.
A segment to provide authentication results.
A segment to provide the date of the authentication.
A group of segments providing information on the totals and the quantities corresponding to the accounting records for verification purposes, this group summarizes all the monetary amounts by account and by period.
A segment indicating the number of accounting entries for a ledger and period.
A segment to provide references related to a ledger or a period.
A segment containing the date related to a ledger or a period.
A segment adding up the total amounts of the accounting records for a ledger and period in local currency and in foreign currency.
Information to be provided in the Summary section:
A service segment used to separate the detail and summary sections.
A segment group providing quantity and amount totals at message level.
A segment specifying the number of sub-periods included in the period covered by the message.
A segment providing references at message level.
A segment containing the date which are relevant at message level for verification purpose.
A segment adding up the total amounts relating to the LEDGER message.
A segment group to provide authentication information.
A segment to provide authentication results.
A segment to provide the date of the authentication.
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.
| 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 | |
| SEQ | Sequence details | |
| TAX | Duty/tax/fee details | |
| UNH | Message header | |
| UNS | Section control | |
| UNT | Message trailer |
| ├─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 | ×99999 | (M) |
| │─├─SEQ Sequence details | ×1 | (M) |
| │─├─CPT Account identification | ×4 | (C) |
| │─├─FII Financial institution information | ×1 | (C) |
| │─├─Segment Group 5 | ×99999 | (M) |
| │─│─├─IND Index details | ×1 | (M) |
| │─│─├─RFF Reference | ×1 | (M) |
| │─│─├─FTX Free text | ×1 | (M) |
| │─│─├─Segment Group 6 | ×999 | (M) |
| │─│─│─├─LIN Line item | ×1 | (M) |
| │─│─│─├─CPT Account identification | ×4 | (C) |
| │─│─│─├─RJL Accounting journal identification | ×1 | (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 7 | ×9 | (C) |
| │─│─│───├─CCI Characteristic/class id | ×1 | (M) |
| │─│─│───└─CAV Characteristic value | ×1 | (C) |
| │─│─└─Segment Group 8 | ×1 | (C) |
| │─│───├─AUT Authentication result | ×1 | (M) |
| │─│───└─DTM Date/time/period | ×1 | (C) |
| │─└─Segment Group 9 | ×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 10 | ×1 | (M) |
| │─├─QTY Quantity | ×1 | (M) |
| │─├─RFF Reference | ×1 | (C) |
| │─├─DTM Date/time/period | ×1 | (C) |
| │─└─MOA Monetary amount | ×9 | (M) |
| ├─Segment Group 11 | ×1 | (C) |
| │─├─AUT Authentication result | ×1 | (M) |
| │─└─DTM Date/time/period | ×1 | (C) |
| └─UNT Message trailer | ×1 | (M) |