Skip to main content

Knowledge Center

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.

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