CreditNote

The data format CreditNote is used to export credit notes, e.g. for statistical purposes. Create and export the data format in the Data » Dynamic export menu. The Exporting data page of the manual describes how you export the data format.

Pay close attention to the exact spelling of the data fields. The data cannot be processed if the data fields are spelled incorrectly.

1. Overview of the data fields

Table 1 explains the data fields for the CreditNote data format in alphabetical order as well as filter options that you set in the Filter tab of the data format.

Field name	Explanation	Filter
CreditNoteCurrency	Currency of the credit note
CreditNoteID	The credit note’s order ID
CreditNoteMarking	Credit note flag (0-6)
CreditNoteNumber	Number of the credit note
CreditNoteStatus	Status of the credit note
CreditNoteTimeStamp	Date of creating the credit note	Activate the filter and select the operator and date. Use the operator Period to select a range of dates.
CustomerAdditionalName	Additions to the customer’s name
CustomerCity	The customer’s town
CustomerCompany	The customer’s company
CustomerCountryID	The customer’s country. The ID needs to be imported here. The country IDs are found under: System » Orders » Shipping » Settings » Tab: Countries of delivery
CustomerEmail	The customer’s email address
CustomerFax	The customer’s fax number
CustomerFirstname	The customer’s first name
CustomerGroup	Customer group	Activate the filter, select the operator and enter the value.
CustomerHouseNo	The customer’s house number
CustomerID	Customer ID
CustomerLang	The customer’s language
CustomerLastName	The customer’s surname
CustomerMobile	The customer’s mobile phone number
CustomerPhone	The customer’s telephone number
CustomerSalutationID	Form of address 0 = Mr 1 = Ms 2 = Company
CustomerStreet	The customer’s street
CustomerZIP	The customer’s postcode
ExternalOrderID	External order ID, e.g. from an external market
LastUpdateTimestamp	The date of the last change
OwnerID	ID of the owner of the order
ParentOrderID	ID of the higher-ranking order, original order ID
StoreID	Online store ID
TotalGross	Gross order total
TotalNet	Net order total
TotalVAT	VAT

Field name

Explanation

Filter

CreditNoteCurrency

Currency of the credit note

CreditNoteID

The credit note’s order ID

CreditNoteMarking

Credit note flag (0-6)

CreditNoteNumber

Number of the credit note

CreditNoteStatus

Status of the credit note

CreditNoteTimeStamp

Date of creating the credit note

Activate the filter and select the operator and date.
Use the operator Period to select a range of dates.

CustomerAdditionalName

Additions to the customer’s name

CustomerCity

The customer’s town

CustomerCompany

The customer’s company

CustomerCountryID

The customer’s country. The ID needs to be imported here.
The country IDs are found under: System » Orders » Shipping » Settings » Tab: Countries of delivery

CustomerEmail

The customer’s email address

CustomerFax

The customer’s fax number

CustomerFirstname

The customer’s first name

CustomerGroup

Customer group

Activate the filter, select the operator and enter the value.

CustomerHouseNo

The customer’s house number

CustomerID

Customer ID

CustomerLang

The customer’s language

CustomerLastName

The customer’s surname

CustomerMobile

The customer’s mobile phone number

CustomerPhone

The customer’s telephone number

CustomerSalutationID

Form of address
0 = Mr
1 = Ms
2 = Company

CustomerStreet

The customer’s street

CustomerZIP

The customer’s postcode

ExternalOrderID

External order ID, e.g. from an external market

LastUpdateTimestamp

The date of the last change

OwnerID

ID of the owner of the order

ParentOrderID

ID of the higher-ranking order, original order ID

StoreID

Online store ID

TotalGross

Gross order total

TotalNet

Net order total

TotalVAT

VAT

Table 1: data fields of the data format CreditNote

2. Overview of the procedures

In the Procedures tab, select which procedures you want to be carried out during the data export. Activate the LastUpdateTimestamp procedure. Select the set the current date option from the drop-down list. A timestamp will be added to credit notes during the export, indicating when the items were last changed.