Her ser du en oversikt og forklaringer til alle importkolonnene. Eksempelfilen inneholder kun noen av disse kolonnene. Ønsker du å legge til flere kolonner i importfilen? Sørg for å legge inn riktig overskrift (header) på kolonnene.
Obligatoriske felt er markert med uthevet skrift.
Header |
Norsk beskrivelse |
Full name |
Description |
INVOICE NO |
Fakturanummer |
Invoice number |
|
INVOICE DATE |
Fakturadato |
Invoice date |
Format: YYYY-MM-DD |
DUE DATE |
Forfallsdato |
Invoice due date |
Format: YYYY-MM-DD |
KID |
KID-nummer |
KID number |
If not specified, the KID number will be created if an OCR agreement exists. |
PAYMENT TYPE |
Betalingsform |
Payment type (paid amount) |
Refers to an existing payment type. This field is mandatory if the paid amount is specified. To add payment type go to Invoice > Settings > Payment types and add a number to the column «Import ID». Specify the correct number in the import file. |
PAID AMOUNT |
Betalingsbeløp |
Paid amount |
Amount paid by customer |
ORDER NO |
Ordrenummer |
Order number |
|
ORDER DATE |
Ordredato |
Order date |
Format: YYYY-MM-DD |
CUSTOMER NO |
Kundenummer |
Customer number |
Customer information will be updated on registered customers. |
CUSTOMER NAME |
Kundenavn |
Customer name |
|
ORGANIZATION NO |
Organisasjonsnummer |
Organization number |
|
CUSTOMER EMAIL |
Kundens e-postadresse |
Customer’s email address |
Company preference: If this order is included in an invoice, then the invoice will be sent to the customer by email. |
CUSTOMER PHONE |
Kundens telefonnummer |
Customer’s phone number |
|
CUSTOMER MOBILE |
Kundens mobiltelefonummer |
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 – fornavn |
Customer contact’s first 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 |
|
DEPARTMENT NAME |
Avdelingsnavn |
Department name |
|
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 |
Leveringsdato |
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 |
|
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. This is required if a description is not provided. |
ORDER LINE - PROD NAME |
Ordrelinje – produktnavn |
Order line – product name |
|
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 |
Percentage |
ORDER LINE - VAT CODE |
Ordrelinje – mva-kode |
Order line – system defined VAT code |
Read more about the system-defined VAT codes in the following article – VAT codes |