EDI GUIDEFLATFILE DELFORWho should read this document?
This document is for EDI-administrators who will implement these guidelines to be able to send FLATFILE - DELFOR orders to Bosch Rexroth AG.

Explanation of usage:
Each flatfile consists of a header, several line items, per line item several schedule records and a trailer record.
The file can contain more than one schedule. The structure always begins with a header record followed by a line item record, followed by schedule records.
At the end of each file there is a trailer record which contains the number of transmitted lines, excluding the trailer record.

Example with one line item and 3 schedules
header record

Example with 2 line items and 3 schedules eachheader recordof purchase order 1line item record

line item recordschedule recordschedule recordschedule recordschedule recordschedule recordschedule record

trailer record

line item recordschedule recordschedule recordschedule record

trailer record

If you have questions to this guide, send an e-mail to: SupportSales.EDI@de.bosch.com

Header record
No.
123456789101112131415

Description
1. Schedule Header Information
Qualifier "H" for header data
Document number
Document date
Order Number
Sold-to-Party
Ship-to Party
Ship-to address: partner nameShip-to address: street
Ship-to address: zip-code
Ship-to address: city
Ship-to address: country (2-digit ISO-Code)
Place of discharge
Supplier number
Message Type
Carriage Return Line Feed

ExampleH4220070201
551234564788
6032253
6063331
Bosch Rexroth AG
Zum Eisengiesser 1
97816
Lohr am Main
DEW12317000001
DELFOR"CRLF"

Remarkformat yyyymmdd

Start Length End Decimal
12374580
90100135170179
214
216
220
230
240

135835101035359352410101136
44
79
89
99
134
169
178
213
215
219229239
240(R)equired(O)ptional
R
R
R
R
R
O
O
O
O
O
O
O
R
R
R

Data-Type
CHAR
CHAR
CHAR
CHAR
CHAR
CHAR
CHAR
CHAR
CHAR
CHAR
CHAR
CHAR
CHAR
CHAR
CHAR

Line item record
No.

123456789101112131415Description
2. Schedule Line item information
Qualifier "L" for line item data
Material number of customer
Material Description
Material number of supplier
Order Number
Previous delivery schedule
Date of last scheduleDrawing number
Received quantity
Received cumulative quantity
Ordered cumulative quantity
Backorder quantitiy
Despatch note number
Date of last delivery
Carriage Return Line FeedExample

LR900310277
VALVE ......
987654321
551234564788
1025465789
20070117
5A
500.000
2650.000
2700.000
50.000174567892
20070115"CRLF"

Remarkformat YYYYMMDD

number of last delivery
format YYYYMMDDStart Length End Decimal

1
22060
78
113
148
156
161
176
191
206
221
256
264

1
1840
1835358
51515151535
8
1

11959
77
112
147
155
160
175
190
205
220255263
264(R)equired(O)ptional

RR
R
O
RO
O
O
3 O
3 R
3 O
3 O
O
O
R

Data-Type

CHAR
CHAR
CHAR
CHAR
CHAR
CHAR
CHAR
CHAR
CHAR
CHAR
CHAR
CHAR
CHAR
CHAR
CHAR

Schedule record
No.

123
4
567

Description
3. Schedule delivery information
Qualifier "D" for delivery information
Scheduling conditions
Order Quantity
Unit of Measure
Delivery date*
Date format
Carriage Return Line Feed
* date formats to be used:

ExampleD
12.000PCE
20070227
D"CRLF"D = yyyymmdd
W = yyyyww
M = yyyymm

Remark1 = fix, 4 = forecast, 10 = immediately

format corresponding to field 6
D = day, W = week, M = monthe.g. 20070227
e.g. 200709
e.g. 200702

Start Length End Decimal

124192230
38

1215
388113182129
3738(R)equired(O)ptional

RR
3 RRR
RR

Data-Type

CHAR
CHAR
CHAR
CHAR
CHAR
CHARCHAR

Trailer record
No.
12
3Description
4. Trailer record (for checking purposes)
Qualifier "T" for Trailer
Number of lines transmitted, excluding the trailer record
Carriage Return Line Feed
> all fields left assigned!
> decimal separator is marked by a dot "."> no "thousand separator" (9500.00 is correct!)ExampleRemarkT2"CRLF"Start Length End Decimal
112

1
1
1

1
1
2

(R)equired(O)ptional
RRR

Data-Type
CHAR
CHAR
CHAR