Organisation Unit Address (File Layout)

Detail record

	Field Name	Field Size	ATTR	O/M	Start	End	Description / Value
1	File indicator	4	Char	M	1	4	AB89
2	Org_Unit_Code	8	Char	M	5	12	Organisation Unit Code
3	Status	15	Char	O	13	27	Blank or MAIL RETURNED
4	Type	15	Char	M	28	42	Type of Address: RESIDENTIAL POSTAL BUSINESS OVERSEAS CAREOFADDRESS FOREIGN
5	T_LINE_1	50	Char	O	43	92	First line of the address
6	T_LINE_2	50	Char	O	93	142	Second line of the address
7	T_LINE_3	50	Char	O	143	192	Third line of the address
8	T_LINE_4	50	Char	O	193	242	Fourth line of the address
9	T_LINE_5	50	Char	O	243	292	Fifth line of the address
10	COUNTRY	15	Char	O	293	307	Validate to Country UDPV values.
11	C_POSTAL	10	Char	O	308	317	Postal code
12	C_ELEC_ID_1	150	Char	O	318	467	E-mail address
13	T_ELEC_DESC_1	20	Char	O	468	487	Description for the e-mail address
14	C_TEL_ COUNTRY_1	8	Char	O	488	495	The country code for the first telephone number.
15	C_TEL_AREA_1	8	Char	O	496	503	The area code for the first telephone number.
16	R_TELEPHONE_1	20	Char	O	504	523	The first telephone number.
17	C_TEL_ COUNTRY_2	8	Char	O	524	531	The country code for the second telephone number.
18	C_TEL_AREA_2	8	Char	O	532	539	The area code for the second telephone number.
19	R_TEL_ NUMBER_2	20	Char	O	540	559	The second telephone number.
20	C_TEL_ COUNTRY_3	8	Char	O	560	565	The country code for the third telephone number.
21	C_TEL_AREA_3	8	Char	O	566	573	The area code for the third telephone number.
22	R_TELEPHONE_3	20	Char	O	574	593	The third telephone number.
23	C_CELL_ COUNTRY	8	Char	O	594	601	The country code for the cellular number.
24	R_CELLULAR	20	Char	O	602	621	The cellular number.
25	Country Code (Fax No 1)	8	Char	O	622	629	The country code for the first fax number.
26	Area Code (Fax No 1)	8	Char	O	630	637	The area code for the first fax number.
27	Fax Number 1	20	Char	O	638	657	The first fax number.
28	Country Code (Fax No 2)	8	Char	O	658	665	The country code for the second fax number.
29	Area Code (Fax No 2)	8	Char	O	666	673	The area code for the second fax number.
30	Fax Number 2	20	Char	O	674	693	The second fax number.

Note:

Positions 1-3 of the last row must contain EOF, followed by a return character.

When the file is loaded, the system will check that the Organisation Unit Code is unique for each type of address. If not, the Address Details will not be loaded for that Organisation Unit and an error message will be written to the error log.

For more details refer to Organisation Unit Address Upload under

Processes

File Transfer

Conversion

Uploading Files and Documents