Cust_Addr

ODI Extracts > Core Director > Cust_Addr

Extract to return all addresses associated with a customer

Provider	Element	Element Description	Reference File	Reference Field	Field Type	Length
Core Director	Dlt	Delete record flag			String	1
Core Director	SrcKey	Unique record key	MASTER.ISM	COM_MASTER_PRIMARY_KEY (of CIF or Acct that address exists on) + Seq	String	20
Core Director	FornKey	Account Key	MASTER.ISM	COM_MASTER_PRIMARY_KEY of CIF	String	18
Core Director	AddrCatUse	Cust or Acct	MASTER.ISM	based on if the address is from the CIF or Account	String	8
Core Director	AddrCat2Use	Phys or Seasonal address	MASTER.ISM		String	11
Core Director	StreetAddr1	Street Address 1	MASTER.ISM	9 for physical, 86 for seasonal	String	40
Core Director	StreetAddr2	Street Address 2	MASTER.ISM	37 for physical	String	40
Core Director	City	City	MASTER.ISM	10 for physical, 87 for seasonal	String	25
Core Director	StateCode	State	MASTER.ISM	11 for physical, 88 for seasonal	String	2
Core Director	PostalCode	Zip	MASTER.ISM	12 for physical, 89 for seasonal	String	13
Core Director	SeasonBegDt	Seasonal Start Date	MASTER.ISM	68	DateTime	8
Core Director	SeasonEndDt	Seasonal End Date	MASTER.ISM	69	DateTime	8
Core Director	SeasonReocur	Number of Months to Increase Starting and Ending Dates	MASTER.ISM	70	Int32	2

Have a Question?

Have a how-to question? Seeing a weird error? Get help on StackOverflow.

Register for the Developer Office Hours where we answer technical Q&A from the audience.

Please ignore this field

Did this page help you?

Last updated Fri Feb 21 2025