Load Customer archive (CUS) - INP/58042
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 | 10000 | Customer Id. Unique number created by RamBase. Provide this value if you want to update an existing customer. | ||
ACCOUNTCL | C | Classification of customers. Valid options have to be set up by JHC personnel in advance. | ||
ADDR1 | Mystery Lane 123 | First address line. | ||
ADDR2 | Post box 9077 | Second address line. | ||
ATTN | Jane Doe | Attention. | ||
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 the CON archive in RamBase. |
CITY | Y | NEDRE VATS | City/town/village. | |
CREDITINS | 400000 | Credit amount insured for the customer, in company currency. | ||
CREDITLIM | 20000 | Maximum limit for customer credit, in currency given by company currency. | ||
CUR | 3 | NOK, EUR | Currencies this customer buys in. May contain a comma list if several are used. Is validated against a subset of ISO 4217. | |
DELTERM | FCA, Incoterm 2010 | Delivery terms for shipments to customer. Valid options have to be set up by JHC personnel in advance. | ||
DELTERMPLACE | Oslo | The place of delivery at which you are responsible to deliver goods according to the delivery terms. | ||
DISTRICT | South | A geographic district for which an individual sales person or a sales team hold responsibility. Valid options have to be set up by JHC personnel in advance. | ||
DUEAPPROVE | NO | "YES" if approval before shipping orders are required when outstanding accounts are overdue. | ||
EDIACCOUNT | 1234567 | Electronic data interchange account number. | ||
EDIPARTNER | STANDARDEHF | Electronic data interchange partner. | ||
john.doe@msn.com | Customer's main mail address. Will be validated. | |||
ENTERPRISE | 924054832 | Legal entity, a unique enterprise/organization number. The format is different from country to country. | ||
EXTID | Y* | External customer reference/identifier. *Required if NAME is not provided. | ||
FAX | +34915300164 | Customer's main fax number. Can not contain any letters or spaces, but + is OK as prefix. Must be six digits or more. | ||
FEE | 50 | An amount in document currency that will be added to an order. | ||
FEEPCT | 5 | Percentage of financial charge to be added to orders. | ||
FIRSTNAME | John | A person's first name. | ||
ICTDB | JHR-NO | Inter Company Trading DataBase. Used to identify internal customer/suppliers. | ||
INCLVAT | NO | Specifies how value added tax (VAT) should be calculated. Either always include VAT, always exclude VAT or use standard/default VAT rules. Valid options are: YES = if the customer always should pay VAT NO = if the customer never should pay VAT ‘blank’ = Std VAT rules will be used. | ||
INDEXAGR | 80/1.5 | Exchange fluctuation rate agreement. When an order is issued, RamBase stores the current exchange rate and the currency the part normally is purchased in. The exchange rate might have changed when the invoice is issued. The exchange rate fluctuation agreement specifies how to handle these differences. The agreement has the format AAA/BBB, where AAA is a percentage of the total invoice, and BBB is the exchange rate fluctuation percentage. E.g. 80/3.0 means that if the rate of exchange on the date a customer order is transported to an invoice has changed more than +/- 3% from the rate of exchange, 80% of the invoice amount will be adjusted. | ||
INSCOMPANY | AIG | Insurance company used by the customer for credit insurance. | ||
INTFEE | 25 | Interest rate used when creating interest invoices for invoices that have past duedate. | ||
INVCONS | 1 | M | Specifies whether or how often shipping advise items will be consolidated when creating invoices. Valid options are: N = No consolidation X = Excluded from automatic creation of invoice. D = Daily W = Weekly M = Monthly If no value is provided, this is understood as the value N (No consolidation), which means that the invoice is automatically created when the shipping advise is sent. | |
INVGROUPBY | YOURNO | Field to group by if the values D, W or M are set in the INVCONS field. | ||
INVOICEBLOCKED | YES | Invoices for this customer will be blocked for registering. | ||
INVSORTBY | PART | Field to sort by if the values D, W or M are set in the INVCONS field. | ||
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 customer in correct language. | |
MINGM | 20 | The minimum accepted gross margin in percentage (%). | ||
MSG | Customer wants estimates in EURO. | Internal note/notice about the customer. | ||
NAME | Y* | Doe | Company name, or a person's surname. *Required, if EXTID is not provided. | |
ORDERBLOCKED | YES | Orders for this customer will be blocked for registering. | ||
PAYBY | Credit card | Method of payment. Valid options have to be set up by JHC personnel in advance. | ||
PAYTERM | NET,10 | Payment terms. Duedate on invoice documents are calculated based on Payterm. Valid options have to be set up by JHC personnel in advance. 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 | ||
PHONE | +4752763390 | Customer's main phone number. Can not contain any letters or spaces, but + is OK as prefix. Must be four digits or more. | ||
PIDEXT | 902 | Account manager, refers to a PER. | ||
PIDINT | 8900 | Account sales assistant, refers to a PER. | ||
PLINAME | Price list name. | |||
PLINO | 6 | 100000 | Identification number of Price list (PLI) the customer belongs to. | |
POCODE | Y | 5578 | Postal Code. Will be validated against the POC archive in RamBase. Illegal values will be discarded. | |
PRICEAGR | 100-PR | Quantity Price Agreement. E.g 100-PR means that even if an order line is for less quantity than 100 pieces, it will pick of the volume price of 100 pieces from the product (ART). Valid options have to be set up by JHC personnel in advance. | ||
QUOTEBLOCKED | YES | Sales quotes for this customer will be blocked for registering. | ||
REMINDER | YES | Set to "NO" if dunning letters for outstanding amounts should not be created for the customer. | ||
SECTOR | Distributor | The sector the customer belongs to. Valid options have to be set up by JHC in advance. | ||
SEGMENT | Military | The market segment the customer operates within. Valid options have to be set up by JHC personnel in advance. | ||
SEMAIL | john.doe@msn.com | Email for the default shipping address for customer. Will be validated. | ||
SHCODE | SHC/100007 | Refers to special shipping and handling code for orders from this customer. Valid options have to be set up in SHC archive prior to the load. | ||
SHIPBYNO | 100036 | Preferred shipping method for sales orders. Will typically be a carrier's product. Numbers are references to SHP archive. | ||
SHIPCOMPLETEDOC | YES | Decides whether all items of an order should be shipped together. If set to YES, the items of an order should never be splitted into several shipments. If no value is provided, this is understood as NO. | ||
SHIPCOMPLETEITM | YES | Decides whether the whole quantity in an order item always should be shipped together. If set to YES, the order item should never be splitted into several shipments. If no value is provided, this is understood as NO. | ||
SHIPCONS | YES | Decides whether order items will be consolidated into shipping advices in automatic processes. If set to NO, each order will result in separate shipping advice. If set to YES, several orders will be consolidated in to one Shipping Advise. If no value is provided, this is understood as NO. | ||
SHIPDAY | 2 | D3 | Specifies which day orders will be shipped. Valid options are: V1-V5 = E.g V1 means Monday in the week before orders requested/confirmed date. W1-W5 = E.g W2 means Monday in the week the order is requested confirmed. D0-D9 = E.g D2 means two days before the order is requested/confirmed. If no value is provided, this is understood as D0. If the shippingday is based on requested or confirmed date is depending on set up in SHIPONCONF. | |
SHIPGROUPBY | YOURNO | Field to group by if the value YES is set in the SHIPCONS field. | ||
SHIPONCONF | YES | If set to YES, orders should be shipped to meet the confirmed date rather than requested. Is used in combination with SHIPDAY. If no value is provided, this is understood as NO. | ||
SHIPPINGADVICEBLOCKED | YES | Shipping advices for this customer will be blocked for registering. | ||
SHIPSORTBY | PART | Field to sort by if the value YES is set in the SHIPCONS field. | ||
SHIPSUBFGT | YES | Decides whether freight should be charged on sub-shipments or not. If no value is provided, this is understood as NO. | ||
SPHONE | 4752763390 | Phone for the default shipping address for customer. Can not contain any letters or spaces, but + is OK as prefix. Must be four digits or more. | ||
ST | Y | 1 | 4 | Status of the customer. 1:New, 2:Pending internal approvement, 4:Active, 9:Obsolete. Defaults to 2 if not provided. |
STATE | Y* | CA | * Required if country (CCODE) is Canada or USA. | |
VATNO | DK669248438 | Value Added Tax (VAT) registration number. Unique number assigned by the relevant tax authority. This format is different from country to country. |