SSIS Components for Sage 200

Build 20.0.7587

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='newbusinessadvice@sage.com'
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).

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587