File Layout: ADDRESS

Interface:           1

Frequency:          Daily

Description:         Details for a member's address record.

 

Addresses for existing members are processed directly to core.  Addresses for new member are processed to core once the daily confirm process is done. 

 

Addresses come in with the following codes:

HA – home address

WA – work address

OS - overseas. 

 

The residential address will be marked as the preferred address and in the absence of a residential address and existence of an overseas address, the overseas address will be marked as the preferred address. 

 

When new addresses are being processed, a new instance will be created, and the previous one marked a discontinued.

 

File layout

NO HEADER

 

DATA

Field

Position

Length

Type

Group SAP Fields

Comments

ADDRESS.MEMBNO

1 – 8

8

N

PA0053-PENUM

Right justified with leading zeros

ADDRESS.NMECDE

9 – 10

2

C

 

MB

ADDRESS.ADDCDE

11 – 12

2

C

PA006-ANSSA

Can be either HA, OS, WA

ADDRESS.ADLIN1

13 – 46

34

X

PA0006-STRAS (House No and Street) (PA0006-NAME2 for WA)

Req 80 - blanks should be output instead of asterisks where no data for row
Left justified with trailing spaces

ADDRESS.ADLIN2

47 – 80

34

X

PA0006-LOCAT (2nd Address line)( PA0006-STRAS

(House No and Street) for WA)

Req 80 - blanks should be output instead of asterisks where no data for row
Left justified with trailing spaces

ADDRESS.ADLIN3

81 – 114

34

X

PA0006-ORT01 (City)( PA0006-LOCAT

(2nd Address line) for WA)

Req 80 - blanks should be output instead of asterisks where no data for row
Left justified with trailing spaces

ADDRESS.ADLIN4

115 – 148

34

X

PA0006-ORT02

(District)( PA0006-ORT01 (City) for WA)

Req 80 - blanks should be output instead of asterisks where no data for row
Left justified with trailing spaces

ADDRESS.ADLIN5

149 – 182

34

X

PA0006-STATE (County) (PA0006-WKWNG (Mail Van) for WA)

Req 80 - blanks should be output instead of asterisks where no data for row
Left justified with trailing spaces

ADDRESS.PSTCDE

183 – 192

10

X

PA0006-PSTLZ

Left justified with trailing spaces

ADDRESS.ADDEFF

193 – 202

10

D

PA0006-BEGDA

dd/mm/yyyy

ADDRESS.CNTRY

203 – 217

15

X

1st 10 chars of T005-LANDX for PA0006-LAND1
(only populate when non-UK address)

Req 82 - Field expanded from 10 - 15 characters

ADDRESS.TELNM1

218 – 233

16

X

PA0006-TELNR

 

 

NO TRAILER