GEDI Message Lines
"'GEDI Message Lines', holds the information that is contained within a 'GEDI Message'"
Last updated
"'GEDI Message Lines', holds the information that is contained within a 'GEDI Message'"
Last updated
In the 'GEDI Message Line' page view in Business Central you will find 'GEDI Message Lines'. 'GEDI Message Lines', holds the information that is contained within a 'GEDI Message'. The information is structured by 'GEDI Class name' and 'GEDI Property name'.
'GEDI Class names' correspond to a Message Document type, for example 'ORDER' or 'INVOICE' etc.
'GEDI Property names' correspond to a field or 'tag' as it's often called in EDI, for example 'OrderNumber' or 'InvoiceNumber'
'GEDI Mappings' can import or export information to 'GEDI Message Lines'.
The CIP reads or writes information to 'GEDI Message Lines'.
Each 'GEDI Message Line' and each corresponding 'GEDI Property name' has a specific value type. This makes sure that information is always imported and exported correctly. Each value type has it's own column in the 'GEDI Message Line' table. The value types are;
Text value - "Customer Name"
Code value - "PIECE"
Integer value - "100"
Decimal value - "100,00"
Date value - "2021-10-29"
Time value - "10:15:00"
DateTime value - "2021-10-29 10:15"
Boolean value - Checkbox for "TRUE" or "FALSE"
Big integer value - "12147483647"
The value type defined in the 'GEDI Mapping' shall correspond to the value type of the 'GEDI Property name', or the data won't be correctly transferred.
'GEDI Message Lines', 'GEDI Class names' and 'GEDI Property name' all have a corresponding level. Levels allow for different 'GEDI Class names' to together build up one 'Message Document Type'. The level can be found in a field in the 'GEDI Message Line'
For example, 'Message Document Type' 'Order' consists of two levels and 'GEDI Class names':
Level 1: 'ORDER' 'GEDI Class name', corresponds to the order header.
Level 2: 'ORDERLINE' 'GEDI Class name', corresponds to the order lines.
Some 'Message Document Types' and 'GEDI Class names' may have repeatable levels. To structure this information there is a field 'Level Line No' on each 'GEDI Message Line'.
For example, many 'ORDERLINE' 'GEDI Class names' can be contained in the same Order.
First 'ORDERLINE' section has 'Level'=2, and 'Level Line No'=1
Second 'ORDERLINE' section also has 'Level'=2, but 'Level Line No'=2
etc for each additional line.
Some 'Message Document Types' are more complex than others. For example, the Despatch Advice has three levels and 'GEDI Class names'. The Despatch Advice header can hold multiple containers and each container can hold multiple order lines.
Level 1: DESPATCHADVICE - Despatch Advice header information
Level 2: DESPATCHADVICELOGISTICUNIT - Despatch Advice container information
Level 3: DESPATCHADVICELOGISTICUNITLINE - Despatch Advice article line information
