Load Customer shipping addresses - INP/63673
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. | ||
ISDEFAULT | 1, Y, Yes | Set to 1, Y or YES if this should be the default Shipping Address for the customer. | ||
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 |