CustomerDeliveryAddresses

A customer can have multiple delivery addresses stored for their account which can be used when creating an invoice or sales order.

Table Specific Information

Select

The driver uses the Sage 200c Standard Online API to process all search criteria.

Supported operators are: =, < , <= , > , >= , != , AND, LIKE , IS NULL , IS NOT NULL.

For example, the following queries are processed server side:

SELECT * FROM CustomerDeliveryAddresses WHERE Id = 27927
SELECT * FROM CustomerDeliveryAddresses WHERE Contact = 'Lee Dalkin'
SELECT * FROM CustomerDeliveryAddresses WHERE Country = 'abc'
SELECT * FROM CustomerDeliveryAddresses WHERE CustomerId = 27825
SELECT * FROM CustomerDeliveryAddresses WHERE Description = 'Registered address'
SELECT * FROM CustomerDeliveryAddresses WHERE Email = '[email protected]'
SELECT * FROM CustomerDeliveryAddresses WHERE Fax = '01742 876 236'
SELECT * FROM CustomerDeliveryAddresses WHERE IsDefault = false
SELECT * FROM CustomerDeliveryAddresses WHERE PostalName = 'A1 Design Services'
SELECT * FROM CustomerDeliveryAddresses WHERE TaxCodeId = 1729
SELECT * FROM CustomerDeliveryAddresses WHERE TaxNumber = 'GB238 3839 38'
SELECT * FROM CustomerDeliveryAddresses WHERE Telephone = '01742 876 234'
SELECT * FROM CustomerDeliveryAddresses WHERE Address1 = '67a Station Road'
SELECT * FROM CustomerDeliveryAddresses WHERE Address2 = 'abc'
SELECT * FROM CustomerDeliveryAddresses WHERE Address3 = 'Blackpool'
SELECT * FROM CustomerDeliveryAddresses WHERE Address4 = 'Lancashire'
SELECT * FROM CustomerDeliveryAddresses WHERE City = 'abc'
SELECT * FROM CustomerDeliveryAddresses WHERE County = 'abc'
SELECT * FROM CustomerDeliveryAddresses WHERE Postcode = 'BP12 7HT'
SELECT * FROM CustomerDeliveryAddresses WHERE AddressCountryCodeId = 0
SELECT * FROM CustomerDeliveryAddresses WHERE DateTimeUpdated = '2018-02-28T15:23:46.867+01:00'

Columns


Name	Type	References	Description
Id [KEY]	Long		The unique id of the customer delivery address.
Contact	String		The contact associated with the customer delivery address.
Country	String		Country (if using segmented addresses in Sage 200c Professional or Sage 200 Extra Online).
CustomerId	Long		Unique Id of the customer account the customer delivery address is associated with. See customers
Description	String		The description of the customer delivery address.
Email	String		The email address associated with the customer delivery address.
Fax	String		The fax number associated with the customer delivery address.
IsDefault	Bool		Flag to indicate if this is the default customer delivery address for the parent customer. See customer
PostalName	String		Postal name is the name of the person or company who the invoice or sales order is addressed to.
TaxCodeId	Long		The tax code record Id. See tax_codes
TaxNumber	String		The tax number.
Telephone	String		The telephone number associated with the customer delivery address.
Address1	String		Address line 1.
Address2	String		Address line 2.
Address3	String		Address line 3.
Address4	String		Address line 4.
City	String		City (if using segmented addresses in Sage 200c Professional or Sage 200 Extra Online).
County	String		County (if using segmented addresses in Sage 200c Professional or Sage 200 Extra Online).
Postcode	String		Postcode.
AddressCountryCodeId	Long		Country code Id. See country_codes
DateTimeUpdated	Datetime		The date and time this entity was last updated (UTC).

ODBC Driver for Sage 200

CustomerDeliveryAddresses

Table Specific Information

Select

Columns