Import format of the UGL interface

You can find more information on the UGL interface under http://www.mein-lieber-span.com/mls/download/UGL_0301.pdf

Part 1 - Structure of the UGL file

File name

Axxxxxxx.nnn

A	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 import 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 AN request of the manufacturer BE purchase order (delivery order) of the manufacturer
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	P	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	P	Street
124	126	3	A	K	Country
127	132	6	A	P	Postal code
133	162	30	A	P	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	P	Item number of the manufacturer
14	23	10 (0)	N	U	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	P	Item number of the manufacturer
14	23	10 (0)	N	U	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	K	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	P	Item number of the manufacturer
14	23	10 (0)	N	U	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 Especially for @EDI-Connect it is possible to also transfer additional information here which was not planned in the UGL-interface description. Place 01 - 03: constant '.MA' Place 04 - 16: ILN of the manufacturer according to PRICAT Place 17 - 26 : customer number of the ultimate consumer

Part 4 - Automatic transfer
Registry	The file and program names can be exported from the Registry
Path to the data base	HKEY_CURRENT_USER\Software\VB and VBA Program Settings\EDI-Connect\Database\LocalPath
Name of the data base	HKEY_CURRENT_USER\Software\VB and VBA Program Settings\EDI-Connect\Database\Filename
Path name of the program (available from version 0.9.0)	HKEY_CURRENT_USER\Software\VB and VBA Program Settings\EDI-Connect\Database\Executable
Transfer parameter	The call of @EDI-Connect with the following parameter causes the direct import of an UGL file. edicon.exe ugl-import ugldateiname ugldateiname has to be replaced by the correct name of the UGL-file.