Load Supplier archive (SUP)
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. | ||
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. |