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. |
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. |
|
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 |
|
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.