D14A
Message D14A/LEDGER
Ledger message
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.
Message description
UNH
M(1) : Message headerA 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 14A 0051 UN
BGM
M(1) : Beginning of messageSegment identifying the type of LEDGER message.
DTM
M(99) : Date/time/periodA segment containing the opening and closing dates of the accounting period of the accounting entries and the preparation date of the message.
RFF
C(99) : ReferenceSegment containing the number of the used chart of accounts linked to the message and its version number.
CUX
C(99) : CurrenciesA segment providing currencies which are specific to the LEDGER message.
FTX
C(1) : Free textA segment with free text information, in coded or clear form, for the purpose of providing additional clarification.
SG1 M(99) : NAD-RFF-SG2
SG3 C(99) : CCI-CAV
SG4 M(99999) : SEQ-CPT-FII-SG5-SG9
A group of segments providing information on accounting entries by ledger.
SEQ
M(1) : Sequence detailsA segment giving detailed information on the sequence of the ledger.
CPT
C(4) : Account identificationA 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.
FII
C(1) : Financial institution informationA segment for the purpose of specifying the bank account numbers relating to the specified account.
SG5 M(99999) : IND-RFF-FTX-SG6-SG8
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.
IND
M(1) : Index detailsA 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.
RFF
M(1) : ReferenceA segment containing the number of the source document relating to the accounting record.
FTX
M(1) : Free textA segment with free text information, in coded or clear form, to give an explanation of the accounting entry.
SG6 M(999) : LIN-CPT-RJL-DTM-FTX-PAI-RFF-QTY-TAX-FII-CUX-MOA-SG7
A segment group containing all necessary information for an accounting record.
LIN
M(1) : Line itemA segment identifying the line item of the accounting entries or records information sequence.
CPT
C(4) : Account identificationA 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.
RJL
C(1) : Accounting journal identificationA segment identifying the source document and the type of accounting records of accounting entries for a given period.
DTM
C(9) : Date/time/periodA segment giving the accountancy dates concerning the accounting record, date of capture, date of source document, date of accounting validation.
FTX
C(1) : Free textA 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.
PAI
C(1) : Payment instructionsA segment specifying the settlement method of the accounting record.
RFF
C(9) : ReferenceA 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.
QTY
C(9) : QuantityA segment for the purpose of specifying a quantity relating to the monetary amount of the accounting record.
TAX
C(9) : Duty/tax/fee detailsA segment for specifying the duties, tax or fee types relating to the accounting record.
FII
C(1) : Financial institution informationA segment for the purpose of specifying the bank account numbers relating to the specified record.
CUX
C(9) : CurrenciesA segment containing the currency details, currencies or currency rates used in the record.
MOA
M(9) : Monetary amountA 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.
SG9 M(1) : QTY-RFF-DTM-MOA
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.
QTY
M(1) : QuantityA segment indicating the number of accounting entries for a ledger and period.
RFF
C(1) : ReferenceA segment to provide references related to a ledger or a period.
DTM
C(1) : Date/time/periodA segment containing the date related to a ledger or a period.
MOA
M(9) : Monetary amountA segment adding up the total amounts of the accounting records for a ledger and period in local currency and in foreign currency.
UNS
M(1) : Section controlA service segment used to separate the detail and summary sections.
SG10 M(1) : QTY-RFF-DTM-MOA
A segment group providing quantity and amount totals at message level.
QTY
M(1) : QuantityA segment specifying the number of sub-periods included in the period covered by the message.
RFF
C(1) : ReferenceA segment providing references at message level.
DTM
C(1) : Date/time/periodA segment containing the date which are relevant at message level for verification purpose.
MOA
M(9) : Monetary amountA segment adding up the total amounts relating to the LEDGER message.
SG11 C(1) : AUT-DTM
UNT
M(1) : Message trailerA 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.
Message structure
UNH, Message header M 1 BGM, Beginning of message M 1 DTM, Date/time/period M 99 RFF, Reference C 99 CUX, Currencies C 99 FTX, Free text C 1 --- Segment Group 1 ------------------------- M 99 -------+ NAD, Name and address M 1 | RFF, Reference C 9 | | --- Segment Group 2 ------------------------- C 99 ------+| CTA, Contact information M 1 || COM, Communication contact C 9 || ---- ----------------------------------------------------------++ --- Segment Group 3 ------------------------- C 99 -------+ CCI, Characteristic/class id M 1 | CAV, Characteristic value C 1 | ---- -----------------------------------------------------------+ --- Segment Group 4 ------------------------- M 99999 -------+ SEQ, Sequence details M 1 | CPT, Account identification C 4 | FII, Financial institution information C 1 | | --- Segment Group 5 ------------------------- M 99999 ------+| IND, Index details M 1 || RFF, Reference M 1 || FTX, Free text M 1 || || --- Segment Group 6 ------------------------- M 999 -----+|| LIN, Line item M 1 ||| CPT, Account identification C 4 ||| RJL, Accounting journal identification C 1 ||| DTM, Date/time/period C 9 ||| FTX, Free text C 1 ||| PAI, Payment instructions C 1 ||| RFF, Reference C 9 ||| QTY, Quantity C 9 ||| TAX, Duty/tax/fee details C 9 ||| FII, Financial institution information C 1 ||| CUX, Currencies C 9 ||| MOA, Monetary amount M 9 ||| ||| --- Segment Group 7 ------------------------- C 9 ----+||| CCI, Characteristic/class id M 1 |||| CAV, Characteristic value C 1 |||| ---- --------------------------------------------------------++|| || --- Segment Group 8 ------------------------- C 1 -----+|| AUT, Authentication result M 1 ||| DTM, Date/time/period C 1 ||| ---- ---------------------------------------------------------++| | --- Segment Group 9 ------------------------- M 1 ------+| QTY, Quantity M 1 || RFF, Reference C 1 || DTM, Date/time/period C 1 || MOA, Monetary amount M 9 || ---- ----------------------------------------------------------++ UNS, Section control M 1 --- Segment Group 10 ------------------------ M 1 -------+ QTY, Quantity M 1 | RFF, Reference C 1 | DTM, Date/time/period C 1 | MOA, Monetary amount M 9 | ---- -----------------------------------------------------------+ --- Segment Group 11 ------------------------ C 1 -------+ AUT, Authentication result M 1 | DTM, Date/time/period C 1 | ---- -----------------------------------------------------------+ UNT, Message trailer M 1