Remadv
Remadv
Remadv
0. INTRODUCTION 2
1. BACKGROUND INFORMATION 3
1.1 General information 3
2. DATA MODEL 4
2.1 Data Model Format 4
2.2 Data Model Diagram 5
2.3 Data Model Entities 7
2.4 Data Model Relationships 8
2.5 Data Model Attributes 9
3. SCOPE 12
3.1 Functional Definition 12
3.2 Field of Application 12
3.3 Principles 12
3.4 Message Usage 12
4. MESSAGE DEFINITION 13
4.1 Message Structure 13
4.2 Mapping of the Data Model to the Message 14
4.3 Branching Diagram of the Segments used by Eurofer 19
4.4 General Description of the Message - Subset of Eurofer 23
4.5 Detailed Description of the Message - Subset of Eurofer 27
1
UN/EDIFACT D97.A REMADV - Remittance Advice message
0. INTRODUCTION
This document provides the definition of the EUROFER subset of the REMITTANCE
ADVICE message based on the UN standard REMADV message of the UN/EDIFACT
directory D97A.
This message has been created by the EDIFER "Message development" working group. The
message is to be used in Electronic Data Interchange (EDI) between partners involved in the
steel industry.
- A Data Model definition describes the data entities, attributes and their relationships.
- The scope describes the field of application, principles and message usage.
- The message definition covers the structure, the entity/attribute mapping and how the
data described in the data model relates to the message.
- The message definition outlines the general structure of the message and specifies the
use of each segment group and, or segment.
- Based on the branching diagram of the original EDIFACT message REMADV, the
segments used are indicated. This is followed by a detailed description of the segments
used by Eurofer.
2
UN/EDIFACT D97.A REMADV - Remittance Advice message
1. BACKGROUND INFORMATION
The following principles are valid for the Remittance advice message;
- A Remittance advice may cover one or more commercial trade transactions, such as
invoices, credit notes, debit notes, etc
- A Remittance advice may include a cross reference to a payment order given to the
bank.
- Each Remittance advice shall be calculated in only one currency, even though the
related transaction is denominated in different currencies.
The Eurofer subset of the Remittance advice message has been developed under the
following assumptions;
- a payer (customer) informs the payee (supplier) about the payment details
- the payment may cover more than one financial transaction, such as invoices, debit
notes, credit note, etc
3
UN/EDIFACT D97.A REMADV - Remittance Advice message
2. DATA MODEL
To simplify the understanding of the data model, the model is defined at a summary level,
specifying when necessary a group of data elements instead of each data element.
The data model consists of data entities, the relationships between those data entities and the
attributes (data elements) in each data entity.
An entity specifies an object against which information is held; it has a name, a description
and attributes.
The relationships of the data entities within the data model are reflected in the structure of
the diagram in chapter 2.2.
4
UN/EDIFACT D97.A REMADV - Remittance Advice message
1
Remittance advice
Contains
1
Payment Relates to
1,N
Accounting
document
Has
0,N
Adjustment
Reference to Reference to
Company Message /
Document
5
UN/EDIFACT D97.A REMADV - Remittance Advice message
In this diagram, the rectangles represent data entities and the ovals show us the relationship
between two data entities. How often a relationship can exist between two data entities is
given in both directions and is specified as 0, 1, N.
- 0 means that there is no relationship between the entities.
- 1 means that there is one and only one relationship between the entities.
- N means that there are many relationships between the entities.
- 0,1 means that there can be no or one relationship between the entities.
- 1,N means that there can be one or many relationships between the entities.
- 0,N means that there can be no or many (one or more) relationships between the
entities.
6
UN/EDIFACT D97.A REMADV - Remittance Advice message
The entities are regrouped in two groups. The first group includes all the basic data entities
and the second the related data entities.
The following entities are contained within the data model.
REMITTANCE ADVICE
PAYMENT
ACCOUNTING DOCUMENT
ADJUSTMENT
COMPANY
MESSAGE/DOCUMENT
PAYMENT This entity specifies the details of the payment, such as the payment
channel, payment date, payment currency, the bank account numbers
and the payment amounts
ACCOUNTING This entity gives the details of the commercial trade transactions
DOCUMENT covered by the Remittance advice message. This entity specifies the
document number, document date, the amount due, amount remitted,
and payment references.
ADJUSTMENT This entity gives the justification of the difference between the
amount due and the amount remitted of a commercial trade
transaction.
MESSAGE & This entity contains all the references to another message or
DOCUMENT document. For example invoice, credit note, order, despatch advice.
7
UN/EDIFACT D97.A REMADV - Remittance Advice message
8
UN/EDIFACT D97.A REMADV - Remittance Advice message
ENTITY : PAYMENT
payment means
Indication of the instrument of payment, which may include a guarantee, e.g. cash,
check, payment to bank account.
payment date
Date on which an amount due is made available to the creditor, in accordance with the
terms of payment.
payment currency
The monetary unit in which payment is made, or is to be made.
payment amount
Actual amount paid, or to be paid.
9
UN/EDIFACT D97.A REMADV - Remittance Advice message
amount remitted
Amount remitted in the accounting document.
ENTITY : ADJUSTMENT
adjustment reason
Indication of the reason for adjustment.
adjustment description
Explanation of the motive for the adjustment.
adjustment amount
Amount of the adjustment.
adjustment reference
Indication of the reference justifying the adjustment.
10
UN/EDIFACT D97.A REMADV - Remittance Advice message
ENTITY : COMPANY
11
UN/EDIFACT D97.A REMADV - Remittance Advice message
3. SCOPE
3.3. Principles
This Eurofer Remittance advice message has been created as a subset of the UNSM
REMADV message of EDIFACT. The message is initiated when the payer (customer)
makes a payment to the payee, allowing the payee to reconcile the financial transactions and
to identify the outstanding amounts. A Remittance advice may cover one or more
commercial trade transactions (and related financial transactions), such as invoices, credit
notes, debit notes, etc.
Each Remittance advice shall be calculated in only one currency, even though the related
transaction is calculated in different currencies.
12
UN/EDIFACT D97.A REMADV - Remittance Advice message
4. MESSAGE DEFINITION
The heading section is used to give the general information relating to the whole message.
Examples of this kind of information are remittance advice number, date of remittance
advice, parties involved, identification of the financial institutions and account numbers, and
when relevant the currencies and the rate of exchange.
The heading section can also be used to give information which has the same content for
each line in the detail section. Examples of this kind of information are references valid for
all detail items specified in the detail section.
The detail section can be used to identify the reference documents against which payment is
being made, to give the monetary amounts for the amount due and the amount to be
remitted.
This sections allows also to specify the currencies, rate of exchange and related date/period
valid for the referenced document, where different to the remittance, and if necessary to
indicate the adjustment reason(s), amounts(s), the referenced documents and the description
or the adjustment.
The summary section can be used to give the total amount of payment to be made or other
total amounts.
13
UN/EDIFACT D97.A REMADV - Remittance Advice message
In the following table a short overview is given about the meaning and the functionality of
the segment groups and segments in the message. The information given covers :
- the segment group
- the segment
- the description of the meaning and the functionality
- the comments of the EDIFER working group
HEADING SECTION
14
UN/EDIFACT D97.A REMADV - Remittance Advice message
DETAIL SECTION
15
UN/EDIFACT D97.A REMADV - Remittance Advice message
SUMMARY SECTION
16
UN/EDIFACT D97.A REMADV - Remittance Advice message
The mapping is done starting from the entities, relationships and attributes of the data model
to the EDIFACT message.
This mapping is presented as a table containing the entities of the following information ;
- the attributes
- the segment group number
- the segment by its tag
- the Edifact data element
- remarks about the usage.
Entity : PAYMENT
Payment means PAI 4461
Payment date DTM 2380 DTM segment in the header,
following BGM.
Payment currency Group 3 CUX 6345
Payment amount MOA 5025 MOA segment in the summary
section.
Payment order number RFF 1154 Use the code PQ in element
1153.
Payers (customers) financial FII C088 Use code PB in element 3035.
institution
Payers (customers) financial FII 3194
institution account number
Payees (suppliers) financial FII C088 Use code RB in element 3035.
institution
Payees (suppliers) financial FII 3194
institution account number
Entity : ACCOUNTING
DOCUMENT
Message / document type Group 4 DOC 1001
Message / document number Group 4 DOC 1004
Message / document date Group 4 DTM 2380
Invoice (credit- , debit note) currency Group 4 MOA 6345
or
Group 5 CUX 6345
Invoice (credit-, debit note) amount Group 4 MOA 5004 Use the code 77 in element
(amount due) 5025.
Amount remitted Group 4 MOA 5004 Use the code 139 in element
5025.
Payers (customers) payment Group 4 RFF 1154 Use code AHK in element 3035.
reference number
Invoicing party payment reference Group 4 RFF 1154 Use code AHJ in element 3035.
number
17
UN/EDIFACT D97.A REMADV - Remittance Advice message
Entity : ADJUSTMENT
Adjustment reason Group 6 AJT 4465
Adjustment description Group 6 FTX C108
Adjustment amount Group 6 MOA 5004 Use the code 109 in element
5025.
Adjustment reference Group 6 RFF 1154 Use the relevant code in element
1153.
Entity : COMPANY
Company code, name and address Group 1 NAD 1154 Use the relevant code for 1153.
Contact information Group 2 CTA C056 Use the relevant code for 3139.
Communication contact Group 2 COM C076
18
UN/EDIFACT D97.A REMADV - Remittance Advice message
The codes used for the usage indicator (USG. IND.) for the segments.
R for REQUIRED - Should always be used in the message
O for OPTIONAL - May be used by trading partners if required.
X for EXCLUDED - Not used in the message.
The codes used for the status of the segments according to EDIFACT:
M for MANDATORY
C for CONDITIONAL
Heading Section
USG.IND. PAGE NUM. TAG NAME STATUS REPEATS GROUP REPEATS
19
UN/EDIFACT D97.A REMADV - Remittance Advice message
Detail Section
USG.IND. PAGE NUM. TAG NAME STATUS REPEATS GROUP REPEATS
Summary Section
USG.IND. PAGE NUM. TAG NAME STATUS REPEATS GROUP REPEATS
20
UN/EDIFACT D97.A REMADV - Remittance Advice message
EUROFER REMADV REMITTANCE ADVICE MESSAGE VERSION - DECEMBER 1999 UN/EDIFACT DIRECTORY : D97.A
Level
UN BGM UNS UN
00 H T
M 1 M M M
1 1 1
G01 G03
C 99 C 5
01
DTM RFF FII PAI FTX NA CUX MOA
D See page 2
M 5 C 5 C 5 C 1 C 5 M 1 M 1 M 9
G02
C 5
02
CTA
M 1
03
COM
C 5
Branching Page
Diagram 1
EUROFER REMADV REMITTANCE ADVICE MESSAGE VERSION - DECEMBER 1999 UN/EDIFACT DIRECTORY : D97.A
Leve
l
G04
See page
1 C 9999
01
DOC
M 1
G05 G06
C 5 C 100
02
RFF CUX AJT
MOA DTM
M C C 5 M 1 M 1
5 5
03
MOA
RFF FTX
C C 1 C 5
1
04
21
UN/EDIFACT D97.A REMADV - Remittance Advice message
This section is provided to give clarification and further explanation to the usage of the
segments within the message defined by Eurofer. The message consists of three sections, a
heading section, a detail section and a summary section.
The heading section is representing the payment details, the corresponding references and
the parties involved. Detail information which applies or relates to all line items of the detail
section can also be given in the heading section.
This section should be read in conjunction with the segment usage and the branching
diagram (chapter 3.3.) which indicates the required (R) and optional (O) segments and
segment groups.
The following guidelines and principles apply to the whole message of Eurofer and are
intended to facilitate the understanding and the implementation of the message.
All the specified data/times (segment DTM) should be in the format 'CCYYMMDD'/'hhmm'
unless all parties involved in the transaction agree that there is a functional requirement for
an alternative format.
Periods should be specified as whole numbers representing the required period as indicated
in the format qualifier (weeks, month, etc)
Where a choice of code or text is given, only the code element should be used if possible.
Optional (conditional) data that are not required in the message should not be included.
Care must be taken that the segment qualifier in dependent segments do not conflict with the
segment qualifier of the trigger segment of the group.
22
UN/EDIFACT D97.A REMADV - Remittance Advice message
23
UN/EDIFACT D97.A REMADV - Remittance Advice message
24
UN/EDIFACT D97.A REMADV - Remittance Advice message
25
UN/EDIFACT D97.A REMADV - Remittance Advice message
26
UN/EDIFACT D97.A REMADV - Remittance Advice message
This section is provided to give detailed clarification and a further explanation to the usage
of the data elements in the segments of the Remittance advice message defined in the subset
of Eurofer. The message consists of three sections, a heading section, a detail section and a
summary section.
The section 4.5.2. describes each segment used in the heading section of the Eurofer
Remittance advice message. The section 4.5.3. describes each segment used in the detail
section of the Eurofer Remittance advice message. The section 4.5.4. describes each
segment used in the summary section of the Eurofer Remittance advice message.
The original EDIFACT segment layout is listed. The appropriate comments relevant to the
Eurofer subset are indicated.
The segments are presented in the sequence in which they appear in the message. The
segment and the segment group tag is followed by Mandatory or Conditional indicator, the
maximum number of occurrences and the segment description.
Reading from left to right, in column one the usage indicator is for the use of the EDIFACT
data elements in the Eurofer subset.
In the other columns the information is given about the data element tag, data element name,
followed by the EDIFACT status and the format.
The codes used for the usage indicator (USG. IND.) for the data elements are,
R for REQUIRED - Should always be used in the message
O for OPTIONAL - May be used by trading partners if required.
X for EXCLUDED - Not used in the message.
27
UN/EDIFACT D97.A REMADV - Remittance Advice message
GROUP :
SEGMENT :
UNH MESSAGE HEADER
SEGMENT STATUS :
Mandatory 1
FUNCTION :
To head, identify and specify a message
NOTES :
This segment would normally be added as part of the translation process. It has been
included for completeness.
28
UN/EDIFACT D97.A REMADV - Remittance Advice message
GROUP :
SEGMENT :
BGM BEGINNING OF MESSAGE
SEGMENT STATUS :
Mandatory segment repeat : 1
FUNCTION :
To indicate the type and function of a message and to transmit the identifying number.
NOTES :
29
UN/EDIFACT D97.A REMADV - Remittance Advice message
GROUP :
SEGMENT :
DTM DATE / TIME / PERIOD
SEGMENT STATUS :
Mandatory segment repeat : 5
FUNCTION :
To specify date, and/or time, period.
NOTES :
All specified dates/times should be in the format 'CCYYMMDD'/'hhmm' unless all
parties involved in the transaction agree that there is a functional requirement for an
alternative format.
R C507 DATE/TIME/PERIOD M
R 2005 Date/time/period qualifier M an..3
137 Document/message date/time
138 Payment date
See code list EDIFACT for other values
R 2380 Date/time/period C an..35
R 2379 Date/time/period format qualifier C an..3
102 CCYYMMDD
203 CCYYMMDDhhmm
See code list EDIFACT for other values
30
UN/EDIFACT D97.A REMADV - Remittance Advice message
GROUP :
SEGMENT :
RFF REFERENCE
SEGMENT STATUS :
Conditional segment repeat : 5
FUNCTION :
To specify a reference.
NOTES :
This segment is used for referencing documents, relating to the whole message or to
all the received items specified in the detail section.
The documents paying for must be given in the segment group 4, triggered by the
segment DOC.
R C506 REFERENCE M
R 1153 Reference qualifier M an..3
AEK Payment order number
PQ Payment reference
See code list EDIFACT for other codes
R 1154 Reference number C an..35
X 1156 Line number C an..6
X 4000 Reference version number C an..35
31
UN/EDIFACT D97.A REMADV - Remittance Advice message
GROUP :
SEGMENT :
FII FINANCIAL INSTITUTION INFORMATION
SEGMENT STATUS :
Conditional segment repeat : 5
FUNCTION :
To identify an account and a related financial institution.
NOTES :
32
UN/EDIFACT D97.A REMADV - Remittance Advice message
GROUP :
SEGMENT :
PAI PAYMENT INSTRUCTIONS
SEGMENT STATUS :
Conditional segment repeat : 1
FUNCTION :
To specify the instructions for payment.
NOTES :
33
UN/EDIFACT D97.A REMADV - Remittance Advice message
GROUP :
SEGMENT :
FTX FREE TEXT
SEGMENT STATUS :
Conditional segment repeat : 5
FUNCTION :
To provide free from or coded text information.
NOTES :
34
UN/EDIFACT D97.A REMADV - Remittance Advice message
GROUP :
Group 01 : NAD SG2 SG3
Conditional group repeat : 99
SEGMENT :
NAD NAME AND ADDRESS
SEGMENT STATUS :
Mandatory segment repeat : 1
To specify the name/address and their related function, either by C082 only and/or
unstructured by C058 or structured by C080 thru 3207.
NOTES :
This segment is used for identifying the parties relevant for the whole message.
Party details can be given in coded form or clear text. We recommend the use of
coded form, using C082. The basis of this codification could be one of the national or
international code lists. Examples of such code lists are VAT-registration number,
Chamber of commerce, Wirtschaftsvereinigung, Odette, EAN, etc.
35
UN/EDIFACT D97.A REMADV - Remittance Advice message
O C059 STREET C
R 3042 Street and number/P.O. Box M an..35
O 3042 Street and number/P.O. Box C an..35
O 3042 Street and number/P.O. Box C an..35
O 3042 Street and number/P.O. Box C an..35
36
UN/EDIFACT D97.A REMADV - Remittance Advice message
GROUP :
Group 02: CTA - COM
Conditional group repeat : 5
SEGMENT :
CTA CONTACT INFORMATION
SEGMENT STATUS :
Mandatory segment repeat : 1
FUNCTION :
To identify a person or a department to whom communication should be directed..
NOTES :
37
UN/EDIFACT D97.A REMADV - Remittance Advice message
GROUP :
Group 02: CTA - COM
Conditional group repeat : 5
SEGMENT :
COM COMMUNICATION CONTACT
SEGMENT STATUS :
Conditional segment repeat : 5
FUNCTION :
To identify a communication number of a department or a person to whom
communication should be directed.
NOTES :
38
UN/EDIFACT D97.A REMADV - Remittance Advice message
GROUP :
Group 03: CUX- DTM
Conditional group repeat : 5
SEGMENT :
CUX CURRENCIES
SEGMENT STATUS :
Mandatory segment repeat : 1
FUNCTION :
To specify currencies used in the transaction and relevant details for the
rate of exchange.
NOTES :
If the payment currency is different from the invoicing currency the segment CUX is
used to give the rate of exchange. This can be done by giving in the first occurrence
of the composite C504 the reference currency (invoicing currency), the second
occurrence of the composite C504 is used as target currency (payment currency) and
the rate of exchange can be specified in the data element 5402.
39
UN/EDIFACT D97.A REMADV - Remittance Advice message
40
UN/EDIFACT D97.A REMADV - Remittance Advice message
GROUP :
Group 04: DOC- MOA DTM RFF NAD SG5 SG6 SG7 SG8
Conditional group repeat : 9999
SEGMENT :
MOA MONETARY AMOUNT
SEGMENT STATUS :
Mandatory segment repeat : 5
FUNCTION :
To specify a monetary amount.
NOTES :
41
UN/EDIFACT D97.A REMADV - Remittance Advice message
GROUP :
Group 04: DOC- MOA DTM RFF NAD SG5 SG6 SG7 SG8
Conditional group repeat : 9999
SEGMENT :
DTM DATE / TIME / PERIOD
SEGMENT STATUS :
Conditional segment repeat : 5
FUNCTION :
To specify date, and/or time, period.
NOTES :
All specified dates/times should be in the format 'CCYYMMDD'/'hhmm' unless all
parties involved in the transaction agree that there is a functional requirement for an
alternative format.
R C507 DATE/TIME/PERIOD M
R 2005 Date/time/period qualifier M an..3
137 Document/message date/time
See code list EDIFACT for other values
R 2380 Date/time/period C an..35
R 2379 Date/time/period format qualifier C an..3
102 CCYYMMDD
203 CCYYMMDDhhmm
See code list EDIFACT for other values
42
UN/EDIFACT D97.A REMADV - Remittance Advice message
GROUP :
Group 04: DOC- MOA DTM RFF NAD SG5 SG6 SG7 SG8
Conditional group repeat : 9999
SEGMENT :
RFF REFERENCE
SEGMENT STATUS :
Conditional segment repeat : 5
FUNCTION :
To specify a reference.
NOTES :
This segment is used for referencing documents, relating to the referenced document
in the segment DOC.
R C506 REFERENCE M
R 1153 Reference qualifier M an..3
AHJ Payees reference number
AHK Payers reference number
CT Contract number
CO Buyers order number
See code list EDIFACT for other codes
R 1154 Reference number C an..35
X 1156 Line number C an..6
X 4000 Reference version number C an..35
43
UN/EDIFACT D97.A REMADV - Remittance Advice message
GROUP :
Group 05: CUX- DTM
Conditional group repeat : 5
SEGMENT :
CUX CURRENCIES
SEGMENT STATUS :
Mandatory segment repeat : 1
FUNCTION :
To specify currencies used in the transaction and relevant details for the
rate of exchange.
NOTES :
If the payment currency is different from the invoicing currency the segment CUX is
used to give the rate of exchange. This can be done by giving in the first occurrence
of the composite C504 the reference currency (invoicing currency), the second
occurrence of the composite C504 is used as target currency (payment currency) and
the rate of exchange can be specified in the data element 5402.
44
UN/EDIFACT D97.A REMADV - Remittance Advice message
GROUP :
Group 06: AJT- MOA RFF FTX
Conditional group repeat : 100
SEGMENT :
AJT ADJUSTMENT DETAILS
SEGMENT STATUS :
Mandatory segment repeat : 1
FUNCTION :
To identify the reason for an adjustment.
NOTES :
45
UN/EDIFACT D97.A REMADV - Remittance Advice message
GROUP :
Group 06: AJT- MOA RFF FTX
Conditional group repeat : 100
SEGMENT :
MOA MONETARY AMOUNT
SEGMENT STATUS :
Conditional segment repeat : 1
FUNCTION :
To specify a monetary amount.
NOTES :
46
UN/EDIFACT D97.A REMADV - Remittance Advice message
GROUP :
Group 06: AJT- MOA RFF FTX
Conditional group repeat : 100
SEGMENT :
RFF REFERENCE
SEGMENT STATUS :
Conditional segment repeat : 1
FUNCTION :
To specify a reference.
NOTES :
This segment is used for a referencing document, relating to the adjustment of the
referenced document.
R C506 REFERENCE M
R 1153 Reference qualifier M an..3
CT Contract number
DQ Delivery note number
PL Price list number
See code list EDIFACT for other codes
R 1154 Reference number C an..35
X 1156 Line number C an..6
X 4000 Reference version number C an..35
47
UN/EDIFACT D97.A REMADV - Remittance Advice message
GROUP :
Group 06: AJT- MOA RFF FTX
Conditional group repeat : 100
SEGMENT :
FTX FREE TEXT
SEGMENT STATUS :
Conditional segment repeat : 5
FUNCTION :
To provide free from or coded text information.
NOTES :
48
UN/EDIFACT D97.A REMADV - Remittance Advice message
GROUP :
SEGMENT :
UNS SECTION CONTROL
SEGMENT STATUS :
Mandatory segment repeat : 1
FUNCTION :
Service segment to separate Header, Detail and Summary sections of a message.
NOTES :
This segment would normally be added as part of the translation process. It has been
included for completeness.
49
UN/EDIFACT D97.A REMADV - Remittance Advice message
GROUP :
SEGMENT :
MOA MONETARY AMOUNT
SEGMENT STATUS :
Mandatory segment repeat : 9
FUNCTION :
To specify a monetary amount.
NOTES :
50
UN/EDIFACT D97.A REMADV - Remittance Advice message
GROUP :
SEGMENT :
UNT MESSAGE TRAILER
SEGMENT STATUS :
Mandatory 1
FUNCTION :
Service segment ending a message, giving the totals number of segments.
NOTES :
This segment would normally be added as part of the translation process. It has been
included for completeness.
51
UN/EDIFACT D97.A REMADV - Remittance Advice message
All information provided in this documentation is provided as is without any warranties of any
kind including warranties of accuracy, fitness for a particular purpose, or non-infringement or
intellectual property.
EUROFER shall not be held responsible for any errors or any loss resulting from any use of this
document or the specification herein.
The materials contained in this document may be copied provided that ALL copies retain the
copyright and any other proprietary notices contained on the materials. No material may be
modified, edited or taken out of context such as its use creates a false or misleading statement or
impression as to the positions, statements or actions of the publisher.
52