Load Customer Shipping addresses
Possible fields to be loaded into RamBase are listed in the Field-column in the following table. The other columns in this table provide additional information about each field.
Field |
Required |
Length |
Example |
Description |
ACCOUNT |
Y* |
123456 |
Customer Id. Unique number created by RamBase. * To identify the customer to be updated ACCOUNT or EXTID must be provided in the file. |
|
EXTID |
Y * |
External system customer Id. * To identify the customer to be updated ACCOUNT or EXTID must be provided in the file. |
||
SDELTERM |
Y* |
|
|
*If shipping address is provided. |
SDELTERMPLACE |
Y* |
|
|
*If shipping address is provided. |
SFIRSTNAME |
John |
A person's first name in the shipping address. |
||
SNAME |
Doe |
Company name, or a person's surname in the shipping address. |
||
SATTN |
Jane Doe |
Attention in the shipping address. |
||
SADDR1 |
Mystery Lane 123 |
First address line in the shipping address. |
||
SADDR2 |
Post Box 9077 |
Second address line in the shipping address. |
||
SPOCODE |
5578 |
Postal code in the shipping address. Will be validated against the POC archive in RamBase. Illigal values will be discarded. |
||
SCITY |
NEDRE VATS |
City/town/village in the shipping address. |
||
SSTATE |
TN |
A US state. |
||
SHIPCC |
2 |
NO |
Country code is a two-character code identifying a country. The code follows the ISO 3166 standard. Will be validated against the CON archive in RamBase. |
|
SITM |
1 |
Unique shipping address identifier. |
||
SSHCODE |
SHC/100007 |
Refers to a special shipping and handling code for orders to this shipping address. Valid options have to be set up in the SHC archive prior to the load. |
||
SPHONE |
+4752763390 |
Phone number for this shipping address. |
||
SFAX |
+34915300164 |
Fax number for this shipping address. |
||
SEMAIL |