Bookshelf Home | Contents | Index | Search | PDF

Siebel Enterprise Integration Manager Administration Guide > Common EIM Usage Examples > Other Examples >

Example of Setting Explicit Primary Mappings

---

This example is specific to Siebel eBusiness Applications.

You are importing a new account with three addresses using the EIM_ACCOUNT interface table. You can explicitly set one of these addresses as the primary business address by populating the primary flag column ACC_PR_ADDR with Y, or as the primary billing address by populating the primary flag column ACC_PR_BL_ADDR with Y.

NOTE:  The flag columns for explicit primary mappings usually follow the XXX_PR_XXX naming convention.

Table 23 shows an example of setting the primary business address for A. K. Parker Distribution to Menlo Park, and its billing address to San Francisco.

If an explicit primary mapping is not used or not used properly—such as no address or more than one address flagged as the primary business address—then EIM ignores this explicit primary mapping and sets the primary implicitly.

For information on the explicit primary columns for each EIM table, see Interface Tables Reference.

Table 23.  Explicit Primary Mapping for an Account

NAME	LOC	ACCNT_BU	ADDR	City	ACC_PR_ADDR	ACC_PR_BL_ADDR
A. K. Parker Distribution	CA	Americas	1000 Industrial Way	Menlo Park	Y
A. K. Parker Distribution	CA	Americas	322 Arkansas Street	San Francisco		Y
A. K. Parker Distribution	CA	Americas	888 El Camino Real	San Mateo

Table 24 shows an excerpt from Interface Tables Reference. It shows that when you use the EIM_ACCOUNT interface table, you can use the ACC_PR_ADDR column to mark an address as the primary address and the ACC_PR_BL_ADDR column to mark an address as the primary billing address.

Table 24 is provided as an example only; for a full listing of the mappings supported by the EIM_ACCOUNT interface table, see Interface Tables Reference.

Table 24.  EIM_ACCOUNT

Base Table	Base Column	UK	Req	Base Column Description	IF Source Column	Data Type	Length
S_ORG_EXT*	NAME	1	Y	Name	NAME	Varchar	100
	LOC	2	N	Site	LOC	Varchar	50
	BU_ID	3	Y	Business Unit Id	ACCNT_BU	Varchar	50
	PR_ADDR_ID		N	Primary Address	ACC_PR_ADDR	Char	1
	PR_BL_ADDR_ID		N	Primary Bill To Address	ACC_PR_BL_ADDR	Char	1
	PR_BL_OU_ID		N	Primary Billing Organization Id	ACC_PR_BL_OU	Char	1
S_ADDR_ORG	ADDR		Y	Address	ADDR_ADDR	Varchar	200
	CITY		Y	City	ADDR_CITY	Varchar	50
	STATE		N	State	ADDR_STATE	Varchar	10
	ZIPCODE		N	Zipcode	ADDR_ZIPCODE	Varchar	30
	OU_ID	2	Y	Account	ACCNT_BU	Varchar	50
					LOC	Varchar	50
					NAME	Varchar	100

Bookshelf Home | Contents | Index | Search | PDF