Enterprise Solutions

Cust_Addr

Operational Data Integration (ODI) > ODI Extracts > Core Director > Cust_Addr

Extract to return all addresses associated with a customer

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

Have a Question?
Have a how-to question? Seeing a weird error? Get help on StackOverflow.
Register for the Digital Toolkit Meetup where we answer technical Q&A from the audience.
Last updated Tue Apr 16 2024