Delivery Address Interface Table

This extract file interface handles the delivery address records associated with the invoices in the current extract set.

Data loaded via this interface is primarily bound for the CONTACT_DETAILS CXP Customer Experience Platform, or CXP, is MDS Global's self-service app that allows business customers to manage their own accounts and subscriptions. Admin schema table.

External table name	Schema	Mapped file
delivery_address_Interface	Staging	delivery_address.dat

 

Delivery address interface table fields

Column Heading	Type	Length	Description
EXTERNAL_DELIVERY_ADDRESS_ID	VarChar2	40	Unique delivery address identifier as used by the originating CRM data base.
TITLE	VarChar2	40	Addressee's title (Mr, Mrs, and so on).
FIRST_NAME	VarChar2	40	Addressee's forename.
MIDDLE_NAME	VarChar2	40	Addressee's middle name.
SURNAME	VarChar2	40	Addressee's surname.
JOB_TITLE	VarChar2	40	Addressee's job title (used as required in a business address)
COMPANY_NAME	VarChar2	100	The company name used on a corporate type customer's address.
ADDRESS_LINE_1	VarChar2	40	First geographical address line.
ADDRESS_LINE_2	VarChar2	40	Second geographical address line.
ADDRESS_LINE_3	VarChar2	40	Third geographical address line.
ADDRESS_LINE_4	VarChar2	40	Fourth geographical address line.
ADDRESS_LINE_5	VarChar2	40	Fifth geographical address line.
ADDRESS_LINE_6	VarChar2	40	Sixth geographical address line.
POSTAL_CODE	VarChar2	40	Geographical post code or zip code.
TELEPHONE_NUMBER	VarChar2	40	Contact telephone number (optional for a pure delivery address).
ALTERNATIVE_TELEPHONE_NUMBER	VarChar2	40	Secondary contact telephone number (optional for a pure delivery address).
FAX_NUMBER	VarChar2	40	Contact fax number (optional for a pure delivery address).
ADDRESS_TYPE	VarChar2	40	Gives an indication of the nature of the current address and what it is used for. An address can represent different things such as an invoicing address or straight customer contact details. For invoice delivery address purposes this value can take values such as 'Business' or 'Personal' to give an indication of the kind of addressee involved.