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. | |
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). |