Historical Data Credit Note template field definitions
Follow
Heather
Updated : Created :
Use the Historical Data Credit Note template to upload historical data to Business Intelligence (BI) and Advanced Inventory Manager (AIM).
Points to note
- Only use if you processed credits for any of the Sales Orders imported on the Historical Data Sales Order template.
- Credits uploaded to Historical Data will not be linked to Sales Orders in Unleashed.
- Numeric fields should not have more than 4 decimal values.
|
Field |
Definition |
Size |
Type |
Mandatory field |
|
CreditNoteNumber |
Unique credit note number. |
20 |
PK - Alphanumeric |
Yes |
|
CreditDate |
Date the credit note was processed. (Oldest date = 2015-01-01) |
- |
yyyy-MM-dd |
Yes |
|
CreditType |
Option of 2 types, credit linked to a sales order should be type = “Credit”. If the credit is not linked to a Sales Order it should be type = “FreeCredit” |
20 |
Alphanumeric |
Yes |
|
OrderNumber |
Unique Sales Order number linked to this credit. |
20 |
FK - Alphanumeric |
Yes - only if credittype = “credit” |
|
InvoiceNumber |
Unique Sales Invoice number linked to this credit. |
21 |
FK - Alphanumeric |
Yes - only if credittype = “credit” |
|
CustomerCode |
The unique customer code (as created in Unleashed) who placed the order and who received the credit. |
500 |
Alphanumeric |
Yes |
|
CurrencyCode |
The default currency code linked to the Sales Order. It must be a valid currency code used in your Unleashed account, setup under: Settings - System - Currency Rates. |
3 |
Alphanumeric |
Yes |
|
ExchangeRate |
The exchange rate at the time of sale. Only needed to complete if the sale to the customer was done in a foreign currency. |
18 |
Numeric * |
Enter “1” if it is the same as the base currency. |
|
ChargeTotal |
Total charges linked to the Credit note, repeat the total on all line items if there is more than one credit line. (The format of this field should be plain numeric with no thousand separators or currencies eg. $1,000.00 should be entered as 1000.00.) |
18 |
Numeric * |
Leave blank if there were no additional charges. |
|
LineNumber |
Each product on the Credit Note represents a line number, starting from number 1 for the first product, 2 for the second, etc. |
18 |
Numeric |
Yes |
|
ProductCode |
The product code must match the product code as captured on the Sales Invoice / Sales Order. |
100 |
Alphanumeric |
Yes |
|
CreditQuantity |
The number of units credited |
18 |
Numeric * |
Yes |
|
UnitPrice |
The price per Unit credited. (The format of this field should be plain numeric with no thousand separators or currencies eg. $1,000.00 should be entered as 1000.00.) |
18 |
Numeric * |
Yes |
|
LineTotal |
Total credit processed. Excluding tax. (The format of this field should be plain numeric with no thousand separators or currencies eg. $10,000.00 should be entered as 10000.00.) |
18 |
Numeric * |
No |
|
LineCost |
Average landed cost price at the time of sale. (The format of this field should be plain numeric with no thousand separators or currencies eg. $1,000.00 should be entered as 1000.00.) |
18 |
Numeric * |
Yes |
|
ReturnToStock |
Indication if the product credited was returned to stock. Returned to stock options are: TRUE or FALSE |
- |
Boolean |
Yes: TRUE or FALSE |