Skip to main content

Knowledge Center

Load Supplier archive (SUP) - INP/59330

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

NAME

Y

Doe

Company name, or a person's surname.

POCODE

Y

5578

Postal Code. Will be validated against the POC archive in RamBase. Illegal values will be discarded.

CITY

Y

NEDRE VATS

City/town/village.

CCODE

Y

2

NO

Country code is a two-character code identifying a country. The code follows the ISO 3166 standard. Will be validated against CON archive in RamBase.

CUR

3

NOK, EUR

Currencies this supplier sells in. May contain a comma list if several. Is validated against a subset of ISO 4217.

ST

Y

1

4

Status of the supplier. 1:New, 2:Pending internal approvement, 4:Active, 9:Obsolete. Defaults to 2 if not provided.

ACCOUNT

10000

Supplier Id. Unique number created by RamBase. Provide this value if you want to update an existing supplier.

FIRSTNAME

John

A person's first name.

ATTN

Jane Doe

Attention.

ADDR1

Mystery Lane 123

First address line.

ADDR2

Post box 9077

Second address line.

STATE

Y*

CA

* Required if country (CCODE) is Canada or USA.

PHONE

+4752763390

Supplier's main phone number. Can not contain any letters or spaces, but + is OK as prefix. Must be four digits or more.

EMAIL

john.doe@msn.com

Supplier's main email address. Will be validated.

ENTERPRISE

924054832

Legal entity, a unique enterprise/organization number. The format is different from country to country.

VATNO

DK669248438

Value Added Tax (VAT) registration number. Unique number assigned by the relevant tax authority. The format is different from country to country.

LANGUAGE

3

Eng

Preferred Language. Value is stored as a three character code, according to ISO 639-2 standard. Will be used to produce output to supplier in correct language.

SHIPBYNO

100036

Preferred shipping method for purchase orders. Will typically be a carrier's product. Numbers are references to SHP archive.

OUTGOINGSHIPBYNO

100012

Preferred shipping method for sales orders. Will typically be a carrier's product. Valid options have to be set up by JHC personnel in advance. Numbers are references to SHP archive.

DELTERM

FCA Oslo

Delivery terms for shipments from supplier. Valid options have to be set up by JHC personnel in advance.

PAYTERM

NET,10

Payment terms for this supplier.  Valid options have to be set up by JHC personnel in advance. If duedate on invoice documents are not manually filled, this will be calculated based on PayTerm.

Valid options:

ADVANCE - Payment in advance

NET, X - Day(s) net

COD - Cash on delivery

COP - Cash on pick up

EOCM, X - Net x day(s) EOM

PAYBY

SWIFT

Method of payment. Valid options have to be set up by JHC personnel in advance.

ACCOUNTCL

C

Classification of suppliers. Valid options have to be set up by JHC personnel in advance.

PAYBLOCKED

1

If set to 1, the system will block for generating payments to supplier.

0 is default value -> no blocking

MSG

Duplicate registered, use SUP/12345 instead.

Internal note/notice about the supplier.

ICTDB

JHR-NO

Inter Company Trading DataBase. Used to identify internal customer/suppliers

EXTID

External supplier reference/identifier.