Does EIM support importing multiple addresses for accounts?

If you are using EIM interface tables, you can explicitly set primary addresses for accounts. If you are not using EIM interface tables, you can still set primary addresses using IF interface tables. 

If you are loading accounts with single addresses, you should use the address fields in the EIM_ACCOUNT table. If you are loading accounts with multiple addresses, do not populate the address fields in the EIM_ACCOUNT table. Instead, use the EIM_ADDR_ORG table to load all addresses for these accounts. If you need to set a primary address in this case, import the primary address using the EIM_ACCOUNT table in one batch, and the rest of the addresses using the EIM_ADDR_ORG table in another batch.

NOTE: This procedure works only for an account that does not already have an address with which it is associated.

 

To set the primary address for an account

1 Populate the EIM_ACCOUNT table with the following primary address data which maps to the S_ORG_EXT and S_ADDR_ORG base tables:

■ ADDR_ADDR

■ ADDR_CITY

■ ADDR_STATE

■ ADDR_ZIPCODE

■ ACCNT_LOC

■ ACCNT_NAME

 

2 Run an EIM import process for the EIM_ACCOUNT table. The address will automatically be set as primary.

 

3 Populate the EIM_ADDR_ORG table with other addresses. Make sure the account data (ACCNT_LOC and ACCNT_NAME) is consistent with that imported earlier in the S_ORG_EXT table. The following columns need to be populated in the EIM_ADDR_ORG table:

■ ADDR

■ CITY

■ STATE

■ ZIPCODE

■ ACCNT_LOC

■ ACCNT_NAME

 

4 Run an EIM import process for the EIM_ADDR_ORG table. The addresses will be associated with the related account.

 

The following example uses this procedure to import two addresses for the ABC CORP account located in SF and sets the 111 MILL ST FREMONT CA 94536 address as the primary address.

 

To set the primary address of ABC CORP as an example

 

1 Insert the primary address into the EIM_ACCOUNT table by executing the following SQL statement:

 

insert into EIM_ACCOUNT (ROW_ID,IF_ROW_BATCH_NUM, IF_ROW_STAT,

PARTY_UID,PARTY_TYPE_CD,ADDR_ADDR,ADDR_CITY,ADDR_STATE,

ADDR_ZIPCODE,ACCNT_LOC,ACCNT_NAME,ADDR_ACTIVE_FLG,

ADDR_BL_ADDR_FLG,ADDR_DISACLEANSEFL,ADDR_MAIN_ADDR_FLG,

ADDR_NAME_LOCK_FLG,ADDR_SHIP_ADDR_FLG,ADDR_ADDR_NAME) VALUES (1,1,'FOR_IMPORT','ABC CORP PARTY','Organization','111 MILL ST',

'FREMONT','CA','94536','SF','ABC CORP','Y','Y','Y','Y','Y','Y','Fremont facility')

 

2 Run an EIM import process by adding or modifying the following process section in the .ifb configuration file:

 

[Import Address Data]

TYPE = IMPORT

BATCH = 1

TABLE = EIM_ACCOUNT

 

3 Insert the remaining address into the EIM_ADDR_ORG table by executing the

following SQL statement:

 

insert into EIM_ADDR_ORG (ROW_ID,IF_ROW_BATCH_NUM,IF_ROW_STAT, ADDR,CITY,STATE,ZIPCODE,ACCNT_LOC,ACCNT_NAME,ADDR_ACTIVE_FL,ADDR_BL_ADDR_FLG,ADDR_DISACLEANSEFL,ADDR_MAIN_ADDR_FLG, ADDR_NAME_LOCK_FLG,ADDR_SHIP_ADDR_FLG,ADDR_ADDR_NAME) VALUES (1, 1,'FOR_IMPORT','2050 LAKE DR','SAN MATEO',‘CA','94555',

'SF','ABC CORP','Y','Y','Y','Y','Y','Y','Fremont facility')

 

NOTE: Make sure that ACCNT_NAME and ACCNT_LOC are populated with the exact data that is in the S_ORG_EXT table for the respective account. 4 Run an EIM import process by adding or modifying the following process section in the .ifb configuration file:

 

[Import Address Data]

TYPE = IMPORT

BATCH = 1

TABLE = EIM_ADDR_ORG

Tags