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