Her ser du en oversikt og forklaringer til alle importkolonnene. Eksempelfilen inneholder kun noen av disse kolonnene. Vil du legge til flere kolonner i importfilen?
Sørg for å legge dem inn med riktig overskrift (header) i hver kolonne. Kolonner på engelsk må også skrives på engelsk.
Obligatoriske felter står med uthevet skrift.
| Header | Norsk beskrivelse | Full name | Description |
| ORDER NO | Ordrenummer | Order number | |
| ORDER DATE | Ordredato | Order date | Format: YYYY-MM-DD |
| CUSTOMER NO | Kundenummer | Customer number | Customer information will be updated if the customer is registered. |
| CUSTOMER NAME | Kundenavn | Customer name | |
| ORGANIZATION NO | Organisasjons-nummer | Organization number | |
| CUSTOMER EMAIL | Kundens e-postadresse | Customer’s email address | Company preference: If this order is included in an invoice (see importInvoicesCSV), the invoice will be sent to the customer by email. |
| CUSTOMER PHONE | Kundens telefonnummer | Customer’s phone number | |
| CUSTOMER MOBILE | Kundens mobiltelefonnummer | Customer’s mobile phone number | |
| POSTAL ADDR - LINE 1 | Postadresse – linje 1 | Customer’s postal address – line 1 | |
| POSTAL ADDR - LINE 2 | Postadresse – linje 2 | Customer’s postal address – line 2 | |
| POSTAL ADDR - POSTAL NO | Postadresse – postnummer | Customer’s postal address – postal number | |
| POSTAL ADDR - CITY | Postadresse – poststed | Customer’s postal address - city | |
| POSTAL ADDR - COUNTRY | Postadresse – land | Customer’s postal address - country | |
| BUSINESS ADDR - LINE 1 | Forretningsadresse – linje 1 | Customer’s business address – line 1 | |
| BUSINESS ADDR - LINE 2 | Forretningsadresse – linje 2 | Customer’s business address – line 2 | |
| BUSINESS ADDR - POSTAL NO | Forretningsadresse – postnummer | Customer’s business address – postal number | |
| BUSINESS ADDR - CITY | Forretningsadresse – poststed | Customer’s business address - city | |
| BUSINESS ADDR - COUNTRY | Forretningsadresse – land | Customer’s business address - country | |
| CUSTOMER CAT 1 - NO | Kundekategori 1 – nummer | Customer category 1 - number | |
| CUSTOMER CAT 1 - NAME | Kundekategori 1 – navn | Customer category 1 - name | |
| CUSTOMER CAT 2 - NO | Kundekategori 2 – nummer | Customer category 2 - number | |
| CUSTOMER CAT 2 - NAME | Kundekategori 2 – navn | Customer category 2 - name | |
| CUSTOMER CAT 3 - NO | Kundekategori 3 – nummer | Customer category 3 - number | |
| CUSTOMER CAT 3 - NAME | Kundekategori 3 – navn | Customer category 3 - name | |
| CONTACT - FIRST NAME | Kontakt – fornavn | Customer contact’s first name | |
| CONTACT - LAST NAME | Kontakt – etternavn | Customer contact’s last name | |
| ATTN - FIRST NAME | Ved/attention – fornavn | Attention’s first name | |
| ATTN - LAST NAME | Ved/attention – etternavn | Attention’s last name | |
| REFERENCE NO | Referansenummer | Reference number | |
| DEPARTMENT NO | Avdelingsnummer | Department number | Refers to existing departments. |
| DEPARTMENT NAME | Avdelingsnavn | Department name | Refers to existing departments. |
| PROJECT NO | Prosjektnummer | Project number | The project will be created if it is not registered. |
| PROJECT NAME | Prosjektnavn | Project name | The project will be created if it is not registered. |
| COMMENTS | Kommentar | Comments | |
| CURRENCY | Valuta | Currency | |
| DELIVERY DATE | Leveransedato | Delivery date | |
| DELIVERY ADDR - LINE 1 | Leveransested – linje 1 | Delivery address – line 1 | |
| DELIVERY ADDR - LINE 2 | Leveransested – linje 2 | Delivery address – line 2 | |
| DELIVERY ADDR - POSTAL NO | Leveransested – postnummer | Delivery address – postal number | |
| DELIVERY ADDR - CITY | Leveransested – poststed | Delivery address - city | |
| DELIVERY ADDR - COUNTRY | Leveransested – land | Delivery address - country | |
| INVENTORY NO | Lagernummer | Inventory number | |
| INVENTORY NAME | Lagernavn | Inventory name | |
| RECURRING - START DATE | Repeterende faktura - første fakturaperiode starter her. | Recurring invoice - start date. | yyyy-MM-dd |
| RECURRING - INTERVAL | Repeterende faktura - antall måneder per faktura. | Recurring invoice - invoicing interval. | Number of months per invoice. |
| RECURRING - INVOICE DAY OF MONTH | Repeterende faktura - utsending av faktura. Hvilken dag i måneden skal fakturaen sendes ut. | Recurring invoice - Invoice sending. day of month for invoice sending. | 0-31. 31 means last day of month. |
| RECURRING - INVOICE OFFSET |
Repeterende faktura - utsending av faktura. Har du satt RECURRING - INVOICE DAY OF MONTH, betyr feltet antall måneder før/etter fakturadato. Har du ikke satt det, betyr feltet antall dager før/etter fakturadato.
|
Recurring invoice - Invoice sending. Month/day offset. If RECURRING - INVOICE DAY OF MONTH is set, then this field means months. If not, then this field means days. | Months when a day is fixed (max 12), days when it is not (max 365). |
| RECURRING - INVOICE OFFSET DIRECTION | Repeterende faktura - utsending av faktura. Forskudd eller etterskudd for første dag i fakturaperioden. | Recurring invoice - Invoice sending. Sending in advance or in arrears of the first day of the invoicing period. | Required even when the offset is 0. ADVANCE or ARREARS |
| RECURRING - END DATE | Repeterende faktura - Siste dag i siste fakturaperiode. Kan være tom hvis det ikke er noen sluttdato. | Recurring invoice - last day of the last invoicing period. | yyyy-MM-dd |
| RECURRING - ORDER LINE - START DATE | Repeterende faktura - startdato for en repeterende ordrelinje. Hvis denne er tom vil det bli en ordrelinje som kun sendes med neste faktura. | Recurring invoice - start date of a recurring order line. Empty means it will only be sent once with the next invoice. | yyyy-MM-dd |
| RECURRING - ORDER LINE - END DATE | Repeterende faktura - siste dag i en periode for en repeterende ordrelinje. Kan være tom. | Recurring invoice - end date of a recurring order line. Can be empty. | yyyy-MM-dd |
| RECURRING - ORDER LINE - EXCLUDED MONTHS | Repeterende faktura - månednummer: denne ordrelinjen skal ha unntak (januar er 1 osv.). Kan kun brukes på repeterende faktura med månedlig intervall. | Recurring invoice - the month-number(s) this order line should be excluded. Only available on recurring invoices with monthly interval. | E.g. "1,12" to exclude December and January |
| ORDER LINE - PROD NO | Ordrelinje – produktnummer | Order line – product number |
Refers to an existing product. If the product is not registered, the product will be created. Required for new products or if a description is not provided on existing products. |
| ORDER LINE - PROD NAME | Ordrelinje – produktnavn | Order line – product name | Required for new products. |
| ORDER LINE - DESCRIPTION | Ordrelinje – beskrivelse | Order line - description | Required if product number is not provided. |
| ORDER LINE - UNIT PRICE | Ordrelinje – enhetspris | Order line – unit price | |
| ORDER LINE - COUNT | Ordrelinje – antall | Order line - count | |
| ORDER LINE - DISCOUNT | Ordrelinje – rabatt | Order line - discount | |
| ORDER LINE - VAT CODE | Ordrelinje – mva-kode | Order line – system-defined VAT codes |
Read more about the system-defined VAT codes in the following article – VAT codes.
|