Sage 200 Online Customer Delivery Address XML

Information can be stored for multiple delivery addresses against each customer account. Further information can be found on the Sage 200 Online Customer Delivery Address API Documentation.

Tasks

• Exporting Customer Delivery Addresses From Sage 200 Online

Fields for Download Only

id

Read Only
The unique ID of the customer delivery address.

Type	Example	XML
integer(int64)	27914	<id>27927</id>

date_time_created

Read Only
The date and time this entity was created (UTC).

Type	Example	XML
string(date-time)	2021-02-28T14:06:36.983Z	<date_time_created>2021-02-28T14:06:36.983Z</date_time_created>

date_time_updated

Read Only
The date and time this entity was last updated (UTC).

Type	Example	XML
string(date-time)	2021-02-28T14:23:46.867Z	<date_time_updated>2021-02-28T14:23:46.867Z</date_time_updated>

address_1

Read Only
Address line 1.

Type	Example	XML
string(60)	67a Station Road	<address_1>67a Station Road</address_1>

address_2

Read Only
Address line 2.

Type	Example	XML
string(60)	67a Station Road	<address_2>67a Station Road</address_2>

address_3

Read Only
Address line 3.

Type	Example	XML
string(60)	Blackpool	<address_3>Blackpool</address_3>

address_4

Read Only
Address line 4.

Type	Example	XML
string(60)	Lancashire	<address_4>Lancashire</address_4>

city

Read Only
City (if using segmented addresses in Sage 200 Professional).

Type	Example	XML
string(60)	Blackpool	<city>Blackpool</city>

county

Read Only
County (if using segmented addresses in Sage 200 Professional).

Type	Example	XML
string(60)	Lancashire	<county>Lancashire</county>

postcode

Read Only
Postcode.

Type	Example	XML
string(60)	BP12 7HT	<postcode>BP12 7HT</postcode>

country

Read Only
The Country name (if using segmented addresses in Sage 200 Professional).

Type	Example	XML
string(60)	United Kingdom	<country>United Kingdom</country>

address_country_code_id

Read Only
Country code Id.

Type	Example	XML
integer(int64)	0	<address_country_code_id>0</address_country_code_id>

customer_id

Read Only
Unique Id of the customer account the customer delivery address is associated with.

Type	Example	XML
integer(int64)	27825	<customer_id>27825</customer_id>

is_default

Optional
Flag to indicate if this is the default customer delivery address for the parent customer.

Type	Example	XML
boolean	false	<is_default>false</is_default>

description

Read Only
The description of the customer delivery address.

Type	Example	XML
string(255)	Registered address	<description>Registered address</description>

postal_name

Read Only
Postal name is the name of the person or company who the invoice or sales order is addressed to.

Type	Example	XML
string(60)	A1 Design Services	<postal_name>A1 Design Services</postal_name>

contact

Read Only
The contact associated with the customer delivery address.

Type	Example	XML
string(235)	Lee Dalkin	<contact>Lee Dalkin</contact>

telephone

Read Only
The telephone number associated with the customer delivery address.

Type	Example	XML
string(60)	01742 876 234	<telephone>01742 876 234</telephone>

fax

Read Only
The fax number associated with the customer delivery address.

Type	Example	XML
string(30)	01742 876 236	<fax>01742 876 236</fax>

email

Read Only
The email address associated with the customer delivery address.

Type	Example	XML
string(255)	[email protected]	<email>[email protected]</email>

tax_number

Read Only
The tax number.

Type	Example	XML
string(30)	GB238 3839 38	<tax_number>GB238 3839 38</tax_number>

tax_code_id

Read Only
The tax code record Id.

Type	Example	XML
integer(int64)	1729	<tax_code_id>1729</tax_code_id>

country_code_id

Read Only
VAT details Country code Id.

Type	Example	XML
integer(int64)	13	<country_code_id>13</country_code_id>

Example XML

<?xml version="1.0" encoding="utf-8"?>
<CustomerDeliveryAddresss xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <CustomerDeliveryAddress>
    <id>27927</id>
    <date_time_created>2021-02-28T14:06:36.983Z</date_time_created>
    <date_time_updated>2021-02-28T14:23:46.867Z</date_time_updated>
    <address_1>67a Station Road</address_1>
    <address_2 />
    <address_3>Blackpool</address_3>
    <address_4>Lancashire</address_4>
    <city />
    <county />
    <postcode>BP12 7HT</postcode>
    <country />
    <address_country_code_id>0</address_country_code_id>
    <address_country_code>
      <id>0</id>
      <date_time_updated xsi:nil="true" />
      <name />
      <code />
      <eu_member>false</eu_member>
    </address_country_code>
    <customer_id>27825</customer_id>
    <is_default>false</is_default>
    <description>Registered address</description>
    <postal_name>A1 Design Services</postal_name>
    <contact>Lee Dalkin</contact>
    <telephone>01742 876 234</telephone>
    <fax>01742 876 236</fax>
    <email>[email protected]</email>
    <tax_number>GB238 3839 38</tax_number>
    <tax_code_id>1729</tax_code_id>
    <country_code_id>13</country_code_id>
    <tax_code>
      <id>1729</id>
      <date_time_updated>2021-02-28T14:23:46.133Z</date_time_updated>
      <code>1</code>
      <name>Standard rate</name>
      <tax_rate>20.00</tax_rate>
    </tax_code>
    <country_code>
      <id>13</id>
      <date_time_updated>2021-02-28T14:23:46.173Z</date_time_updated>
      <name>Great Britain</name>
      <code>GB</code>
      <eu_member>false</eu_member>
    </country_code>
  </CustomerDeliveryAddress>
</CustomerDeliveryAddresss>