Skip to main content

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

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.

To top