Document toolboxDocument toolbox

Customer Addresses (bi_address)

Owned by Chris Laun
Feb 28, 2023
1 min read

Overview: This is an incremental file of customer address information from CDSADR_M.

Frequency: Daily
Data Source: Advantage
Delivery Method: SFTP to csv import work
Filename: Address_<Lytics Group>_<Date>_<Time>.txt
LQL Advice: Most of these fields will need to be mapped to Item_Number for context.
Field NameDescriptionSource FieldSample Value
Customer_NumberAdvantage identifier of the customerCDSADR_M.CTM_NBR000012345678
First_NameFirst name of the customerCDSADR_M.ATN_1STJANE
Middle_InitialMiddile Initial of the customerCDSADR_M.ATN_MIDA
Last_NameLast name of the customerCDSADR_M.ATN_ENDDOE
Street_Addr_Line_1First address lineCDSADR_M.STR_1ST123 MAIN ST
Street_Addr_Line_2Second address lineCDSADR_M.STR_2NDAPT A
Street_Addr_Line_3Third address lineCDSADR_M.STR_3RDSUITE 100
CityCity on the customer addressCDSADR_M.CTM_CTYBaltimore
StateState on the customer addressCDSADR_M.CTM_STEMD
Country_Code3 character code representing the countryCDSADR_M.CUN_TYPUSA
Postal_CodePostal/Zip codeCDSADR_M.ZIP_CDE21230
Phone_Number_1First phone recordCDSADR_M.PHO_NBR555-555-1111
Phone_Number_2Second phone recordCDSADR_M.PHO_NBR2555-555-1111
Phone_Number_3Third phone recordCDSADR_M.PHO_NBR3555-555-1111
Promoted_By_MailFlag indicating whether the customer can be promoted to by mailCDSADR_M.PMO_ADRY
Promoted_By_PhoneFlag indicating whether the customer can be promoted to by phoneCDSADR_M.PMO_PHNN
Promoted_By_FaxFlag indicating whether the customer can be promoted to by faxCDSADR_M.PMO_FAXY
Promoted_By_SMSFlag indicating whether the customer can be promoted to by SMSCDSADR_M.PMO_SMSN
Email_AddressEmail of the customerCDSEML_M.ADR_EMLtest@example.com
OperationCDC Operation code associated with the event
U
Company_NameBusiness name on the address recordCDSADR_M.CMP_NME14 WEST
Is_Address_ValidAddress valid flagCDSADR_M.ADR_VLDY
Country_NameFull name of the country on the addressCDSCOU_T.CUN_NMEUnited States
Promo_FlagFlag on the customer record indicating whether they can be promoted toCDSCTM_M.PROMOY
Sex_CodeCode indicating the customer's genderCDSCTM_M.SEX_CDEF
DMA_PanderFlag field used to limit who can be marketed to
YES
Namebank_OKFlag to identify customers who can be used by Namebank
N
Record_StatusFlag indicating whether the customer record is activeCDSCTM_M.REC_STAA
com.atlassian.confluence.content.render.xhtml.migration.exceptions.UnknownMacroMigrationException: The macro 'html-macro' is unknown.