Part 1 - Structure of the UGL file
|
|
File name
|
Bxxxxxxx.nnn
|
B
|
Constant
|
|
xxxxxxx
|
Date with format YYYMMDD
YYY 000 = 2000, 001 = 2001
DD = Day
MM = Month
Example: 23.03.2004 = 0040323
|
|
nnn
|
Serial file number. Once you reach number 999 it starts
again with 001. Daily restart of numbering
|
|
|
File folder
|
The file is always put into the export directory of the
EDI-Connect folder.
|
|
Character set
|
ISO-8859-15 or ISO8859-1
|
|
Record length
|
Fixed record length of 200 characters plus CR and LF
(total of 202). EDI-Connect also accepts shorter
record lengths as it always reads until the end of the line.
|
|
Permissible field types
|
Alphanumerical and numerical
|
|
Alphanumerical fields
|
The transfer is made left-justified with padded blank
characters. All characters are permitted
|
|
Numerical fields
|
Right-justified with leading zeros. Only figures between 0
and 9 are allowed. Attention should be paid to the number of decimal places,
as commas and points are not allowed.
Example:
Numerical 11 digits, 2 decimal places
Value: 123,45
Representation: 00000012345
|
Part 2 - Permissible record types
|
|
KOP
|
Header data (required)
|
|
ADR
|
Different address data (optional)
|
|
POT
|
Item texts (optional)
|
|
POA
|
Item data articles (required record)
|
|
POZ
|
Item data cut (required if POA has been marked as cut)
|
|
END
|
End record (required)
|
|
Order and number of record types
|
|
Header area
|
KOP (1) - ADR (0-1) - There may only be 1 header area per
file
|
|
Article area
|
POT (0-1) - POA (1) - POZ (0-1) - The sequence can be
repeated as often as desired.
|
|
Footer area
|
END (1) - There may only be 1 footer area per file
|
Part 3 - Description of the record types
|
|
Legend
|
P = required entry field
K = optional entry field
U = not supported
A = alphanumerical
N = numerical
L = length (with numerical values followed by the number of decimal places in
brackets)
|
|
|
|
KOP
|
Header line
|
|
From
|
To
|
Length
|
Type
|
Required
|
Description
|
|
1
|
3
|
3
|
A
|
P
|
KOP constant indicator header data
|
|
4
|
13
|
10
|
A
|
P
|
Customer number of the manufacturer with the vendor
|
|
14
|
23
|
10
|
A
|
K
|
Vendor number of the supplier with the manufacturer
|
|
24
|
25
|
2
|
A
|
P
|
Request type
PA price quotation of the vendor
AB order response of the vendor
|
|
26
|
40
|
15
|
A
|
P
|
Request number of the manufacturer
|
|
41
|
90
|
50
|
A
|
K
|
Sales order text
|
|
91
|
105
|
15
|
A
|
K
|
Transaction number of the wholesaler. If the
manufacturer sends a purchase order as a response to a quotation, the
transaction number of the quotation can be transferred here.
|
|
106
|
113
|
8 (0)
|
N
|
K
|
Desired delivery date in the form of YYYYMMDD (e.g.
23.04.2004 = 20040423)
|
|
114
|
116
|
3
|
A
|
K
|
Currency indicator (empty = EUR)
|
|
117
|
121
|
5
|
A
|
P
|
Version indicator (current 03.01)
|
|
122
|
161
|
40
|
A
|
K
|
Name of the person responsible of the manufacturer
|
|
162
|
162
|
1
|
A
|
K
|
J = cut indicator. POZ records are only allowed if this
indicator is set
|
|
|
|
|
ADR
|
Different address data
|
|
From
|
To
|
Length
|
Type
|
Required
|
Description
|
|
1
|
3
|
3
|
A
|
P
|
ADR constant indicator address data
|
|
4
|
33
|
30
|
A
|
K
|
Name 1
|
|
34
|
63
|
30
|
A
|
K
|
Name 2
|
|
64
|
93
|
30
|
A
|
U
|
Name 3 (is not forwarded in
@EDI-Connect)
|
|
94
|
123
|
30
|
A
|
K
|
Street
|
|
124
|
126
|
3
|
A
|
K
|
Country
|
|
127
|
132
|
6
|
A
|
K
|
Postal code
|
|
133
|
162
|
30
|
A
|
K
|
City
|
|
|
|
|
POT
|
Item texts
|
|
From
|
To
|
Length
|
Type
|
Required
|
Description
|
|
1
|
3
|
3
|
A
|
P
|
POT constant indicator item texts
|
|
4
|
13
|
10 (0)
|
N
|
K
|
Item number of the manufacturer
|
|
14
|
23
|
10 (0)
|
N
|
P
|
Item number of the wholesaler
|
|
24
|
63
|
40
|
A
|
K
|
Info text 1
|
|
64
|
103
|
40
|
A
|
K
|
Info text 2
|
|
104
|
143
|
40
|
A
|
K
|
Info text 3
|
|
144
|
161
|
18
|
A
|
K
|
Number of service specifications
|
|
|
|
|
POA
|
Item data articles
|
|
From
|
To
|
Length
|
Type
|
Required
|
Description
|
|
1
|
3
|
3
|
A
|
P
|
POA constant indicator article item
|
|
4
|
13
|
10 (0)
|
N
|
K
|
Item number of the manufacturer
|
|
14
|
23
|
10 (0)
|
N
|
P
|
Item number of the wholesaler
|
|
24
|
38
|
15
|
A
|
P
|
Article number
|
|
39
|
49
|
11 (3)
|
N
|
P
|
Order/demand quantity
|
|
50
|
89
|
40
|
A
|
K
|
Article description 1
|
|
90
|
129
|
40
|
A
|
K
|
Article description 2
|
|
130
|
140
|
11 (2)
|
N
|
K
|
Gross unit price
|
|
141
|
141
|
1
|
A
|
P
|
Price unit
0 = per 1 quantity unit
1 = per 10 quantity units
2 = per 100 quantity units
3 = per 1000 quantity units
|
|
142
|
152
|
11 (2)
|
N
|
K
|
Net item value
|
|
153
|
157
|
5 (2)
|
N
|
K
|
Discount 1
|
|
158
|
162
|
5 (2)
|
N
|
K
|
Discount 2
|
|
163
|
180
|
18
|
A
|
K
|
Number of service specifications (title and item are
separated by a point)
|
|
181
|
181
|
1
|
A
|
K
|
Indicator alternative item - A = alternative
|
|
182
|
182
|
1
|
A
|
U
|
Item category
|
|
183
|
183
|
1
|
A
|
U
|
Internally reserved
|
|
184
|
186
|
3
|
A
|
K
|
Quantity unit
|
|
187
|
190
|
3
|
A
|
U
|
Distributor indicator (HKZ) acc. to UGS interface
|
|
191
|
191
|
1
|
A
|
K
|
J = cut data for this item available. A POZ record is
then also required.
|
|
|
|
|
POZ
|
Cut data
|
|
From
|
To
|
Length
|
Type
|
Required
|
Description
|
|
1
|
3
|
3
|
A
|
P
|
POZ constant indicator article cut data
|
|
4
|
13
|
10 (0)
|
N
|
K
|
Item number of the manufacturer
|
|
14
|
23
|
10 (0)
|
N
|
P
|
Item number of the wholesaler
|
|
24
|
27
|
4 (0)
|
N
|
K
|
Height in mm
|
|
28
|
31
|
4 (0)
|
N
|
K
|
Width in mm
|
|
32
|
35
|
4 (0)
|
N
|
K
|
Thickness in mm
|
|
|
|
|
END
|
End record
|
|
From
|
To
|
Length
|
Type
|
Required
|
Description
|
|
1
|
3
|
3
|
A
|
P
|
END constant indicator end record
|
|
4
|
43
|
40
|
A
|
K
|
Additional text 1
|
|
44
|
83
|
40
|
A
|
K
|
Additional text 2
|
|
84
|
123
|
40
|
A
|
K
|
Additional text 3
|
|
124
|
163
|
40
|
A
|
K
|
Additional text 4
|
|
