LEDGER Ledger
TBG12 Accounting and Auditing, Registration, Financial Information
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.
Header
- 00010Message headerMandatoryMax 1
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 21A 0051 UN
1. Data element S009/0057 is retained for upward compatibility. The use ofS016 and/or S017 is encouraged in preference.2. The combination of the values carried in data elements 0062 and S009 shallbe used to identify uniquely the message within its group (if used) or ifnot used, within its interchange, for the purpose of acknowledgement. - 00020Beginning of messageMandatoryMax 1
Segment identifying the type of LEDGER message.
- 00030Date/time/periodMandatoryMax 99
A segment containing the opening and closing dates of the accounting period of the accounting entries and the preparation date of the message.
- 00040ReferenceConditionalMax 99
Segment containing the number of the used chart of accounts linked to the message and its version number.
- 00050CurrenciesConditionalMax 99
A segment providing currencies which are specific to the LEDGER message.
- 00060Free textConditionalMax 1
A segment with free text information, in coded or clear form, for the purpose of providing additional clarification.
- Segment group 1Repeat 99
- 00080Name and addressMandatoryMax 1
A segment to identify a party.
- 00090ReferenceConditionalMax 9
A segment to provide references which are specific to the concerned party.
- Segment group 2Repeat 99
- 00110Contact informationMandatoryMax 1
A segment to provide contacts related to the party.
- 00120Communication contactConditionalMax 9
A segment to provide communication numbers of the contact.
- 00110Contact informationMandatoryMax 1
- 00080Name and addressMandatoryMax 1
- Segment group 3Repeat 99
- 00140Characteristic/class idMandatoryMax 1
A segment to identify a characteristic.
- 00150Characteristic valueConditionalMax 1
A segment to provide the value of the characteristic.
- 00140Characteristic/class idMandatoryMax 1
Detail
- Segment group 4Repeat 99999
- 00170Sequence detailsMandatoryMax 1
A segment giving detailed information on the sequence of the ledger.
- 00180Account identificationConditionalMax 4
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.
- 00190Financial institution informationConditionalMax 1
A segment for the purpose of specifying the bank account numbers relating to the specified account.
- Segment group 5Repeat 99999
- 00210Index detailsMandatoryMax 1
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.
- 00220ReferenceMandatoryMax 1
A segment containing the number of the source document relating to the accounting record.
- 00230Free textMandatoryMax 1
A segment with free text information, in coded or clear form, to give an explanation of the accounting entry.
- Segment group 6Repeat 999
- 00250Line itemMandatoryMax 1
A segment identifying the line item of the accounting entries or records information sequence.
- 00260Account identificationConditionalMax 4
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.
- 00270Accounting journal identificationConditionalMax 1
A segment identifying the source document and the type of accounting records of accounting entries for a given period.
- 00280Date/time/periodConditionalMax 9
A segment giving the accountancy dates concerning the accounting record, date of capture, date of source document, date of accounting validation.
- 00290Free textConditionalMax 1
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.
- 00300Payment instructionsConditionalMax 1
A segment specifying the settlement method of the accounting record.
- 00310ReferenceConditionalMax 9
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.
- 00320QuantityConditionalMax 9
A segment for the purpose of specifying a quantity relating to the monetary amount of the accounting record.
- 00330Duty/tax/fee detailsConditionalMax 9
A segment for specifying the duties, tax or fee types relating to the accounting record.
- 00340Financial institution informationConditionalMax 1
A segment for the purpose of specifying the bank account numbers relating to the specified record.
- 00350CurrenciesConditionalMax 9
A segment containing the currency details, currencies or currency rates used in the record.
- 00360Monetary amountMandatoryMax 9
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.
- Segment group 7Repeat 9
- 00380Characteristic/class idMandatoryMax 1
A segment to identify a characteristic.
- 00390Characteristic valueConditionalMax 1
A segment to provide the value of the characteristic.
- 00380Characteristic/class idMandatoryMax 1
- 00250Line itemMandatoryMax 1
- Segment group 8Repeat 1
- 00410Authentication resultMandatoryMax 1
A segment to provide authentication results.
- 00420Date/time/periodConditionalMax 1
A segment to provide the date of the authentication.
- 00410Authentication resultMandatoryMax 1
- 00210Index detailsMandatoryMax 1
- Segment group 9Repeat 1
- 00440QuantityMandatoryMax 1
A segment indicating the number of accounting entries for a ledger and period.
- 00450ReferenceConditionalMax 1
A segment to provide references related to a ledger or a period.
- 00460Date/time/periodConditionalMax 1
A segment containing the date related to a ledger or a period.
- 00470Monetary amountMandatoryMax 9
A segment adding up the total amounts of the accounting records for a ledger and period in local currency and in foreign currency.
- 00440QuantityMandatoryMax 1
- 00170Sequence detailsMandatoryMax 1
Summary
- 00480Section controlMandatoryMax 1
A service segment used to separate the detail and summary sections.
- Segment group 10Repeat 1
- 00500QuantityMandatoryMax 1
A segment specifying the number of sub-periods included in the period covered by the message.
- 00510ReferenceConditionalMax 1
A segment providing references at message level.
- 00520Date/time/periodConditionalMax 1
A segment containing the date which are relevant at message level for verification purpose.
- 00530Monetary amountMandatoryMax 9
A segment adding up the total amounts relating to the LEDGER message.
- 00500QuantityMandatoryMax 1
- Segment group 11Repeat 1
- 00550Authentication resultMandatoryMax 1
A segment to provide authentication results.
- 00560Date/time/periodConditionalMax 1
A segment to provide the date of the authentication.
- 00550Authentication resultMandatoryMax 1
- 00570Message trailerMandatoryMax 1
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.
1. 0062, the value shall be identical to the value in 0062 in thecorresponding UNH segment.